Re: Connecting to a mariadb server from a Free Pascal Process using Devaun
Michael Van Canneyt via fpc-pascal <[email protected]> Wed, 20 May 2026 14:23:59 +0200 (CEST)
| Newsgroups | gmane.comp.compilers.free-pascal.general |
|---|---|
| Message-ID | <[email protected]> |
It is a property of the mysql connection class, simply set it to 'True' before connecting. Michael. On Tue, 19 May 2026, Terry A. Haimann via fpc-pascal wrote: > Where and how do I do this? > > > Message: 1 > Date: Mon, 18 May 2026 08:55:30 +0200 (CEST) > From: Michael Van Canneyt <michael-y8GAwIkqPAJpn7uciFS/[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: <7eb6e01c-fca3-6ecb-b573-ad8eefa08d2e-y8GAwIkqPAJpn7uciFS/[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 > _______________________________________________ fpc-pascal maillist - [email protected] https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal