[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pdns-users
Subject:    [Pdns-users] (no subject)
From:       Alejandro Flores Lopez <afloresl () wingunetworks ! com>
Date:       2015-08-04 22:10:32
Message-ID: CAEFr0c11ob2u4d7_pOs+SJGP5aPhn+deMX6+jdBHAQNcsqeKxw () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hey guys

Im using PDNS with mysql with 1 parent and 3 replications servers,  im
looking for the steps to have DNSSEC in some domains, checking some
documents i have found that is a very simple process, however when i try to
apply the steps i have an error on mysql


Securing zone with rsasha256 algorithm with default key size
Error: GSQLBackend unable to store key: Failed to execute mysql_query,
perhaps connection died? Err=1: Binary logging not possible. Message:
Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode
'STATEMENT'


Checking on mysql forums, the solution for this is the next instruction:

SET GLOBAL binlog_format = 'ROW';

I wonder if this instruction will have any impact on the replication
process or could create a problem on the operation.

Any comment is welcome.

Alex

[Attachment #5 (text/html)]

<div dir="ltr"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div \
dir="ltr"><br></div><div dir="ltr">Hey guys  </div><div dir="ltr"><br></div><div \
dir="ltr">Im using PDNS with mysql with 1 parent and 3 replications servers,   im \
looking for the steps to have DNSSEC in some domains, checking some documents i have \
found that is a very simple process, however when i try to apply the steps i have an \
error on mysql</div><div dir="ltr"><br></div><div dir="ltr"><br></div><div \
dir="ltr"><div dir="ltr">Securing zone with rsasha256 algorithm with default key \
size</div><div dir="ltr">Error: GSQLBackend unable to store key: Failed to execute \
mysql_query, perhaps connection died? Err=1: Binary logging not possible. Message: \
Transaction level &#39;READ-COMMITTED&#39; in InnoDB is not safe for binlog mode \
&#39;STATEMENT&#39;</div><div><br></div><div><br></div><div>Checking on mysql forums, \
the solution for this is the next instruction:</div></div><div \
dir="ltr"><br></div><div dir="ltr"><pre class="lang-sql prettyprint prettyprinted" \
style="margin-top:0px;padding:5px;border:0px;font-size:13px;overflow:auto;width:auto;max-height:600px;font-family:Consolas,Menlo,Monaco,&#39;Lucida \
Console&#39;,&#39;Liberation Mono&#39;,&#39;DejaVu Sans Mono&#39;,&#39;Bitstream Vera \
Sans Mono&#39;,&#39;Courier \
New&#39;,monospace,sans-serif;color:rgb(57,51,24);word-wrap:normal;background-color:rgb(238,238,238)"><code \
style="margin:0px;padding:0px;border:0px;font-family:Consolas,Menlo,Monaco,&#39;Lucida \
Console&#39;,&#39;Liberation Mono&#39;,&#39;DejaVu Sans Mono&#39;,&#39;Bitstream Vera \
Sans Mono&#39;,&#39;Courier New&#39;,monospace,sans-serif;white-space:inherit"><span \
class="kwd" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">SET</span><span \
class="pln" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> GLOBAL \
binlog_format </span><span class="pun" \
style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">=</span><span class="pln" \
style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="str" \
style="margin:0px;padding:0px;border:0px;color:rgb(128,0,0)">&#39;ROW&#39;</span><span \
class="pun" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">;</span></code></pre><div \
style="font-size:12.8000001907349px">I wonder if this instruction will have any \
impact on the replication process or could create a problem on the \
operation.</div><div style="font-size:12.8000001907349px"><br></div><div \
style="font-size:12.8000001907349px">Any comment is welcome.</div><div \
style="font-size:12.8000001907349px"><br></div><div \
style="font-size:12.8000001907349px">Alex<br \
style="font-size:12.8000001907349px"><div style="font-size:12.8000001907349px"><div \
dir="ltr"><div dir="ltr"><div \
dir="ltr"><br></div></div></div></div></div></div></div></div></div> </div>



_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


[prev in list] [next in list] [prev in thread] [next in thread]