Installing Efa I have this error, using fresh CentOS-8.3.2011-x86_64
[eFa] If these settings are correct type 'OK' to continue.
[eFa] if there is an error enter the number you want to change.
[eFa] : OK
[eFa] - Starting MariaDB and Configuring
ERROR 1064 (42000) at line 20: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
lastsent TIMESTAMP NOT NULL DE...' at line 11
[eFa] - Configuring hostname and domainname
[eFa] - Setting DNS
Created symlink /etc/systemd/system/multi-user.target.wants/unbound.service → /usr/lib/systemd/system/unbound.service.
[eFa] - Setting IP settings
[eFa] - Generating SSH Host keys
MariaDb error installing eFa-4.0.4
-
- Posts: 388
- Joined: 23 Apr 2015 09:45
Re: MariaDb error installing eFa-4.0.4
But after installation seems that last_update colums is already as we want, so this seems a minor bug
MariaDB [mailscanner]> describe maillog;
+-----------------+---------------------+------+-----+---------------------+-------------------------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------------------+-------------------------------+
| maillog_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| .....
| last_update | timestamp | NO | | current_timestamp() | on update current_timestamp() |
| messageid | longtext | YES | | NULL | |
+-----------------+---------------------+------+-----+---------------------+-------------------------------+
43 rows in set (0.002 sec)
MariaDB [mailscanner]> describe maillog;
+-----------------+---------------------+------+-----+---------------------+-------------------------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------------------+-------------------------------+
| maillog_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| .....
| last_update | timestamp | NO | | current_timestamp() | on update current_timestamp() |
| messageid | longtext | YES | | NULL | |
+-----------------+---------------------+------+-----+---------------------+-------------------------------+
43 rows in set (0.002 sec)
- shawniverson
- Posts: 3644
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: MariaDb error installing eFa-4.0.4
Yeah that is pretty minor, must be something up in MailWatch 1.2.16. I'll take a look and see if it can be fixed upstream.