OTRS 3.3.8 upgrade

Moderator: crythias

Locked
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

OTRS 3.3.8 upgrade

Post by otresi »

Hi,

Now it is time to upgrade my otrs 3.3.8 linux appliance, i was reading documentation and i know that i must to upgrade only to version 4, not 5.
Would you recommended witch version otrs 4 can i install?
Did you have and advice for migration to version 4, maybe anybody have any experience?

Thanks a lot.
OTRS 5 /
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

Hi,

Did i can install new otrs 5, and than move database and configuration from version 3.3.8?

thanks for help
OTRS 5 /
root
Administrator
Posts: 4253
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: OTRS 3.3.8 upgrade

Post by root »

You data has to follow the migration path

3.3 => 4 -> 5
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

i saw that otrs 4 appliance exist, is there a way to update my otrs appliance 3.3.8 to appliance 4.0.8?

thanks
OTRS 5 /
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS 3.3.8 upgrade

Post by jojo »

no, and also there is no appliance for OTRS5
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

is there any way to upgrade my 3.3.8 apliance?
OTRS 5 /
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS 3.3.8 upgrade

Post by jojo »

manually is possible, there are several threads here
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

ok thanks, is version 4.0.0 ok ?
OTRS 5 /
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS 3.3.8 upgrade

Post by jojo »

latest OTRS4 version is 4.0.14 and actual version is 5.0.3
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

ok thanks, i read this documentation: http://otrs.github.io/doc/manual/admin/ ... ading.html

In this documentation i didnt read what about my postgreSQL, should i need to stop database before start migration or no, how to backup and restore database?
I dont understand step 5.4.14 Set file permission, what i need to do?
OTRS 5 /
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

hi, i have got this error when check perl modules. When i tried to install that from cli i got this message

Code: Select all

Unable to locate package

Do u have any advice or link for download that modules?

Thanks a lot
You do not have the required permissions to view the files attached to this post.
OTRS 5 /
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

any advice?
OTRS 5 /
Schojo
Znuny expert
Posts: 181
Joined: 03 Jul 2007, 11:53
Znuny Version: 6.0.30
Real Name: Matthias
Location: /opt/otrs/

Re: OTRS 3.3.8 upgrade

Post by Schojo »

otresi wrote:hi, i have got this error when check perl modules. When i tried to install that from cli i got this message

Code: Select all

Unable to locate package
how did you try to install them? try going to the perl shell via

Code: Select all

perl -MCPAN -e shell
and then

Code: Select all

install Archive::Zip
produktiv_vm: OTRS 6.0.30 - ubuntu Server 18.04.5 LTS - mysql-server 5.7.33
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

problem is not solved..
perl_modules.jpg
You do not have the required permissions to view the files attached to this post.
OTRS 5 /
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: OTRS 3.3.8 upgrade

Post by crythias »

pictures of text is not helpful, and not searchable. Hopefully you could scrape from a PuTTY or SSH connection but if not ... ok ...
the short answer is the most obvious error ... you can't connect to the place to download the updates. This is a network, route, dns, or firewall issue. It is not an OTRS problem.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

Hi,

i have not solved my problem with upgrade perl modules..my network is open, firewall open..

when i tried command apt-get update i receive this message:

Code: Select all

Ign http://ftp.otrs.org appliance Release.gpg
Ign http://ftp.otrs.org/pub/otrs/appliance-update/otrs-3.4/ appliance/current Translation-en
Ign http://ftp.otrs.org/pub/otrs/appliance-update/otrs-3.4/ appliance/current Translation-en_US
Ign http://ftp.otrs.org appliance Release
Err http://ftp.otrs.org appliance/current amd64 Packages
  404  Not Found
W: Failed to fetch http://ftp.otrs.org/pub/otrs/appliance-update/otrs-3.4/dists/appliance/current/binary-amd64/Packages.gz  404  Not Found

E: Some index files failed to download, they have been ignored, or old ones used instead.
i also tried single update modules:

Code: Select all

root@otrs:~# apt-get install -y libarchive-zip-perl
Reading package lists... Done
Building dependency tree       
Reading state information... Done
E: Unable to locate package libarchive-zip-perl
root@otrs:~# apt-get install -y libtemplate-perl
Reading package lists... Done
Building dependency tree       
Reading state information... Done
E: Unable to locate package libtemplate-perl
OTRS 5 /
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS 3.3.8 upgrade

Post by jojo »

the Appliance is not maintained any more!
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

ok, thanks what i need to do, how can i move my otrs to new system?

example:
install centos 7 on new server, install otrs version 5, new database and import database, content of /opt/otrs, Config.pm etc..?
OTRS 5 /
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: OTRS 3.3.8 upgrade

Post by reneeb »

Install OTRS 3.3.8 on a new server, copy the database from the appliance, do the upgrade as described in the manual : https://otrs.github.io/doc/manual/admin ... ading.html , https://otrs.github.io/doc/manual/admin ... ading.html
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

How can i move postgresql database from appliance 3.3.8 to appliance 4.0.8?
When i used restore.pl commance a got this error:

Code: Select all

ERROR: Already existing tables in this database. A empty database is required for restore!
What should i do it?

Thanks for help
Last edited by otresi on 22 Mar 2016, 16:20, edited 1 time in total.
OTRS 5 /
otresi
Znuny newbie
Posts: 84
Joined: 02 Sep 2014, 10:49
Znuny Version: OTRS 5.0.8

Re: OTRS 3.3.8 upgrade

Post by otresi »

when i try backup old database with this command
pg_dump -h 127.0.0.1 otrs > otrs_backup.psql and pasword from Config.pm i got this error

Code: Select all

pg_dump: [archiver (db)] connection to database "otrs" failed: FATAL:  Passwort-Authentifizierung f?r Benutzer >>root<< fehlgeschlagen
FATAL:  Passwort-Authentifizierung f?r Benutzer >>root<< fehlgeschlagen
OTRS 5 /
Locked