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

Pre-requisites

  • Access to a terminal window/command line
  • A user account with sudo or root privileges
  • MySQL Access to the backend database that supports PowerDNS

Fix

  • Before making any changes, we want to back up the current database.
  • We now want to add the missing column to the table cryptokeys
  • Now we want to restart pdns