Re: [AMaViS-user] Static whitelist with MySQL backend?

Anders wrote:

> This is a cause of confusion for me...
> I'm using Amavis-new 2.4.5 and SpamAssassin 3.2.0 with the MySQL backend
> for AWL etc..

The SpamAssassin AWL is not actually a whitelist. It's a score
averaging system.

> What if I want to add domains as statically okay, to always have them
> whitelisted.. Where do I do it?

Typical ways to whitelist in SA include whitelist_from and
whitelist_from_rcvd. These typically look for sender addresses
in the headers (but may also look at the envelope address):
http://spamassassin.apache.org/full/...cklist_options

Read amavisd.conf-sample and search for whitelist (or WHITELIST). You
will see at least three ways (plus some hints on how the SQL
whitelist/blacklist works) to do static domain wide or per-recipient
soft or hard whitelisting. If you want SQL wbl you should read:
http://www.ijs.si/software/amavisd/README.sql.txt and
http://www.ijs.si/software/amavisd/README.sql-mysql.txt
It's my understanding that SQL based wbl is always per recipient (but
the recipient may be a domain). Note that implementing SQL may change
the way amavisd-new performs lookups because results from SQL queries
may override static settings (due to the order in which lookups are
performed). See:
http://www.ijs.si/software/amavisd/README.lookups.txt

At first it took me some work to get my head around SQL based wbl but
since I don't use SQL in amavisd-new on a regular basis I can tell you
that glancing at it again now I would have to spend a little time to
once again familiarize myself. In other words, it was not obvious to
me.

> Anders.

Gary V



-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/