Author: Jai Shinde Date: To: exim-users Subject: [Exim] USERID using MYSQL Database
Hi,
I am trying to get USERID from the mysql database. i am getting following
error message.
LOG: 0 MAIN PANIC
Failed to find user "" from expanded string "${lookup mysql{select USERID
from UID where EMAILID='${local_part}'}{$value}}"
from the virtual_local_delivery transport
LOG: 0 MAIN
== yahoo22@??? <yahoo22@???> T=virtual_local_delivery defer (-30):
Failed to find user "" from expanded
string "${lookup mysql{select USERID from UID where
EMAILID='${local_part}'}{$value}}" from the virtual_local_delivery transport
Where local_delivery parameters are....
virtual_local_delivery:
driver=appendfile
file=
/mail/${substr_0_1:$local_part}/${substr_1_1:$local_part}/${substr_2_1:$loca
l_part}/${local_part}
delivery_date_add
envelope_to_add
return_path_add
group = exim
user = ${lookup mysql{select USERID from UID where
EMAILID='${local_part}'}{$value}}
#user = 32087
mode=0600
