Plesk Migration Manager not migrating databases from cPanel

[MattBBP]

I'm trying to get a workflow going to migrate ~100 websites from cPanel.
Both servers are Linux. The migrations are moving all files and emails but I'm missing the databases.
The only errors/warnings I'm getting are:

Warning:
Couldn't get 'cgi_bin_mode' attribute for domain where cgi-bin dir is '' and docroot dir is '/home/bealetrust/public_html'. Domain will be migrated in that way as if its cgi-bin directory was located under docroot.

Warning: hosting "bealepark.co.uk"
The password was generated for system user 'bealetrust'. New password is 'xxxxxxxxxxx'

Any idea why it might not be copying the databases over? I have access to all the logs but I'm struggling to find where the problem is occurring.

 

[MattBBP]

This time I did get an error. It seems kind of random as to whether I get an error or not.

Error:
Failed to execute backup database

Error:
Failed to pack files sqldump_1304151331 in /var/cache/20130415132910657//domains/aardvarklive.co.uk/databases/aardlive_db [ 14834055168 bytes free of 52743254016 bytes total on mount point 0]

Warning:
Couldn't get 'cgi_bin_mode' attribute for domain where cgi-bin dir is '' and docroot dir is '/home/aardlive/public_html'. Domain will be migrated in that way as if its cgi-bin directory was located under docroot.

Warning: hosting "aardvarklive.co.uk"
The password was generated for system user 'aardlive'. New password is 'xxxxx'

 

[IgorG]

Failed to pack files sqldump_1304151331 in /var/cache/20130415132910657//domains/aardvarklive.co.uk/databases/aardlive_db [ 14834055168 bytes free of 52743254016 bytes total on mount point 0]

This issue occurred due to resource shortage on your server. Make sure that you have enough free diskspace and memory resources if it is Virtuozzo VPS.

Couldn't get 'cgi_bin_mode' attribute for domain

It says that the migration script 'cPanel.pl' has failed to retrieve information from cPanel's database. The error occurred is about cPanel's database inconsistency. I would kindly recommend to contact cPanel to clarify the problem.

 

[MattBBP]

This issue occurred due to resource shortage on your server. Make sure that you have enough free diskspace and memory resources if it is Virtuozzo VPS.

It's not Virtuozzo - it's also got plenty of discspace and it's already taken a bunch of plesk-plesk migrations far larger.

It says that the migration script 'cPanel.pl' has failed to retrieve information from cPanel's database. The error occurred is about cPanel's database inconsistency. I would kindly recommend to contact cPanel to clarify the problem.

This one is less of a concern as it doesn't seem to be stopping anything else from copying over just fine.

Any other ideas? Anywhere to look in the logs to help debug?

 

[MattBBP]

So no ideas where to look in the logs for debugging?
It's pretty frustrating when the source server guys blame the destination server guys and then they both blame Plesk and then Plesk blames cPanel...

I need to pin point the problem with more than hearsay or guesswork because if I set up an account with cPanel I'll bet that they say it's a problem with Plesk!

 

[IgorG]

Look at this article - http://kb.parallels.com/9679 and try to troubleshoot it.

 

[IgorG]

Also you can ask free migration assistance here - http://www.parallels.com/support/plesk/free11assistance_toc/

 

[tempspace]

I am having the same issue (Failed to pack files sqldump_xxxxx), both of my servers have plenty of resources.

 

[NickJ.]

I am having the same issue (Failed to pack files sqldump_xxxxx), both of my servers have plenty of resources.

I too had the same issue. I applied a little 'hack' to the agent files that was able to make it work. Essentially, I told the migration wizard to ignore the error and move on. To my suprise, this actually worked and sent the database over.

NOTE - this is a hack, so do this at your own risk

in the /usr/local/psa/PMM/agents/shared/Storage/FileStorage.pm file, at line 181 comment out everything in the if statement here:

if (!$h->run()) {
# my ($total, $avail, $mount) = HelpFuncs::getMountSpace($destDir);
# Logging::debug("Failed to pack files $destFile in $destDir [ $avail bytes free of $total bytes total on mount point $mount]");
# Logging::error("Failed to pack files $destFile in $destDir [ $avail bytes free of $total bytes total on mount point $mount]");
# POSIX::close($newhandle);
# POSIX::close($newhandle2);
# return;
}

This will cause the function to keep running, adding the files to an array.

I found that on my source server, the DB files were there but they were not gzip packed. By commenting out this block, I'm guessing we are forcing the migration wizard to send the files as is, and when the destination server tries to unpack, it just unpacks 'nothing' so it will move on.

So essentially, your DB files will not be packed, and this may cause very long sending times for your migrations. This was OK with me as I didn't want to do all the work manually.

My guess is that someone has to do some fixing to this file, because earlier in the source I found this:
if ($self->{gzip_bundle} and not $doNotGzip ) {
#FIXME check gzip
push @cmd, "|", ["gzip"];
}

Since I don't know much Perl, I did what I could and was just happy that it worked.

Hope this helps someone!

 

[MattBBP]

wow! that did the trick...
thanks so much - I knew there must have been something in all that code throwing it out.
finally I can move on with my life.