Hello,
We've just had our first and only report of a binary attachment being
corrupted in RT. I was hoping someone might have an idea why this
might happen. The file in question was a zip archive, size 7MB and
was attached to an incoming email message.
We are at RT 3.4.2, Perl 5.8.4 and Orac
yep, when we merge 3.5-EXPERIMENTAL-MYSQL-UPDATES
(http://svn.bestpractical.com/cgi-bin/index.cgi/bps/browse/rt/branches/)
into 3.6
On 7/28/06, Ted Serreyn <[EMAIL PROTECTED]> wrote:
Ruslan, this solution also resolved the attachment issue here under rt
3.6.0. Is this going to be a permanent ch
Ruslan, this solution also resolved the attachment issue here under rt
3.6.0. Is this going to be a permanent change to the schema?
--
Ted Serreyn Phone: 262-432-0260 Fax: 262-432-0232
Serreyn Network Services, LLChttp://www.serreyn.com/
Hello, Chris.
Could you backu
On Thu, Jul 27, 2006 at 12:49:44AM +0400, Ruslan Zakirov wrote:
> Hello, Chris.
> Could you backup your DB, and run next to SQL queries?
> ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;
>
> Then check if you could binary attachments without problems and report back.
> This query is
Hello, Chris.
Could you backup your DB, and run next to SQL queries?
ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;
Then check if you could binary attachments without problems and report back.
This query is safe but anyway I would suggest you to backup data.
On 7/27/06, Covington
On Thu, Jul 20, 2006 at 01:06:01PM -0400, Jesse Vincent wrote:
>
>
>
> On Thu, Jul 20, 2006 at 12:54:36PM -0400, Covington, Chris wrote:
> > On Wed, Jun 07, 2006 at 10:42:23AM -0400, Covington, Chris wrote:
> > > Has anyone gotten this sorted out? I've upgraded to mysql 5.0.22 and I
> > > still
On Thu, Jul 20, 2006 at 12:54:36PM -0400, Covington, Chris wrote:
> On Wed, Jun 07, 2006 at 10:42:23AM -0400, Covington, Chris wrote:
> > Has anyone gotten this sorted out? I've upgraded to mysql 5.0.22 and I
> > still have this problem, so it must be in the configuration somewhere.
> > I've tr
On Wed, Jun 07, 2006 at 10:42:23AM -0400, Covington, Chris wrote:
> Has anyone gotten this sorted out? I've upgraded to mysql 5.0.22 and I
> still have this problem, so it must be in the configuration somewhere.
> I've tried starting mysql with --character-set-server=binary and
> --default-charact
> Has anyone else experienced corruption of binary attachments when moving
> their RT database from one host to another?
There have been several threads on this subject on the mailing lists.
Search the rt-devel archives for Dec 05 for the subject "mysqldump on
Attachments table (bug #6655)" and th
Has anyone else experienced corruption of binary attachments when moving
their RT database from one host to another?
Long version: I used mysqldump to export the rt3 db from a host running
MySQL Max 4.1.13 to a machine running the RHEL MySQL 4.1.20. The my.cnf
file was the same on both hosts, so
On Thu, Jun 01, 2006 at 12:34:32PM -0400, Jesse Vincent wrote:
>
>
>
> On Thu, Jun 01, 2006 at 11:32:10AM -0500, Ted Serreyn wrote:
> > Interesting
> >
> >
> > mysqldump --all-databases --with-default-charset=binary >dump.test
> > mysqldump: unknown variable 'with-default-charset=binary'
> >
>
Ted Serreyn
Sent: Thursday, June 01, 2006 11:29 AM
To: 'Drew Barnes'
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] binary attachment corruption?
That is how I tested, and no it didn't help.
--
Ted Serreyn Phone: 262-432-0260 Fax: 262-432-0232
-Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Drew Barnes
> Sent: Tuesday, May 30, 2006 3:04 PM
> To: Covington, Chris
> Cc: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] binary attachment corruption?
>
> Jesse
al.com
Subject: Re: [rt-users] binary attachment corruption?
Jesse may have inadvertently touched on this in his response. It looks
like your default character set is utf8, but Jesse suggested doing dumps
with --with-default-charset=binary. Hmmm2+2= ___ maybe? Anyone
tried setting
[mys
AM
To: Ted Serreyn
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] binary attachment corruption?
I suspect existing binary attachments are broken beyond repair. Have
you tried running mysql with binary as the default character set and
sending in a ticket with a new attachment?
I suspect existing binary attachments are broken beyond repair. Have
you tried running mysql with binary as the default character set and
sending in a ticket with a new attachment?
Ted Serreyn wrote:
I wish the fix was that simple, but changing the default charset on mysql,
then restarting
: Re: [rt-users] binary attachment corruption?
Jesse may have inadvertently touched on this in his response. It looks
like your default character set is utf8, but Jesse suggested doing dumps
with --with-default-charset=binary. Hmmm2+2= ___ maybe? Anyone
tried setting
[mysqld]
character-set
Jesse may have inadvertently touched on this in his response. It looks
like your default character set is utf8, but Jesse suggested doing dumps
with --with-default-charset=binary. Hmmm2+2= ___ maybe? Anyone
tried setting
[mysqld]
character-set-server = binary
and reporting back?
But I'
On Mon, May 29, 2006 at 09:30:48AM -0500, Ted Serreyn wrote:
> 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).
I am having the same problem w/4.
, LLChttp://www.serreyn.com/
-Original Message-
From: Mike Patterson [mailto:[EMAIL PROTECTED]
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
On Sat, May 27, 2006 at 09:32:27AM -0500, 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.
Did you dump and reload without specifying
--with-default-charset=binary? Mysql 4.1 changed their def
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/web
22 matches
Mail list logo