<div dir="ltr">Bert, you were spot on. One of the NS hostnames wasn't resolving properly and that got it fixed. The only thing that was a bit surprising is that the log was in both cases telling me that the binlog_format was set to statement and had issues with it. I fixed that by permanently setting binlog_format = mixed in the MySQL config (my.cnf). <div class="gmail_extra"><br><div class="gmail_quote">2015-03-07 19:37 GMT+01:00 bert hubert <span dir="ltr"><<a href="mailto:bert.hubert@powerdns.com" target="_blank">bert.hubert@powerdns.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>On Sat, Mar 07, 2015 at 06:52:00PM +0100, Melvin Mughal wrote:<br>
> I fixed the binary log warning by setting the variable to mixed (SET<br>
> SESSION binlog_format = 'ROW';). Now the syslog is just saying no valid<br>
> nameservers. Which config part did I make a mistake?<br>
<br>
</span>We can't sell w/o seeing what is in your database.<br>
<br>
Can you check al the entries for <a href="http://test2.com" target="_blank">test2.com</a> from the records table?<br>
<br>
Especially check if there are NS records, and if they have names that can<br>
either be resolved on the internet, or from the database.<br>
<br>
Bert<br>
<div><div><br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: Using 64-bits mode. Built on 20150302135812<br>
> by <a href="mailto:root@autotest.powerdns.com" target="_blank">root@autotest.powerdns.com</a>, gcc 4.7.2.<br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: PowerDNS comes with ABSOLUTELY NO WARRANTY.<br>
> This is free software, and you are welcome to redistribute it according to<br>
> the terms of the GPL version 2.<br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: Polled security status of version 3.4.3 at<br>
> startup, no known issues reported: OK<br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: Listening for HTTP requests on<br>
> <a href="http://178.62.193.234:8081" target="_blank">178.62.193.234:8081</a><br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: Creating backend connection for TCP<br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: Master/slave communicator launching<br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: No new unfresh slave domains, 0 queued for<br>
> AXFR already<br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: No master domains need notifications<br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: About to create 3 backend threads for UDP<br>
><br>
> Mar 7 12:47:54 ns3 pdns[2478]: Done launching threads, ready to distribute<br>
> questions<br>
><br>
> Mar 7 12:48:54 ns3 pdns[2478]: 1 domain for which we are master needs<br>
> notifications<br>
><br>
> Mar 7 12:48:54 ns3 pdns[2478]: Request to queue notification for domain '<br>
> <a href="http://test2.com" target="_blank">test2.com</a>' was processed, but no valid nameservers or ALSO-NOTIFYs found.<br>
> Not notifying!<br>
><br>
> Mar 7 12:49:54 ns3 pdns[2478]: No master domains need notifications<br>
><br>
> 2015-03-07 18:36 GMT+01:00 Melvin Mughal <<a href="mailto:melvin@mughal.nu" target="_blank">melvin@mughal.nu</a>>:<br>
><br>
> > Having an issue with master-slave configuration. I've used to setup both<br>
> > following the official installation guide (<br>
> > <a href="https://doc.powerdns.com/md/authoritative/installation/" target="_blank">https://doc.powerdns.com/md/authoritative/installation/</a>). The both work<br>
> > with the standard config and also the API is working. The problem: the<br>
> > master can't seem to notify the slave. The syslog is displaying some issue<br>
> > with a query. What piece of my database/config could be causing this? The<br>
> > settings I changed on both:<br>
> ><br>
> > on the master (in pdns.conf):<br>
> ><br>
> ><br>
> ><br>
</div></div>> > *allow-axfr-ips=178.62.95.98 (this is the slave server<br>
> > ip)disable-axfr=nomaster=yes*<br>
> ><br>
> > on the slave:<br>
> ><br>
> ><br>
> > *slave=yes*<br>
> ><br>
> > *set the supermaster to the master server ip.*<br>
<span>> ><br>
> > Here is the syslog of the master server. The slave is ok and reporting no<br>
> > errors in the syslog (= Done launching threads, ready to distribute<br>
> > questions):<br>
> ><br>
</span>> > *Mar 7 12:19:50 ns3 pdns[27026]: Reading random entropy from<br>
> > '/dev/urandom'*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: This is a guarded instance of pdns*<br>
> ><br>
> > *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><br>
> > <<a href="http://178.62.193.233:53" target="_blank">http://178.62.193.233:53</a>>*<br>
> ><br>
> > *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><br>
> > <<a href="http://178.62.193.233:53" target="_blank">http://178.62.193.233:53</a>>*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: PowerDNS Authoritative Server 3.4.3<br>
> > (<a href="mailto:jenkins@autotest.powerdns.com" target="_blank">jenkins@autotest.powerdns.com</a> <<a href="mailto:jenkins@autotest.powerdns.com" target="_blank">jenkins@autotest.powerdns.com</a>>) (C)<br>
> > 2001-2015 PowerDNS.COM BV*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: Using 64-bits mode. Built on<br>
> > 20150302135812 by <a href="mailto:root@autotest.powerdns.com" target="_blank">root@autotest.powerdns.com</a> <<a href="mailto:root@autotest.powerdns.com" target="_blank">root@autotest.powerdns.com</a>>,<br>
> > gcc 4.7.2.*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: PowerDNS comes with ABSOLUTELY NO<br>
<span>> > WARRANTY. This is free software, and you are welcome to redistribute it<br>
</span>> > according to the terms of the GPL version 2.*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: Polled security status of version 3.4.3<br>
> > at startup, no known issues reported: OK*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: Listening for HTTP requests on<br>
> > <a href="http://178.62.193.233:8081" target="_blank">178.62.193.233:8081</a> <<a href="http://178.62.193.233:8081" target="_blank">http://178.62.193.233:8081</a>>*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: Creating backend connection for TCP*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: Master/slave communicator launching*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: No new unfresh slave domains, 0 queued<br>
> > for AXFR already*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: 1 domain for which we are master needs<br>
> > notifications*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: Request to queue notification for domain<br>
> > '<a href="http://test.com" target="_blank">test.com</a> <<a href="http://test.com" target="_blank">http://test.com</a>>' was processed, but no valid nameservers or<br>
> > ALSO-NOTIFYs found. Not notifying!*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: Exiting because communicator thread died<br>
<span>> > with error: GSQLBackend unable to refresh domain_id 6: Failed to execute<br>
> > mysql_query, perhaps connection died? Err=1: Cannot execute statement:<br>
> > impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at<br>
> > least one table uses a storage engine limited to row-based logging. InnoDB<br>
> > is limited to row-logging when transaction isolation level is READ<br>
</span>> > COMMITTED or READ UNCOMMITTED.*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: About to create 3 backend threads for<br>
> > UDP*<br>
> ><br>
> > *Mar 7 12:19:50 ns3 pdns[27026]: Done launching threads, ready to<br>
> > distribute questions*<br>
> ><br>
> > *Mar 7 12:19:51 ns3 mysqld: 150307 12:19:51 [Warning] Aborted connection<br>
<span>> > 2396 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown<br>
</span>> > error)*<br>
> ><br>
> > *Mar 7 12:19:51 ns3 mysqld: 150307 12:19:51 [Warning] Aborted connection<br>
<span>> > 2398 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown<br>
</span>> > error)*<br>
> ><br>
> > *Mar 7 12:19:51 ns3 mysqld: 150307 12:19:51 [Warning] Aborted connection<br>
<span>> > 2399 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown<br>
</span>> > error)*<br>
> ><br>
> > *Mar 7 12:19:51 ns3 mysqld: 150307 12:19:51 [Warning] Aborted connection<br>
<span>> > 2400 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown<br>
</span>> > error)*<br>
> ><br>
> > *Mar 7 12:19:52 ns3 pdns[25864]: Our pdns instance exited with code 0*<br>
<span>> ><br>
> > Mar 7 12:19:52 ns3 pdns[25864]: Respawning<br>
> ><br>
<br>
</span>> _______________________________________________<br>
> Pdns-users mailing list<br>
> <a href="mailto:Pdns-users@mailman.powerdns.com" target="_blank">Pdns-users@mailman.powerdns.com</a><br>
> <a href="http://mailman.powerdns.com/mailman/listinfo/pdns-users" target="_blank">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br>
<br>
</blockquote></div><br></div></div>