[Exim] Mysql Problem

Startseite
Nachricht löschen
Nachricht beantworten
Autor: Laurent Luyckx
Datum:  
To: exim-users@exim.org
Betreff: [Exim] Mysql Problem
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
...
...
system_aliases:
driver = aliasfile
search_type = mysql
query = ${lookup mysql{select maildrop from popUsers where
username='$local_part'} {$value}fail}
file_transport = address_file
pipe_transport = address_pipe


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 ?

Laurent Luyckx