On 1/15/08, Gary V <[EMAIL PROTECTED]> wrote:
> On 1/15/08, Jo Rhett wrote:
> > Thank you, Gary for the detailed response (quoted below). However it
> > appears that these queries will break the existing amavisd tables used
> > for kill score, etc.
> >
> > Is there a way I can use (different) SQL tables for determining if an
> > address is a local user?
> >
>
> Right, in that case it would break what you have. If you are already
> using the amavis schema, but only have a limited number of users or
> domains in the database, consider that you could add a new policy that
> contains nothing more than the policy.id, then, then add any
> @domains.tld that are not currently in the database (domains you want
> considered local) and assign them to that policy. What this does is
> makes those domains local, but lets all lookups fall through to static
> lookups.
>
> Sorry, I'm not schooled enough in SQL to provide any further suggestion.
>
> --
> Gary V
>
But I can tell you that it's not hard to dump your domains into a flat
file that amavis can use:
mysql -uusername -psome_password database -B -N -e "select
concat('.',domain) from domain" >/var/amavis/local_domains
Then in amavisd.conf:
@local_domains_maps = ( read_hash("$MYHOME/local_domains") );
--
Gary V
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
