Re: [Pdns-users] Can the zone data be edited from passing mysql queries?
Hi there, Yes i know it completely has a sql backend hence asking if I can edit the database to change the A record. Well i am trying to implement DNS system monitoring by which my servers will be monitored on particular port and if it couldnt connect then edit the zone file or remove the record do that traffic can be routed away. On 23 Jul 2013 11:00, Manish Rane manish...@gmail.com wrote: Hi Folks, Wondering if I can edit/change the static zone file as a result of certain bash script. Since the backend is Mysql can we really pass mysql statement by which I can update the zone file? Well, I am trying to write a script which will monitor the server on certain ports and it if fails to connect to the server it will delete or add the entry from zone file so that traffic will be routed to another server, possible? I am thinking same possibility with BIND but let me know if this can be possible with pdns OR does any one aware of such solution available in open source? ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Can the zone data be edited from passing mysql queries?
Hi, Op 23-7-2013 11:05, Blason rock schreef: Hi there, Yes i know it completely has a sql backend hence asking if I can edit the database to change the A record. Well i am trying to implement DNS system monitoring by which my servers will be monitored on particular port and if it couldnt connect then edit the zone file or remove the record do that traffic can be routed away. It would probably work providing the changes to the zone are accompanied by a change in the SOA-record for the update. But keep in mind that the TTL for the records can possibly create a long(er than you might want) failover-time. Regards, Ton ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] Power Dns Server As A Domain Name Registry(Parent Name Server)
Hello, Ip Address Of PowerDNS Server with MySQL Backend(Both Authoritative and Recursive) : 188.132.241.151 Ip Address Of Bind9 Server: 188.132.250.197 Here's the MySQL dump of domains table; mysql select * from domains; ++--++++-+-+ | id | name | master | last_check | type | notified_serial | account | ++--++++-+-+ | 5 | etc | yes| 1 | master | 1 | vixen | ++--++++-+-+ 1 row in set (0.00 sec) Here's the MySQL dump of records table; mysql select * from records; ++---+---+--+-+--+--+-+ | id | domain_id | name | type | content | ttl | prio | change_date | ++---+---+--+-+--+--+-+ | 41 | 5 | forum.etc | NS | ns1.forum.etc |1 |1 | 1 | | 43 | 5 | ns1.forum.etc | A| 188.132.250.197 |1 |1 | 1 | | 39 | 5 | forum.etc | SOA | 45325325325 |1 |1 | 1 | ++---+---+--+-+--+--+-+ 3 rows in set (0.00 sec) Here's the records file input for the master zone of forum.etc created in Bind9 Server; $ttl 38400 forum.etc.INSOAns1. info.forum.etc. ( 1374623190 10800 3600 604800 38400 ) forum.etc.INNSns1. ns1 IN A 188.132.250.197 www IN A 94.101.88.30 After i've replaced my pc's dns server ip to PowerDns Server, here's the nslookup dump for both forum.etc and ns1.forum.etc; C:\Users\vixennslookup forum.etc Server:static-151-241-132-188.sadecehosting.net Address: 188.132.241.151 Name: forum.etc C:\Users\vixennslookup ns1.forum.etc Server: static-151-241-132-188.sadecehosting.net Address: 188.132.241.151 Name: ns1.forum.etc Address: 188.132.250.197 On the web browser of my pc, when i typed http://ns1.forum.etc i'm getting an Apache test page of the Bind9 Server and it' ok. But, if i type http://www.forum.etc it can't connect to the ip address which i've added in zone records of Bind9 Server. If you need anything more, please let me know. Thanks. ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Can the zone data be edited from passing mysql queries?
PowerDNS is database driven. Read the docs, or even just the features. On Monday, July 22, 2013, Manish Rane wrote: Hi Folks, Wondering if I can edit/change the static zone file as a result of certain bash script. Since the backend is Mysql can we really pass mysql statement by which I can update the zone file? Well, I am trying to write a script which will monitor the server on certain ports and it if fails to connect to the server it will delete or add the entry from zone file so that traffic will be routed to another server, possible? I am thinking same possibility with BIND but let me know if this can be possible with pdns OR does any one aware of such solution available in open source? -- Genius might be described as a supreme capacity for getting its possessors into trouble of all kinds. -- Samuel Butler ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Power Dns Server As A Domain Name Registry(Parent Name Server)
Hello, Ip Address Of PowerDNS Server with MySQL Backend(Both Authoritative and Recursive) : 188.132.241.151 Ip Address Of Bind9 Server: 188.132.250.197 Here's the MySQL dump of domains table; mysql select * from domains; ++--++++-+-+ |* id | name | master | last_check | type | notified_serial | account |*++--++++-+-+ |* 5 | etc | yes| 1 | master | 1 | vixen |*++--++++-+-+ 1 row in set (0.00 sec) Here's the MySQL dump of records table; mysql select * from records; ++---+---+--+-+--+--+-+ |* id | domain_id | name | type | content | ttl | prio |*change_date | ++---+---+--+-+--+--+-+ |* 41 | 5 | forum.etc | NS | ns1.forum.etc |1 | 1*|* 1 |*|* 43 | 5 | ns1.forum.etc | A| 188.132.250.197 |1 |1*|* 1 |*|* 39 | 5 | forum.etc | SOA | 45325325325 |1 |1*|* 1 |*++---+---+--+-+--+--+-+ 3 rows in set (0.00 sec) Here's the records file input for the master zone of forum.etc created in Bind9 Server; $ttl 38400 forum.etc.INSOAns1. info.forum.etc. ( 1374623190 10800 3600 604800 38400 ) forum.etc.INNSns1. ns1 IN A 188.132.250.197 www IN A 94.101.88.30 After i've replaced my pc's dns server ip to PowerDns Server, here's the nslookup dump for both forum.etc and ns1.forum.etc; C:\Users\vixennslookup forum.etc Server:static-151-241-132-188.sadecehosting.net Address: 188.132.241.151 Name: forum.etc C:\Users\vixennslookup ns1.forum.etc Server: static-151-241-132-188.sadecehosting.net Address: 188.132.241.151 Name: ns1.forum.etc Address: 188.132.250.197 On the web browser of my pc, when i typed http://ns1.forum.etc i'm getting an Apache test page of the Bind9 Server and it' ok. But, if i type http://www.forum.etc it can't connect to the ip address which i've added in zone records of Bind9 Server. If you need anything more, please let me know. Thanks. ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Power Dns Server As A Domain Name Registry(Parent Name Server)
You're making several mistakes in setting up your delegation. First you've included an SOA in your PowerDNS records. Start Of Authority is exactly that. The etc zone needs to have only NS records and (if necessary) A glue records inside of the delegating server. The PDNS server is being given a record that indicates *IT* has authority for the forum.etc zone. Secondly you delegate to ns1.forum.etc but forum.etc has ns1. as it's listed delegate, which would be a zone/record that would not exist. Either add glue, or change that to correctly read ns1 or ns1.forum.etc. (note the trailing dot, VERY important) The PDNS server may also need an SOA for etc as well as depending on the resolver/resolver lib being used you might even need to have delegation in your PDNS for . (the root). On Tue, Jul 23, 2013 at 5:19 PM, Önem Özgülgen onemozgul...@gmail.com wrote: Hello, Ip Address Of PowerDNS Server with MySQL Backend(Both Authoritative and Recursive) : 188.132.241.151 Ip Address Of Bind9 Server: 188.132.250.197 Here's the MySQL dump of domains table; mysql select * from domains; ++--++++-+-+ | id | name | master | last_check | type | notified_serial | account | ++--++++-+-+ | 5 | etc | yes| 1 | master | 1 | vixen | ++--++++-+-+ 1 row in set (0.00 sec) Here's the MySQL dump of records table; mysql select * from records; ++---+---+--+-+--+--+-+ | id | domain_id | name | type | content | ttl | prio | change_date | ++---+---+--+-+--+--+-+ | 41 | 5 | forum.etc | NS | ns1.forum.etc |1 |1 | 1 | | 43 | 5 | ns1.forum.etc | A| 188.132.250.197 |1 |1 | 1 | | 39 | 5 | forum.etc | SOA | 45325325325 |1 |1 | 1 | ++---+---+--+-+--+--+-+ 3 rows in set (0.00 sec) Here's the records file input for the master zone of forum.etc created in Bind9 Server; $ttl 38400 forum.etc.INSOAns1. info.forum.etc. ( 1374623190 10800 3600 604800 38400 ) forum.etc.INNSns1. ns1 IN A 188.132.250.197 www IN A 94.101.88.30 After i've replaced my pc's dns server ip to PowerDns Server, here's the nslookup dump for both forum.etc and ns1.forum.etc; C:\Users\vixennslookup forum.etc Server:static-151-241-132-188.sadecehosting.net Address: 188.132.241.151 Name: forum.etc C:\Users\vixennslookup ns1.forum.etc Server: static-151-241-132-188.sadecehosting.net Address: 188.132.241.151 Name: ns1.forum.etc Address: 188.132.250.197 On the web browser of my pc, when i typed http://ns1.forum.etc i'm getting an Apache test page of the Bind9 Server and it' ok. But, if i type http://www.forum.etc it can't connect to the ip address which i've added in zone records of Bind9 Server. If you need anything more, please let me know. Thanks. ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users -- Genius might be described as a supreme capacity for getting its possessors into trouble of all kinds. -- Samuel Butler ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users