Issues Upgrading

[brianweeks222]

The update did not complete successfully. Please try updating manually.

---- Starting Nagios XI Backup ----
No entry for terminal type "unknown";
using dumb terminal settings.
Running configuration check...
Stopping nagios:. done.
Starting nagios: done.
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 Nagvis...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 130: Incorrect file format 'nagios_logentries' when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

[gsmith]

Hi there,


as root in a shell:

Code: Select all

mysql -u root -p nagios;
Enter password: xxxxxxx
repair table  'nagios_logentries'  use_frm;

That should take care of that table so it works during the mysqldump.

This message is indicating the default password for the nagios database was changed:
Error backing up MySQL database 'nagios' - check the password in this script!

The default password is nagiosxi. If it was changed you will have to change it in the script.
Remember there are 3 databases, so you should try to log in to each one from the command line
using the following so you can get the passwords figured out:

Code: Select all

mysql -u root -p nagios;
mysql -u root -p nagiosql;
mysql -u root -p nagiosxi;

By default all the passwords are nagiosxi

Thanks