PowerDNS 3.2-5 is having some issues connecting to my backend database (sqlite3).
beta powerdns # tail /var/log/errors.log May 7 20:12:41 localhost pdns: Caught an exception instantiating a backend: Unable to launch gsqlite3 connection: SQLite database '/etc/powerdns/database.sqlite' does not exist yet
But when i do:
beta powerdns # sqlite3 /etc/powerdns/database.sqlite SQLite version 18.104.22.168 2013-04-12 11:52:43 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select * from domains; 1|<myhostname>|||NATIVE|| sqlite>
sqlite3 It fetches the records and domains to my liking but not PowerDNS.
Same thing goes for a blank db without any domains or records, i can query it but not PowerDNS.
Followed this guide in order to setup the proper tables and columns: http://doc.powerdns.com/html/gsqlite.html#idp9379264
(without the DNSSEC part, i'll give that a go later on)
It obviously loads the sqlite3 module, and tries to connect to the backend, which doesn't work, so the ArchLinux package is fine i'm guessing.
* Link to package: https://www.archlinux.org/packages/comm … 6_64/pdns/
* chmod == 777
* chown == nobody:nobody (and tried root:root as default)
* running as root (not pdns)
Last edited by Torxed (2013-05-08 10:52:05)
The guides are vague in this regard but once you've just read the config twice you'll understand the logic.
First of all, no absolute paths for sqlite3, it should be:
Secondly, find your chroot, and point it to your database location or put your database here (whichever):
The folder structure should be:
And this py pointing to ./database.sqlite when starting sqlite3 in pdns, it should be able to lock on to the database.