Hello Jorge, I stumbled upon the same problem a few months ago. Here you can find the schema-updates: https://github.com/PowerDNS/pdns/tree/master/modules/gmysqlbackend
best regards, Markus Von: Pdns-users <pdns-users-boun...@mailman.powerdns.com> Im Auftrag von Jorge Arenas via Pdns-users Gesendet: Montag, 19. Oktober 2020 05:42 An: pdns-users@mailman.powerdns.com Betreff: [Pdns-users] Error after upgrade I have a Centos 7 running PowerDNS after a update to mysql-community-server-8.0.22-1.el7.x86_64 mysql-community-devel-8.0.22-1.el7.x86_64 pdns-4.3.1-1pdns.el7.x86_64 pdns-backend-mysql-4.3.1-1pdns.el7.x86_64 pdns-tools-4.3.1-1pdns.el7.x86_64 I am receiving this messages ct 18 22:38:14 pdns_server: Backend error: GSQLBackend unable to find before/after (after) for domain_id 48 and qname 'xxxx': Could not execute mysql statement: select ordername from records where ordername > ? and domain_id=? and disabled=0 and ordername is not null order by 1 asc limit 1: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '>' Oct 18 22:38:16 pdns_server: Backend reported permanent error which prevented lookup (GSQLBackend unable to find before/after (after) for domain_id 48 and qname 'xxxx': Could not execute mysql statement: select ordername from records where ordername > ? and domain_id=? and disabled=0 and ordername is not null order by 1 asc limit 1: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '>'), aborting Oct 18 22:38:16 pdns_server: Backend error: GSQLBackend unable to find before/after (after) for domain_id 48 and qname 'xxxxxx': Could not execute mysql statement: select ordername from records where ordername > ? and domain_id=? and disabled=0 and ordername is not null order by 1 asc limit 1: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '>' I do not know if there some bug or requirement of the updated software I had and old version of pdns and I do not know if i need to update my database schema Can someone help me or point me in the right direction? thanks in advance Jorge Arenas
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
