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

ms at fv-berlin.de ms at fv-berlin.de
Thu May 8 09:08:29 EDT 2014

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>

More information about the rt-users mailing list