[Pdns-users] Mysql PTR
aj.mckee at nmtbmedia.com
Fri Feb 28 04:29:29 UTC 2003
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
Your SQL looks like:
INSERT INTO domains VALUES (68, '141.168.192.in-addr.arpa', NULL, NULL,
'NATIVE', NULL, NULL);
INSERT INTO records VALUES (640, 68, '188.8.131.52.in-addr.arpa',
'PTR', ns.yourdomain.com, 3600, 0, 1046327878);
I hope that helps.
From: pdns-users-bounces at mailman.powerdns.com
[mailto:pdns-users-bounces at mailman.powerdns.com] On Behalf Of Graham
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?
insert into records (domain_id, name,type,content,ttl,prio) select id
'PTR', '192.168.50.1', 3600, 0 from domains where name='test.com';
graham at bravenet.com
More information about the Pdns-users