Thursday, September 18, 2008

Upgrading OTRS from 2.2 to 2.3

Here is the method I've used to upgrade OTRS from 2.2 to 2.3 (2.2.7 to 2.3.2, in fact)
  • I did a full backup of my MySQL data.
  • I backed up 2 files, /opt/otrs/Kernel/Config.pm and /opt/otrs/Kernel/Config/Files/ZZZAuto.pm
  • I upgraded the RPM using rpm -Uvhf otrs-2.3.2-01.i386.rpm
  • Then the Database migration:

  • cd /opt/otrs/scripts/
  • mysql -uotrs -phot < DBUpdate-to-2.3.mysql.sql otrs
  • perl DBUpdate-to-2.3.pl
  • mysql -uotrs -phot < DBUpdate-to-2.3-post.mysql.sql otrs
  • Restarted httpd, MySQL and OTRS service
That's it... You can now log in in the new version (2.3)!