[Pdns-users] Slave zone transferring but not saved (sqlite)

[bert hubert]

On Mon, Feb 28, 2005 at 12:08:56AM -0600, Ben Beuchler wrote:
> Greetings...
> 
> I am trying to import my first domains (from maradns) via AXFR.  I copied the
> schema info directly from the documentation and added a domain entry for the
> first domain I want to pull across:

Try this: 
insert into domains (name, master, type) values ('ds9a.nl', '213.244.168.210', 'SLAVE');
(modified of course). This makes sure your values go to the right fields.

I can't reproduce your problem, might it be that your sqlite database is not
writable by PowerDNS? I've tried to fake that, but I get an error in that
case:

Mar 04 12:11:49 AXFR started for 'ds9a.nl', transaction started
Mar 04 12:11:49 Communicator thread died because of error: Database failed
to start transaction: Error while retrieving SQLite query results

If everything is writable, I get:
$ ./pdns_server --no-config --launch=gsqlite --socket-dir=./ --daemon=no --local-port=5300 --slave --gsqlite-database=./sqlite.db  --loglevel=9
Mar 04 12:15:14 This is a standalone pdns
Mar 04 12:15:14 Listening on controlsocket in './pdns.controlsocket'
Mar 04 12:15:14 It is advised to bind to explicit addresses with the --local-address option
Mar 04 12:15:14 UDP server bound to 0.0.0.0:5300
Mar 04 12:15:14 TCP server bound to 0.0.0.0:5300
Mar 04 12:15:14 PowerDNS 2.9.18-svn (C) 2001-2005 PowerDNS.COM BV (Feb 23 2005, 08:54:47, gcc 3.3.5 (Debian 1:3.3.5-5)) starting up
Mar 04 12:15:14 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.
Mar 04 12:15:14 Creating backend connection for TCP
Mar 04 12:15:14 gsqlite: connection to './sqlite.db' succesful
Mar 04 12:15:14 About to create 3 backend threads for UDP
Mar 04 12:15:14 Master/slave communicator launching
Mar 04 12:15:14 gsqlite: connection to './sqlite.db' succesful
Mar 04 12:15:15 1 slave domain needs checking
Mar 04 12:15:15 gsqlite: connection to './sqlite.db' succesful
Mar 04 12:15:15 Domain ds9a.nl is stale, master serial 2005022001, our serial 0
Mar 04 12:15:15 gsqlite: connection to './sqlite.db' succesful
Mar 04 12:15:15 gsqlite: connection to './sqlite.db' succesful
Mar 04 12:15:15 No serial for 'ds9a.nl' found - zone is missing?
Mar 04 12:15:15 AXFR started for 'ds9a.nl', transaction started
Mar 04 12:15:15 gsqlite: connection to './sqlite.db' succesful
Mar 04 12:15:15 AXFR done for 'ds9a.nl', zone committed
Mar 04 12:15:15 Done launching threads, ready to distribute questions
Mar 04 12:16:15 All slave domains are fresh

I do note some slight differences though, your log has one more 'zone is
missing?' statements.

Can you do 'delete from records where id=(relevant id)' first?

-- 
http://www.PowerDNS.com      Open source, database driven DNS Software 
http://netherlabs.nl              Open and Closed source services