Nagios Support Forum

You need to make sure you set sql_mode="" once you install on MySQL 5.7 or MariaDB 10 otherwise things won't work properly:

https://support.nagios.com/kb/article/n ... n-822.html

Did you do that? Maybe that's why you are having issues?

If you're on EL7 the upgrade scripts/etc will be looking for mariadb-server (case sensitive) packages in yum and not MariaDB-Server or mysql-community packages which will likely interfere with upgrades.

I would stick to what the OS vendor has in their packaging system (mariadb-server 5.5.X) otherwise you're likely to have issues when running the XI upgrades. The offloaded version can be whatever you want but the XI server looks for certain packages on upgrades/install.

Hi Support Team,

The suggestion above didnt work.

He is the log file that i simulate at the lab environment. The upgrade stop at the same place as in production server. Step to produce:
Install XI 5.4 > Offload nagiosql and nagiosxi to the remotedb > update the config as per the documentation > upgrade the nagios XI.

I think the upgrade script cannot work with dbs separated in two different database server(either all dbs@local or all dbs@remote) I dont know.

Anyhow we manage to load back the two remote database back to local server and upgrade successful.

Thanks for your support.

Thank you for providing that info! I'm glad you were able to get it upgraded.

I think technically it should work but I haven't personally tested that scenario.