ops-master:/usr/local/nagios/var/ndologs# ps -ef |grep ndo nagios 2764 1 0 Jun16 ? 00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios 2765 1 0 Jun16 ? 00:00:01 import_ndologsd ops-master:/usr/local/nagios/var/ndologs# ls -l total 0 This is new: (syslog from db server) Jun 17 08:13:38 ost-db mysqld[2342]: Version: '5.0.32-Debian_7etch10' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2390]: Upgrading MySQL tables if necessary. Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2395]: Can't find data directory. Please restart with --datadir=path-to-writable-data-dir Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2400]: Checking for crashed MySQL tables. Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2477]: WARNING: mysqlcheck has found corrupt tables Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2477]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2477]: Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2477]: Improperly closed tables are also reported if clients are accessing Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2477]: the tables *now*. A list of current connections is below. Jun 17 08:13:38 ost-db /etc/mysql/debian-start[2477]: From: [email protected] [mailto:[email protected]] On Behalf Of Duncan Ferguson Sent: Thursday, June 17, 2010 4:55 AM To: Opsview Users Subject: Re: [opsview-users] status page not showing correct results On 16 Jun 2010, at 18:37, Craig Sterley wrote: This morning the status page on our master Opsview server stopped updating with current information. Our internet line went down in the early am, causing several items to go down, and it hasn't updated since. I tried restarting services on both the master server, slave server, and db server - also to the point of rebooting them. Not finding anything in the log anywhere. Found a link in my email archive in regards to running the following to check the last update on the runtime db: mysql -uopsview -p --batch -e "SELECT status_update_time,is_currently_running,last_command_check FROM runtime.nagios_programstatus" status_update_time is_currently_running last_command_check 2010-06-16 16:28:58 0 2010-06-16 16:28:58 The last update is current. The checks are reporting via email as they should be, but nothing is updated on the status page. I can manually log into the slave server and run the command against the host and it comes back with the results expected. Checked the Opsview-web log and it just shows normal login/logout information. The nagios.log is showing normal activity. The db server has tons of space available. Kind of at a loss of where to go next. We are currently running 3.5.2 on Debian Etch and have been for several months with no issues. Any ideas would be greatly appreciated. The status pages are generated from the runtime database - the runtime database is updated by import_ndologsd pulling files from /usr/local/nagios/var/ndologs and it sounds like this update isn't happening. Is that process running? How many files are in that directory? Any errors in system logs about MySQ? 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: [email protected] Skype: tom.callway Web: www.opsview.com <http://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.
<<image001.png>>
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
