[dnsadmin] dnsloadzone issue

[Derkowski, Matthew]

I cannot seem to get dnsloadzone to work,  I have included all my errors and mysql info below.  I ran these as root on the mysql database and get the errors below.  I have also run this as the dnsadmin user, that has full rights on this database, and the output is the same.  I can also drop this database and start over and it's the same errors.

 

 

Thanks,

Matt

 

 

****************log start****************

 

# ./dnsloadzone -p mysqlsec
error inserting data insert into records ( domain_id, host, val, type )         values ( "1", "*", "1W", "T")
error inserting data insert into records ( domain_id, host, val, type )         values ( "1", "ns.localhost", "", "N")
error inserting data insert into records ( domain_id, host, val, type )         values ( "1", "localhost", "127.0.0.1", "A")
error inserting data select domain_id from domains where domain ="127.in-addr.arpa"
mysql_error: Commands out of sync;  You can't run this command now
found duplicate domain 127.in-addr.arpa
error inserting data select domain_id from domains where domain ="1.1.1.in-addr.arpa"
mysql_error: Commands out of sync;  You can't run this command now
found duplicate domain 1.1.1.in-addr.arpa
error inserting data select domain_id from domains where domain ="2.2.2.in-addr.arpa"
mysql_error: Commands out of sync;  You can't run this command now
found duplicate domain 2.2.2.in-addr.arpa
error inserting data select domain_id from domains where domain ="domain1.com"
mysql_error: Commands out of sync;  You can't run this command now
found duplicate domain domain1.com
error inserting data select domain_id from domains where domain ="domain2.com"
mysql_error: Commands out of sync;  You can't run this command now
found duplicate domain domain2.com
error inserting data select domain_id from domains where domain ="domain3.com"
mysql_error: Commands out of sync;  You can't run this command now
found duplicate domain domain3.com
dnsloadzone: could not create records_idx index
mysql error: Commands out of sync;  You can't run this command now

 

 

 

# mysql -u root -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 4.0.22

 

 

 

+----------+
| Database |
+----------+
| dnsadmin |
| mysql    |
+----------+
5 rows in set (0.00 sec)

 

mysql> show tables;
+--------------------+
| Tables_in_dnsadmin |
+--------------------+
| domains            |
| options            |
| owners             |
| records            |
| slaves             |
+--------------------+
5 rows in set (0.00 sec)

 

mysql> SELECT * from domains;
+-----------+-----------+----------+
| domain_id | domain    | owner_id |
+-----------+-----------+----------+
|         1 | localhost |        0 |
+-----------+-----------+----------+
1 row in set (0.01 sec)

 

mysql> SELECT * from options;
+-----------+------------+------------------------------+
| option_id | bindoption | val                          |
+-----------+------------+------------------------------+
|         1 | directory  | /var/bind                    |
|         2 | forwarders |
                            |
|         3 | listen-on  | { 127.0.0.1;1.1.1.1; }; |
|         4 | blackhole  |  bogusnets;                  |
+-----------+------------+------------------------------+
4 rows in set (0.00 sec)

 

mysql> SELECT * from slaves;
Empty set (0.00 sec)

 

mysql> SELECT * from records;
Empty set (0.00 sec)

 

mysql> SELECT * from owners;
+----------+----------+----------+----------------+
| owner_id | username | password | clear_password |
+----------+----------+----------+----------------+
|        1 | root     |          |                |
+----------+----------+----------+----------------+
1 row in set (0.00 sec)

 

mysql>

 

****************log end****************