[Exim] Problem with smartuser.

Página superior
Eliminar este mensaje
Responder a este mensaje
Autor: Thorkild Stray
Fecha:  
A: exim-users
Asunto: [Exim] Problem with smartuser.
I have the following director:

forward_mysql:
driver = smartuser
panic_expansion_fail=false
transport = remote_smtp
new_address = ${lookup mysql{select forward_adresser from \
preferanser, bruker where bruker.id=preferanser.bruker_id and \
bruker.epost='${local_part}@${domain}'} ${value}fail}

(new_address is all on one line)

This is supposed to look up the forwardaddress in a mysql database.

The problem is, that it isn't working. First I thought the select was
wrong, then the connection with the db, but when I ran exim under d9,
I found this:

forward_mysql director called for some@???
search_open: mysql "NULL"
search_find: file="NULL"
key="select forward_adresser from preferanser, bruker where bruker.id=preferanser.bruker_id and bruker.epost='some@???
'" partial=-1
LRU list:
6/etc/aliases
End
internal_search_find: file="NULL"
type=mysql key="select forward_adresser from preferanser, bruker where bruker.id=preferanser.bruker_id and bruker.epost='stray@or
ganizer.net'"
database lookup required for select forward_adresser from preferanser, bruker where bruker.id=preferanser.bruker_id and bruker.epos
t='some@???'
MYSQL query: select forward_adresser from preferanser, bruker where bruker.id=preferanser.bruker_id and bruker.epost='stray@organiz
er.net'
MYSQL new connection: host=some.machine.com port=3306 database=some user=blatti password=blatti
lookup yielded: someotherplace@???
expansion of "${lookup mysql{select forward_adresser from preferanser, bruker where bruker.id=preferanser.bruker_id and bruker.epo
st='${local_part}@${domain}'} ${value}fail}" failed: missing or misplaced { or }
forward_mysql director failed for stray


so, for me it looks like the lookup succedes, and since transport is
set, new_address should be a new mailaddress, right?

But I can't seem to figure out why the expansion goes wrong. I have
also tried with ${expand:...} without success.

Any ideas?


--
Thorkild