Migration from OTRS 6 mysql to OTRS 6 portgresql
Moderator: crythias
-
- 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
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
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
Re: Migration from OTRS 6 mysql to OTRS 6 portgresql
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
Thanks,
Do you have the link or name, I don't have direct access to package with my OTRS
Do you have the link or name, I don't have direct access to package with my OTRS
Re: Migration from OTRS 6 mysql to OTRS 6 portgresql
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
Thanks a lot,
I will try it and tell you if it's work !
I will try it and tell you if it's work !
-
- 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
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
I also have 258 invalid settings deployed any tips to remove them ?
[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
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.
Re: Migration from OTRS 6 mysql to OTRS 6 portgresql
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
Hum weird,
Seems like the MYSQL one is in UTF-8
And the Postgresql to :
Seems like the MYSQL one is in UTF-8
And the Postgresql to :
You do not have the required permissions to view the files attached to this post.
-
- 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
Hello,
Still having the same errors, does someone have any tips ?
Still having the same errors, does someone have any tips ?
-
- 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
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
But I still can't access to my dashboard, FAQ or ticket after the migration