Results 1 to 3 of 3

Thread: [OC Received Time bug]Incorrect timestamp stored in database

  1. #1
    Join Date
    Sep 2008
    Posts
    20
    Rep Power
    7

    Default [OC Received Time bug]Incorrect timestamp stored in database

    Problems:
    Upload Emails using Outlook connector will make some email shown incorrect timestamp, mis-use of upload time as received timestamp, especially in Index folder

    Reason:
    In Zimbra's MySql database, the `date` field in mboxgroup$USER_ID has incorrect timestamp, it presuming that the Email is received at the time of the upload

    Solution:
    To replace `date` field using the time listed in "Date: " header of the email; Attached a script to fix the issue

    Version happen:
    Outlook 2003 + ZCS Network 5.0.7 + Connector 2.07_GA_2450_5.0.2661.7.msi

    How to reproduce:
    1. upload your mails by moving mail from other pst file in Outlook (using connector! not pst import wizard!)
    2. wait until it has fully synchronized with the server
    3. delete the whole profile and data file of zimbra
    4. rebuild zimbra's profile
    5. redownload and see, mails should have incorrect timestamp


    Usage of the fix script:
    ./fixtimestamp.sh <your_user's_name>

    It will parse all email in your user's store and then get the date, build the timestamp and store in mysql
    Attached Files Attached Files
    I can provide custom solution for Zimbra to Zimbra migration.

    Move your mailboxes individually or just item inside each mailbox

  2. #2
    Join Date
    May 2008
    Location
    Houston, TX
    Posts
    5
    Rep Power
    7

    Default

    Line 20 uses -s in the date command which sets the time on the machine... changing this to -d puts the result of the date command in the var as neede without changing the system date.

  3. #3
    Join Date
    Sep 2008
    Posts
    20
    Rep Power
    7

    Default Confirmed mistake

    Confirmed that it is an issue, I have NTP running every 5 minutes in my machine, no wonder I found no problems (as it corrects the time itself!)

    Attached version 0.02
    Attached Files Attached Files
    Last edited by hinyinlam; 10-13-2008 at 07:35 PM. Reason: grammar
    I can provide custom solution for Zimbra to Zimbra migration.

    Move your mailboxes individually or just item inside each mailbox

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 02:44 PM
  2. Message received time
    By palmczak in forum Installation
    Replies: 2
    Last Post: 09-24-2007, 07:46 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
  •