Connecting to the Inventory Management System SQL Interface

To connect to the Inventory Management System database using the MySQL client provided in the Junos Scope installation, type the following:

% <JTK_INSTALL>/mysql/bin/mysql \ - -socket=<JTK_INSTALL>/data/db/mysql.sock \ - -port=<DBPORT>\ - -host=<HOSTNAME>\ - -user=<DBUSER_IMS>\ - -password=<DBUSER_IMS_PASSWORD> $<DBNAME>

Where:

<JTK_INSTALL> is the path of the Junos Scope installation.
<DBPORT> is the port number of the database connection. The default port number is 3306.
<HOSTNAME> is the hostname of database server.
<DBUSER_IMS> is the database user for read-only access to the Inventory Management System. This is the username that the Junos Scope administrator provided during the installation process.
DBUSER_IMS_PASSWORD>< is the password for the Inventory Management System database user. This is the password that the Junos Scope administrator provided during the installation process.
<DBNAME> is the database name jtk for accessing the production Inventory Management System database, or demo for accessing the demonstration database.