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!