MTA logging question

[jescombe]

I've noticed an issue while looking through the logging scripts (am another person that doesn't get all the graphs), zmlogprocess never parses any MTA entries out of my raw_logs table because all the postfix/* entries in there have a postfix_qid of null.

Does this sound right, what postfix entries should have a postfix_qid?

Thanks in advance,
Jon.

[jescombe]

FYI - Just noticed that disk_status isn't getting populated either. The info isn't getting parsed out of raw_logs correctly because zmdisklog isn't setting the hostname...

Regards,
Jon.

[marcmac]

Those don't sound right. I've made some changes to this stuff to fix the missing graph problem, but I've never seen the null qid. Is it possible that syslog is logging the IP, not the hostname, because it can't resolve the IP address?

[jescombe]

I don't believe so, here's an example line from /var/log/zimbra.log and the corresponding database entry -

Feb 16 08:44:13 epia postfix/cleanup[20593]: 6F9614528: message-id=<200602160844.k1G8i8xi008879@localhost.localdom ain>

| 3222 | 2006-02-16 08:44:13 | epia | postfix/cleanup | 20593 | 6F9614528: message-id=<200602160844.k1G8i8xi008879@localhost.localdom ain> | NULL |

I don't really know perl, but am I correct in thinking that zmlogger should be parsing the qid (6F9614528) out in the section below? If so, I'll take a closer look at the processing here..

if ($app =~ /^postfix/ && $msg =~ /^(\S{10,12}): /) {
$qid = $1;
}

Regards,
Jon.

[marcmac]

interesting - your QID is 9 digits, I've never seen that. Quick fix is to change the {10,12} to {9,12} in that script.

[jescombe]

Yep, that's done the trick... Thanks!