SpamAssassin MySQL Plugin

[JohnDoh]

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

[techdude]

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

[JohnDoh]

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.

[spiderling]

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. :confused:
Am I to create a separate table for this?

Thanks in advance

[JohnDoh]

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.

[spiderling]

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

[patricktech]

Do you have the latest stable release of your plugin to work with 0.3-stable release of RC?

Thanks...

[JohnDoh]

the copy on the website will work with 0.3s

[voltron81]

Have somebody tried to install this plugin with ISPConfig 3?
The difference is that Spamassassin is controlled by ISPConfig, so I think the database is different...
What do you think?

Thanks
Michele

[richermartyn]

Hi...
 I have some information regarding MYSQL...
To begin using the Stats Plugin you will need to create a table for the plugin to write to
CREATE TABLE stats (
  day date NOT NULL default'',
  username varchar(100) NOT NULL default '',
  domain varchar(100) default '',
  spam int(20) default '0',
  ham int(20) default '0',
  PRIMARY KEY (day,username,domain)
) TYPE=MyISAM
You will need to replace the following variables with settings for your configuration  You will need to replace the following variables with settings for your configuration  
# Configure SQL for statistical storage
use_stats                       1
user_stats_dsn                  DBI:mysql:spamassassin_beta:sql_hostname
user_stats_sql_username         sql_username
user_stats_sql_password         sql_password
user_stats_sql_table            sql_table

[utiltiy]

Hello,

can me anybody help with the MySQL Settings?

I insert my Database String, but it's save from Settings Possible.

Must i create a new Databse for this or what must i do for it?

Thanks

[JohnDoh]

the plugin interacts with the mysql database which stores your SpamAssassin settings. If you dont have one of those then either this plugin isnt for you or you need to configure your SpamAssassin to use a mysql database (there are lots of guides on how to do that on the internet just do some searching)

[henlon]

I'm running on RC0.3s and have installed the latest plugins from the repository.
When I go to the 'SPAM' label and click on the settings in the left menu i only receive the button 'SAVE' in the forms.
Is there anything more I have to do?
I have created the mySQL db with the fields 'username' 'preference' and 'value'
There are no errors in the log file.

[JohnDoh]

Try using the zip/tag.gz version on the website rather than the one from the repo and see if you have the same issue. Also could you post your config file? You should see a "restore default values" button as well as a save one. Are the fields missing for all sections or just one?

[henlon]

Yes, exept from the first 'General settings' wich is the same as the fields under User settings in the first window.