Moving the Spectrum Data Source to a different One Click server

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

How to move the Performance Manager Spectrum Data Source Integration DB to a new One Click server.

Environment

Currently supported versions of DX NetOps components 

Resolution

The below steps are for a Spectrum environment with the following details:

MySQL User - 

 

Export Database from Existing System

Disable the Spectrum Data Source under – Administration / Data Sources in the Performance Center Portal 

 

 

Shut down the Tomcat server on the existing One Click Integration server

 

Export the netqos_integ database: 

( If you do not supply a password, you will be prompted to enter it. )

 

Linux 

Export: ./mysqldump --defaults-file=../my-spectrum.cnf --routines --databases -uSPEC_admin -p netqos_integ > netqos_integ_backup.sql

 

Windows 

Export: ./mysqldump.exe --routines --databases -uSPEC_admin -p  netqos_integ > netqos_integ_backup.sql

Copy the exported database to the new system.

 

Import Database to new system

 

On the New One Click Integration Server: 

 

Shut down the Tomcat server 

Import the netqos_integ database to the new system:

( If you do not supply a password, you will be prompted to enter it. ) 

 

If the Database already exists you will receive an error : 

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 1007 (HY000) at line 1: Can't create database ‘netqos_integ’; database exists

 

Linux 

 

Ensure DB exists: ./mysql  --defaults-file=../my-spectrum.cnf -uSPEC_admin -p -e 'create database netqos_integ;'

 

Import: ./mysql --defaults-file=../my-spectrum.cnf -uSPEC_admin -p  netqos_integ < netqos_integ_backup.sql

 

Windows 

 

Ensure DB exists: ./mysql  --defaults-file=../my-spectrum.cnf -uSPEC_admin -p -e 'create database netqos_integ;'

 

Import: ./mysql.exe -uSPEC_admin -p netqos_integ < netqos_integ_backup.sql

 

Start the Tomcat server on the new system

Change the  Spectrum Data Source hostname and port  to reflect the new server and enable the data source. 

 

 

Confirm Spectrum data source synchronization was successful and is Available 

Validate the Inventory->Data Sources->Spectrum->All Spectrum Global Collections reflects the GCs in OneClick.

Validate that Spectrum -> Performance Center Event Integration works, if enabled. 

 

Remove Database from original System

Once the proper functionality of the Integration has been validated the netqos_integ database should be removed from the original Integration One Click server. 

./mysql  --defaults-file=/opt/ca/spectrum/mysql/my-spectrum.cnf -uSPEC_admin -p0n3cl1Ck

 

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mibtools           |

| mysql              |

| netqos_integ       |

| performance_schema |

| reporting          |

| sys                |

+--------------------+

7 rows in set (0.16 sec)

mysql> drop database netqos_integ;

Start Tomcat Service