Hi. Last email traffic is from sep 2019 on master in mail_traffic, when i upgraded from Debian 9 to 10. No data in slave in mail_traffic. Cron seems to run, i get other traffic (web) and email quota works. Database, both master and slave checked. php cron-debug shows only : finished. No errors in obvious logs. I always reconfigure all services when updating ispconfig. According to 100-mailbox.stats.inc.php there is some files ispconfig_mailsize that dont exist in maildir, should it ? Is it Dovecot that creates this file or ispconfig ? What to look for when stats is missing ? Does the traffic store in slave database and then transfered to master database or how is it collected? (i did delete the .state file, since that gave me problems 2 years ago, but did not help now) Debug log gives this: DEBUG - safe_exec cmd: which 'dovecot' 2> /dev/null - return code: 0, but nothing else that looks like errors.
So the update Debian 9 -> 10 was in September? Did you then after upgrading to Debian 10 follow ISPConfig Perfect Server Guide and check all packages are installed and configurations done according to that Guide? And after that force ISPConfig update to reconfigure services.
No, that's for old courier setups only. Traffic stats is gathered from mail.log file on dovecot systems. No, its send to master directly.
Is it this code that sends to master node : 100-mailbox.stats.inc.php via direct MySQL ? Its the same missing stats on all my cirka 15 nodes. Another system was updated on dec 19, and thats also the last date in mail_traffic, so its the Debian upgrade (or something missing). Could it be the masterserver database credentials ? I have to look again there. If you could just explain how it saves the traffic i might be able to find why its gone.
yes, lines like $app->dbmaster->query(....) mean that this query is sent to the master. Thats one option, yes. If it cant to the mail_traffic table anymore. Other options are that the log file format was changed so that the parser does not understand it anymore or that no log files get written anymore by the mail system.
mail.log works, i check these every day due to custumers spam: postfix/qmgr[19393]: CB99A9448BB: from=<user@domain>, size=310122, nrcpt=1 (queue active) I do have IPv6 since 2 years almost, could it be that MySQL connection fails from slave, i have mysql accounts from IPv4, but no IPv6 mysql accounts. I will try to make one and test. It dont explain the timing though. Does the cron-debug really try to call master ? So i can use that for testing ?
This might indeed be a reason, I just wonder why we did not had any complaints in that case. Will check that.
Well the function parse_mail_log_line only looks for Amavis in mail.log it seems. Welcome to my life, im usually first on finding not critical bugs ;-)
I'll add a bug report for it. Actually I never use the traffic stats plus my live mail server is still on amavis
