sauserprefs - question about it

[myname]

Hi,

  I set-up SA to use mysql as per here:
UsingSQL - Spamassassin Wiki

...And also read this about the mysql connector:
http://svn.apache.org/repos/asf/spamassassin/tags/spamassassin_current_release_3.3.x/sql/README

I installed the plugin and set the mysql connector as:
// spamassassin database settings
$rcmail_config['sauserprefs_db_dsnw'] = 'mysql://spamman:ffffffff()-1@localhost/spamassassin';

This message is displayed when I try via Roundcube to save some settings:
Error: Cannot change spam settings.

From the logs:
 [Native code: 1142] [Native message: INSERT command denied to user 'spamman'@'localhost' for table 'userpref']  in /www/roundcube/program/include/rcube_mdb2.php on line 646 (POST /?_task=settings&_action=plugin.sauserprefs.save)


Does anyone know what I might have mis-configured?

Regards, S.

[JohnDoh]

look up the mysql error, looks like the user `spamman` doesnt have permission to run inster commands.