trinv
commented
2 years ago Hi, i found how to fix it: exec this command in mysql:
https://github.com/PowerDNS/pdns/blob/master/modules/gmysqlbackend/4.2.0_to_4.3.0_schema.mysql.sql
mysql -u root -p
use powerdns; ALTER TABLE cryptokeys ADD published BOOL NULL DEFAULT 1 AFTER active; quit;
systemctl restart mariadb systemctl restart pdns systemctl restart powerdns-admin
Mar 22 08:44:33 ns01 pdns_server[145457]: [webserver] 2caac540-46fd-4ce9-a2f6-03a337c083de HTTP ISE for "/api/v1/servers/localhost/zones": Exception: GSQLBackend unable to list keys: Could not prepare statement: select cryptokeys.id, flags, active, published, content from domains, cryptokeys where cryptokeys.domain_id=domains.id and name=?: Unknown column 'published' in 'field list' Mar 22 08:44:33 ns01 gunicorn[142533]: [2022-03-22 08:44:33,528] [domain.py:252] ERROR - Cannot add domain test.com. Error while fetching http://10.0.1.9:8081/api/v1/servers/localhost/zones. Returned status 500 and content Internal Server Error
Mar 22 08:46:42 ns01 pdns_server[145457]: [webserver] d4416c68-8e6c-41f7-bc06-fa0580d66abb HTTP ISE for "/api/v1/servers/localhost/zones": Exception: GSQLBackend unable to list keys: Could not prepare statement: select cryptokeys.id, flags, active, published, content from domains, cryptokeys where cryptokeys.domain_id=domains.id and name=?: Unknown column 'published' in 'field list' Mar 22 08:46:42 ns01 gunicorn[142533]: [2022-03-22 08:46:42,568] [domain.py:168] ERROR - Cannot update domain table. Error: Error while fetching http://10.0.1.9:8081/api/v1/servers/localhost/zones. Returned status 500 and content Internal Server Error