Migration issue

[Gabrielpasv]

Hi Guys,

I have plesk 11 on ubuntu server on amazon ec2 instance. Everything is working ok so far. But when I tried to migrate some sites using migration manager I got an error.

This is the error I can see from the website:

<?xml version="1.0"?>
<execution-result status="error"><message code="StdException" id="680e09ec-c988-4b3d-8247-e2d15cbce72a" severity="error"><description>Deployer has been terminated by exception: 
Line 2 error: Element 'shosting': This element is not expected.

Line 2 error: Element 'shosting': This element is not expected.

Line 2 error: Element 'shosting': This element is not expected.
</description></message></execution-result>

Investigating a little more I found one file named mixed-result.xml in /opt/psa/PMM/msessions/20130517183645648 with the following errors

<?xml version="1.0" encoding="UTF-8"?>
<execution-result-mixed status="error" log-location="">
    <backup status="error" log-location="/var/cache/20130517183645648/migration.result">
        <message code="msgtext" severity="error" id="5712b8f3-5396-4903-8ace-1eb3ce6c2d3e">
            <description>Failed to execute backup database</description>
        </message>
        <message code="msgtext" severity="error" id="5b324c81-85e9-4838-88f5-fef66cd1a84d">
            <description>Failed to pack files sqldump_1305171437 in /var/cache/20130517183645648//domains/sites.plantant.com/databases/sitespla_fngla_tls2012 [ 74475933696 bytes free of 120333875200 bytes total on mount point 0]</description>

I went online and I found one KB... saying about a problem with the symbols # or = on the plesk admin password. However the solution they provided does not seems to be valid

The KB tell me to edit file MysqlShellBackend.pm and change on line. However the line is different

Here is the line they want me to change:
print OPTSFILE "[mysqldump]\npassword=" . $self->{password};

and need to change to print OPTSFILE "[mysqldump]\npassword=\"" . $self->{password} . "\"";


But on my file there's no such thing. The closest one is
print OPTSFILE "[mysqldump]\npassword=";



Can anyone please help me on this? Thank YOu

 

[IgorG]

Element 'shosting': This element is not expected.

Is it migration from cPanel? As far as I know this bug (#105910 for your reference) has been fixed in upcoming Plesk 11.5 version. As possible workaround you can try apply following patch:

# diff -u /usr/local/psa/PMM/agents/cPanel9/Transformer.pm{,.orig}
--- /usr/local/psa/PMM/agents/cPanel9/Transformer.pm 2012-04-20 13:52:01.724238347 +0400
+++ /usr/local/psa/PMM/agents/cPanel9/Transformer.pm.orig 2012-04-20 13:57:39.315300125 +0400
@@ -1446,7 +1446,7 @@
$shostingNode->addChild( $urlNode );
$domainFromSubdomainNode->addChild( $shostingNode );

-# $domainFromSubdomainNode->addChild( $shostingNode );
+ $domainFromSubdomainNode->addChild( $shostingNode );
return $shostingNode;
}

 

[Gabrielpasv]

Yes, I am using plesk...

Do you know how do I apply this patch ?

Is it a linux command line ?

Thanks for the help

 

[IgorG]

First of all create backup of original file:

# cp /usr/local/psa/PMM/agents/cPanel9/Transformer.pm /usr/local/psa/PMM/agents/cPanel9/Transformer.pm.orig

then with vi editor comment line in file /usr/local/psa/PMM/agents/cPanel9/Transformer.pm :

$shostingNode->addChild( $urlNode );
$domainFromSubdomainNode->addChild( $shostingNode );

# $domainFromSubdomainNode->addChild( $shostingNode ); <---- THIS LINE SHOULD BE COMMENTED BY # SYMBOL
return $shostingNode;

 

[Gabrielpasv]

After I comment the line it was able to start the migration.. but at the end of the migration it gave me message " completed with erros"

Looks like some database errors

Error:
Failed to execute backup database



Error:
Failed to pack files sqldump_1305210908 in /var/cache/20130521130719738//domains/sites.plantant.com/databases/sitespla_fngla_tls2012 [ 74537840640 bytes free of 120333875200 bytes total on mount point 0]



Error:
Failed to execute backup database



Can you help me?

 

[Gabrielpasv]

Hi IgorG Thanks so much for the help

I see errors like these on migration.log

It is trying to use user DB root which doesn't exist anymore. Plesk renames it to admin right ?


[2891]: 13:07:46 INFO Finish dumping mail configuration for plantant.com.
DBI connect('dbname=mysql;host=localhost','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at Db/DbiBackend.pm line 43


[3141]: 13:08:05 INFO Domain 'sites.plantant.com' is dumped
DBI connect('dbname=sitespla_dotcms','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at Db/DbiBackend.pm line 43
DBI connect('dbname=sitespla_dotcms;host=localhost','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at Db/DbiBackend.pm line 43
[3141]: 13:08:07 INFO New connection: mysql shell connection. db sitespla_dotcms, user root, local socket
[3286]: 13:08:07 INFO Executing bundle producer: '/usr/bin/mysqldump -u 'root' --quick --quote-names --add-drop-table --default-character-set=utf8 --set-charset 'sitesp
la_dotcms'' in



See some more




[13:08:07|DEBG: 1630.Ssh] remote stderr -> Can't use an undefined value as an ARRAY reference at Db/ShellBackend.pm line 97.
at Db/ShellBackend.pm line 97
Db::ShellBackend::getFileToRemove('Db::MysqlShellBackend=HASH(0x117976a8)') called at Db/Connection.pm line 120
Db::Connection::getFileToRemove('password', 'undef', 'utf8names', 1, 'name', 'sitespla_dotcms', 'user', 'root', 'type', ...) called at Storage/DbBundle.pm line
29
Storage:bBundle::cleanup('Storage:bBundle=HASH(0x1179dc98)') called at Storage/FileStorage.pm line 146
Storage::FileStorage::__ANON__() called at IPC/Run.pm line 2645
IPC::Run::_do_kid_and_exit('IPC::Run=HASH(0x1179df38)', 'HASH(0x117915f8)') called at IPC/Run.pm line 1363
IPC::Run::_spawn('IPC::Run=HASH(0x1179df38)', 'HASH(0x117915f8)') called at IPC/Run.pm line 2779
eval {...} called at IPC/Run.pm line 2776
IPC::Run::start('IPC::Run=HASH(0x1179df38)') called at IPC/Run.pm line 1433
IPC::Run::run('IPC::Run=HASH(0x1179df38)') called at Storage/FileStorage.pm line 181
Storage::FileStorage::executeAndSave('Storage::FileStorage=HASH(0x109df1a8)', '/var/cache/20130521130719738//domains/sites.plantant.com/data...', 'sqldump_13052
10908', '', 'Storage:bBundle=HASH(0x1179dc98)', 'REF(0x10943838)', 'Math::BigInt=HASH(0x10943ef8)', 'Math::BigInt=HASH(0x10943f78)') called at Storage/FileStorage.pm
line 370

 

[IgorG]

Plesk renames it to admin right ?

Yes, you are correct.