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
