[SOLVED] Restore not completely working

Moderator: crythias

Post Reply
JHS
Znuny newbie
Posts: 25
Joined: 13 Oct 2016, 11:22
Znuny Version: 6 PL 4

[SOLVED] Restore not completely working

Post by JHS »

Hello guys

I have a question regarding a restore.
We are currently using OTRS 5.0.13 in production and we would like to setup another server (same OS, same OTRS version) with a copy of the production database.
We are using the provided backup.pl and restore.pl scripts in the /opt/otrs/scripts/ directory.

We basically did the following:
[*]Installed CentOS 7, mysql, OTRS 5.0.13
[*]Installed OTRS and finished connection to DB using the webinstaller (installer.pl) (so we have a clean OTRS system) This all works
[*]Created a backup of the production system using /opt/otrs/scripts/backup.pl
[*]Placed the backup of the production system on the test system and executed the following command to restore:

Code: Select all

/opt/otrs/scripts/restore.pl -b /root/otrs_backup/20171121_2300 -d /opt/otrs/
The restore.pl script finishes without any errors.

When I try to login using the agent portal using Chrome, I'm greeted with the message "Session invalid. Please log in again."
I can login through internet explorer, but once I log in to my user (or any other user for that matter). I don't see any tickets on the dashboard.
I don't see the admin button anymore on the top.
When I try to create a ticket, I can find customers, but not queues.
I checked the database for the tickets and queues and can find them, like they are on the production server
I've tried this with 2 admin users, and they both show the same issues.

Any ideas?
You do not have the required permissions to view the files attached to this post.
Last edited by JHS on 22 Nov 2017, 17:39, edited 1 time in total.
OTRS 6.0.5
root
Administrator
Posts: 3961
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Restore not completely working

Post by root »

Hi,

What's teh content of the folder /root/otrs_backup/20171121_2300?

- Roy
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 ?
JHS
Znuny newbie
Posts: 25
Joined: 13 Oct 2016, 11:22
Znuny Version: 6 PL 4

Re: Restore not completely working

Post by JHS »

root wrote:Hi,

What's teh content of the folder /root/otrs_backup/20171121_2300?

- Roy
The following 3 files:
application.tar.gz
config.tar.gz
databasebackup.sql.gz

so basically the output of the backup.pl script on the production server
You do not have the required permissions to view the files attached to this post.
OTRS 6.0.5
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Restore not completely working

Post by jojo »

did you delete the caches
"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
JHS
Znuny newbie
Posts: 25
Joined: 13 Oct 2016, 11:22
Znuny Version: 6 PL 4

Re: Restore not completely working

Post by JHS »

jojo wrote:did you delete the caches
I did not... I knew it was something small... This fixed it.

I still can't log on using chrome though, but I probably have to remove the chrome cache and cookies for that.

I executed following commands:

Code: Select all

su otrs
perl /opt/otrs/bin/otrs.Console.pl Maint::Cache::Delete
OTRS 6.0.5
Post Reply