NdoUtils stop working

[algomas123]

Attached!

thanks for your help.

[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

Code: Select all

instance_name=default

to

Code: Select all

instance_name=localhost

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.

[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.

[algomas123]

now it is failing again...I think event faster than with tcp socket....

[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?

[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?

[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...

[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.

[algomas123]

Hello,

I tried to repair database first of all as I readed that somewhere as possible solution...but It didn't help.

[tgriep]

Try enabling debugging in the nagios.cfg file and see if there any errors on the nagios.log file that could help out.