Hello all!
I use Exim 4.24+Dbmail1.1+Mysql+Drweb!
If my client use auth_plain - system work properly (all ok!)
But if use auth_login - in maillog file i see:
Oct 15 18:13:43 myserver exim[46663]: [1\2] 2003-10-15 18:13:43
auth_login authenticator failed for (programmer) [212.5.102.96]: 435
Unable to authenticate at present (set_id=myuser): lookup of "SELECT
iuser_idnr FROM users WHERE userid = 'myuser' AND passwd = 'mypassword'
" gave DEFER: MYSQL: query failed: Unknown column 'iuser_idnr' in 'field
list'
If who know - HELP me pls!!!!!!
In exim.conf :
auth_login:
driver = plaintext
public_name = LOGIN
server_condition = ${lookup mysql{SELECT iuser_idnr FROM users \
WHERE userid = \
'${quote_mysql:${local_part:$1}}' \
AND passwd = '${quote_mysql:$2}' \
}
server_prompts = "Username:: : Password::"
server_set_id = $1
Best regards,
Dgonny