Re: [Exim] Exim & MySQL

Página Inicial
Delete this message
Reply to this message
Autor: Konrad Michels
Data:  
Para: exim-users
Assunto: Re: [Exim] Exim & MySQL
I've been following this thread for a while now, and I'm thinking it
would be fantastic if someone had some more specific guidance on using
exim with mysql, as in what can be done, example extracts from config
files etc etc.

I'm not clued up on mysql other than from a basic sysadmin perspective,
which does not really onvolve much other than setting it up and
maintenance of data - the data massaging bit I usually leave to the
developers using the database.

It would be immensely useful if there were some documentation which I
could refer to as and when needed to achieve what I want to achieve with
exim and mysql, as I know there is a lot that I can use mysql for with
Exim but just don't do it because I don't have any references other than
what's in the current Exim manual. What's in the current Exim manual is
useful, but I haven't run across any document examples of it being used
in the real world.

Just my £0.02 worth . . .

Later
Konrad


On Wed, 2003-05-07 at 10:23, Philip Hazel wrote:
> On Tue, 6 May 2003, William Thompson wrote:
>
> > It would be nice to have the ability to simply put all data from a lookup
> > like that and check each line. I thought that's how it'd work, but when I
> > RTFM, I noticed it was only going to return true/false which in my case when
> > I was testing, it was always true (because of the sql condition).
> >
> > If something like that's possible, I'd like to wishlist it.
>
> Sorry, I'm not exactly clear what you are asking for here. I'm probably
> missing some vital point. At present you have two choices for the way
> you use lookups in a list:
>
> 1. Have the lookup return a list, which is then searched. The syntax is:
>
>     hosts = ${lookup mysql ..... }

>
> 2.  Use the lookup as a way of indexing into a list of permitted hosts/
>     domains/whatever. The syntax ix:

>
>     hosts = mysql;...

>
> You can even use both of these in the same item:
>
>     hosts = mysql;... : ${lookup mysql ....}

>
> Clearly, you are asking for a third facility, but I'm not sure what it
> is. Please point out to me what I am missing here!
>
>
> --
> Philip Hazel            University of Cambridge Computing Service,
> ph10@???      Cambridge, England. Phone: +44 1223 334714.

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

--
===============
ADVANCE NOTICE:
NB!!! Please note that Konrad will be on leave (and therefore not very
contactable or useful even when you can contact him) from Friday,
June 13th 2003 until June 29th 2003, both dates inclusive. I will be
back in the office on June 30th 2003.

***********************************************************************
*
* Konrad Michels
* System Administrator
* Surfkitchen Limited
* Abbey House
* 1650 Arlington Business Park
* Theale
* RG7 4SA
* United Kingdom
* Tel: +44 118 929 8079
*
***********************************************************************