[SOLVED] open_conversation table info?

[raj]

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

[JoshuaPrismon]

Originally Posted by raj

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.

[raj]

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

[dkarp]

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?

[raj]

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