Database Error

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

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

[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

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