Re: [Odns-devel] Error message updating record

[Ferdinand K. <fk...@ay...>]

> I'm getting this error message when I update my zones:
> PRI: 10.0.3.28 - SEC: 10.0.3.4
> Warning: no access informations about the secondary: NOT updating it.
> 
> Where is it trying to locate access information from the secondary
> server?
> 
Odns tries to query some data from a seperated database (used for data of secondary dns servers i think).
odns is looking in a table called "odns_dns_servers" to get  $sec_dbname, BUT this table does not exist
(when i had i look in mysqldump.txt, which is used to create the odns database, i could not find the 
table)... :-(

                $sec_login = load_data_single($tb_dns_servers, "login", "", "WHERE ip LIKE '$sec_server'");
                $sec_passwd = load_data_single($tb_dns_servers, "passwd", "", "WHERE ip LIKE '$sec_server'");
                $sec_dbname = load_data_single($tb_dns_servers, "dbname", "", "WHERE ip LIKE '$sec_server'");
                $sec_tbname = load_data_single($tb_dns_servers, "tbname", "", "WHERE ip LIKE '$sec_server'");

                        if (mysql_select_db($sec_dbname)) {

                                $sql_query="DELETE FROM $sec_tbname WHERE domain LIKE '$domain' AND type LIKE 'slave'";
                                // print "$sql_query<br>";
                                $sql_result=mysql_query($sql_query,$sec_conn);

                                print "Ok<br>\n";

                        } else {

                                print "Warning: Unable to access db $sec_dbname on secondary server<br>\n";
                        }

I think that mysqldum.txt is uncomlete.
Try to create a table called "odns_dns_servers" and have a look at the php code to know which 
fields this table needs.

btw: I think the odns-project is dead ... :-(

cu,
Ferdinand