[Pdns-users] Mysql PTR

AJ McKee 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,
INSERT INTO records VALUES (640, 68, '',
'PTR', ns.yourdomain.com, 3600, 0, 1046327878);

I hope that helps.

-----Original Message-----
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', '', 3600, 0 from domains where name='test.com';

Graham White
graham at bravenet.com

More information about the Pdns-users mailing list