Re: [Exim] Subject: in autoreply (vacation)

Hallo Robert Heron,

In message "[Exim] Subject: in autoreply (vacation)"
on 22.05.2002, Robert Heron <robert@???> writes:

RH> Hi All,

RH> I've just configured vacation service using autoreply transport. It looks
RH> like this:

What do you think about this?

CREATE TABLE autoresponder (
  arp_aid int(11) NOT NULL auto_increment,
  arp_usr_aid int(11) NOT NULL default '0',       --- user aid
  arp_subject varchar(255) NOT NULL default '',
  arp_text text NOT NULL,
  arp_from date NOT NULL default '0000-00-00',
  arp_till date NOT NULL default '0000-00-00',
  arp_status smallint(6) NOT NULL default '0',
  PRIMARY KEY  (arp_aid)
) TYPE=MyISAM;

MYSQL_AUTORESP_SUB = \
   Select arp_subject \
   from autoresponder, user, domain, site \
   where \
      dom_name = '${quote_mysql:$domain}' and \
      dom_sit_aid = sit_aid and \
      sit_aid = usr_sit_aid and \
      usr_uname = '${quote_mysql:$local_part}' and \
      arp_usr_aid = usr_aid

MYSQL_AUTORESP_BODY = \
   Select arp_text \
   from autoresponder, user, domain, site \
   where \
      dom_name = '${quote_mysql:$domain}' and \
      dom_sit_aid = sit_aid and \
      sit_aid = usr_sit_aid and \
      usr_uname = '${quote_mysql:$local_part}' and \
      arp_usr_aid = usr_aid

=== DIRECTORY ===

mysql_autoresponder:
   driver         = accept
   condition      = \
      ${if or \
         { \
            { match { $h_precedence: } { (?i)junk|bulk|list } } \
            { eq \
               { \
                  ${lookup \
                     mysql{ MYSQL_AUTORESP_CHK } \
                  {1} \
                  } \
               }{1} \
            } \
         } {no} {yes} \
      }

   transport      = mysql_autoresponder_delivery
   errors_to      = postmaster@$domain
   unseen
   no_verify
   no_expn

=== TRANSPORT ===

mysql_autoresponder_delivery:
  driver             = autoreply
  log                = /var/mail/${domain}/${local_part}_vac_log
  once               = /var/mail/${domain}/${local_part}_vac_once_db
  return_path        = ${local_part}@${domain}
  to                 = ${sender_address}
  from               = ${local_part}@${domain}
  subject            = ${lookup mysql{MYSQL_AUTORESP_SUB}}
  text               = ${lookup mysql{MYSQL_AUTORESP_BODY}}

--
Mit freundlichen Gruessen,
Wild Karl-Heinz
mailto:kh.wild@wicom.li