MySQL supported versions in NagiosXI 2014

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
akepley
Posts: 138
Joined: Wed Sep 11, 2013 1:09 pm

MySQL supported versions in NagiosXI 2014

Post by akepley »

We are currently on 5.2.3 and the DBA has asked what versions of MySQL are supported. We are currently running mysql-server-5.5.45-1

Thanks!
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: MySQL supported versions in NagiosXI 2014

Post by rkennedy »

The title of this thread mentions XI2014, but you mention 5.2.3 - was this an upgrade from 2014? This version may be running Postgres still, could you please run cat /usr/local/nagiosxi/html/config.inc.php | grep dbtype on the machine and post back the result?

There should not be any problems with any version of SQL, as long as PHP supports it and functions weren't deprecated.
Former Nagios Employee
akepley
Posts: 138
Joined: Wed Sep 11, 2013 1:09 pm

Re: MySQL supported versions in NagiosXI 2014

Post by akepley »

Sorry for the delayed reply.

Here are the results:

Code: Select all

$cfg['dbtype']=''; // this setting is no longer used - use settings below
                "dbtype" => 'pgsql',
                "dbtype" => 'mysql',
                "dbtype" => 'mysql',
//require_once(dirname(__FILE__).'/db/'.$cfg['dbtype'].'.inc.php');
akepley
Posts: 138
Joined: Wed Sep 11, 2013 1:09 pm

Re: MySQL supported versions in NagiosXI 2014

Post by akepley »

Also on Nagiosxi version, sorry about the 2014 version in the title. Disregard. Listing updates it says "Your installation of Nagios XI 5.2.3"
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: MySQL supported versions in NagiosXI 2014

Post by rkennedy »

Since you upgraded from a previous version, your system is also utilizing Postgres as indicated by "dbtype" => 'pgsql',. This shouldn't have any affect on upgrading mysql, but just wanted to make you aware.
Former Nagios Employee
Locked