[Pdns-users] SQLite connection issues

[Devraj Mukherjee]

Hi Everyone,

I am trying to use PowerDNS with SQLite on CentOS 4.4 which has SQLite3

I can definately access the SQLite database as the user pdns, but PDNS
complains that it can't access the database. Is PDNS SQLite 3
compatible?

[root at woody opt]# su - pdns
[pdns at woody ~]$ sqlite3 /opt/pdns/db/pdns.db
SQLite version 3.3.3
Enter ".help" for instructions
sqlite> select * from supermasters;
sqlite>

PowerDNS messages
Jan 14 22:07:03 woody pdns[27901]: 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.
Jan 14 22:07:03 woody pdns[27901]: Creating backend connection for TCP
Jan 14 22:07:03 woody pdns[27901]: gsqlite: connection failed: Could
not connect to the SQLite database '/opt/pdns/db/pdns.db'
Jan 14 22:07:03 woody pdns[27901]: Caught an exception instantiating a
backend, cleaning up
Jan 14 22:07:03 woody pdns[27901]: TCP server is unable to launch
backends - will try again when questions come in: Unable to launch
gsqlite connection: Could not connect to the SQLite database
'/opt/pdns/db/pdns.db'
Jan 14 22:07:03 woody pdns[27901]: About to create 3 backend threads for UDP
Jan 14 22:07:03 woody pdns[27904]: Master/slave communicator launching
Jan 14 22:07:03 woody pdns[27904]: gsqlite: connection failed: Could
not connect to the SQLite database '/opt/pdns/db/pdns.db'
Jan 14 22:07:03 woody pdns[27904]: Caught an exception instantiating a
backend, cleaning up
Jan 14 22:07:03 woody pdns[27904]: Communicator thread died because of
error: Unable to launch gsqlite connection: Could not connect to the
SQLite database '/opt/pdns/db/pdns.db'
Jan 14 22:07:03 woody pdns[27906]: gsqlite: connection failed: Could
not connect to the SQLite database '/opt/pdns/db/pdns.db'



-- 
"I never look back darling, it distracts from the now", Edna Mode (The
Incredibles)