Results 1 to 9 of 9

Thread: [SOLVED] Export from old "bad" server and import into new

Hybrid View

  1. #1
    Join Date
    Jul 2008
    Location
    Los Angeles, CA
    Posts
    51
    Rep Power
    7

    Default [SOLVED] Export from old "bad" server and import into new

    Hi all,

    This is a pseudo continuation of the following thread:

    http://www.zimbra.com/forums/adminis...2561-help.html

    I'm moving on from the "fix the server" to the "move data out of the old installation and into a new" stage.

    This is not an attempt at restoring from backup, since all attempts at restoration have failed and I've essentially given up on that as the problem seems to be some kind of permissions between LDAP and the MySQL instance or something. Basically, I can get the information store mounted, but can't send or receive e-mail, or search anything in Zimbra. I get a network service error.

    This thread is to collaborate information on how to:

    1) Export mail and mail settings from one Zimbra installation and
    2) Import that mail into another.

    I know that the e-mail itself is stored in .eml files that are in the /opt/zimbra/store folder. So, I suppose if I have to, I can create a shell Zimbra installation, create all of the same users, then somehow import those messages, possibly by going through this route:

    .eml files ---> Outlook Express ---> Import into Outlook 2003 ---> Export to PST ---> Import into user's mail

    Does anyone have any suggestions on this?

    Does anyone know where the user accounts and settings are located? My guess is that they're in the MySQL database...but where's that located?

    Thanks!
    - Jesse

  2. #2
    Join Date
    Feb 2007
    Location
    Portland, OR
    Posts
    1,147
    Rep Power
    10

    Default

    Are you able to access the old server via IMAP? if so probably the easiest solution for migrating over the email would be to use IMAPsync.

    I have used the second of the scripts listed here User Migration - Zimbra :: Wiki quite a few times without any issues (once I got it working).

    You will need to have IMAP clear text access enabled. In every instance that I have used this I had a small enough user base that I could manually set the passwords on both servers to something known. If you have a large userbase though you might want to modify the imapsync command to use the --authuser1 and --passfile1 options. I am pretty sure that Zimbra supports this. Basically you provide the admin user which then has auth permissions on all other accounts without needing passwords for them.

    Your imapsync command will probably look something like this:
    Code:
    imapsync --authuser1 admin@oldserver --passfile1 a file \
                    --authuser2 admin@newserver --passfile2 a file \
                    --noauthmd5 --exclude "Junk" --exclude "Contacts" \
                    --host1 $host1 --user1 $user \
                    --host2 $host2 --user2 $user2
    A couple of notes on this tool:
    If your distro has this tool available as a package USE IT. Installing this tool has been my biggest problem every time I have used it.
    I have never used the authuser mechanism before but have seen reports of it working ...so see if the command I posted works but it might need some fixing.

  3. #3
    Join Date
    Jul 2008
    Location
    Los Angeles, CA
    Posts
    51
    Rep Power
    7

    Default

    Thanks ArcaneMagus! You've been pretty insightful during this whole ordeal of mine.

    So IMAP sync from Zimbra to Zimbra server should work? Using the FOSS version?

    If so, that'd be great...if the IMAP sync works. I'll give that a shot tomorrow and see if I get good results.

    I'm assuming I'd have to have 2 boxes running concurrently...and therefore one would have to have a different hostname/IP. I know I can figure out how to change the hostname in Zimbra after the fact...I remember seeing that somewhere.

    - Jesse

  4. #4
    Join Date
    Aug 2008
    Location
    St Pete FL USA
    Posts
    392
    Rep Power
    7

    Default

    imapsync should work, in general, as long as you can get into both servers via imap.
    Jay R. Ashworth - ZCS 6.0.9CE/CentOS5 - St Pete FL US - Music - Blog - Photography - IANAL - IAAMA
    Try to Ask Questions The Smart Way -- you'll get better answers.

    Put your product and version in your profile/signature - All opinions strictly my own, even though I have an employer these days.
    If you [SOLVE] something, please tell everyone how for the archives
    And, please... read what people write, and answer the questions they asked, not the ones they didn't.

  5. #5
    Join Date
    Aug 2008
    Location
    St Pete FL USA
    Posts
    392
    Rep Power
    7

    Default

    You can in fact change the Zimbra hostname, though you will also have to regenerate the SSL cert, and I haven't figured out how to do that yet.
    Jay R. Ashworth - ZCS 6.0.9CE/CentOS5 - St Pete FL US - Music - Blog - Photography - IANAL - IAAMA
    Try to Ask Questions The Smart Way -- you'll get better answers.

    Put your product and version in your profile/signature - All opinions strictly my own, even though I have an employer these days.
    If you [SOLVE] something, please tell everyone how for the archives
    And, please... read what people write, and answer the questions they asked, not the ones they didn't.

  6. #6
    Join Date
    Feb 2007
    Location
    Portland, OR
    Posts
    1,147
    Rep Power
    10

    Default

    As Baylink said IMAPsync should work as long as each server supports IMAP. It reads the capabilities of each server and uses what it can of those supported abilities.

    I have successfully used it to transfer mail from a Groupwise 6.5 system to Zimbra, and then later from a Zimbra system to another Zimbra system.

  7. #7
    Join Date
    Feb 2007
    Location
    Portland, OR
    Posts
    1,147
    Rep Power
    10

    Default

    Have you tried going to Tools-> Certificates-> Install Certificate in the Admin UI? That is where I updated my certificate a while ago.

  8. #8
    Join Date
    Aug 2008
    Location
    St Pete FL USA
    Posts
    392
    Rep Power
    7

    Default

    Well, you see, Z and I don't see eye to eye on DNS issues...

    That facility appears only to permit you to build and install certificates locally for what the server believes it is called.

    Alas, what the server believes it is called (benjamin) is not what the users call it (zmail), and I have no clue how much stuff I'll break if I rename it temporarily to change the certs and then change it back.

    And I don't have an SSL CA infrastructure built in-house to let me build it myself.
    Jay R. Ashworth - ZCS 6.0.9CE/CentOS5 - St Pete FL US - Music - Blog - Photography - IANAL - IAAMA
    Try to Ask Questions The Smart Way -- you'll get better answers.

    Put your product and version in your profile/signature - All opinions strictly my own, even though I have an employer these days.
    If you [SOLVE] something, please tell everyone how for the archives
    And, please... read what people write, and answer the questions they asked, not the ones they didn't.

  9. #9
    Join Date
    Jul 2008
    Location
    Los Angeles, CA
    Posts
    51
    Rep Power
    7

    Default

    Did some major work on this whole snafu this weekend, and with a friend of mine we buckled down to figure it out. I worked in the direction of exporting and importing into a new Zimbra install and my friend tried to fix the current broken deployment.

    The best method I worked out for exporting and reimporting is the command to export and re-import a single mailbox, including calendar and stuff. The forum thread I found this is:

    http://www.zimbra.com/forums/migrati...imbra-pst.html

    And the commands are:

    You can export an entire mailbox from the NE box with:
    zmmailbox -z -m user@domain.com getRestURL "//?fmt=tgz" > /tmp/user.tgz

    And import on the FOSS box (or back on the NE when needed) with:
    zmmailbox -z -m user@domain.com postRestURL "//?fmt=tgz&resolve=reset" /tmp/user.tgz


    I think that the IMAPsync would work great but I never got the point of testing/playing with it, since my friend actually figured out how to fix the broken install! Here's the link to the original thread in case you're interested in how it was fixed:

    http://www.zimbra.com/forums/adminis...2561-help.html

    Thanks to you all for the help.

    - Jesse

Similar Threads

  1. [SOLVED] PST import tool, error limit reached
    By Mike Scholes in forum Administrators
    Replies: 6
    Last Post: 12-14-2007, 09:16 AM
  2. [SOLVED] Import imap folder - no CRAM-MD5 error
    By stevejacobs in forum Migration
    Replies: 5
    Last Post: 11-01-2007, 08:30 AM
  3. Server rename and multi-server upgrade.
    By Tim Mothery in forum Administrators
    Replies: 0
    Last Post: 07-21-2007, 06:20 AM
  4. need advice on configuring zimbra to work with fax server
    By pheonix1t in forum Administrators
    Replies: 0
    Last Post: 07-11-2007, 07:46 PM
  5. Replies: 1
    Last Post: 09-16-2006, 11:02 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
  •