How do I change the database user name and password in Security Reporting Center modules?

This article applies to:

• Security Reporting Center 2.0
• Security Reporting Center 2.1

Question:

Procedure:

To change the user name and password, please follow these directions for each module. (You must stop and restart each of the services for the changes to take effect.  This will also ensure that the new passwords are encrypted.)

• NetIQ Scheduler Agent

  1. Using any text editor, open the agent.conf file from the \modules\agent directory.

  2. Under the [ConfigDB] section, locate the entry for username and an entry for password.  

  3. Delete the existing encrypted user name and password from each of these entries.

  4. Type the new user name and password following the equal sign.

  5. Save and close the file.

  6. Stop and restart the NetIQ - Scheduler Agent service by clicking Start | Settings | Control Panel | Administrative Tools | Services.
  
  
  

• NetIQ LEA Service

  1. Using any text editor, open the lea_service.ini file from \modules\leaservice directory.

  2. Under the [LEA_Service] section, locate an entry for configDb_UserName and an entry for configDb_UserPassword. 

     Note: Do not change the configDb_DSN entry.

  3. Delete the existing encrypted user name and password from each of these entries.

  4. Type the new user name and password following the equal sign.

  5. Save and close the file.

  6. Stop and restart the NetIQ - LEA Service service by clicking Start | Settings | Control Panel | Administrative Tools | Services.
  
  
  

• NetIQ Syslog Service

  1. Using any text editor, open the syslog_service.ini file from the \modules\syslogservice directory.

  2. Under the [SYSLOG_Service] section locate an entry for configDb_UserName and an entry for configDb_UserPassword. 

     Note: Do not change the configDb_DSN entry.

  3. Delete the existing encrypted user name and password from each of these entries.

  4. Type the new user name and password following the equal sign.

  5. Save and close the file.

  6. Stop and restart the NetIQ - Syslog Service service by clicking Start | Settings | Control Panel | Administrative Tools | Services.
  
  
  

• User Interface

  1. Open the web.xml file from the \common\uiserver\WEB-INF directory.

  2. Find the <param-name> entry, WtSchedJdbcUsername.

  3. Change the encrypted <param-value> to the new user name.

  4. Find the <param-name> entry, WtSchedJdbcPassword.

  5. Change the encrypted <param-value> to the new password.

  6. Find the <param-name> entry, WtSchedJdbcEncrypted.

  7. Change the <param-value> to false.

  8. Save and close the file.

  9. Stop and restart the NetIQ - Tomcat service by clicking Start | Settings | Control Panel | Administrative Tools | Services.
  
  
  

Notes:

Changing the MySQL database user name and password is not done through Security Reporting Center.  Instead, this action should be done via MySQL.

A number of free GUI tools for MySQL administration are available. MySQL can also be administered from the command line.

The tool maintained by MySQL AB is available at the following URL: http://dev.mysql.com/downloads/gui-tools/

Note: SRC uses an older version of MySQL, so you may see a warning about version mismatch.

MySQL-Front, a well-known GUI tool, is no longer available.

This article was previously published as:

NETIQKB14395