Email traffic gone since Debian 9 to 10

Discussion in 'ISPConfig 3 Priority Support' started by elmacus, Feb 28, 2020.

  1. elmacus

    elmacus Active Member HowtoForge Supporter

    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.
     
    Last edited: Feb 28, 2020
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    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.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  4. elmacus

    elmacus Active Member HowtoForge Supporter

    Yes i did.
     
  5. elmacus

    elmacus Active Member HowtoForge Supporter

    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.
     
    Last edited: Feb 28, 2020
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  7. elmacus

    elmacus Active Member HowtoForge Supporter

    mail.log works, i check these every day due to custumers spam:
    postfix/qmgr[19393]: CB99A9448BB: from=<[email protected]>, 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 ?
     
    Last edited: Feb 28, 2020
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    cron debug does the exact same thing that the regular cronjob does.
     
  9. elmacus

    elmacus Active Member HowtoForge Supporter

    Its not a Amavis versus Rspamd bug, right ?
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    This might indeed be a reason, I just wonder why we did not had any complaints in that case. Will check that.
     
  11. elmacus

    elmacus Active Member HowtoForge Supporter

    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 ;-)
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    I'll add a bug report for it. Actually I never use the traffic stats plus my live mail server is still on amavis :)
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

Share This Page