Re: [RCU] sauserprefs plugin database problem mysql

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