Hi, <br><br>I too had a similar problem. I inherited our RT System from an earlier administrator whom didn't complete some step correctly earlier in the life of the system. We were going from 3.6.5 to 3.8.0 and all worked fine. Since then to enable some plugins I attempted to update to 3.8.2. <br>
<br>I did use --default-character-set=binary on mysqldump and completed all of the upgrade steps as per UPGRADING.mysql but upon browsing the newly updated RT System to my surprise all the binary attachments had been corrupted as you are mentioning.<br>
<br>To get around this I created a couple of perl scripts.<br>1. Pulls all attachments out of the functioning database (Pre-Upgrade) and dumps them to the filesystem<br>2. Inserts all attachments back into the newly updated schema.<br>
<br>This approach worked for me, I was then able to use 3.8.2 without any trouble at all.<br><blockquote style="margin: 1.5em 0pt;"><p><b>Regards,</b></p>
<p><b>Aaron Guise<br>
<img src="http://www.guise.net.nz/images/signatures/mob.gif" border="0" width="30" height="24">027
212 6638<br>
<img src="http://www.guise.net.nz/images/signatures/email.gif" border="0" width="29" height="26"><a target="_blank" href="mailto:aaron@guise.net.nz">aaron@guise.net.nz</a><br>
</b></p></blockquote><br><br><div class="gmail_quote">On Wed, Jun 3, 2009 at 11:14 AM, Dominic Lepiane <span dir="ltr"><<a href="mailto:Dominic.Lepiane@ptgrey.com">Dominic.Lepiane@ptgrey.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
I'm not too clear what you mean. In creating the test system, I did
backup & restore the db. But I built a 3.6.6 system and then
tested the upgrade from that database. So I stopped Apache and
Postfix, removed the old /opt/rt3 folder, make install to get the new
3.8 files, and then followed the upgrade instructions including the
rt-setup-database and upgrade-mysql-schema.pl scripts.<br>
<br>
At this point, I'm simply trying to get a handful of binary attachments
working with a simple script to spit out the image entirely independent
of RT. So I'm doing this:<br>
<br>
mysqldump --default-character-set=binary --compact -c -t -q -Q -w
"TransactionId < 2500 AND ContentType=\"image/bmp\"" -u root rt3
Attachments > /data/attachments-dump4.sql<br>
<br>
mysql --default-character-set=binary -u root rttest <
attachments-dump4.sql<br>
<br>
As you can sortof see, I'm trying to dump a couple attachments from the
3.6.6 rt3 database which contain image/bmp data and then restoring to
the test database. I have a couple PHP scripts which simply spit out
the ContentType as the Content-type header first and then echo the
Content second. And it looks to me like the data coming out of the
rttest database still is broken. However, I know that if I push new
tickets in to the upgraded RT 3.8.3, those images do come out good the
same as the old data does under 3.6.6.<br>
<br>
I must still be confused or missing something though, what do I do now?<br>
<br>
Thanks,<br><font color="#888888">
- Dominic</font><div><div></div><div class="h5"><br>
<br>
<br>
Ruslan Zakirov wrote:
<blockquote type="cite">
<pre>I believe you used backup&restore of original production DB, didn't
you? In this case you probably mangled data on load. Use
--default-character-set=binary on mysqldump and later on mysql load.
This only required for not upgraded DBs, after proper upgrade you
don't need this option.
On Wed, Jun 3, 2009 at 12:55 AM, Dominic Lepiane
<a href="mailto:Dominic.Lepiane@ptgrey.com" target="_blank"><Dominic.Lepiane@ptgrey.com></a> wrote:
</pre>
<blockquote type="cite">
<pre>Dear RT users,
I am trying to get our RT installation moved from RT 3.6.6 to 3.8.3.
I've tried following the upgrade steps in the UPGRADING.mysql and the
README files as diligently as I can. The DBMS is MySQL 5.0.45. I
updated all the perl modules... When I try the new version, everything
coming in works okay, but all the old binary attachments are broken, in
truth, anything other than regular ascii is mangled (e.g. diacritical
marks like é, ô, ç etc). If I try to open an image, it says "The image
<a href="http://rt/Ticket/Attachment/672/883/spots1.bmp" target="_blank">http://rt/Ticket/Attachment/672/883/spots1.bmp</a>"cannot be displayed,
because it contains errors.".
Clearly I've either missed something or something has to be done to
convert this data. If I convert the Content column back to longtext
from longblob, then the binary data works again.
Please advise what can I do to get the data into the new table schema.
Thanks,
- Dominic
_______________________________________________
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a>
Commercial support: <a href="mailto:sales@bestpractical.com" target="_blank">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
<pre> </pre>
</blockquote>
</div></div></div>
<br>_______________________________________________<br>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
<br>
Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
<br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br></blockquote></div><br>