Re: [Exim] local domains from mysql db

yes, it's nothing like that, i think i've got it working now anyway.



Subject: RE: [Exim] local domains from mysql db


> I may be incorrect.... but did you compile exim with mysql functionality ?
>
> -----Original Message-----
> From: me& [mailto:exim-list@opbit.com]
> Sent: 25 March 2002 02:53
> To: Gareth Down; exim-users@???
> Subject: Re: [Exim] local domains from mysql db
>
>
> I don't really know what your problem is because :
>
> local_domains mydomain.com:mysql;SELECT domain FROM domains where
> domain='$key';
>
> works perfectly here
>
> EG
>
> > > On 2002-03-25 at 02:25 -0000, exim wrote:
> > > > > "select domain_name from domains;" will return how many rows from
> this
> > > > > little database?
> > > > >
> > > > > Hint: answer != 1
> > > > </phill>
> > > >
> > > > True, but when you do "lsearch;/usr/exim/aliases/domains" the answer
> is
> > also
> > > > != 1 isn't it?
> > >
> > > lsearch is completely internal to Exim. Exim knows how to construct
the
> > > query. Exim knows how to do "The Right Thing". It supplies an
implicit
> > > key for the search.
> > >
> > > Mutating SQL queries to try to do The Right Thing is almost certainly
> > > The Wrong Thing, The Frigging Stupid Thing, the I Just Spent How Many
> > > Hours Debugging Something Which Was Silently Changed????? Thing, and
> > > many others.
> > >
> > > > I tried that ("mysql;select domain_name where domain_name =
> '$domain';")
> > but
> > > > that didn't work...
> > >
> > > Where are you selecting from?
> >
> > Sorry I wrote it in the message wrong, hmmm..... I don't know, I suppose
> > I'll just have to
> > keep trying different things then.
> >
> > Cheers for your help anyway,
> >
> > Gareth
> > gjd@???
> >
> >
> >
> >
> > --
> >
> > ## 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/ ##
> NOTICE:
>
> This message contains privileged and confidential information intended
> only for the person or entity to which it is addressed.
>
> Any review, retransmission, dissemination, copy or other use of, or
> taking of any action in reliance upon this information by persons or
> entities other than the intended recipient, is prohibited.
>
> If you received this message in error, please notify the sender
> immediately by e-mail, facsimile or telephone and thereafter delete the
> material from any computer.
>
> The New Africa Capital Group, its subsidiaries or associates do not accept
liability for any
> personal views expressed in this message.
>