Bug 2241923

Summary:	Unable to create the MariaDB database with the default schema file
Product:	[Fedora] Fedora EPEL	Reporter:	Frank Büttner <bugzilla>
Component:	opendmarc	Assignee:	Kevin Fenzi <kevin>
Status:	NEW ---	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	epel9	CC:	abo, kevin
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	---
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Frank Büttner 2023-10-03 13:20:41 UTC

Description of problem:
The database can't created with the schema file.

Version-Release number of selected component (if applicable):
opendmarc-1.4.2-10.el9.x86_64

How reproducible:
every time

Steps to Reproduce:
1. call mysql opendmarc < /usr/share/opendmarc/db/schema.mysql

Actual results:
ERROR 1067 (42000) at line 58: Fehlerhafter Vorgabewert (DEFAULT) für 'lastsent'

Expected results:
That the tables of the database are created.

Additional info:
This line fails:
lastsent TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00',
an fix will be:
USE opendmarc;
SET @@session.time_zone = '+00:00';
...
lastsent TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:01',
...