Daily Maill Report Empty after upgrade to 7.1.4

[nameless']

Hello,

I went from ZCS 7.1.2 to 7.1.4, but after my upgrade, all my daily mail reports are empty

Checked the log, all seems to work well, logrotate do its job, so I don't know what could be the problem. Any idea ?

Running 7.1.4 on Ubuntu Server 10.04.3 64Bits.

[phoenix]

Did you search for some of the forum threads on this subject: site:zimbra.com +"daily mail report" +empty - Yahoo! Search Results

[nameless']

Yes, and I didn't found anything revealant / things that work

[phoenix]

Originally Posted by nameless'

Yes, and I didn't found anything revealant / things that work

DO tell us what you've tried otherwise we'll be going over the same ground that's already been covered in those threads.

[nameless']

Ok, sorry.

- /tmp/logprocess.out is empty. Nothing in it. So I don't know/think if my DB is corrupted. I only receiving message from mysql.slow, and as I read it's not important. I ignore it.

- /opt/zimbra/libexec/pflogsumm.pl -d yesterday /var/log/mail.log show me mail reports with some data. But I think some data are missing, as I have a low "per user send mails", while in global stats I have a lot more. (For example, it says my server sent 3400 mails yesterday, while my biggest send user has only send 6 mails (Impossible, I know there are a lot more).

Edit : It show me a lot of entries like this :

Messages with no size data
--------------------------
0028D5EED56 ml.dute@external.com
00437636ED3 asero@domain.com
0056B635131 cbuerel@domain.com
0087E5EFE59 dr@domain.com
00B515EAFE9 adue@domain.com
00D9A5EBFA1 biey@domain.com
00EBF5D8E07 aqer@domain.com
0102B5EDCCD cirana@domain.com
018565EE191 adrte@domain.com

- /opt/zimbra/libexec/zmdailyreport show me nothing (Only 0 everywhere).

- zmcontrol status and zmstatctl status show me everything is running fine.

Under the Admin interface, I have red crosses for all services

I don't know what could be more useful ?

[phoenix]

Originally Posted by nameless'

- /tmp/logprocess.out is empty. Nothing in it. So I don't know/think if my DB is corrupted.

Why do you think the DB might be corrupted? Have you read the wiki article (and forum threads) on how to check the DB?

Originally Posted by nameless'

I only receiving message from mysql.slow, and as I read it's not important.

Where did you read that and what is the message?

Originally Posted by nameless'

I ignore it.

Not a good idea if the DB is corrupt.

Originally Posted by nameless'

- zmcontrol status and zmstatctl status show me everything is running fine.

Under the Admin interface, I have red crosses for all services

Are all the services actually running? Check it with zmcontrol. Have you also checked some of the forum threads that cover this topic?

Originally Posted by nameless'

I don't know what could be more useful ?

What has happened to this server recently (apart from the update to zimbra)?

[nameless']

Originally Posted by phoenix

Why do you think the DB might be corrupted? Have you read the wiki article (and forum threads) on how to check the DB?

Because I receive this email every sundays :


Where did you read that and what is the message?

Not a good idea if the DB is corrupt.

Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=xxxxxx
mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.

Originally Posted by phoenix

Are all the services actually running? Check it with zmcontrol. Have you also checked some of the forum threads that cover this topic?

Yes, all services are running. I checked some threads (Can't remember which, sorry), and didn't found any solution to this

Originally Posted by phoenix

What has happened to this server recently (apart from the update to zimbra)?

Well, nothing, expect security updates

[nameless']

Originally Posted by phoenix

Why do you think the DB might be corrupted? Have you read the wiki article (and forum threads) on how to check the DB?

Where did you read that and what is the message?

Not a good idea if the DB is corrupt.

Because I receive this email every sundays :

Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=xxxxxx
mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.

Originally Posted by phoenix

Are all the services actually running? Check it with zmcontrol. Have you also checked some of the forum threads that cover this topic?

Yes, all services are running. I checked some threads (Can't remember which, sorry), and didn't found any solution to this

Originally Posted by phoenix

What has happened to this server recently (apart from the update to zimbra)?

Well, nothing, expect security updates