Nagios XI database connection error after password change
Posted: Wed Nov 16, 2016 3:56 am
Good morning,
Nagios XI stopped working after we followed the instructions we received begin this month in the mail 'Nagios XI security advisory'. The mail advised users of Nagios to change the default passwords on their systems. As our systems were installed by our supplier we figured we'd check and change the passwords if found necessary.
PDF with instructions: https://assets.nagios.com/downloads/nag ... ios-XI.pdf
We noticed that the NDOUTILS account was using the default n@gweb password and changed that into something new. Exact commands we used:
mysql -u root -p
use mysql;
set password for 'ndoutils'@localhost= password('PASSWORD');
quit;
systemctl restart ndo2db
Then we changed the passwords in the following files:
/usr/local/nagios/etc/ndo2db.cfg
/usr/local/nagiosxi/html/config.inc.php
/usr/local/nagvis/etc/nagvis.ini.php
But we just get the error messages below. We changed the password back into the default password but it still won't work. We restarted all Nagios related services but no luck.
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.
Run the following from the CLI as root to attempt to repair the DB
/usr/local/nagiosxi/scripts/repair_databases.sh
What can I do? The repair script won't work.
Kind regards,
Dennis Lans
Nagios XI stopped working after we followed the instructions we received begin this month in the mail 'Nagios XI security advisory'. The mail advised users of Nagios to change the default passwords on their systems. As our systems were installed by our supplier we figured we'd check and change the passwords if found necessary.
PDF with instructions: https://assets.nagios.com/downloads/nag ... ios-XI.pdf
We noticed that the NDOUTILS account was using the default n@gweb password and changed that into something new. Exact commands we used:
mysql -u root -p
use mysql;
set password for 'ndoutils'@localhost= password('PASSWORD');
quit;
systemctl restart ndo2db
Then we changed the passwords in the following files:
/usr/local/nagios/etc/ndo2db.cfg
/usr/local/nagiosxi/html/config.inc.php
/usr/local/nagvis/etc/nagvis.ini.php
But we just get the error messages below. We changed the password back into the default password but it still won't work. We restarted all Nagios related services but no luck.
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.
Run the following from the CLI as root to attempt to repair the DB
/usr/local/nagiosxi/scripts/repair_databases.sh
What can I do? The repair script won't work.
Kind regards,
Dennis Lans