Upgrade 3.0.2 to 3.0.6 - Windows Deafult Install

[rjcunningham]

Can anyone post any links to a detailed process to upgrade a Windows install from 3.0.2 to 3.0.6 ?

Sorry if they have already been posted, but I can't find anythign useful. I did find a post that says to do it like the previous versions, and I found a video on a 2.? to a new 2.? but that seemed very confusing and the screen shots did not match up since it was an older version.

Thanks in advance

Randy Cunningham
----------------------------------
OTRS 3.0.2
OS:Windows 2003 w. all default install apps

[ferrosti]

This is not an upgrade, but an update, so you are searching for wrong terms.
1. Make sure you have backed up every change you have made to the system. (cronjobs, config, themes, etc.)
2. Replace 3.0.2 with 3.0.6
3. apply backup from changes to 3.0.6
4. run otrs.SetPermissions.pl
5. restart webserver to recompile new perl scripts when running with mod_perl

There are no changes to your db backend, so there is nothing to worry about.

[eneless]

Hi ferrosti

As I'm in a similar predicament, I am not sure if rjcunningham's post was quite answered in the way he was hoping (although forgive me if his issue is resolved).
You'll have to forgive us Windows users who lack familliarity with Linux!!
I am looking to update from 3.0.5 to 3.0.6. Following that I know I can add the ITSM modules through the package manager within OTRS Admin area.

2. Replace 3.0.2 with 3.0.6

Could you please explain exactly what is to be replaced? The standard Windows installer is a "complete" installer containing Apache, MySQL, Perl & the OTRS files for the initial setup. I cannot see a clear set of "upgrade instructions."
Can this also be done using the package manager?

Any suggestions appreciated!

[ferrosti]

The package manager only takes care of .opm packages. Think of a package like of an add-on.

You are mixing up upgrade (2.4.x to 3.0.x to 3.1.x) and update (3.0.n to 3.0.6). During updates (or call them patchlevel) there are no changes to the db structure. So there is nothing to worry about this part. Your themes will still work after an update. So there is no need to test that.

Have a look at the UPGRADING file in your OTRS home directory. Since you only do an update there is no need for all the database related parts, except from backing it up and restore.

[crythias]

Could you please explain exactly what is to be replaced

Exactly: The source code: http://ftp.otrs.org/pub/otrs/otrs-3.0.6.zip

[eneless]

thanks...

I'll give it a whirl!
fingers crossed

[crythias]

backup the directory before update.

[eneless]

but of course

[schraube]

point 4 needs more explaination...

[quote] 4. run otrs.SetPermissions.pl

when I run the script in perl I got remarks on missing parameters.... like:

Usage: otrs.SetPermissions.pl
[--otrs-user=<OTRS_USER>]
[--web-user=<WEBSERVER_USER>]
[--otrs-group=<OTRS_GROUP>]
[--web-group=<WEB_GROUP>]
[--admin-user=<ADMIN_USER>]
[--admin-group=<ADMIN_GROUP>]
[--admin-group-writable]
[--secure]
[--not-root]
<OTRS_HOME>

any idea about the correct users and groups for windows???

[jojo]

this script is not needed for windows

[eneless]

ok. no success here for an odd reason.
order of events thus far: -

• backup completed
• stopped OTRS services (MySQL, Apache2.2, CRONw)
• extracted zip to replace files (updating from 3.0.5 --> 3.0.6) from http://ftp.otrs.org/pub/otrs/otrs-3.0.6.zip
• started OTRS services (MySQL, Apache2.2, CRONw)
• Apache fails to start (event log error The Apache2.2 service terminated with service-specific error 1 (0x1).)
• stopped OTRS services (MySQL, Apache2.2, CRONw)
• restored from backup
• server rebooted
• OTRS 3.0.5 working as per normal

This is very strange considering (from what I can see) Apache is complely unaffected by this update as it is code based only.
Any ideas?

[schraube]

quote:::::
This is not an upgrade, but an update, so you are searching for wrong terms.
1. Make sure you have backed up every change you have made to the system. (cronjobs, config, themes, etc.)
2. Replace 3.0.2 with 3.0.6
3. apply backup from changes to 3.0.6
4. run otrs.SetPermissions.pl
5. restart webserver to recompile new perl scripts when running with mod_perl

There are no changes to your db backend, so there is nothing to worry about.
quote:

this is the published howto - see second post in this thread...

when I replace files with extracted source files (ZIP) and then start otrs, I get some permission and access errors...
that's why a SetPermission.pl maybe makes sense...

in the past I always uninstalled the "old" otrs and then reinstalled the new one - this works great ! unfortunally this is a little bit time intensive and the copy/paste thing "should" be easier...

[jojo]

this howto is not for windows! please do a backup, deinstallation of otrs, installation of otrs, restoring config files and database..

[schraube]

very confusing....

the thread opener asked:

"Can anyone post any links to a detailed process to upgrade a Windows install from 3.0.2 to 3.0.6 ?"

this is exactly my question. answer was follow the steps in answer2 of this thread (and this includes setpermission)...

anyway - thanks

I will go on with "old fashion" uninstall / reinstall

[ferrosti]

Yes, I have been wrong on that one and have given advise on update on a Linux machine.

In case you have permission errors from Apache, you´ll at least have to make sure that Apache user is able to r/w these files.
BEFORE you do this you will have to copy back your config files or make sure these were not changed during update.

[eneless]

this howto is not for windows! please do a backup, deinstallation of otrs, installation of otrs, restoring config files and database..

Seriously? that will also remove apache, cronw, mysql & perl. quite a painful process if all that is actually happening is the application files get updated.

[eneless]

are files to be backed up stil the same in version 3?
Kernel/Config.pm and Kernel/Config/Files/ZZZAuto.pm
http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=351

6.) Upgrade database structure

Is this step needed?

[ferrosti]

Since this is an update and no upgrade there is no change to your DB backend.
You´d most probably have to apply changes to your OTRS system wehn upgrading to 3.1

[arayson]

Necesito, por favor si alguien me puede indicar como puedo actualizar de version 2.4.5 a 3.0.6 en Windows de 64 bits.
Y que cambios debo hacerle a las tablas del MySQL.
Gracias.

[MichaelR]

Necesito, por favor si alguien me puede indicar como puedo actualizar de version 2.4.5 a 3.0.6 en Windows de 64 bits.
Y que cambios debo hacerle a las tablas del MySQL.
Gracias.

Google Translate:

Need, please if anyone can tell me how I can upgrade from version 2.4.5 to 3.0.6 on Windows 64 bits.
And should I change the MySQL tables.
Thanks.

Create your own thread about the issue please.
(Doesn't matter if its 32 or 64bit)

Cheers,
Michael

[eneless]

OK

Sucessfully updated from 3.0.5 > 3.0.7 using default installer.
My server OS: - Win 2003 R2 x64. dedicated for OTRS only.
My existing OTRS install path (using default windows installer) - D:\APPS\OTRS
Perhaps you could use my instructions I noted down and update the FAQ here for v3 users?

• Stop the OTRS services (start > programs > otrs > tools > otrs services stop)

• Using NTbackup create a full backup of D:\APPS\OTRS (where D:\APPS\OTRS is the path you previously installed from)

• Uninstall OTRS from "add/remove programs" in control panel.

• Install 3.0.7 using otrs-3.0.7-win-installer-2.4.3.exe and accept the defaults (do not run the web installer once finished)

• Stop the OTRS services (start > programs > otrs > tools > otrs services stop)

• using NTbackup restore the following files/directories from your backup archive: -

• • --- D:\Apps\OTRS\Apache\conf (this allows for any changes made to your previous Apache config - not needed if you didn't change from the defaults originally)

• • --- D:\Apps\OTRS\mysql

• • --- D:\Apps\OTRS\OTRS\Kernel\Config.pm

• • --- D:\Apps\OTRS\OTRS\Kernel\Config\Files\ZZZAuto.pm

• Start the OTRS services (start > programs > otrs > tools > otrs services start)

Hope this helps.

[manlanbmo]

HI!

The "HowTo" from eneless works fine. One thing I would add:

Also you have to setup up the ticketcounter.log in "Path you Installed OTRS"\OTRS\OTRS\var\log


and i modifed the crontab.txt in "Path you Installed OTRS"\OTRS\CRONw. This ist not so importent. Here i modified the time to get the supportmails from a pop3 account

Greets

manlan

[guillo]

I have a question: How did you backup and restore your DB ??

[eneless]

Hi Guillo

We haven't done an upgrade that recently but, to the point where my organisation had upgraded, the posts & documentation that I'd read so far advised that the database wasn't upgraded going from 3.x.x to 3.x.x, only the code.
As a result, whilst the code gets upgraded using the latest Win installer I restored the %OTRS_INSTALL_PATH%\Mysql folder to put the DB back as it was.

Hope that helps!

[jojo]

Database Upgrades are only needed on Upgrades to a minor version (3.0.x to 3.1.x or to a major version 2.4.x -> 3.0.x)

Please note that you should always upgrade to the latest version in your minor version

[eneless]

jojo

Please could you clarify exactly where database upgrades are needed - my understanding was that the DB is only upgraded on a major release?

Are you saying that and upgrade takes place on major & minor releases
2.4.x --> 3.x.x
3.0.x --> 3.1.x

But not to point releases?
3.1.x --> 3.1.x

Where a major release takes place, is there a recommended upgrade procedure? Wouldn't restoring my mysql backup archive will overwrite the upgrade as would inserting the sql using phpmyadmin?

[jojo]

please always read the UPGRADING file

[guillo]

please always read the UPGRADING file

Too bad that file is intended for LINUX. And I've read in several places, that the upgrade precess is very different from one OS to the other.

The fact is that there is no UP TO DATE procedure to upgrade OTRS on Windows, there is not a reliable document or source on how to do it (At least I havent found it). I've posted that question on this forum several times and the answers that I get are on the line of: Read X document (the one that is for linux), or try this website (a website that says that there is NO DOCUMENTATION or upgrader for Windows). I call it windows racism hahaha
(sorry it's been a rough week.... and I still can't upgrade the OTRS thing without getting errors!!!! )

Anyway... after my rant.

So I have a simple question and I'm very confused for all the things that I've read around the web.

I have OTRS 3.0.6 and I want to upgrade it to the latest version 3.1.7 the question is

Do I have to go trough 3.0.7, 3.0.8, 3.0.X, 3.1.0, 3.1.1, 3.1.2, 3.1.X, ... , 3.1.7 ??????

Or just go for 3.0.6 to 3.1.7 ?

And is there a simple step by step to do this on windows?? NOT LINUX.