[exim] Problems with mysql query

Top Page
Delete this message
Reply to this message
Author: Adrian Chapela
Date:  
To: exim-users
Subject: [exim] Problems with mysql query
Hello,

I can't select a user from a mysql database.

The query seem not execute and I don't understand anything.

I have a user in local and it's OK. The exim was compiled with mysql
support.

The domains list can't be retrevied from the database and no error....

The config:

The domain list error:
domainlist local_domains = localhost: mysql;SELECT userid FROM domains
WHERE userid='$domain';

The domain list OK:
domainlist local_domains = localhost : example.es

#Router
virtual_users:
driver = redirect
allow_fail
allow_defer
data = ${lookup mysql{select maildir from users where
id='$local_part@$domain'}{$value}fail}
directory_transport = virtual_delivery

#Transport
virtual_delivery:
debug_print='T: para $local_part@$domain'
driver = appendfile
maildir_format
delivery_date_add
envelope_to_add
return_path_add
group = mail
user = mail
mode = 0660

The errors:13:21:41 29972 local_part=proba_salva domain=example.es
13:21:41 29972 calling virtual_users router
13:21:41 29972 rda_interpret (string): ${lookup mysql{select maildir 
from users where id='$local_part@$domain'}{$value}fail}
13:21:41 29972 expanding: select maildir from users where 
id='$local_part@$domain'
13:21:41 29972    result: select maildir from users where 
id='proba_salva@???'
13:21:41 29972 search_open: mysql "NULL"
13:21:41 29972 search_find: file="NULL"
13:21:41 29972   key="select maildir from users where 
id='proba_salva@???" partial=-1 affix=NULL starflags=0
13:21:41 29972 LRU list:
13:21:41 29972   :/etc/aliases
13:21:41 29972   End
13:21:41 29972 internal_search_find: file="NULL"
13:21:41 29972   type=mysql key="select maildir from users where 
id='proba_salva@???"
13:21:41 29972 database lookup required for select maildir from users 
where id='proba_salva@???'
13:21:41 29972 MYSQL query: select maildir from users where 
id='proba_salva@???'
13:21:41 29972 MYSQL new connection: host=localhost port=0 socket=NULL 
database=maildb user=mail