[Pdns-users] DNSSEC Support with PowerDNS – LDAP & MariaDB Backend

[Alessandro Lota]

Hi all,
I am new here and not subscribed yet, so please keep me in CC. :-)
I have been using PowerDNS with an LDAP backend for many years, but it 
does not support DNSSEC.
To add DNSSEC support, I configured a secondary MariaDB backend and 
added a new section:

# in my pdns.conf below a working LDAP conf

launch+=gmysql
gmysql-host=127.0.1.1
gmysql-user=pdns_superuser
gmysql-password=~omissis~
gmysql-dbname=pdns
gmysql-port=3306

# DNSSEC
gmysql-dnssec=yes

Everything seems to work fine, but PowerDNS keeps getting killed due to 
a strange database access issue:

Feb 18 13:59:21 ns1 systemd[1]: pdns.service: Main process exited, 
code=killed, status=6/ABRT
Feb 18 13:49:05 ns1 mariadbd[607352]: 2025-02-18 13:49:05 4863 [Warning] 
Aborted connection 4863 to db: 'pdns' user: 'pdns_superuser' host: 
'localhost' (Got an error reading communication packets)

The database configuration seems correct. However, I suspect that 
PowerDNS is trying to use a Unix socket instead of a TCP port because 
the logs show "localhost" instead of "127.0.0.1".
Could this strange behavior be caused by using a dual backend configuration?

some ideas?

TIA
Alessandro

-- 
è facile registrare un dominio con bitName! https://www.bitname.it