Results 1 to 5 of 5

Thread: [SOLVED] open_conversation table info?

  1. #1
    raj's Avatar
    raj
    raj is offline Moderator
    Join Date
    Oct 2005
    Location
    USA, Canada and India
    Posts
    777
    Rep Power
    10

    Default [SOLVED] open_conversation table info?

    Hi..just working on integrating some stuff and trying to understand something in regard to one of the mysql table under each mailboxgroup

    Table Name: open_conversation
    Table Data:
    mailbox_id hash conv_id
    428 baEGgm5CGreA8occjEsVzi4MmHo= 260
    428 QijJkMW,yPWQ1AUoA+eHTNuD9Gk= 261
    428 5bIhzyS,AX7Z2CeqM+HRZYLxke0= 262
    428 dIlnflkUn0lAoPJHPpSnEPjcrVk= 264

    Mailbox_id = Same as ID field as in zimbra.mailbox table
    Hash = ?
    Conv_id = ?

    How does zimbra link/create these HASH and CONV_ID to messages?

    Thanks
    Raj

  2. #2
    JoshuaPrismon is offline Zimlet Guru & Moderator
    Join Date
    Nov 2005
    Posts
    477
    Rep Power
    9

    Default

    Quote Originally Posted by raj View Post
    Hi..just working on integrating some stuff and trying to understand something in regard to one of the mysql table under each mailboxgroup

    Table Name: open_conversation
    Table Data:
    mailbox_id hash conv_id
    428 baEGgm5CGreA8occjEsVzi4MmHo= 260
    428 QijJkMW,yPWQ1AUoA+eHTNuD9Gk= 261
    428 5bIhzyS,AX7Z2CeqM+HRZYLxke0= 262
    428 dIlnflkUn0lAoPJHPpSnEPjcrVk= 264

    Mailbox_id = Same as ID field as in zimbra.mailbox table
    Hash = ?
    Conv_id = ?

    How does zimbra link/create these HASH and CONV_ID to messages?

    Thanks
    Raj
    Directly linking into the MySQL database for this is probably a very bad idea. Might I suggest you use the Zimbra API's? The Table schema changes pretty frequently, which will break your code.

  3. #3
    raj's Avatar
    raj
    raj is offline Moderator
    Join Date
    Oct 2005
    Location
    USA, Canada and India
    Posts
    777
    Rep Power
    10

    Default

    Hi..I agree to that but this is something I really like to know. I am working on OSS backup solution so to do that if I have to COPY conversation data from this table then I was just curious HOW this table data was created at the fist place.
    I looked into the source and I can guess a little

    Conv_id = Parent ID in Mailbox table
    Hash = ? could be the FILE hash of the Parent message file in message store

    Follow up Q would be?
    if all of the DATA is deleted form this "open_conversation" table can we Re-Create this table data using some API or from command line..something like re-indexing

    Thanks
    Raj

  4. #4
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

    Default

    hash is the SHA-1 hash of the normalized subject of the open conversation. When a new message comes in with a "Re: " prefix and the same normalized subject, that's the row it matches. The FOREIGN KEY constraint should tell you that conv_id refers to the corresponding conversation (or message , if it's a 1-message conversation).

    But why are you worried about this? If you're trying to do backup, why not just dump the table contents for all the tables?
    Bugzilla - Wiki - Downloads - Before posting... Search!

  5. #5
    raj's Avatar
    raj
    raj is offline Moderator
    Join Date
    Oct 2005
    Location
    USA, Canada and India
    Posts
    777
    Rep Power
    10

    Default

    Thanks for the details
    I am trying to make a date based or criterion based backup..
    ie: backup emails for Sep 1 2007 to Oct 15 2007, so i just wanted the data rows i need. for this table i just wanted to know how its done in case I need to recreate it due to some SNAFU

    Just documenting what all this means..some day it will help.
    Thanks again..you can mark the thread [solved]

    Raj

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. postfix stopped
    By riegersteve in forum Administrators
    Replies: 1
    Last Post: 05-15-2007, 03:25 PM
  2. Can't start Zimbra!
    By zibra in forum Administrators
    Replies: 5
    Last Post: 03-22-2007, 11:34 AM
  3. Mails accumulating in deferred queue
    By NIRMESH KUMAR in forum Administrators
    Replies: 10
    Last Post: 03-19-2007, 12:17 AM
  4. Web client logon fails (INVALID_PDU)
    By jermxx in forum Installation
    Replies: 8
    Last Post: 02-20-2007, 02:20 PM
  5. The mailbox and mta dies in FC4 GA version
    By meikka in forum Installation
    Replies: 72
    Last Post: 03-16-2006, 05:30 PM

Posting Permissions

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