Re: [Pdns-users] Multiple Entries in the Content field of NAPTR records.

2015-02-23 Thread Peter van Dijk
Hello Jonathan,

On 20 Feb 2015, at 18:28 , Jonathan Hunter hunter...@hotmail.com wrote:

 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?

No, this will not work. One database row is one DNS record, there are no 
exceptions to this. What problem are you trying to solve by combining the 
records?

Kind regards,
-- 
Peter van Dijk
Netherlabs Computer Consulting BV - http://www.netherlabs.nl/


___
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.

2015-02-20 Thread Jonathan Hunter
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