Re: [exim] Using Postgres lookup for SMTP auth

Author: Jakob Hirsch
Date:
To: Rory Campbell-Lange, Exim Users, mark
Subject: 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.

This message is part of the following thread:
	the complete thread tree sorted by date
	Rory Campbell-Lange at
	W B Hacker at