List Info

Thread: amavis SQL blacklist/whitelist problems




amavis SQL blacklist/whitelist problems
user name
2006-04-14 17:15:48
Matt wrote:

> Hello,

> I recently setup a mail filter gateway on my gentoo
machine by following 
> this guide :

> htt
p://www.gentoo.org/doc/en/mailfilter-guide.xml

> Everything worked great.  I can send email from an
external source and 
> it is filtered and sent to my exchange server.  However
I am not quite 
> sure if the SPAM filtering is working.

> For now, I am trying to get amavis to use MySQL for
policies and 
> whitelisting and blacklisting per user.  When I start
the amavis debug I 
> get :

> ANTI-VIRUS code    loaded
> ANTI-SPAM  code    NOT loaded

> Does that mean that nothing in the MySQL database is
being used then 
> because SPAM is not working? 

> I know that amavis is at least connecting to the
database ok and pulling 
> a policy, because of this in amavis debug (after I send
an external email) :

> connect_to_sql: trying 'DBI:mysql:maildb:localhost'
> connect_to_sql: 'DBI:mysql:maildb:localhost'
succeeded

> Where can I start to troubleshoot this problem? Is it a
spamassasin 
> problem? or and amavis problem? 

> Thanks,
> Matt

Assuming spamassassin is installed, have you looked in
amavisd.conf to
see if you have disabled spam scanning?

# bypass_spam_checks_maps  = (1);  # uncomment to
DISABLE anti-spam code

I see this in the example:

map { $bypass_spam_checks{lc($_)}=1 } (qw(
        postmaster
        abuse
));

Try commenting this out. You can set these in your SQL
database.

Gary V



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking
scripting language
that extends applications into web and mobile media. Attend
the live webcast
and join the prime developer group breaking into this new
coding territory!
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=110944&bid=241720&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/
amavis SQL blacklist/whitelist problems
user name
2006-04-14 18:38:01
Yup that was it.  Figured it out right before I read this.

Gary V wrote:
> Matt wrote:
>
>   
>> Hello,
>>     
>
>   
>> I recently setup a mail filter gateway on my gentoo
machine by following 
>> this guide :
>>     
>
>   
>> htt
p://www.gentoo.org/doc/en/mailfilter-guide.xml
>>     
>
>   
>> Everything worked great.  I can send email from an
external source and 
>> it is filtered and sent to my exchange server. 
However I am not quite 
>> sure if the SPAM filtering is working.
>>     
>
>   
>> For now, I am trying to get amavis to use MySQL for
policies and 
>> whitelisting and blacklisting per user.  When I
start the amavis debug I 
>> get :
>>     
>
>   
>> ANTI-VIRUS code    loaded
>> ANTI-SPAM  code    NOT loaded
>>     
>
>   
>> Does that mean that nothing in the MySQL database
is being used then 
>> because SPAM is not working? 
>>     
>
>   
>> I know that amavis is at least connecting to the
database ok and pulling 
>> a policy, because of this in amavis debug (after I
send an external email) :
>>     
>
>   
>> connect_to_sql: trying
'DBI:mysql:maildb:localhost'
>> connect_to_sql: 'DBI:mysql:maildb:localhost'
succeeded
>>     
>
>   
>> Where can I start to troubleshoot this problem? Is
it a spamassasin 
>> problem? or and amavis problem? 
>>     
>
>   
>> Thanks,
>> Matt
>>     
>
> Assuming spamassassin is installed, have you looked in
amavisd.conf to
> see if you have disabled spam scanning?
>
> # bypass_spam_checks_maps  = (1);  # uncomment to
DISABLE anti-spam code
>
> I see this in the example:
>
> map { $bypass_spam_checks{lc($_)}=1 } (qw(
>         postmaster
>         abuse
> ));
>
> Try commenting this out. You can set these in your SQL
database.
>
> Gary V
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a
groundbreaking scripting language
> that extends applications into web and mobile media.
Attend the live webcast
> and join the prime developer group breaking into this
new coding territory!
> http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=110944&bid=241720&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/
>   


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking
scripting language
that extends applications into web and mobile media. Attend
the live webcast
and join the prime developer group breaking into this new
coding territory!
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=110944&bid=241720&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/
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )