Good morning, I'm having a heck of a time getting everything up and running correctly. Email sending and receiving work wonderful, no problems there. The problems are that there are no mail statistics and all email accounts quota shows 0kb as well as the Mailbox traffic is all 0. Additionally almost all of the system statistics like "Show server load" all say "No data about the server load available at the moment. Please check again later.", not sure if its related. I really like ISPConfig and I'm really grateful for it, just a few little kinks here. This is a fresh server (running since yesterday morning) that was created using the perfect guide for Ubuntu 18.04 (Thanks!) ISPConfig: 3.1dev Linux: Ubuntu 18.04 (Digital Ocean Image) Services: Apache2, Postfix, Dovecot htf-report.txt: Text was too long for forum post, please see pastebin.com/2pu1tYa5 The Mail.log file is full and to my knowledge everything appears great, here is an exert: Code: Jan 28 14:21:35 mail postfix/qmgr[1420]: 89916428C6: removed Jan 28 14:21:35 mail postfix/qmgr[1420]: B5B27428C7: removed Jan 28 14:21:35 mail postfix/smtp[29748]: 0A6F0428CA: to=<[email protected]>, relay=mail.emailsecuritycheck.net[149.202.232.193]:25, delay=0.2, delays=0.01/0.02/0.17/0, dsn=4.0.0, status=deferred (host mail.emailsecur$ Jan 28 14:21:35 mail postfix/smtpd[29709]: 475FA428AD: client=localhost[127.0.0.1] Jan 28 14:21:35 mail postfix/cleanup[29723]: 475FA428AD: message-id=<[email protected]> Jan 28 14:21:35 mail postfix/qmgr[1420]: 475FA428AD: from=<>, size=4956, nrcpt=1 (queue active) Jan 28 14:21:35 mail amavis[1602]: (01602-13-3) Blocked BANNED (application/x-msdownload,.asc,attached.) {BouncedInbound,Quarantined}, [149.202.232.193]:32813 [149.202.232.193] <[email protected]> -> <adm@iremovedthis>,$ Jan 28 14:21:35 mail postfix/smtp[29706]: 0084F428C9: to=<adm@iremovedthis>, relay=127.0.0.1[127.0.0.1]:10024, conn_use=3, delay=0.32, delays=0.1/0.11/0/0.11, dsn=2.5.0, status=sent (250 2.5.0 Ok, id=01602-13-3, BOUNCE) Jan 28 14:21:35 mail postfix/qmgr[1420]: 0084F428C9: removed Jan 28 14:21:35 mail postfix/smtpd[29701]: disconnect from outbound.emailsecuritycheck.net[149.202.232.193] ehlo=2 starttls=1 mail=1 rcpt=1 data=1 quit=1 commands=7 Jan 28 14:21:35 mail postfix/smtp[29750]: 28B64428CC: to=<[email protected]>, relay=mail.emailsecuritycheck.net[149.202.232.193]:25, delay=0.21, delays=0.01/0.03/0.17/0, dsn=4.0.0, status=deferred (host mail.emailsecu$ Jan 28 14:21:35 mail postfix/smtpd[29709]: 62A44428C6: client=localhost[127.0.0.1] Jan 28 14:21:35 mail postfix/cleanup[29705]: 62A44428C6: message-id=<[email protected]> Jan 28 14:21:35 mail postfix/qmgr[1420]: 62A44428C6: from=<>, size=4953, nrcpt=1 (queue active) Jan 28 14:21:35 mail amavis[1602]: (01602-13-4) Blocked BANNED (application/x-msdownload,.asc,attached) {BouncedInbound,Quarantined}, [149.202.232.193]:37779 [149.202.232.193] <[email protected]> -> <adm@iremovedthis>, $ Jan 28 14:21:35 mail postfix/smtp[29706]: 1A0A2428C8: to=<adm@iremovedthis>, relay=127.0.0.1[127.0.0.1]:10024, conn_use=4, delay=0.32, delays=0.1/0.11/0/0.11, dsn=2.5.0, status=sent (250 2.5.0 Ok, id=01602-13-4, BOUNCE) Jan 28 14:21:35 mail postfix/qmgr[1420]: 1A0A2428C8: removed Jan 28 14:21:35 mail postfix/smtp[29724]: 475FA428AD: to=<[email protected]>, relay=mail.emailsecuritycheck.net[149.202.232.193]:25, delay=0.18, delays=0.01/0/0.17/0, dsn=4.0.0, status=deferred (host mail.emailsecurit$ Jan 28 14:21:35 mail postfix/smtp[29733]: 62A44428C6: to=<[email protected]>, relay=mail.emailsecuritycheck.net[149.202.232.193]:25, delay=0.18, delays=0.01/0/0.17/0, dsn=4.0.0, status=deferred (host mail.emailsecurit$ Jan 28 14:21:37 mail postfix/smtpd[29762]: connect from localhost[127.0.0.1] Jan 28 14:21:37 mail postfix/smtpd[29762]: 8994B428C7: client=localhost[127.0.0.1] Jan 28 14:21:37 mail postfix/cleanup[29723]: 8994B428C7: message-id=emailsecuritycheck.net.3.rqwJiBafudkoIg3O9pyKO38vN3L7WdFmgbuRvMzdXv8= Jan 28 14:21:37 mail postfix/qmgr[1420]: 8994B428C7: from=<[email protected]>, size=1949, nrcpt=1 (queue active) Jan 28 14:21:37 mail amavis[1603]: (01603-12) Passed SPAM {RelayedTaggedInbound,Quarantined}, [149.202.232.193]:42551 [149.202.232.193] <[email protected]> -> <adm@iremovedthis>, quarantine: T/spam-TD5qEtwIjgy8.gz, Queu$ Jan 28 14:21:37 mail postfix/smtp[29731]: 99C8140121: to=<adm@iremovedthis>, relay=127.0.0.1[127.0.0.1]:10024, delay=3, delays=0.11/0.07/0.01/2.8, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as$ Jan 28 14:21:37 mail postfix/qmgr[1420]: 99C8140121: removed Jan 28 14:21:37 mail dovecot: lda(adm@iremovedthis): sieve: msgid=emailsecuritycheck.net.3.rqwJiBafudkoIg3O9pyKO38vN3L7WdFmgbuRvMzdXv8=: stored mail into mailbox 'Junk' Jan 28 14:21:37 mail postfix/pipe[29711]: 8994B428C7: to=<adm@iremovedthis>, relay=dovecot, delay=0.04, delays=0.01/0/0/0.03, dsn=2.0.0, status=sent (delivered via dovecot service (doveconf: Warning: /etc/dovecot/dovecot.conf line 67: Glo$ Jan 28 14:21:37 mail postfix/qmgr[1420]: 8994B428C7: removed Please note in that bit of the log I was testing the spam/virus scanning, which works excellent. I removed the domains and replaced it with "iremovedthis" for this post. mail.err is blank
Thank you for your quick reply, the results of crontab -l are: Code: * * * * * /usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done * * * * * /usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done And the last few lines of /var/log/ispconfig/cron.log are as follows: Code: Mon Jan 28 14:45:01 UTC 2019 finished. Mon Jan 28 14:46:01 UTC 2019 Mon Jan 28 14:46:01 UTC 2019 Mon Jan 28 14:46:01 UTC 2019 finished. Mon Jan 28 14:47:01 UTC 2019 Mon Jan 28 14:47:01 UTC 2019 Mon Jan 28 14:47:01 UTC 2019 finished. Mon Jan 28 14:48:01 UTC 2019 Mon Jan 28 14:48:01 UTC 2019 Mon Jan 28 14:48:01 UTC 2019 finished. Mon Jan 28 14:49:02 UTC 2019 Mon Jan 28 14:49:02 UTC 2019 Mon Jan 28 14:49:02 UTC 2019 finished. Mon Jan 28 14:50:01 UTC 2019 Mon Jan 28 14:50:01 UTC 2019 Mon Jan 28 14:50:01 UTC 2019 finished. Mon Jan 28 14:51:01 UTC 2019 Mon Jan 28 14:51:01 UTC 2019 Mon Jan 28 14:51:01 UTC 2019 finished. Mon Jan 28 14:52:01 UTC 2019 Mon Jan 28 14:52:01 UTC 2019 Mon Jan 28 14:52:01 UTC 2019 finished. Mon Jan 28 14:53:01 UTC 2019 Mon Jan 28 14:53:01 UTC 2019 Mon Jan 28 14:53:01 UTC 2019 finished.
That's both ok so far. Login to phpmyadmin as root user or admin user with similar privileges, go to the ispconfig database, select all tables and choose to repair them. maybe one of the tables is broken.
Thank you for your reply, I did ispconfig_update.sh and when asked to reconfigure the database permissions I said yes (single server setup) and it appears to have fixed the problem! Mailbox sizes are now showing and some other stats are working. Mailbox traffic is still 0 but I believe that will show up later with more traffic. Thank you for your time!
