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/ _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
