OpenNetAdmin

Track. Automate. Configure.

Home About Features Community Develop
Download this project as a tar.gz file

DNS Bind Build Tool

druwoldt

16-03-2010 23:54:19

Dear All,

We are using the bind DNS build tool which is working for the domain but not the reverse. After a minor bit of coding I found

subnet record
id:domain_id:interface_id:dns_id:type:ttl:name:ebegin:notes:mx_preference:txt:srv_pri:srv_weight:srv_port
690:5:336:688:PTR:0::2010-02-08 10:42:27::0::0:0:0

The 336 interface_id does not exist in the interfaces table. I checked for this record and this is where the reverse is failing. How do I track what record this belongs to so I can fix it up.

Yours sincerely

David Ruwoldt

druwoldt

17-03-2010 17:34:13

Dear All,

Was able to solve this.

Found the entry test. The bad record was 690 in table dns

The A record (688) points at the interface table correctly to 335
The PTR record points wrongly to 336 which does not exist in the interface table.

From DNS table
id:domain_id:interface_id:dns_id:type:ttl:name:ebegin:notes:mx_preference:txt:srv_pri:srv_weight:srv_port
688:6:335:0:A:0:test:2010-02-08 10:37:38::0::0:0:0
690:5:336:688:PTR:0::2010-02-08 10:42:27::0::0:0:0

I deleted the PTR record and re-created it so the links were set correctly.
From DNS table
id:domain_id:interface_id:dns_id:type:ttl:name:ebegin:notes:mx_preference:txt:srv_pri:srv_weight:srv_port
688:6:335:0:A:0:test:2010-02-08 10:37:38::0::0:0:0
755:5:335:688:PTR:0::2010-03-16 18:02:40::0::0:0:0

I then had to delete the bad record from the database using mysql
DELETE FROM dns WHERE id=690;

The build now works :).

Yours sincerely

David Ruwoldt