mariadb update errors this morning
Posted: 18 Jul 2021 04:12
I just had a problem with my efa4 box this morning. yum updated MariaDB and then MariedDB failed to restart correctly. The error was
running mysql_upgrade resolved that issue.
[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:So it seems that 'sa_user' no longer has rights to the mailscanner database.
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 )
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 )