Re: [exim] Using Postgres lookup for SMTP auth

Pàgina inicial
Delete this message
Reply to this message
Autor: Jakob Hirsch
Data:  
A: Rory Campbell-Lange, Exim Users, mark
Assumpte: Re: [exim] Using Postgres lookup for SMTP auth
Quoting Rory Campbell-Lange:

>   server_set_id = \
>     ${if and {{eq{$2}${lookup pgsql {
>     SELECT password FROM users where userid || '@' || domain = '${quote_pgsql:$1}'
>     }}}}{yes}{no}}


I don't really understand you problem, but I would use this:

public_name = PLAIN
...
server_condition = \
 ${if eq {$auth3} {${lookup pgsql {\
    SELECT password FROM users \
    WHERE userid || '@' || domain = '${quote_pgsql:$auth2}'} \
  {$value}fail}}} }



For LOGIN, decrease the X of all $authX by one.