Re: [Exim] Exim & PostgreSQL 2 :)

Top Page
Delete this message
Reply to this message
Author: Joachim Wieland
Date:  
To: exim-users
Subject: Re: [Exim] Exim & PostgreSQL 2 :)
Hi,

On Fri, Mar 08, 2002 at 04:51:47PM -0000, Andy Hedges wrote:
> Oh and then use the variable like this


> local_domains =     machine.example.com : \
>             localhost : \
>             pgsql;PGSQL_LOCAL_MAILALIAS


Yes, the last line is the important Information:

local_domains is a list, not a string, so the proper syntax (without
macros) is:

domainlist local_domains = pgsql;select domain from tbldomains \
where domain = '$domain' and ... ;

Is it really necessary to add a "DISTINCT" ?

Other question: When should one use the quote function? Of course it is
necessary to do it as often as possible, could there arise SQL injection
attacks with malformed e-Mail headers? (Assuming that the MUA doesn't
reject them because of invalid characters)... It seems to be used quite
seldom in the examples posted here.


Joachim

--
*****PGP key available - send e-mail request***** - ICQ: 37225940
When space has no frontiers, then why the hell does the Voyager crew always
meet the same species?