I am using Cyberpanel 2.4.5 on Almalinux 9.
PowerDNS has stopped working.
Note that I don’t have systemd-resolved in my Almalinux 9.
Mariabd is running an accesible. But getting below error, where I have check the table and found it’s true.
Note that I haven’t done any recent chanes except implement file2ban to stop ddos attach. I believe that is irrelevant.
Error:
May 08 19:33:03 pdns_server[16212]: PDNSException while filling the zone cache: Database error trying to retrieve all domains:Could not prepare statement: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type=‘SOA’ AND records.name=domains.name WHERE records.disabled=0 OR ?: Unknown column ‘domains.catalog’ in ‘SELECT’
May 08 19:33:03 systemd[1]: pdns.service: Main process exited, code=exited, status=1/FAILURE
Domain Table:
Error:
Mysql Connection Port:
PowerDNS Permission:
MySQL password in config is also ok.
Tried sudo systemctl start pdns but it didn’t work. Getting same error.
Can anyone help please.