Thread: SpamAssassin MySQL Plugin

Understandable. Something I can look to mod in myself I guess.

The one issue I see is a user that doesnt have user prefs, when the go to the spam tab, the plugin shows settings, atleast it could be misleading to an end user that doesnt know what to look for, when in fact no spam settings exist in the userprefs table for them.

I guess depending on its application and how its presented to the users could determine a lot. Maybe I will look at adding an enable and disable button that can be turned on or off in the config file i.e. choose to have it in use or not.

Thanks, Patrick

I have added some new options to the code (currently in the repo): In the score drop down a new option at the top called "Default Score". Also if some one has a score which is not in the drop down then a new value is added called "Other ([score])" so that a score is never lost. Then at the bottom of the screen, next to the save button there is a new "Restore Default Settings" button which does excatly what it says on the tin. It has the effect of deleteing all the user's settings since anything which matches the default is not saved to the DB.

How does one tell SpamAssassin to use these settings? I'll write a step-by-step if someone can point me in the right direction to get mine working.

The offical instructions are here UsingSQL - Spamassassin Wiki If you do a search from Spamassassin and MySQL you should find some guides.

What modifications do I need to make to this to get it to work with another Template? Such as the MobileMe Template?

It depends what version of RC (and the plugin) you have. If its 0.3b then your options are limited, there is a sauserprefs.css file in the plugin folder and you can tweak that to try and match your skin, but that’s about it – unless you want to edit the code in sauserprefs.php

If you are using SVN trunk then there is a skins folder inside the plugin dir, and default inside that – make a copy of this folder and give it the same name as your skin and you can tweak the template files, css and images.

I am a newbie to managing a dedicated server and to RC, and I'm having a little trouble understanding the configuration settings for this plugin.

I'm using RC 0.3beta and uploaded the sauserprefs folder into the plugins folder. Added the sausesrprefs to the $rcmail_config['plugins'] array.

I have RC's 'users' table which has a 'username' field and a 'preferences' field, but it does not have a 'value' field.
Am I to create a separate table for this?

Thanks in advance

hi, i think maybe you are looking in the wrong place. you should be putting in the info from your SpamAssassin user prefs table, not the RC users table. UsingSQL - Spamassassin Wiki should get you started on setting up SpamAssassin and MySQL.

Thanks for the info. I'll give it try.