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 <user> -p <passwd> --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.

I’m not the maintainer but I uploaded this update.

This is to do with the dbconfig support that was contributed here:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=879241

This is Debian-specific, I think … Unfortunately I don’t use a database
or dbconfig and have no idea what it does, how it works, or what would
need to be updated. I hope I can look into it later, help welcome.

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.