Help me please for upgrade version

[AceBlack]

Hello everyone, I have a new customer that using otrs on a virtual machine freebsd.
Now..., They want to upgrade to the latest version, but I need advice. There is currently installed OTRS 2.4.9 with module ITSM 1.3.2. O_o
I've read that I have to upgrade all versions in between, but I was wondering if someone has already tried to do it or is madness ...
In any case, does anyone have any suggestions or any link to all different steps to follow in order to not destroy the database?
This is the summary screen of my otrs system:

Database
Check Commento Stato
Check DateStyle. ISO, MDY OK
Check existing framework tables. 69 tables checked. OK
Check the utf8 client connection. UTF8 OK
Check the utf8 server connection. UTF8 OK
Check database version. 9.3.4 OK


OS
Check Commento Stato
Check disk usage. Disk usage (). OK
Shows the used distribution. freebsd is used. OK
Shows the used Kernel version. "FreeBSD xx.com 8.3-RELEASE-p3 OK
Check Perl Version. Perl 5.10.1 (freebsd) is used. OK


OTRS
Check Commento Stato
Check if Ticket::.... No $Data{""} found. OK
Check default SOAP credentials. You have not enabled SOAP or have set your own pwd. OK
Check if root@localhost account has the default pwd. There is no active root@localhost with default pwd. OK
Check if the configured FQDN is valid. FQDN 'xx.com' looks good. OK
Check if file system is writable. The file system is writable. OK
Search for invalid user with locked tickets. There are no invalid users with locked tickets. OK
Check log for error log entries. You have more error log entries: (LIST ERRORS) Failed
Check open tickets in your system. You have 187 open tickets in your system. OK
Check deployment of all packages. All packages are correctly installed. OK
Check if the configured SystemID contains only digits. Your SystemID setting is 121. OK
Check Ticket::SearchIndexModule setting. 91806 articles in your system. You should use the StaticDB backend for OTRS 2.3 and higher. Critical
Check Ticket::IndexModule setting. You are using "Kernel::System::Ticket::IndexAccelerator::RuntimeDB", that's fine for 26884 tickets in your system. OK
Check orphaned StaticDB records. No orphaned records found. OK


Webserver
Check Commento Stato
Display web server version. You are running Apache/2.2.22 (FreeBSD) mod_fcgid/2.3.6 mod_ssl/2.2.22 OpenSSL/0.9.8y DAV/2. OK
Check for CGI Accelerator. You should use FastCGI or mod_perl to increase your performance. Critical

[wurzel]

Hi,

Hello everyone, I have a new customer that using otrs on a virtual machine freebsd.
Now..., They want to upgrade to the latest version, but I need advice.

You support customers, get money and ask here in a open source non-commercial forum? Nice.

There is currently installed OTRS 2.4.9 with module ITSM 1.3.2. O_o
I've read that I have to upgrade all versions in between, but I was wondering if someone has already tried to do it or is madness ...
In any case, does anyone have any suggestions or any link to all different steps to follow in order to not destroy the database?

Just do an upgrade. Where's your problem?

Flo

[AceBlack]

You support customers, get money and ask here in a open source non-commercial forum? Nice.

?!? Yes i'm their new network administrator... and they ask me for this upgrade... where is your problem if they have up to now an open source license?

Just do an upgrade. Where's your problem?

my problem is... that I never updated software from such an old version to the latest stable. That's it. If you want to help me, you're welcome, if not will wait others.

Thanks for your time

Bye

[jojo]

read the UPGRADING isntructions.

You have to go

2.4.x -> 3.0.latest -> 3.1.latest -> 3.2.latest -> 3.3.latest

So please always follow the UPGRADING document of the version you are upgrading to

[AceBlack]

read the UPGRADING isntructions.

You have to go

2.4.x -> 3.0.latest -> 3.1.latest -> 3.2.latest -> 3.3.latest

So please always follow the UPGRADING document of the version you are upgrading to

Thanks Jojo, the upgrading document is "otrs_admin_book_3.x.pdf" correct?

[jojo]

it is the UPGRADING file in the OTRS directory of each version:

https://github.com/OTRS/otrs/blob/rel-3_0/UPGRADING
https://github.com/OTRS/otrs/blob/rel-3_1/UPGRADING
https://github.com/OTRS/otrs/blob/rel-3_2/UPGRADING.md
https://github.com/OTRS/otrs/blob/rel-3_3/UPGRADING.md

[AceBlack]

Thanks for the reply jojo, I'm following guide shown me, but when I run the command (Point :

cat scripts/DBUpdate-to-3.0.postgresql.sql | psql otrs

gives me an error message: "psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? "

rightly I might add, since the database is on another machine.... but how do I tell script that the db is not local?

Thanks in advance...

[wurzel]

Hi,

you restored your Config Files?
What is configured in your Config.pm ?

Flo

[crythias]

Thanks for the reply jojo, I'm following guide shown me, but when I run the command (Point 8):

cat scripts/DBUpdate-to-3.0.postgresql.sql | psql otrs

gives me an error message: "psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? "

rightly I might add, since the database is on another machine.... but how do I tell script that the db is not local?

Thanks in advance...

man psql

[AceBlack]

Hi,
you restored your Config Files?
Flo

Yes, Thanks for answer

man psql

Thanks crythias... finally it works: psql with options -U "user" -h "IPAddress of remote host" -d "dbname"