[Pdns-users] Supermaster don't working, win32 SqlLite

[F L]

Hello.

I'm using PowerDNS 2.9.15 with SQLite Back'end, on a windows server 2003.
The machine has two IP's, I want PowerDNS to listen in just ONE of them.

I'm trying to use Supermaster on Win32. I have a Bind 9 master set up for
allow transfers to my powerdns machine (for the both IP's I have in this
machine), and the powerdns machine is listed as NS in my zones. In the bind
logs, I see that bind notifies to the slaves the changes in the zones. I
modify any zone and I see bind's log saying notifications have been sent,
but PowerDNS doesn't say anything.

My config-file is as follows:

local-address=81.19.98.116
launch=gsqlite
gsqlite-database=d:\powerdns_data\powerdns.sqlite
recursor=127.0.0.1:5300
slave
#query-local-address=81.19.98.116
query-logging=yes
loglevel=15
query-logging=yes
log-dns-details=yes
log-failed-updates=yes
use-logfile=yes
logfile=D:\powerdns_data\log.txt

webserver=yes
webserver-address=81.19.98.114
webserver-port=8053

My PowerDNS.sqlite dump:

BEGIN TRANSACTION;
create table domains (
              id  INTEGER PRIMARY KEY,
              name  VARCHAR(255) NOT NULL,
              master  VARCHAR(20) DEFAULT NULL,
              last_check INTEGER DEFAULT NULL,
              type  VARCHAR(6) NOT NULL,
              notified_serial   INTEGER DEFAULT NULL,
              account           VARCHAR(40) DEFAULT NULL
            );

CREATE TABLE records (
              id              INTEGER PRIMARY KEY,
              domain_id       INTEGER DEFAULT NULL,
              name            VARCHAR(255) DEFAULT NULL,
              type            VARCHAR(6) DEFAULT NULL,
              content         VARCHAR(255) DEFAULT NULL,
              ttl             INTEGER DEFAULT NULL,
              prio            INTEGER DEFAULT NULL,
              change_date     INTEGER DEFAULT NULL
            );
create table supermasters (
              ip          VARCHAR(25) NOT NULL,
              nameserver  VARCHAR(255) NOT NULL,
              account     VARCHAR(40) DEFAULT NULL
            );
INSERT INTO supermasters VALUES('81.19.98.113','ns67s.factoryw.com',NULL);
CREATE INDEX domain_id ON records(domain_id);
CREATE UNIQUE INDEX name_index ON domains(name);
CREATE INDEX nametype_index ON records(name,type);
CREATE INDEX rec_name_index ON records(name);
COMMIT;



Then, If I add a slave zone manually (with INSERT INTO domains
VALUES(1,'clubatletismoalzira.com','81.19.98.113',NULL,'SLAVE',NULL,NULL); )
to PowerDNS's table, I see this in the log:

Sat 27 Mar 20:37:27 (2): PowerDNS 2.9.15-WIN32 (C) 2001-2003 PowerDNS.COM BV
(Jan 30 2004, 03:34:16) starting up
Sat 27 Mar 20:37:27 (2): PowerDNS comes with ABSOLUTELY NO WARRANTY. This is
free software, and you are welcome to redistribute it according to the terms
of the GPL version 2.
Sat 27 Mar 20:37:27 (4): PowerDNS 2.9.15-WIN32 (C) 2001-2003 PowerDNS.COM BV
(Jan 30 2004, 03:33:58) starting up
Sat 27 Mar 20:37:27 (1): DNS Proxy launched, local port 31559, remote
127.0.0.1:5300
Sat 27 Mar 20:37:27 (1): Creating backend connection for TCP
Sat 27 Mar 20:37:27 (1): Master/slave communicator launching
Sat 27 Mar 20:37:27 (2): gsqlite: connection to
'd:\powerdns_data\powerdns.sqlite' succesful
Sat 27 Mar 20:37:27 (1): Launched webserver on 81.19.98.114:8053
Sat 27 Mar 20:37:27 (2): gsqlite: connection to
'd:\powerdns_data\powerdns.sqlite' succesful
Sat 27 Mar 20:37:27 (2): About to create 3 backend threads
Sat 27 Mar 20:37:27 (2): gsqlite: connection to
'd:\powerdns_data\powerdns.sqlite' succesful
Sat 27 Mar 20:37:27 (2): 1 slave domain needs checking
Sat 27 Mar 20:37:27 (2): Domain clubatletismoalzira.com is stale, master
serial 1080415805, our serial 0
Sat 27 Mar 20:37:27 (2): gsqlite: connection to
'd:\powerdns_data\powerdns.sqlite' succesful
Sat 27 Mar 20:37:27 (2): gsqlite: connection to
'd:\powerdns_data\powerdns.sqlite' succesful
Sat 27 Mar 20:37:27 (2): gsqlite: connection to
'd:\powerdns_data\powerdns.sqlite' succesful
Sat 27 Mar 20:37:27 (4): Done launching threads, ready to distribute
questions
Sat 27 Mar 20:37:27 (4): No serial for 'clubatletismoalzira.com' found -
zone is missing?
Sat 27 Mar 20:37:27 (1): AXFR started for 'clubatletismoalzira.com',
transaction started
Sat 27 Mar 20:37:27 (1): AXFR done for 'clubatletismoalzira.com', zone
committed
Sat 27 Mar 20:38:27 (2): 1 slave domain needs checking
Sat 27 Mar 20:38:27 (2): Domain clubatletismoalzira.com is stale, master
serial 1080415805, our serial 0
Sat 27 Mar 20:38:27 (2): gsqlite: connection to
'd:\powerdns_data\powerdns.sqlite' succesful
Sat 27 Mar 20:38:27 (4): No serial for 'clubatletismoalzira.com' found -
zone is missing?
Sat 27 Mar 20:38:27 (1): AXFR started for 'clubatletismoalzira.com',
transaction started
Sat 27 Mar 20:38:27 (1): AXFR done for 'clubatletismoalzira.com', zone
committed
Sat 27 Mar 20:39:27 (2): 1 slave domain needs checking
Sat 27 Mar 20:39:27 (2): Domain clubatletismoalzira.com is stale, master
serial 1080415805, our serial 0

And it keeps repeating the same (Domain clubatletismoalzira.com is stale,
master serial 1080415805, our serial 0) for years.