Hi all, I am attempted to migrate one opsview-appliance database to another. I can get as far as upgrading the database and then restarting the server.
This is the error I get when attempted to upgrade the database with
Mon Nov 10 19:57:57 2014: Starting for opsview
Mon Nov 10 19:57:57 2014: DB at version 3.15.5
Shared notification profiles
DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails [for Statement "DROP TABLE IF EXISTS sharednotificationprofiles"] at /usr/local/nagios/installer/upgradedb_opsview.pl line 4470.
Mon Nov 10 19:57:57 2014: Finished for opsview
upgrade failed at /usr/local/nagios/installer/upgradedb.pl line 38.