Trouble backing up Nagios XI 2012R2.8c

[benningtonr]

I have updated my nagios many times in the last three years. I have always had to go in and change the password in the script for the mysql portion. But now following the backup directions, as I always do, there is no line to change the password as before. Please advise,
Thank you

[benningtonr]

I figured this would be a quick and easy answer.

[tmcdonald]

Our office hours are from 9:00AM to 5:00PM Central. Anything posted before 9:00AM probably will not be seen or replied to until after then.

The config settings are now located in /usr/local/nagiosxi/html/config.inc.php and are stored in a PHP array.

[benningtonr]

My apologies, thank you for the info

[benningtonr]

okay, i changed the password here and still get the same error.

// db-specific connection information
$cfg['db_info']=array(
"nagiosxi" => array(
"dbtype" => 'pgsql',
"dbserver" => 'localhost',
"user" => 'nagiosxi',
"pwd" => 'MYNEWPASSWORD',
"db" => 'nagiosxi',


[root@nagios ~]# /usr/local/nagiosxi/scripts/backup_xi.sh
Could not open input file: import_xiconfig.php
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/share/perfdata/Rivendell_Server: file changed as we read it
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 MySQL databases...
Error backing up MySQL database 'nagios' - check the password in this script!


Again sorry for the lack of patients, didn't even think about operating hours

[tmcdonald]

That specific error was addressed recently in this thread: http://support.nagios.com/forum/viewtop ... 16&t=25273

The script swilkerson posted should work on 2.8+. If not I would work through the troubleshooting steps in that thread and verify a db connection from the command line.

[benningtonr]

Worked like a champ, you guys are the best, thank you.
On to upgrading tom 2014 now, Fingers crossed