As I stated in the subject, I am planning to migrate the OTRS 3.3.3 production environment on Windows Server 2008 R2 to OTRS 3.3.3 test environment on CentOS 7. I want to test that it will work on CentOS before upgrading to OTRS version 4.0.11 and putting it back in production, but this time in CentOS. I'm using MySQL database on Windows. I've installed MariaDB fork for MySQL on CentOS 7.
My plan is:
1. Install CentOS 7 on VMware;
2. Install OTRS 3.3.3 rpm;
3. Install OTRSCloneDB v.1.0.13 package on Windows OTRS to prepare for migration of the MySQL database to CentOS target location;
3. (and if everything works well) upgrade OTRS 3.3.3 on CentOS 7 to OTRS 4.0.11.
So far, I've done steps 1, 2 and 3. But I got stuck when I run perl otrs.CloneDB.pl on Windows cmd. It can't connect to my target location. It says: Access denied for user 'otrs'@'FQDN-of-my-windows' <using password: YES>. I know it's permissions issue. I configured CloneDB in SysConfig on my Win installation. Also, I've granted permissions on my MySQL on CentOS 7 to user otrs with it's password. But again, it doesn't work. I am stuck with this for 4 days now, I've googled a lot, but with no solution
That's why I'm writing to you, if you can tell me what I'm missing. If you need more info on my configuration, ask me. Maybe I'm wrong with the whole plan with the steps that I've mentioned in the beginning of this post, I don't know. I followed the manual Migrating OTRS from Windows to Linux.
And another question, if I get this connection to work, when I try to migrate the database from Windows to CentOS, will it copy the database with no disruptions in my production environment? Will it stop some services, run slower while cloning or?
Thanks in advance for any answer that might get me to resolve my issue.