THIS KNOWLEDGE BASE HAS BEEN ARCHIVED AND IS NO LONGER BEING UPDATED
Please visit library.nagios.com/docs for the latest and most up-to-date documentation.
Home » Categories » Multiple Categories

XI 5.10.0 and newer Postgress to MySQL Conversion

The Nagios XI default database changed from PostgreSQL to MySQL, since the initial release of XI 5.  If you see a notice after upgrading XI on your server to version 5.10.0, or later, to convert your PostgreSQL database to MySQL, it means you are still on PostgreSQL (maybe due to original installation being pre - XI 5).


The following process will guide you through a successful migration of the PostgreSQL database to the MYSQL database. Please note to only run this script on your XI 5.10.x or XI 5.11.x installation. Please make sure you have upgraded to one of those versions first, before proceeding.
 

Make sure to back up your XI instance first, using this document: https://assets.nagios.com/downloads/nagiosxi/docs/Backing-Up-And-Restoring-Nagios-XI.pdf
 

Open a root ssh session to the Nagios server and look in the /etc/my.cnf file or the /etc/my.cnf.d/mysql-server.cnf file (your server will have one or the other) for the following option:

max_allowed_packet=256M

If it is not defined, then under this section

[mysqld]
Add this
max_allowed_packet=256M

Save the change and run this command to restart the MYSQL or MariaDB database.

systemctl restart mariadb || systemctl restart mysqld

Change the directory:

cd /usr/local/nagiosxi/scripts/pg2mysql/


Run this to download the conversion script.
wget https://assets.nagios.com/downloads/support/convert_mod.zip

Unzip the downloaded file by running this command:
unzip convert_mod.zip

Then run the following command to convert the nagiosxi database from PostgreSQL to MYSQL and setup the server to point to the database in MYSQL.

In the command to perform the conversion, it uses nagiosxi as the root password for the mysql database, if it was changed on your server, use your password instead of this example.

Run this command to set the script executable.
chmod a+x convert_mod.php


Then run this command to perform the conversion.

./convert_mod.php localhost root nagiosxi

After the script has finished, you can log back in to the XI interface and make sure everything is working correctly.



Special Offer For Knowledgebase Visitors! Get a huge discount on Nagios Log Server by clicking below.

Get 60% Off Nagios Log Server!

Did you know? Nagios provides complete monitoring of: Windows, Linux, UNIX, Servers, Websites, SNMP, DHCP, DNS, Email, Storage, Files, Apache, IIS, EC2, and more!

1.67 (3)
Article Rating (3 Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Nagios XI - SNMP Trap v3 Configuration
Viewed 39900 times since Tue, Nov 13, 2018
Nagios XI - BPI XML Cache
Viewed 7414 times since Thu, Mar 9, 2017
Nagios Core - SNMP Explained - NWC15
Viewed 17918 times since Mon, Feb 8, 2016
Nagios XI - Removing All Historical Data
Viewed 11756 times since Thu, Apr 12, 2018
Nagios XI - Integrating On-Call Schedules with Nagios - NWC13
Viewed 8321 times since Tue, Feb 9, 2016
Managing Contact Templates
Viewed 6906 times since Mon, Jun 28, 2021
Nagios XI - Disabling Database UTF8 Connectivity
Viewed 7254 times since Thu, Mar 8, 2018
Nagios Core - Understanding retention.dat and modified_attributes
Viewed 20015 times since Fri, Jul 15, 2016
Nagios XI - Checking System Status
Viewed 9706 times since Wed, Jul 19, 2017
Resizing The VM Disk Size For CentOS 7
Viewed 75698 times since Tue, May 8, 2018