A database connection error has been detected after changing

[mdifiglia]

I followed the document https://assets.nagios.com/downloads/nag ... 1465481631 to change the default passwords and now I get the following error:

Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Passwords.JPG

[mdifiglia]

I ran the scripts below and the all successfully logged me into MySQL.

mysql -uroot -p<new password>
mysql -unagiosxi -p<new password>
mysql -undoutils -p<new password>
mysql -unagiosql -p<new password>

[rkennedy]

Hey Mike,

Can you PM over or email me the following files as well so we can scrub through to see how things are looking?

Code: Select all

/root/scripts/automysqlbackup
/usr/local/nagiosxi/scripts/restore_xi.sh
/usr/local/nagiosxi/var/xi-sys.cfg
/usr/local/nagios/etc/ndo2db.cfg
/usr/local/nagiosxi/html/config.inc.php
/usr/local/nagvis/etc/nagvis.ini.php
/var/www/html/nagiosql/config/settings.php
/usr/local/nagiosxi/scripts/restore_xi.sh 

[mdifiglia]

I emailed all 7 files as requested. I also restarted the ndo2db service as was suggested with no success.

[tgriep]

The passwords for the nagios database do not match between the config.inc.php and the ndo2db.cfg file.
One of them has an s in it and the other doesn't.
Fix that and that should work for you.

[mdifiglia]

I fat fingered it ; ) Thank you for the help!!! Everything is up and running now

[lmiltchev]

Great! I am locking this thread and marking it as "resolved".