Hi Ton, as usual you got it right man, dropping the table did complete the installation successfully. thank you. now as far as the history of this implementation I had this Opsview implementation started with 2.14.0 in mid 2008 and upgraded to 3.0.3.xxxx when it first came out. I then migrated to 3.0.4.2486 and that is when i got the error. Thanks again,
On 2009-06-08 07:15, Ton Voon wrote: > > On 5 Jun 2009, at 22:25, Nick Akl wrote: > > > Fri Jun 5 14:22:53 2009: Starting for runtime-opsview > > Fri Jun 5 14:22:53 2009: DB at version 3.0.0 > > Renaming hostgroups to opsview_hostgroups > > DBD::mysql::db do failed: Table 'opsview_hostgroups' already exists > > [for Statement "RENAME TABLE hostgroups TO opsview_hostgroups"] at / > > usr/local/nagios/installer/upgradedb_runtime.pl line 696. > > Fri Jun 5 14:22:53 2009: Finished for runtime-opsview > > What is the history of the runtime database on this server? Did you do > a migration of the runtime database from a different server? Did you > do a test upgrade and the restore the database? > > To fix, you can drop the table first (mysql> DROP TABLE > opsview_hostgroups) and rerun the installation. > > I'm just trying to work out why you had a problem, if it is widespread > and if we need to delete the table before we do the rename. > > Ton > > _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
