Curtis,
> Are the hash tables that amavsd-new uses db4 hashes?
> if not what are they?
They are Perl associative arrays, colloquially known as
hashes.
It is possible to use a Perl 'tie' mechanism to associate
an associative array variable with an external database,
such as db4. It's beeen tried and known to work, although
it is practically never used. If an external database for
lookups is needed, a preferred solution is SQL (or LDAP).
For a small site a good solution for SQL lookups is
a SQLite database, no SQL server is needed.
> I need to write an interface for white/blacklisting.
> the mysql documentation is largely incoherent unless
> you have a degree in CS.
I agree the SQL documentation could use a face lift.
You'd need a record in table 'users' for each recipient
(or a recipient domain) which needs its own white/blacklist
entries. A policy id could point to some policy record with
all
fields NULL or missing, if it is not needed for other
purposes.
The sender addresses go to table 'mailaddr'. Only those
sender addresses (or sender domains) need to be stored
there
which are needed in white/black-list entries.
Lastly, the table 'wblist' creates associations between
senders and recipients, either blacklisting or whitelisting
some sender for some recipient.
Mark
------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://
sourceforge.net/services/buy/index.php
_______________________________________________
AMaViS-user mailing list
AMaViS-user lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/
|
