On Wed, 2003-10-15 at 09:26, [EMAIL PROTECTED] wrote:
> 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!!!!!!
>
That looks easy, remove the i from infront of user_idnr in the select
statement, it looks like it was added improperly. DBmail's id colum is
user_idnr, not iuser_idnr by default.
> server_condition = ${lookup mysql{SELECT iuser_idnr FROM users \
> WHERE userid = \
> '${quote_mysql:${local_part:$1}}' \
> AND passwd = '${quote_mysql:$2}' \
> }
Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]
