Page 3 of 3
Re: NdoUtils stop working
Posted: Tue Jul 05, 2016 3:16 pm
by algomas123
Attached!
thanks for your help.
Re: NdoUtils stop working
Posted: Tue Jul 05, 2016 4:24 pm
by tgriep
The nagios.cfg file looks good but you may want to edit the ndomod.cfg file to fix a few settings.
Change this line from
to
Change the output type to unix socket by commenting out these lines
Code: Select all
output_type=tcpsocket
output=127.0.0.1
Then un-comment these 2 lines
Code: Select all
output_type=unixsocket
output=/usr/local/nagios/var/ndo.sock
Save the file and restart nagios and check and see if the data is stored in MYSQL now.
Re: NdoUtils stop working
Posted: Wed Jul 06, 2016 3:30 am
by algomas123
Ok, I have set up both of your suggestions. (also changed ndo2db to unix socket...obviously). I will let you know something in some hours (it used to fail after 10-12 hours)...
Anyway, It was running like this previously and it was failing in the same way...
As I said in my first post...Nagios was running without problem for months...and when I installed nagiosql, after one week...started to fail!! maybe this helps you.
Re: NdoUtils stop working
Posted: Wed Jul 06, 2016 8:11 am
by algomas123
now it is failing again...I think event faster than with tcp socket....
Re: NdoUtils stop working
Posted: Wed Jul 06, 2016 9:58 am
by algomas123
It is getting worst
, now it is failing more frequently...
I am not sure, but I think this is a clue...first error in log, coming from pop_from_queue in queue.c is always:
Identifier removed...who removed my queue???
is it possible to know?
Re: NdoUtils stop working
Posted: Wed Jul 06, 2016 10:05 am
by tgriep
The problem is that it is hard to find any information on the Nagiosql settings as the project doesn't seem to be supported anymore.
It could be that Nagiosql is locking the MYSQL database which prevents ndoutils from writing to the database.
You may want to check the settings for Nagiosql and the MYSQL database and see if there are anything tweaks you can do.
It could be permission problems with the Apache settings, PHP settings, etc...
Does the failure coincide when someone is using Nagiosql?
Re: NdoUtils stop working
Posted: Wed Jul 06, 2016 10:49 am
by algomas123
It does not coincide with anyone using nagiosql, at fact, most of times are during night:...but problem appeared more or less 2 days after installing it...so make sense what you say...
Anyway...nagiosql and nagios are using differents db (but in same server), with differents users, who has not adqin privileges and can't interact with other tables...
I will keep investigating...
Re: NdoUtils stop working
Posted: Wed Jul 06, 2016 1:44 pm
by tgriep
If you upgraded the MYSQL server or any thing else while installing Nagiosql, that could help out on where to look on this issue.
Maybe it is a corrupt mysql database. Try running a repair and see if that helps.
Re: NdoUtils stop working
Posted: Thu Jul 07, 2016 4:14 am
by algomas123
Hello,
I tried to repair database first of all as I readed that somewhere as possible solution...but It didn't help.
Re: NdoUtils stop working
Posted: Thu Jul 07, 2016 11:58 am
by tgriep
Try enabling debugging in the nagios.cfg file and see if there any errors on the nagios.log file that could help out.