Re: [exim] Using Postgres lookup for SMTP auth

Startseite
Nachricht löschen
Nachricht beantworten
Autor: Jakob Hirsch
Datum:  
To: Rory Campbell-Lange, Exim Users, mark
Betreff: 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.