DNS Zone Transfer Problem

I have come across a couple of threads where people had issues with zone transfers and they're here:
http://www.howtoforge.com/forums/showthread.php?t=34373
http://www.howtoforge.com/forums/showthread.php?t=32145&page=2

I am running Centos 5.3.

I went over these threads and did everything that was suggested: I upgraded to mydns-ng latest (1.2.8.27) and my zones are still not being transferred to the slave server.

Master:

Code:

[root@vnpws01 log]# mydns -v
mydns[10804]: AXFR is enabled
mydns[10804]: TCP ports are enabled
mydns[10804]: DNS UPDATE is not enabled
mydns[10804]: DNS NOTIFY is not enabled
mydns[10804]: DNS IXFR is not enabled
mydns[10804]: optional 'xfer' column found in 'dns_soa' table
mydns[10804]: mydns 1.2.8.27 started Mon Jul 13 16:19:48 2009 (listening on 3 addresses)

Slave:

Code:

[root@vnpws02 tmp]# mydns -v
mydns[10994]: AXFR is enabled
mydns[10994]: TCP ports are enabled
mydns[10994]: DNS UPDATE is not enabled
mydns[10994]: DNS NOTIFY is not enabled
mydns[10994]: DNS IXFR is not enabled
mydns[10994]: optional 'xfer' column found in 'dns_soa' table
mydns[10994]: mydns 1.2.8.27 started Mon Jul 13 16:18:39 2009 (listening on 3 addresses)

Contents of mydns.conf on both servers:

Code:

##
##  /etc/mydns.conf
##  Fri Sep 21 21:44:51 2007
##  For more information, see mydns.conf(5).
##


                                # DATABASE INFORMATION

db-host = localhost             # SQL server hostname
db-user = ispconfig             # SQL server username
db-password = xxxxxxxxxxxx # SQL server password
database = dbispconfig                  # MyDNS database name


                                # GENERAL OPTIONS

user = nobody                   # Run with the permissions of this user
group = nobody                  # Run with the permissions of this group
listen = *                      # Listen on these addresses ('*' for all)
no-listen =                     # Do not listen on these addresses


                                # CACHE OPTIONS

zone-cache-size = 1024          # Maximum number of elements stored in the zone cache
zone-cache-expire = 60          # Number of seconds after which cached zones expires
reply-cache-size = 1024         # Maximum number of elements stored in the reply cache
reply-cache-expire = 30         # Number of seconds after which cached replies expire


                                # ESOTERICA

log = LOG_DAEMON                # Facility to use for program output (LOG_*/stdout/stderr)
pidfile = /var/run/mydns.pid    # Path to PID file
timeout = 120                   # Number of seconds after which queries time out
multicpu = 1                    # Number of CPUs installed on your system
recursive =                     # Location of recursive resolver
allow-axfr = yes                # Should AXFR be enabled?
allow-tcp = yes                 # Should TCP be enabled?
allow-update = no               # Should DNS UPDATE be enabled?
ignore-minimum = no             # Ignore minimum TTL for zone?
soa-table = dns_soa                     # Name of table containing SOA records
rr-table = dns_rr                       # Name of table containing RR data
notify-enabled = no             # Enable notify from updates
notify-source = 0.0.0.0         # Source address for ipv4 notify messages
notify-source6 = 0.0.0.0        # Source address for ipv6 notify messages
soa-where =                     # Extra WHERE clause for SOA queries
rr-where =                      # Extra WHERE clause for RR queries

The mydns --create-tables command yields:

Code:

[root@vnpws01 log]# /usr/sbin/mydns --create-tables
--
--  Table layouts for mydns 1.2.8.27 (Jul 2009)
--  Copyright (C) 2002-2005 Don Moore  2007-2008 Howard Wilkinson
--
--  You might create these tables with a command like:
--
--    $ mydns --create-tables | mysql -hHOST -p -uUSER DATABASE
--
--

--
--  Table structure for table 'dns_soa' (zones of authority)
--
CREATE TABLE IF NOT EXISTS dns_soa (
  id         INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  origin     CHAR(255) NOT NULL,
  ns         CHAR(255) NOT NULL,
  mbox       CHAR(255) NOT NULL,
  serial     INT UNSIGNED NOT NULL default '1',
  refresh    INT UNSIGNED NOT NULL default '28800',
  retry      INT UNSIGNED NOT NULL default '7200',
  expire     INT UNSIGNED NOT NULL default '604800',
  minimum    INT UNSIGNED NOT NULL default '86400',
  ttl        INT UNSIGNED NOT NULL default '86400',
   xfer      CHAR(255) DEFAULT NULL,
  UNIQUE KEY (origin)
) Engine=MyISAM;

--
--  Table structure for table 'dns_rr' (resource records)
--
CREATE TABLE IF NOT EXISTS dns_rr (
  id         INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  zone       INT UNSIGNED NOT NULL,
  name       CHAR(64) NOT NULL,
  data       VARBINARY(128) NOT NULL,
  aux        INT UNSIGNED NOT NULL,
  ttl        INT UNSIGNED NOT NULL default '86400',
  type       ENUM('A','AAAA','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT'),
  UNIQUE KEY rr (zone,name,type,data)
) Engine=MyISAM;

[root@vnpws01 log]#

Please help in any way.

Thanks.

 

Yep. I have attached a pic. One question. Is the zone transfer done automatically or am I supposed to initiate it with mydnsimport? My setup is also a multiserver setup. Probably should not make a difference.