Page 2 of 2

Re: Offloaded MySQL db - table not found

Posted: Thu Jun 14, 2012 9:49 am
by lmiltchev
Sounds good. Let us know if you have any issues with the new VM.

Re: Offloaded MySQL db - table not found

Posted: Thu Jun 14, 2012 9:34 pm
by prmmover
Ok, so after many more hours of fiddling, I figured out the problem, but I'm not sure I like the answer.

You apparently cannot change the username or password of the db user for the ndoutils on the remote DB side. For the nagios database, you need to keep the same ndoutils user/password credentials, it's not honoring the use of a different username/password combination on the remote server.

I tested with a new VM and clean databases, got the same error after I moved them to the remote db server, using a new username of "nagiosadm". Logged in, same problem.

Then I added an "ndoutils" user with default password into the remote database, restarted everything, and bingo, everything is working as it should, with the default local mysqld stopped and chkconfig'd off.

So, I would suggest that someone test this out on the nagios development end, and if this turns out to be the case, change the library document to reflect this.

-Gary

Re: Offloaded MySQL db - table not found

Posted: Fri Jun 15, 2012 7:30 am
by scottwilkerson
Sure you can, you need to modify the /usr/local/nagios/etc/ndo2db.cfg and restart the ndo2db service

Code: Select all

service ndo2db restart
service nagios restart