Migration Steps

After successfully creating the admin migration user, follow the below migration steps:

To perform migration steps:

In Oracle Linux VA make the following files executable:

chmod a+rwx /usr/local/Secunia/csi/install/util/migratedb.sh

chmod a+rwx /usr/local/Secunia/csi/install/util/dumpPDB.php

In Oracle Linux VA run the below script:

/usr/local/Secunia/csi/install/util/migratedb.sh

After running the script, you can see a log folder get created at /usr/local/Secunia/csi/install/util/ with the migration successful message. If a log folder is not created then you need to verify the permission of dumpPDB.php, migratedb.sh files. Now run the below script:

/usr/local/Secunia/csi/install/util/migratedb.sh

Script will ask for the below details of source server (CentOS) and destination server (Oracle Linux):

Source IP

Source MySQL username

Source MySQL password

Destination IP

Destination MySQL username

Destination MySQL password

Run the below commands for permission and to copy the previously generated reports (pdf and csv):

•

On CentOS—Use the following command:

rsync -av /usr/local/Secunia/csi/reports/* root@<Oracle Linux IP>:/usr/local/Secunia/csi/reports/

•

On Oracle Linux—Use the following command:

chmod a+rw /usr/local/Secunia/csi/reports

Start services using the below commands:

systemctl start sgdaemon.service

systemctl start scandaemon.service

systemctl start haproxy.service

After migration, remove mysql user - 'mig_admin'@'%' from both the servers using the below commands:

DROP USER 'mig_admin'@'%';

FLUSH PRIVILEGES;

Run server configuration and DB configuration from wizard.