Search found 6 matches
- Wed May 03, 2017 10:22 am
- Forum: Open Source Nagios Projects
- Topic: Please help with this SQL error!!
- Replies: 10
- Views: 40984
Re: Please help with this SQL error!!
your hwclock , date , and grep date.timezone /etc/php.ini may not be in sync. Please post the output of those three commands. Ey! All seem in the right time :( was the first things that i checked [root@monitoring var]# hwclock Wed 03 May 2017 05:16:53 PM CEST -0.209484 seconds [root@monitoring var]...
- Wed May 03, 2017 10:18 am
- Forum: Open Source Nagios Projects
- Topic: Please help with this SQL error!!
- Replies: 10
- Views: 40984
Re: Please help with this SQL error!!
Hello all! I found a solution. Deduced that the problem was in timestamp of some _HOST_.rrd (I don't know why this happened) so i copied from another _HOST_.rrd working with the current timestamp and it works! Now graphics are writing in the replaced database. I dont know if is a good solution but i...
- Wed May 03, 2017 4:34 am
- Forum: Open Source Nagios Projects
- Topic: Please help with this SQL error!!
- Replies: 10
- Views: 40984
Re: Please help with this SQL error!!
Ok i will ask there. Anyway i discovered something: I found the perfdata log and it says this: [root@monitoring var]# tail -f perfdata.log 2017-05-03 10:56:10 [3442] [0] RRDs::update /usr/local/pnp4nagios/var/perfdata/****/_HOST_.rrd 1493801759:97.212997:0 2017-05-03 10:56:10 [3442] [0] RRDs::update...
- Tue May 02, 2017 3:54 am
- Forum: Open Source Nagios Projects
- Topic: Please help with this SQL error!!
- Replies: 10
- Views: 40984
Re: Please help with this SQL error!!
Hello! Good and bad news. I tried the solution that tgriep said with both commands and the error is not showing in the messages log anymore: [root@monitoring ~]# tail -f /var/log/messages May 2 10:33:54 monitoring systemd: Started Session 1 of user root. May 2 10:33:54 monitoring systemd: Starting S...
- Fri Apr 28, 2017 7:41 am
- Forum: Open Source Nagios Projects
- Topic: Please help with this SQL error!!
- Replies: 10
- Views: 40984
Re: Please help with this SQL error!!
Hello, Thanks for reply!! I changed the leverl 2, was configured in -1 (Everything), but i guess that will show the same. Ok, when i resolve the problem ill change to level 1. The output of the debug file: [1493377263.382377] [002.0] [pid=5635] SELECT instance_id FROM nagios_instances WHERE instance...
- Thu Apr 27, 2017 4:51 am
- Forum: Open Source Nagios Projects
- Topic: Please help with this SQL error!!
- Replies: 10
- Views: 40984
Please help with this SQL error!!
Hello, I need resolv this urgently. I have the following tools: CentOS Linux release 7.3.1611 (Core) nagios core Version 4.1.1 nagiosql version 3.2.0 mysql version 5.6.35 ndoutils version 2.0.1 p4p nagios (i dont know which version is) Some weeks ago, when I click an host in nagiosql this show me a ...