Hi,
I set-up SA to use mysql as per here:
UsingSQL - Spamassassin Wiki (http://wiki.apache.org/spamassassin/UsingSQL)
...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.
look up the mysql error, looks like the user `spamman` doesnt have permission to run inster commands.