[Pdns-users] Dig @127.0.0.1 gives status servfail

[Peter van Dijk]

On Sat, 2021-05-22 at 16:16 -0500, von lon via Pdns-users wrote:
> When i do the command "Dig @127.0.0.1" i get a response called servfail when i do the command "sudo systemctl status pdns" i get "Backend reported permanent error which prevented lookup (GSQLBackend lookup query:Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?: Unknown column 'disabled' in 'field list'), aborting
> Backend error: GSQLBackend lookup query:Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?: Unknown column 'disabled' in 'field list' " so i think this is causeing the problem but i dont know how to fix it. I am using the latest version of powerdns i think. I am on raspbian 10 using gmysql. I got this using apt. And. I turned my firewall off to see if that was the problem but it wasnt the problem.

You're using an SQL schema from before version 3.4.0, with a pdns
version after 3.4.0. Please see 
https://github.com/PowerDNS/pdns/tree/master/modules/gmysqlbackend for
the schema updates you need to apply.

Kind regards,
-- 
Peter van Dijk
PowerDNS.COM BV - https://www.powerdns.com/