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:\\[email protected]!" .  
So if for example query is for 44123456789, the sip request will be 
[email protected] 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: [email protected]
> To: [email protected]
> CC: [email protected]
> Subject: Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3
> 
> mysql> update records set content = '100 10 "U" "E2U+sip" 
> "!^\\\\+44(.*)$!sip:\\\\[email protected]!" .' 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 +0000, Jonathan Hunter wrote:
> > > Hi Aki,
> > > In fact on closer inspection its version 3.3-2.
> > > Any comments/help appreciated.
> > > Thanks
> > > Jon
> > > 
> > > From: [email protected]
> > > To: [email protected]
> > > Date: Thu, 5 Jun 2014 12:14:03 +0000
> > > CC: [email protected]
> > > 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: [email protected]
> > > > To: [email protected]
> > > > CC: [email protected]
> > > > Subject: Re: [Pdns-users] NAPTR wildcard records on PDNS version 3.3
> > > > 
> > > > On Thu, Jun 05, 2014 at 11:44:23AM +0000, 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:\\[email protected]!" .','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:\\[email protected]!"
> > > > > 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
> > > > > [email protected]
> > > > > http://mailman.powerdns.com/mailman/listinfo/pdns-users
> > > > 
> > >                                     
> > > 
> > > _______________________________________________
> > > Pdns-users mailing list
> > > [email protected]
> > > http://mailman.powerdns.com/mailman/listinfo/pdns-users                   
> > >                   
> 
> 
> 
> > _______________________________________________
> > Pdns-users mailing list
> > [email protected]
> > http://mailman.powerdns.com/mailman/listinfo/pdns-users
> 
                                          
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users

Reply via email to