Re: mariadb TLS/SSL error

[Benoît Minisini <benoit.minisini@xxxxxxxxxxxxxxxx>]

Le 26/09/2025 à 13:05, Wim Geraets a écrit :
> When using my existing programs with more recent gambas eg 3.20.4, I get a connection error:
>
> Try hConnection.open: Cannot open database: TLS/SSL error: SSL is required, but the server does not support it.
>
> I use a mariadb server on my local network, indeed without SSL.
>
> The Command Line client gives the same error.
>
> mariadb -h my.server.internal -u myname -p
> *******
>
> ERROR 2026: TLS/SSL error..
>
> But I can work around with the parameter --skip_ssl.
>
> mariadb -h my.server.internal -u myname --skip_ssl -p
> *******
>
> Welcome to the MariaDB... monitor
>
> I can continue to work around by creating the file ~.my.cnf with as content:
> [Client]
> skip-ssl = true
>
> Now I can login on the commandline.
>
> What to do in Gambas?  Gambas does not seem to read "~.my.cnf".
> Is there a way to give the parameter "--skip_ssl"?
>
> (I work on openSUSE Tumbleweed and Leap, ok until version 3.20.2, problem occured from 3.20.4, most recent version tried 3.20.99)
>
>
> Kind greetings,
>
> Wim

You can set the 'GB_DB_MYSQL_NOSSL' environment variable to "1" to 
disable SSL. But not all versions of MySQL/MariaDB support disabling SSL 
(you will get a warning message).
This environment variable must be set before opening the connection of 
course.

Regards,

--
Benoît Minisini.