Migrating from courier-imap without passwords using Imapsync: Difference between revisions

(New page: == Migrate e-mail accounts from courier-imap, postfixadmin to zimbra without having user passwords == First, we needed to pull the account names and passwords from postfixadmin over to th...)
 
Line 1: Line 1:
== Migrate e-mail accounts from courier-imap, postfixadmin to zimbra without having user passwords ==
== Migrate e-mail accounts from courier-imap, postfixadmin to zimbra without having user passwords ==


First, we needed to pull the account names and passwords from postfixadmin over to the new Zimbra system. This article demonstrates a php script that did the job well, querying the encrypted passwords from the MySQL backup into a file:
First, we needed to pull the account names and passwords from postfixadmin over to the new Zimbra system. This article demonstrates a php script that did the job well, querying the encrypted passwords from the MySQL backup into a file. You can also modify it to retrieve aliases and subscribers from MySQL.


http://wiki.zimbra.com/index.php?title=Password_Migration[http://wiki.zimbra.com/index.php?title=Password_Migration]
http://wiki.zimbra.com/index.php?title=Password_Migration[http://wiki.zimbra.com/index.php?title=Password_Migration]


Using the exported.sh file, which runs zmprov, it created the users on Zimbra and was able to set their passwords. You may want to grep out all the 'zmprov ma username' lines into another file called reset_passwords.sh to run to reset passwords later, and add #!/bin/bash on the top line to make it a script, also do chmod +x reset_passwords.sh to make it executable. At this point, we want to change the passwords to something all the same for the imapsync migration - add it to the 'zimpassfile2' file specified in the imapsync command.
Using the exported.sh file, which runs zmprov, it created the users on Zimbra and was able to set their passwords. You may want to grep out all the lines with 'zmprov ma username' into another file, called reset_passwords.sh, to use for reseting account passwords later. (add #!/bin/bash on the top line to make it a script, 'chmod +x reset_passwords.sh' to make it executable.)
At this point, we want to change the account passwords to be all the same for the time it takes to do the imapsync migration - add the password to the 'zimpassfile2' file as specified in the imapsync command.


Migrating e-mail using imapsync was complicated when trying to use the --auth-user postfixadmin 'super-user' option, so we decided instead to create a new e-mail account via postfixadmin, called migration1, set a password, and then manually change the symlink for the mail folder in this way:
Migrating e-mail using imapsync was complicated when trying to use the --auth-user postfixadmin 'super-user' option, so we decided instead to create a new e-mail account via postfixadmin, called migration1, set a password, and then manually change the symlink for the mail folder in this way:
Line 22: Line 23:
<pre>rm /usr/local/virtual/migrate1@domain.com; ln -s /usr/local/virtual/drno@domain.com /usr/local/virtual/migration1@domain.com</pre>
<pre>rm /usr/local/virtual/migrate1@domain.com; ln -s /usr/local/virtual/drno@domain.com /usr/local/virtual/migration1@domain.com</pre>


After all the accounts have synced, use the reset passwords script (which you grepped out of exported.sh) that contains the 'zmprov ma' commands to reset all user passwords to the same as they had on the old mail server.
As recommended, we ran two imapsync processes on different servers concurrently to reduce the time for migration. We configured accounts migration1 and migration2 on the old mail server so we could point to two different mail folders at one time under /usr/local/virtual.
 
After all the accounts have synced, use the reset_passwords.sh script that contains the 'zmprov ma' commands to reset all user passwords to the same ones which they had on the old mail server.


MS
MS

Revision as of 19:56, 11 August 2009

Migrate e-mail accounts from courier-imap, postfixadmin to zimbra without having user passwords

First, we needed to pull the account names and passwords from postfixadmin over to the new Zimbra system. This article demonstrates a php script that did the job well, querying the encrypted passwords from the MySQL backup into a file. You can also modify it to retrieve aliases and subscribers from MySQL.

http://wiki.zimbra.com/index.php?title=Password_Migration[1]

Using the exported.sh file, which runs zmprov, it created the users on Zimbra and was able to set their passwords. You may want to grep out all the lines with 'zmprov ma username' into another file, called reset_passwords.sh, to use for reseting account passwords later. (add #!/bin/bash on the top line to make it a script, 'chmod +x reset_passwords.sh' to make it executable.) At this point, we want to change the account passwords to be all the same for the time it takes to do the imapsync migration - add the password to the 'zimpassfile2' file as specified in the imapsync command.

Migrating e-mail using imapsync was complicated when trying to use the --auth-user postfixadmin 'super-user' option, so we decided instead to create a new e-mail account via postfixadmin, called migration1, set a password, and then manually change the symlink for the mail folder in this way:

ln -s /usr/local/virtual/jbond@domain.com /usr/local/virtual/migration1@domain.com

Then running imapsync worked:

/usr/bin/imapsync --buffersize 8192000 --nosyncacls --subscribe --syncinternaldates --host1 postfixserver.domain.com --user1 migration1 \
--passfile1 zimpassfile1 --host2 zimbraserver.domain.com --user2 jbond@domain.com --passfile2 zimpassfile2 --noauthmd5

(I'm sure there are better ways to script all of this. Anyone who wants to add this, it will be welcomed.)

Then delete the symlink and relink it for the next user, so you can run imapsync again:

rm /usr/local/virtual/migrate1@domain.com; ln -s /usr/local/virtual/drno@domain.com /usr/local/virtual/migration1@domain.com

As recommended, we ran two imapsync processes on different servers concurrently to reduce the time for migration. We configured accounts migration1 and migration2 on the old mail server so we could point to two different mail folders at one time under /usr/local/virtual.

After all the accounts have synced, use the reset_passwords.sh script that contains the 'zmprov ma' commands to reset all user passwords to the same ones which they had on the old mail server.

MS

Jump to: navigation, search