Migration from OTRS 6 mysql to OTRS 6 portgresql

Moderator: crythias

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

Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath » 03 Jan 2019, 14:57

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
Moderator
Posts: 14492
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by jojo » 03 Jan 2019, 15:01

There is a module which allows the switch to antoher database. Please install via paket manager
"Production": OTRS™ 6, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

Neakath
OTRS newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
OTRS Version?: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath » 03 Jan 2019, 15:06

Thanks,

Do you have the link or name, I don't have direct access to package with my OTRS

jojo
Moderator
Posts: 14492
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by jojo » 03 Jan 2019, 15:10

OTRSCloneDB-6.0.4.opm on ftp.otrs.org
"Production": OTRS™ 6, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

Neakath
OTRS newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
OTRS Version?: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath » 03 Jan 2019, 15:11

Thanks a lot,

I will try it and tell you if it's work !

Neakath
OTRS newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
OTRS Version?: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath » 03 Jan 2019, 16:18

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
Moderator
Posts: 14492
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by jojo » 03 Jan 2019, 16:27

it seems that your databases are not utf-8.
"Production": OTRS™ 6, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

Neakath
OTRS newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
OTRS Version?: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath » 03 Jan 2019, 16:44

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
OTRS newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
OTRS Version?: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath » 04 Jan 2019, 08:50

Hello,

Still having the same errors, does someone have any tips ?

Neakath
OTRS newbie
Posts: 7
Joined: 03 Jan 2019, 14:43
OTRS Version?: 6.0.0
Real Name: Lucas
Company: None

Re: Migration from OTRS 6 mysql to OTRS 6 portgresql

Post by Neakath » 04 Jan 2019, 11:12

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