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


Reply via email to