Dotaz: Postfix vytahovani dat z nej

[Evka]

Ahoj, potreboval bych si udelat vlastni statistiku mailu prochazejici nasim postovnim serverem. Upravil jsem

spamfilter unix - n n - - pipe flags=Rq user=spamfilter argv=/usr/local/bin/spamfilter.sh -f ${sender} -- ${recipient}

na

#!/bin/bash

/usr/bin/spamc | /usr/sbin/sendmail -i "$@"
echo Program $0 byl spusten s Parametry $@ >> /home/spamfilter/spamfilter.log
echo `date` byl poslan mail od $2 k $4 >> /home/spamfilter/mail.log
exit $?

tim si pozbiram data kdy odkud kam, ale jen maily ktere konci na nasem serveru, navic mi k tomu chybi podstatny udaj velikost mailu. Snazil jsem se znasilnit postfix.org ale asi hledam pod spatnymi klicovimy slovy protoze vice o tech parametrech ${recipient} atd jsem se docetl s utle brozury v cestine co jsem koupil v tescu. Ma nekdo myslenku kde hledat, treba neco podobneho delal nebo ho napadne nejake klicove sloo ktere by me dovedlo bliz k cili?
Diky vsem za cas
PS: pokud se dilo podari konecny vysledek dam na konec diskuze

Odpovědi

[Petr Šobáň]

Nějak nechápu co řešíš ?

Postfix loguje maily a pokud ne stačí si to nastavit a potom jenom přečíst z logu.

/var/log/maillog

Případně si můžete spracovat statistiku viz: man pflogsumm

[root@soban /var/log]# pflogsumm /var/log/maillog

Grand Totals
------------
messages

      8   received
      8   delivered
      5   forwarded
      0   deferred
      0   bounced
      2   rejected (20%)
      0   reject warnings
      0   held
      0   discarded (0%)

  29120   bytes received
  29830   bytes delivered
      2   senders
      2   sending hosts/domains
      4   recipients
      4   recipient hosts/domains


Per-Day Traffic Summary
    date          received  delivered   deferred    bounced     rejected
    --------------------------------------------------------------------
    Dec  3 2006         1          1 
    Dec  4 2006         3          3          0          0          1 
    Dec  5 2006         0          0          0          0          1 
    Dec  6 2006         1          1 
    Dec  7 2006         3          3 

Per-Hour Traffic Daily Average
    time          received  delivered   deferred    bounced     rejected
    --------------------------------------------------------------------
    0000-0100           0          0          0          0          0 
    0100-0200           0          0          0          0          0 
    0200-0300           0          0          0          0          0 
    0300-0400           0          0          0          0          0 
    0400-0500           0          0          0          0          0 
    0500-0600           0          0          0          0          0 
    0600-0700           0          0          0          0          0 
    0700-0800           0          0          0          0          0 
    0800-0900           0          0          0          0          0 
    0900-1000           0          0          0          0          0 
    1000-1100           0          0          0          0          0 
    1100-1200           0          0          0          0          0 
    1200-1300           0          0          0          0          0 
    1300-1400           0          0          0          0          0 
    1400-1500           0          0          0          0          0 
    1500-1600           0          0          0          0          0 
    1600-1700           0          0          0          0          0 
    1700-1800           0          0          0          0          0 
    1800-1900           0          0          0          0          0 
    1900-2000           0          0          0          0          0 
    2000-2100           0          0          0          0          0 
    2100-2200           0          0          0          0          0 
    2200-2300           0          0          0          0          0 
    2300-2400           0          0          0          0          0 

Host/Domain Summary: Message Delivery 
 sent cnt  bytes   defers   avg dly max dly host/domain
 -------- -------  -------  ------- ------- -----------
      5    22573        0     0.1 s    0.1 s  .....net.cz
      1     4473        0     0.7 s    0.7 s  ......cz
      1     1595        0     0.8 s    0.8 s  li....cz
      1     1189        0     0.7 s    0.7 s  em.....cz

Host/Domain Summary: Messages Received 
 msg cnt   bytes   host/domain
 -------- -------  -----------
      5    21863   b8......cz
      3     7257   s.....cz

Senders by message count
------------------------
      5   root@.....fcanet.cz
      3   soban@......cz

Recipients by message count
---------------------------
      5   petr@....t.cz
      1   ....fiala@.......cz
      1   li...@......cz
      1   ju...@.......cz

Senders by message size
-----------------------
  21863   root@b......cz
   7257   soban@.....cz

Recipients by message size
--------------------------
  22573   petr@....net.cz
   4473   j...@......cz
   1595   linux@......cz
   1189   roman...@.....cz

message deferral detail: none

message bounce detail (by relay): none

message reject detail
---------------------
  RCPT
    Relay access denied (total: 2)
           1   hinet.net
           1   222.122.179.234

message reject warning detail: none

message hold detail: none

message discard detail: none

smtp delivery failures: none

Warnings: none

Fatal Errors
------------
  postlog (total: 1)
         1   usage: postfix/postlog [-c config_dir] [-i] [-p priority] [-t t...

Panics: none

Master daemon messages
----------------------
     13   daemon started -- version 2.3.3, configuration /etc/postfix
     13   terminating on signal 15
[root@soban /var/log]# 

Samozřejmě sem emaily trochu upravil.

[Ľubomír Host]

Ja som kedysi napisal parser tychto logov, ktory to tlaci do mysql. statistika sa da potom spravit cez zopar SQL prikazov. Skript je tuto: pf-savelog-mysql.pl