[exim] Other Fearures that Exim should have

Jumping on the wagon...

Some time ago - I tried to have Exim do (My)SQL updates. It would be
nice to have more generic access to Databases - etc..
rather than fudging it..

ie in "transports" - I have....

mysql_delivery:
  driver = appendfile
  directory = /var/spool/mail/$domain/$local_part/
  maildir_format = true
  directory_mode = 0755
  create_directory = true
  user = smmsp
  group = smmsp
  mode = 0660
 quota = ${lookup mysql {select mquota from admin \
    where user='${local_part}@${domain}' and status>1}}M
 quota_is_inclusive=false

message_suffix = ${lookup mysql {insert into maillog set
mfrom='${quote_mysql:$sender_address}',\
    mto='${quote_mysql:$local_part}@${domain}', domain='${domain}',
mvia='${quote_mysql:$sender_host_address}',\
    msize=${message_size}, mdelivered=current_timestamp,
mailid='$message_id', mspam='$spam_score_int',\
    mreturn='${quote_mysql:$return_path}' }{}{}}

The "Message suffix" is being used to do Accounting updates...
Ugly Hack.

Be nicer to have a dummy or generic label - even one that you could
maybe return a result to a variable?

set $acl_var2=${lookup mysql {select mquota from admin \

    where user='${local_part}@${domain}' and status>1}}

Practical?

-- 
  .  .     ___. .__      Posix Systems - Sth Africa
 /| /|       / /__       mje@???  -  Mark J Elkins, SCO ACE, Cisco CCIE
/ |/ |ARK \_/ /__ LKINS  Tel: +27 12 807 0590  Cell: +27 82 601 0496