Re: [opsview-users] Viewports gone after 3.7.1 upgrade

[Duncan Ferguson]

On 15 Jun 2010, at 02:01, Evan Anderson wrote: The upgrade proceeded without a hitch, however I had issues with both ODW and runtime databases immediately afterwards.  I managed to track down the issue to a "corrupted" my.cnf (lots of white space, missing entries etc), which I basically set back to all the defaults I could find, changed some opsview configuration passwords and got things running again (ODW importing OK etc). Since then, I haven't been able to see any Viewports.  All of the keywords are configured in the relevant hosts and services, and I was able to view them before all of this happened. I've noticed the following in the opsviewd.log though: [2010/06/10 18:05:26]  [ndoutils_configdumpend]  [FATAL]  DBD::mysql::db do failed: Table 'runtime.opsview_viewports_temporary' doesn't exist [for Statement " INSERT INTO opsview_viewports_tmp SELECT DISTINCT viewportid, keyword, hostname, servicename, host_object_id, service_object_id FROM opsview_viewports_temporary"] which more than likely has something to do with it. I've tried most of what I could think of, including backing up the file structure and databases and restoring them again. Run /usr/local/nagios/bin/db_mysql (you may need to provide username/password for mysql root user depending on your setup) and then run /usr/local/nagios/installer/upgradedb.pl so see if that comes up with anything.   Duncs --  Duncan Ferguson Senior Developer/Support Engineer Global Headquarters: Unit 69 Suttons Business Park | Reading | Berkshire | RG6 1AZ | UK UK:      +44 (0) 845 057 7887 USA:     +1 866 879 9184 Fax:       +44 (0) 1189 074 071 email:    tom.call...@opsview.com Skype:  tom.callway 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