Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: lizat on January 01, 2011, 07:29:04 PM

Title: Spam Assassin User Prefs Plugin not working
Post by: lizat on January 01, 2011, 07:29:04 PM

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

Title: Spam Assassin User Prefs Plugin not working
Post by: rosali on January 01, 2011, 11:37:55 PM

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';

Title: Spam Assassin User Prefs Plugin not working
Post by: lizat on January 02, 2011, 04:27:03 AM

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

Title: Spam Assassin User Prefs Plugin not working
Post by: rosali on January 02, 2011, 04:52:37 AM

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.

Title: Spam Assassin User Prefs Plugin not working
Post by: JohnDoh on January 02, 2011, 04:54:32 AM

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.

Title: Spam Assassin User Prefs Plugin not working
Post by: lizat on January 02, 2011, 06:15:36 AM

John,

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

Quote

* 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

Title: Spam Assassin User Prefs Plugin not working
Post by: JohnDoh on January 03, 2011, 04:29:44 AM

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

Title: Spam Assassin User Prefs Plugin not working
Post by: lizat on January 03, 2011, 08:17:49 AM

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