upgrade OTRS 2.1.7 to 2.2.1

newer
How to installation on Fedora...

older
Tickets shown on "my queues" view

bradis

9 Jul 2007 9 Jul '07

12:45 p.m.

So, did anyone already made it ? Vbrgs!

Attachments:

attachment.html (text/html — 51 bytes)

Show replies by date

Maurice James Ny

13 Jul 13 Jul

5:43 p.m.

Once you complete the rpm upgrade you must run the DB upgrade script. _____ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of bradis Sent: Monday, July 09, 2007 8:46 AM To: User questions and discussions about OTRS.org Subject: [otrs] upgrade OTRS 2.1.7 to 2.2.1 So, did anyone already made it ? Vbrgs!

Umberto Nicoletti

14 Jul 14 Jul

7:22 a.m.

On 7/13/07, Maurice James Ny wrote:

...

Once you complete the rpm upgrade you must run the DB upgrade script.

Before removing the old installation remember to dump the configuration from the SysConfig editor. You can then reload it into the new installation to transport almost all customizations over. Umberto

...

So, did anyone already made it ?

Vbrgs! _______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

bradis

3:09 p.m.

sorry. and where is this script located? or it's name? Vbrgs! On 7/13/07, Maurice James Ny wrote:

...

Once you complete the rpm upgrade you must run the DB upgrade script.

------------------------------

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *bradis *Sent:* Monday, July 09, 2007 8:46 AM *To:* User questions and discussions about OTRS.org *Subject:* [otrs] upgrade OTRS 2.1.7 to 2.2.1

So, did anyone already made it ?

Vbrgs!

_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

Maurice James Ny

15 Jul 15 Jul

5:18 p.m.

Opt/otrs/scripts _____ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of bradis Sent: Saturday, July 14, 2007 11:09 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] upgrade OTRS 2.1.7 to 2.2.1 sorry. and where is this script located? or it's name? Vbrgs! On 7/13/07, Maurice James Ny wrote: Once you complete the rpm upgrade you must run the DB upgrade script. _____ From: otrs-bounces@otrs.org [mailto: mailto:otrs-bounces@otrs.org otrs-bounces@otrs.org] On Behalf Of bradis Sent: Monday, July 09, 2007 8:46 AM To: User questions and discussions about OTRS.org Subject: [otrs] upgrade OTRS 2.1.7 to 2.2.1 So, did anyone already made it ? Vbrgs! _______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/ http://www.otrs.com/

Jeff Shepherd

24 Jul 24 Jul

1:33 a.m.

What script is that you're supposed to run in /opt/otrs/scripts? My OTRS installation is on a Fedora 3 system with a MySQL database. Thanks! -Jeff Maurice James Ny wrote:

...

Opt/otrs/scripts

------------------------------------------------------------------------

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *bradis *Sent:* Saturday, July 14, 2007 11:09 AM *To:* User questions and discussions about OTRS.org *Subject:* Re: [otrs] upgrade OTRS 2.1.7 to 2.2.1

sorry. and where is this script located? or it's name? Vbrgs!

On 7/13/07, *Maurice James Ny* mailto:maurice.james@verizon.net> wrote:

Once you complete the rpm upgrade you must run the DB upgrade script.

------------------------------------------------------------------------

*From:* otrs-bounces@otrs.org mailto:otrs-bounces@otrs.org [mailto: otrs-bounces@otrs.org mailto:otrs-bounces@otrs.org] *On Behalf Of *bradis *Sent:* Monday, July 09, 2007 8:46 AM *To:* User questions and discussions about OTRS.org *Subject:* [otrs] upgrade OTRS 2.1.7 to 2.2.1

So, did anyone already made it ?

Vbrgs!

_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/ http://www.otrs.com/

------------------------------------------------------------------------

_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

Nils Breunese (Lemonbit)

7:24 a.m.

Jeff Shepherd wrote:

...

What script is that you're supposed to run in /opt/otrs/scripts?

Read the UPGRADING file. When coming from OTRS 2.1.x you need to use the DBUpdate-to-2.2.mysql.sql script to upgrade the database to the 2.2.x schema. If you're upgrading from 2.0.x, you'll first need to use the DBUpdate-to-2.1.mysql.sql script and then the DBUpdate- to-2.2.mysql.sql script. You can apply an SQL update script like this (as mentioned in the UPGRADING file): # cat /opt/otrs/scripts/DBUpdate-to-2.2.mysql.sql | mysql -p -f - u <db-user> <otrs-db-name> (Or without cat: # mysql -p -f -u <db-user> <otrs-db-name> < /opt/otrs/scripts/ DBUpdate-to-2.2.mysql.sql if that's your thing.) Don't forget to replace <db-user> with an actual database user that has access to your OTRS database (probably otrs, root or admin or something), and <otrs-db-name> with the name of your OTRS database (probably otrs). Nils Breunese.

Jeff Shepherd

3:39 p.m.

Thanks! This is the first time that I've had to upgrade the DB before. All of the other updates just applied after using the RPM. -Jeff Nils Breunese (Lemonbit) wrote:

...

Jeff Shepherd wrote:

...
What script is that you're supposed to run in /opt/otrs/scripts?

Read the UPGRADING file. When coming from OTRS 2.1.x you need to use the DBUpdate-to-2.2.mysql.sql script to upgrade the database to the 2.2.x schema. If you're upgrading from 2.0.x, you'll first need to use the DBUpdate-to-2.1.mysql.sql script and then the DBUpdate-to-2.2.mysql.sql script.

You can apply an SQL update script like this (as mentioned in the UPGRADING file):

# cat /opt/otrs/scripts/DBUpdate-to-2.2.mysql.sql | mysql -p -f -u <db-user> <otrs-db-name>

(Or without cat:

# mysql -p -f -u <db-user> <otrs-db-name> < /opt/otrs/scripts/DBUpdate-to-2.2.mysql.sql

if that's your thing.)

Don't forget to replace <db-user> with an actual database user that has access to your OTRS database (probably otrs, root or admin or something), and <otrs-db-name> with the name of your OTRS database (probably otrs).

Nils Breunese. ------------------------------------------------------------------------

_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

Nils Breunese (Lemonbit)

4:50 p.m.

Jeff Shepherd wrote:

...

Thanks! This is the first time that I've had to upgrade the DB before. All of the other updates just applied after using the RPM.

That was also my experience. You might want to file a bug report at bugs.otrs.org. Nils Breunese.

6569

Age (days ago)

6584

Last active (days ago)

List overview

Download

8 comments

5 participants

participants (5)

bradis
Jeff Shepherd
Maurice James Ny
Nils Breunese (Lemonbit)
Umberto Nicoletti