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 = '[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
