Code: Select all
2021-07-18 11:27:16 139824745740032 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
[edit: I was using another plugin for spamassassin that needed access to the mailscanner table. Ignore the following because this is NOT a mailscanner/efa problem, but a customization problem]
However, I am now getting this error:
Code: Select all
2021-07-18 11:56:18 139927642838784 [Warning] Access denied for user 'sa_user'@'localhost' to database 'mailscanner'
I've confirmed that the sa_user no longer has any rights to the mailscanner database, so I went ahead and granted the rights to resolve the issue.
The curious thing is why did this error appear after the mariadb upgrade? Also, what should be the minimum amount of rights that sa_user needs for the mailscanner database?
(posted in slack as well: https://efa-project.slack.com/archives/ ... 1260007100 )