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/From: Mike Patterson [mailto:mikep@berkeley.edu]
Sent: Monday, May 29, 2006 12:05 AM
To: Ted Serreyn
Cc: rt-users@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/
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@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:
Careers — Best Practical Solutions