(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@???
