error with update to 4.0.4-42

Bugs in eFa 4
Post Reply
tobiasp
Posts: 13
Joined: 15 Nov 2020 10:42

error with update to 4.0.4-42

Post by tobiasp »

Hi,
i just tried to update to 4.0.4-42 and got this info/error from yum:

should I be worried about:
ERROR 1067 (42000) at line 46: Invalid default value for 'lastsent'
Job for mariadb.service canceled.

Code: Select all

MailWatch for MailScanner Database Upgrade to 1.2.23

Testing connectivity to the database ................................. OK

Updating database schema:

 - Convert database to UTF-8.......................................... ALREADY DONE

 - Fix security issues in database.................................... No known security issues

 - Drop `geoip_country` table......................................... ALREADY DROPPED
 - Drop `spamscores` table............................................ ALREADY DROPPED
 - Add autorelease table to `mailscanner` database.................... ALREADY EXIST
 - Add mtalog_ids table to `mailscanner` database..................... ALREADY EXIST
 - Add resetid, resetexpire and lastreset fields in `users` table..... ALREADY EXIST
 - Add login_expiry and login_timeout fields in `users` table......... ALREADY EXIST
 - Add id field in `users` table...................................... ALREADY EXIST
 - Fix schema for type field in `users` table......................... OK

 - Fix schema for username field in `audit_log` table................. ALREADY DONE
 - Fix schema for ipv6 support in `audit_log` table................... ALREADY DONE
 - Fix schema for id field in `blacklist` table....................... ALREADY DONE
 - Fix schema for id field in `whitelist` table....................... ALREADY DONE
 - Fix schema for username field in `users` table..................... ALREADY DONE
 - Fix schema for username field in `user_filters` table.............. ALREADY DONE
 - Fix schema for spamscore field in `users` table.................... ALREADY DONE
 - Fix schema for highspamscore field in `users` table................ ALREADY DONE
 - Fix schema for timestamp field in `maillog` table.................. ALREADY DONE
 - Fix schema for nameinfected in `maillog` table..................... ALREADY DONE
 - Fix schema for password field in `users` table..................... ALREADY DONE
 - Fix schema for fullname field in `users` table..................... ALREADY DONE
 - Fix schema for rule and rule_desc field in `mcp_rules` table....... ALREADY DONE

 - Fix schema for rule and rule_desc field in `sa_rules` table........ ALREADY DONE

 - Cleanup orphaned user_filters...................................... OK
 - Add id field and primary key to `audit_log` table.................. ALREADY DONE
 - Add inq_id field and primary key to `inq` table.................... ALREADY DONE
 - Add maillog_id field and primary key to `maillog` table............ ALREADY DONE
 - Add rblspamreport field to `maillog` table......................... ALREADY DONE
 - Add token field to `maillog` table................................. ALREADY DONE
 - Add released field to `maillog` table.............................. ALREADY DONE
 - Add last_update field to `maillog` table........................... ALREADY EXIST
 - Add salearn field to `maillog` table............................... ALREADY DONE
 - Add messageid field to `maillog` table............................. ALREADY DONE
 - Check for missing tokens in `maillog` table........................ DONE
   0 token generated
 - Add mtalog_id field and primary key to `mtalog` table.............. ALREADY DONE
 - Add to_address field to `mtalog` table and add to unique key....... ALREADY DONE
 - Add mtalog_id field and primary key to `outq` table................ ALREADY DONE
 - Add id field and primary key to `saved_filters` table.............. ALREADY DONE
 - Add mtalog_id field and primary key to `user_filters` table........ ALREADY DONE

 - Dropping too big index `maillog_from_idx` on table `maillog`....... ALREADY DONE
 - Dropping too big index `maillog_to_idx` on table `maillog`......... ALREADY DONE

 - Convert database to utf8mb4........................................ ALREADY DONE

 - Convert table `audit_log` to utf8mb4............................... ALREADY CONVERTED
 - Convert table `autorelease` to utf8mb4............................. ALREADY CONVERTED
 - Convert table `blacklist` to utf8mb4............................... ALREADY CONVERTED
 - Convert table `inq` to utf8mb4..................................... ALREADY CONVERTED
 - Convert table `maillog` to utf8mb4................................. ALREADY CONVERTED
 - Convert table `mcp_rules` to utf8mb4............................... ALREADY CONVERTED
 - Convert table `mtalog` to utf8mb4.................................. ALREADY CONVERTED
 - Convert table `mtalog_ids` to utf8mb4.............................. ALREADY CONVERTED
 - Convert table `outq` to utf8mb4.................................... ALREADY CONVERTED
 - Convert table `saved_filters` to utf8mb4........................... ALREADY CONVERTED
 - Convert table `sa_rules` to utf8mb4................................ ALREADY CONVERTED
 - Convert table `users` to utf8mb4................................... ALREADY CONVERTED
 - Convert table `user_filters` to utf8mb4............................ ALREADY CONVERTED
 - Convert table `whitelist` to utf8mb4............................... ALREADY CONVERTED

 - Convert table `audit_log` to InnoDB................................ ALREADY CONVERTED
 - Convert table `autorelease` to InnoDB.............................. ALREADY CONVERTED
 - Convert table `blacklist` to InnoDB................................ ALREADY CONVERTED
 - Convert table `inq` to InnoDB...................................... ALREADY CONVERTED
 - Convert table `maillog` to InnoDB.................................. ALREADY CONVERTED
 - Convert table `mcp_rules` to InnoDB................................ ALREADY CONVERTED
 - Convert table `mtalog` to InnoDB................................... ALREADY CONVERTED
 - Convert table `mtalog_ids` to InnoDB............................... ALREADY CONVERTED
 - Convert table `outq` to InnoDB..................................... ALREADY CONVERTED
 - Convert table `saved_filters` to InnoDB............................ ALREADY CONVERTED
 - Convert table `sa_rules` to InnoDB................................. ALREADY CONVERTED
 - Convert table `users` to InnoDB.................................... ALREADY CONVERTED
 - Convert table `user_filters` to InnoDB............................. ALREADY CONVERTED
 - Convert table `whitelist` to InnoDB................................ ALREADY CONVERTED

 - Search for missing indexes on table `maillog`...................... DONE

Checking for obsolete files:

 - Cache dir already removed.......................................... OK

Checking MailScanner.conf settings:

 - QuarantineWholeMessage ............................................ OK
 - QuarantineWholeMessagesAsQueueFiles ............................... OK
 - DetailedSpamReport ................................................ OK
 - IncludeScoresInSpamAssassinReport ................................. OK
 - SpamActions ....................................................... OK
 - HighScoringSpamActions ............................................ OK
 - AlwaysLookedUpLast ................................................ OK

Checking conf.php configuration entry:

 - All mandatory entries are present.................................. OK
 - All obsolete entries are already removed........................... OK
 - optional RPC_PORT ................................................. INFO
 - optional RPC_SSL .................................................. INFO
 - optional RPC_REMOTE_SERVER ........................................ INFO
 - optional VIRUS_REGEX .............................................. INFO
 - optional LDAP_BIND_PREFIX ......................................... INFO
 - optional LDAP_BIND_SUFFIX ......................................... INFO
 - optional EXIM_QUEUE_IN ............................................ INFO
 - optional EXIM_QUEUE_OUT ........................................... INFO
 - optional PWD_RESET_FROM_NAME ...................................... INFO
 - optional PWD_RESET_FROM_ADDRESS ................................... INFO
 - optional MAILQ .................................................... INFO
 - optional MAIL_SENDER .............................................. INFO
 - optional SESSION_NAME ............................................. INFO
 - optional SENDMAIL_QUEUE_IN ........................................ INFO
 - optional SENDMAIL_QUEUE_OUT ....................................... INFO
 - optional MAILWATCH_SMTP_HOSTNAME .................................. INFO
 - optional ALLOW_NO_USER_DOMAIN ..................................... INFO
 - optional ENABLE_SUPER_DOMAIN_ADMINS ............................... INFO
 - optional QUARANTINE_DAYS_TO_KEEP_NONSPAM .......................... INFO


 - Checking minimal PHP version >= 5.4................................ PHP version OK

*** ERROR/WARNING SUMMARY ***
conf.php: optional configuration entry "RPC_PORT" is missing, needed if RPC_ONLY mode is enabled
conf.php: optional configuration entry "RPC_SSL" is missing, needed if RPC_ONLY mode is enabled
conf.php: optional configuration entry "RPC_REMOTE_SERVER" is missing, needed to show number of mails in postfix queues on remote server (RPC)
conf.php: optional configuration entry "VIRUS_REGEX" is missing, needed in distributed setup
conf.php: optional configuration entry "LDAP_BIND_PREFIX" is missing, needed when using LDAP authentication
conf.php: optional configuration entry "LDAP_BIND_SUFFIX" is missing, needed when using LDAP authentication
conf.php: optional configuration entry "EXIM_QUEUE_IN" is missing, needed only if using Exim as MTA
conf.php: optional configuration entry "EXIM_QUEUE_OUT" is missing, needed only if using Exim as MTA
conf.php: optional configuration entry "PWD_RESET_FROM_NAME" is missing, needed if Password Reset feature is enabled
conf.php: optional configuration entry "PWD_RESET_FROM_ADDRESS" is missing, needed if Password Reset feature is enabled
conf.php: optional configuration entry "MAILQ" is missing, needed when using Exim or Sendmail to display the inbound/outbound mail queue lengths
conf.php: optional configuration entry "MAIL_SENDER" is missing, needed if you use Exim or Sendmail Queue
conf.php: optional configuration entry "SESSION_NAME" is missing, needed if experiencing session conflicts
conf.php: optional configuration entry "SENDMAIL_QUEUE_IN" is missing, needed only if using Sendmail as MTA
conf.php: optional configuration entry "SENDMAIL_QUEUE_OUT" is missing, needed only if using Sendmail as MTA
conf.php: optional configuration entry "MAILWATCH_SMTP_HOSTNAME" is missing, needed only if you use a remote SMTP server to send MailWatch emails
conf.php: optional configuration entry "ALLOW_NO_USER_DOMAIN" is missing, allow usernames not in mail format for domain admins and regular users
conf.php: optional configuration entry "ENABLE_SUPER_DOMAIN_ADMINS" is missing, allows domain admins to change domain admins from the same domain
conf.php: optional configuration entry "QUARANTINE_DAYS_TO_KEEP_NONSPAM" is missing, to have quarantine keeping days independently configured for nonspam mails

ERROR 1067 (42000) at line 46: Invalid default value for 'lastsent'
Job for mariadb.service canceled.
Update completed successfully!
User avatar
shawniverson
Posts: 3683
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: error with update to 4.0.4-42

Post by shawniverson »

This error is for a DMARC database table. Error should not have any impact and plan to fix in next update.
tobiasp
Posts: 13
Joined: 15 Nov 2020 10:42

Re: error with update to 4.0.4-42

Post by tobiasp »

Great, thanks for the info!
tobiasp
Posts: 13
Joined: 15 Nov 2020 10:42

Re: error with update to 4.0.4-42

Post by tobiasp »

just fyi:

Upgrading : eFa-1:4.0.4-43.eFa.el8.noarch 35/84
Running scriptlet: eFa-1:4.0.4-43.eFa.el8.noarch 35/84

Preparing to update eFa...
ERROR 1067 (42000) at line 46: Invalid default value for 'lastsent'
Update completed successfully!
User avatar
shawniverson
Posts: 3683
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: error with update to 4.0.4-42

Post by shawniverson »

Well, that's annoying. I'll keep working on this.
Post Reply