Skip to main content

Transfer fail

Comments

34 comments

  • cPRex Jurassic Moderator

    You don't need to pre-create anything as the package will do all that for you.

    1
  • cPRex Jurassic Moderator

    You're very welcome - it's what I'm here for!

    1
  • cPRex Jurassic Moderator

    Hey there!  On the Source machine, are you able to run "/scripts/pkgacct username" without errors?  Just replace "username" with the cPanel account username you are working with.

    0
  • boazor

    Hi cPRex ,

    Thanks for the reply.

    Forgive me if I dont understand what you mean where I do this "/scripts/pkgacct username" ?

     

    0
  • cPRex Jurassic Moderator

    pkgacct is the tool that creates the cPanel backup that you move to the other server.  Testing this on the command line directly may give you more information about the database failure so we can get that resolved.

     

    0
  • boazor

    OK,

    no error.

    Boaz

     

    0
  • cPRex Jurassic Moderator

    So that completed fully for the user with no error?  Nothing odd showed up with the database when you ran that?

    0
  • boazor

    No , and its create file on server 900MB but full account is 2.5GB

     

    [root@cp ~]# /scripts/pkgacct xxxxxx (user name)
    [2024-04-03 08:04:26 -0700] pkgacct started.
    [2024-04-03 08:04:26 -0700] pkgacct version 10 - user : xxxxxxx- tarball: 1 - target mysql : default - split: 0 - incremental: 0 - homedir: 1 - mailman: 1 - backup: 0 - archive version: 4 - running with uid 0
    [2024-04-03 08:04:26 -0700] pkgacct using '/usr/local/cpanel/3rdparty/bin/pigz -6 --processes 1 --blocksize 4096 --rsyncable' to compress archives
    [2024-04-03 08:04:26 -0700] pkgacct working dir : /home/cpmove-xxxxxx
    [2024-04-03 08:04:26 -0700] Copying Reseller Config...[2024-04-03 08:04:26 -0700] Done
    [2024-04-03 08:04:26 -0700] Copying Suspension Info (if needed)...[2024-04-03 08:04:26 -0700] Done
    [2024-04-03 08:04:26 -0700] Copying Team Info (if needed)...[2024-04-03 08:04:26 -0700] Done
    [2024-04-03 08:04:26 -0700] Copying installed SSL certificates and keys...[2024-04-03 08:04:26 -0700] Performing “ApacheTLS” component....
    [2024-04-03 08:04:26 -0700] Completed “ApacheTLS” component.
    [2024-04-03 08:04:26 -0700] Done
    [2024-04-03 08:04:26 -0700] Copying DKIM keys....[2024-04-03 08:04:26 -0700] Done
    [2024-04-03 08:04:26 -0700] Copying Bandwidth Data....[2024-04-03 08:04:26 -0700] Performing “Bandwidth” component....
    Summary databases … done!
    [2024-04-03 08:04:27 -0700] Completed “Bandwidth” component.
    [2024-04-03 08:04:27 -0700] Done
    [2024-04-03 08:04:27 -0700] Copying Dns Zones.......xxxxxxx...[2024-04-03 08:04:27 -0700] Done
    [2024-04-03 08:04:27 -0700] Copying Mail files....[2024-04-03 08:04:27 -0700] Performing “MailConfig” component....
    [2024-04-03 08:04:27 -0700] Completed “MailConfig” component.
    [2024-04-03 08:04:27 -0700] Done
    [2024-04-03 08:04:27 -0700] Copying proftpd file....[2024-04-03 08:04:27 -0700] Done
    [2024-04-03 08:04:27 -0700] Performing “Logs” component....
    ...log file sizes [40086 byte(s)]......xxxxxxxx-ssl_log......xxxxxxx.....xxxxxxxx-bytes_log...[2024-04-03 08:04:27 -0700] Completed “Logs” component.
    [2024-04-03 08:04:27 -0700] Copy userdata...[2024-04-03 08:04:27 -0700] Done
    [2024-04-03 08:04:27 -0700] Copy custom virtualhost templates...[2024-04-03 08:04:27 -0700] Done
    [2024-04-03 08:04:27 -0700] Copying mailman lists and archives....Done copying mailman lists and archives.
    [2024-04-03 08:04:27 -0700] Copying homedir.............
    [2024-04-03 08:04:28 -0700] Done
    [2024-04-03 08:04:28 -0700] Fixing up EA4 .htaccess blocks: /home/xxxxxx/public_html/.htaccess  Done.
    [2024-04-03 08:04:28 -0700] Performing “Postgresql” component....
    [2024-04-03 08:04:28 -0700] Completed “Postgresql” component.
    [2024-04-03 08:04:28 -0700] Performing “Mysql” component....
    [2024-04-03 08:04:28 -0700] Determining mysql dbs...[2024-04-03 08:04:28 -0700] ...mysqldump version: 5.7.44...[2024-04-03 08:04:28 -0700] ...mysql version: 5.7...[2024-04-03 08:04:28 -0700] Saving mysql privs...[2024-04-03 08:04:28 -0700] Done
    [2024-04-03 08:04:28 -0700] Saving mysql authentication information...[2024-04-03 08:04:28 -0700] Done
    [2024-04-03 08:04:28 -0700] Storing MySQL databases...[2024-04-03 08:04:28 -0700] Storing database rewardsc_cpanewnetworkscr
    [2024-04-03 08:05:11 -0700] Storing database rewardsc_support
    [2024-04-03 08:05:11 -0700] Done
    [2024-04-03 08:05:11 -0700] ...Done
    [2024-04-03 08:05:11 -0700] ...Done
    [2024-04-03 08:05:11 -0700] Completed “Mysql” component.
    [2024-04-03 08:05:11 -0700] Performing “MysqlRemoteNotes” component....
    [2024-04-03 08:05:11 -0700] Completed “MysqlRemoteNotes” component.
    [2024-04-03 08:05:11 -0700] Performing “CpUserFile” component....
    [2024-04-03 08:05:11 -0700] Completed “CpUserFile” component.
    [2024-04-03 08:05:11 -0700] Performing “Cron” component....
    [2024-04-03 08:05:11 -0700] Readable crontab file (/var/spool/cron/xxxxxxx) found; copying …
    [2024-04-03 08:05:11 -0700] Completed “Cron” component.
    [2024-04-03 08:05:11 -0700] Performing “Quota” component....
    [2024-04-03 08:05:11 -0700] Completed “Quota” component.
    [2024-04-03 08:05:11 -0700] Performing “Integration” component....
    [2024-04-03 08:05:11 -0700] Completed “Integration” component.
    [2024-04-03 08:05:11 -0700] Performing “AuthnLinks” component....
    [2024-04-03 08:05:11 -0700] Completed “AuthnLinks” component.
    [2024-04-03 08:05:11 -0700] Performing “APITokens” component....
    [2024-04-03 08:05:11 -0700] Completed “APITokens” component.
    [2024-04-03 08:05:11 -0700] Performing “DNSSEC” component....
    [2024-04-03 08:05:11 -0700] Completed “DNSSEC” component.
    [2024-04-03 08:05:11 -0700] Performing “Custom” component....
    [2024-04-03 08:05:11 -0700] No custom components to perform.
    [2024-04-03 08:05:11 -0700] Completed “Custom” component.
    [2024-04-03 08:05:11 -0700] Performing “AutoSSL” component....
    [2024-04-03 08:05:11 -0700] Completed “AutoSSL” component.
    [2024-04-03 08:05:11 -0700] Storing Subdomains....
    [2024-04-03 08:05:11 -0700] Done
    [2024-04-03 08:05:11 -0700] Storing Parked Domains....
    [2024-04-03 08:05:11 -0700] Done
    [2024-04-03 08:05:11 -0700] Storing Addon Domains....
    [2024-04-03 08:05:11 -0700] Performing “Password” component....
    [2024-04-03 08:05:11 -0700] Completed “Password” component.
    [2024-04-03 08:05:11 -0700] Performing “DigestShadow” component....
    [2024-04-03 08:05:11 -0700] Completed “DigestShadow” component.
    [2024-04-03 08:05:11 -0700] Copying shell.......[2024-04-03 08:05:11 -0700] Done
    [2024-04-03 08:05:11 -0700] Performing “WebCalls” component....
    [2024-04-03 08:05:11 -0700] Completed “WebCalls” component.
    [2024-04-03 08:05:11 -0700] Performing “BrandCustomizations” component....
    [2024-04-03 08:05:11 -0700] Completed “BrandCustomizations” component.
    [2024-04-03 08:05:11 -0700] Performing “PublicContact” component....
    [2024-04-03 08:05:11 -0700] Completed “PublicContact” component.
    [2024-04-03 08:05:11 -0700] Performing “MailLimits” component....
    [2024-04-03 08:05:11 -0700] Completed “MailLimits” component.
    [2024-04-03 08:05:11 -0700] Performing “LinkedNodes” component....
    [2024-04-03 08:05:11 -0700] Completed “LinkedNodes” component.
    [2024-04-03 08:05:11 -0700] Creating Archive ............................................
    [2024-04-03 08:06:53 -0700] Done
    [2024-04-03 08:06:53 -0700] pkgacctfile is: /home/cpmove-xxxxxxx.tar.gz
    [2024-04-03 08:06:56 -0700] md5sum is: 18546be90b59721a34beeccbc8883659
    [2024-04-03 08:06:56 -0700]
    [2024-04-03 08:06:56 -0700] size is: 932719402
    [2024-04-03 08:06:56 -0700]
    [2024-04-03 08:06:56 -0700] homesize is: 849899520
    [2024-04-03 08:06:56 -0700]
    [2024-04-03 08:06:56 -0700] homefiles is: 8331
    [2024-04-03 08:06:56 -0700]
    [2024-04-03 08:06:56 -0700] mysqlsize is: 3115304532
    [2024-04-03 08:06:56 -0700] pkgacct completed

    0
  • cPRex Jurassic Moderator

    Well, that's a good sign then!  Is there a major difference between the MySQL versions on the two systems?

    0
  • boazor

    on new server MySQL 8.0 on old server MySQL 5.7  

    0
  • cPRex Jurassic Moderator

    I'm wondering if there was just a temporary issues - if you try the Transfer Tool again, does it still fail?

    0
  • boazor

    I try like few times yesterday , I ever try to do it when account suspend didnt work.

    I moved like few WP website's all moved easy even with 1GB data

    0
  • cPRex Jurassic Moderator

    Could you try manually moving over that pkgacct file you created as a test and see if a manual restore would work?  Once the file is moved over to the Destination machine and placed in /home you can restore it through WHM or you can run "/scripts/restorepkg /full/path/to/file"

    0
  • boazor

    I can do that just need to know if its include the database is its only 900MB and all account is 2.5GB is that ok?

    0
  • cPRex Jurassic Moderator

    Yes, everything for the account is included in that package we made.

    0
  • boazor

    Do I need to create account on new server or its will create everything ?

    0
  • boazor

    Its look like move everything no error . 

    Thank you very much .

    Can I do it on suspend account to?

    its live site and I need to take it down before I start 

     

    0
  • cPRex Jurassic Moderator

    Yes, although you may need to manually unsuspend it on the Destination after the restore is complete as it will likely also move the suspended flag.

    0
  • boazor

    Ok, 

    On list account the size of account will take time to update ? as I see now 800mb

    0
  • cPRex Jurassic Moderator

    That's also correct - you can manually run /scripts/fixquotas to force an update to that, but it will happen automatically as part of the nightly maintenance.

    0
  • boazor

    cPRex thank you very much for all the help and patience is greatly appreciated

    0
  • boazor

    Hi cPRex,

    everything moved , But I am getting error can it be something with .htaccess ?

    he requested URL was not found on this server.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

    0
  • cPRex Jurassic Moderator

    It's hard to say - do you see anything helpful in the main Apache log at /etc/apache2/logs/error_log?

    Do other files on that domain work properly?

    0
  • boazor

    I dont see any error regard this just something about file permission but I fix it as was on old server

    755 and 644  

    0
  • cPRex Jurassic Moderator

    I'm glad you were able to get that fixed quickly!

    0
  • boazor

    I didnt :( I fix the permission but still not working.

    I remove somethings from htaccess domain start work but not everything 

     

    0
  • cPRex Jurassic Moderator

    We might need to see a ticket on this issue as we'll need more details to troubleshoot this.

    0
  • boazor

    I found this : ModSecurity: collections_remove_stale: Failed to access DBM file "/var/cpanel/secdatadir/

    And this is how to fix it just need to be sure its not open some security issues 

    https://support.cpanel.net/hc/en-us/articles/9487131172887-ModSecurity-collection-store-Failed-to-access-DBM-file-var-cpanel-secdatadir-nobody-ip-Permission-denied

     

    0
  • cPRex Jurassic Moderator

    There are no security issues by applying that fix.

    0
  • boazor

    On EasyApache 4 I notice its not the same as the old one maybe I will try to compere and add what missing ?

    0

Please sign in to leave a comment.