Development

Wiki Start
Wishlist
Timeline
Roadmap
Browse Source
New Ticket
View Tickets

Ticket #1215 (closed defect: fixed)

Opened 4 months ago

Last modified 3 months ago

POP/IMAP traffic is not added in domain statistics with courier and fedora core 8

Reported by: silicio Assigned to:
Priority: major Milestone: ispCP ω 1.0.0 - RC5
Component: Backend (Engine) Version: ispCP ω 1.0.0 - RC4
Severity: Hard Keywords:
Cc:

Description

The traffic pop/imap in domain statistics is not added with courier 4.3.1-1 and fedora Core 8. I have modified the file ispcp-vrl-traff :

# POP3

$rs = sys_command("$cat $rlog|$grep 'pop3d'|$grep 'user='|$grep 'top='|$grep -v 'ip=\\[::ffff:127.0.0.1\\]'|$awk '{print \$7,\$10,substr(\$11,1,length(\$11)-1);}' 1>$pop3_log");

.... and now the traffic is added.

Attachments

ispcp-vrl-traff.patch2.txt (2.5 kB) - added by ispcomm on 06/13/08 21:05:45.
fixed patch for debian/fedora/freebsd.
ispcp-vrl-traff.patch2.2.txt (2.5 kB) - added by ispcomm on 06/13/08 21:07:29.
Sorry... this is the correct patch. Discard the previous one (I need dev access to do it).

Change History

04/27/08 11:02:34 changed by silicio

Fedora core 8 with courier 4.3.1-1 - pop3 maillog

Apr 27 10:27:01 systemtest pop3d: Connection, ip=[::ffff:10.0.0.50] Apr 27 10:27:01 systemtest pop3d: LOGIN, user=pippo@systemtest.net, ip=[::ffff:10.0.0.50], port=[2006] Apr 27 10:27:01 systemtest pop3d: LOGOUT, user=pippo@systemtest.net, ip=[::ffff:10.0.0.50], port=[2006], top=0, retr=5853, rcvd=66, sent=6262, time=0

Fedora core 8 with courier 4.3.1-1 - imap maillog

Apr 27 10:58:36 systemtest imapd: Connection, ip=[::ffff:127.0.0.1] Apr 27 10:58:36 systemtest imapd: LOGIN, user=pippo@systemtest.net, ip=[::ffff:127.0.0.1], port=[59271], protocol=IMAP Apr 27 10:58:37 systemtest imapd: LOGOUT, user=pippo@systemtest.net, ip=[::ffff:127.0.0.1], headers=0, body=1214, rcvd=145, sent=2080, time=1

Fedora core 8 with postfix 2.4.5 - smtp maillog

Apr 27 10:50:59 systemtest postfix/smtpd[2716]: connect from unknown[10.0.0.50] Apr 27 10:50:59 systemtest postfix/smtpd[2716]: 564FB78548: client=unknown[10.0.0.50] Apr 27 10:50:59 systemtest postfix/cleanup[2719]: 564FB78548: message-id=<000d01c8a843$d10a0870$3200000a@stargate> Apr 27 10:50:59 systemtest postfix/qmgr[13391]: 564FB78548: from=<pippo@systemtest.net>, size=1406, nrcpt=1 (queue active) Apr 27 10:50:59 systemtest postfix/smtpd[2716]: disconnect from unknown[10.0.0.50] Apr 27 10:51:00 systemtest postfix/smtpd[2727]: connect from systemtest.com.local[127.0.0.1] Apr 27 10:51:00 systemtest postfix/smtpd[2727]: D8C5178555: client=systemtest.com.local[127.0.0.1] Apr 27 08:51:00 systemtest postfix/cleanup[2719]: D8C5178555: message-id=<000d01c8a843$d10a0870$3200000a@stargate> Apr 27 10:51:00 systemtest postfix/qmgr[13391]: D8C5178555: from=<pippo@systemtest.net>, size=1873, nrcpt=1 (queue active) Apr 27 10:51:00 systemtest postfix/smtpd[2727]: disconnect from systemtest.com.local[127.0.0.1] Apr 27 10:51:00 systemtest amavis[1343]: (01343-03) Passed CLEAN, MYNETS LOCAL [10.0.0.50] [10.0.0.50] <pippo@systemtest.net> -> <admin@systemtest.com>, Message-ID: <000d01c8a843$d10a0870$3200000a@stargate>, mail_id: FodQtVCAXbg4, Hits: 3.036, size: 1406, queued_as: D8C5178555, 1465 ms Apr 27 10:51:00 systemtest postfix/smtp[2721]: 564FB78548: to=<admin@systemtest.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=1.6, delays=0.09/0.04/0.03/1.5, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as D8C5178555) Apr 27 10:51:00 systemtest postfix/qmgr[13391]: 564FB78548: removed Apr 27 10:51:00 systemtest spamd[2226]: spamd: connection from systemtest.com.local [127.0.0.1] at port 51564 Apr 27 10:51:00 systemtest spamd[2226]: spamd: setuid to admin succeeded Apr 27 10:51:01 systemtest spamd[2226]: spamd: processing message <000d01c8a843$d10a0870$3200000a@stargate> for admin:500 Apr 27 10:51:01 systemtest spamd[2226]: spamd: clean message (3.0/5.0) for admin:500 in 0.9 seconds, 2000 bytes. Apr 27 10:51:01 systemtest spamd[2226]: spamd: result: . 3 - ALL_TRUSTED,AWL,HTML_MESSAGE,TRACKER_ID,TVD_SPACE_RATIO scantime=0.9,size=2000,user=admin,uid=500,required_score=5.0,rhost=systemtest.com.local,raddr=127.0.0.1,rport=51564,mid=<000d01c8a843$d10a0870$3200000a@stargate>,autolearn=no Apr 27 10:51:01 systemtest spamd[2227]: spamd: connection from systemtest.com.local [127.0.0.1] at port 51566 Apr 27 10:51:01 systemtest spamd[2227]: spamd: setuid to admin succeeded Apr 27 10:51:01 systemtest spamd[2227]: spamd: processing message <000d01c8a843$d10a0870$3200000a@stargate> for admin:500 Apr 27 10:51:02 systemtest spamd[2144]: prefork: child states: IB Apr 27 10:51:03 systemtest spamd[2227]: spamd: clean message (3.1/5.0) for admin:500 in 1.2 seconds, 2229 bytes. Apr 27 10:51:03 systemtest spamd[2227]: spamd: result: . 3 - ALL_TRUSTED,AWL,HTML_MESSAGE,TRACKER_ID,TVD_SPACE_RATIO scantime=1.2,size=2229,user=admin,uid=500,required_score=5.0,rhost=systemtest.com.local,raddr=127.0.0.1,rport=51566,mid=<000d01c8a843$d10a0870$3200000a@stargate>,autolearn=no Apr 27 10:51:03 systemtest postfix/local[2728]: D8C5178555: to=<admin@systemtest.com>, relay=local, delay=2.2, delays=0.01/0.05/0/2.2, dsn=2.0.0, status=sent (delivered to command: /usr/bin/spamc | procmail -a "$EXTENSION" DEFAULT=$HOME/Maildir/ MAILDIR=$HOME/Maildir) Apr 27 10:51:03 systemtest postfix/qmgr[13391]: D8C5178555: removed Apr 27 10:51:03 systemtest spamd[2144]: prefork: child states: II

04/27/08 11:05:58 changed by silicio

Fedora core 8 with courier 4.3.1-1 - pop3 maillog

Apr 27 10:27:01 systemtest pop3d: Connection, ip=[::ffff:10.0.0.50]

Apr 27 10:27:01 systemtest pop3d: LOGIN, user=pippo@systemtest.net, ip=[::ffff:10.0.0.50], port=[2006]

Apr 27 10:27:01 systemtest pop3d: LOGOUT, user=pippo@systemtest.net, ip=[::ffff:10.0.0.50], port=[2006], top=0, retr=5853, rcvd=66, sent=6262, time=0

Fedora core 8 with courier 4.3.1-1 - imap maillog

Apr 27 10:58:36 systemtest imapd: Connection, ip=[::ffff:127.0.0.1]

Apr 27 10:58:36 systemtest imapd: LOGIN, user=pippo@systemtest.net, ip=[::ffff:127.0.0.1], port=[59271], protocol=IMAP

Apr 27 10:58:37 systemtest imapd: LOGOUT, user=pippo@systemtest.net, ip=[::ffff:127.0.0.1], headers=0, body=1214, rcvd=145, sent=2080, time=1

Fedora core 8 with postfix 2.4.5 - smtp maillog

Apr 27 10:50:59 systemtest postfix/smtpd[2716]: connect from unknown[10.0.0.50]

Apr 27 10:50:59 systemtest postfix/smtpd[2716]: 564FB78548: client=unknown[10.0.0.50]

Apr 27 10:50:59 systemtest postfix/cleanup[2719]: 564FB78548: message-id=<000d01c8a843$d10a0870$3200000a@stargate>

Apr 27 10:50:59 systemtest postfix/qmgr[13391]: 564FB78548: from=<pippo@systemtest.net>, size=1406, nrcpt=1 (queue active)

Apr 27 10:50:59 systemtest postfix/smtpd[2716]: disconnect from unknown[10.0.0.50]

Apr 27 10:51:00 systemtest postfix/smtpd[2727]: connect from systemtest.com.local[127.0.0.1]

Apr 27 10:51:00 systemtest postfix/smtpd[2727]: D8C5178555: client=systemtest.com.local[127.0.0.1]

Apr 27 08:51:00 systemtest postfix/cleanup[2719]: D8C5178555: message-id=<000d01c8a843$d10a0870$3200000a@stargate>

Apr 27 10:51:00 systemtest postfix/qmgr[13391]: D8C5178555: from=<pippo@systemtest.net>, size=1873, nrcpt=1 (queue active)

Apr 27 10:51:00 systemtest postfix/smtpd[2727]: disconnect from systemtest.com.local[127.0.0.1]

Apr 27 10:51:00 systemtest amavis[1343]: (01343-03) Passed CLEAN, MYNETS LOCAL [10.0.0.50] [10.0.0.50] <pippo@systemtest.net> -> <admin@systemtest.com>, Message-ID: <000d01c8a843$d10a0870$3200000a@stargate>, mail_id: FodQtVCAXbg4, Hits: 3.036, size: 1406, queued_as: D8C5178555, 1465 ms

Apr 27 10:51:00 systemtest postfix/smtp[2721]: 564FB78548: to=<admin@systemtest.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=1.6, delays=0.09/0.04/0.03/1.5, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as D8C5178555)

Apr 27 10:51:00 systemtest postfix/qmgr[13391]: 564FB78548: removed

Apr 27 10:51:00 systemtest spamd[2226]: spamd: connection from systemtest.com.local [127.0.0.1] at port 51564

Apr 27 10:51:00 systemtest spamd[2226]: spamd: setuid to admin succeeded

Apr 27 10:51:01 systemtest spamd[2226]: spamd: processing message <000d01c8a843$d10a0870$3200000a@stargate> for admin:500

Apr 27 10:51:01 systemtest spamd[2226]: spamd: clean message (3.0/5.0) for admin:500 in 0.9 seconds, 2000 bytes.

Apr 27 10:51:01 systemtest spamd[2226]: spamd: result: . 3 - ALL_TRUSTED,AWL,HTML_MESSAGE,TRACKER_ID,TVD_SPACE_RATIO scantime=0.9,size=2000,user=admin,uid=500,required_score=5.0,rhost=systemtest.com.local,raddr=127.0.0.1,rport=51564,mid=<000d01c8a843$d10a0870$3200000a@stargate>,autolearn=no

Apr 27 10:51:01 systemtest spamd[2227]: spamd: connection from systemtest.com.local [127.0.0.1] at port 51566

Apr 27 10:51:01 systemtest spamd[2227]: spamd: setuid to admin succeeded

Apr 27 10:51:01 systemtest spamd[2227]: spamd: processing message <000d01c8a843$d10a0870$3200000a@stargate> for admin:500

Apr 27 10:51:02 systemtest spamd[2144]: prefork: child states: IB

Apr 27 10:51:03 systemtest spamd[2227]: spamd: clean message (3.1/5.0) for admin:500 in 1.2 seconds, 2229 bytes.

Apr 27 10:51:03 systemtest spamd[2227]: spamd: result: . 3 - ALL_TRUSTED,AWL,HTML_MESSAGE,TRACKER_ID,TVD_SPACE_RATIO scantime=1.2,size=2229,user=admin,uid=500,required_score=5.0,rhost=systemtest.com.local,raddr=127.0.0.1,rport=51566,mid=<000d01c8a843$d10a0870$3200000a@stargate>,autolearn=no

Apr 27 10:51:03 systemtest postfix/local[2728]: D8C5178555: to=<admin@systemtest.com>, relay=local, delay=2.2, delays=0.01/0.05/0/2.2, dsn=2.0.0, status=sent (delivered to command: /usr/bin/spamc | procmail -a "$EXTENSION" DEFAULT=$HOME/Maildir/ MAILDIR=$HOME/Maildir)

Apr 27 10:51:03 systemtest postfix/qmgr[13391]: D8C5178555: removed

Apr 27 10:51:03 systemtest spamd[2144]: prefork: child states: II

05/10/08 18:17:44 changed by rats

  • status changed from new to closed.
  • resolution set to fixed.
  • milestone changed from Working to ispCP ω 1.0.0 - RC5.

changed in r1145 - I hope it will work as I changed it. But is should!

06/13/08 21:04:56 changed by ispcomm

  • status changed from closed to reopened.
  • resolution deleted.

This "fix" brakes traffic accounting on debian (and any other system not using pop3d). A proper patch is attached that will work for both debian and fedora. The patch is against r1205

The patch corrects also a potential bug related to /etc/hostname

PLEASE>>> Check patches before committing them to SVN.

ispcomm.

06/13/08 21:05:45 changed by ispcomm

  • attachment ispcp-vrl-traff.patch2.txt added.

fixed patch for debian/fedora/freebsd.

06/13/08 21:07:29 changed by ispcomm

  • attachment ispcp-vrl-traff.patch2.2.txt added.

Sorry... this is the correct patch. Discard the previous one (I need dev access to do it).

06/13/08 22:43:48 changed by rats

  • status changed from reopened to closed.
  • resolution set to fixed.

added in r1206

Add/Change #1215 (POP/IMAP traffic is not added in domain statistics with courier and fedora core 8)




Action