-------- Original-Nachricht -------- > Datum: Sat, 25 Aug 2007 00:42:47 +0200 > Von: Mark Martinec <[EMAIL PROTECTED]> > An: [email protected] > Betreff: Re: [AMaViS-user] Question regarding SQL lookups
> Steve, > Mark > > Now I would like to use a SQL query for @local_domains_maps to get a > list > > of the domains. But the query would be executed against a totally > different > > database then the one amavis-new is using. > > Not sure what you have in mind, but perhaps the following example > >from amavisd.conf-sample can supply you an idea: > > # Here is an example of a SELECT clause that fabricates an artificial > 'users' > # table from actual table 'postfix_domains' containing a field > 'domain_name'. > # The effect is that domains listed in the 'postfix_domains' table will be > # treated as local by amavisd, and be given settings from a policy id 99 > # if such a policy id exists, or just fall back to static lookups. > # The user.id (with a value 1) is there only to provide a user id (same id > # for all listed domains) when global SQL-based white/blacklisting is > used. > # > # $sql_lookups_no_at_means_domain = 1; > # $sql_select_policy = > # 'SELECT *, user.id'. > # ' FROM (SELECT 1 as id, 99 as policy_id, "Y" AS local'. > # ' FROM postfix_domains WHERE domain_name IN (%k)) AS user'. > # ' LEFT JOIN policy ON policy_id=policy.id'; > I still don't understand. Allow me to be more specific: I have a setup where all the data for Postfix is inside a MySQL database. All the users, aliases, domains, transports, etc. With a cron job I do query the MySQL database to get a list of all domains on the server. Then I sort that result and then I compare the list with what is in amavisd.conf under @local_domains_maps. If the result is not the same as in amavisd.conf, then I push the result into amavisd.conf and restart AMaViS. And I want to avoid this job. I would like to directly specify a SQL query for local_domains_maps instead of using: @local_domains_maps = ( [qw( .$mydomain .domain1.tld .domain2.tld domain2.tld ... At least I don't need to update the @local_domains_maps by hand but still. I would prefer to directly query the SQL database then using my stupid hack. Is this possible? How? > > Mark > Steve > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > 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/ -- Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten Browser-Versionen downloaden: http://www.gmx.net/de/go/browser ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. 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/
