Plesk 12.5 | MySQL 5.6 | Cent OS 6.5 | Plesk Panel 'Application Vault' Issue

[PriyanA]

Hi,

I have upgraded MySQL 5.1 to 5.6 successfully.

Everything works fine. Except for Plesk Panel > Tools & Setting > 'Application Vault'

Error Message,
-----
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 11933
Type Exception
-----

I understand /usr/lib64/libmyodbc5.so no longer there.

I can downgrade to mysql-connector-odbc-5.1.5r1144-7.el6

then I get this Error message by accessing 'Application Vault'

----
502 Bad Gateway
nginx
----

How can I resolve this issue?

Thank You!

 

[PriyanA]

Anyone? Plesk Team?

 

[IgorG]

I can downgrade to mysql-connector-odbc-5.1.5r1144-7.el6

Why downgrade? I suppose that version of this package should be the same as for mysql-server package - 5.6

 

[PriyanA]

Current connector version installed by upgrading to MySQL 5.6 using YUM is,

mysql-connector-odbc.x86_64 5.3.4-1.el6

I receive this error message by accessing 'Application Vault'

Error Message,
-----
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 11933
Type Exception
-----

 

[IgorG]

What is output of

# ls -la /usr/lib64/libmyodbc*

?

 

[PriyanA]

-rwxr-xr-x 1 root root 4300760 Jun 19 2014 /usr/lib64/libmyodbc5a.so
-rwxr-xr-x 1 root root 4299448 Jun 19 2014 /usr/lib64/libmyodbc5w.so

Thank you IgorG

 

[IgorG]

Try to create symlink /usr/lib64/libmyodbc5.so to one of these files and check results.

 

[PriyanA]

Thank you!!! It worked!

#cd /usr/lib64/

#ln -s libmyodbc5w.so libmyodbc5.so

Then,

#ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock


Thank you IgorG