Re: [Exim] help with condition

Top Page
Delete this message
Reply to this message
Author: Johann Spies
Date:  
To: exim-users
Subject: Re: [Exim] help with condition
--
On Tue, Feb 03, 2004 at 03:56:29PM +0200, Johann Spies wrote:
>
> Hallo Nico,
>
> ...
> >
> > The more advanced way:
> >
> > condition = ${if < {$message_size} {80k} \
> >     {${lookup pgsql \
> >         {select 1 from emailuser where \
> >          username='${uc:${quote_pgsql:$local_part}}' and \
> >          spamdelete = 't' limit 1} \
> >       }\
> >     }\
> >   }

> >
>
> Thanks for your clear explanation.
>
> The condition is used in the acl check_data section.
>
> I have tried your advanced example and I it works perfectly.


Or so I thought. It actually does not. Exim does not complain but
the condition is never satisfied. We have nearly 20000 users and
about 1000 of them have selected 'f' in their "spamdelete" field.

But if I use this condition, no spam gets rejected.

Here is my full acl for exiscan-spamassassin:

acl_check_data:

warn message = X-Spam-Score: $spam_score ($spam_bar)
     condition = ${if < {$message_size} {80k} {1}{0}}
     spam = spamd:true



# reject messages that score more than 8
  deny message = Message viewed as spam. (scored $spam_score SpamAssassin points.)
       condition = ${if < {$message_size} {80k} \
           {${lookup pgsql \
           {select 1 from emailuser where \
           username='${uc:${quote_pgsql:$local_part}}' and \
           spamdelete = 't' limit 1} \
             }\
           }\
         }
        spam = spamd:true
        condition = ${if >{$spam_score_int}{80}{1}{0}}
        log_message = Message viewed as spam. (scored $spam_score SpamAssassin points.)


accept

I need to get this working urgently and I do not make any progress at
the moment.

I hope somebody can open my eyes for the solution.

Regards
Johann

--
Johann Spies          Telefoon: 021-808 4036
Informasietegnologie, Universiteit van Stellenbosch


     "Lift up your heads, O ye gates; and be ye lift up, ye
      everlasting doors; and the King of glory shall come
      in. Who is this King of glory? The LORD strong and
      mighty, the LORD mighty in battle."
                                   Psalms 24:7,8
--
Content-Description: Digital signature


[ signature.asc of type application/pgp-signature deleted ]
--