It seems that the issue was with writing to /tmp and apparmor. This post was useful:
http://www.opsview.com/fr/node/777, post #5. Thanks! Adam On 10-11-12 11:58 AM, Ton Voon wrote: > > On 12 Nov 2010, at 13:33, Adam Tworkowski wrote: > >> /usr/local/nagios/bin/ndoutils_configdumpend = no difference. >> >> /var/log/opsview/opsviewd.log shows errors with tables related to >> viewports. For example, >> >> [2010/11/12 08:31:55] [ndoutils_configdumpend] [FATAL] DBD::mysql::db do >> failed: Can't create table '/tmp/#sql74a9_a73e1_1' (errno: -1) [for >> Statement "CREATE TEMPORARY TABLE opsview_viewports_temporary LIKE >> opsview_viewports"] >> [2010/11/12 08:31:55] [ndoutils_configdumpend] [FATAL] DBD::mysql::db do >> failed: Table 'runtime.opsview_viewports_temporary' doesn't exist [for >> Statement " >> INSERT INTO opsview_viewports_temporary > > You have a problem with mysql. If you run as mysql root user: > > CREATE TEMPORARY TABLE opsview_viewports_temporary LIKE opsview_viewports; > > This comes back with the errno: -1 error message. That needs to get > fixed before Opsview will be able to update the opsview_viewports table. > > Ton > > _______________________________________________ > 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
