trusteddomainproject / OpenDMARC

This is the Trusted Domain Project's impementation of the DMARC protocol libary and mail filter, called OpenDMARC. A "milter" connects to unix-based mailers (originally, sendmail, but now many) and provides a standard filtering API.
Other
98 stars 52 forks source link

opendmarc-import a lot of TINYINT's need DEFAULT '0' #217

Open mdereuver opened 2 years ago

mdereuver commented 2 years ago

I have OpenDMARC installed with reporting on Ubuntu 20.04. opendmarc-import complains on first import with:

Field 'arc' doesn't have a default value

Added a DEFAULT '0' and opendmarc-imports complains again with:

Field 'arc_policy' doesn't have a default value

After that I added DEFAULT '0' to alot of TINYINT's and opendmarc-import did not complained about default values. Can someone look into schema.mysql to see what default values are needed.