Re: [exim] Help with MySQL user stats

Top Page
Delete this message
Reply to this message
Author: Mark Elkins
Date:  
To: exim-users
Subject: Re: [exim] Help with MySQL user stats
On Mon, 2005-10-31 at 14:11 +0000, Terry wrote:
> Mark Elkins wrote:
> > Because I'm not aware of any simple way to do real-time logging of
> > e-mail stats inside exim - I've put together a few hacks...
> >
> > For example - to 'log' the number and size of emails - in routers
> > I have....
> >
> > mysql_user:


blah blah

> >
> > ps - What exim could do with is a general purpose "condition" which

can
> > be used to run a MySQL request at any time.... call it "dbrequest"

and
> > allow it to be used in all sections..??? This would be ideal then

for
> > stats gathering..


> Have you seen exilog
> http://duncanthrax.net/exilog/exilog.txt


Not the solution - I want to take small bits of info and populate my
custom database with it...

In Transports, Under "mysql_delivery:"
I also have...
  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 = 20M
# quota = ${lookup mysql {select quota from admin \
#    where user='${local_part}@${domain}' and status>1}} \
quota_is_inclusive=false


message_suffix = ${lookup mysql {insert into maillog set
mfrom='${quote_mysql:$sender_address}', mto='${quote_mysql:$local_part}@
${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}' }{}{}}



Again - this is a hack (using "message_suffix"). If exim had a
"dbrequest" function, then Duncan's Exim Logger could collect data real
time.
-- 
  .  .     ___. .__      Posix Systems - Sth Africa.  e.164 VOIP ready
 /| /|       / /__       mje@???  -  Mark J Elkins, Cisco CCIE
/ |/ |ARK \_/ /__ LKINS  Tel: +27 12 807 0590  Cell: +27 82 601 0496