Hi

This question has obviously been asked many times before, but I am having trouble dealing with the answers.

I run MariaDB, rather than MYSQL, using OpenSUSE 13.2, with Lazarus 1.4, Free Pascal 2.6.4, downloaded from Sourceforge. I have the usual issue getting a database connection: "TMySQL56Connection can not work with the installed MySQL client version: Expected (5.6), got (10.0.13-MariaDB)"

There's a diff associated with the bug report at
http://bugs.freepascal.org/view.php?id=26620 which I have attempted to apply, without success.

What I tried was:

- patch
/usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql/mysqlconn.inc as in the diff
- rebuilt, using the Makefile in that directory
- within Lazarus, rebuilt the IDE.

This hasn't achieved anything. I get the same error, which presumably means I have missed out some steps.

I'm starting to find the documentation wiki "a mass of twisted passages, all alike". Is there a simple explanation of what I have missed?

TIA
Susie
---
Susie Nichol
Christchurch, New Zealand.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20150628/1f16b310/attachment.html>

This hasn't achieved anything. I get the same error, which presumably means

I have missed out some steps.

- patch /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql/mysqlconn.inc as in the diff
- rebuilt, using the Makefile in that directory

>> - install it, replacing the shipped mysqlXY compiled units

- within Lazarus, rebuilt the IDE.

Compiling is not enough. Did you install the .ppu ?

Several ways are possible:

1. The clean way
That is, in /usr/share/fpsrc/2.6.4/packages/fcl-db you should run "make install", as root. But that may lead to other problems since you will have newer .ppu's of all

2. find the newly generated mysql56conn.ppu and mysql56conn.o, and just copy these over the installed version

And then rebuild lazarus.

The simplest solution may be to:
3. Simply copy 2 files: mysql56conn.pp and mysqlconn.inc from /usr/share/fpsrc/2.6.4/packages/fcl-db/src/sqldb/mysql to your project's directory. Recompile your project.
You will then not be able to make the connection in the lazarus form designer, but the compiled program should then work.

Michael.

Many thanks both of you

Susie

On Sun, Jun 28, 2015 at 9:35 PM, Michael Van Canneyt <

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20150629/20a130e6/attachment.html>

Susie Nicol wrote

Many thanks both of you Susie

Did you manage to get it to work ?

Michael.

Yes, it is working.

The diff is incorrect, but comments in the bug track correct it. I used your method 2; method 1 didn't work and I think I know why: my testing has upset the directory structure. I'll look into that after I get this project finished.

Susie

On Sun, Jun 28, 2015 at 9:35 PM, Michael Van Canneyt <

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20150629/37646cb6/attachment.html>