Hi there,
I had the spam update settings correctly set and it did work.
Nothing changed. However, today users can no longer update the spam settigs:
The error is: Jan 28 17:23:45 srv1 roundcube: DB Error: MDB2 Error: insufficient permissions Query: _doQuery: [Error message: Could not execute statement] [Last executed query: UPDATE userpref SET value = '6' WHERE username = 'babuser@klunky.co.uk' AND preference = 'required_score';] [Native code: 1142] [Native message: UPDATE command denied to user 'spam'@'localhost' for table 'userpref'] in /www/roundcube/program/include/rcube_mdb2.php on line 646 (POST /?_task=settings&_action=plugin.sauserprefs.save)
The sauserprefgs config file states this, and I can login as the user: $rcmail_config['sauserprefs_db_dsnw'] = 'mysql://spam:xxxxxxxxxxxxxxxxxx-1@localhost/spamassassin';
The grants are these ( a flush priv has been run).
mysql> show grants for 'spam'@'localhost';
+--------------------------------------------------------------------------------------------------------------------+
| Grants for
spam@localhost
|
+--------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'spam'@'localhost' IDENTIFIED BY PASSWORD
'*xxxxxxxxxxxxxxxxxx' |
| GRANT SELECT, INSERT, DELETE ON spamassassin.bayes_expire TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON spamassassin.userpref TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON spamassassin.bayes_global_vars TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON spamassassin.bayes_token TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON spamassassin.bayes_seen TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON spamassassin.bayes_vars TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON spamassassin.awl TO
'spam'@'localhost' |
+--------------------------------------------------------------------------------------------------------------------+
Here is the specific sql : mysql> UPDATE userpref SET value = '6' WHERE username = 'baduser@klunky.co.uk' AND preference = 'required_score'; ERROR 1142 (42000): UPDATE command denied to user 'spam'@'localhost' for table 'userpref'
I tried the same update as the admin user, and it worked.
Has anyone seen this afore, or know what could have changed for this to suddenly stop working?
- Another weird oddity is that all mail is shown in Roundcube, yet some
is missed from Thunderbird. Very strange.
Best regards, S.