[Exim] USERID using MYSQL Database

Góra strony
Delete this message
Reply to this message
Autor: Jai Shinde
Data:  
Dla: exim-users
Temat: [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

can anybody tell me whats the error....

Thanx in Advance..


Have Fun
Jai