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.

tranfertool discontinues

Discussion in 'Data Protection' started by D.Schmidt, Jun 8, 2016.

Tags:
  1. D.Schmidt

    D.Schmidt Registered

    Joined:
    May 31, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Essen
    cPanel Access Level:
    Root Administrator
    Hi, clicking "Fetch Account List" stops with this:

    Code:
    Failed to execute sql method do: (XID 7dzhfk) DBD::mysql::db do failed: Unknown column 'creator' in 'field list' at /usr/local/cpanel/Cpanel/DBBackend.pm line 157.
        Cpanel::DBBackend::_retried_sql(Whostmgr::Transfers::Session=HASH(0x7d1b648), "do", "INSERT INTO sessions (sessionid,version,creator,initiator,tar"...) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 95
        Cpanel::DBBackend::_retried_do(Whostmgr::Transfers::Session=HASH(0x7d1b648), "INSERT INTO sessions (sessionid,version,creator,initiator,tar"...) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1460
        Whostmgr::Transfers::Session::_create_new_session(Whostmgr::Transfers::Session=HASH(0x7d1b648), "1447631113copya20160608073047MgzLwLV") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1126
        Whostmgr::Transfers::Session::_set_session_id(Whostmgr::Transfers::Session=HASH(0x7d1b648), "1447631113copya20160608073047MgzLwLV") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1016
        Whostmgr::Transfers::Session::_init(Whostmgr::Transfers::Session=HASH(0x7d1b648), "session_id_template", "144.76.31.113", "initiator", "copyacct", "create", 1) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 31
        Cpanel::DBBackend::new("Whostmgr::Transfers::Session", "initiator", "copyacct", "create", 1, "session_id_template", "144.76.31.113") called at /usr/local/cpanel/Whostmgr/Transfers/Session/Setup.pm line 51
        Whostmgr::Transfers::Session::Setup::try {...} () called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80
        eval {...} called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71
        Try::Tiny::try(CODE(0x7d1bfc0), Try::Tiny::Catch=REF(0x7d1c0b0)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Setup.pm line 59
        Whostmgr::Transfers::Session::Setup::setup_session_obj(HASH(0x8059e60), HASH(0x804c9c8)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Preflight/RemoteRoot/Create.pm line 78
        Whostmgr::Transfers::Session::Preflight::RemoteRoot::Create::_create_remote_root_transfer_session(HASH(0x20c0d78)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Preflight/RemoteRoot/Create.pm line 37
        Whostmgr::Transfers::Session::Preflight::RemoteRoot::Create::__ANON__() called at /usr/local/cpanel/Cpanel/Capture.pm line 39
        Cpanel::Capture::try {...} () called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80
        eval {...} called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71
        Try::Tiny::try(CODE(0x7f65dd8), Try::Tiny::Catch=REF(0x8047d60)) called at /usr/local/cpanel/Cpanel/Capture.pm line 43
        Cpanel::Capture::trap_stdout(CODE(0x8047e20)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Preflight/RemoteRoot/Create.pm line 39
        Whostmgr::Transfers::Session::Preflight::RemoteRoot::Create::create_remote_root_transfer_session(HASH(0x20c0d78)) called at /usr/local/cpanel/Whostmgr/API/1/Transfers.pm line 113
        Whostmgr::API::1::Transfers::create_remote_root_transfer_session(HASH(0x20c0d78), HASH(0x6a50b78), HASH(0x20bfbf0)) called at whostmgr/bin/xml-api.pl line 2872
        whostmgr::bin::xml_api::__ANON__(HASH(0x6a50b78), HASH(0x20c0d78), HASH(0x20bfbf0), CODE(0x69aa5b8)) called at /usr/local/cpanel/Whostmgr/API/1/Data/Wrapper.pm line 218
        Whostmgr::API::1::Data::Wrapper::try {...} () called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80
        eval {...} called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71
        Try::Tiny::try(CODE(0x6f7abb0), Try::Tiny::Catch=REF(0x8047a78)) called at /usr/local/cpanel/Whostmgr/API/1/Data/Wrapper.pm line 237
        Whostmgr::API::1::Data::Wrapper::execute_internal(CODE(0x77e00c0), HASH(0x20c0d78), HASH(0x20bfbf0), HASH(0x76987a8), CODE(0x69aa5b8)) called at whostmgr/bin/xml-api.pl line 3023
        whostmgr::bin::xml_api::runapp(__CPANEL_HIDDEN__, HASH(0x20bfbf0), HASH(0x20d8988), 0, CODE(0x69aa5b8)) called at whostmgr/bin/xml-api.pl line 2805
        whostmgr::bin::xml_api::script(CODE(0x69aa5b8), "-json", "./create_remote_root_transfer_session") called at whostmgr/bin/xml-api.pl line 2757
    any ideas?
    cheers

    /etc/redhat-release:CloudLinux release 7.2 (Valeri Kubasov)
    /usr/local/cpanel/version:11.56.0.22
    /var/cpanel/envtype:standard
    CPANEL=release
    Server version: Apache/2.4.18 (Unix)
    Server built: Jan 20 2016 10:21:03
    Cpanel::Easy::Apache v3.32.9 rev9999 +cloudlinux
    PHP 5.5.31 (cli) (built: Jan 20 2016 10:22:52)
    Copyright (c) 1997-2015 The PHP Group
    Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies
    mysql Ver 14.14 Distrib 5.5.45, for Linux (x86_64) using readline 5.1
     
    #1 D.Schmidt, Jun 8, 2016
    Last edited by a moderator: Jun 8, 2016
  2. dswimr615

    dswimr615 Member

    Joined:
    Jan 9, 2014
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I don't know if your issue has been fixed, but this is the first result on google so I wanted to post the answer cPanel gave which resolved the problem:

    The issue was a missing column in the 'whmxfer' database on the destination server. For some reason, the 'creator' column did not exist on the destination server in the whmxfer database. I created it as it exists on your source server and a test server, via WHM's phpMyAdmin.

    Code:
    mysql> show columns in sessions;
    +-------------+------------+------+-----+---------+-------+
    | Field | Type | Null | Key | Default | Extra |
    +-------------+------------+------+-----+---------+-------+
    | sessionid | char(255) | NO | PRI | NULL | |
    | initiator | char(255) | YES | | unknown | |
    | pid | bigint(20) | YES | | 0 | |
    | version | double | YES | | 0 | |
    | target_host | char(255) | YES | | NULL | |
    | source_host | char(255) | YES | | NULL | |
    | state | bigint(20) | YES | | 0 | |
    | starttime | datetime | YES | | NULL | |
    | endtime | datetime | YES | | NULL | |
    | creator | char(255) | YES | | root | |
    +-------------+------------+------+-----+---------+-------+
    

    After doing this, the Transfer Tool is connecting without error.
     
    #2 dswimr615, Jun 28, 2016
    Last edited by a moderator: Jul 7, 2016
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    CPANEL-6878 is open to track reports of this issue. There's currently no update to provide on the cause of this problem, but I'll update this thread with more information as it becomes available.

    Note that in cPanel 58, transfers now use the SQLite database. Here's a quote from the cPanel 58 release notes:

    Thank you.
     
  4. D.Schmidt

    D.Schmidt Registered

    Joined:
    May 31, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Essen
    cPanel Access Level:
    Root Administrator
    ok, thank you.
    I reinstalled the whole server and the problem was gone.
     

Share This Page