Migration Steps

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

1. 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 

2. In Oracle Linux VA run the below script:

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

3. 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 

4. 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 

5. 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

6. Start services using the below commands:

    systemctl start sgdaemon.service
    systemctl start scandaemon.service
    systemctl start haproxy.service

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

    DROP USER 'mig_admin'@'%';
    FLUSH PRIVILEGES;

8. Run server configuration and DB configuration from wizard.