Zimbra Restore Mails From Store Folder - Revision history

Raunaq at 06:09, 26 July 2012

2012-07-26T06:09:49Z

← Older revision		Revision as of 06:09, 26 July 2012
Line 1:		Line 1:
			[[Category:Zimbra]]

	== Zimbra Mailbox Structure ==		== Zimbra Mailbox Structure ==
	In Zimbra, each user is assigned a unique 'mailbox ID', which links him/her to their folder in ''/opt/zimbra/store/0''.		In Zimbra, each user is assigned a unique 'mailbox ID', which links him/her to their folder in ''/opt/zimbra/store/0''.

Admin: /* The solution */

2012-07-25T13:05:19Z

The solution

← Older revision		Revision as of 13:05, 25 July 2012
Line 50:		Line 50:
	547		547
	23 "KolkataRO Witalsee" <rokolkata@witalsee.com>		23 "KolkataRO Witalsee" <rokolkata@witalsee.com>
	12 <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =		<nowiki>12 <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =</nowiki>
	11 "Pawan Kumar" <pawan.kumar@witalsee.com>		11 "Pawan Kumar" <pawan.kumar@witalsee.com>
	11 KolkataRO Witalsee=20		<nowiki>11 KolkataRO Witalsee=20</nowiki>
	11 <DIV><B>To:</B> <A title=3Drokolkata@witalsee.com=20		<nowiki>11 <DIV><B>To:</B> <A title=3Drokolkata@witalsee.com=20</nowiki>

	From this we can guess that the folder '547', ie ''/opt/zimbra/store.old/0/547'', belongs to 'rokolkata@witalsee.com'.		From this we can guess that the folder '547', ie ''/opt/zimbra/store.old/0/547'', belongs to 'rokolkata@witalsee.com'.

Admin: /* The solution */

2012-07-25T13:04:34Z

The solution

← Older revision		Revision as of 13:04, 25 July 2012
Line 47:		Line 47:
	<nowiki>12 <DIV><B>To:</B> <A title=3Dsecretary@witalsee.com=20</nowiki>		<nowiki>12 <DIV><B>To:</B> <A title=3Dsecretary@witalsee.com=20</nowiki>
	<nowiki>7 <DIV><B>To:</B> <A title=3Drolucknow@witalsee.com=20</nowiki>		<nowiki>7 <DIV><B>To:</B> <A title=3Drolucknow@witalsee.com=20</nowiki>

	547		547
	23 "KolkataRO Witalsee" <rokolkata@witalsee.com>		23 "KolkataRO Witalsee" <rokolkata@witalsee.com>

Admin: /* The solution */

2012-07-25T13:04:08Z

The solution

← Older revision		Revision as of 13:04, 25 July 2012
Line 35:		Line 35:

	# /opt/zimbra/store.old/0/findusers.sh		# /opt/zimbra/store.old/0/findusers.sh


	This will return a list of top ten users (in '''/tmp/messagelist''') whose name is present in the 'To:' field of the messages stored.		This will return a list of top ten users (in '''/tmp/messagelist''') whose name is present in the 'To:' field of the messages stored.

Admin: /* The solution */

2012-07-25T13:03:38Z

The solution

← Older revision		Revision as of 13:03, 25 July 2012
Line 46:		Line 46:
	13 "dr brijesh singh rajawat" <brijeshsinghrajawat@witalsee.com>,		13 "dr brijesh singh rajawat" <brijeshsinghrajawat@witalsee.com>,
	12 'Secretary'=20		12 'Secretary'=20
	12 <DIV><B>To:</B> <A title=3Dsecretary@witalsee.com=20		<nowiki>12 <DIV><B>To:</B> <A title=3Dsecretary@witalsee.com=20</nowiki>
	7 <DIV><B>To:</B> <A title=3Drolucknow@witalsee.com=20		<nowiki>7 <DIV><B>To:</B> <A title=3Drolucknow@witalsee.com=20</nowiki>

	547		547

Admin: /* The solution */

2012-07-25T13:01:53Z

The solution

@@ Line 37: / Line 37: @@
-This will return a list of top ten users (in ''/tmp/messagelist'') whose name is present in the 'To:' field of the messages stored.
+This will return a list of top ten users (in '''/tmp/messagelist''') whose name is present in the 'To:' field of the messages stored.
 Using the output of this, we can make a good estimate of the user's folder, but this needs to be confirmed manually as well, by reading the email.
 The mails can then be recovered by using zmmailbox as the Zimbra user.

Admin at 12:26, 25 July 2012

2012-07-25T12:26:01Z

← Older revision		Revision as of 12:26, 25 July 2012
Line 1:		Line 1:
	Zimbra Mailbox Structure		== Zimbra Mailbox Structure ==
			In Zimbra, each user is assigned a unique 'mailbox ID', which links him/her to their folder in ''/opt/zimbra/store/0''.

	~~Mails are stored in~~		Therefore a user with say mailbox ID '716', would have folder ''/opt/zimbra/store/0/716''. The emails are stored in '.msg' format.
	~~In Zimbra, each~~ user ~~is assigned a unique '~~mailbox ID', ~~which links him~~/~~her to~~

			For more information on the structure,
			[http://wiki.zimbra.com/wiki/Account_mailbox_database_structure go here]


			== The problem ==
			Now this information is stored in LDAP, so if LDAP is corrupted or unrecoverable, we cannot associate the mailbox ID with the user ID.

			But the store folder is intact.


			== The solution ==
			We will have to trace which folder belongs to which user. Since each folder belongs to a single user, it is sufficient to determine with a few emails who the inbox belongs to.

			So we follow these steps to recover it:
			In our case the backup store folder is ''/opt/zimbra/store.old/0''

	Go to the backup store folder:		Go to the backup store folder:

	cd /opt/zimbra/store.old/0		# cd /opt/zimbra/store.old/0

			Save the script as 'findusers.sh', and the run the script.

	~~Use the following script:~~
	#!/bin/bash		#!/bin/bash

Line 19:		Line 34:
	done		done

	This will return a list of top ten users (in '''/tmp/messagelist''') whose name is present in the 'To:' field of the messages stored.		# /opt/zimbra/store.old/0/findusers.sh


			This will return a list of top ten users (in ''/tmp/messagelist'') whose name is present in the 'To:' field of the messages stored.
	Using the output of this, we can make a good estimate of the user's folder, but this needs to be confirmed manually as well, by reading the email.		Using the output of this, we can make a good estimate of the user's folder, but this needs to be confirmed manually as well, by reading the email.

Line 35:		Line 53:
	mbox agmadmin@witalsee.com> addMessage /Recovery /opt/zimbra/store.old/0/809/msg/0		mbox agmadmin@witalsee.com> addMessage /Recovery /opt/zimbra/store.old/0/809/msg/0

	'''/opt/zimbra/store.old/0/809/msg/0''' is the path to the folder containing the mails. Some IDs may have a large amount of mails, resulting in '''msg/1''', '''msg/2''', etc. These will have to be run one-by-one.		''/opt/zimbra/store.old/0/809/msg/0'' is the path to the folder containing the mails. Some IDs may have a large amount of mails, resulting in ''msg/1'', ''msg/2'', etc. These will have to be run one-by-one.

Admin at 12:02, 25 July 2012

2012-07-25T12:02:10Z

← Older revision		Revision as of 12:02, 25 July 2012
Line 1:		Line 1:
			Zimbra Mailbox Structure

			Mails are stored in
			In Zimbra, each user is assigned a unique 'mailbox ID', which links him/her to



	Go to the backup store folder:		Go to the backup store folder:

Admin at 11:41, 25 July 2012

2012-07-25T11:41:48Z

← Older revision		Revision as of 11:41, 25 July 2012
Line 12:		Line 12:
	echo "" >> /tmp/messagelist		echo "" >> /tmp/messagelist
	done		done

	This will return a list of top ten users (in '''/tmp/messagelist''') whose name is present in the 'To:' field of the messages stored.		This will return a list of top ten users (in '''/tmp/messagelist''') whose name is present in the 'To:' field of the messages stored.
	Using the output of this, we can make a good estimate of the user's folder, but this needs to be confirmed manually as well, by reading the email.		Using the output of this, we can make a good estimate of the user's folder, but this needs to be confirmed manually as well, by reading the email.

Admin at 11:39, 25 July 2012

2012-07-25T11:39:54Z

@@ Line 1: / Line 1: @@
 The mails can then be recovered by using zmmailbox as the Zimbra user.
@@ Line 11: / Line 29: @@
   mbox agmadmin@witalsee.com> addMessage /Recovery /opt/zimbra/store.old/0/809/msg/0
-'/opt/zimbra/store.old/0/809/msg/0' is the path to the folder containing the mails. Some IDs may have a large amount of mails, resulting in 'msg/1', 'msg/2', etc. These will have to be run one-by-one.
+'''/opt/zimbra/store.old/0/809/msg/0''' is the path to the folder containing the mails. Some IDs may have a large amount of mails, resulting in '''msg/1''', '''msg/2''', etc. These will have to be run one-by-one.