Size limitation on attachments?

RT Users
1

Is the 1-meg size limitation on attachments a configurable limit? Anyone
know how to bump that up?

Adam

Irony has only emergency use. Carried over time, it is the
voice of the trapped who have come to enjoy their cage. -Lewis Hyde
adam@baz.org Adam Hirsch http://web.baz.org/~adam/

2

Search the recent archives, this question was answered within the last
week. There’s MySQL setting that has to be changes.

Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
kfh@mqsoftware.com

-----Original Message-----
From: Adam Hirsch [mailto:adam@baz.org]
Sent: Wednesday, February 25, 2004 2:18 PM
To: RT users
Subject: [rt-users] size limitation on attachments?

Is the 1-meg size limitation on attachments a configurable limit?
Anyone
know how to bump that up?

Adam

–
Irony has only emergency use. Carried over time, it is the
voice of the trapped who have come to enjoy their cage. -Lewis Hyde
adam@baz.org Adam Hirsch
http://web.baz.org/~adam/

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

3

It didn’t work for me. The question was answered with

increase “max_allowed_packet” in my.cnf for mysql 4

however this did nothing for my circumstance which involved attempting
to migrate RT2 to RT3 including attachments up to 1.1MB in size.
Eventually I just gave up.

the consensus was it was an issue BKAC (Between Keyboard And Chair)
but I could find no such problem. And then the issue died.

So if anybody actually knows how to solve this it would be appreciated.

Search the recent archives, this question was answered within the last
week. There’s MySQL setting that has to be changes.

–
Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
kfh@mqsoftware.com

-----Original Message-----
From: Adam Hirsch [mailto:adam@baz.org]
Sent: Wednesday, February 25, 2004 2:18 PM
To: RT users
Subject: [rt-users] size limitation on attachments?

Is the 1-meg size limitation on attachments a configurable limit?
Anyone
know how to bump that up?

Adam

–
Irony has only emergency use. Carried over time, it is the
voice of the trapped who have come to enjoy their cage. -Lewis Hyde
adam@baz.org Adam Hirsch
http://web.baz.org/~adam/

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

4

Hmm. Well, there might be other issues involved with migrating that I
don’t know about, but you must have this set properly in my.cnf, or
you’re dead from the git-go. This has been true at least as far back as
mysql 3.2 (something), as I had to set this when I first installed
bugzilla, 3 years ago.

So, if you’ve a new rt3 install, this is probably good enough. If
you’re migrating from RT2, there might be something else needed in
addition.

Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
kfh@mqsoftware.com

-----Original Message-----
From: David M Dennis [mailto:dmd@speakeasy.org]
Sent: Wednesday, February 25, 2004 2:31 PM
To: Kelly F. Hickel
Cc: Adam Hirsch; RT users
Subject: RE: [rt-users] size limitation on attachments?

It didn’t work for me. The question was answered with

increase “max_allowed_packet” in my.cnf for mysql 4

however this did nothing for my circumstance which involved attempting
to migrate RT2 to RT3 including attachments up to 1.1MB in size.
Eventually I just gave up.

the consensus was it was an issue BKAC (Between Keyboard And Chair)
but I could find no such problem. And then the issue died.

So if anybody actually knows how to solve this it would be
appreciated.

±------------------------

Search the recent archives, this question was answered within the
last
week. There’s MySQL setting that has to be changes.

–
Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
kfh@mqsoftware.com

-----Original Message-----
From: Adam Hirsch [mailto:adam@baz.org]
Sent: Wednesday, February 25, 2004 2:18 PM
To: RT users
Subject: [rt-users] size limitation on attachments?

Is the 1-meg size limitation on attachments a configurable limit?
Anyone
know how to bump that up?

Adam

–
Irony has only emergency use. Carried over time, it is the
voice of the trapped who have come to enjoy their cage. -Lewis
Hyde
adam@baz.org Adam Hirsch
http://web.baz.org/~adam/

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

5

setting

max_allowed_packet = 5M

in /etc/my.cnf and restarting the db did the trick. Thanks, folks.

Adam

The fairest thing we can experience is the mysterious. It is the fundamental
emotion which stands at the cradle of true art and true science. – Einstein
adam@baz.org http://web.baz.org/~adam/

6

David M Dennis dmd@speakeasy.org writes:

It didn’t work for me. The question was answered with
increase “max_allowed_packet” in my.cnf for mysql 4
however this did nothing for my circumstance which involved attempting
to migrate RT2 to RT3 including attachments up to 1.1MB in size.
Eventually I just gave up.

Did you check that your setting actually took effect, e.g. by doing a
‘mysqladmin variables | grep max_allowed_packet’?

Espen Wiborg espenhw@empolis.no
There are more chickens than people in the world.