OK, As I promised here is what I did to migrate OTRS v3.0.11 from a windows to a Centos linux box.
FIRST: This worked for me, it's not an official tutorial neither approved by OTRS team. Use it at your own risk. ;)
Before migration:
OTRS v3.0.11 running on a windows XP box.
Goal:
Migrate the same version to a linux box maintaining all data as in the windows server.
Steps to migrate same version 3.0.11 from the window to linux.
- Install a fresh CentOS 6.3 with all updates.
- Install OTRS v 3.0.11 following this URL: http://www.blog.paranoidpenguin.net/2012/04/how-to-install-otrs-3-1-on-cento... but using v 3.0.11 instead 3.1.3, also I used postfix instead sendmail.
- versions of some software:
[root@otrs2 sys]# rpm -qa|grep otrs
otrs-3.0.11-03.noarch
[root@otrs2 sys]# rpm -qa|grep httpd
httpd-2.2.15-15.el6.centos.1.i686
httpd-tools-2.2.15-15.el6.centos.1.i686
[root@otrs2 sys]# rpm -qa|grep mysql
mysql-libs-5.1.61-4.el6.i686
php-mysql-5.3.3-14.el6_3.i686
mysql-5.1.61-4.el6.i686
mysql-server-5.1.61-4.el6.i686
[root@otrs2 sys]# rpm -qa|grep perl
perl-5.10.1-127.el6.i686
- Backup to MYSQL database on Windows.
C:\>"C:\Archivos de programa\OTRS\mysql\bin\mysqldump.exe" -uroot -p otrs > otrsbk.sql
-Copied these files to my PC for copying later to the linux box:
Kernel/Config.pm
Kernel/Config/GenericAgent.pm
Kernel/Config/Files/ZZZAuto.pm
var/*
- OPTIONAL: make a backup of MYSQL database on the linux side before being deleted.
[root@otrs2 init.d]# mysqldump -u root -p otrs >/tmp/otrs_original_antes_migracion.sql
Enter password:
- DROP database on the linux side stopping first all daemons regarding OTRS (httpd, crond, postfix)
CRON
[root@otrs2 init.d]# service crond stop
Stopping crond: [ OK ]
APACHE
[root@otrs2 init.d]# service httpd stop
Stopping httpd: [ OK ]
POSTFIX
[root@otrs2 init.d]# service postfix stop
[root@otrs2 init.d]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.61 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| otrs |
+--------------------+
3 rows in set (0.00 sec)
mysql> drop database otrs;
Query OK, 111 rows affected (0.10 sec)
mysql> exit
Bye
[root@otrs2 init.d]#
- Copy otrsbk,sql file, create new database and import the MYSQL-Windows file in the linux box.
Copy otrsbk.sql to linux:/tmp/
[root@otrs2 init.d]# mysqladmin -u root -p create otrs
Enter password:
[root@otrs2 init.d]# mysql -u otrs -p otrs < /tmp/otrsbk.sql
Enter password:
- Stop all services on the linux box regarding OTRS.
CRON
[root@otrs2 init.d]# service crond stop
Stopping crond: [ OK ]
APACHE
[root@otrs2 init.d]# service httpd stop
Stopping httpd: [ OK ]
MYSQL
[root@otrs2 init.d]# service mysqld stop
Stopping mysqld: [ OK ]
POSTFIX
[root@otrs2 init.d]# service postfix stop
Shutting down postfix: [ OK ]
- Copy these files and folders from my PC to the linux BOX. (NOTE: Recommended to verify all permissions on the copied files before continue)
Kernel/Config.pm
Kernel/Config/GenericAgent.pm
Kernel/Config/Files/ZZZAuto.pm
var/*
- Replaced this string "/ARCHIV~1/OTRS/OTRS/" for this one "/opt/otrs" on these files:
/opt/otrs/Kernel/Config.pm
/opt/otrs/Kernel/Config/Files/ZZZAuto.pm
- Check if database's "otrs" password is the same on the linux box editing this file /opt/otrs/Kernel/Config.pm
# (The password of database user. You also can use bin/CryptPassword.pl
# for crypted passwords.)
$Self->{'DatabasePw'} = 'otrs-password';
- Execute this two scripts:
[root@otrs2 Config]# /opt/otrs/bin/otrs.RebuildConfig.pl
otrs.RebuildConfig.pl
Hi Steve,
I think Perl supports this out of the box. :D Try something like:
push @{$Self->{CustomerUser}->{Map}}, [ your additional settings here ... ];
Best regards, mg
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs