Try running the sql insert statement by hand.
Looks like an mysql error but it is not clear if it is
a login/authentication issue, which database it is using,
or if the user has permissions or if the sql insert statement is
failing.
Ken Jones
inter7.com
On Thursday 03 February 2005 5:06 pm, Derkowski, Matthew wrote:
> 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****************
