# --
# UPGRADING - upgrading OTRS
# Copyright (C) 2001-2008 OTRS AG, http://otrs.org/
# --
# $Id: UPGRADING,v 1.27 2008/07/03 22:52:58 martin Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (GPL). If you
# did not receive this file, see http://www.gnu.org/licenses/gpl-2.0.txt.
# --

These instructions are for people upgrading OTRS from "2.2" to "2.3".

*) Stop all your services (e. g. rcotrs stop-force)

*) Backup everything (database, Kernel/Config.pm, Kernel/Config/GenericAgent.pm, var/*)
   (Remember: 5% of all config settings are renamed in OTRS 2.2, so may some of the
   Kernel/Config.pm settings will not be compatible)

*) Make sure that you have backed up everything ;-)

*) If possible try this install on a separate machine, althoug
   I had always only production machines to upgrade

*) Install the new release (tar or RPM)

*) If you use the tar:

    a) the OTRS themes between 2.2 and 2.3 are _not_ compatible
       (don't use the old themes)!

*) Update the database changes with (part 1):
    MySQL:
      cat $OTRS_HOME/scripts/DBUpdate-to-2.3.mysql.sql | mysql -p -f -u root otrs
    PostgreSQL:
      cat $OTRS_HOME/scripts/DBUpdate-to-2.3.postgresql.sql | psql otrs

   (Don't worry about the error messages, you can update all previous version
   with this script and in the most cases your database has already the most changes!)

*) Run the migration script (as OTRS user, _not_ as root):
   You must execute the migration script to migrate some data from the old database
   structure to the new one. Please run $OTRS_HOME/scripts/DBUpdate-to-2.3.pl!

*) Update the database changes with (part 2):
    MySQL:
      cat $OTRS_HOME/scripts/DBUpdate-to-2.3-post.mysql.sql | mysql -p -f -u root otrs
    PostgreSQL:
      cat $OTRS_HOME/scripts/DBUpdate-to-2.3-post.postgresql.sql | psql otrs

*) If _no_ RPM is used, execute $OTRS_HOME/bin/SetPermissions.sh!

*) Restart your services (e. g. rcotrs restart-force or each service manually)

*) Log in as 'root@localhost' and select Admin -> SysConfig to make sure that
   OTRS updates the configuration files.
