Bug#955867: opendmarc: Schema update script with ARC changes not present

[David Bürgin]

What we need to solve this properly is an additional dbconfig schema
migration that cleanly updates the previous database schema to the new
one. The migration script would have to be patched in and installed to
/usr/share/dbconfig-common/data/opendmarc/upgrade/mysql/1.4.0~beta1+dfsg-1.
It must also take into account our Debian patches in this area.

I think it is important to have this for a seamless upgrade experience,
however it is non-trivial work and needs to be written from scratch.
This work is perhaps best contributed by someone who uses the reporting
feature and who can test the migration properly and with real data. I
don’t use this feature and won’t be looking into it further.


-- 
David

Bug#955867: opendmarc: Schema update script with ARC changes not present

[boson]

Package: opendmarc
Version: 1.4.0~beta1+dfsg-1
Severity: normal

Dear Maintainer,

After updating OpenDMARC to version 1.4.0~beta1+dfsg-1 the following
has begun to occur:

- When running opendmarc-import in a crontab I get the following
  message:
opendmarc-import: failed to insert message: Unknown column 'arc' in 'field 
list'

  I tried to import (to MariaDB) the schema update script located at:
 /usr/share/doc/opendmarc/README.update-db-schema.mysql

 but it does not contain any SQL.  It states that the following command
 should be executed:

   mysql -u  -p  --force < update-db-schema.mysql

 but the stated file could not be found.

- The expected outcome is that there would be a schema update script
  which could be applied to the opendmarc DB to include the new ARC
  DB tables/fields.


-- System Information:
Debian Release: bullseye/sid
  APT prefers testing
  APT policy: (990, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 5.4.0-4-amd64 (SMP w/4 CPU cores)
Kernel taint flags: TAINT_WARN
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL 
set to en_US.UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set 
to en_US.UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages opendmarc depends on:
ii  adduser3.118
ii  dbconfig-mysql 2.0.13
ii  debconf [debconf-2.0]  1.5.73
ii  init-system-helpers1.57
ii  libbsd00.10.0-1
ii  libc6  2.30-4
ii  libmilter1.0.1 8.15.2-18
ii  libopendmarc2  1.4.0~beta1+dfsg-1
ii  lsb-base   11.1.0
ii  publicsuffix   20200201.2258-1

Versions of packages opendmarc recommends:
ii  libdbd-mysql-perl 4.050-3
ii  libdbi-perl   1.643-1
ii  libhttp-message-perl  6.22-1
ii  libopendbx1   1.4.6-14
ii  libopendbx1-mysql 1.4.6-14
ii  libswitch-perl2.17-2
ii  perl  5.30.0-9

Versions of packages opendmarc suggests:
ii  libmime-tools-perl  5.509-1
pn  libxml-simple-perl  
ii  python  2.7.17-2
pn  python-mysqldb  

-- Configuration Files:
/etc/default/opendmarc changed [not included]
/etc/opendmarc.conf changed [not included]

-- debconf information:
  opendmarc/remote/port:
  opendmarc/mysql/method: Unix socket
  opendmarc/db/app-user: opendmarc@localhost
  opendmarc/remote/host: localhost
  opendmarc/install-error: abort
  opendmarc/upgrade-error: abort
  opendmarc/db/dbname: opendmarc
* opendmarc/dbconfig-install: true
  opendmarc/database-type: mysql
  opendmarc/internal/skip-preseed: false
  opendmarc/mysql/authplugin: default
  opendmarc/upgrade-backup: true
  opendmarc/purge: false
* opendmarc/mysql/admin-user: debian-sys-maint
  opendmarc/remove-error: abort
  opendmarc/dbconfig-reinstall: false
  opendmarc/passwords-do-not-match:
  opendmarc/internal/reconfiguring: false
  opendmarc/remote/newhost:
  opendmarc/dbconfig-remove: true
  opendmarc/dbconfig-upgrade: true
  opendmarc/missing-db-package-error: abort