Running A MySQL-Based DNS Server: MyDNS - Page 3

3 Install dnscache

One very important thing to know about MyDNS is that it does not support external (recursive) DNS lookups, i.e. MyDNS will deliver answers only for domains that it is authoritative for! If you want to resolve other domains like, for example,, you will have to install a DNS resolver like dnscache on your system, and it has to be installed on a separate IP address. To find out why the DNS server (MyDNS) and the DNS resolver (dnscache) are separated like that, have a look here:

Normally, your ISP gives you IP addresses of name servers that you use for your internet connection at home or in your office so that your workstation can resolve names like The name server IP addresses are actually IP addresses of DNS resolvers like dnscache. Now if you want to give your customers your own name server IP addresses, you must set up a DNS resolver and give your customers the IP address of that DNS resolver.

Now, if you only have one IP address on your server, you could say, "Ok, I bind MyDNS to and dnscache to my public IP address to get around this bottleneck.". Please read here to find out why this is a bad idea:

If you do not want to install a DNS resolver on your system, you can skip this section.

Now lets say you have two public IP addresses, and, and you want MyDNS to listen on and dnscache to listen on

Do the following steps to install dnscache:

groupadd dns
useradd -M -g dns -s /sbin/nologin -c DNS-Cache-User dnscache
useradd -M -g dns -s /sbin/nologin -c TinyDNS-User tinydns
useradd -M -g dns -s /sbin/nologin -c DNSlog-User dnslog

Create the dnscache init script:

cd /usr/local/sbin
chmod 700 dnsctl
ln -s /usr/local/sbin/dnsctl /etc/init.d/dnsctl

Create the system startup links:

On Debian:

update-rc.d dnsctl defaults

On Fedora and RedHat:

chkconfig --levels 235 dnsctl on

Then we compile and install dnscache:

cd /usr/local/src
tar -zxvf ucspi-tcp-0.88.tar.gz
cd ucspi-tcp-0.88
make setup check

mkdir -p /var/package
chmod 1755 /var/package
cd /var/package
gunzip daemontools-0.76.tar
tar -xpf daemontools-0.76.tar
rm daemontools-0.76.tar
cd /var/package/admin/daemontools-0.76

cd /usr/local/src
tar -xvzf djbdns-1.05.tar.gz
cd djbdns-1.05
make setup check

dnscache-conf dnscache dnslog /etc/dnscache
ln -s /etc/dnscache /service
touch /etc/dnscache/root/ip/1.2.3

Now dnscache is listening on Now we have to tell MyDNS that it should listen on only. Therefore we have to change the listen directive in /etc/mydns.conf:

listen =

and restart MyDNS:

/etc/init.d/mydns restart

Now if you try to resolve domain names on, you should get an answer. E.g., to resolve, you can run

dig @

In the same way you should be able to resolve domains handled by MyDNS (e.g., but this time you dig

dig @

4 Getting The Zones And Records From The Primary To The Secondary DNS Server

If both the primary and the secondary DNS server use MyDNS, you have three possibilities to get the data from the primary to the secondary DNS server:

  1. The old-fashioned way: you can use zone transfers. Therefore, you must change allow-axfr = no to allow-axfr = yes in /etc/mydns.conf and restart MyDNS on the primary DNS server. In addition to that, you have to specify the secondary DNS server's IP address in the xfer column in the soa table for the zones that should be transferred. Plus, make sure the firewall on the primary DNS does not block port 53 (TCP and UDP).
  2. Both the primary and secondary DNS use the same MySQL database. There is one drawback with this solution: if the MySQL server fails, then both the primary and the secondary DNS will fail at the same time...
  3. The preferred solution: use MySQL database replication to transfer the data from the primary to the secondary DNS. Make sure the firewall on the primary DNS does not block the MySQL port (normally 3306).

I recommend that you use MySQL replication. I have written a very precise guide about how to set this up here: so I do not have to cover this topic here again.


Falko Timme

About Falko Timme

Falko Timme is an experienced Linux administrator and founder of Timme Hosting, a leading nginx business hosting company in Germany. He is one of the most active authors on HowtoForge since 2005 and one of the core developers of ISPConfig since 2000. He has also contributed to the O'Reilly book "Linux System Administration".

Share this page:

Suggested articles

3 Comment(s)

Add comment



If you have tried to wget from, you have not the right file. Mr Falko have posted the content here: /usr/local/sbin/dnsctl

If you are on linux, and are stumped, as I am, at "errno" error when compiling dnscache items, try read this: installing-dns-cache-with-djbdns

By: jamie

Thanks to debian for hiding 'sarge' in favour of v4.1 Also the packages required to install sarge are no longer available from any of the mirrors. So... either download 13 CD's OR don't bother.

 I know what my favoured option is.

 Frankly I don't see why Bind for windows doesn't support using mysql by default. It's pathetic. Just like apache which also wants constant restarts to recognise new hosts...

By: Anonymous

MyDNS 1.1.0 appears to support recursive lookups through the support of a second DNS server that can do recursive lookups.    This was a good thing to find as I was moving from BIND9 to MyDNS.

The /etc/mydns.conf has a variable [recursive] where I was able to enter the IP address.  This gave me what I needed to allow MyDNS to be a authoritative server while also providing a path for resolution for those who used the server as a name server on remote systems.