Re: [Exim] exim + MySQL problem

Hmm..

Have you tried adding a \ in front of @ in your router? Also turn on
logging in your mysql database and see what the exact SQL Select
statement exim is sending to it.

mysql_user:
   driver = accept
   condition = \
    ${if eq{} \
      { ${lookup mysql {SELECT home FROM passwd \
          WHERE email='${local_part}\@${domain}'}} \
      } \
      {no}{yes} \
    }
   retry_use_local_part
   transport=mysql_delivery

Dawid SzymaXski wrote:
> On Fri, 26 Jul 2002 10:19:50 -0300
> Patrick Boutilier <boutilpj@???> wrote:
>
>
>>What happens when you run this query from a mysql prompt?
>>
>>SELECT home FROM passwd WHERE email='dasdada@???'
>
>
> mysql> SELECT home FROM users WHERE email='dasdada@???';
> Empty set (0.01 sec)
>
> mysql>
>
>
>
>
> --
>
> Regards,
> Dawid Szymanski
>
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>