IBM 5.5 manual Configuring Netcool/Precision TN

Configuring Netcool/Precision TN

To configure Netcool/Precision TN to work with an existing copy of MySQL:

1.Change directory to <netcool_install_dir> configuration directory, for example:

/opt/netcool/etc/precisiontn

2.If you are running a default installation of MySQL on your local machine, you might not need to make any changes in this file. If you are not running a default installation, open the mysql_config.xml file with a text editor and update the following properties:

–Set the port property value to the number of the MySQL server port.

–Set the username and passwd property values to match the user account you want to use for this product software on the MySQL server.

–Set the host property value to the host name of the MySQL server you want to use.

–Set the dbname property value to the name of the database you want to use.

3.Save and close the file.

4.Change directory to <netcool_install_dir>/etc/precisiontn, open the precisiontn.xml file and locate the <application> section.

Within this section, find the following lines:

<!-- To use oracle set the value to 'oracle'. --> <variable name="db" value="oracle" />

5.Replace the oracle value with mysql. The modified lines are shown below.

<!-- To use oracle set the value to 'oracle'. --> <variable name="db" value="mysql" />

6.Save and close the precisiontn.xml file.

26 Netcool/Precision for Transmission Networks 5.5 Administration Guide