Page 1 of 1
XI Upgrade failure using RDS
Posted: Mon Nov 30, 2015 1:45 pm
by 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?
Re: XI Upgrade failure using RDS
Posted: Mon Nov 30, 2015 3:35 pm
by 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
Re: XI Upgrade failure using RDS
Posted: Mon Nov 30, 2015 5:00 pm
by 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
Re: XI Upgrade failure using RDS
Posted: Mon Nov 30, 2015 5:52 pm
by 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)
Re: XI Upgrade failure using RDS
Posted: Mon Nov 30, 2015 7:11 pm
by 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?
Re: XI Upgrade failure using RDS
Posted: Tue Dec 01, 2015 9:45 am
by daveinvb
The Program URL is our internal AWS address and External URL is blank.
Re: XI Upgrade failure using RDS
Posted: Tue Dec 01, 2015 4:41 pm
by 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 -