Thread: SpamAssassin MySQL Plugin

the copy on the website will work with 0.3s

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

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

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

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)

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.

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?

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

well thats quite clever, did you have an old version of this plugin installed? make sure you have cleared your cache, sounds like you might be using an old version of the JS file.