Issue Plesk Onyx Version 17.0.17 Error

[Scottpr]

Hi

I upgraded to Plesk Onyx Version 17.0.17 and i am getting the following error when i click on applications.

Internal error: ODBC error #01000: [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found
Message ODBC error #01000: [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found
File aps_php.php
Line 12157
Type Exception


Any idea's ?

Using Centos 6 (64 bits)
PHP 7.0.13
MYSQL 5.6.34

Kind Regards

Scott

 

[Scottpr]

https://kb.plesk.com/en/124899

I ran rpm -Uvh mysql-connector-odbc-5.1.5.rpm --force

and it gives me error

error: open of mysql-connector-odbc-5.1.5.rpm failed: No such file or directory

 

[Eax]

try

yum install mysql-connector-odbc

 

[Scottpr]

Hi Eax

No unfortunately that did not work, still getting the error.

Kind Regards

Scott

# yum install mysql-connector-odbc

Loaded plugins: presto

Setting up Install Process
PLESK_17_0_17-extras | 2.9 kB 00:00
PLESK_17_NGINX | 2.9 kB 00:00
PLESK_17_PHP56 | 2.9 kB 00:00
PLESK_17_PHP70 | 2.9 kB 00:00
base | 3.7 kB 00:00
extras | 3.4 kB 00:00
mysql-connectors-community | 2.5 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql56-community | 2.5 kB 00:00
updates | 3.4 kB 00:00
Package mysql-connector-odbc-5.3.6-1.el6.x86_64 already installed and latest version
Nothing to do

 

[Eax]

Hi Eax

No unfortunately that did not work, still getting the error.

Kind Regards

Scott

# yum install mysql-connector-odbc

Loaded plugins: presto

Setting up Install Process
PLESK_17_0_17-extras | 2.9 kB 00:00
PLESK_17_NGINX | 2.9 kB 00:00
PLESK_17_PHP56 | 2.9 kB 00:00
PLESK_17_PHP70 | 2.9 kB 00:00
base | 3.7 kB 00:00
extras | 3.4 kB 00:00
mysql-connectors-community | 2.5 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql56-community | 2.5 kB 00:00
updates | 3.4 kB 00:00
Package mysql-connector-odbc-5.3.6-1.el6.x86_64 already installed and latest version
Nothing to do

read
https://kb.plesk.com/en/120426

 

[Scottpr]

Hi Eax

Thanks, please see below result

/usr/lib64/sw/libmysqlserver.so.2

So it should be located here :

/usr/lib64/libmysqlserver.so.2

If so do i move onto step 2 and run

grep -i APS_DB_DRIVER_LIBRARY /etc/psa/psa.conf
APS_DB_DRIVER_LIBRARY /usr/lib64/libmysqlserver.so.2

Apologies i am not a linux admin, and want to make sure i am doing this right

Kind Regards

Scott

 

[Eax]

dont touch libmysqlserver
you need to fix libmyodbc5
it's simple
search and find libmyodbc5.so , then link it to correct path "/usr/lib64/libmyodbc5.so"

regards

 

[Scottpr]

Hi Eax

Sorry so to clarify, i ran

find / \( -name libmysqlserver.so.2 -o -name libmyodbc.so \) -print 2>/dev/null

it then gave me only the below result

/usr/lib64/sw/libmysqlserver.so.2

--------

So this means the file libmyodbc.so is located in the folder libmysqlserver.so.2 ?

Is so, are you saying i only need to move the file libmyodbc.so to the folder under /usr/lib64/sw/libmysqlserver.so.2

I don't see a folder under /SW called libmysqlserver.so.2

Kind Regards

Scott

 

[Scottpr]

Sorry typos

Is so, are you saying i only need to move the file libmyodbc.so to the folder under /usr/lib64/libmysqlserver.so.2

I don't see a folder under /lib64 called libmysqlserver.so.2