How to Fix 'Backend error: GSQLBackend unable to list keys' in PowerDNS

After upgrading to Ubuntu 20.10, you may sometimes encounter an error when attempting to start PowerDNS:

Backend error: GSQLBackend unable to list keys: Could not prepare statement: select, flags, active, published, content from domains, cryptokeys where and name=?: Unknown column ‘published’ in ‘field list’



mysqldump -u root -p -B pdns > pdns_backup.sql

mysql -u root -p use pdns; ALTER table cryptokeys add column published BOOL DEFAULT 1 after active;

systemctl restart pdns

comments powered by Disqus