[rt-users] File attachments corrupted after DB migration (Was: Mailgate doesnt generate tickets after Upgrade)

[ms at fv-berlin.de]

On 07/05/2014 16:40, Kevin Falcone wrote:
> On Wed, May 07, 2014 at 12:51:07AM +0200, ms at fv-berlin.de wrote:
>> used rt-serializer to dump the database,
>> used rt-importer.
> 
> Yeah - those are the relevant steps you didn't mention.
> You're running into this bug I expect
> http://issues.bestpractical.com/Ticket/Display.html?id=29158
> 
> -kevin

Yes that was the issue indeed and the posted SQL queries fixed it, thanks!


With that out of the way we have found a new issue from the migration
(hence the new subject): the attached files that were migrated are garbled.

With that I mean:

- TXT files are fine, even the charset is correct
- ANY kind of file with binary in it (we tested jpg, pdf, doc, zip)
appears to be corrupted. The plaintext bits of these files are identical
(like a jpg has the plaintext string "JFIF" in its header), but
everything else is completely messed up to the point where even the jpg
header becomes invalid.

I have attached 2 files (~40kb for both): -new from the migrated system
and -old from the old system. The differences in a hex editor are pretty
apparent, everything that's not plaintext is just wrong.


Are there maybe any command line switches to rt-serializer and
rt-importer that I missed?

Thanks for the help!



-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003-new.jpg
Type: image/jpeg
Size: 23548 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140508/e7a99db9/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003-old.jpg
Type: image/jpeg
Size: 15584 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140508/e7a99db9/attachment-0001.jpg>