Restore account failed

Hedloff

March 02, 2015 04:42

Hello, We have customers that are moving from bluehost etc and when you download a backup from them the name on the file is: backup-mon-mar-02-01_40_30-2015.tar How can we restore that file? Tried this:

[/home]# /scripts/restorepkg backup-mon-mar-02-01_40_30-2015.tar
cPanel restorepkg version: 2.2
Archive user:
Restricted: no
Allow Reseller Privileges: no

The system will attempt to restore the archive file "/home/backup-mon-mar-02-01_40_30-2015.tar"
                                                                                               Failed to execute sql method do: DBD::mysql::db do failed: Column 'user' cannot be null at /usr/local/cpanel/Cpanel/DBBackend.pm line 154.
        Cpanel::DBBackend::_retried_sql(Whostmgr::Transfers::Session=HASH(0x5dd9ae8), "do", "INSERT INTO `AccountLocal_cpanelresto20150302095859If"...) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 92
        Cpanel::DBBackend::_retried_do(Whostmgr::Transfers::Session=HASH(0x5dd9ae8), "INSERT INTO `AccountLocal_cpanelresto20150302095859If"...) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1015
        Whostmgr::Transfers::Session::_insert_hashref_into(Whostmgr::Transfers::Session=HASH(0x5dd9ae8), __CPANEL_HIDDEN__, HASH(0x5e11968)) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 555
        Whostmgr::Transfers::Session::enqueue(Whostmgr::Transfers::Session=HASH(0x5dd9ae8), "AccountLocal", HASH(0x5e11968), 30) called at bin/restorepkg.pl line 272
        bin::restorepkg::script("bin::restorepkg", "backup-mon-mar-02-01_40_30-2015.tar") called at bin/restorepkg.pl line 51

Since there aren't any username it is failing. Have also tried renaming the file with username, but that is also failing?

Comments

7 comments

storminternet

March 02, 2015 12:09
Have you created pkacct for the account with the cPanel username ? From your logs I can see pkgacct was made with the backup-mon-mar. Is that real cPanel username you are using for your domain. You can either manually create your account on new server and upload it's data from old host via ftp.
0
cPanelMichael

March 02, 2015 16:56
Hello :) Are you sure these are backups generated through cPanel/WHM or the "/scripts/pkgacct" script? Or, is it possible your hosting provider is offering you custom backups? Do the contents extract in the same format as a backup generated through cPanel? Thank you.
0
vigasdeep

March 23, 2015 17:03
Exactly the same error. I created the cpmove file using /scripts/pkgacct username and trying to restore by using /scripts/restorepkg username in both command the cpmove-username.tar.gz was in /home/
Hello, We have customers that are moving from bluehost etc and when you download a backup from them the name on the file is: backup-mon-mar-02-01_40_30-2015.tar How can we restore that file? Tried this:
[/home]# /scripts/restorepkg backup-mon-mar-02-01_40_30-2015.tar cPanel restorepkg version: 2.2 Archive user: Restricted: no Allow Reseller Privileges: no The system will attempt to restore the archive file "/home/backup-mon-mar-02-01_40_30-2015.tar" Failed to execute sql method do: DBD::mysql::db do failed: Column 'user' cannot be null at /usr/local/cpanel/Cpanel/DBBackend.pm line 154. Cpanel::DBBackend::_retried_sql(Whostmgr::Transfers::Session=HASH(0x5dd9ae8), "do", "INSERT INTO `AccountLocal_cpanelresto20150302095859If"...) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 92 Cpanel::DBBackend::_retried_do(Whostmgr::Transfers::Session=HASH(0x5dd9ae8), "INSERT INTO `AccountLocal_cpanelresto20150302095859If"...) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1015 Whostmgr::Transfers::Session::_insert_hashref_into(Whostmgr::Transfers::Session=HASH(0x5dd9ae8), __CPANEL_HIDDEN__, HASH(0x5e11968)) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 555 Whostmgr::Transfers::Session::enqueue(Whostmgr::Transfers::Session=HASH(0x5dd9ae8), "AccountLocal", HASH(0x5e11968), 30) called at bin/restorepkg.pl line 272 bin::restorepkg::script("bin::restorepkg", "backup-mon-mar-02-01_40_30-2015.tar") called at bin/restorepkg.pl line 51
Since there aren't any username it is failing. Have also tried renaming the file with username, but that is also failing?
0
cPanelMichael

March 23, 2015 18:19
Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome. Thank you.
0
elmister

April 09, 2015 17:12
same problem here, with a backup created with pkgacct, deleted the account and when restoring got the same problem did you solve the problem in these weeks?
0
elmister

April 10, 2015 01:56
i finally could restore it, user account was still in /etc/passwd, for some reason there was still some files in /home/user/mail/domain.com/dovecot.* removing the user ,deleting /home/user and running restorepkg with --force option solved it
0
cPanelMichael

April 10, 2015 19:18
I am happy to see you were able to resolve the issue. Thank you for updating us with the outcome.
0

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?