Remote MYSQL - mysql_enable_utf8 not applied?
Concerned version
Version: %1.9.15
Summary
Can't connect to remote MySQL Server (backend) with LLNG.
- We are migrating mysql databases all arround the IT into a secured cluster. As we choosed MySQL as backend, LLNG is also concerned by this migration;
- Connection needs to be done with a client-charset = UTF8. I can connect successfuly to the cluster via mysql command :
mysql -u [lemonUser] -p -h mysqlCluser
( default-charset fixed in my.cnf )
But it doesn't work via LLNG (from lemonldap-ng.ini):
dbiChain = DBI:mysql:database=lemonLdapDb;host=mysqlCluster
I tried to force mysql_enable_utf8=1 & SET NAMES 'utf8'; but saw that it was already put in _DBI.pm.
Logs
DBD::mysql::db do failed: Lost connection to MySQL server during query at /usr/share/perl5/Lemonldap/NG/Common/Conf/_DBI.pm
It fails on "set names utf8;" It's like the utf8 encoding is not really "sent" and so the server doesn't accept transactions despite it accepted the connection....
Can you reproduce this issue ? dunno where else to search for make it work.
Anthony