Hello I had a powerdns server and the server died for some hardware issues during the day. Since I did not remember what version of powerdns it was running at I deployed a new server and deployed the latest stable version on it. Then because of mismatches in the database I have found out that it was something like 4.3 therefore I run the sql migration script to make it compatible with 4.7 schema. Now the powerdns keep failing with the following error:
Feb 26 16:25:44 dns-2 systemd[1]: Starting PowerDNS Authoritative Server... Feb 26 16:25:44 dns-2 pdns_server[9754]: Loading '/usr/lib64/pdns/libgmysqlbackend.so' Feb 26 16:25:44 dns-2 pdns_server[9754]: This is a standalone pdns Feb 26 16:25:44 dns-2 pdns_server[9754]: Listening on controlsocket in '/run/pdns/pdns.controlsocket' Feb 26 16:25:44 dns-2 pdns_server[9754]: 'domain-metadata-cache-ttl' is deprecated and will be removed in a future release, use 'zone-metadata-cache-ttl' instead Feb 26 16:25:44 dns-2 pdns_server[9754]: UDP server bound to 0.0.0.0:53 Feb 26 16:25:44 dns-2 pdns_server[9754]: UDP server bound to [::]:53 Feb 26 16:25:44 dns-2 pdns_server[9754]: TCP server bound to 0.0.0.0:53 Feb 26 16:25:44 dns-2 pdns_server[9754]: TCP server bound to [::]:53 Feb 26 16:25:44 dns-2 pdns_server[9754]: PowerDNS Authoritative Server 4.9.4 (C) PowerDNS.COM BV Feb 26 16:25:44 dns-2 pdns_server[9754]: Using 64-bits mode. Built using gcc 11.5.0 20240719 (Red Hat 11.5.0-2.0.1) on Feb 6 2025 15:25:48 by root@localhost. Feb 26 16:25:44 dns-2 pdns_server[9754]: 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. Feb 26 16:25:44 dns-2 pdns_server[9754]: [webserver] Listening for HTTP requests on 0.0.0.0:8082 Feb 26 16:25:44 dns-2 pdns_server[9754]: Polled security status of version 4.9.4 at startup, no known issues reported: OK Feb 26 16:25:54 dns-2 pdns_server[9754]: PDNSException while filling the zone cache: Database error trying to retrieve all domains:Could not execute mysql 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 ?: Lost connection to server during query Feb 26 16:25:54 dns-2 systemd[1]: pdns.service: Main process exited, code=exited, status=1/FAILURE Feb 26 16:25:54 dns-2 systemd[1]: pdns.service: Failed with result 'exit-code'. Feb 26 16:25:54 dns-2 systemd[1]: Failed to start PowerDNS Authoritative Server. Any idea how can I fix it at least to a state where I can export the zones to some files so that I could reimport them in a new installation with new database. Regards, Peter
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
