I am running into a problem when I try to clone the OTRS database using the CloneDB module as shown below.
Code: Select all
[Wed Aug 5 12:31:28 2015] otrs.CloneDB.pl: DBD::mysql::st execute failed: Table 'otrs.change_freetext' doesn't exist at /opt/otrs/KIX4OTRS/Kernel/System/DB.pm line 635.
[Wed Aug 5 12:31:28 2015] otrs.CloneDB.pl: Version string '-1, set by base.pm' contains invalid data; ignoring: '-1, set by base.pm' at /opt/otrs/Kernel/System/Log.pm line 197.
[Wed Aug 5 12:31:28 2015] otrs.CloneDB.pl: Version string '-1, set by base.pm' contains invalid data; ignoring: '-1, set by base.pm' at /opt/otrs/Kernel/System/Log.pm line 197.
ERROR: OTRS-otrs.CloneDB.pl-01 Perl: 5.10.1 OS: linux Time: Wed Aug 5 12:31:28 2015
Message: Table 'otrs.change_freetext' doesn't exist, SQL: '
SELECT COUNT(*)
FROM change_freetext'
Traceback (24382):
Module: Kernel::System::CloneDB::Driver::Base::RowCount Line: 170
Module: Kernel::System::CloneDB::Driver::Base::SanityChecks Line: 124
Module: Kernel::System::CloneDB::Backend::SanityChecks Line: 260
Module: ./otrs.CloneDB.pl Line: 75
[Wed Aug 5 12:31:28 2015] otrs.CloneDB.pl: Died at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 170.
When i initiate a dry run with CloneDB.pl -n is says everything is ok.
Both versions of MYSQL are the same at both ends (5.1.73)
I have checked Telnet connectivity on 3306 to the remote database and that is working fine. I have run the following commands from the remote end:
Code: Select all
mysql> DROP DATABASE otrs;
mysql> CREATE DATABASE otrs;