Re: [Exim] Mysql Lookups

Top Page
Delete this message
Reply to this message
Author: Dave Raven
Date:  
To: Nico Erfurth
CC: exim-users
Subject: Re: [Exim] Mysql Lookups
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/ ##
:
: