Mail contacts lost during migration from ispCP 1.0.7

**ivanxx** · Feb 28th 2014

Hi there!,

I've just made the migration from ispcp 1.0.7 and, after ironing out some problems with the status of some domains and some other minor fixes, I've found that the mail contacts sotred by the users are no longer present in the new roundcube webmail service.

Is there any way to get them back?

Thanks!

-Iván.

mafioso · Feb 28th 2014

Maybe you can migrate them from your existing? backup..

**flames** · Feb 28th 2014

i-MSCP used SquirrelMail, you probably need to import it from the old installation. if you used roundcube also before, then the database name was not the same, so just copy over the entries.

**ivanxx** · Feb 28th 2014

Well, I've found at: /var/cache/imscp/addons/vendor/imscp/roundcube/plugins/squirrelmail_usercopy/squirrelmail_usercopy.php a script that looks like a script to import user info from squirrelmail into roundcube.

This script was included in the i-MSCP installation, I'm looking into it right now to see if it does what it says it does (found a "// Copy addres book" comment inside the code so far, but I'm not sure if my SquirrelMail data is available after the upgrade. probably I'll have to restore a backup to try it...

-Iván.

**flames** · Feb 28th 2014

usualy it should be still available, if squirrelmail uses a mysql database to store contacts. if squirrelmail uses a file, so it is gone on migration.

edit: looks not good for you http://squirrelmail.org/docs/admin/admin-2.html (at the bottom)
you can surely restore squirrelmail files from a backup

**ivanxx** · Feb 28th 2014

not a biggie, also I've found here (see the comment at the end of the post) a very promising php script that reads squirrelmail's files and imports them directly into roundcube's mysql databse. Will posts my results, thanks!

**ivanxx** · Feb 28th 2014

Okay, success!

I recovered a backup (actually just reconnected a virtual drive containing my old ispcp before the migration) and found the .abook files (they were at /var/www/ispcp/gui/tools/webmail/data ).
Then, using the script mentioned in my previous post, got all the abooks inserted in the roundcube's database. Love this!

-Iván.

**Nuxwin** · Feb 28th 2014

Hello ;

Could you please create a mini howto with needed resource links? Then, we can add it in our wiki at migration section.

Thanks

**ivanxx** · Mar 7th 2014

Sure, here's the mini how-to:

Here's what you need:

.abook files from your users. They are located on /var/www/ispcp/gui/tools/webmail/data on ispcp omega, but they're lost after upgrading to i-mscp, so you'll want to have a backup for this .

This script: (modified from a comment by user k4b3za at http://blog.kxr.me/2010/04/mig…uirrel-mail-contacts.html)

PHP

#!/usr/bin/php -q
<?php
// squirrelmail data dir in ispcp omega
$DATA = "/var/www/ispcp/gui/tools/webmail/data/";
// i-mscp Roudncube DataBase
$mysql_link=mysql_pconnect("localhost","root","yourMySQLrootPassword");
mysql_select_db("ispcp_roundcube");
$sql = "select user_id,username from users order by user_id";
$Resp= mysql_query($sql);
while( $row = mysql_fetch_array($Resp) ){
$file = $DATA.$row["username"].".abook";
if(file_exists( $file )){
$handle = fopen( $file , 'r');
while (!feof($handle)) {
$buffer = fgets($handle, 4096);
if(trim($buffer)){
list($nick,$nombre,$apellido,$email,$empresa) = explode("|",$buffer);
if( trim($email) ){
$sql2 = "select email from contacts where user_id='".$row["user_id"]."' and email='$email' ";
$Resp2= mysql_query($sql2);
if(mysql_num_rows($Resp2)==0){
print "Adding $email to ".$row["username"]." ...";
$sql3 = "insert into contacts set name = '$nick', firstname = '$nombre',surname = '$apellido', email = '$email',user_id = '".$row["user_id"]."' ";
$Resp3 = mysql_query($sql3);
if($Resp3) print " Ok\n";
else print " Fail\n";
}
}
}
}
}
}

Display More

Basically, this script looks for "username.abook" files where "username(s)" are your imported roundcube database users. If it finds any match, it will then open the .abook and will insert nick,name,surname and email fields into roundcube's contact database for that username, unless the email adress for the contact is already there (maybe the user already started to type his/her contacts).

It doesn't handle contact groups or members of groups (don't know if they even existed in squirrelmail).

...so you just run the script and you should be all set. Backup your database first (just in case) and Enjoy!

-Ivan.

Mail contacts lost during migration from ispCP 1.0.7

Share

Daily visitors