Hey Guys,
New to Cyber Panel, we have tried to fix an issue where once the cluster is turned on pdns fails to start and keeps rebooting complaining that there is a communications issue.
I have an extraction from the log but i have been unable to post it here.
I have also seen that under the Managed Services >> Manage PowerDNS! it wont retain if its a master or a slave
I have reformatted severl times, checked selinux, disabled the firewall, edited the hostname and name servers in /etc/hosts nothing has worked. This is a brand new install
[root@static-103-243-239-97 ~]# journalctl -f | grep pdns
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: PowerDNS Authoritative Server 4.8.4 (C) 2001-2022 PowerDNS.COM BV
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: Using 64-bits mode. Built using gcc 11.4.1 20230605 (Red Hat 11.4.1-2) on Feb 6 2024 00:00:00 by mockbuild@localhost.
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: Polled security status of version 4.8.4 at startup, no known issues reported: OK
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: Primary/secondary communicator launching
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: Creating backend connection for TCP
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: About to create 3 backend threads for UDP
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: Exiting because communicator thread died with error: virtual void GSQLBackend::getUpdatedMasters(std::vector<DomainInfo>&, std::unordered_set<DNSName>&, CatalogHashMap&) unable to retrieve list of master domains: Could not prepare statement: select d.id, d.name, d.type, d.notified_serial,d.options, d.catalog,r.content from records r join domains d on r.domain_id=d.id and r.name=d.name where r.type='SOA' and r.disabled=0 and d.type in ('MASTER', 'PRODUCER'): Unknown column 'd.options' in 'SELECT'
Jun 07 02:00:32 static-xxx-xxx-xxx-xx pdns_server[35336]: Done launching threads, ready to distribute questions
Jun 07 02:00:33 static-xxx-xxx-xxx-xx systemd[1]: pdns.service: Main process exited, code=exited, status=1/FAILURE
Jun 07 02:00:33 static-xxx-xxx-xxx-xx systemd[1]: pdns.service: Failed with result 'exit-code'.
Jun 07 02:00:34 static-xxx-xxx-xxx-xx systemd[1]: pdns.service: Scheduled restart job, restart counter is at 746.
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: Loading '/usr/lib64/pdns/libgmysqlbackend.so'
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: This is a standalone pdns
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: Listening on controlsocket in '/run/pdns/pdns.controlsocket'
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: UDP server bound to 0.0.0.0:53
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: UDP server bound to [::]:53
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: TCP server bound to 0.0.0.0:53
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: TCP server bound to [::]:53
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: PowerDNS Authoritative Server 4.8.4 (C) 2001-2022 PowerDNS.COM BV
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: Using 64-bits mode. Built using gcc 11.4.1 20230605 (Red Hat 11.4.1-2) on Feb 6 2024 00:00:00 by mockbuild@localhost.
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: Polled security status of version 4.8.4 at startup, no known issues reported: OK
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: Primary/secondary communicator launching
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: Creating backend connection for TCP
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: Exiting because communicator thread died with error: virtual void GSQLBackend::getUpdatedMasters(std::vector<DomainInfo>&, std::unordered_set<DNSName>&, CatalogHashMap&) unable to retrieve list of master domains: Could not prepare statement: select d.id, d.name, d.type, d.notified_serial,d.options, d.catalog,r.content from records r join domains d on r.domain_id=d.id and r.name=d.name where r.type='SOA' and r.disabled=0 and d.type in ('MASTER', 'PRODUCER'): Unknown column 'd.options' in 'SELECT'
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: About to create 3 backend threads for UDP
Jun 07 02:00:34 static-xxx-xxx-xxx-xx pdns_server[35351]: Done launching threads, ready to distribute questions
Jun 07 02:00:35 static-xxx-xxx-xxx-xx systemd[1]: pdns.service: Main process exited, code=exited, status=1/FAILURE
Jun 07 02:00:35 static-xxx-xxx-xxx-xx systemd[1]: pdns.service: Failed with result 'exit-code'.
^X^C