Hello All,

I had a user that wanted to migrate his own mail via drag and drop with Outlook 2007. After he copied over all his mail, a significant number of messages came up with bad date headers.

The solution I found was using fixdate.py from pyzimbra. I had to make a couple small changes to get it working with 5.0.2.

Code:
--- db.py	2006-03-03 11:03:52.000000000 +0400
+++ db.py.WILL	2008-02-21 11:14:59.000000000 +0400
@@ -60,7 +60,7 @@
 		"""Connects to the mailbox for the given mailbox_id, dbconf for other params"""
 		self.mailbox_id = mailbox_id
 		dbconf = dbconf.copy()
-		dbconf.DBNAME = "mailbox%d" % self.mailbox_id
+		dbconf.DBNAME = "mboxgroup%d" % self.mailbox_id
 		Facade.dbwrapper.__init__(self, dbconf)
 
 	def get_folders(self):

--- fixdate.py	2008-02-21 10:13:00.000000000 +0400
+++ fixdate.py.WILL	2008-02-21 11:16:14.000000000 +0400
@@ -30,8 +30,8 @@
 			mbdb.set_details(message_id, **updated_details)
 			progress.amount = n
 			progress.show(filename)
-		progress.amount = n
-		progress.show(filename)
+		#progress.amount = n
+		#progress.show(filename)
 		print
 	mbdb.dbclose()
 db.dbclose()
I also had to run zmmypasswd NEWPASSWORD to get the connection settings right.

mysql.config:
Code:
DBTYPE=mysql
DBHOST=localhost
DBUSER=zimbra
DBSOCKET=/opt/zimbra/db/mysql.sock
DBPASSWORD=NEWPASSWORD
As a headsup this is very CPU intensive, so do it after hours.