RE: [Exim] PostgreSQL & Aliassing Again

Top Page
Delete this message
Reply to this message
Author: Mark McRitchie
Date:  
To: 'exim-users@exim.org'
Subject: RE: [Exim] PostgreSQL & Aliassing Again
Philip,

can you put a database lookup in the (lookup failed) part?

Regards,
Mark

-----Original Message-----
From: Philip Hazel [mailto:ph10@cus.cam.ac.uk]
Sent: 28 August 2002 15:54
To: Sander Smeenk
Cc: exim-users@???
Subject: Re: [Exim] PostgreSQL & Aliassing Again


On Wed, 28 Aug 2002, Sander Smeenk wrote:

> But I also want that all email to a $local_part NOT SPECIFIED in the
> database goes to 'thisuser@???'.



   data = ${lookup pgsql{SELECT destination FROM exim_user_aliases
   WHERE lower(localpart) = lower('${quote_pgsql:$local_part}') AND
   lower(owner) = lower('${quote_pgsql:$domain}') LIMIT 1}}
                                                         ^
                                                         ^
Make use of the "lookup failed" features of Exim. Instead of ending your
expansion with "}}" use


}{$value}{thisuser@???}}

Voila.

--
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/ ##


Salamis Group of Companies - WWW.SALAMISGROUP.COM

This communication contains information which is confidential and may
also be privileged. It is for the exclusive use of the intended
recipient(s). If you are not the intended recipient(s) be advised
that any form of distribution, copying or use of this communication
or the information it contains is strictly prohibited and may be
unlawful. We apologise if you have received this communication in
error. Please return it to the sender immediately, delete this
communication from your computer and destroy any copies of it. Any
views/opinions expressed in this email are that of the author and may
not reflect the views of Salamis (M&I)Ltd.