Zimbra

teamnet · #1 (**permalink**) 01-22-2010, 07:45 AM

Hello,

I just finished installing zimbra on Gentoo. It works great.
On one other server I have about 300 user accounts with user names and password stored in vpopmail database and table. How to import this user accounts into zimbra? I do not need user messages I just need there passwords and accounts. And one more thing passwords are encrypted.

I was looking all around wiki and forums and I found imapsync. It is working great for user messages from mailbox from one server to another. BUT THIS IS NOT WHAT I NEED.

This is what I need: Qmail (vpopmail) acounts --->> Zimbra accounts

Klug · #2 (**permalink**) 01-22-2010, 07:54 AM

Did you look at the "migrations" wiki pages ?

There are several migrations tools (none for vpopmail iirc) that can help you build you own tool...

phoenix · #3 (**permalink**) 01-22-2010, 07:58 AM

Quote:

Originally Posted by teamnet

Hello,

I just finished installing zimbra on Gentoo. It works great.
On one other server I have about 300 user accounts with user names and password stored in vpopmail database and table. How to import this user accounts into zimbra? I do not need user messages I just need there passwords and accounts. And one more thing passwords are encrypted.

I was looking all around wiki and forums and I found imapsync. It is working great for user messages from mailbox from one server to another. BUT THIS IS NOT WHAT I NEED.

This is what I need: Qmail (vpopmail) acounts --->> Zimbra accounts

By Zimbra, do you mean Zimbra Collaboration Suite or Zimbra Desktop?

teamnet · #4 (**permalink**) 01-22-2010, 07:59 AM

I was thing something like
Migrating from Postfix and MySQL with bash - Zimbra :: Wiki

I will try with that just to change that mysql tables etc ...

teamnet · #5 (**permalink**) 01-22-2010, 07:59 AM

Quote:

Originally Posted by phoenix

By Zimbra, do you mean Zimbra Collaboration Suite or Zimbra Desktop?

Zimbra Collaboration Suite

teamnet · #6 (**permalink**) 01-22-2010, 08:48 AM

I like zimbra .... Using this: Migrating from Postfix and MySQL with bash - Zimbra :: Wiki I was able to export vpopmail accounts (user names, password etc). I tested it only for one account and it worked .... Now I have to do that for all accounts.

Lunch break now ... I will come back soon with more results.

teamnet · #7 (**permalink**) 01-23-2010, 03:25 AM

Thanks everyone. I finished this account migration. This is the script:

PHP Code:

 
#!/usr/bin/php

// http://wiki.zimbra.com/index.php?title=Password_Migration
// Modified migration script for gentoo+qmail+vpopmail
//


<?php
/////////////////////////////////////////////////////////

$user="user";
$pass="password";
$db="vpopmail";
$table_mbox="vpopmail";
$file="exported.sh";

/////////////////////////////////////////////////////////
echo "This script generates a bash script called: $file
The script contains the commands to re-create the mail accounts on zimbra server.\n\n
";

$mydb = mysql_connect('localhost',$user, $pass) or die ('Error connecting to server');
mysql_select_db($db);
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");

$query = "SELECT pw_name,pw_domain,pw_passwd
                FROM $table_mbox";
$dane = mysql_query($query) or die ('Error during query for '.mysql_error());

echo "Writing to $file ...\n";
$fh = fopen($file, "w");
$sp = '@';
fwrite($fh, "#!/bin/sh -x\n\n");

while ($row = mysql_fetch_array($dane, MYSQL_NUM))
{
    $data_mbox = "zmprov ca ".$row[0]."".$sp."".$row[1]." dsfs123hsdyfgbsdgfbsd displayName '".$row[0]."'\n";
    $data_mbox .= "zmprov ma ".$row[0]."".$sp."".$row[1]." userPassword '{crypt}".$row[2]."'"."\n";
    fwrite($fh, $data_mbox);
}
echo "Done.";

Once again thanks evryone ....