SVN Releases > Requests

sauerprefs config setting the database connection string?

(1/1)

kujoe2002:
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:



--- Quote ---.....$rcmail_config['plugins'] = array(....'markasjunk2', 'sauserprefs', 'vcard_attachments',....
--- End quote ---

Now it tells me


--- Quote ---* You must set the database connection string
* Enter the table name, name of the username field, preference field, and value
field

--- End quote ---

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. 

JohnDoh:
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.

kujoe2002:
I had already renamed the file. 


--- Quote ---// spamassassin database settings
$rcmail_config['sauserprefs_db_dsnw'] = 'mysql://username:password@localhost/database';

--- End quote ---

Am I changing this with the info in mySQL database file for the email?


--- Quote ---// PEAR database DSN for read only operations (if empty write database will be used)
// useful for database replication
$rcmail_config['sauserprefs_db_dsnr'] = '';

--- End quote ---

I'm not sure what this is.  Can I leave it as is?



--- Quote ---// table that holds user prefs
$rcmail_config['sauserprefs_sql_table_name'] = "userpref";

--- End quote ---

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?

JohnDoh:

--- Quote ---
--- Quote ---// spamassassin database settings
$rcmail_config['sauserprefs_db_dsnw'] = 'mysql://username:password@localhost/database';

--- End quote ---

Am I changing this with the info in mySQL database file for the email?
--- End quote ---

no, it should be the connection string for the database while holds you spamassassin prefs


--- Quote ---
--- Quote ---// PEAR database DSN for read only operations (if empty write database will be used)
// useful for database replication
$rcmail_config['sauserprefs_db_dsnr'] = '';

--- End quote ---

I'm not sure what this is.  Can I leave it as is?
--- End quote ---

yes


--- Quote ---
--- Quote ---// table that holds user prefs
$rcmail_config['sauserprefs_sql_table_name'] = "userpref";

--- End quote ---

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?
--- End quote ---

no, these settings should matach your spamassassin sql settings.

kujoe2002:
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?

Navigation

[0] Message Index