RE: [exim] Exim 3.36, mySQL and route_list

Top Page
Delete this message
Reply to this message
Author: Rob Stead
Date:  
To: exim-users
Subject: RE: [exim] Exim 3.36, mySQL and route_list

Thank you Adrian,

Your 'exim -bt -d 13 test@???' suggestion is excellent. Thank
you. Useful stuff.

Yes I take your point about version 4. I'm cheating a bit by using a
version 3 OpenBSD package. I also have Exim 4 installed elsewhere.

Good suggestion on Philip Hazel's book which I do actually have. I've also
read all the documentation I can (for two days now) and I can't see were the
syntax error is or what I'm missing.

Could I indulge you with one last question?

In a route_list I read the smarthost is a simple string so is there a way of
passing the result of the query to a string and using this? Eg

my_ans = ${lookup mysql {MYSQL_SMARTHOST}{$value}fail}
route_list = * my_ans bydns_a

Thanks in advance.

Rob

---------------------------------------------------------------
Rob Stead


-----Original Message-----
From: exim-users-bounces@??? [mailto:exim-users-bounces@exim.org] On
Behalf Of Adrian Zaugg
Sent: 06 February 2005 15:02
To: exim-users@???
Subject: Re: [exim] Exim 3.36, mySQL and route_list



Rob Stead wrote:
>
>     smarthost_tg router: failed to expand "${lookup": missing lookup 
> type

Voilà: There must be a syntax error: Exim can't see you want to use a mysql
lookup. *Recheck the docu*. You may also want to try exim's testing features
and use a high debug level:
exim -bt -d 13 test@???

> lack of knowledge sadly doesn't allow me (yet) to understand the
> relationship between these two.

Routers: Remote delivery
Directors: Local delivery

> select route from ...' only appears to work in the director section

No, I don't think.

If you need to do a lot of configuration works, you should consider to buy
Philip Hazel's excellent book about exim. Before you do too much in exim
3.36, consider using exim4, if you can. One day you will need to upgrade
anyway and it might be easier doing it from scratch than migrating an
existing configuration. If you start with exim4, there won't be any need of
migration in the nearer future (is exim5 in sight at all?)... In addition to
this, people on this list can help you much more with the current version
(not mentioning all the goodies of exim4 etc.).

Regards, Adrian.


--
## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at http://www.exim.org/ ##