Upgrading on Windows with ITSM and other modules installed.

[Goofball]

What would be the correct procedure to upgrade from OTRS 3.0.8 to 3.0.9 and keep my ITSM 3.0.4 and FAQ 2.0.5 modules/data functional and intact? I'm not finding anything instructions or notes on upgrade effects on installed modules for even the Linux/FreeBSD version.

I'm in the process of testing the following and wanted to see if anyone else has any input (OTRS is installed on the D: drive on my server):

• 1. Note current version of installed packages such as ITSM/FAQ. Make sure install packages for exact version of modules are avaialable.
  2. Stop all OTRS Services (Apache2.2, MYSQL, CRONw)
  3. Make backup copy of D:\OTRS to D:\OTRS_YYYYMMDD
  4. Restart MYSQL service, open CMD prompt, CD to D:\OTRS\MySQL\bin and run 'mysqldump -u root otrs > D:\OTRS_YYYYMMDD\otrs_MMMMYYDD_bak.sql'
  to back up the DB.
  5. Stop MYSQL service.
  6. Uninstall current version of OTRS Windows installer.
  7. Install updated version of OTRS Windows installer.
  8. Stop Apache2.2 service
  9. Copy Apache httpd.conf from backup copy of OTRS directory from step 2 to D:\OTRS\Apache\conf (fixes IP/Port conflict with IIS)
  10. Start Apache2.2 service
  11. Open web installer (http://servername/otrs/installer.pl) and configure new installation. Make sure DB user/pass matches previous install.
  12. Log in to agent site as root@localhost. Open ADMIN and Package Manager.
  Install same version of packages from prior version install (IE: ITSM 3.0.4/FAQ 2.0.5)
  13. Stop Apache2.2, CRONw services (Note: MYSQL still running)
  14. Open CMD prompt, CD to D:\OTRS\MySQL\bin. Run restore database backup: mysql -u root otrs < D:\OTRS_YYYYMMDD\otrs_MMMMYYDD_bak.sql
  15. Copy OTRS custom settings in config files from backup directory to: OTRS\Kernel\Config.pm, ORTS\Kernel\Config\Files\ZZZAuto.pm,
  OTRS\Scripts\apache2-httpd.include.conf, OTRS\Scripts\apache2-perl-startup.pl
  OTRS\var\cron\postmaster_mailbox.dist, OTRS\bin\otrs.Cron4Win32.pl
  16. Run CMD prompt, run 'perl D:\OTRS\otrs\bin\otrs.Cron4Win32.pl', 'perl D:\OTRS\otrs\bin\otrs.RebuildConfig.pl' and 'perl D:\OTRS\otrs\bin\otrs.DeleteCache.pl'
  17. Start Apache2.2 and CRONw services
  18. "Upgrade" iPhone or Support package if needed.

Edit: Added 2 additional custom files that need copied or settings customized. This appears to be working at the moment. I would still appreciate input as to the "correctness" of my list above.

Thanks!

[MichaelR]

Mine are kind of similar, but I don't follow the web installer.


1. Backup OTRS main folder, download sysconfig
2. Dump Database
3. Uninstall OTRS
4. Install OTRS *do not continue with web installer*
5. Copy over httpd.conf, config.pm, ZZZAuto.pm
7. Create Database manually
8. Import old data
9. Set permission on DB
10. Upgrade DB if necessary
11. Rebuild Config, Delete Cache, Rebuild Indexes etc
12. Restart OTRS
13. Log into OTRS, reinstall all broken Packages.
14. Upload sysconfig
15. Enable Apache::DBI
16. Copy over your Ticket/Change counter's etc.
16. Restart OTRS
17. ???
18. Profit!

[eneless]

I too have a Win install with ITSM.

I would appreciate an "official" line on what the correct upgrade procedure is when using the win installer. There are a number of threads relating to this but I have never seen a definitive answer from the mods or admins on this.
http://forums.otrs.org/viewtopic.php?f= ... 131#p36131

[eneless]

Sorry to bump a thread.

The upgrade process for Windows without add ons is well discussed. I would really appreciate if someone could clarify an upgrade procedure for Windows OTRS with ITSM installed.
Currently running OTRS 3.0.8 & ITSM 3.0.4
Would like to upgrade to OTRS 3.1.1 & ITSM 3.1.1

[trueuser]

Dear All,
I am currently using OTRS: 3.0.5 with default installation and no ITSM. I am grading to 3.2.2. Using Goofball method to upgrade. If I do step 9
step 15: OTRS\Scripts\apache2-httpd.include.conf, OTRS\Scripts\apache2-perl-startup.pl (steps), then I cannot start my apache services.

Can you please advice me something?

If I leave the
httpd.conf, OTRS\Scripts\apache2-httpd.include.conf and OTRS\Scripts\apache2-perl-startup.pl
I can start the apache service and when I try to login to OTRS I get the following error,
"Session invalid. Please log in again. "
can anyone please help, it will be really appreciated.

Thanks