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 ------------------------------------------------------------------------- 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/
