Re: Exim i autoryzacja użytkowników z bazy.

[TG]

Dzięki za pomoc ale zrobiłem już tak:

MYSQL_AUTH1=select concat(nazwa,'@',domena) from skrzynki where 
concat(nazwa,'@',domena)='$2' AND haslo='$3'
MYSQL_AUTH2=select concat(nazwa,'@',domena) from skrzynki where 
concat(nazwa,'@',domena)='$1' AND haslo='$2'

begin authenticators
 plain:
   driver = plaintext
   public_name = PLAIN
   server_condition = ${lookup mysql{MYSQL_AUTH1}{1}fail}
   server_prompts = :
   server_set_id = $2

 login:
   driver = plaintext
   public_name = LOGIN
   server_prompts = "Username:: : Password::"
   server_condition = ${lookup mysql{MYSQL_AUTH2}{1}fail}
   server_set_id = $1

I działa! Ale jak to sie ma do autoryzacji po SSL? W logach wydaje się OK... 
A co Wy myślicie?

----- Original Message ----- 
From: "Arkadiusz Rdest" <weed w punkt.pl>
To: "PLD: Users list (Polish)" <pld-users-pl w lists.pld-linux.org>
Sent: Sunday, February 24, 2008 12:28 AM
Subject: Re: Exim i autoryzacja użytkowników z bazy.

np. tak


AUTH_PLAIN        = SELECT password_enc FROM mail_users WHERE username =
'${quote_mysql:$2}'

AUTH_LOGIN        = SELECT password_enc FROM mail_users WHERE username =
'${quote_mysql:$1}'




begin authenticators

plain:
   driver = plaintext
   public_name = PLAIN
   server_prompts = :
   server_condition = "${if and { {!eq{$2}{}} {!eq{$3}{}} \
                        {crypteq{$3}{${lookup
mysql{AUTH_PLAIN}{$value}fail}}} } {yes}{no}}"
   server_set_id = $2

login:
   driver = plaintext
   public_name = LOGIN
   server_prompts = "Username:: : Password::"
   server_condition = "${if and { {!eq{$1}{}} {!eq{$2}{}} \
                        {crypteq{$2}{${lookup
mysql{AUTH_LOGIN}{$value}fail}}} } {yes}{no}}"
   server_set_id = $1


tylko dsotosuj oczywiscie odpowiednio nazwy pol w bazie pod siebie



-- 
  -[  net and sys admin  ]-[ Learn the facts and make up your own ]-
  -[ a.rdest()infomex()pl]-[ damn mind. That's why you have one.  ]-
_______________________________________________
pld-users-pl mailing list
pld-users-pl w lists.pld-linux.org
http://lists.pld-linux.org/mailman/listinfo/pld-users-pl