Bug 2241923 - Unable to create the MariaDB database with the default schema file
Summary: Unable to create the MariaDB database with the default schema file
Keywords:
Status: NEW
Alias: None
Product: Fedora EPEL
Classification: Fedora
Component: opendmarc
Version: epel9
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Kevin Fenzi
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2023-10-03 13:20 UTC by Frank Büttner
Modified: 2023-10-03 13:20 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed:
Type: Bug
Embargoed:

Attachments (Terms of Use)

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',
...
Note You need to log in before you can comment on or make changes to this bug.