Roundcube Community Forum
SVN Releases => Requests => Topic started by: kujoe2002 on March 21, 2013, 05:20:45 PM
-
So I'm trying to setup spam assassin using the Sauerprefs config file. I uploaded the sauerprefs to the plugin folder. I edited the main.inc file to add the string:
.....$rcmail_config['plugins'] = array(....'markasjunk2', 'sauserprefs', 'vcard_attachments',....
Now it tells me
* You must set the database connection string
* Enter the table name, name of the username field, preference field, and value
field
Can Anyone tell me (in layman's terms) what I'm supposed to do? I tried looking up:
http://stackoverflow.com/questions/360024/how-do-i-set-a-connection-string-config-programatically-in-net
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx
http://www.connectionstrings.com/access
http://www.sqlstrings.com/
but am now more confused.
-
in the sauserprefs plugin folder there is a file called config.inc.php.dist you need to rename this to config.inc.php and fill in the config options inside it. that is where the db connection string and table settings go.
-
I had already renamed the file.
// spamassassin database settings
$rcmail_config['sauserprefs_db_dsnw'] = 'mysql://username:password@localhost/database';
Am I changing this with the info in mySQL database file for the email?
// PEAR database DSN for read only operations (if empty write database will be used)
// useful for database replication
$rcmail_config['sauserprefs_db_dsnr'] = '';
I'm not sure what this is. Can I leave it as is?
// table that holds user prefs
$rcmail_config['sauserprefs_sql_table_name'] = "userpref";
Is this the info I would find in the MySQL file for the email account? Or do I leave as is? And the rest of the file, are there changes I need to make or are these the default settings for the plugin?
-
// spamassassin database settings
$rcmail_config['sauserprefs_db_dsnw'] = 'mysql://username:password@localhost/database';
Am I changing this with the info in mySQL database file for the email?
no, it should be the connection string for the database while holds you spamassassin prefs
// PEAR database DSN for read only operations (if empty write database will be used)
// useful for database replication
$rcmail_config['sauserprefs_db_dsnr'] = '';
I'm not sure what this is. Can I leave it as is?
yes
// table that holds user prefs
$rcmail_config['sauserprefs_sql_table_name'] = "userpref";
Is this the info I would find in the MySQL file for the email account? Or do I leave as is? And the rest of the file, are there changes I need to make or are these the default settings for the plugin?
no, these settings should matach your spamassassin sql settings.
-
OK, So I did everything you said and I'm still getting spam from the same email address. does it take a little time before spam assassin works?