Page 1 of 1

Database Error

Posted: Fri Apr 28, 2017 4:27 pm
by jgreene
I get the following error after offloading the DB per https://assets.nagios.com/downloads/nag ... Server.pdf

Databse Error

A database connection error has been detected, please follow the repair prompt below. If the issue persists, 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


I then run "/usr/local/nagiosxi/scripts/repairmysql.sh Nagios" and get the following error:

mysqlcheck: Got error: 1045: Access denied for user 'ndoutils'@'xxx.xxx.xxx.xxx'

Re: Database Error

Posted: Mon May 01, 2017 9:02 am
by tgriep
Take a look at the following configuration files on the Nagios server and verify that the username, password and IP address for your off-loaded MYSQL database are updates with the correct information.

Code: Select all

/usr/local/nagiosxi/html/config.inc.php
/usr/local/nagios/etc/ndo2db.cfg
Also, you may want to go back through the manual and verify that the permissions were granted for the user accounts in the MYSQL database and that the firewall allows inbound traffic.

Re: Database Error

Posted: Tue May 02, 2017 4:21 pm
by tacolover101
in addition to what @tgriep mentioned, this document outlines where default credentials are stored, and as the error mentions it looks like you're getting denied. you might need to update it somewhere if it's not a problem on the SQL end.

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Re: Database Error

Posted: Tue May 02, 2017 4:28 pm
by dwhitfield
You may also want to post/PM the two files mentioned:

Code: Select all

/usr/local/nagiosxi/html/config.inc.php
/usr/local/nagios/etc/ndo2db.cfg
If you PM, you'll need to update the thread to bring the thread back up on our support dashboard.