Feature Reguest: Log Transaction Sequence Number
Feature Reguest: Log Transaction Sequence Number
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.
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.
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:[/size]
rather would look like this:
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.
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))"
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))"
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.
Re: Feature Reguest: Log Transaction Sequence Number
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! ヅ
Re: Feature Reguest: Log Transaction Sequence Number
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...
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
https://www.hmailserver.com/documentation
Re: Feature Reguest: Log Transaction Sequence Number
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.How expensive would logging to an excel file format be Martin?
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?Yeah, or even just comma separated values, csv, rather than tab separated values would be nice.
Re: Feature Reguest: Log Transaction Sequence Number
That would be a good reason why not to do it.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?
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
https://www.hmailserver.com/documentation
Re: Feature Reguest: Log Transaction Sequence Number
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
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
Re: Feature Reguest: Log Transaction Sequence Number
Session number for log entries would be extremely useful.
Re: Feature Reguest: Log Transaction Sequence Number
Session numbers, that's what I thought too... at first... It's the thread ID you need - to crossreference multiple logfiles
https://www.hmailserver.com/forum/viewt ... lit=thread
SørenR.
Woke is Marxism advancing through Maoist cultural revolution.
Woke is Marxism advancing through Maoist cultural revolution.
Re: Feature Reguest: Log Transaction Sequence Number
Baby steps...