TMySQLConnection and MariaDB - suse vs Debian
lazarus / 16-Databases

----------------------------------------------------------------------
GordonFindlay · 2016-12-26 00:28

I have a project which uses a TMySQL56Connection to work with a
MariaDB version 10.0.28 For unrelated reasons I moved it from an
OpenSUSE LEAP 42.1 box to a Debian 8 one.

They have the same version of MariaDB (mysql -V reports "version 15.1
Distrib 10.0.28-MariaDB in both cases).

Lazarus/FPC etc are installed in a private directory, not shared. I
simply copied the dirtecory across. I can create and execute projects
as normal.

I transferred the databases, and using mysql from the command line
everything looks as expected.

But when i attempt to access the databases from my project the MySQL
5.6 connector throws an error: "Cannot work with installed MySQL
Client version; got 5.5.0 expected 5.6"

Using TMySQL55Connection doesn't work either: there is a more general
error message, basically "unable to connect".

Identical dev. environment, code and databases - what's different?

Any thoughts?
TIA
Gordon

----------------------------------------------------------------------
LacaK · 2016-12-26 08:26

Quote from: GordonFindlay on December 26, 2016, 01:28:04 am the MySQL
5.6 connector throws an error: "Cannot work with installed MySQL
Client version; got 5.5.0 expected 5.6"
IMO this indicates, that somewhere on path is 5.5 client library,
which is loaded ... instead of expected 5.6

----------------------------------------------------------------------
GordonFindlay · 2016-12-27 07:46

​​
Thanks - that is the problem.

In case anyone else encounters this, the issue is that Debian 8.0
(Jessie) installs Maria 10.0.28, which is MySQL 5.6 compatible, but
version 5.5 of libmysqlclient18.so

Version 5.6 is available in the jessie-backports repository (see
https://packages.debian.org/jessie-backports/libmysqlclient18)