Resolved Plesk 12.5 mysql 5.6 ODBC

[moswak]

Plesk 12.5 latest Updates
Centos 6.8
Mysql 5.6

Hi,
i read many threads in forum and some articels in KB.

for the error Can't open lib '/usr/lib64/libmyodbc5.so' : file not found
there are two solutions, both worked

1.
edit file /etc/odbcinst.ini
replace /usr/lib64/libmyodbc5.so to /usr/lib64/libmyodbc5a.so
then
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

or
2.
create smylink
#cd /usr/lib64/
#ln -s libmyodbc5w.so libmyodbc5.so
and then
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

which is the better solution ?

 

[IgorG]

which is the better solution ?

The better solution that is working correctly for you.

 

[moswak]

there are two solutions, both worked

The better solution that is working correctly for you.

both worked thats why i ask which one is the better way.

ok, then it is probably my decision.

I forgot ...
To keep link /tmp/mysql.sock after server restart add following string in the beginning of /etc/init.d/mysqld:
if [ ! -L /tmp/mysql.sock ]; then ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock ; fi

 

[SimonG]

Not sure if it's any help now, but I usually take option 2, and set up the links.