Bug#997056: gmysql, gpgsql, gsqlite3 backend [...] will not receive any automatic, schema updates.

[Mathieu Roy]

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 <ze...@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