SpamAssassin MySQL patch

[horfic]

I tried to patch it, but when i try the command, it says that the patch command is unknown. I have a ubuntu 6.06 version with php 5.2.6 and plesk 8.4!

[horfic]

I tried to patch it, but when i try the command, it says that the patch command is unknown. I have a ubuntu 6.06 version with php 5.2.6 and plesk 8.4!

PS: Maybe you can combine this with the SPAM/Ham Report Addon.

[JohnDoh]

sounds like you dont have patch installed. Patch is a bit of software that allows you to apply patch/diff.

[pyther24]

Can you update this to work with release two?
Thanks!

[JohnDoh]

Hi, there is a version that works with 0.2stable from the SVN and I will update it to work with the version from the RC website when i have sometime, hopefully this weekend. Its only the compressed app.js file that is different, if you swap app.js for app.js.src the patch should work as is.

[JohnDoh]

added a patch for the release version from the RC website, please see earlier post.

[pyther24]

Thanks! It works great, however it seems that you got rid of the 0.5 increments :-/

[JohnDoh]

the option is still there, look in plugins/sauserperfs/config.inc.php for $sauserprefs_config['score_inc'].

[horfic]

I installed the patch, but it doesn't work! Because my Spamassasin comes with Plesk, and Plesk has only the user id in the userpref table and has the username in a diffrent table.

userpref table = spamfilter preferences
table with username = spamfilter

So is there a plesk version comming up!

[JohnDoh]

There is no plesk version but it should be easy to fix, just change the SQL statements in sauerprefs.inc and save_sauserprefs.inc.

[horfic]

I tried it! As soon I use $user_db->fetch_row or $user_db->result it shows me a blank page.

Sorry pretty new to songbird programming. I know where to change it and that i have to get the id from the other table by searching for the username there. It just doesn't work!

UPDATE:
I managed to solve the problem, I used now fetch_assoc to do it. Obviously he didn't knew the functions above.

[lacri]

thx for this great addon, i have installed and works fine,
i have a bug or problem ? by to add a address from an incoming email on click add to address book will not work
thats the address add to whitelist via whitelist sync can you help me is this a bug or not yet implement ?

thx for help

[siodseraph]

Thanks for this excellent add-on! I suggest to add this as a component to Roundcube - maybe as an optional extension that can be enabled through the main config file.

Good job, have been looking for something like that for a while!

Now a question: I am trying to use the whitelist_sync feature but somehow it doesn't seem to work - or it works differently than I expect it to.

If I added a user to my addressbook, should it be added as a whitelist user to the userprefs? I did add the contact_id field for the table but it's always -1 no matter where I add the user (addressbook, add via + symbol at email, whitelist rule).

I can live without this feature, everything else works great! Just wondering what this feature will add to RC and the Whitelists

EDIT: Never mind, without me doing anything the sync now works when adding something to the addressbook. Which makes this thing even BETTER!

[JohnDoh]

At the moment the sync only works between actions done in the addressbook and the whitelist. I am working on a better system that will sync with the + as well as any other addressbook related action.

[siodseraph]

That's good news, glad to see this is actively developed. Keep it up, will fetch the new version as soon as it becomes available and test it out.