[exim] Postgres Lookup failure..

Top Page
Delete this message
Reply to this message
Author: Jerry Wintrode
Date:  
To: exim-users
Subject: [exim] Postgres Lookup failure..


I have the following in my configure file:

GREYLIST_TEST = SELECT CASE \
                  WHEN now() - block_expires > 0 THEN 2 \
                  ELSE 1\
                END \
                FROM relaytofrom \
                WHERE relay_ip='${quote_pgsql:$sender_host_address}' \
                AND from_domain='${quote_pgsql:$sender_address_domain}'


GREYLIST_ADD  = INSERT INTO relaytofrom (relay_ip, from_domain) \
                VALUES ( '${quote_pgsql:$sender_host_address}, \
                '${quote_pgsql:$sender_address_domain}')





And the following acl_check_data entries:

# Greylist config
  #
  warn    set acl_m7 = ${lookup pgsql{GREYLIST_TEST}{$value}{0}}
  defer   message = Temporary Local Error. Please try again later.
        condition = ${if eq{$acl_m7}{0}{1}}
        condition = ${lookup pgsql{GREYLIST_ADD}{yes}{no}}
  defer condition = ${if eq{$acl_m7}{1}{1}}



The fails with the following error:

temporarily rejected after DATA: PGSQL: query failed: ERROR: syntax
error at or near "domain" at character 75

The @ character is messing this up. Anyone have an idea of why this is
happening?


Thanks in advance.

Jerry Wintrode