Feature Reguest: Log Transaction Sequence Number

Use this forum if you want to suggest a new feature to hMailServer. Before posting, please search the forum to confirm that it has not already been suggested.
Post Reply

Do you need this feature?

Yes
7
70%
No
3
30%
 
Total votes: 10

tpainter
New user
New user
Posts: 13
Joined: 2006-11-14 21:26
Location: Harrisonburg, VA | U.S.A.

Feature Reguest: Log Transaction Sequence Number

Post by tpainter » 2007-12-21 06:36

This may already exist in a newer version, or have been discussed under a different term. If so, my apologies.

I find troubleshooting end user reports of messages sent but not received by the destination tedius given the time-centric instead of transaction-centric log format. I usually use Excel or a log viewer to filter log files. If each message had a unique sequence number assigned to it that was in each log entry associated with the message, I could filter on it and receive all the log entries associated with a message from when hMailserver received it until the destination server accepted it.

Schurki
Normal user
Normal user
Posts: 55
Joined: 2007-12-22 13:44

Post by Schurki » 2008-01-01 18:23

I second this one.

Log files are really hard to read, mainly for 2 reasons:

1.) They are time centric, not session number centric

2.) Application-Delivery messages cannot be easily associated with the previous SMTP Session number.

This is why I suggest the following:

Events to the log file should not be written immediately, but when the session and the Delivery Thread has been finished. Then the whole Session should be dumped to the logfile. Application Delivery messages should have the same session number as the previous SMTP thread.

Also inserting a blank line after each session would increase readability of the log.

So a log file like this:

Code: Select all

"SMTPD"	2588	71281	"2008-01-01 16:31:09.828"	"62.178.94.59"	"SENT: 220 mymailserver"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.859"	"62.178.94.59"	"RECEIVED: EHLO walter"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.859"	"62.178.94.59"	"SENT: 250-hmailserver[nl]250-SIZE[nl]250 AUTH LOGIN"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.890"	"62.178.94.59"	"RECEIVED: AUTH LOGIN"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.890"	"62.178.94.59"	"SENT: 334 VXNlcm5hbWU6"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.921"	"62.178.94.59"	"RECEIVED: d2FsdGVyLnJpbmdAY2lzdi5hdA=="
"SMTPD"	2588	71281	"2008-01-01 16:31:09.921"	"62.178.94.59"	"SENT: 334 UGFzc3dvcmQ6"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.984"	"62.178.94.59"	"RECEIVED: ***"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.031"	"62.178.94.59"	"SENT: 235 authenticated."
"SMTPD"	2588	71281	"2008-01-01 16:31:10.046"	"62.178.94.59"	"RECEIVED: MAIL FROM: <w@mydomain.com>"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.062"	"62.178.94.59"	"SENT: 250 OK"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.093"	"62.178.94.59"	"RECEIVED: RCPT TO: <f@reflex.at>"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.093"	"62.178.94.59"	"SENT: 250 OK"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.109"	"62.178.94.59"	"RECEIVED: RCPT TO: <i@mydomain.com>"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.109"	"62.178.94.59"	"SENT: 250 OK"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.125"	"62.178.94.59"	"RECEIVED: DATA"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.125"	"62.178.94.59"	"SENT: 354 OK, send."
"SMTPD"	2588	71281	"2008-01-01 16:31:10.484"	"62.178.94.59"	"SENT: 250 Queued (0.281 seconds)"
"APPLICATION"	3304	"2008-01-01 16:31:10.500"	"SMTPDeliverer - Message 9703: Delivering message from w@mydomain.com to f@reflex.at, i@mydomain.com. File: C:\Program Files\hMailServer\Data\{412F68A4-68F2-4EFB-B4BD-476C2F402B41}.eml"
"SMTPD"	2616	71281	"2008-01-01 16:31:13.015"	"62.178.94.59"	"RECEIVED: QUIT"
"SMTPD"	2616	71281	"2008-01-01 16:31:13.015"	"62.178.94.59"	"SENT: 221 goodbye"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"RECEIVED: 220-safemail-02.sil.at ESMTP MTA Tue, 01 Jan 2008 15:22:30 +0000"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"RECEIVED: 220-NO UCE / NO UBE, We trace and terminate spammers."
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"RECEIVED: 220-This server uses the following DNS-blacklists:"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"RECEIVED: 220 ** DSBL, NJABL, L1-SPEWS **"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"SENT: HELO mail.mydomain.com"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.734"	"62.116.68.200"	"RECEIVED: 250 safemail-02.sil.at Hello ns3.schurki.com [83.64.192.95]"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.734"	"62.116.68.200"	"SENT: MAIL FROM:<w@mydomain.com>"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.734"	"62.116.68.200"	"RECEIVED: 250 OK"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.734"	"62.116.68.200"	"SENT: RCPT TO:<f@reflex.at>"
"SMTPD"	2588	71284	"2008-01-01 16:31:26.875"	"62.116.68.195"	"SENT: 220 mymailserver"
"SMTPD"	2588	71284	"2008-01-01 16:31:26.875"	"62.116.68.195"	"RECEIVED: HELO safemail-02.sil.at"
"SMTPD"	2588	71284	"2008-01-01 16:31:26.875"	"62.116.68.195"	"SENT: 250 Hello."
"SMTPD"	2588	71284	"2008-01-01 16:31:26.875"	"62.116.68.195"	"RECEIVED: MAIL FROM:<>"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.484"	"62.116.68.195"	"SENT: 250 OK"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.484"	"62.116.68.195"	"RECEIVED: RCPT TO:<w@mydomain.com>"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.500"	"62.116.68.195"	"SENT: 250 OK"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.500"	"62.116.68.195"	"RECEIVED: QUIT"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.500"	"62.116.68.195"	"SENT: 221 goodbye"
"SMTPC"	2616	71283	"2008-01-01 16:31:27.609"	"62.116.68.200"	"RECEIVED: 250 Accepted"
"SMTPC"	2616	71283	"2008-01-01 16:31:27.609"	"62.116.68.200"	"SENT: DATA"
"SMTPC"	2616	71283	"2008-01-01 16:31:27.609"	"62.116.68.200"	"RECEIVED: 354 Enter message, ending with "." on a line by itself"
"SMTPC"	2616	71283	"2008-01-01 16:31:27.609"	"62.116.68.200"	"SENT: [nl]."
"SMTPC"	2616	71283	"2008-01-01 16:31:33.031"	"62.116.68.200"	"RECEIVED: 250 OK id=1J9iwp-0007R9-HD"
"SMTPC"	2616	71283	"2008-01-01 16:31:33.031"	"62.116.68.200"	"SENT: QUIT"
"SMTPC"	2616	71283	"2008-01-01 16:31:33.031"	"62.116.68.200"	"RECEIVED: 221 safemail-02.sil.at closing connection"
"APPLICATION"	3304	"2008-01-01 16:31:33.062"	"SMTPDeliverer - Message 9703: Message delivery thread completed."
"SMTPD"	2588	71289	"2008-01-01 16:31:47.859"	"80.253.80.49"	"SENT: 220 mymailserver"
"SMTPD"	2588	71289	"2008-01-01 16:31:47.890"	"80.253.80.49"	"RECEIVED: HELO web.de"
"SMTPD"	2588	71289	"2008-01-01 16:31:47.890"	"80.253.80.49"	"SENT: 250 Hello."
"SMTPD"	2588	71289	"2008-01-01 16:31:47.953"	"80.253.80.49"	"RECEIVED: MAIL FROM: <gewinnso@web.de>"
"SMTPD"	2616	71290	"2008-01-01 16:31:48.500"	"71.3.113.56"	"SENT: 220 mymailserver"
"SMTPD"	2616	71291	"2008-01-01 16:31:48.515"	"71.3.113.56"	"SENT: 220 mymailserver"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.765"	"80.253.80.49"	"SENT: 250 OK"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.828"	"80.253.80.49"	"RECEIVED: RCPT TO: <w@mydomain.com>"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.843"	"80.253.80.49"	"SENT: 250 OK"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.921"	"80.253.80.49"	"RECEIVED: DATA"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.921"	"80.253.80.49"	"SENT: 354 OK, send."
"SMTPD"	2588	71289	"2008-01-01 16:31:49.093"	"80.253.80.49"	"SENT: 250 Queued (0.094 seconds)"
"APPLICATION"	3304	"2008-01-01 16:31:49.109"	"SMTPDeliverer - Message 9705: Delivering message from gewinnso@web.de to w@mydomain.com. File: C:\Program Files\hMailServer\Data\{598E9302-39E9-49F1-AD4B-9BAB0EA6C70A}.eml"
"SMTPD"	2616	71292	"2008-01-01 16:31:56.859"	"77.99.1.141"	"SENT: 220 mymailserver"
"APPLICATION"	3304	"2008-01-01 16:31:57.531"	"SMTPDeliverer - Message 9705: Message deleted. Action was taken by script subscribing to OnDeliverMessage."
"SMTPD"	2616	71293	"2008-01-01 16:31:57.812"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71294	"2008-01-01 16:31:57.906"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71295	"2008-01-01 16:31:57.921"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71296	"2008-01-01 16:31:57.937"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71297	"2008-01-01 16:31:58.046"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71298	"2008-01-01 16:31:58.078"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71293	"2008-01-01 16:31:58.781"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71293	"2008-01-01 16:31:58.781"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2616	71294	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71294	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2616	71295	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71295	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2616	71296	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71296	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2616	71297	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71297	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2616	71298	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71298	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2616	71293	"2008-01-01 16:31:59.687"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2588	71294	"2008-01-01 16:31:59.796"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2624	71295	"2008-01-01 16:31:59.796"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2608	71296	"2008-01-01 16:31:59.812"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2596	71297	"2008-01-01 16:31:59.812"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2592	71298	"2008-01-01 16:31:59.812"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2588	71294	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"SMTPD"	2592	71298	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"SMTPD"	2596	71297	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"SMTPD"	2624	71295	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLICATION"	2588	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"
"APPLICATION"	2592	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"
"SMTPD"	2608	71296	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLICATION"	2596	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"
"APPLICATION"	2624	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"
"APPLICATION"	2608	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"
"SMTPD"	2608	71292	"2008-01-01 16:32:00.187"	"77.99.1.141"	"RECEIVED: HELO delphi.com"
"SMTPD"	2608	71292	"2008-01-01 16:32:00.187"	"77.99.1.141"	"SENT: 250 Hello."
"SMTPD"	2608	71299	"2008-01-01 16:32:00.640"	"83.21.209.22"	"SENT: 220 mymailserver"
"SMTPD"	2608	71299	"2008-01-01 16:32:00.859"	"83.21.209.22"	"RECEIVED: EHLO 83.21.209.22"
"SMTPD"	2608	71299	"2008-01-01 16:32:00.859"	"83.21.209.22"	"SENT: 250-hmailserver[nl]250-SIZE[nl]250 AUTH LOGIN"
"SMTPD"	2616	71293	"2008-01-01 16:32:01.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLICATION"	2616	"2008-01-01 16:32:01.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"
"SMTPD"	2608	71299	"2008-01-01 16:32:01.218"	"83.21.209.22"	"RECEIVED: MAIL From:<shashi14lennox@TALKAMERICA.NET>"
"SMTPD"	2608	71299	"2008-01-01 16:32:01.390"	"83.21.209.22"	"SENT: 550 Rejected by Spamhaus (83.21.209.22)"
"APPLICATION"	2608	"2008-01-01 16:32:01.390"	"hMailServer SpamProtection rejected RCPT (Sender: shashi14lennox@TALKAMERICA.NET, IP:83.21.209.22, Reason: Rejected by Spamhaus (83.21.209.22))"
"SMTPD"	2608	71292	"2008-01-01 16:32:02.046"	"77.99.1.141"	"RECEIVED: MAIL FROM: <Prunssnoy@delphi.com>"
"SMTPD"	2608	71292	"2008-01-01 16:32:02.437"	"77.99.1.141"	"SENT: 550 Rejected by Spamhaus (77.99.1.141)"
"APPLICATION"	2608	"2008-01-01 16:32:02.437"	"hMailServer SpamProtection rejected RCPT (Sender: Prunssnoy@delphi.com, IP:77.99.1.141, Reason: Rejected by Spamhaus (77.99.1.141))"
[/size]

rather would look like this:

Code: Select all

"SMTPD"	2588	71281	"2008-01-01 16:31:09.828"	"62.178.94.59"	"SENT: 220 mymailserver"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.859"	"62.178.94.59"	"RECEIVED: EHLO walter"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.859"	"62.178.94.59"	"SENT: 250-hmailserver[nl]250-SIZE[nl]250 AUTH LOGIN"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.890"	"62.178.94.59"	"RECEIVED: AUTH LOGIN"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.890"	"62.178.94.59"	"SENT: 334 VXNlcm5hbWU6"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.921"	"62.178.94.59"	"RECEIVED: d2FsdGVyLnJpbmdAY2lzdi5hdA=="
"SMTPD"	2588	71281	"2008-01-01 16:31:09.921"	"62.178.94.59"	"SENT: 334 UGFzc3dvcmQ6"
"SMTPD"	2588	71281	"2008-01-01 16:31:09.984"	"62.178.94.59"	"RECEIVED: ***"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.031"	"62.178.94.59"	"SENT: 235 authenticated."
"SMTPD"	2588	71281	"2008-01-01 16:31:10.046"	"62.178.94.59"	"RECEIVED: MAIL FROM: <w@mydomain.com>"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.062"	"62.178.94.59"	"SENT: 250 OK"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.093"	"62.178.94.59"	"RECEIVED: RCPT TO: <f@reflex.at>"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.093"	"62.178.94.59"	"SENT: 250 OK"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.109"	"62.178.94.59"	"RECEIVED: RCPT TO: <i@mydomain.com>"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.109"	"62.178.94.59"	"SENT: 250 OK"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.125"	"62.178.94.59"	"RECEIVED: DATA"
"SMTPD"	2588	71281	"2008-01-01 16:31:10.125"	"62.178.94.59"	"SENT: 354 OK, send."
"SMTPD"	2588	71281	"2008-01-01 16:31:10.484"	"62.178.94.59"	"SENT: 250 Queued (0.281 seconds)"
"SMTPD"	2616	71281	"2008-01-01 16:31:13.015"	"62.178.94.59"	"RECEIVED: QUIT"
"SMTPD"	2616	71281	"2008-01-01 16:31:13.015"	"62.178.94.59"	"SENT: 221 goodbye"
"APPLI"	3304	71281	"2008-01-01 16:31:10.500"	"SMTPDeliverer - Message 9703: Delivering message from w@mydomain.com to f@reflex.at, i@mydomain.com. File: C:\Program Files\hMailServer\Data\{412F68A4-68F2-4EFB-B4BD-476C2F402B41}.eml"

"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"RECEIVED: 220-safemail-02.sil.at ESMTP MTA Tue, 01 Jan 2008 15:22:30 +0000"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"RECEIVED: 220-NO UCE / NO UBE, We trace and terminate spammers."
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"RECEIVED: 220-This server uses the following DNS-blacklists:"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"RECEIVED: 220 ** DSBL, NJABL, L1-SPEWS **"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.718"	"62.116.68.200"	"SENT: HELO mail.mydomain.com"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.734"	"62.116.68.200"	"RECEIVED: 250 safemail-02.sil.at Hello ns3.schurki.com [83.64.192.95]"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.734"	"62.116.68.200"	"SENT: MAIL FROM:<w@mydomain.com>"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.734"	"62.116.68.200"	"RECEIVED: 250 OK"
"SMTPC"	2616	71283	"2008-01-01 16:31:26.734"	"62.116.68.200"	"SENT: RCPT TO:<f@reflex.at>"
"SMTPC"	2616	71283	"2008-01-01 16:31:27.609"	"62.116.68.200"	"RECEIVED: 250 Accepted"
"SMTPC"	2616	71283	"2008-01-01 16:31:27.609"	"62.116.68.200"	"SENT: DATA"
"SMTPC"	2616	71283	"2008-01-01 16:31:27.609"	"62.116.68.200"	"RECEIVED: 354 Enter message, ending with "." on a line by itself"
"SMTPC"	2616	71283	"2008-01-01 16:31:27.609"	"62.116.68.200"	"SENT: [nl]."
"SMTPC"	2616	71283	"2008-01-01 16:31:33.031"	"62.116.68.200"	"RECEIVED: 250 OK id=1J9iwp-0007R9-HD"
"SMTPC"	2616	71283	"2008-01-01 16:31:33.031"	"62.116.68.200"	"SENT: QUIT"
"SMTPC"	2616	71283	"2008-01-01 16:31:33.031"	"62.116.68.200"	"RECEIVED: 221 safemail-02.sil.at closing connection"
"APPLI"	3304	71283	"2008-01-01 16:31:33.062"	"SMTPDeliverer - Message 9703: Message delivery thread completed."

"SMTPD"	2588	71284	"2008-01-01 16:31:26.875"	"62.116.68.195"	"SENT: 220 mymailserver"
"SMTPD"	2588	71284	"2008-01-01 16:31:26.875"	"62.116.68.195"	"RECEIVED: HELO safemail-02.sil.at"
"SMTPD"	2588	71284	"2008-01-01 16:31:26.875"	"62.116.68.195"	"SENT: 250 Hello."
"SMTPD"	2588	71284	"2008-01-01 16:31:26.875"	"62.116.68.195"	"RECEIVED: MAIL FROM:<>"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.484"	"62.116.68.195"	"SENT: 250 OK"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.484"	"62.116.68.195"	"RECEIVED: RCPT TO:<w@mydomain.com>"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.500"	"62.116.68.195"	"SENT: 250 OK"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.500"	"62.116.68.195"	"RECEIVED: QUIT"
"SMTPD"	2588	71284	"2008-01-01 16:31:27.500"	"62.116.68.195"	"SENT: 221 goodbye"

"SMTPD"	2588	71289	"2008-01-01 16:31:47.859"	"80.253.80.49"	"SENT: 220 mymailserver"
"SMTPD"	2588	71289	"2008-01-01 16:31:47.890"	"80.253.80.49"	"RECEIVED: HELO web.de"
"SMTPD"	2588	71289	"2008-01-01 16:31:47.890"	"80.253.80.49"	"SENT: 250 Hello."
"SMTPD"	2588	71289	"2008-01-01 16:31:47.953"	"80.253.80.49"	"RECEIVED: MAIL FROM: <gewinnso@web.de>"
"SMTPD"	2616	71290	"2008-01-01 16:31:48.500"	"71.3.113.56"	"SENT: 220 mymailserver"
"SMTPD"	2616	71291	"2008-01-01 16:31:48.515"	"71.3.113.56"	"SENT: 220 mymailserver"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.765"	"80.253.80.49"	"SENT: 250 OK"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.828"	"80.253.80.49"	"RECEIVED: RCPT TO: <w@mydomain.com>"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.843"	"80.253.80.49"	"SENT: 250 OK"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.921"	"80.253.80.49"	"RECEIVED: DATA"
"SMTPD"	2588	71289	"2008-01-01 16:31:48.921"	"80.253.80.49"	"SENT: 354 OK, send."
"SMTPD"	2588	71283	"2008-01-01 16:31:49.093"	"80.253.80.49"	"SENT: 250 Queued (0.094 seconds)"
"APPLI"	3304	71283	"2008-01-01 16:31:49.109"	"SMTPDeliverer - Message 9705: Delivering message from gewinnso@web.de to w@mydomain.com. File: C:\Program Files\hMailServer\Data\{598E9302-39E9-49F1-AD4B-9BAB0EA6C70A}.eml"
"APPLI"	3304	71283	"2008-01-01 16:31:57.531"	"SMTPDeliverer - Message 9705: Message deleted. Action was taken by script subscribing to OnDeliverMessage."

"SMTPD"	2616	71292	"2008-01-01 16:31:56.859"	"77.99.1.141"	"SENT: 220 mymailserver"
"SMTPD"	2608	71292	"2008-01-01 16:32:00.187"	"77.99.1.141"	"RECEIVED: HELO delphi.com"
"SMTPD"	2608	71292	"2008-01-01 16:32:00.187"	"77.99.1.141"	"SENT: 250 Hello."
"SMTPD"	2608	71292	"2008-01-01 16:32:02.046"	"77.99.1.141"	"RECEIVED: MAIL FROM: <Prunssnoy@delphi.com>"
"SMTPD"	2608	71292	"2008-01-01 16:32:02.437"	"77.99.1.141"	"SENT: 550 Rejected by Spamhaus (77.99.1.141)"
"APPLI"	2608	71292	"2008-01-01 16:32:02.437"	"hMailServer SpamProtection rejected RCPT (Sender: Prunssnoy@delphi.com, IP:77.99.1.141, Reason: Rejected by Spamhaus (77.99.1.141))"

"SMTPD"	2616	71293	"2008-01-01 16:31:57.812"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71293	"2008-01-01 16:31:58.781"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71293	"2008-01-01 16:31:58.781"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2616	71293	"2008-01-01 16:31:59.687"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2616	71283	"2008-01-01 16:32:01.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLI"	2616	71283	"2008-01-01 16:32:01.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"

"SMTPD"	2616	71294	"2008-01-01 16:31:57.906"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71294	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71294	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2588	71294	"2008-01-01 16:31:59.796"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2588	71283	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLI"	2588	71283	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"

"SMTPD"	2616	71295	"2008-01-01 16:31:57.921"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71295	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71295	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2624	71295	"2008-01-01 16:31:59.796"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2624	71283	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLI"	2592	71283	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"

"SMTPD"	2616	71296	"2008-01-01 16:31:57.937"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71296	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71296	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2608	71296	"2008-01-01 16:31:59.812"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2608	71283	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLI"	2596	71283	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"

"SMTPD"	2616	71297	"2008-01-01 16:31:58.046"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71297	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71297	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2596	71297	"2008-01-01 16:31:59.812"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2596	71283	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLI"	2624	71283	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"

"SMTPD"	2616	71298	"2008-01-01 16:31:58.078"	"84.223.154.54"	"SENT: 220 mymailserver"
"SMTPD"	2616	71298	"2008-01-01 16:31:59.265"	"84.223.154.54"	"RECEIVED: HELO host-84-223-154-54.cust-adsl.tiscali.it"
"SMTPD"	2616	71283	"2008-01-01 16:31:59.265"	"84.223.154.54"	"SENT: 250 Hello."
"SMTPD"	2592	71298	"2008-01-01 16:31:59.812"	"84.223.154.54"	"RECEIVED: MAIL FROM:<jrader@faculty.ed.umuc.edu>"
"SMTPD"	2592	71298	"2008-01-01 16:32:00.062"	"84.223.154.54"	"SENT: 550 Rejected by Spamhaus (84.223.154.54)"
"APPLI"	2608	71283	"2008-01-01 16:32:00.062"	"hMailServer SpamProtection rejected RCPT (Sender: jrader@faculty.ed.umuc.edu, IP:84.223.154.54, Reason: Rejected by Spamhaus (84.223.154.54))"

"SMTPD"	2608	71299	"2008-01-01 16:32:00.640"	"83.21.209.22"	"SENT: 220 mymailserver"
"SMTPD"	2608	71299	"2008-01-01 16:32:00.859"	"83.21.209.22"	"RECEIVED: EHLO 83.21.209.22"
"SMTPD"	2608	71299	"2008-01-01 16:32:00.859"	"83.21.209.22"	"SENT: 250-hmailserver[nl]250-SIZE[nl]250 AUTH LOGIN"
"SMTPD"	2608	71299	"2008-01-01 16:32:01.218"	"83.21.209.22"	"RECEIVED: MAIL From:<shashi14lennox@TALKAMERICA.NET>"
"SMTPD"	2608	71283	"2008-01-01 16:32:01.390"	"83.21.209.22"	"SENT: 550 Rejected by Spamhaus (83.21.209.22)"
"APPLI"	2608	71283	"2008-01-01 16:32:01.390"	"hMailServer SpamProtection rejected RCPT (Sender: shashi14lennox@TALKAMERICA.NET, IP:83.21.209.22, Reason: Rejected by Spamhaus (83.21.209.22))"
See the difference in readability?

If Item 1 is too difficult to implement, then it would already help just to implement Item 2 (Linking Application session to smtp session), and I could easily sort the log on the session number and get a nice output.

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: Feature Reguest: Log Transaction Sequence Number

Post by ^DooM^ » 2009-01-17 13:15

How expensive would logging to an excel file format be Martin? Searching through logs would be seriously easy if they were .xls files?
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

User avatar
mattg
Moderator
Moderator
Posts: 22435
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Feature Reguest: Log Transaction Sequence Number

Post by mattg » 2009-01-17 16:02

Yeah, or even just comma separated values, csv, rather than tab separated values would be nice.

Perhaps am option to selet the log file delimiter?

btw - You can import tab separated values into Excel. Open excel first then 'open' and point to the log file, select 'tab' delimited...
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
martin
Developer
Developer
Posts: 6846
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

Re: Feature Reguest: Log Transaction Sequence Number

Post by martin » 2009-01-17 16:09

How expensive would logging to an excel file format be Martin?
Depends on what you would actually like to log to Excel and how you would like to do it. Excel sheets are limited to 65000 rows so having it as a generic logging format may not be a perfect solution. I'm not sure if there's some good "Excel-creating" component out there. The times I have created Excel sheets I've used the Excel API to create the .xls file, but that causes Excel.exe to be running and is very slow.
Yeah, or even just comma separated values, csv, rather than tab separated values would be nice.
Hmm, why? As you say, you can open current log files in Excel today as long as you select tab delimited. Feels like comma would cause more problems since commas are likely to be included in error messages given by other servers for example?

User avatar
mattg
Moderator
Moderator
Posts: 22435
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Feature Reguest: Log Transaction Sequence Number

Post by mattg » 2009-01-18 15:12

martin wrote:Hmm, why? As you say, you can open current log files in Excel today as long as you select tab delimited. Feels like comma would cause more problems since commas are likely to be included in error messages given by other servers for example?
That would be a good reason why not to do it.

the only reason I suggested csv, rather than Tab Separated Values is that csv are likely to be automatically by Excel, where Tab Separated Values in .log file are unlikely to be (yes they can be set that way, but then all .log files will want to open in excel..)
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

Stas
New user
New user
Posts: 1
Joined: 2009-12-25 16:02

Re: Feature Reguest: Log Transaction Sequence Number

Post by Stas » 2009-12-25 16:57

Merry Christmas to you all!

Martin, first of all - Big thank for your work.

I want to UP this topic and support Schurki - it's wery hard to parse log files in server wich have load more than 1-2 msg/sec. This is one of two things which I personally really miss (the second - the filter on HELLO and PTR but it is not for this topic).

In my server i have peaks up to 8-10 connect/sec and looking for session in log is a big problem. Excel does not always solve the problem - the size of logs greatly exceeds its limit (130000+ lines w/o pop3,imap,debug) and totally unacceptable in view of what is happening at the moment.

Is it real to store session log in temp file and append it to main log at the end of session to have complete uninterruptable log of sessions (like it does MDaemon for example)?
And perhaps it would be nice to be able as option in addition to main log to split logs by protocol (pop3.log, imap.log, smtp-in.log smtp-out.log)? This things would greatly simplify the search in logs, especially in online mode.

Thanks again.
PS. Sorry for my english

palinka
Senior user
Senior user
Posts: 4455
Joined: 2017-09-12 17:57

Re: Feature Reguest: Log Transaction Sequence Number

Post by palinka » 2019-05-02 13:09

Session number for log entries would be extremely useful.

User avatar
SorenR
Senior user
Senior user
Posts: 6308
Joined: 2006-08-21 15:38
Location: Denmark

Re: Feature Reguest: Log Transaction Sequence Number

Post by SorenR » 2019-05-02 13:23

palinka wrote:
2019-05-02 13:09
Session number for log entries would be extremely useful.
Session numbers, that's what I thought too... at first... It's the thread ID you need - to crossreference multiple logfiles :wink:

https://www.hmailserver.com/forum/viewt ... lit=thread
SørenR.

Woke is Marxism advancing through Maoist cultural revolution.

palinka
Senior user
Senior user
Posts: 4455
Joined: 2017-09-12 17:57

Re: Feature Reguest: Log Transaction Sequence Number

Post by palinka » 2019-05-02 13:30

👍

User avatar
SorenR
Senior user
Senior user
Posts: 6308
Joined: 2006-08-21 15:38
Location: Denmark

Re: Feature Reguest: Log Transaction Sequence Number

Post by SorenR » 2019-05-02 13:56

palinka wrote:
2019-05-02 13:30
👍
Now you just need Ruud to implement it :mrgreen:
SørenR.

Woke is Marxism advancing through Maoist cultural revolution.

palinka
Senior user
Senior user
Posts: 4455
Joined: 2017-09-12 17:57

Re: Feature Reguest: Log Transaction Sequence Number

Post by palinka » 2019-05-02 15:56

Baby steps... :mrgreen:

Post Reply