but I now have a new error message:
2002-11-05 09:58:35 188yba-000KkP-00 == dave@???
<dave@???>
T=mysql_relay defer (-33): failed to lookup IP address for
192.168.0.21"
The value for 'ip from relays where id=raven.za.net' is
192.168.0.21.
So; its getting it right, but how am I to get it to relay the
message to
that ip? All I have changed is the hosts line to what you
recommended.
Thanks
Dave
- ----- Original Message -----
From: "Nico Erfurth" <masta@???>
To: "Dave Raven" <dave@???>
Cc: <exim-users@???>
Sent: Monday, November 04, 2002 3:01 PM
Subject: Re: [Exim] Mysql Lookups
: Dave Raven wrote:
: > Hi all,
: > I'm busy moving over to mysql from plain text files
throughout
: > my exim config; and all has been going well but I cant seem
: > to figure out one problem.
: >
: > I have a relay director; which calls this transport:
: >
: > mysql_trans:
: > driver = smtp
: > hosts = "mysql;SELECT ip FROM relays WHERE id='$domain';"
:
: Try this
: hosts = ${lookup mysql{SELECT ip FROM relays WHERE \
: id='${quote_mysql:$domain}'}{$value}}"
:
: --
:
: ## List details at http://www.exim.org/mailman/listinfo/exim-users
Exim
: details at http://www.exim.org/ ##
:
:
:
:
:
: --
:
: ## List details at http://www.exim.org/mailman/listinfo/exim-users
Exim details at http://www.exim.org/ ##
:
: