Spam Assassin User Prefs Plugin not working

[lizat]

Can someone help me with this. I have this plugin (sauserpref) lodaed but although I see the tab in Settings I get this erro on clicking it:

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

what should I check?

thank you............ liz

[rosali]

Looks like connection string to Spam Assassin database (not Roundcube database) is wrong.

config.inc.php[.dist]

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

[lizat]

Rosali,

Sorry not sure where u mean i can get into Spam assin on cpanel, do you mean in the Roundcube config file?

thanks..... liz

[rosali]

SA has to be configured to load configuration from a database instead of config files. Make sure to setup SA accordingly. That's not a Roundcube issue. I'm not familiar with cpanel.

[JohnDoh]

in the sauserprefs folder there is a config file. you need to setup the database connection in there so that the plugin can access your spamassassin config information, have you reading the readme? that has some info about the config file and the various options.

[lizat]

John,

I think I'm just being slow here. The readme says:

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

I assumed in the sauserpred config file BUt where, worried to hack it wrongly. I searched for the string suggested by Rosalie but not found?

liz

[JohnDoh]

if you couldn't find the string rosali said then you are looking in the wrong file. in the [rc root]/plugins/sauserprefs/ there is a file called config.inc.php.dist you rename this file config.inc.php and set the config values correctly for your setup

[lizat]

yes, I see now, thanks............ liz