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 = '[email protected]' 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 =
'[email protected]' 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.
--
List info: http://lists.roundcube.net/users/
BT/8f4f07cd
