MySQL BIND SDB Driver / Discussion / Help: layout of arpa zone

Shaun - 2004-09-22

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?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andreas Lund - 2006-02-13
  
  I'm stumped by the exact same problem. Did you ever figure it out?
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andreas Lund - 2006-02-14
  
  Change the last line to read as follows:
  
  33.1.168.192 | 259200 | PTR | somepc.somewhere.com.
  
  Wasn't so hard after all :o)
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Magnus Heinz - 2007-01-02
    
    for me, the following line works:
    33.1.168.192.in-addr.arpa | 259200 | PTR | somepc.somewhere.com.
    
    Magnus
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Nataniel Klug - 2008-12-30
  
  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
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Nataniel Klug - 2008-12-30
    
    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!
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

layout of arpa zone

Forums

Help

layout of arpa zone document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

layout of arpa zone