Amavisd-new maps x SQL lookups

	Hi

	Is it possible to use SQL lookups for local_domains_maps, 
score_sender_maps, blacklist_sender_maps,
bypass_spam_checks_maps, etc ?

	I tried to put lookup_sql() and lookup_sql_field() calls in

amavisd.conf, but I always get a syntax error.


	If it's possible, would somebody post an example ?

______________________________
Ricardo Canani
cananiintranetworks.com.br


------------------------------------------------------------
-------------
Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to
make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on
Apache Geronimo
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.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/

Ricardo wrote:

>         Hi

>         Is it possible to use SQL lookups for
local_domains_maps, 
> score_sender_maps, blacklist_sender_maps,
bypass_spam_checks_maps, etc ?

>         I tried to put lookup_sql() and
lookup_sql_field() calls in 
> amavisd.conf, but I always get a syntax error.


>         If it's possible, would somebody post an
example ?

> ______________________________
> Ricardo Canani
> cananiintranetworks.com.br

Read a few pages here:
http://marc.theaimsgroup.com/?l=amavis-
user&m=113479225731661&w=2
and this document:
htt
p://www.ijs.si/software/amavisd/README.sql.txt
and SQL related items here:
http://www.ijs.si/software/amavisd/amavisd-new-do
cs.html#wblist
and this thread:
http://marc.theaimsgroup.com/?l=amavis-
user&m=113173915721641&w=2

Gary V


------------------------------------------------------------
-------------
Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to
make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on
Apache Geronimo
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.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/

	Gary

	Thanks for your hints. I'm already successfully using
$sql_select_policy and $sql_select_white_black_list in
amavisd.conf.

	I'm trying to go beyond README.sql and be able to use SQL
lookups for
*all* maps, despite any performance decrease. Something
like:

local_domains_maps            = (
sql_lookup_field(...) );
viruses_that_fake_sender_maps = (
sql_lookup_field(...) );
score_sender_maps             = (
sql_lookup_field(...) );
keep_decoded_original_maps    = (
sql_lookup_field(...) );
blacklist_sender_maps         = (
sql_lookup_field(...) );


	Nowadays I use SQL lookups for almost all Postfix maps and
I'd like to
do the same for Amavis-new maps.

	Have you ever tried anything like that ?

____________________________________
Ricardo Canani - Intranetworks
cananiintranetworks.com.br


Gary V wrote:
> Ricardo wrote:
> 
>>         Hi
> 
>>         Is it possible to use SQL lookups for
local_domains_maps, 
>> score_sender_maps, blacklist_sender_maps,
bypass_spam_checks_maps, etc ?
> 
>>         I tried to put lookup_sql() and
lookup_sql_field() calls in 
>> amavisd.conf, but I always get a syntax error.
> 
> 
>>         If it's possible, would somebody post an
example ?
> 
>> ______________________________
>> Ricardo Canani
>> cananiintranetworks.com.br
> 
> Read a few pages here:
> http://marc.theaimsgroup.com/?l=amavis-
user&m=113479225731661&w=2
> and this document:
> htt
p://www.ijs.si/software/amavisd/README.sql.txt
> and SQL related items here:
> http://www.ijs.si/software/amavisd/amavisd-new-do
cs.html#wblist
> and this thread:
> http://marc.theaimsgroup.com/?l=amavis-
user&m=113173915721641&w=2
> 
> Gary V
> 
> 
>
------------------------------------------------------------
-------------
> Using Tomcat but need to do more? Need to support web
services, security?
> Get stuff done quickly with pre-integrated technology
to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based
on Apache Geronimo
> http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> AMaViS-user mailing list
> AMaViS-userlists.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/


------------------------------------------------------------
-------------
Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to
make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on
Apache Geronimo
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.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/

          Hello

          Would it be possible to put 'SQL Lookup for all
maps' in the 
whishlist ?

______________________________
Ricardo Canani
cananiintranetworks.com.br


Em 7/9/2006 10:59, Ricardo Canani escreveu:
>     Gary
> 
>     Thanks for your hints. I'm already successfully
using
> $sql_select_policy and $sql_select_white_black_list in
amavisd.conf.
> 
>     I'm trying to go beyond README.sql and be able to
use SQL lookups for
> *all* maps, despite any performance decrease. Something
like:
> 
> local_domains_maps            = (
sql_lookup_field(...) );
> viruses_that_fake_sender_maps = (
sql_lookup_field(...) );
> score_sender_maps             = (
sql_lookup_field(...) );
> keep_decoded_original_maps    = (
sql_lookup_field(...) );
> blacklist_sender_maps         = (
sql_lookup_field(...) );
> 
> 
>     Nowadays I use SQL lookups for almost all Postfix
maps and I'd like to
> do the same for Amavis-new maps.
> 
>     Have you ever tried anything like that ?
> 
> ____________________________________
> Ricardo Canani - Intranetworks
> cananiintranetworks.com.br
> 
> 
> Gary V wrote:
>> Ricardo wrote:
>>
>>>         Hi
>>
>>>         Is it possible to use SQL lookups for
local_domains_maps, 
>>> score_sender_maps, blacklist_sender_maps,
bypass_spam_checks_maps, etc ?
>>
>>>         I tried to put lookup_sql() and
lookup_sql_field() calls in 
>>> amavisd.conf, but I always get a syntax error.
>>
>>
>>>         If it's possible, would somebody post
an example ?
>>
>>> ______________________________
>>> Ricardo Canani
>>> cananiintranetworks.com.br

------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief surveys
-- and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.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/