Plesk update and APS application installation fail: No ODBC MySQL mysql drivers found, trying /usr/lib64/libmyodbc5a.so

Connect to the server using SSH . Downgrade the package mysql-connector-odbc : yum downgrade mysql-connector-odbc-8.0.11-1.el6 Add the following line to the file /etc/yum.repos.d/mysql-community.repo under the section…

All Articles

Connect to the server using SSH. Downgrade the package mysql-connector-odbc:

yum downgrade mysql-connector-odbc-8.0.11-1.el6

Add the following line to the file /etc/yum.repos.d/mysql-community.repo under the section [mysql-connectors-community] to exclude these packages from regular updates:

exclude=mysql-connector-odbc*

The result should be like the one below:

cat /etc/yum.repos.d/mysql-community.repo
...
[mysql-connectors-community]
exclude=mysql-connector-odbc* Open the file /etc/odbcinst.inifor editing and set the parameters Driver and Driver64 to /usr/lib64/libmyodbc5a.so:

[MySQL]
Driver = /usr/lib64/libmyodbc8w.so
Driver64 = /usr/lib64/libmyodbc8w.so Re-install latest updates: plesk installer update --repatch

Published by

anup

Technical content from the 24x7ServerSupport infrastructure, server management and cloud operations team.