mariadb update errors this morning

Bugs in eFa 4
Post Reply
User avatar
pdwalker
Posts: 1384
Joined: 18 Mar 2015 09:16

mariadb update errors this morning

Post by pdwalker » 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

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
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:

Code: Select all

 2021-07-18 11:56:18 139927642838784 [Warning] Access denied for user 'sa_user'@'localhost' to database 'mailscanner'
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 )

Post Reply