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?
is missed from Thunderbird. Very strange.
Best regards, S.
I found the problem. I had a typo, and was granting update as the wrong user. now I have to undo what I did.
Which grants should the roundcube user have on the spamassin table, if any?
Regards, S
On 01/28/2011 05:38 PM, J4K wrote:
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 ONspamassassin
.bayes_expire
TO 'spam'@'localhost' | | GRANT SELECT, INSERT, DELETE ONspamassassin
.userpref
TO 'spam'@'localhost' | | GRANT SELECT, INSERT, DELETE ONspamassassin
.bayes_global_vars
TO 'spam'@'localhost' | | GRANT SELECT, INSERT, DELETE ONspamassassin
.bayes_token
TO 'spam'@'localhost' | | GRANT SELECT, INSERT, DELETE ONspamassassin
.bayes_seen
TO 'spam'@'localhost' | | GRANT SELECT, INSERT, DELETE ONspamassassin
.bayes_vars
TO 'spam'@'localhost' | | GRANT SELECT, INSERT, UPDATE, DELETE ONspamassassin
.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.