<html><head></head><body><div class="ydp59c6ae32yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div><div dir="ltr" data-setdir="false">Thanks Marcus</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><span><span class="ydp5f5f3ae3tlid-translation ydp5f5f3ae3translation" lang="en"><span title="">I did the updates of the database schemas (With some warnings on charset modifications, <span><span class="ydp4ed00667tlid-translation ydp4ed00667translation" lang="en"><span title="">but apparently the changes were made</span></span></span>)<br></span></span></span></div><div dir="ltr" data-setdir="false"><span><span class="ydp5f5f3ae3tlid-translation ydp5f5f3ae3translation" lang="en"><span title=""><br></span></span></span></div><div dir="ltr" data-setdir="false"><span><span class="ydp5f5f3ae3tlid-translation ydp5f5f3ae3translation" lang="en"><span title="">make the modifications from 3.4.0 to 4.1.0, 4.1.0 to 4.2.0 and 4.2.0 to 4.3.0 <br></span></span></span></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"> <span><span class="ydp4e832ebtlid-translation ydp4e832ebtranslation" lang="en"><span title="">but I keep getting the same error</span></span></span><br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">reading some post in internet ( I am not an expert on MySQL) they mention that this error: "I<span>s generally caused by comparing two strings of incompatible
collations or by attempting to select data of different collations into a
combined column"</span></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">But I do not know how correct this</div><div><br></div><div class="ydp59c6ae32signature"><br></div><div class="ydp59c6ae32signature" dir="ltr" data-setdir="false">Jorge Arenas Quezada <br></div><div class="ydp59c6ae32signature" dir="ltr" data-setdir="false">Aguascalientes, Ags Mexico <br></div><div class="ydp59c6ae32signature" dir="ltr" data-setdir="false">jorgeaaq@yahoo.com</div></div>
<div><br></div><div><br></div>
</div><div id="yahoo_quoted_3544481061" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Monday, October 19, 2020, 1:04:07 AM CDT, Markus Ehrlicher <markus.ehrlicher@komsa.de> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv5784906753">
<style><!--
#yiv5784906753
_filtered {}
_filtered {}
_filtered {}
#yiv5784906753
#yiv5784906753 p.yiv5784906753MsoNormal, #yiv5784906753 li.yiv5784906753MsoNormal, #yiv5784906753 div.yiv5784906753MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman", serif;}
#yiv5784906753 a:link, #yiv5784906753 span.yiv5784906753MsoHyperlink
{
color:#0563C1;
text-decoration:underline;}
#yiv5784906753 a:visited, #yiv5784906753 span.yiv5784906753MsoHyperlinkFollowed
{
color:#954F72;
text-decoration:underline;}
#yiv5784906753 p.yiv5784906753msonormal0, #yiv5784906753 li.yiv5784906753msonormal0, #yiv5784906753 div.yiv5784906753msonormal0
{
margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman", serif;}
#yiv5784906753 span.yiv5784906753E-MailFormatvorlage18
{
font-family:"Calibri", sans-serif;
color:#1F497D;}
#yiv5784906753 span.yiv5784906753E-MailFormatvorlage19
{
font-family:"Calibri", sans-serif;
color:windowtext;}
#yiv5784906753 .yiv5784906753MsoChpDefault
{
font-size:10.0pt;}
_filtered {}
#yiv5784906753 div.yiv5784906753WordSection1
{}
--></style>
<div>
<div class="yiv5784906753WordSection1">
<p class="yiv5784906753MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">Hello Jorge,</span></p>
<p class="yiv5784906753MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;"> </span></p>
<p class="yiv5784906753MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">I stumbled upon the same problem a few months ago. Here you can find the schema-updates:</span></p>
<p class="yiv5784906753MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;"><a rel="nofollow" target="_blank" href="https://github.com/PowerDNS/pdns/tree/master/modules/gmysqlbackend">https://github.com/PowerDNS/pdns/tree/master/modules/gmysqlbackend</a></span></p>
<p class="yiv5784906753MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;"> </span></p>
<p class="yiv5784906753MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">best regards,</span></p>
<p class="yiv5784906753MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;">Markus</span></p>
<p class="yiv5784906753MsoNormal"><span style="font-size:11.0pt;font-family:sans-serif;color:#1F497D;"> </span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<p class="yiv5784906753MsoNormal"><b><span style="font-size:11.0pt;font-family:sans-serif;">Von:</span></b><span style="font-size:11.0pt;font-family:sans-serif;"> Pdns-users <pdns-users-bounces@mailman.powerdns.com>
<b>Im Auftrag von </b>Jorge Arenas via Pdns-users<br>
<b>Gesendet:</b> Montag, 19. Oktober 2020 05:42<br>
<b>An:</b> pdns-users@mailman.powerdns.com<br>
<b>Betreff:</b> [Pdns-users] Error after upgrade</span></p>
</div>
</div>
<p class="yiv5784906753MsoNormal"> </p>
<div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">I have a Centos 7 running PowerDNS</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">after a update to
</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> mysql-community-server-8.0.22-1.el7.x86_64</span></p>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> mysql-community-devel-8.0.22-1.el7.x86_64</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> pdns-4.3.1-1pdns.el7.x86_64</span></p>
</div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> pdns-backend-mysql-4.3.1-1pdns.el7.x86_64<br>
pdns-tools-4.3.1-1pdns.el7.x86_64</span></p>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">I am receiving this messages
</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">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 '>'</span></p>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">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</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">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 '>'</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">I do not know if there some bug or requirement of the updated software
</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">I had and old version of pdns and I do not know if i need to update my database schema</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">Can someone help me or point me in the right direction?</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">thanks in advance</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">Jorge Arenas</span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
</div>
</div>
<div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="yiv5784906753MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
</div>
</div>
</div>
</div></div>
</div>
</div></body></html>