Results 1 to 8 of 8

Thread: Daily Maill Report Empty after upgrade to 7.1.4

  1. #1
    Kidoucorp is offline Active Member
    Join Date
    Aug 2010
    Posts
    40
    Rep Power
    4

    Default Daily Maill Report Empty after upgrade to 7.1.4

    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.

  2. #2
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,485
    Rep Power
    56

    Default

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


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    Kidoucorp is offline Active Member
    Join Date
    Aug 2010
    Posts
    40
    Rep Power
    4

    Default

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

  4. #4
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,485
    Rep Power
    56

    Default

    Quote Originally Posted by nameless' View Post
    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.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    Kidoucorp is offline Active Member
    Join Date
    Aug 2010
    Posts
    40
    Rep Power
    4

    Default

    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 ?

  6. #6
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,485
    Rep Power
    56

    Default

    Quote Originally Posted by nameless' View Post
    - /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?

    Quote Originally Posted by nameless' View Post
    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?

    Quote Originally Posted by nameless' View Post
    I ignore it.
    Not a good idea if the DB is corrupt.

    Quote Originally Posted by nameless' View Post
    - 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?

    Quote Originally Posted by nameless' View Post
    I don't know what could be more useful ?
    What has happened to this server recently (apart from the update to zimbra)?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  7. #7
    Kidoucorp is offline Active Member
    Join Date
    Aug 2010
    Posts
    40
    Rep Power
    4

    Default

    Quote Originally Posted by phoenix View Post
    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.
    Quote Originally Posted by phoenix View Post
    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

    Quote Originally Posted by phoenix View Post
    What has happened to this server recently (apart from the update to zimbra)?
    Well, nothing, expect security updates

  8. #8
    Kidoucorp is offline Active Member
    Join Date
    Aug 2010
    Posts
    40
    Rep Power
    4

    Default

    Quote Originally Posted by phoenix View Post
    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.
    Quote Originally Posted by phoenix View Post
    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

    Quote Originally Posted by phoenix View Post
    What has happened to this server recently (apart from the update to zimbra)?
    Well, nothing, expect security updates

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 05-11-2012, 02:16 PM
  2. Replies: 6
    Last Post: 03-14-2011, 04:21 AM
  3. [SOLVED] New zcs 7 install : database errors founds
    By dkbk in forum Administrators
    Replies: 4
    Last Post: 03-01-2011, 06:49 AM
  4. [SOLVED] Mailserver down when send file attach of 50Mb
    By ZMilton in forum Administrators
    Replies: 20
    Last Post: 04-10-2008, 11:44 AM
  5. Replies: 2
    Last Post: 02-12-2008, 11:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •