On Monday 21 October 2002 10:06 am, Nico Erfurth wrote:
> > I am wondering how versatile exim's aliases from SQL tables is. I'm
> > trying to make a dynamic static mailing-list alias, for static
> > delivery.
> > For example, an employees@domain alias, to send an email to every
> > employee, with one simple address to send to.
> >
> > What I'm wondering is. Can I have multiple rows for such an alias in SQL?
> > Like for example:
> >
> > domain | list | email
> > ------------+------------+----------------------
> > domain.com | employees | psi-jack@???
> > domain.com | employees | user1@???
> > domain.com | employees | user2@???
>
> This should work, the pgsql lookup will return
>
> psi-jack@???
> user1@???
> user2@???
>
> if you feed this into the data-option of your redirect-router everything
> is ok.
>
> ciao
sql_aliases:
driver = redirect
allow_fail
allow_defer
data = ${lookup pgsql {SELECT list,email FROM staticlists WHERE domain =
'$domain'}}
file_transport = address_file
pipe_transport = address_pipe
Oct 21 10:15:16 ginseng.myrddincd.com exim[10363]: 2002-10-21 10:15:16
H=relay2.pgsql.com [64.49.215.143]
F=<pgsql-general-owner+M31896@???> temporarily rejected RCPT
<psi-jack@???>: error in redirect data: missing or malformed local
part (expected word or "<") in "list=employees email=psi-jack@???"
Oct 21 10:15:16 ginseng.myrddincd.com exim[10363]: 2002-10-21 10:15:16
H=relay2.pgsql.com [64.49.215.143]
F=<pgsql-general-owner+M31896@???> temporarily rejected RCPT
<psi-jack@???>: error in redirect data: missing or malformed local
part (expected word or "<") in "list=employees email=psi-jack@???"
Why am I getting this though? :/
--
Eric Renfro
Myrddin Computers & Designs - CEO/President
