My question, is how do a or condition, for the valid sender
2007/3/11, Peter Bowyer <peter@???>:
> (top-posting because my response relates to the original as a whole)
>
> You don't seem to have asked a question. You've given lots of detail,
> but what actually is the problem? If the router you quote is supposed
> to solve the issue you mention, what happens that isn't what you
> expected? What's the debug output look like when you try a delivery
> that you want to work, and one that you want to fail?
>
> Peter
>
> On 10/03/07, Alex <abusquets@???> wrote:
> > Hi, i have this two tables
> >
> > CREATE TABLE group_contents(
> > group_id int(10) DEFAULT '0' NOT NULL,
> > member varchar(255) DEFAULT '0' NOT NULL
> > admin char(1) NOT NULL default 'Y',
> > )
> >
> > CREATE TABLE groups(
> > id INTEGER NOT NULL PRIMARY KEY,
> > domain_id mediumint (8) NOT NULL default '0',
> > name varchar(64) NOT NULL default '',
> > is_public char(1) NOT NULL default 'Y',
> > enabled tinyint(1) NOT NULL default '1'
> > );
> >
> >
> > groups.is_public allows Y,N,A
> > Y -> public
> > N -> not public
> > A -> only senders admin can send
> >
> >
> > I need add a rule for allow send emails to the group if sender is
> > group_contents.admin is Y and the group groups.is_public value is A,
> >
> >
> > Now I have this:
> >
> >
> > virtual_dom_groups:
> > driver = redirect
> > allow_fail
> > senders = ${if eq{Y}{${lookup sqlite{/etc/exim/exim.db select g.is_public \
> >
> > from groups g, domains d \
> > where d.enabled = '1' and
> > d.domain = '${domain}' and \
> > d.domain_id = g.domain_id
> > and g.enabled = '1' and \
> > g.name = '${local_part}'}}} \
> > {$sender_address} \
> > {${lookup sqlite{/etc/exim/exim.db select c.member \
> > from group_contents c, groups g, domains d \
> > where g.enabled = '1' and g.id = c.group_id and g.is_public = 'N' \
> > and d.domain = '${domain}' \
> > and d.domain_id = g.domain_id and g.enabled = '1' \
> > and g.name = '${local_part}' \
> > and c.member LIKE '${sender_address}' limit 1}}}}
> >
> > data = ${lookup sqlite{/etc/exim/exim.db \
> > select c.member \
> > from group_contents c, groups g, domains d \
> > where d.enabled = '1' and \
> > d.domain = '${domain}' and \
> > d.domain_id = g.domain_id and \
> > g.enabled = '1' and \
> > g.id = c.group_id and \
> > g.name = '${local_part}'} }
> >
> > headers_remove = subject
> > headers_add = Subject: [${lookup sqlite{/etc/exim/exim.db select g.name \
> > from groups g, domains d \
> > where d.enabled = '1' and
> > d.domain = '${domain}' and \
> > d.domain_id = g.domain_id
> > and g.enabled = '1' and \
> > g.name =
> > '${local_part}'}}] $h_subject
> > local_part_suffix = -*
> > local_part_suffix_optional
> > retry_use_local_part
> > reply_transport = address_reply
> > pipe_transport = address_pipe
> >
> > --
> > ## List details at http://www.exim.org/mailman/listinfo/exim-users
> > ## Exim details at http://www.exim.org/
> > ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
> >
>
>
> --
> Peter Bowyer
> Email: peter@???
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users
> ## Exim details at http://www.exim.org/
> ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
>
