Re: [opsview-users] FROM monitoringservers me

[Ton Voon]

On 16 May 2011, at 01:02, Doug Small wrote: i'm importing a opsview database dump to a new server but i cannot get past the following error: # /usr/local/nagios/bin/rc.opsview gen_config Opsview::Monitoringserver can't SELECT me.id, me.name, me.role, me.host, me.activated, me.passive, me.uncommitted FROM   monitoringservers me WHERE  me.role = ?  ORDER BY role : DBD::mysql::st execute failed: Unknown column 'me.passive' in 'field list' [for Statement "SELECT me.id, me.name, me.role, me.host, me.activated, me.passive, me.uncommitted FROM   monitoringservers me WHERE  me.role = ?  ORDER BY role " with ParamValues: 0='Master'] at /usr/local/nagios/perl/lib/DBIx/ContextualFetch.pm line 52.  at /usr/local/nagios/bin/create_and_send_configs line 90 Failed to generate configuration - see /admin/reload for errors has anyone seen this before? can i drop the column me.passive?? Take a look at http://docs.opsview.com/doku.php?id=opsview-community#common_tasks where there is a "Migrating Opsview to different hardware", which is what you are doing. My guess is that your backup DB is not the same level as the new server, so you need to upgrade the database schema: http://docs.opsview.com/doku.php?id=opsview-community:migratinghardware#migrate_databases Ton Ton Voon Product Architect Global Headquarters: Unit 69 Suttons Business Park | Reading | Berkshire | RG6 1AZ | UK UK:      +44 (0) 845 057 7887 USA:     +1 866 879 9184 Email:    ton.v...@opsview.com Skype:   tonvoon Web:     www.opsview.com This e-mail is confidential, intended only for the named recipient(s) above and may contain information that is privileged and confidential. If you receive this message in error, or are not the named recipient(s), please notify the sender at the phone number above, do not copy this message, do not disclose its contents to anyone, and delete this e-mail message from your computer. Although we routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Opsera makes no representation or warranty as to the absence of viruses in this e-mail or any attachments.

_______________________________________________
Opsview-users mailing list
Opsview-users@lists.opsview.org
http://lists.opsview.org/lists/listinfo/opsview-users