Mysql server patch compatibility

[mansonli]

May I know any compatibility issues of patches found in https://www.oracle.com/security-alerts/ ... pendixMSQL which're applicable to install on the following version with nagios 5.4.13 and 5.7.x?

5.7.19-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

[ssax]

What is the output of these commands on the XI system?

Code: Select all

rpm -qa | grep -i mariadb
rpm -qa | grep -i mysql

Please PM me a copy of your profile, you can download it from Admin > System Profile by clicking the Download Profile button.

[ssax]

That version of MySQL should work but note that we do not have/use or test against MySQL Enterprise. You would need to reach out to MySQL support to determine if any of those are applicable to that MySQL package you are trying to use, the ones we use are from the OS vendor repositories which you can search the backported CVEs like this:

https://www.cyberciti.biz/faq/linux-fin ... e-applied/
https://access.redhat.com/security/updates/backporting

[mansonli]

Our DBA team checked "April 2020 Critical Patch Update patch" is applicable to current mysql enterprise 5.7.19, it's upgraded to 5.7.23 which contains fixes in above patch on a nonprod db server and will be tested its compatibility with nagios XI 5.4.13.

Do you mean nagiox XI 5.4.x to 5.7.x work with mysql 5.7.x (non enterprise) without known issue?

[ssax]

Do you mean nagios XI 5.4.x to 5.7.x work with mysql 5.7.x (non enterprise) without known issue?

Correct, you can pretty much use any recent version of MySQL/MariaDB and it'll work (later versions require that sql_mode change I already listed). So yes, 5.7.23 is included in 5.7.X and there are no known issues with it.

I haven't run into a MySQL/MariaDB version that it has issues with in my 4-ish years here. That's why they don't list the required version because you should be able to use any version of MySQL/MariaDB that the system supports (don't try to shoe-horn in some really really old version of MySQL/MariaDB, but even if you did I assume it would likely work). I doubt you'll have any issues with MySQL enterprise, I'm just noting that we don't have access to it or test against it so you may run into issues, the likelihood of you running into issues is low.