<div dir="ltr"><font face="arial, helvetica, sans-serif">I fixed the binary log warning by setting the variable to mixed (<span class="" style="color:rgb(0,0,0);line-height:20px;margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;background-image:initial;background-color:transparent;background-repeat:initial"><code style="margin:0px;padding:1px;border:0px;outline:0px;vertical-align:baseline;color:inherit;background-image:initial;background-color:inherit;background-repeat:initial">SET SESSION binlog_format = 'ROW';). <font face="arial, helvetica, sans-serif">Now the syslog is just saying no valid nameservers. Which config part did I make a mistake?</font></code></span></font><div>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: Using 64-bits mode. Built on 20150302135812 by <a href="mailto:root@autotest.powerdns.com">root@autotest.powerdns.com</a>, gcc 4.7.2.</span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.</span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: Polled security status of version 3.4.3 at startup, no known issues reported: OK</span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: Listening for HTTP requests on <a href="http://178.62.193.234:8081">178.62.193.234:8081</a></span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: Creating backend connection for TCP</span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: Master/slave communicator launching</span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: No new unfresh slave domains, 0 queued for AXFR already</span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: No master domains need notifications</span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: About to create 3 backend threads for UDP</span></p>
<p class=""><span class="">Mar 7 12:47:54 ns3 pdns[2478]: Done launching threads, ready to distribute questions</span></p>
<p class=""><span class="">Mar 7 12:48:54 ns3 pdns[2478]: 1 domain for which we are master needs notifications</span></p>
<p class=""><span class="">Mar 7 12:48:54 ns3 pdns[2478]: Request to queue notification for domain '<a href="http://test2.com">test2.com</a>' was processed, but no valid nameservers or ALSO-NOTIFYs found. Not notifying!</span></p>
<p class=""><span class="">Mar 7 12:49:54 ns3 pdns[2478]: No master domains need notifications</span></p></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-03-07 18:36 GMT+01:00 Melvin Mughal <span dir="ltr"><<a href="mailto:melvin@mughal.nu" target="_blank">melvin@mughal.nu</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">
<p>Having an issue with master-slave configuration. I've used to setup both following the official installation guide (<a href="https://doc.powerdns.com/md/authoritative/installation/" target="_blank">https://doc.powerdns.com/md/authoritative/installation/</a>). The both work with the standard config and also the API is working. The problem: the master can't seem to notify the slave. The syslog is displaying some issue with a query. What piece of my database/config could be causing this? The settings I changed on both:</p><p>on the master (in pdns.conf):</p><p><i><font color="#000000" face="arial, helvetica, sans-serif" style="background-color:rgb(255,255,255)"><span style="line-height:23.3999996185303px;white-space:nowrap">allow-axfr-ips=</span></font><span style="font-size:12.8000001907349px">178.62.95.98 (this is the slave server ip)</span><font color="#000000" face="arial, helvetica, sans-serif" style="background-color:rgb(255,255,255)"><br style="line-height:23.3999996185303px;white-space:nowrap"><span style="line-height:23.3999996185303px;white-space:nowrap">disable-axfr=no</span><br style="line-height:23.3999996185303px;white-space:nowrap"><span style="line-height:23.3999996185303px;white-space:nowrap">master=yes</span></font></i><br></p><p><font color="#000000" face="arial, helvetica, sans-serif" style="background-color:rgb(255,255,255)"><span style="line-height:23.3999996185303px;white-space:nowrap">on the slave:</span></font></p><p><i><span style="line-height:23.3999996185303px;white-space:nowrap;background-color:rgb(255,255,255)"><font color="#000000" face="arial, helvetica, sans-serif">slave=yes</font></span><font color="#000000" face="arial, helvetica, sans-serif" style="background-color:rgb(255,255,255)"><span style="line-height:23.3999996185303px;white-space:nowrap"><br></span></font></i></p><p><font color="#000000" face="arial, helvetica, sans-serif" style="background-color:rgb(255,255,255)"><span style="line-height:23.3999996185303px;white-space:nowrap"><i>set the supermaster to the master server ip.</i></span></font></p><p><font color="#000000" face="arial, helvetica, sans-serif" style="background-color:rgb(255,255,255)"><span style="line-height:23.3999996185303px;white-space:nowrap">Here is the syslog of the master server. The slave is ok and reporting no errors in the syslog (= </span></font>Done launching threads, ready to distribute questions):</p><p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Reading random entropy from '/dev/urandom'</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: This is a guarded instance of pdns</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: UDP server bound to <a href="http://178.62.193.233:53" target="_blank">178.62.193.233:53</a></i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: TCP server bound to <a href="http://178.62.193.233:53" target="_blank">178.62.193.233:53</a></i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: PowerDNS Authoritative Server 3.4.3 (<a href="mailto:jenkins@autotest.powerdns.com" target="_blank">jenkins@autotest.powerdns.com</a>) (C) 2001-2015 PowerDNS.COM BV</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Using 64-bits mode. Built on 20150302135812 by <a href="mailto:root@autotest.powerdns.com" target="_blank">root@autotest.powerdns.com</a>, gcc 4.7.2.</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Polled security status of version 3.4.3 at startup, no known issues reported: OK</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Listening for HTTP requests on <a href="http://178.62.193.233:8081" target="_blank">178.62.193.233:8081</a></i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Creating backend connection for TCP</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Master/slave communicator launching</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: No new unfresh slave domains, 0 queued for AXFR already</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: 1 domain for which we are master needs notifications</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Request to queue notification for domain '<a href="http://test.com" target="_blank">test.com</a>' was processed, but no valid nameservers or ALSO-NOTIFYs found. Not notifying!</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Exiting because communicator thread died with error: GSQLBackend unable to refresh domain_id 6: Failed to execute mysql_query, perhaps connection died? Err=1: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: About to create 3 backend threads for UDP</i></span></p>
<p><span><i>Mar 7 12:19:50 ns3 pdns[27026]: Done launching threads, ready to distribute questions</i></span></p>
<p><span><i>Mar 7 12:19:51 ns3 mysqld: 150307 12:19:51 [Warning] Aborted connection 2396 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown error)</i></span></p>
<p><span><i>Mar 7 12:19:51 ns3 mysqld: 150307 12:19:51 [Warning] Aborted connection 2398 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown error)</i></span></p>
<p><span><i>Mar 7 12:19:51 ns3 mysqld: 150307 12:19:51 [Warning] Aborted connection 2399 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown error)</i></span></p>
<p><span><i>Mar 7 12:19:51 ns3 mysqld: 150307 12:19:51 [Warning] Aborted connection 2400 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown error)</i></span></p>
<p><span><i>Mar 7 12:19:52 ns3 pdns[25864]: Our pdns instance exited with code 0</i></span></p>
<p><span>Mar 7 12:19:52 ns3 pdns[25864]: Respawning</span></p></div>
</blockquote></div><br></div>