<div dir="ltr">
<p class="">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/">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 class="">on the master (in pdns.conf):</p><p class=""><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 class=""><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 class=""><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 class=""><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 class=""><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 class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: Reading random entropy from '/dev/urandom'</i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: This is a guarded instance of pdns</i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: UDP server bound to <a href="http://178.62.193.233:53">178.62.193.233:53</a></i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: TCP server bound to <a href="http://178.62.193.233:53">178.62.193.233:53</a></i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: PowerDNS Authoritative Server 3.4.3 (<a href="mailto:jenkins@autotest.powerdns.com">jenkins@autotest.powerdns.com</a>) (C) 2001-2015 PowerDNS.COM BV</i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: Using 64-bits mode. Built on 20150302135812 by <a href="mailto:root@autotest.powerdns.com">root@autotest.powerdns.com</a>, gcc 4.7.2.</i></span></p>
<p class=""><span class=""><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 class=""><span class=""><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 class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: Listening for HTTP requests on <a href="http://178.62.193.233:8081">178.62.193.233:8081</a></i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: Creating backend connection for TCP</i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: Master/slave communicator launching</i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: No new unfresh slave domains, 0 queued for AXFR already</i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: 1 domain for which we are master needs notifications</i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: Request to queue notification for domain '<a href="http://test.com">test.com</a>' was processed, but no valid nameservers or ALSO-NOTIFYs found. Not notifying!</i></span></p>
<p class=""><span class=""><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 class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: About to create 3 backend threads for UDP</i></span></p>
<p class=""><span class=""><i>Mar 7 12:19:50 ns3 pdns[27026]: Done launching threads, ready to distribute questions</i></span></p>
<p class=""><span class=""><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 class=""><span class=""><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 class=""><span class=""><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 class=""><span class=""><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 class=""><span class=""><i>Mar 7 12:19:52 ns3 pdns[25864]: Our pdns instance exited with code 0</i></span></p>
<p class=""><span class="">Mar 7 12:19:52 ns3 pdns[25864]: Respawning</span></p></div>