[SOLVED] qmail (vpopmail) accounts to zimbra

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

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...

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?

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 ...

Quote:

---

Originally Posted by phoenix

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

---

Zimbra Collaboration Suite

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.

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 ....

Excellent, this is great!

Did you put it in the wiki too?

Yes I added this here:
Building Zimbra on Gentoo - Zimbra :: Wiki

Quote:

---

Originally Posted by teamnet

Yes I added this here:
Building Zimbra on Gentoo - Zimbra :: Wiki

---

Excellent script, thanks for putting it in the wiki. :)