Backup restoration gives error.

[dinush]

I have restored a backup taken from "Nagios XI 2014R2.7" to "nagiosxi-5.4.1" and got no error.

But it gives below message on the page and not working now.
---------------------
Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, 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
---------------------

Please assist to overcome the issue.

[avandemore]

If you refresh the page does the error remain? What is in /var/log/mariadb/mariadb.log? Did you follow the instructions in the message? If so, what were the results?

Please send over /usr/local/nagiosxi/html/config.inc.php as well.

[dinush]

there's no /var/log/mariadb/mariadb.log file.

config.inc.php file attached.


and now i'm thinking of trying to use upgrade package to do the upgrade from "Nagios XI 2014R2.7" to "nagiosxi-5.4.1"

[dinush]

is it possible to take a backup from "Nagios XI 2014R2.7" and restore to latest "nagiosxi-5.4.2".

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

NOTE 1: The version of the fresh install of Nagios XI that you are restoring to needs to match the version of Nagios XI that the backup
was taken from. For example:
Backup was created on Nagios XI 5.2.2
The server you are restoring to must have Nagios XI 5.2.2 installed on it
All versions of Nagios XI can be downloaded from the following page:
https://assets.nagios.com/downloads/nag ... rsions.php
After performing the restore you can then proceed to upgrade to the latest version available.


so that means, i have to do the upgrade 1st and then restore the backup?

[rkennedy]

When upgrading from 2014R2.7 - the chances are one of your databases is still running on postgres. In newer versions, we've streamlined mariadb / mysql for everything.

With that said, you'll need to install a new version of 2014R2.7, and then upgrade to the current XI version.

You should be fine upgrading to the current version once 2014R2.7 is installed, I don't think you need to go to 5.2.2 and then 5.4.x.

[tmcdonald]

Just checking in since we have not heard from you in a while. Did @rkennedy's post clear things up?