Updating OTRS Help Desk 3.2.8

[virtualhost]

Hello Team,

Hi, i am a newbie in OTRS. I need to upgrade OTRS to 3.2.8. The current version we have is 3.2.6. Please note that i am working on windows 8 machine.
I have tried the forums but without any luck. Do we uninstall or reinstall? Does it Involve Backup and restoration? The document and the search parameters have not helped me. It would be great if you could give me step-by-step instructions, Word Document or a PDF to install 3.2.8.

Regards,
Virtual Host

[guillo]

this might help you. It's for 3.0 to 3.1 but it might serve you as a guideline.

https://tecnobalam.wordpress.com/

[virtualhost]

Guillo Thanks for the guide. Let me try and keep you updated

[virtualhost]

I get the error message while performing the perl update

C:\Program Files (x86)\OTRS\OTRS\scripts>perl DBUpdate-to-3.2.pl

Migration started...

DBI connect('database=otrs;host=localhost;','otrsadmin',...) failed: Access deni
ed for user 'otrsadmin'@'localhost' (using password: YES) at C:/Program Files (x
86)/OTRS/OTRS/Kernel/System/DB.pm line 253

>> Can't write C:/PROGRA~2/OTRS/OTRS/var/log/otrs.log: Permission denied <<

ERROR: OTRS-DBUpdate-to-3.2-99 Perl: 5.12.3 OS: MSWin32 Time: Mon Jul 1 19:33:5
1 2013

Message: Access denied for user 'otrsadmin'@'localhost' (using password: YES)

Traceback (676):
Module: Kernel::System::DB::new (OTRS 3.2. Line: 224
Module: main::_CommonObjectsBase (unknown version) Line: 143
Module: DBUpdate-to-3.2.pl (unknown version) Line: 68

Got no DBObject! at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/SysConfig.pm
line 101.
Step 1 of 10: Refresh configuration cache...
C:\Program Files (x86)\OTRS\OTRS\scripts>

[KlausNehrer]

Your otrsadmin from your MySQL DB has a password?

[virtualhost]

Hi,

Yes Klaus Nehrer we do have a password for OTRS DB.

I have tried the solution from Bogdan Iosif on the forum to run (C:\Program Files (x86)\OTRS\OTRS\scripts>mysql -uroot otrs < "C:\Program
Files (x86)\OTRS\OTRS\scripts\DBUpdate-to-3.2.mysql.sql") and I have received another error message.

Please note that if I run C:\Program Files (x86)\OTRS\OTRS\scripts> it doesn’t open the sql window.

Example if I run C:\Program Files (x86)\OTRS\OTRS\scripts>mysql –uroot otrs. It prompts with a n error message that it cannot find the MYSQL file.

However, if I run C:\Program Files (x86)\OTRS\mysql\bin>mysql -uroot otrs it opens the MYSQL Window.

I have tried the command and below is the error message.

C:\Program Files (x86)\OTRS\mysql\bin>mysql -uroot otrs < "C:\Program Files (x86)\OTRS\OTRS\scripts\DBUpdate-to-3.2.mysql.sql".ERROR 1091 (42000) at line 7: Can't DROP 'group_read'; check that column/key exists

I have ran the perl update and it gave me the following error message

C:\Program Files (x86)\OTRS\mysql\bin>perl DBUpdate-to-3.2.pl Can't open perl script "DBUpdate-to-3.2.pl": No such file or directory

Please note that both the command have been executed using C:\Program Files (x86)\OTRS\mysql\bin> and not C:\Program Files (x86)\OTRS\OTRS\scripts>

Regards,
Virtual Host

[virtualhost]

Hi Guys,

OTRS 3.2.8 is re-installed successfully and works like a charm. A good exercise and nice way to learn OTRS.

Regards,
Virtual Host

[virtualhost]

Hi Guys,

OTRS 3.2.8 is re-installed successfully and works like a charm. A good exercise and nice way to learn OTRS.

Performed a backup of the DB. Uninstalled 3.2.6 and re-installed 3.2.8 . Reinstalled 3.2.6 ITSM Bundle. Restored the Database.

Replaced needed config files (Config.pm/ZZZAuto.pm/GenricAgent.pm/TicketCounter.log and the var/articles) and run LoaderCache.pl -o delete and RebuildConfig.pl afterwards.

Works like a charm!!!