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 cryptokeys.id, flags, active, published, content from domains, cryptokeys where cryptokeys.domain_id=domains.id and name=?: Unknown column ‘published’ in ‘field list’

Pre-requisites

Fix

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