On Mon, 31 Jan 100 kwild@??? wrote:
> MYSQL_RELAY = SELECT concat(rel_ip,':') FROM RELAY where
> rel_ip='${quote:$sender_address}' and DATE_ADD( rel_ts, INTERVAL "10"
> MINUTE ) > NOW()
>
> >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.
>
> This statement do not work also.
Sorry, which does not work? What you need is
MYSQL_RELAY = SELECT concat(rel_ip,'::') FROM RELAY where \
rel_ip='${quote::$sender_address}' and DATE_ADD( rel_ts, INTERVAL "10" \
MINUTE ) > NOW()
> When statring the session with telnet SERVERIP 25 the connection should be
> closed?
Not immediately.
> Or later ...
>
> Can you give me a hint how to debug the session?
Check out the -bh option. You can use this in conjunction with -d9 to
get extra debugging information.
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
