Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Never Min
Hi, please see this link: https://doc.otrs.com/doc/manual/admin/5.0/en/html/installation-on-windows.html -Never Edson Richter 于2019年2月20日周三 上午6:13写道: > Our company uses PostgreSQL as standard database for everything (that > needs one 😉 ). > > So, our OTRS 5 system is the last one based on My

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Edson Richter
That's right what I need. But for some reason, during dry-run, while checking "article_attachment" I got "died" and process ends... Do I need to increase process memory, change batch sizes, perhaps optimize the script somehow? I'm using OEL7 with unbreakable kernel with all updates. Perl inter

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Edson Richter
For sanity, I'm moving attachments to file system... Enviado do meu Telefone LG -- Mensagem original-- De: Edson Richter Data: qua, 20 de fev de 2019 14:43 Para: Never Min;User questions and discussions about OTRS.; Cc: Assunto:Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL That's

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Edson Richter
Because people find nice to have a logo in your email signature, I have some tickets with more than 300 attachments... Most of them are repeated logos in mail signature... That's odd. Enviado do meu Telefone LG -- Mensagem original-- De: Edson Richter Data: qua, 20 de fev de 2019 15:20

[otrs] RES: OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Edson Richter
Thank you very much. It is wonderful how easy this script made my day. The only think I’ll point is that documentation is far behind the PDF that you have access through the web interface. Also, would be nice to add a suggestion for large installations to put all attachments on filesystem first –

[otrs] OTRS 5 - after CloneDB, all FAQ are without images (attachments?)

2019-02-20 Thread Edson Richter
1. I’ve moved all attachments to FS using the script. 2. Run the CloneDB to move from MySQL to PostgreSQL. 3. After, moved all files from FS from one server to the new server When I look to tickets, images and attachments are normal. When I look FAQ entries, no images are shown. Any tip?