mail traffic stats not working since 3.1

Helo,
as i found now, mail traffic stats are not working this year. I think it stopped working since update to ISPConfig 3.1
https://www.dropbox.com/s/s5imdynekopzoyd/mail-traffic.jpg?dl=0
Do you have idea what to fix ?

Regards
RH

 

yes, all other stats are OK,
How is ISPC collecting data ? was there changes in database regarding stats? i had some problems with upgrade to 3.1 and there maybe some patch not aplied to DB..
mail.log is on separate mail server, working OK

mail_traffic table (on main server, there is no data on mailserver) ends with 2016-12
I updated in half of JAnuary, suppose there has to be at least some data for 2017-01 ? or table is populated at end of the month ?

EDIT: SQL table seems to be OK, i checked againt fresh isntall of ISPC

 

i have reinstalled yesterday from 3.1.2 to 3.1.3, reconfigured permissions on master a nothing happened, no mailbox traffic data
supopse rights of read users as defined in /usr/local/ispconfig/server/lib/config.inc.php

as

//** Database settings for the master DB. This setting is only used in multiserver setups
$conf['dbmaster_type'] = 'mysql';
$conf['dbmaster_host'] = 'host.domain.tld';
$conf['dbmaster_port'] = '3306';
$conf['dbmaster_database'] = 'dbispconfig';
$conf['dbmaster_user'] = 'ispcsrv2';
$conf['dbmaster_password'] = 'xxxxxxxxxxxxxxxxxxxx';
$conf['dbmaster_new_link'] = false;
$conf['dbmaster_client_flags'] = 0;

are configured autoamtically by update ? or do i have to replace those with root ?

 

Hello,
it is still not working in 3.1.5, even if i give slave server root permission to master db. All data in mail_traffic table on master server ends 2016-12. No data in mail_traffic table on mail server (suppose it is OK)
Is it possbile that i'm missing some packages in my Debian 8 or something else ?

 

* * * * * /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

 

yes, everything is in the place

 

Hello,
does it log somewhere ? There is no screen output for the script ..
I found just file /usr/local/ispconfig/server/temp/rescue_module_serverconfig.ser.txt
root@mail:/usr/local/ispconfig/server/temp# cat rescue_module_serverconfig.ser.txt
a:1:{s:12:"serverconfig";a:2:{s:6:"server";a:1:{s:8:"loglevel";i:1;}s:6:"rescue";a:5:{s:10:"try_rescue";s:0:"";s:23:"do_not_try_rescue_httpd";s:0:"";s:23:"do_not_try_rescue_mysql";s:0:"";s:22:"do_not_try_rescue_mail";s:0:"";s:25:"do_not_try_rescue_mongodb";s:1:"n";}}}

 

Did you see any files when you run
find /var/vmail -name ispconfig_mailsize
?

 

Helo,
no.

FYI: this server was updated since first stable release of ISPConfig 3, which is i think 7 years or so ??
maybe something from past ?

 

root of mailbox:

drwx------ 13 vmail vmail 4096 Jun 22 17:58 Maildir
-rw------- 1 vmail vmail 53 Jun 22 17:09 .quotausage
-rw-r--r-- 1 vmail vmail 222 Sep 16 2012 .sieve
-rw-r--r-- 1 vmail vmail 244 Oct 28 2015 .sieve.svbin

Maildir folder

drwx------ 2 vmail vmail 118784 Jul 9 22:42 cur
drwx------ 5 vmail vmail 4096 Jul 9 22:42 .Deleted Messages
-rw------- 1 vmail vmail 24304 Jul 4 00:44 dovecot.index
-rw------- 1 vmail vmail 1203592 Jul 10 15:52 dovecot.index.cache
-rw------- 1 vmail vmail 19332 Jul 10 15:52 dovecot.index.log
-rw------- 1 vmail vmail 21 Aug 4 2016 dovecot-keywords
-rw------- 1 vmail vmail 96 Aug 4 2016 dovecot.mailbox.log
-rw------- 1 vmail vmail 74908 Jul 10 15:52 dovecot-uidlist
-rw------- 1 vmail vmail 8 Aug 4 2016 dovecot-uidvalidity
-r--r--r-- 1 vmail vmail 0 Aug 4 2015 dovecot-uidvalidity.55c0af2b
drwx------ 5 vmail vmail 4096 Jun 29 17:32 .Drafts
drwx------ 5 vmail vmail 4096 Aug 4 2016 .Junk
drwx------ 2 vmail vmail 4096 Jul 10 15:52 new
drwx------ 5 vmail vmail 4096 Jun 29 17:32 .Notes
drwx------ 5 vmail vmail 4096 Jun 29 17:32 .Sent
drwx------ 5 vmail vmail 4096 Jul 7 11:29 .Sent Messages
drwx------ 5 vmail vmail 4096 Jul 9 13:22 .Spam
-rw------- 1 vmail vmail 65 Feb 21 11:08 subscriptions
drwx------ 2 vmail vmail 4096 Jul 10 15:52 tmp
drwx------ 5 vmail vmail 4096 Aug 4 2015 .Trash

 

in some of the older mailboxes, there is also file
courierimapsubscribed (with 2013 date)
?

i use dovecot

 

older mailbox

drwx------ 5 vmail vmail 4096 Oct 14 2013 .Archives
-rwxr--r-- 1 vmail vmail 48 Oct 13 2013 courierimapsubscribed
drwx------ 2 vmail vmail 335872 Jul 10 16:09 cur
-rw------- 1 vmail vmail 69128 Jul 5 08:15 dovecot.index
-rw------- 1 vmail vmail 2214300 Jul 10 18:18 dovecot.index.cache
-rw------- 1 vmail vmail 2868 Jul 10 18:18 dovecot.index.log
-rw------- 1 vmail vmail 194 Jul 30 2012 dovecot-keywords
-rw------- 1 vmail vmail 1152 Jan 24 2015 dovecot.mailbox.log
-rw------- 1 vmail vmail 132453 Jul 10 18:18 dovecot-uidlist
-rw------- 1 vmail vmail 8 Nov 9 2016 dovecot-uidvalidity
-rw------- 1 vmail vmail 0 Oct 31 2011 dovecot-uidvalidity.4eae9c87
drwx------ 5 vmail vmail 4096 May 23 09:27 .Drafts
drwx------ 5 vmail vmail 4096 Nov 9 2016 .Junk
-rw------- 1 vmail vmail 2051 Nov 28 2011 maildirsize
drwx------ 2 vmail vmail 4096 Jul 10 18:18 new
drwx------ 5 vmail vmail 4096 Jul 10 16:09 .Sent
drwx------ 5 vmail vmail 4096 Jul 13 2016 .Spam
-rw------- 1 vmail vmail 54 Feb 21 11:07 subscriptions
drwx------ 2 vmail vmail 4096 Jul 10 18:18 tmp
drwx------ 5 vmail vmail 4096 Jul 10 08:34 .Trash