[Pdns-users] ENUM order value question! ? :)
Hi Guys, I wondered if anyone had seen similar results to me or if I need to reconfigure anything. Essentially Im using Power dns dig command to the power dns ENUM server returns results in order value; 8.3.4.0.9.1.7.1.9.7.4.4.e164.sip 120 IN NAPTR 74 3 "U" "E2U+sip" "!^(.*)$!sip:*241*\\1@1.2.3.4!" .8.3.4.0.9.1.7.1.9.7.4.4.e164.sip 120 IN NAPTR 76 13 "U" "E2U+sip" "!^(.*)$!sip:*311*+\\1@1.2.3.4!" .8.3.4.0.9.1.7.1.9.7.4.4.e164.sip 120 IN NAPTR 89 49 "U" "E2U+sip" "!^(.*)$!sip:*421*\\1@1.2.3.4!" .8.3.4.0.9.1.7.1.9.7.4.4.e164.sip 120 IN NAPTR 109 48 "U" "E2U+sip" "!^(.*)$!sip:*381*+\\1@1.2.3.4!" .8.3.4.0.9.1.7.1.9.7.4.4.e164.sip 120 IN NAPTR 216 2 "U" "E2U+sip" "!^(.*)$!sip:*205*00\\1@1.2.3.4!" .8.3.4.0.9.1.7.1.9.7.4.4.e164.sip 120 IN NAPTR 728 49 "U" "E2U+sip" "!^(.*)$!sip:*421*\\1@1.2.3.4!" .8.3.4.0.9.1.7.1.9.7.4.4.e164.sip 120 IN NAPTR 1050 3 "U" "E2U+sip" "!^(.*)$!sip:*241*\\1@1.2.3.4!" . However when capturing in wireshark on the wire I can see the answers sections returns in summary as; 8.3.4.0.9.1.7.1.9.7.4.4.e164.sip: type NAPTR, class IN, order 89, preference 49, flags U8.3.4.0.9.1.7.1.9.7.4.4.e164.sip: type NAPTR, class IN, order 109, preference 48, flags U8.3.4.0.9.1.7.1.9.7.4.4.e164.sip: type NAPTR, class IN, order 728, preference 49, flags U8.3.4.0.9.1.7.1.9.7.4.4.e164.sip: type NAPTR, class IN, order 216, preference 2, flags U8.3.4.0.9.1.7.1.9.7.4.4.e164.sip: type NAPTR, class IN, order 1050, preference 3, flags U8.3.4.0.9.1.7.1.9.7.4.4.e164.sip: type NAPTR, class IN, order 74, preference 3, flags U Can powerdns send out in the DNS response packet with an ordered by order value Answer section? As my stored procedure does it from a MySQL sense but not when populating the DNS response, is this configurable? Or is it purely left to the client to order and select accordingly? Merry Christmas to you all :) Thanks Jon ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] Order Value Decimal Place /leading Zero behaviour
Hi Guys, I am testing the Order Value in the content of NAPTR records using powerdns and MySQL database. I am trying to see an order value of 0.000322 which is lowest cost entry for one target carrier, and 0.0049 for a slightly more expensive carrier. So content looks like this in the records table; 0.000322 10 U E2U+sip !^(.*)$!sip:\\1...@carrier1.com!.0.0049 10 U E2U+sip !^(.*)$!sip:\\1...@carrier2.com!. When I do this I get a parsing error, I presume due to decimal point; Mar 5 10:05:42 localhost pdns[6207]: Exception: Parsing record content: expected digits at position 1 in '0.000322 10 U E2U+sip !^(.*)$!sip:\\1...@carrier1.com!.'Mar 5 10:05:42 localhost pdns[6207]: Exception building answer packet (Parsing record content: expected digits at position 1 in '0.000322 10 U E2U+sip !^(.*)$!sip:\\1...@carrier1.com!.') sending out servfail So I wondered if it would respect the leading 0's if I removed the decimal, so I have entries as; 322 10 U E2U+sip !^(.*)$!sip:\\1...@carrier1.com!.00049 10 U E2U+sip !^(.*)$!sip:\\1...@carrier2.com!. However when testing with dig I am returned; IN NAPTR 49 10 U E2U+sip !^(.*)$!sip:\\1...@carrier2.com! . IN NAPTR 322 10 U E2U+sip !^(.*)$!sip:\\1...@carrier1.com! . So doesnt seem to respect the leading 0's. Is there anyway I can resolve this so I can define values such as 0.000322 so in the example above it is the preference? Many thanks Jon ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] FW: Optimize Powerdns and Mysql for DB with 500K entries
instances and Unbound. Using dnsscope for my biggest instance I can see that I get these stats: 0.01% of questions answered within 50 usec (0.01%) 51.67% of questions answered within 100 usec (51.67%) 60.11% of questions answered within 200 usec (8.44%) 60.40% of questions answered within 300 usec (0.29%) 60.70% of questions answered within 400 usec (0.30%) 63.85% of questions answered within 800 usec (3.14%) 67.78% of questions answered within 1000 usec (3.93%) 97.93% of questions answered within 2.00 msec (30.15%) 99.71% of questions answered within 4.00 msec (1.78%) 99.97% of questions answered within 8.00 msec (0.26%) 100.00% of questions answered within 32.00 msec (0.03%) 100.00% of questions answered within 64.00 msec (0.00%) 0 responses (0.00%) older than 2 seconds Average non-late response time: 569.60 usec What kind of statistics are you seeing? Do you get large amounts of I/O wait on the server? Is your mysql innodb buffer pool size large enough to hold the entire table in RAM? Chris On 26/02/2015 2:40 AM, Jonathan Hunter wrote: Hi Guys, I appreciate there are optimization tips on the website, however I wondered if there are any specific tips for optimization when dealing with a records table or associated view of 500K rows in a Mysql backend database on a Virtual Centos Machine with 2 x 3Ghz processors, 1GB RAM and 20GB Memory. I am seeing some slow responses in terms of using dig to perform NAPTR record lookups. Any help would be great. Many thanks Jon ___ 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 ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] Optimize Powerdns and Mysql for DB with 500K entries
Hi Guys, I appreciate there are optimization tips on the website, however I wondered if there are any specific tips for optimization when dealing with a records table or associated view of 500K rows in a Mysql backend database on a Virtual Centos Machine with 2 x 3Ghz processors, 1GB RAM and 20GB Memory. I am seeing some slow responses in terms of using dig to perform NAPTR record lookups. Any help would be great. Many thanks Jon ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] longest-digit match in records name lookup NAPTR
Hi Guys, Sorry, last question for a while! Is it possible to disable longest-digit match in the name lookup? I only ask as running queries on the following entries (shown below from records table) using for example a dig to NAPTR 4.3.2.1.5.5.5.4.0.7.1.0.0.e164.sip.mn, the call is always routed tocarrier 3, where as Id like to be in a position ideally where it would pickup the wildcard with the higher priority (carrier1.com) ideally. Is it an option or not designed due to RFC? Thanks Jon mysql select * from records;++---+-+---++---+--+-+--+---+--+| id | domain_id | name| type | content | ttl | prio | change_date | disabled | ordername | auth |++---+-+---++---+--+-+--+---+--+ | 5 | 1 | *.1.0.0.e164.sip.mn | NAPTR | 1 1 U E2U+sip !^(.*)$!sip:\\1...@carrier1.com! . | 120 | NULL |NULL |0 | NULL |1 || 6 | 1 | *.1.0.0.e164.sip.mn | NAPTR | 3 10 U E2U+sip !^(.*)$!sip:\\1...@carrier2.com!. | 120 | NULL | NULL |0 | NULL |1 || 7 | 1 | *.5.5.5.4.0.7.1.0.0.e164.sip.mn | NAPTR | 5 10 U E2U+sip !^(.*)$!sip:\\1...@carrier3.com!. | 120 | NULL |NULL |0 | NULL |1 |++---+-+---++---+--+-+--+---+--+ ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] Multiple Entries in the Content field of NAPTR records.
Hi All, Is it possible when implementing NAPTR records in the records table to add multiple entries within the content field of a record? Im just trying to reduce the number of entries in the database, so wondered if I could have more than one content entry, and if so how do you split them up? So for example I have; select * from records;++---+---+---+-+---+--+-+| id | domain_id | name | type | content | ttl | prio | change_date |++---+---+---+-+---+--+-+ | 27 | 1 | *.0.3.7.7.4.4.e164.sip.mn | NAPTR | 2 10 U E2U+sip !^(.*)$!sip:\\1@195.219.240.46!. | 120 | NULL |NULL || 26 | 1 | *.0.3.7.7.4.4.e164.sip.mn | NAPTR | 2 10 U E2U+sip !^(.*)$!sip:\\1@195.219.240.50!. | 120 | NULL |NULL | Can I add both 2 10 U E2U+sip !^(.*)$!sip:\\1@195.219.240.46!. and 2 10 U E2U+sip !^(.*)$!sip:\\1@195.219.240.50!. into the content of id 27 without breaking a query? Many thanks Jon ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] Modify Records Table-Time of Day records
Hi Guys, I have implemented an ENUM server using powerdns and its working well. I store data of course in the powerdns database, and in particular the records table. Is it possible to modify the structure of the records table, to add new fields? Also has anyone implemented Time of day routing with ENUM and powerdns previously? Any help would be great. Many thanks Jon ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3
Hi, Yes that works great, I have modified slightly so that with the SBC Im using it removes the +44 and then inserts the remaining digits into the SIP request; 100 10 U E2U+sip !^44(.*)$!sip:\\1@10.10.10.10! . So if for example query is for 44123456789, the sip request will be 123456789@10.10.10.10 after the query thanks to the regex above. Many thanks to Aki for the help! Jon Date: Thu, 5 Jun 2014 20:37:22 +0300 From: cmo...@youzen.ext.b2.fi To: hunter...@hotmail.com CC: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3 mysql update records set content = '100 10 U E2U+sip !^+44(.*)$!sip:1@10.10.10.10! .' where type = 'NAPTR'; This works. Aki Tuomi On Thu, Jun 05, 2014 at 06:50:07PM +0300, Aki Tuomi wrote: I need to verify if this is a bug in 3.3 first (or someone else ofc). Aki On Thu, Jun 05, 2014 at 03:15:16PM +, Jonathan Hunter wrote: Hi Aki, In fact on closer inspection its version 3.3-2. Any comments/help appreciated. Thanks Jon From: hunter...@hotmail.com To: cmo...@youzen.ext.b2.fi Date: Thu, 5 Jun 2014 12:14:03 + CC: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3 Hi Aki, Thanks for the response, its version 3.3; pdns_control version3.3 Thanks Jon Date: Thu, 5 Jun 2014 14:55:51 +0300 From: cmo...@youzen.ext.b2.fi To: hunter...@hotmail.com CC: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3 On Thu, Jun 05, 2014 at 11:44:23AM +, Jonathan Hunter wrote: Hi Guys, Sorry to trouble you all, just wondered if anyone can help. I am using Powerdns as an ENUM server, and for single records its working well, however for wildcard entries I am having issues. Im sure its just syntax from my point of view, however looking at the associated RFCs and guides it all looks good. I add a wildcard entry such as below, where query is something like; 6.6.6.9.9.3.4.3.4.1.4.4.test.domain Now with the query number, I want to store this as a variable, prefix it then send it out as a SIP URI. So I have added an entry in records such as below; INSERT INTO records (id,domain_id,name,type,content,ttl)VALUES('16','3','*.test.domain','NAPTR','100 10 U E2U+sip !^\\+44(.*)$!sip:\\1@10.10.10.10! .','120'); With the idea that the query number will be stored in the back-referenced parameter \\1 and all will be well and I can use it to generate the request. However once I add this, then send a query into the DNS server I get; Exception: Unable to parse DNS TXT !^\\+44(.*)$!sip:\\1@10.10.10.10! Does anyone have any working wildcard examples I can reference as its quite frustrating now! Many thanks Jon Which version are you running? ___ 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 ___ 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] NAPTR wildcard records on PDNS version 3.3
Hi Aki, Thanks for the response, its version 3.3; pdns_control version3.3 Thanks Jon Date: Thu, 5 Jun 2014 14:55:51 +0300 From: cmo...@youzen.ext.b2.fi To: hunter...@hotmail.com CC: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3 On Thu, Jun 05, 2014 at 11:44:23AM +, Jonathan Hunter wrote: Hi Guys, Sorry to trouble you all, just wondered if anyone can help. I am using Powerdns as an ENUM server, and for single records its working well, however for wildcard entries I am having issues. Im sure its just syntax from my point of view, however looking at the associated RFCs and guides it all looks good. I add a wildcard entry such as below, where query is something like; 6.6.6.9.9.3.4.3.4.1.4.4.test.domain Now with the query number, I want to store this as a variable, prefix it then send it out as a SIP URI. So I have added an entry in records such as below; INSERT INTO records (id,domain_id,name,type,content,ttl)VALUES('16','3','*.test.domain','NAPTR','100 10 U E2U+sip !^\\+44(.*)$!sip:\\1@10.10.10.10! .','120'); With the idea that the query number will be stored in the back-referenced parameter \\1 and all will be well and I can use it to generate the request. However once I add this, then send a query into the DNS server I get; Exception: Unable to parse DNS TXT !^\\+44(.*)$!sip:\\1@10.10.10.10! Does anyone have any working wildcard examples I can reference as its quite frustrating now! Many thanks Jon Which version are you running? ___ 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] NAPTR wildcard records on PDNS version 3.3
Hi Aki, In fact on closer inspection its version 3.3-2. Any comments/help appreciated. Thanks Jon From: hunter...@hotmail.com To: cmo...@youzen.ext.b2.fi Date: Thu, 5 Jun 2014 12:14:03 + CC: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3 Hi Aki, Thanks for the response, its version 3.3; pdns_control version3.3 Thanks Jon Date: Thu, 5 Jun 2014 14:55:51 +0300 From: cmo...@youzen.ext.b2.fi To: hunter...@hotmail.com CC: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3 On Thu, Jun 05, 2014 at 11:44:23AM +, Jonathan Hunter wrote: Hi Guys, Sorry to trouble you all, just wondered if anyone can help. I am using Powerdns as an ENUM server, and for single records its working well, however for wildcard entries I am having issues. Im sure its just syntax from my point of view, however looking at the associated RFCs and guides it all looks good. I add a wildcard entry such as below, where query is something like; 6.6.6.9.9.3.4.3.4.1.4.4.test.domain Now with the query number, I want to store this as a variable, prefix it then send it out as a SIP URI. So I have added an entry in records such as below; INSERT INTO records (id,domain_id,name,type,content,ttl)VALUES('16','3','*.test.domain','NAPTR','100 10 U E2U+sip !^\\+44(.*)$!sip:\\1@10.10.10.10! .','120'); With the idea that the query number will be stored in the back-referenced parameter \\1 and all will be well and I can use it to generate the request. However once I add this, then send a query into the DNS server I get; Exception: Unable to parse DNS TXT !^\\+44(.*)$!sip:\\1@10.10.10.10! Does anyone have any working wildcard examples I can reference as its quite frustrating now! Many thanks Jon Which version are you running? ___ 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 ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users