Package: pdns-server
Version: 4.4.1-1
Hello,
My pdns-server is currently unusable after upgrade due to a database issue
# pdnsutil list-keys
Zone Type Act Pub Size Algorithm ID
Location Keytag
------------------------------------------------------------------------------------------
Error: GSQLBackend unable to list keys: Unable to compile SQLite
statement : 'select cryptokeys.id, flags, active, published, content
from domains, cryptokeys where cryptokeys.domain_id=domains.id and
name=:domain': no such column: published (1)
According to the doc, that was to be expected
# zmore /usr/share/doc/pdns-backend-sqlite3/NEWS.Debian.gz
pdns (4.1.3-4) unstable; urgency=medium
The gmysql, gpgsql, gsqlite3 backend packages no longer provide automatic
database configuration using dbconfig-common. You can continue to use
previously created databases, but they will not receive any automatic
schema updates. For new installations, please see the README.Debian
files on how to initialize the schema.
-- Christian Hofstaedtler <z...@debian.org> Tue, 31 Jul 2018 11:00:00
+0800
There are the following scripts provided:
/usr/share/pdns-backend-sqlite3/schema
/usr/share/pdns-backend-sqlite3/schema/3.4.0_to_4.0.0_schema.sqlite3.sql
/usr/share/pdns-backend-sqlite3/schema/4.0.0_to_4.2.0_schema.sqlite3.sql
/usr/share/pdns-backend-sqlite3/schema/4.2.0_to_4.3.0_schema.sqlite3.sql
/usr/share/pdns-backend-sqlite3/schema/4.3.0_to_4.3.1_schema.sqlite3.sql
/usr/share/pdns-backend-sqlite3/schema/bind-dnssec.4.2.0_to_4.3.0_schema.sqlite3.sql
/usr/share/pdns-backend-sqlite3/schema/bind-dnssec.schema.sqlite3.sql
/usr/share/pdns-backend-sqlite3/schema/dnssec-3.x_to_3.4.0_schema.sqlite3.sql
/usr/share/pdns-backend-sqlite3/schema/nodnssec-3.x_to_3.4.0_schema.sqlite3.sql
/usr/share/pdns-backend-sqlite3/schema/schema.sqlite3.sql
Obviously, I am upgrading from 4.1.x to 4.4. So I have to guess what is
appropriate.
Is there a supported and recommended backend? I picked sqlite3 because
that seemed convenient, when I started using pdns. Now, if I have to
bother hand-tuning the database at every upgrade, conveniency is out of
the picture.
Regards
--
Mathieu Roy
