Roundcube/Plugin/sauserprefs

SpamAssassin-User-Prefs-SQL

Writes the spamassassin user preferences in the DB. The user will be allowed to create a black/white list, to adjust the required_score and so on.

• Installed via github: johndoh / roundcube-sauserprefs
• Plugin name: sauserprefs

If you migrated to spamassassin v.4 you have to use the v. 1.20.1 which is not available on composer yet. So you have to download it from github and install by yourself:

cd /var/www/roundcube/htdocs/plugins
wget https://github.com/johndoh/roundcube-sauserprefs/archive/refs/tags/1.20.1.tar.gz
tar xzf 1.20.1.tar.gz
mv roundcube-sauserprefs-1.20.1/ sauserprefs
mv config.inc.php.dist config.inc.php

Adjust the configuration:

$config['sauserprefs_db_dsnw'] = 'mysqli://spamassassin:<PASSWORD>@<mysql-IP>/spamassassin';
$config['sauserprefs_sav4'] = true;

NB: <mysql-IP> is the IP address of your mysql server (localhost if the same of qmail).

If 'mysqli' extension is not available in your php, then choose the old 'mysql' in the line above.

If you have just upgraded to spamassassin v.4 you'd have to take a look to the following info.

Spamassassin userprefs' funcionality has been explained in this page. Now we have to check just the creation/modification of the record inside the userprefs table of the spamassassin DB.