OTRS upgrade
1.2.4 - 1.3.2
RedHat 9
Backing up the MySQL data should not be a problem: you can simply copy the
complete MySQL OTRS data directory including all the data (.MYD files) to
another directory. You should backup you data on a daily bases: make a cron job
for the mysqldump command (see
http://dev.mysql.com/doc/mysql/en/mysqldump.html). It's very easy and should
not be a problem. I'm not a Linux expert, but this is simple and powerful.
I assume you have downloaded the new 1.3.2 OTRS RH8 rpm.
1. stop all services ("service otrs stop")
2. backup everything (I did
not need the backup files at all, but you never know....) : OTRS is in
/opt/otrs. Copy the complete directory structure (I did this with
Midnight Commander (mc) utility) to f.i. /otrs124
3. backup MySQL data
(/var/lib/mysql/otrs/*.MYD files)
4. install the new RPM (rpm -ivh --force otrsxxxxxx.rpm) I had to use --force
so all the old files were rewritten, when I didn't I got a lot of error
messages)
5. update the database changes with:
MySQL: cat /opt/otrs/scripts/DBUpdate-to-x.y.mysql.sql | mysql -p -f -u
root otrs
6. execute (from /bin !!) /opt/otrs/bin/SetPermissions.sh
otrs apache apache apache apache
7. I changed in /etc/sysconfig/otrs the OTRS_DB_RUNNING=1 to =0 because on RH
the mysqld check does not work properly
8. restart the services:
service httpd restart
service mysql start
service otrs start
this did the job for me :-)
regards,
Peter
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Philippe Roth
Sent: woensdag 15 juni 2005 15:11
To: otrs@otrs.org
Subject: [otrs] Please need HELP...
Dear All,
I sent this problem several times, but no answers.... Pleaaaase....
We need to know how to make an upgrade from a previous version too a
more recent.
We have installed version 1.3.1 and would like to make the upgrade to
1.3.2 (before version 2.0)
We made works and we have a problem when making a queue a sub-queue of
an other.
The message shown is "Error: Need SystemAddressID! "
Our server is under Fedora Core 2.
We made backup of the database with
# mysqldump --add-drop-table -u root -p otrs otrs-backup.bkp
We would like to know what is the correct procedure to make a upgrade?
Does anyone have any experience in this???
Please heeeellllppppp.....
Many thanks in advance for some light,
Philippe Roth
_______________________________________________
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
Support oder Consulting für Ihr OTRS System?
=http://www.otrs.de/
_______________________________________________
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
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
