Page 1 of 1
Mysql server patch compatibility
Posted: Tue Oct 27, 2020 2:02 am
by 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)
Re: Mysql server patch compatibility
Posted: Tue Oct 27, 2020 2:21 pm
by 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.
Re: Mysql server patch compatibility
Posted: Fri Nov 13, 2020 4:14 pm
by 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
Re: Mysql server patch compatibility
Posted: Sun Nov 15, 2020 9:11 pm
by 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?
Re: Mysql server patch compatibility
Posted: Mon Nov 16, 2020 7:38 pm
by 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.