[rt-users] binary attachment corruption?

[Ted Serreyn]

In my case it is an existing rt installation, that has started to experience
this problem I believe since the mysql upgrade.  New attachments sent in are
always corrupted (ok only the binary ones).

Ted


-- 
Ted Serreyn               Phone: 262-432-0260  Fax: 262-432-0232
Serreyn Network Services, LLC            http://www.serreyn.com/

-----Original Message-----
From: Mike Patterson [mailto:mikep at berkeley.edu] 
Sent: Monday, May 29, 2006 12:05 AM
To: Ted Serreyn
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] binary attachment corruption?

Ted,

I had a binary attachment problem when I attempted to restore a backed 
up mysql rt database. 
I wasn't backing up in a way that kept the binary attachments intact.

See subject "binary attachments corrupt in migration to new box" 
5/11/2006 in the archive
----------------------------------------------------------------------------
I had to add this flag "--default-character-set=binary" to my dump 
command before I could get a good migration to another server.
 
mysqldump --opt --add-drop-table --single-transaction --user=root 
--password=my_pass_was_here rt3 | gzip > /usr/backup/rt3_db_last2.sql.gz
----------------------------------------------------------------------------

Is this part of the problem you're experiencing? 
When I was having this issue, new attachments weren't corrupt, just the 
migrated ones. 

Fortunately I caught it in test migrations....

Good luck,
Mike

Ted Serreyn wrote:
>
> Seeing corruptions for any and all binary attachments.  rt-3.4.5, 
> mysql 4.1.19.  I am suspecting that this is a mysql problem.
>
>  
>
>  
>
>  
>
> In apache2.conf
>
> AddDefaultCharset UTF-8
>
> PerlModule Apache::DBI
>
> #PerlFreshRestart On
>
> #PerlRequire /home/httpd/html/support.serreyn.com/rt-3.4.3/bin/webmux.pl
>
> PerlRequire /home/httpd/html/support.serreyn.com/rt-3.4.5/bin/webmux.pl
>
> AddDefaultCharset UTF-8
>
>  
>
> In my.cnf
>
> [mysql]
>
> character-sets-dir=/usr/share/mysql/charsets
>
> default-character-set=utf8
>
>  
>
> [mysqld]
>
> character-set-server            = utf8
>
> default-character-set           = utf8
>
>  
>
> # mysqladmin version
>
> mysqladmin  Ver 8.41 Distrib 4.1.19, for pc-linux-gnu on i686
>
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
>
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>
> and you are welcome to modify and redistribute it under the GPL license
>
>  
>
> Server version          4.1.19
>
> Protocol version        10
>
> Connection              Localhost via UNIX socket
>
> UNIX socket             /var/run/mysqld/mysqld.sock
>
> Uptime:                 8 days 16 hours 30 min 29 sec
>
>  
>
> Threads: 2  Questions: 77797  Slow queries: 0  Opens: 223  Flush 
> tables: 1  Open tables: 64  Queries per second avg: 0.104**
>
> * *
>
> * *
>
> -- 
> Ted Serreyn               Phone: 262-432-0260  Fax: 262-432-0232
> Serreyn Network Services, LLC            http://www.serreyn.com/
>
>  
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>
> We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html