Re: [Exim] exim + MySQL problem

Top Page
Delete this message
Reply to this message
Author: Patrick Boutilier
Date:  
To: exim-users
Subject: Re: [Exim] exim + MySQL problem
What is going on here is that the bogus account is being reported as a
good one by your router and then it fails to get the group in the transport.

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




What happens when you run this query from a mysql prompt?

SELECT home FROM passwd WHERE email='dasdada@???'





Dawid SzymaXski wrote:
> This is a multi-part message in MIME format.
> --
> Hi!
>
> I'm trying to set up exim with MySQL that doesnt handle local (system) accounts, just those in SQL dbase.
>
> My configuration (attached) is based on config file on:
> http://www.tty1.net/stuff/exim4.conf-vdomains
>
> Whats the problem then? So
>
> In dbase I have only one user "test@???"
> when I send e-mail to test@??? all works fine,
> but when trying to send to some other user that doesnt exist in dbase I get:
>
> 2002-07-26 14:05:06 17Y3qE-000CGa-00 == dasdada@??? R=mysql_user T=mysql_delivery defer (-28): Failed to find group "" from expanded string "${lookup mysql {SELECT gid FROM users    WHERE email='${local_part}@${domain}'}}" for the mysql_delivery transport

>
> What may couse it ?;[
>
> --
>
> Regards,
> Dawid Szymanski
> --
> [ config.wrong of type application/octet-stream deleted ]
> --
>
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>