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:[EMAIL PROTECTED] Sent: Monday, May 29, 2006 12:05 AM To: Ted Serreyn Cc: [email protected] 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: [EMAIL PROTECTED] > > > 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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] 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
