Where and how do I do this?
Message: 1 Date: Mon, 18 May 2026 08:55:30 +0200 (CEST) From: Michael Van Canneyt <[email protected]> To: "Terry A. Haimann via fpc-pascal" <[email protected]> Subject: Re: [fpc-pascal] Connecting to a mariadb server from a Free Pascal Process using Devaun Message-ID: <[email protected]> Content-Type: text/plain; charset=US-ASCII; format=flowed 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. -- Terry A. Haimann <[email protected]> _______________________________________________ fpc-pascal maillist - [email protected] https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
