Koozali.org: home of the SME Server

whitelist not working

Offline cyrulution

  • ***
  • 58
  • +0/-0
    • http://cyrulution.eu
whitelist not working
« on: August 05, 2007, 06:16:40 PM »
How can I get the whitelist working? Spamassassin is working almost perfect. Only a few "false positives" have to be sorted manually. Most times just the from same senders. If the whitelist was working, the spam filter would be perfect.
Cyrus

Offline mmccarn

  • *
  • 2,656
  • +10/-0
whitelist not working
« Reply #1 on: August 05, 2007, 06:45:48 PM »
There are several different whitelists active in SME 7:
  • spamassassin
  • qpsmtpd:dnsbl
  • qpsmtpd:rhsbl
  • qpsmtpd:check_badmailfrom
  • qpsmtpd:require_resolvable_fromhost
We could help you figure things out if you can tell us what messages you're getting, and what you've already done to whitelist the "offending" sender (that isn't working).

Offline cyrulution

  • ***
  • 58
  • +0/-0
    • http://cyrulution.eu
whitelist not working
« Reply #2 on: August 05, 2007, 09:22:57 PM »
Quote from: "mmccarn"
There are several different whitelists active in SME 7:
  • spamassassin
  • qpsmtpd:dnsbl
  • qpsmtpd:rhsbl
  • qpsmtpd:check_badmailfrom
  • qpsmtpd:require_resolvable_fromhost
We could help you figure things out if you can tell us what messages you're getting, and what you've already done to whitelist the "offending" sender (that isn't working).


just spamassassin
I already "whitlisted" a number of email addresses with the Horde whitelist.

Offline mmccarn

  • *
  • 2,656
  • +10/-0
whitelist not working
« Reply #3 on: August 06, 2007, 07:12:31 PM »
I'm not sure what exactly the horde whitelist option does on a SME server, but I suspect that it may kick in too late for what you want.

If you have your SME configured to mark junk email and to deliver junk to the junkmail folder, all of this happens before horde ever gets a chance to do anything (that is, everything else I 've seen in Horde only happens when you login to webmail - but by this time your SME has already delivered anything with '^X-Spam-Status: Yes' in the headers into your personal junkmail folder).

To manage the server's spamassassin whitelist you need to either issue a bunch of command-line commands or load and use the whitelist contrib for server-manager.

command line options: (open link, scroll down to 'Whitelist and Blacklist'): http://wiki.contribs.org/index.php?title=Email&curid=238&diff=4583&oldid=4582#The_entire_Sonoracomm_howto_from_Google.27s_text_cache

whitelist contrib (seems to be 'beta'): http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/testing/smeserver-wbl/

Offline Patagón

  • 1
  • +0/-0
Re: whitelist not working
« Reply #4 on: October 10, 2007, 11:26:44 AM »
Just a comment,

1) You are in webmail and mark a msg as white or black
2) If you see the horde database, table horde_prefs you can select out the whitelist o blacklist of every user in the database
    something like   mysql
                          > use horde
                          > select pref_value from horde_prefs where pref_name = "whitelist" into outfile "/tmp/whitelist.txt";
3) With the withelist.txt then you can cut to get the e-mail address
     something like  cut -f2 -d"\"" < /tmp/whitelist.txt


4) With all this stuff then probably you can insert the e-mail addresses into the spamassassin doing something like this
     for b in `cat /tmp/whitelist.txt`; do
         db spamassassin setprop wbl.global $b White
     done

5) If you can insert this in crontab, then probably you can connect webmail whitelist/blacklist with spamassassin whitelist/blacklist

The only thing I can see with this is there is no black or white lists per user. The lists are general.

I hope can help

Regards

Offline Normando

  • *
  • 841
  • +2/-1
    • Unixlan
Re: whitelist not working
« Reply #5 on: October 10, 2007, 02:21:58 PM »
Patagon, very good solution to integrate horde and spamassassin.

Please see this post:
http://forums.contribs.org/index.php?topic=38681.0