Gary V wrote: > On 1/15/08, Jo Rhett wrote: >> On Jan 15, 2008, at 3:28 PM, Gary V wrote: >>> 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") ); >> That seems so silly when "select distinct Domain from Email" will >> give the exact answer. Flushing every minute or so to text tables >> and then having to restart amavisd to reread it is... wasteful
> Right. Prefixing the domain with a period is likely unnecessary. It > wildcards all the subdomains of a given domain. Whether this type of > thing is of any use depends on how often domains new domains are > added. It would be disruptive if that occurs often. You would only > need to do it when a new domain is added, which is not likely to be > every minute or so. One might script this type of thing into whatever > interface is used to add new domains. I'm sorry, but it's downright silly to write a script to export it and restart amavisd. And it needs too much permissions/rights. Can amavis lookup a map via SQL or not? ------------------------------------------------------------------------- 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 AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/