[Pdns-users] Mysql PTR

[AJ McKee]

Something I learned just last night.

Your domain name is going to be somthing like this.

13.13.13.in-addr.arpa and then each record for each host will be a PTR
record. so you would only have to enter in the last digits of the Ip
address. 

Your SQL looks like:

DOMAIN;
INSERT INTO domains VALUES (68, '141.168.192.in-addr.arpa', NULL, NULL,
'NATIVE', NULL, NULL);
RECORD
INSERT INTO records VALUES (640, 68, '3.141.168.192.in-addr.arpa',
'PTR', ns.yourdomain.com, 3600, 0, 1046327878);



I hope that helps.
AJ

-----Original Message-----
From: pdns-users-bounces at mailman.powerdns.com
[mailto:pdns-users-bounces at mailman.powerdns.com] On Behalf Of Graham
White
Sent: 28 February 2003 02:52
To: pdns-users at mailman.powerdns.com
Subject: [Pdns-users] Mysql PTR 


Tried to get a reverse lookup working on an ip but without much success,
I tried a few variations on the insert statement below, any ideas?
Thanks

insert into records (domain_id, name,type,content,ttl,prio) select id
,'test.com', 
'PTR', '192.168.50.1', 3600, 0 from domains where name='test.com';

Graham White
graham at bravenet.com