|
|
The steps to set up the databases for various support platforms apply to both the Central Server and the Distributed Mediation Server, unless explicitly stated as Central Server or the Distributed Mediation Server. The RDBMS which are supported by Web NMS Distributed Setup are listed below:
MySQL
Oracle
Sybase
For version information, please refer to Installation Instructions.
MySQL is the default database bundled with Web NMS. Web NMS starts and initializes this database before starting the Web NMS modules. Therefore, in Windows and Solaris environments, the MySQL daemon is started when you invoke the Web NMS 'start script' "startnms.bat/sh", present under <Central Home/bin and "startdms.bat/sh" in <DMS Home> respectively.
In Linux, you need to start the MySQL daemon as a service before starting the Web NMS Server. To start MySQL daemon as a server in Linux, perform the following steps:
Log in as a super user.
Start MySQL. Syntax: $ /etc/rc.d/init.d/mysql start
If you have changed the default settings and later you want to use MySQL database, make the following changes:
If the Web NMS Server is already started, then do a proper shutdown of server. Do not terminate the process abruptly
Run reinitialize_nms.sh/bat from the <Central Home>/bin directory and reintialize_dms.sh/bat from the <DMS Home>/bin directory, to clean up the tables in the database in the respective servers.
Copy the database_params.conf and DatabaseSchema.conf files present in the <Central Home>/ conf/MySQL directory to the <Central Home>/conf directory. Similarly, the database_params.conf and DatabaseSchema.conf files present in the <DMS Home>/ conf/MySQL directory needs to be moved to the <DMS Home>/conf directory.
In database_params.conf file in the Central and Distributed Mediation Server, specify the machine name where the database is to run, user name, and password for the database.
Set the <Central Home>/mysql/driver/mysql_connector.jar as the DB_CLASSPATH value in the setEnv.bat/sh file under the <Central Home> directory. Similarly, in the Distributed Mediation Server, set <DMS Home>/mysql/driver/mysql_connector.jar in the DB_CLASSPATH variable in the setEnv.bat/sh file under the <DMS Home> directory.
Start the MySQL Server, by running the startMySQL.bat/sh file under the <Central Home>/bin or the <DMS Home>/bin directory respectively.
Start Web NMS Server.
Configuring MySQL Home
It is not mandatory to keep the MySQL directory (having the full MySQL installation) under the <Central Home> or <DMS Home> directory. The path for the MySQL files is configurable and hence the MySQL directory can be present anywhere. The path for the MySQL directory can be configured in the setEnv.bat/sh file present in <Central Home> or <DMS Home> directory respectively.
In the setEnv.sh/bat file, specify the full path of MySQL Home in the MYSQL_HOME parameter. For example,
MYSQL_HOME=C:\Central_Server\mysql
Configuration in Web NMS Launcher (For Central Server configuration only)
Say the Web NMS Launcher is used to start Web NMS. Then to configure MySQL, do the following:
In the <Central Home>/conf/launcher_conf.txt file, specify the MySQL Home, for reinitializing the database, as shown below:
<application>
<property name="AppName" value="Reinitialize Web NMS"/>
...............................
<property value="-Dmysql.home=./mysql" name="AppJavaOption"/>
</application>
In the same file, specify the MySQL Home, for starting the Web NMS server, as shown below:
<application>
<property name="AppName" value="Start Web NMS Server"/>
..................................
<property name="AppJavaOption" value="-Dmysql.home=./mysql -Dwebserver.port=9090 -D
..................................
</application>
Edit the DB_CLASSPATH variable (which is, by default, set to mysqldriver) in setEnv.bat file under the <Central Home> or the <DMS Home> directory, as applicable, to set the JDBC Driver for Oracle.
If the Web NMS Server is already started, shut down the server properly. Do not terminate the process abruptly.
Add the entry open_cursors=300 in the <ORACLE_HOME>/Database/init<database name>.ora file.
After changing the OPEN_CURSORS value, start the TnsListener Service and then the Oracle database.
|
|
Note: The TnsListener Service listens for and accepts the incoming connection requests from the client applications. |
Copy the DatabaseSchema.conf and database_params.conf from the <Central Home>/conf/Oracle directory to the <Central Home>/conf/ directory or from the <DMS Home>/conf/Oracle directory to the <DMS Home>/conf directory, as applicable.
Change the database_params.conf file with the oracle database name in the URL.
Check if the Oracle server is listening to the port 1521.
Start the Web NMS server.
|
|
Note: In Oracle, the number of open cursors supported for a single connection is set to 50 by default. It has to be changed to 250 for Web NMS to work with Oracle. |
Edit the DB_CLASSPATH variable (which is set to mysqldriver, by default) in the setEnv.bat file under the <Central Home> directory or the <DMS Home> directory, as applicable, to set the JDBC Driver for Sybase. An example entry in the setEnv.bat file for Sybase is given below:
set DB_CLASSPATH=<Web NMS Home>/conf/Sybase/jconn2.jar
Check whether the jconn.jar is placed in the appropriate location as per the path specified in the setEnv.bat file.
If the Web NMS Server is already started, then shut down the server properly. Do not terminate the process abruptly.
Copy the DatabaseSchema.conf file and the database_params.conf file from the <Central Home>/conf/Oracle directory to the <Central Home>/conf/ directory or from the <DMS Home>/conf/Oracle directory to the <DMS Home>/conf directory, as applicable.
Edit the database_params.conf file to change the drivername for Sybase database.
Edit the database_params.conf file to change the URL for Sybase, if the Sybase database is running in a remote machine and not in the localhost.
Check if the Sybase server is listening to the port 2048.
Start the Web NMS server.
To reinitialize the database connected to Central Server, invoke the reinitialize_nms.bat/sh script from the <Central Server>/bin directory or through the Reinitialize Web NMS icon in the Launcher.
To reinitialize the database connected to Distributed Mediation Server, invoke the reinitialize_dms.bat/sh script from the <DMS Home>/bin directory.
|
|
