I'm currently poking around the rep_total_mail_by_date.php and I've just noticed that my mtalog table is empty.
Does anyone know what part of mailscanner/mailwatch/<something else?> is responsible for populating this table?
MTA stats - who's responsible for the data collection?
Re: MTA stats - who's responsible for the data collection?
Ok, further poking around reveals the following directories contain the scripts for MTA log processing:
According to INSTALL, the mailwatch_relay.sh script needs to run hourly in cron (after updating), but my EFA installation doesn't have this.
This file references two scripts called
located in /home/www/sites/mailscanner/
The first file appears to be the log parser, but it doesn't appear to capture the information correctly from the log file. I'll look at it in a bit more detail shortly.
Code: Select all
/usr/local/bin/mailwatch/tools/Postfix_relay/
This file references two scripts called
Code: Select all
postfix_relay.php
mailscanner_relay.php
The first file appears to be the log parser, but it doesn't appear to capture the information correctly from the log file. I'll look at it in a bit more detail shortly.
- shawniverson
- Posts: 3783
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: MTA stats - who's responsible for the data collection?
weird.
it's not working for me.
it is logging some data (relay) but it is not logging unknown users, or rbl blocked mail or unknown domains.
were/are you getting those stats?
it's not working for me.
it is logging some data (relay) but it is not logging unknown users, or rbl blocked mail or unknown domains.
were/are you getting those stats?
- shawniverson
- Posts: 3783
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: MTA stats - who's responsible for the data collection?
not sure....I'll check...
Re: MTA stats - who's responsible for the data collection?
What were you able to discover?
On my system, only 'relay' events are logged. Nothing else is.
On my system, only 'relay' events are logged. Nothing else is.
- shawniverson
- Posts: 3783
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: MTA stats - who's responsible for the data collection?
So, that means the log processing script needs some additional work.
I'll have a look and see what needs to be done.
I'll have a look and see what needs to be done.
Re: MTA stats - who's responsible for the data collection?
Yeah, the script doesn't process those other events, and thus doesn't capture them. That's left as an "exercise for the reader".
I've made some initial changes to capture this information. I'll share the results once I'm happy with the results.
I've made some initial changes to capture this information. I'll share the results once I'm happy with the results.
Re: MTA stats - who's responsible for the data collection?
note to self:
you came across this before and found another script that could properly pull the information:
viewtopic.php?f=5&t=1015&p=3146&hilit=m ... tics#p3146
you came across this before and found another script that could properly pull the information:
viewtopic.php?f=5&t=1015&p=3146&hilit=m ... tics#p3146