Author Topic: Spam Assassin User Prefs Plugin not working  (Read 3531 times)

Offline lizat

  • Jr. Member
  • **
  • Posts: 38
    • http://www.TheTangoClub.com
Spam Assassin User Prefs Plugin not working
« 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

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Spam Assassin User Prefs Plugin not working
« Reply #1 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';
« Last Edit: January 02, 2011, 08:56:22 AM by rosali »
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline lizat

  • Jr. Member
  • **
  • Posts: 38
    • http://www.TheTangoClub.com
Spam Assassin User Prefs Plugin not working
« Reply #2 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

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Spam Assassin User Prefs Plugin not working
« Reply #3 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.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,524
Spam Assassin User Prefs Plugin not working
« Reply #4 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.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more…

Offline lizat

  • Jr. Member
  • **
  • Posts: 38
    • http://www.TheTangoClub.com
Spam Assassin User Prefs Plugin not working
« Reply #5 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

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,524
Spam Assassin User Prefs Plugin not working
« Reply #6 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
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more…

Offline lizat

  • Jr. Member
  • **
  • Posts: 38
    • http://www.TheTangoClub.com
Spam Assassin User Prefs Plugin not working
« Reply #7 on: January 03, 2011, 08:17:49 AM »
yes, I see now, thanks............ liz