Thread: SpamAssassin MySQL Plugin

so you have the spamassasin database all setup and the plugin is correctly configured to connect to that database, not the rc one, is that right?

the sauserprefs_bayes_delete_query is optional, just leave it blank if you are not using bayesian data or it is not being stored in the db.

Originally Posted by roe1234

Is there any ability to get this plugin working with Amavisd-New?

+1

I agree with this, i have amavisd-new user pref..

Originally Posted by Crupuk

+1

I agree with this, i have amavisd-new user pref..

Wont the SpamAssassin part work anyway?

I don't have access from my server from work, but will have a look tonight.

If not then having this work with amavisd-new would be great.

Originally Posted by Volnhar

Wont the SpamAssassin part work anyway?

I don't think so, because spamassassin is called from amavisd-new and juste retourne a spam score.

Amavisd-new use is own prefs.

Thanks for you help

Hello,
my first post here. I hope this is the right place to start.
I'm Italian and quite a newbie with linux and mysql.
I have just set up an ubuntu 9.10 mail server with spamassassin, amavisd-new, ISPConfig and RoundCube for my organization.
It is working quite well except that we are receiving too much spam.
I'm trying to install the sauserprefs plugins but I have some doubts.
In mysql I have the following databases:
* dbispconfig (47 tables)
* information_schema (28 tables)
* mysql (23 tables)
* roundcube (6 tables)
In the config.inc.php file of the sauserprefs plugin I have set the roundcube database but I'm not sure that it is the correct database.
Then with PHPmyadmin I have created a table called userprefs with 3 fields (username, preference and value) that I have set to text.
In this way, in RoundCube, I can access the plugin and even save the preferences but I'm not sure it will work and especially I'm not sure it will connect to spamassassin (how spamassassin can take the information from this database?).
Any help and explanation will be appreciated.
I've tried to research this on google but I still have many doubts.
Thank you.

CREATE TABLE userpref (
username varchar(100) NOT NULL default '',
preference varchar(50) NOT NULL default '',
value varchar(100) NOT NULL default '',
prefid int(11) NOT NULL auto_increment,
PRIMARY KEY (prefid),
KEY username (username)
);

OK, it seems it's working. I'm able to save the preferences.
I did the tables with the suggested commands in the roundcube database, is it right?
Will spamassassin use the same database?
Thanks.

Addendum:

Maybe I did a mistake in mysql by making two separate databases for ISPConfig and roundcube?
Even if I'm able to save the preferences, it seems that they have no effect.
The only effect that I can see is when I change the policies in the ISPConfig (i.e. permissive, normal and their spam levels), but from this plugin I can't notice any effect.

this isnt really the best place for help setting up spamassassin or ispconfig, have you gone though this UsingSQL - Spamassassin Wiki if you're still stuck i suggest finding some spamassassin support or may be ispconfig. hope you get it working.

Hello,

Does the deletion of user bayesian data work for anybody?
I am getting "server error" message every time I try to use this functionality.

It seems like the problem is with the following piece of code in purge_bayes() function:

PHP Code:

if ($rcmail->config->get('sauserprefs_bayes_delete_query', true)) {
           $this->api->output->command('display_message', $this->gettext('servererror'), 'error');
           return;
                } 


($rcmail->config->get('sauserprefs_bayes_delete_query', true)) always returns TRUE and further lines of the function are never executed.

After commenting out the above part everything works as expected.
(However, I suppose, this code should rather be fixed than removed )