[GH-ISSUE #85] Monthy Messaging graphs showing zero for last day of month #67

New issue

Open

opened 2026-05-05 15:03:42 -06:00 by gitea-mirror · 0 comments

gitea-mirror commented

2026-05-05 15:03:42 -06:00

Owner

Originally created by @betsys on GitHub (Aug 31, 2024).
Original GitHub issue: https://github.com/darold/sendmailanalyzer/issues/85

Running SendmailAnalyzer 9.4 with (an older version of ) sendmail on Centos

In most ways it's running great, but the monthly graphs show zero for the last day of the month, every month
The data for the next-to-last day is correct, there's no off-by-one error there.
The daily graphs for those days look fine. It's been doing this consistently for the last few years.

Thanks for any suggestions.
Not critical, but I've been making some presentations about email and I'd like to fix it.

Attaching screenshots for July 30 and 31 and the entire month,.
The second screenshot shows that hovering over the monthly graph for the last day shows zero messages
Also attaching file listing.

Running as a daemon with the default script in /etc/init.d , no diffs from
https://github.com/darold/sendmailanalyzer/blob/master/start_scripts/sendmailanalyzer

Don't have a /etc/sendmailanalyzer.conf

conf file in /usr/local/sendmailanalizer , diffs from current distro:
(I'm not running postscreen, not sure why conf below includes it)

PRODHOST [root@xmx 2024]# diff /usr/local/sendmailanalyzer/sendmailanalyzer.conf /tmp/sendmailanalyzer.conf.dist
< LOG_FILE      /var/log/mail.log
> LOG_FILE      /var/log/maillog
< MTA_NAME      sm-mta|sendmail|postfix|spampd|postscreen
> MTA_NAME      sm-mta|sendmail|postfix|spampd
< #VIRTUAL_DOMAIN_DB_QUERY      SELECT name FROM virtual_domains

> #VIRTUAL_DOMAIN_DB_QUERY        SELECT name FROM virtual_domains
< # When possible sendmailanalyzer extract the fqdn part of the sender or
< # recipient relay. Enable this directive if you just want Ip addresses.
< RELAY_IP_ONLY 0
<
< # Threshold to detect case where postscreen reject an ip address. By
< # default  reject: RCPT from ... are not logged by postfix, we mark the
< # message as DNSBL rejected when DNSBL rank value is upper or equal.
< POSTSCREEN_DNSBL_THRESHOLD    3
> # Custom milter-reject regex detected as spam
> #MILTER_REJECT_REGEX Mailbox not found

Crontab:
0 1 * * * /usr/local/sendmailanalyzer/sa_cache > /dev/null 2>&1

(there's some homerolled gunk in logrotate but it all operates on the rotated/old files)
Logrotate:

var/log/mail.log {
    create 0640 root root
        prerotate
                service sendmail stop
                purgestat
        endscript
        postrotate
                service rsyslog restart
                service sendmail start
                /usr/local/etc/shared/rollover /var/log/mail.log.0 60 \
                        "/usr/local/etc/shared/maillog -z -o /var/log/last/mail.last"
                /usr/local/etc/rollover.mail.log.local
                service sendmailanalyzer restart
                service outbound restart
           echo ""
        endscript
}

Note: there is also a cron job which stops sendmail at 1:30 AM every night to take snapshots.
not sure how this would be relevant - if it were impacting things I'd expect to see 1:30 worth of data.

Originally created by @betsys on GitHub (Aug 31, 2024). Original GitHub issue: https://github.com/darold/sendmailanalyzer/issues/85 Running SendmailAnalyzer 9.4 with (an older version of ) sendmail on Centos In most ways it's running great, but the monthly graphs show zero for the last day of the month, every month The data for the next-to-last day is correct, there's no off-by-one error there. The daily graphs for those days look fine. It's been doing this consistently for the last few years. Thanks for any suggestions. Not critical, but I've been making some presentations about email and I'd like to fix it. Attaching screenshots for July 30 and 31 and the entire month,. The second screenshot shows that hovering over the monthly graph for the last day shows zero messages Also attaching file listing. Running as a daemon with the default script in /etc/init.d , no diffs from https://github.com/darold/sendmailanalyzer/blob/master/start_scripts/sendmailanalyzer Don't have a /etc/sendmailanalyzer.conf conf file in /usr/local/sendmailanalizer , diffs from current distro: (I'm not running postscreen, not sure why conf below includes it) ``` PRODHOST [root@xmx 2024]# diff /usr/local/sendmailanalyzer/sendmailanalyzer.conf /tmp/sendmailanalyzer.conf.dist < LOG_FILE /var/log/mail.log > LOG_FILE /var/log/maillog < MTA_NAME sm-mta|sendmail|postfix|spampd|postscreen > MTA_NAME sm-mta|sendmail|postfix|spampd < #VIRTUAL_DOMAIN_DB_QUERY SELECT name FROM virtual_domains > #VIRTUAL_DOMAIN_DB_QUERY SELECT name FROM virtual_domains < # When possible sendmailanalyzer extract the fqdn part of the sender or < # recipient relay. Enable this directive if you just want Ip addresses. < RELAY_IP_ONLY 0 < < # Threshold to detect case where postscreen reject an ip address. By < # default reject: RCPT from ... are not logged by postfix, we mark the < # message as DNSBL rejected when DNSBL rank value is upper or equal. < POSTSCREEN_DNSBL_THRESHOLD 3 > # Custom milter-reject regex detected as spam > #MILTER_REJECT_REGEX Mailbox not found ``` Crontab: 0 1 * * * /usr/local/sendmailanalyzer/sa_cache > /dev/null 2>&1 (there's some homerolled gunk in logrotate but it all operates on the rotated/old files) Logrotate: ``` var/log/mail.log { create 0640 root root prerotate service sendmail stop purgestat endscript postrotate service rsyslog restart service sendmail start /usr/local/etc/shared/rollover /var/log/mail.log.0 60 \ "/usr/local/etc/shared/maillog -z -o /var/log/last/mail.last" /usr/local/etc/rollover.mail.log.local service sendmailanalyzer restart service outbound restart echo "" endscript } ``` Note: there is also a cron job which stops sendmail at 1:30 AM every night to take snapshots. not sure how this would be relevant - if it were impacting things I'd expect to see 1:30 worth of data. ![july files](https://github.com/user-attachments/assets/a68959c2-6f42-4d17-a031-125589af340f) ![july montly 1](https://github.com/user-attachments/assets/cf098aa1-a900-483d-8274-436d1341d358) ![july montly 2](https://github.com/user-attachments/assets/aeb2361e-9e65-4638-91de-1bee2f47095b) ![july 30 daily](https://github.com/user-attachments/assets/874343f8-66fe-4858-a56d-7c518a7fffd0) ![july 31 daily](https://github.com/user-attachments/assets/73c84098-1faf-4b76-a89a-593ebfdd57db)