[fpc-pascal] Connecting to a mariadb server from a Free Pascal Process using Devaun

[Michael Van Canneyt]

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 at freepascal.org>
> To: "Terry A. Haimann via fpc-pascal"
> 	<fpc-pascal at lists.freepascal.org>
> Subject: Re: [fpc-pascal] Connecting to a mariadb server from a Free
> 	Pascal Process using Devaun
> Message-ID: <7eb6e01c-fca3-6ecb-b573-ad8eefa08d2e at freepascal.org>
> 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 <terry at haimann.us>
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>