XI Upgrade failure using RDS

[daveinvb]

Does the UI upgrade use a default password for MySQL? I'm using AWS RDS and I am receiving the error "Error backing up MySQL database 'nagiosql' - check the password in this script!". It's really poor practice to use default passwords in RDS, so is there somewhere I can set that in Nagios so the script will run?

[daveinvb]

Code: Select all

---- Starting Nagios XI Backup ----
No entry for terminal type "unknown";
using dumb terminal settings.
Backing up Core Config Manager (NagiosQL)...
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 2005: "Unknown MySQL server host 'nagiosql.*********.us-east-1.rds.amazonaws.com:3306' (0)" when trying to connect
Error backing up MySQL database 'nagiosql' - check the password in this script!

Will I also run into the same error running the manual process listed here? https://assets.nagios.com/downloads/nag ... ctions.pdf

[ssax]

You shouldn't run into an issue if you run the manual upgrade but that's because the manual upgrade doesn't take a backup first.

Run a manual backup and see if that allows it to complete and let us know so we can dig further.

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

[daveinvb]

The manual upgrade failed as well.

Code: Select all

kernel.shmall = 268435456
kernel.msgmni = 256000
Removing depricated failure_prediction_enabled from NagiosQL
ERROR 2005 (HY000): Unknown MySQL server host 'nagiosql.**********.us-east-1.rds.amazonaws.com:3306' (0)

[Box293]

Can you go to Admin > System Config > Manage System Config

What is in your "Program URL" and "External URL" fields?

Does you Program URL resolve to an internal IP address?

[daveinvb]

The Program URL is our internal AWS address and External URL is blank.

[rkennedy]

From your XI machine, can you run the following and post the output -

Code: Select all

nslookup nagiosql.*********.us-east-1.rds.amazonaws.com

Replace the ******* accordingly to match the exact hostname that sql is looking for.

Also, please post the output of -

Code: Select all

cat /etc/hosts