Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[case 106345] Problem in restoring the account or transfer tool from other server

Discussion in 'Data Protection' started by chuvadenovembro, Jul 2, 2014.

  1. chuvadenovembro

    chuvadenovembro Member

    Joined:
    Aug 27, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    Hi Friends,
    I have a big issue on various servers with cpanel 11.44
    When I use the migration tool (transfer tools), it doesn't work properly in many accounts, some of them are not transferred and another accounts are transferred, but with missing MySQL Databases.
    Examples of error warnings:

    Code:
    Failed: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 42

The system failed to execute “ALTER DATABASE `anderson_db` DEFAULT CHARACTER SET 'utf8'” because of an error: DBD::mysql::db do failed: MySQL server has gone away
Failed to remove empty DB “anderson_db”: DBD::mysql::db do failed: MySQL server has gone away
Saved failed database restore to “/home/anderson/cpmove_failed_mysql_dbs.1403316457” for maunal restoration.
The system failed to reinstall the MySQL database “anderson_db” as “anderson_db” because of an error: The system failed to connect to the MySQL server as “anderson” because of an error: Unknown database 'anderson_db' at /usr/local/cpanel/Cpanel/DBI.pm line 43.

The “Roundcube” restore module failed because of an error: Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) at /usr/local/cpanel/Cpanel/Mysql.pm line 140 ...caught
    The problem occurs with several files of backup and migration Tool (transfer tools)

    Servers (Cloudlinux 64bits + CSF + CXS + WAF Comodo + Cpanel 11.44 + apache 2.2.X or 2.4.X)

    Anyone else with this problem?
     
    #1 chuvadenovembro, Jul 2, 2014
  2. P00r

    P00r Registered

    Joined:
    Jun 4, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    I have the same problem with a very similar configuration, using cloudlinux as well, only not using WAF Comodo rules :)

    I am trying a manual restore, the transfer looked good but then own cloud started crashing... (the account is an owncloud install mainly)
     
    #2 P00r, Jul 2, 2014
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,070
    Likes Received:
    1,361
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please check to see if /var/lib/mysql/mysql.sock is symbolically linked to /tmp/mysql.sock on the source and destination servers. If not, run this command:

    Code:
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
    Thank you.
     
    #3 cPanelMichael, Jul 3, 2014
  4. chuvadenovembro

    chuvadenovembro Member

    Joined:
    Aug 27, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    Thanks Michel,

    On my servers, this was exactly the problem
     
    #4 chuvadenovembro, Jul 3, 2014
  5. ssavchenko

    ssavchenko Registered

    Joined:
    Oct 10, 2008
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    Maybe the same problem.

    The manual backup from:
    CENTOS 6.5 x86_64
    WHM 11.44.0 (build 19)
    to WHM 11.44.0 (build 18)
    # readlink -f /tmp/mysql.sock
    /var/lib/mysql/mysql.sock

    Error:
    Code:
    The system failed to execute “ALTER DATABASE `username_dbname` DEFAULT CHARACTER SET 'utf8'” because of an error: DBD::mysql::db do failed: MySQL server has gone away
Failed to remove empty DB “username_dbname”: DBD::mysql::db do failed: MySQL server has gone away
Saved failed database restore to “/home/username/cpmove_failed_mysql_dbs.1404412357” for maunal restoration.
The system failed to reinstall the MySQL database “username_dbname” as “username_dbname” because of an error: The system failed to connect to the MySQL server as “username” because of an error: Unknown database 'username_dbname' at /usr/local/cpanel/Cpanel/DBI.pm line 43.
    Same for the others DB
     
    #5 ssavchenko, Jul 3, 2014
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,070
    Likes Received:
    1,361
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Please open a support ticket if creating the symbolic link does not help. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
    #6 cPanelMichael, Jul 3, 2014
  7. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,452
    Likes Received:
    12
    Trophy Points:
    148
    cPanel Access Level:
    DataCenter Provider

    Please check your my.cnf to make sure you do not have a very low wait_timeout that is causing mysql connections to be dropped. We have opened case 106345 to handle some of the very low wait_timeouts (the default is 28000s https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_wait_timeout) we have seen (some 15 seconds).
     
    #7 cPanelNick, Jul 7, 2014
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,070
    Likes Received:
    1,361
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    To update, a resolution for internal case number 106345 is included with cPanel version 11.44.0.27:

    Fixed case 106345: Transfers abort with SIGPIPE if the mysql timeouts are too low.

    Thank you.
     
    #8 cPanelMichael, Jul 18, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - [case 106345] Problem
  1. Reado

    SOLVED [case EA-6287] EasyApache 4 UI fails to load with UTF-8 error - The subprocess error

    Reado, May 17, 2017, in forum: EasyApache
    Replies:
    29
    Views:
    2,259
    BluegrassNet
    May 18, 2017
  2. rarod

    [case CPANEL-12822,case CPANEL-13105] phpMyAdmin max_input_vars error

    rarod, Apr 20, 2017, in forum: Database Discussions
    Replies:
    32
    Views:
    3,106
    cPanelMichael
    Aug 4, 2017
  3. linux.system25

    [case CPANEL-9751] Phpmyadmin - PHP MySQL library version

    linux.system25, Apr 11, 2017, in forum: Database Discussions
    Replies:
    12
    Views:
    3,708
    cPanelMichael
    May 29, 2017
  4. chiareu

    Configured cron-jobs not displayed on Cpanel > Cron Jobs [case CPANEL-6197, fixed in 56.0.17]

    chiareu, Apr 8, 2016, in forum: General Discussion
    Replies:
    32
    Views:
    8,079
    cPanelNick
    May 17, 2016
  5. tomfra

    [Case CPANEL-1843] pkgacct on 11.50.2.0 under CentOS 5

    tomfra, Oct 7, 2015, in forum: Data Protection
    Replies:
    9
    Views:
    1,606
    @home
    Oct 8, 2015

Share This Page