Re: [Exim] smtp auth

Page principale
Supprimer ce message
Répondre à ce message
Auteur: Ilya
Date:  
À: exim-users
Sujet: Re: [Exim] smtp auth
still doesnt work. I have setup mysql logging and here is the query exim
sends:
                     67 Query      SELECT password FROM users WHERE
user='ilya'
this query does return crypted password. but exim just doesnt go any futher.
if I run exim -d and try to smth AUTH here is what Exim says:


Process 60023 is handling incoming connection from [192.168.0.1]
ready for new message
LOG: 0 MAIN REJECT
Authentication failed for (windows) [192.168.0.1]: 435 Unable to
authenticate at present: "lookup" failed and "fail" requested
LOG: 0 MAIN REJECT
Authentication failed for (windows) [192.168.0.1]: 535 Incorrect
authentication data
LOG: 1 MAIN REJECT
refused relay (host) to <ilya@???> from <ilya@???> H=(windows)
[192.168.0.1]

i tried putting there user which exists (ilya) same result. any ideas? thx a
lot.
here is my configure information again:

plain:
  driver = plaintext
  public_name = PLAIN
server_prompts = "Username:: : Password::"
  server_condition = "${if and { \
                        {!eq{$2}{}} \
                        {!eq{$3}{}} \
                        {crypteq{$3}{${lookup mysql{SELECT password FROM
users WHERE user='$2'}{$value}fail}}} \
                        } {yes}{no}}"
  server_set_id = $2


login:
  driver = plaintext
  public_name = LOGIN
  server_prompts = "Username:: : Password::"
  server_condition = "${if and { \
                        {!eq{${quote_mysql:${local_part:$1}}}{}} \
                        {!eq{${quote_mysql:${local_part:$2}}}{}} \
                        {crypteq{${quote_mysql:${local_part:$2}}}{${lookup
mysql{SELECT password FROM users WHERE user='${quo
te_mysql:${local_part:$1}}'}{$value}fail}}} \
                        } {yes}{no}}"
  server_set_id = ${quote_mysql:${local_part:$1}}


is there any other tests i could make to figure out what is happening?


----- Original Message -----
From: "Andy De Petter" <adepette@???>
To: "Ilya" <mail@???>; <exim-users@???>
Sent: Tuesday, January 16, 2001 3:08 AM
Subject: RE: [Exim] smtp auth


>
> > 2001-01-15 21:49:14 Authentication failed for (shark) [192.168.0.1]: 435
> > Unable to authenticate at present: "lookup" failed and "fail" requested
> >
> > the rest of config works fine with all mysql settings.
> > any ideas how to fix my problems?
> >
> >
>
> This means that exim did actually lookup your user, but it didn't get any
> results back.
>
> Can you try in your query, to replace $2 and $1 with
> ${quote_mysql:${local_part:$2}} and ${quote_mysql:${local_part:$1}}
> accordingly, and see if it works like that? If it still doesn't work,
> replace it with a fixed value, like a user of which you are user he

exists.
>
> -Andy
>
> --
> ......................................................................
> :                                                                    :
> :                           Andy De Petter <adepette@???>   :
> :    Skynet   NV/SA                                System Engineer   :
> :                                                                    :
> : Kol. Bourgstraat 124          _,'|            _.-''``-...___..--'; :
> :    1140  Brussels            /, \'.      _..-' ,      ,--...--'''  :
> :                             < \   .`--'''      `     /|            :
> :   IPv6 ADP17-6BONE           `-,;'              ;   ; ;            :
> :    ICQ # 1548957        __...--''     __...--_..'  .;.'            :
> :                        (,__....----'''      (,..--''               :
> : http://www.skynet.be                                               :
> ......................................................................

>
> The opinions expressed are personal.
>
>
>