Migrate OTRS 6.0 to another server

[solown]

Hi OTRS users,

I'm migrating OTRS 6.0.16 from an old system to a new system by using backup.pl and restore.pl scripts.

I use Apache 2.4.39 and PostgresSQL 11 on my new system and Apache 2.4.27 and PostgresSQL 9.6 on the old system.

I had no problem to reinstall OTRS on my new system. I was able to access to index page and use installer.pl

I changed users and db name on the new installation. I have problem with restore.pl script because he is copying old Config.pm and trying to alter database with the old database configuration, nevertheless I got ALTER TABLE output during the execution of the script.

After a quick check on my database, no changes have been made by the script, I can't find old data.

Is there a way to specify the database credentials during the execution of the script, or preserve the current Config.pm file ?

Kind regards,
Solown

[wurzel]

Hi,

if you follow the update docs you will succeed.
https://doc.otrs.com/doc/manual/install ... ating.html

the restore.pl is possible, but only if credentials are the same. So you have do to the transfer manually as described in the docs.

regards
Florian

[solown]

Hi,

Thanks for your answer, I give it a try but I'm stuck again.

Here is the error of the script DB-Update-to-6.pl as follow in the update doc :

Code: Select all

Error: Connection was successful, but database content is missing.

Error: Not possible to perform DB connection!

Nothing to specified where are my backup store.

regards

[wurzel]

Hi,

show all the steps you performed. Maybe we can assist then

Flo

[skullz]

[OLD SERVER]

otrs fullbackup


[NEW SERVER]

1. Install new otrs completely. Make sure this can connect to db, login, create ticket, etc..
2. If new otrs db also created, drop the new otrs db.
3. Backup Config.pm to somewhere
3. use otrs Restore script
4. Restore back Config.pm
5. use otrs set permission script

**you may want to also check /var/lib/pgsql/data/pg_hba.conf