On Tue, 12 May 2026, Terry A. Haimann via fpc-pascal wrote:
Ok, this all works from Linux Mint running where I am running Mariadb 10.11.14.
I ahave also ran this on newer versions of mint w/o issues. But on True Blue
Debian systems I haven't gotten it to work.
Ok, yesterday I installed Devaun 6.12.86 on an old laptop (i5-2450m) and
installed mariadb 11.8.6. According to the web that version is compatible with
Mysql 8.0. I created the database and table and added terry to the grant table.
I then did a fresh compile and tried running it:
fpc ImportCars.pas
Free Pascal Compiler version 3.2.2+dfsg-46 [2025/02/08] for x86_64
Copyright (c) 1993-2021 by Florian Klaempfl and others
Target OS: Linux for x86-64
Compiling ImportCars.pas
Linking ImportCars
97 lines compiled, 0.3 sec
./ImportCars
An unhandled exception occurred at $00000000004F54E9:
EInOutError: Can not load default MySQL library ("libmysqlclient.so.21" or
"libmysqlclient.so"). Check your installation.
$00000000004F54E9
$0000000000482FE5
$000000000047054D
I tried then to install libmysqlclient-dev but according to apt-get that has
been discontinued and replaced with either libmariadb-dev or
libmariadb-dev-compat. I tried both with the following results:
sudo apt-get install libmariadb-dev
./ImportCars
An unhandled exception occurred at $00000000004F54E9:
EInOutError: Can not load default MySQL library ("libmysqlclient.so.21" or
"libmysqlclient.so"). Check your installation.
$00000000004F54E9
$0000000000482FE5
$000000000047054D
I then removed that library and installed the 2nd library.
sudo apt-get remove libmariadb-dev
sudo apt-get install libmariadb-dev-compat
./ImportCars
An unhandled exception occurred at $0000000000483045:
EInOutError: TMySQL80Connection can not work with the installed MySQL client
version: Expected (8.0), got (3.4.9).
$0000000000483045
$000000000047054D
Set the SkipLibraryVersionCheck property to true, that should avoid this error.
Michael.
_______________________________________________
fpc-pascal maillist - [email protected]
https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
