I'm trying to use an arpa zone in mysql-bind. This is currently how I have the table laid out:
1.168.192.in-addr.arpa | 259200 | SOA | ns.somewhere.com. hostmaster.somewhere.com. 2004090201 21600 900 604800 3600 1.168.192.in-addr.arpa | 259200 | NS | ns.somewhere.com. 192.168.1.33 | 259200 | PTR | somepc.somewhere.com.
This doesn't appear to be working though. How should the table look for an ARPA zone?
I'm stumped by the exact same problem. Did you ever figure it out?
Change the last line to read as follows:
33.1.168.192 | 259200 | PTR | somepc.somewhere.com.
Wasn't so hard after all :o)
for me, the following line works: 33.1.168.192.in-addr.arpa | 259200 | PTR | somepc.somewhere.com.
Magnus
Hello friends,
Reading this forum I could configure well my arpa zones but I have a problem. I have a network that is not a full class C like:
192.168.0.0/25
So it starts fron 0 and goes until 127. I wrote this zones in named.conf like this:
0-127.0.168.192.in-addr.arpa
But mysql-bind can not find any SOA register for this kind of domain. I don't know what to to so I change the zone to a full class C and it works.
How can I solve this SOA problem? Any ideas?
Att,
Nataniel Klug
I have just changed table name in named.conf and it's done. Now I have my classes all working. Just for didatic reasons and someone who might need:
--- named.conf --- zone "0-127.166.101.200.in-addr.arpa" IN { type master; notify no; database "mysqldb bind 200_101_166 localhost USER PASS"; };
--- dump of 200_101_166 mysql bind table --- CREATE TABLE IF NOT EXISTS `200_101_166` ( `name` varchar(128) default NULL, `ttl` bigint(20) unsigned default '3600', `rdtype` varchar(128) NOT NULL default '', `rdata` varchar(128) NOT NULL default '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
INSERT INTO `200_101_166` (`name`, `ttl`, `rdtype`, `rdata`) VALUES ('0-127.166.101.200.in-addr.arpa', 3600, 'SOA', 'cnett.com.br. dns.cnett.com.br. 2008121701 2H 2M 1W 1H'), ('0-127.166.101.200.in-addr.arpa', 3600, 'NS', 'ns1.cnett.com.br'), ('0-127.166.101.200.in-addr.arpa', 3600, 'NS', 'ns2.cnett.com.br');
Any questions you have fell free to ask!
Log in to post a comment.
I'm trying to use an arpa zone in mysql-bind. This is currently how I have the table laid out:
1.168.192.in-addr.arpa | 259200 | SOA | ns.somewhere.com. hostmaster.somewhere.com. 2004090201 21600 900 604800 3600
1.168.192.in-addr.arpa | 259200 | NS | ns.somewhere.com.
192.168.1.33 | 259200 | PTR | somepc.somewhere.com.
This doesn't appear to be working though. How should the table look for an ARPA zone?
I'm stumped by the exact same problem. Did you ever figure it out?
Change the last line to read as follows:
33.1.168.192 | 259200 | PTR | somepc.somewhere.com.
Wasn't so hard after all :o)
for me, the following line works:
33.1.168.192.in-addr.arpa | 259200 | PTR | somepc.somewhere.com.
Magnus
Hello friends,
Reading this forum I could configure well my arpa zones but I have a problem. I have a network that is not a full class C like:
192.168.0.0/25
So it starts fron 0 and goes until 127. I wrote this zones in named.conf like this:
0-127.0.168.192.in-addr.arpa
But mysql-bind can not find any SOA register for this kind of domain. I don't know what to to so I change the zone to a full class C and it works.
How can I solve this SOA problem? Any ideas?
Att,
Nataniel Klug
I have just changed table name in named.conf and it's done. Now I have my classes all working. Just for didatic reasons and someone who might need:
--- named.conf ---
zone "0-127.166.101.200.in-addr.arpa" IN {
type master;
notify no;
database "mysqldb bind 200_101_166 localhost USER PASS";
};
--- dump of 200_101_166 mysql bind table ---
CREATE TABLE IF NOT EXISTS `200_101_166` (
`name` varchar(128) default NULL,
`ttl` bigint(20) unsigned default '3600',
`rdtype` varchar(128) NOT NULL default '',
`rdata` varchar(128) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
INSERT INTO `200_101_166` (`name`, `ttl`, `rdtype`, `rdata`) VALUES
('0-127.166.101.200.in-addr.arpa', 3600, 'SOA', 'cnett.com.br. dns.cnett.com.br. 2008121701 2H 2M 1W 1H'),
('0-127.166.101.200.in-addr.arpa', 3600, 'NS', 'ns1.cnett.com.br'),
('0-127.166.101.200.in-addr.arpa', 3600, 'NS', 'ns2.cnett.com.br');
Any questions you have fell free to ask!