On Mon, 31 Jan 100 kwild@??? wrote:
> The SQL statment for the relay check looks like
>
> MYSQL_RELAY = SELECT rel_ip FROM RELAY where
> rel_ip='${quote:$sender_address}' and DATE_ADD( rel_ts, INTERVAL "10"
> MINUTE ) > NOW()
>
> And the host_accept_relay looks like
>
> host_accept_relay = localhost: mysql;MYSQL_RELAY
The problem is that your SQL statement contains a colon, and
host_accept_relay operates on a colon-separated list. This has been
concealed by the use of a macro. However, Exim macros are very, very
simple, and are just textual substitutions, nothing more. The macro
substitution happens before the line is interpreted in any way.
So you need to double up the colon in your query.
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
