This article describes how to configure the Command Center to access new database server. Command Center must be reconfigured when the Database server location and the credentials are changed.

Instructions

To reconfigure the Command Center to access database server, complete the following procedure:

1. Stop Command Center.

2. Migrate the database to the new server according to the database product guidelines.

3. If you are using MySQL, then open the <CCHOME>/conf/database_params.conf file with a text editor and update the line containing “url jdbc:mysql://<OLDMYSQLSERVER>:3306/ccdb” to reflect the new server hostname IP address.

4. If you are using Microsoft SQL, then open the <CCHOME>/classes/hbnlib/hibernate.cfg.xml file with a text editor and edit the line containing “<property name="connection.url">jdbc:sqlserver://<OLDMSSQLSERVER>:1433;databaseName=<OLDDBNAME></property>” to reflect the new Microsoft SQL server and database name.

5. If the database username and password are changed, then run the following command to get the new encrypted password:
   E:\CC_5241\bin\admintools>EncryptPassword.bat root public mynewpassword.
   Note: The 'root' and 'public' are the Command Center logon credentials and 'mynewpassword' is the new password for database.

6. The encrypted password for "mynewpassword" is:
   ceMv9Me6gF5h6Cn1

7. Copy the new encrypted password into 'hibernate.cfg.xml' file.

8. Restart the Command Center service and verify if the new database server is being used.
   
   Note: These above mentioned steps for changing the "Password" will doesn't work in Command center version 5.2 and above, it only works in Command center version 5.1 or later version, The encryption password works differently in newer version and even after changing the password it will not reset the password.