Nagios XI 5 - MySQL Version

[maxiz1987]

Hi All,

I have a question that I wanted to ask - Which is the version of MySQL in Nagios XI 5?

Because I have ran the following query and I got:


mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.73 |
+-----------+


Is the version 5.1 ? This version is really old and deprecated and I am not sure if this is correct.

Can anyone help me with this?

Regards,

[Box293]

It's whatever version your OS repository provides.

[mcapra]

My recent XI 5.2.9 install is using the same version:

Code: Select all

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.73    |
+-----------+

Strictly speaking, which MySQL version you can use is only limited by what your PHP environment supports (through mysqli or similar connectors).

[maxiz1987]

But do you know if I use MySQL 5.6 or 5.7 if it is supported by Nagios ?

I wanted to do an offload of the DB running the Nagios and the DB both on different RHEL 7 Machines.

[mcapra]

But do you know if I use MySQL 5.6 or 5.7 if it is supported by Nagios ?

Strictly speaking it's more an issue with your PHP environment than it is with Nagios. If you're running a clean XI system or deployed from the OVA, your installation should be able to handle MySQL 5.6 without issues. Just be sure to snapshot/backup prior to transitioning.

[maxiz1987]

Hi Guys - This thread could be closed.

Thanks for your assistance.

Regards,