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

Peter van Dijk peter.van.dijk at powerdns.com
Mon Feb 23 10:26:01 UTC 2015


Hello Jonathan,

On 20 Feb 2015, at 18:28 , Jonathan Hunter <hunterj91 at 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 at 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 at 195.219.240.50!".       |   120 | NULL |        NULL |
> 
> Can I add both 2 10 "U" "E2U+sip" "!^(.*)$!sip:\\1 at 195.219.240.46!". and 2 10 "U" "E2U+sip" "!^(.*)$!sip:\\1 at 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/





More information about the Pdns-users mailing list