SpamAssassin MySQL Plugin

[JohnDoh]

this isnt really the best place for help setting up spamassassin or ispconfig, have you gone though this UsingSQL - Spamassassin Wiki if you're still stuck i suggest finding some spamassassin support or may be ispconfig. hope you get it working.

[snyder]

Hello,

Does the deletion of user bayesian data work for anybody?
I am getting "server error" message every time I try to use this functionality.

It seems like the problem is with the following piece of code in purge_bayes() function:
if ($rcmail->config->get('sauserprefs_bayes_delete_query', true)) {
           $this->api->output->command('display_message', $this->gettext('servererror'), 'error');
           return;
                }

($rcmail->config->get('sauserprefs_bayes_delete_query', true)) always returns TRUE and further lines of the function are never executed.

After commenting out the above part everything works as expected.
(However, I suppose, this code should rather be fixed than removed )

[JohnDoh]

its been fixed already in the repo, Commit 17dcbfb9c4d902eb8a8a28c4817cf7fac2988e9e to JohnDoh's RoundCube-Plugin-SpamAssassin-User-Prefs-SQL - GitHub

[snyder]

great, thanks!
(I should have check GitHub first, sorry...)

[Crupuk]

Wont the SpamAssassin part work anyway?

I don't have access from my server from work, but will have a look tonight.

If not then having this work with amavisd-new would be great.

Nothing about this ?

:-D

[Dane]

a little issue in sauserprefs.php

change this:

if (!isset($no_override['skip_rbl_checks'])) {
               if ($_POST['_spamskiprblchecks'] == "1")
                  $new_prefs['skip_rbl_checks'] = "";
               else
                  $new_prefs['skip_rbl_checks'] = "1";

for:

if (!isset($no_override['skip_rbl_checks'])) {
               if ($_POST['_spamskiprblchecks'] == "1")
                  $new_prefs['skip_rbl_checks'] = "0";
               else
                  $new_prefs['skip_rbl_checks'] = "1";

regards

[JohnDoh]

thanks, this has been fixed in the repo version.

[dvdsmith]

CREATE TABLE userpref (
  username varchar(100) NOT NULL default '',
  preference varchar(50) NOT NULL default '',
  value varchar(100) NOT NULL default '',
  prefid int(11) NOT NULL auto_increment,
  PRIMARY KEY  (prefid),
  KEY username (username)
);

I'm pretty new mysql, so forgive me if I missed the obvious.  

So far as I can tell this was the only mention I could find specifying the details of the field required for this plugin.  The readme only tells you to create the table and fields, not field length or anything else.  I would suggest the above should be in the readme or at least the essential details.

Dave

[JohnDoh]

TBH I kind of assumed that any one who used the plugin would already have their SA setup. There are lots of guides out there for how to it with different databases, including the SA documentation itself.

But I understand what you are saying about it being hard to know where to start, may be I will add a link to the SA documentation in the readme.

[LMSSML]

Hi there,

When I installed the plugin

When i used on roundcube what happends it's the following it looses the separator and opens a total page of spam filter making roundcube icon above some options.

Is it possible to open has settings and the left options opende and see the tabs above ?

[JohnDoh]

are you using the default skin and correct version of the plugin for your version of rc?

[LMSSML]

Hi there,

I'.m using rc 0.4

and the version of spam is sauserprefs.

Version of spamassasin 3.2.3

[JohnDoh]

hmm sauserprefs version 1.4 right? its at the top of [rc root]/plugins/sauserprefs/sauserprefs.php. and its the default RC skin not running inside iframes or anthing like that right? it should look like this http://www.tehinterweb.co.uk/roundcube/plugins/sauserprefs.jpg

[LMSSML]

Hi John


Thanks for the awnser:


but it goes a little different from what you have posted.

What you have posted that's the way I like to be but it goes like my jpeg.

What I did do wrong ?


Any help ?

[SKaero]

What browser is that happening in and have you tried clearing your browser cache?