Re: [Pdns-users] Slaves are not updating after making changes on master
Going even further with debugging, I've found out that my mysql configurations were set to localhost only, so I though maybe that is the problem, but nothing, it didn't help. I've restored new VPS and installed from wheezy backports pdns version 3.4.4., configured everything and slaves just don't update after additional records. As I mentioned already, if I add new slave zone, all records are transferred, but afterwards none. If I sent notify for this domain, result is always: pdns[7807]: 1 domain for which we are master needs notifications pdns[7807]: No master domains need notifications and nothing gets updated. Servers are indeed behind the firewall, but I've tried to allow all traffic on port 53 and no success (I've even disabled completely firewall, so firewall is not a problem for sure). On 12.06.2015 22:05, Mislav Orsolic | Linux System Administrator wrote: Where exactly can I see/find this autoserial setting? I've checked both tables records (change_date) and domains (notified_serial) both have some values, it's not set to 0 or NULL on master and on slave in domains table notified_serial for both new and old domains is set to NULL + in records table, change_date is set to NULL for old/new domains. I've also tried to add on the slave On 12.06.2015 21:37, Aki Tuomi wrote: On Fri, Jun 12, 2015 at 09:23:35PM +0200, Mislav Orsolic | Linux System Administrator wrote: I've recently debugged even more this scenario and it seems like I'm unable to find solution. What bothers me is this: - every domain that was added in the past, after adding new record, new record is automatically transferred to the slave with any problem within next minute or two - every new domain that I add have problem when I add new record on the master server, it is not transferred to the slaves and the only way it is working is manually through pdns_control notify host domain OR changing directly in the database SOA record or last checked - in the end this is not solution, as I want it to be transferred automatically, just like it's working for old domains What could be the problem, any suggestions? If any log/setting is needed, let me know and I will provide the same. Maybe those older domains are using autoserial by having their serial set to 0? In this case, powerdns sets serial to highest change_date. Aki ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Slaves are not updating after making changes on master
I've recently debugged even more this scenario and it seems like I'm unable to find solution. What bothers me is this: - every domain that was added in the past, after adding new record, new record is automatically transferred to the slave with any problem within next minute or two - every new domain that I add have problem when I add new record on the master server, it is not transferred to the slaves and the only way it is working is manually through pdns_control notify host domain OR changing directly in the database SOA record or last checked - in the end this is not solution, as I want it to be transferred automatically, just like it's working for old domains What could be the problem, any suggestions? If any log/setting is needed, let me know and I will provide the same. On 11.05.2015 14:44, Mislav | sys admin wrote: No, I didn't update any SOA records. I've just tried that and it seems like this is not working for me, but I've figure it out if I change last_check to NULL, powerdns not only synchronize all DNS records, but it also update SOA record. Thanks @Peter On master server, every domain is set to MASTER, and on slave is set to SLAVE. On 11.05.2015 13:47, Aki Tuomi wrote: On Mon, May 11, 2015 at 09:14:51AM +0200, Mislav | sys admin wrote: I'm having problem with updating slaves after making changes on master. Slaves are not getting updated at all. After I type manually on the master server: Did you remember to update your SOA record serial to larger number as well? Aki -- Srdacan pozdrav | Best regards Mislav Orsolic | sys admin http://www.mislav.eu / https://www.linkedin.com/in/mislavorsolic ___ *T * +385 91 444 0275 *Skype:* mislav.orsolic ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Slaves are not updating after making changes on master
On Fri, Jun 12, 2015 at 09:23:35PM +0200, Mislav Orsolic | Linux System Administrator wrote: I've recently debugged even more this scenario and it seems like I'm unable to find solution. What bothers me is this: - every domain that was added in the past, after adding new record, new record is automatically transferred to the slave with any problem within next minute or two - every new domain that I add have problem when I add new record on the master server, it is not transferred to the slaves and the only way it is working is manually through pdns_control notify host domain OR changing directly in the database SOA record or last checked - in the end this is not solution, as I want it to be transferred automatically, just like it's working for old domains What could be the problem, any suggestions? If any log/setting is needed, let me know and I will provide the same. Maybe those older domains are using autoserial by having their serial set to 0? In this case, powerdns sets serial to highest change_date. Aki ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Slaves are not updating after making changes on master
Where exactly can I see/find this autoserial setting? I've checked both tables records (change_date) and domains (notified_serial) both have some values, it's not set to 0 or NULL on master and on slave in domains table notified_serial for both new and old domains is set to NULL + in records table, change_date is set to NULL for old/new domains. I've also tried to add on the slave On 12.06.2015 21:37, Aki Tuomi wrote: On Fri, Jun 12, 2015 at 09:23:35PM +0200, Mislav Orsolic | Linux System Administrator wrote: I've recently debugged even more this scenario and it seems like I'm unable to find solution. What bothers me is this: - every domain that was added in the past, after adding new record, new record is automatically transferred to the slave with any problem within next minute or two - every new domain that I add have problem when I add new record on the master server, it is not transferred to the slaves and the only way it is working is manually through pdns_control notify host domain OR changing directly in the database SOA record or last checked - in the end this is not solution, as I want it to be transferred automatically, just like it's working for old domains What could be the problem, any suggestions? If any log/setting is needed, let me know and I will provide the same. Maybe those older domains are using autoserial by having their serial set to 0? In this case, powerdns sets serial to highest change_date. Aki ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Slaves are not updating after making changes on master
Hello, On 11 May 2015, at 9:14, Mislav | sys admin wrote: * What is going wrong I'm having problem with updating slaves after making changes on master. Slaves are not getting updated at all. After I type manually on the master server: # pdns_control notify-host domain host then of course, it's get updated. What type did you set your domains to in the domains table? It looks like you want MASTER. Kind regards, -- Peter van Dijk PowerDNS.COM BV - https://www.powerdns.com/ ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Slaves are not updating after making changes on master
On Mon, May 11, 2015 at 09:14:51AM +0200, Mislav | sys admin wrote: I'm having problem with updating slaves after making changes on master. Slaves are not getting updated at all. After I type manually on the master server: Did you remember to update your SOA record serial to larger number as well? Aki ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Slaves are not updating after making changes on master
No, I didn't update any SOA records. I've just tried that and it seems like this is not working for me, but I've figure it out if I change last_check to NULL, powerdns not only synchronize all DNS records, but it also update SOA record. Thanks @Peter On master server, every domain is set to MASTER, and on slave is set to SLAVE. On 11.05.2015 13:47, Aki Tuomi wrote: On Mon, May 11, 2015 at 09:14:51AM +0200, Mislav | sys admin wrote: I'm having problem with updating slaves after making changes on master. Slaves are not getting updated at all. After I type manually on the master server: Did you remember to update your SOA record serial to larger number as well? Aki ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users