Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2016-12

MariaDB, SQLConnection - Suse vs Debian

4 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Gordon Findlay

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 other 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20161226/6de758dc/attachment.html>

Reply by email

Mehmet Erol Sanliturk
to Gordon Findlay

On Sun, Dec 25, 2016 at 8:28 PM, Gordon Findlay via Lazarus <

Show quoted text 33 lines
wrote: 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 other 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 -- _______________________________________________

This means , without hesitation , MariaDB is not compliant to MySQL :

https://www.google.com/#q=compliant+meaning

versus

https://www.google.com/#q=compatible+meaning

.

Mehmet Erol Sanliturk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20161225/5411d4c0/attachment-0001.html>

Reply by email

leledumbo
to Gordon Findlay: I have a project which uses a TMySQL56Connection to work with a MariaDB version 10.0.28…
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"
Show quoted text 5 lines
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?

MariaDB 10.0 indeed maps to MySQL 5.6. But the installed client library is of version 5.5.0, which the connector refuse to use due to version difference. Install the same version for both client and server.

View this message in context: http://free-pascal-lazarus.989080.n3.nabble.com/Lazarus-MariaDB-SQLConnection-Suse-vs-Debian-tp4050639p4050643.html Sent from the Free Pascal - Lazarus mailing list .

Reply by email

Gordon Findlay
to leledumbo

​​
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

On Tue, Dec 27, 2016 at 7:07 AM, leledumbo via Lazarus <

Show quoted text 29 lines
wrote: > 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? MariaDB 10.0 indeed maps to MySQL 5.6. But the installed client library is of version 5.5.0, which the connector refuse to use due to version difference. Install the same version for both client and server. -- View this message in context: http://free-pascal-lazarus. 989080.n3.nabble.com/Lazarus-MariaDB-SQLConnection-Suse-vs- Debian-tp4050639p4050643.html Sent from the Free Pascal - Lazarus mailing list . -- _______________________________________________ Lazarus mailing list http://lists.lazarus-ide.org/listinfo/lazarus

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20161227/9a327676/attachment.html>

Reply by email