Page 1 of 1

MySQL supported versions in NagiosXI 2014

Posted: Wed Jun 22, 2016 3:44 pm
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!

Re: MySQL supported versions in NagiosXI 2014

Posted: Wed Jun 22, 2016 4:21 pm
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.

Re: MySQL supported versions in NagiosXI 2014

Posted: Tue Jun 28, 2016 9:54 am
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');

Re: MySQL supported versions in NagiosXI 2014

Posted: Tue Jun 28, 2016 10:06 am
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"

Re: MySQL supported versions in NagiosXI 2014

Posted: Tue Jun 28, 2016 1:44 pm
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.