Recent

Author Topic: 10.3.22-MariaDB-0+deb10u1  (Read 381 times)

@Func

  • New Member
  • *
  • Posts: 35
10.3.22-MariaDB-0+deb10u1
« on: May 22, 2020, 06:13:44 am »
does there have some components can access database (10.3.22-MariaDB-0+deb10u1 ). thanks !

dogriz

  • Full Member
  • ***
  • Posts: 108
    • Tech blog - Delphi, Lazarus, Firebird, Windows, Linux, Android...
Re: 10.3.22-MariaDB-0+deb10u1
« Reply #1 on: May 22, 2020, 09:01:19 am »
I have no problem accessing MariaDB 10.3.23 on linux with TMySQL57Connection.
FPC 3.0.4
Lazarus 2.0.6
Debian x86_64, arm

PascalDragon

  • Hero Member
  • *****
  • Posts: 1966
  • Compiler Developer
Re: 10.3.22-MariaDB-0+deb10u1
« Reply #2 on: May 22, 2020, 09:04:25 am »
MariaDB 10.3.22 should be compatible with the MySQL 5.7 client. Thus as dogriz wrote you can use TMySQL57Connection.

devEric69

  • Sr. Member
  • ****
  • Posts: 317
Re: 10.3.22-MariaDB-0+deb10u1
« Reply #3 on: May 22, 2020, 11:01:13 am »
MariaDB 10.3.22 should be compatible with the MySQL 5.7 client. Thus you can use TMySQL57Connection.

Thank you,
I have the same problem with a MariaDB 10, and it works for me (nb: but I'm under Windows, before migrating the development under Linux).


My configuration is:

 ▶ on the database server side:
version: 10.0.29-MariaDB - mariadb.org
charset=utf8
started on localhost and listening at 3306


 ▶ on the database client side (from the database server's "point of view"):
▪ a client Apache (I work with a WAMP named Uniserver (https://wiki.freepascal.org/Lazarus_Application_Gallery#Uniform_Server), written in Object Pascal too):
libmysql - version mysqlnd 5.0.12-dev

▪ a client API named libmysql.dll for Lazarus (copied from the my standard installation of UniserverXIII in '...\UniserverXIII\\core\mysql\bin', and pasted into 'C:Windows System32') - version: 10.0.029

From Lazarus, the component resource witten in *.lfm is:

Code: Pascal  [Select][+][-]
  1. object MySQL57Connection1: TMySQL57Connection
  2.   Connected = True
  3.   LoginPrompt = False
  4.   DatabaseName = 'licenses'
  5.   KeepConnection = False
  6.   Params.Strings = (
  7.     'Port=3306'
  8.   )
  9.   Password = 'root'
  10.   UserName = 'root'
  11.   CharSet = 'utf8'
  12.   HostName = 'localhost'
  13.   SkipLibraryVersionCheck = True
  14.   left = 104
  15.   top = 24
  16. end

ps1: i've another layer for - mysqli or pdo - Php data access - too, which is named php*mysql*.dll, in order to be able to model a base with PhpMyAdmin (Version : 4.4.15.10, installed with Uniserver also)
ps2: it also works well with Zeos 7.2.6 stable (but it requires the installation and versioning of the zcomponent.lpk package).
ps3: compatibilities between MariaDB and MySQL are written in mysqlconn.inc, line 75.
« Last Edit: July 03, 2020, 02:07:52 pm by devEric69 »
use: Linux 64 bits (Ubuntu 18.04 LTS).
Lazarus version: 2.0.4 (svn revision: 62502M) compiled with fpc 3.0.4 - fpDebug \ Dwarf3.

 

TinyPortal © 2005-2018