Hi Looks as though something really weird has happened during the 3.7.0-3.7.1 upgrade around the mysql instance on my server (150 hosts, 1250 services).
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. Any help you could provide would be great. Thanks Evan
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
