On Mon, 9 Aug 1999, Laurent Luyckx wrote:
> Hi
>
> I'm trying to use Exim with mysql.
> I've configure exim to query a database. But Exim said me that I've an
> error and this error is what i want to query !!!
>
> This is my configuration: exim.conf
>
> mysql_servers = radius1.domain.net/qpopper/qpopper/test
> ...
> ...
>
>
> I got this error message:
>
> 1999-08-09 16:54:45 11DuZG-0000Bl-00 == c000@???
> D=system_aliases defer (-1): system_aliases director: search_find
> deferred: MYSQL: query failed: You have an error in your SQL syntax near
> '/var/spool/mail/c/0/00/inbox' at line 1\n
>
> But what I want is exactly : /var/spool/mail/c/0/00/inbox
>
> Where is my error ?
You are trying to do two lookups. You have "mysql" specified as the
search type for aliasfile (which makes it want to send "query" to the
mysql server), and then you are using a mysql lookup to lookup the
query. It does one query, and tries to use the result of that as a
second query.
Try instead:
system_aliases:
driver = aliasfile
search_type = mysql
query="select maildrop from popUsers where username=`$local_part`"
file_transport = address_file
pipe_transport = address_pipe
>
> Laurent Luyckx
>
>
>
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>
