Nagios XI - MySQL 8 Compatibility

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
jmsanesteban.sgre
Posts: 51
Joined: Thu Apr 23, 2020 6:46 am

Nagios XI - MySQL 8 Compatibility

Post by jmsanesteban.sgre »

Hi all!

I manage a Nagios XI installation that uses MySQL 5.7 and we are planning to migrate it to a new environment with newer OS and MySQL versions.

I would like to know if Nagios XI is fully compatible with MySQL 8. Has any of you information about this? I tried to find official documentation, but I didn't have good luck.

Thanks in advance.

BR,
Juanma.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Nagios XI - MySQL 8 Compatibility

Post by benjaminsmith »

Hi Jaunma,

Nagios XI will support any MySQL version below 10.x. Also, please note that as of 5.7.5 STRICT_TRANS_TABLES mode is enabled by default. This should be disabled and we have a knowledgebase article on how to do this.

Nagios XI - STRICT_TRANS_TABLES

I hope that helps answer your question, let me know if you need help with anything else.

Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
jbrunkow
Posts: 441
Joined: Fri Mar 13, 2020 10:45 am

Re: Nagios XI - MySQL 8 Compatibility

Post by jbrunkow »

Yes! Nagios XI is compatible with MySQL version 8. :D Our latest release is being installed on MySQL version 8.0.17
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
jmsanesteban.sgre
Posts: 51
Joined: Thu Apr 23, 2020 6:46 am

Re: Nagios XI - MySQL 8 Compatibility

Post by jmsanesteban.sgre »

Thank you very much for your answers, they have been very useful.

BR,
Juanma.
User avatar
jbrunkow
Posts: 441
Joined: Fri Mar 13, 2020 10:45 am

Re: Nagios XI - MySQL 8 Compatibility

Post by jbrunkow »

We are happy to help.

Do you have any other questions, or can we lock this topic for editing?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
jmsanesteban.sgre
Posts: 51
Joined: Thu Apr 23, 2020 6:46 am

Re: Nagios XI - MySQL 8 Compatibility

Post by jmsanesteban.sgre »

It's Ok for me, you can lock it.
Locked