connecting to mariadb
lazarus / 63-Database

----------------------------------------------------------------------
alanyoung · 2025-12-12 14:43

I have installed Lazarus Pascal on macos Tahoe .  I have also mariadb,
installed on the same machine via homebrew, which works in terminal
mode.  I also have a pascal project, created in an earlier vision of
Lazarus Pascal, which successfully connected to a mariadb database. 
When I tried to replicate the earlier pascal program in the newer
version of pascal on the macOS Tahoe it always fails to connect to the
database, with the message 'can not load the default MySQl library
(\"libmysqlclient.dylib20\" or \"libmysqlclient.dylib\"). Check your
installation.  Given it's a new clean installation (via fpcupdeluxe). 
Is this a problem of the latest version of Lazarus Pascal or the
method of installation.  Any help would be appreciated.  Thanks

----------------------------------------------------------------------
marcov · 2025-12-12 15:13

mysqlclient is an external requirement. It might be that the older
version finds an older library (e.g. x86), and that your new build is
in arm.

Try to verify target architecture of the old binary and new binary.
(e.g. with the file command)

----------------------------------------------------------------------
alanyoung · 2025-12-13 12:27

the installation of Lazarus Pascal and mariadb are on a new new
computer running Mac Tahoe.  The test to connect to mariadb via pascal
was all with new project.  Therefore there should be no issue with old
versions.

----------------------------------------------------------------------
Zvoni · 2025-12-15 08:31

And have you also homebrewed the MySQL-Client-Lib?

can you find "libmysqlclient.dylib20" or "libmysqlclient.dylib" by
hand?

----------------------------------------------------------------------
alanyoung · 2025-12-15 16:57

I was unable to find either libmysqlclient.dylib20" or
"libmysqlclient.dylib.

Trying to homebrew MySQL-Client-Lib gave no results

----------------------------------------------------------------------
Zvoni · 2025-12-16 07:20

Quote from: alanyoung on December 15, 2025, 05:57:03 pmI was unable to
find either libmysqlclient.dylib20" or "libmysqlclient.dylib.

Trying to homebrew MySQL-Client-Lib gave no results

?!?!?

https://formulae.brew.sh/formula/mysql-client

Though not sure, to what extent MySQL 9.5 Client is supported by our
MySQL-Connection-Class
Maybe one of the older Versions on that page (8.0.44 or 8.4.7)

----------------------------------------------------------------------
alanyoung · 2025-12-16 15:36

I tried both client versions but the problem still persists

----------------------------------------------------------------------
alanyoung · 2026-01-24 17:30

I have also installed mysql as opposed to mariadb, i.e. the
installation does not involve home-brew.  However when I try to
connect to the database in pascal I get the same error- 'can not load
the default MySQl library (\"libmysqlclient.dylib20\" or
\"libmysqlclient.dylib\")'. 
I am at a loss as to how to proceed.

----------------------------------------------------------------------
nouzi · 2026-01-24 19:27

You can try this

Code: Bash  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i brew
install mariadb-client or
Code: Bash  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i brew
install mariadb --devel

----------------------------------------------------------------------
alanyoung · 2026-01-28 17:09

brew install mariadb-client appears to not to be available in homebrew

----------------------------------------------------------------------
nouzi · 2026-01-28 18:17

Quote from: alanyoung on January 28, 2026, 06:09:00 pmbrew install
mariadb-client appears to not to be available in homebrew

You can find dynamic files , get out this command

Code: Bash  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i find /
-name "libmysqlclient*.dylib" 2>/dev/null

----------------------------------------------------------------------
alanyoung · 2026-04-04 16:37

find / -name "libmysqlclient*.dylib" 2>/dev/null. returns:
/opt/homebrew/lib/libmysqlclient.dylib
/opt/homebrew/lib/libmysqlclient_r.dylib
/opt/homebrew/Cellar/mariadb/12.2.2/lib/libmysqlclient.dylib
/opt/homebrew/Cellar/mariadb/12.2.2/lib/libmysqlclient_r.dylib

but the Lazarus error message is refers to libmysqlclient.dybil21 or
dylib

So there appears to be a mismatch between what MariaDB is installing
for their product and what the current version pascal is providing
(when using the fpcupdeluxe)!