Difference between revisions of "Email Statistics"

From SME Server
Jump to navigationJump to search
Line 47: Line 47:
 
Sample output:
 
Sample output:
 
  # qplogtail
 
  # qplogtail
  14185   213.37.31.24    dnsbl   msg denied before queued
+
  <nowiki>14868   209.74.246.66  0/30
14262   64.233.184.243  1/40
+
14868  209.74.246.66   check_basicheaders      msg denied before queued
14262  64.233.184.243  queued  No, hits=-101.1 required=5.0_
+
14868   209.74.246.66  1.622 sec.
14320   71.8.114.81    1/40
+
14879   200.127.59.114 0/30
14320   71.8.114.81    dnsbl  msg denied before queued
+
14879   200.127.59.114 dnsbl  msg denied before queued
14349   200.63.233.145 1/40
+
14879   200.127.59.114 2.874 sec.
  14349   200.63.233.145  dnsbl   msg denied before queued
+
14890  69.147.64.214  0/30
 +
14890  69.147.64.214  queued No, hits=-2.6 required=5.0_
 +
14890   69.147.64.214   7.433 sec.</nowiki>
 +
 
  
 
To install:
 
To install:
 
  cd /usr/local/bin
 
  cd /usr/local/bin
  wget -O qplogtail <nowiki>http://bugs.contribs.org/attachment.cgi?id=1379</nowiki>
+
  wget -O qplogtail <nowiki>http://bugs.contribs.org/attachment.cgi?id=2035</nowiki>
 
  chmod 755 qplogtail
 
  chmod 755 qplogtail
  

Revision as of 23:49, 26 June 2008

Email Statistics

How to get statistics about the performance of your mail server

Built-In Statistical Reports

Server-Manager

Some email statistics can be seen from server-manager under "Administration", "Mail log file analysis"

qplogsumm.pl

SME 7.2 and later include the 'logterse' plugin to qpsmtpd as well as the 'qplogsumm.pl' statistics script.

qplogsumm.pl updates /var/log/qpsmtpd/state with per-plugin statistics for any qpsmtpd plugin that appears in a qpsmtpd logterse entry each time the qpsmtpd log is rotated.

Sample output here

e-smith-viewlogfiles-1.8.0-4 (released Nov 28 2007) or later will allow you to 'View' /var/log/qpsmtpd/state from 'View log files' in the server-manager (earlier versions conceal all files named "state" - Bug 3416).

Currently, qplogsumm.pl is disabled by default. Enable it with

config setprop qpsmtpd qplogsumm enabled
signal-event email-update

Contribs & Addons

Brian Read's spamfilter-stats-7.pl

Brian Read's mailstats contrib analyzes your qpsmtpd log files and sends an email to the specified email address summarizing your SME server activity.

Full details can be found at mailstats

qplogtail

qplogtail is a script intended to help monitor /var/log/qpsmtpd/current and extract a concise but meaningful display of what the server is up to.

qplogtail extracts 5 kinds of information:

  1. Normal connections:
    28545 Accepted connection 4/30 from 86.139.2.73 ...
  2. Errors in violation of Instances:
    5146 Too many connections: 40 >= 40. Waiting one second.
  3. Errors in violation of InstancesPerIP:
    5320 hosts_allow plugin: Too many connections from 212.100.229.201: 6 > 5Denying connection.
  4. Messages blocked by any qpsmtpd plugin:
    15751 logging::logterse plugin: ` 82.210.181.241 241-pra-6.acn.waw.pl 241-pra-6.acn.waw.pl <Glasteinzhza@ask-it-here.com> dnsbl 903 http://www.spamhaus.org/query/bl?ip=82.210.181.241 msg denied before queued
  5. Messages queued for delivery:
    15587 logging::logterse plugin: ` 128.220.32.40 miami.deuvis.com miami.deuvis.com <aapple@deuvis.com> <c.wolf@ncxr.org> queued <200709270344.l8R3iq0b010299@deuvis.com> No, hits=-2.6 required=5.0_

Each smtp transaction will generate two lines of output containing:

msgid   remote_ip   x/40
msgid   remote_ip   dispostion   details

Sample output:

# qplogtail
14868   209.74.246.66   0/30
14868   209.74.246.66   check_basicheaders      msg denied before queued
14868   209.74.246.66   1.622 sec.
14879   200.127.59.114  0/30
14879   200.127.59.114  dnsbl   msg denied before queued
14879   200.127.59.114  2.874 sec.
14890   69.147.64.214   0/30
14890   69.147.64.214   queued  No, hits=-2.6 required=5.0_
14890   69.147.64.214   7.433 sec.


To install:

cd /usr/local/bin
wget -O qplogtail http://bugs.contribs.org/attachment.cgi?id=2035
chmod 755 qplogtail

To run:

qplogtail


Direct comments or questions to Bugzilla:3418

Qpsmtpd_connection_time

See qpsmtpd_connection_time