Upgraded gateway from 9.1 to 9.2 - failed to start
We tried to upgrade it from ssgmenu but we got the below error.
Function SP_Change_master does not exist”
**** Unable to start the server: The version mismatch between the database (version 9.1.00) and Gateway (version 9.2.00) is too great.The database version must be within two major versions of the Gateway and cannot be lower.To resolve, either upgrade the database or the Gateway.
The function outlined sp_change_master is not a known stored procedure look in the /opt/SecureSpan/Gateway/config/etc/sql/ change files, or reviewing a standard build of our gateway.
Update of the SSG database failed because of custom stored procedures. Custom stored procedure need to be backup, deleted, then restored after ssg database is updated
All custom store and procedure need to be backed up, then deleted before you update the ssg database
Enter the following commands for each custom SP:
mysql> delete from mysql.proc where name='sp_change_master';
mysql> delete from mysql.proc where name='sp_drop_database';
To take backup of only Stored Procedures and Triggers (Exclude table and data ) use the following command.
# mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt ssg > ssg.sql
To restore stored procedures in the database simply use the following command, But make sure you have taken backup properly before restoring it to avoid any data loss.
# mysql -u root -p ssg < ssg.sql