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.
>
>
>
