[exim] condition help

Top Page
Delete this message
Reply to this message
Author: Alex
Date:  
To: exim-users
Subject: [exim] condition help
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