[Pdns-users] gmysql SSL connection error, no such file

[Cristian Seres]

Hi,

I thought I'll ask here if someone can help as I've hit my head to the 
wall for several hours already and can't figure out, what's going on.

I am working on a copy of a production environment, 
pdns-4.9.3-1pdns.el9.x86_64 on two AlmaLinux 9.5 hosts, 
mariadb-10.5.22-1.el9_2.alma.1.x86_64.

I enabled MariaDB primary-secondary replication using TLSv1.3 
replication and it is now working fine. The problem is that when I 
enable options ssl_cert,ssl_key and ssl_ca in [mariadb] section of 
MariaDB config in ns2, the pdns refuses to start, giving
"ns2 pdns_server[33296]: Caught an exception instantiating a backend 
(gmysql): Unable to launch gmysql connection: Unable to connect to 
database: ERROR 2026 (HY000): SSL connection error: no such file"

and I can't figure out, what file is it not able to read. I've also 
tried to set gmysql-group=pdns-client in pdns.conf and define

[pdns-client]
ssl_cert =
ssl_key =
ssl_ca =
skip_ssl = true

but the error remained the same.

I could just disable TLS on this server, but it still annoys me that I 
can't understard what the actual problem is and why mysql command from 
the command line works fine, but pdns gmysql can't connect.

Any ideas, how to find out what file it is trying to access? I even 
tried to copy all ca, key and crt files to /etc/pdns/certs and gave 
permission to pdns and set those absolute paths in [pdns-client] 
section, but even that didn't help.

With best regards,

-- 
Cristian Seres