you are absolutely right. i was transferring between hardware, but i was also throwing in a version upgrade. i down rev'd the opsview install on the new target system and all ran fine.
thanks for the response. doug On Mon, May 16, 2011 at 5:41 AM, Ton Voon <[email protected]> wrote: > > 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: [email protected] > 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 > [email protected] > http://lists.opsview.org/lists/listinfo/opsview-users > >
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
