Migration from OTRS 6 mysql to OTRS 6 portgresql

Moderator: crythias

Post Reply
Neakath
Znuny newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
Znuny Version: 6.0.0
Real Name: Lucas
Company: None

Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath »

Hello,

First, I'm sorry for my bad english.

I have a project for the school where I need to change my OTRS 6 with a mysql database to an OTRS 6 with a postgresql data.

I tried to use many script or application like "pgloader" but I get many error when i'm trying to see the content on my pgsql OTRS.

Does anyone have some tips to help me or have already done it ?

Thanks a lot.

Neakath
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by jojo »

There is a module which allows the switch to antoher database. Please install via paket manager
"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
Neakath
Znuny newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
Znuny Version: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath »

Thanks,

Do you have the link or name, I don't have direct access to package with my OTRS
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by jojo »

OTRSCloneDB-6.0.4.opm on ftp.otrs.org
"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
Neakath
Znuny newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
Znuny Version: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath »

Thanks a lot,

I will try it and tell you if it's work !
Neakath
Znuny newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
Znuny Version: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath »

Doesn't work, I execute the migration but i get a lot of those errors :

[Thu Jan 3 14:52:25 2019] otrs.Console.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x74, immediately after start byte 0xf8) in print at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 322.
[Thu Jan 3 14:52:25 2019] otrs.Console.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x37, immediately after start byte 0xf7) in print at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 322.
[Thu Jan 3 14:52:25 2019] otrs.Console.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x3d, immediately after start byte 0xfa) in print at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 322.
[Thu Jan 3 14:52:25 2019] otrs.Console.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x68, immediately after start byte 0xfb) in print at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 322.
[Thu Jan 3 14:52:25 2019] otrs.Console.pl: Malformed UTF-8 character (unexpected non-continuation byte 0xf7, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 322.


After the migration I have some informations on my new postgresql OTRS like clients groups user etc

But I don't have access to the ticket section or FAQ and Dashboard
Capture.PNG

I also have 258 invalid settings deployed any tips to remove them ?
You do not have the required permissions to view the files attached to this post.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by jojo »

it seems that your databases are not utf-8.
"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
Neakath
Znuny newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
Znuny Version: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath »

Hum weird,

Seems like the MYSQL one is in UTF-8
otrs.PNG
And the Postgresql to :
pgutf82.PNG
You do not have the required permissions to view the files attached to this post.
Neakath
Znuny newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
Znuny Version: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath »

Hello,

Still having the same errors, does someone have any tips ?
Neakath
Znuny newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
Znuny Version: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath »

Ok, I find the part of my database that wasn't in UTF8 (An attachment of an FAQ)

But I still can't access to my dashboard, FAQ or ticket after the migration
Post Reply