Menu

layout of arpa zone

Help
Shaun
2004-09-22
2013-04-22
  • Shaun

    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?

     
    • Andreas Lund

      Andreas Lund - 2006-02-13

      I'm stumped by the exact same problem. Did you ever figure it out?

       
    • Andreas Lund

      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)

       
      • Magnus Heinz

        Magnus Heinz - 2007-01-02

        for me, the following line works:
        33.1.168.192.in-addr.arpa | 259200 | PTR | somepc.somewhere.com.

        Magnus

         
    • Nataniel Klug

      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

       
      • Nataniel Klug

        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!

         

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.