CentOS 5.x >> CentOS 6.x

Moderator: crythias

Locked
Giulio Soleni
Znuny wizard
Posts: 392
Joined: 30 Dec 2010, 14:35
Znuny Version: 6.0.x and 5.0.x
Real Name: Giulio Soleni
Company: IKS srl

CentOS 5.x >> CentOS 6.x

Post by Giulio Soleni »

Hi,
I currently have a production environment otrs-3.2.9-01 installed on a CentOS 5.9 release and MySQL 5.0.95 database.
I know from viewtopic.php?f=53&t=22762 that OTRS cannot be updated to the 3.3.x version due to the Perl 5.10.0 requirements.

These are the details of my present system:
[root@x-otrs ~]# cat /etc/redhat-release
CentOS release 5.9 (Final)
[root@x-otrs ~]# uname -a
Linux x-otrs.iks.local 2.6.18-348.12.1.el5 #1 SMP Wed Jul 10 05:28:41 EDT 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@x-otrs ~]# rpm -qa | grep mysql
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-connector-odbc-3.51.26r1127-2.el5
mysql-server-5.0.95-5.el5_9
php-mysql-5.1.6-40.el5_9
mysql-5.0.95-5.el5_9
mysql-5.0.95-5.el5_9
[root@x-otrs ~]# rpm -qa | grep otrs
otrs-3.2.9-01

I try to write down the possible migration steps from my current server to a new CentOS 6.4 server with MySQL 5.6.
Here [old.otrs] is my present system (based on CentOS 5) and [new.otrs] is my new system (based on CentOS 6)

1. update OTRS 3.2.9 on [old.otrs] to OTRS 3.2.12 ... since OTRS 3.2.9 version is not compatible with MySQL 5.6
2. install a pretty new system [new.otrs] based on CentOS 6.4 x64, MySQL 5.6 and OTRS 3.2.12
3. backup the database and the article folders (/opt/otrs/var/...) on [old.otrs]
4. restore the backed up stuff on the [new.otrs] system (skipping the OTRS binaries) <<<< I AM NOT SURE ABOUT HOW I CAN DO THAT
5. update the [new.system] to OTRS 3.3.1 (or last available 3.3.x version).

Do you think that this procedure may work?
I think that the critical point is #4.
- MySQL db 5.0.95 can be imported directly on a MySQL 5.6 ?
- I store (by SysConfig) all attachments, tickets and articles on the fs... is it safe to cut and paste that folder from [old.system] to [new.system] ?

Does anyone has already performed this kind of migration?
Any issue or problem found?

Thank you in advance!

Giulio
OTRS 6.0.x on CentOS 7.x with MariaDB 10.2.x database connected to an Active Directory for Agents and Customers.
ITSM and FAQ modules installed.
Locked