Attachment issue on RT 3.6.3

RT Users
1

Hi!

We’ve freshly set up RT on a Gentoo box and most of it runs very well by
now. Most tickets will be opened through incoming emails.

This is my current issue: Only text attachments are saved to the database.
All other (tested with JPG) file types that are sent in via mail (inline
or as attachment) or attached on the web GUI don’t work.

The result is, that the filename is shown in the ticket, but it is not
linked. The DB row contains the filename, content Type but no content.

The max size for attachments in the RT_SiteConfig is set to >10MB, and
also MySQL’s “max_packet_size” is set to a big value. The images I tried
to attach were <300K, so that shouldn’t be a problem I think.

Any help on this issue is very appreciated!

Cheers,
Mario

2

Any help on this issue is very appreciated!

Cheers,
Mario

Hi Mario,

Had the same problem earlier, but had radio silence on the thread [0].
If you find a resolution to this please post your findings. Still
looking myself.

Can you let me know if you’re getting the same errors as I did. It’s at
the very bottom of the e-mail.

Thanks,

~ stevo

[0] - [rt-users] Custom Status/Ticket disappears

3

Steven,Mario;
Have a look at :
http://lists.fsck.com/pipermail/rt-users/2006-July/040843.html
it maybe related.
Roy

Steven Hollingsworth wrote:> On Tue, Apr 24, 2007 at 09:59:14AM +0200, Mario Rimann wrote:

Any help on this issue is very appreciated!

Cheers,
Mario

Hi Mario,

Had the same problem earlier, but had radio silence on the thread [0].
If you find a resolution to this please post your findings. Still
looking myself.

Can you let me know if you’re getting the same errors as I did. It’s at
the very bottom of the e-mail.

Thanks,

~ stevo

[0] - [rt-users] Custom Status/Ticket disappears

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

4

Hi!

We’ve freshly set up RT on a Gentoo box and most of it runs very
well by
now. Most tickets will be opened through incoming emails.

This is my current issue: Only text attachments are saved to the
database.
All other (tested with JPG) file types that are sent in via mail
(inline
or as attachment) or attached on the web GUI don’t work.

The result is, that the filename is shown in the ticket, but it is not
linked. The DB row contains the filename, content Type but no content.

The max size for attachments in the RT_SiteConfig is set to >10MB, and
also MySQL’s “max_packet_size” is set to a big value. The images I
tried
to attach were <300K, so that shouldn’t be a problem I think.

Any help on this issue is very appreciated!

Do you see errors in the apache or syslog?

PGP.sig (186 Bytes)

5

Steven,Mario;
Have a look at :
http://lists.fsck.com/pipermail/rt-users/2006-July/040843.html
it maybe related.
Roy

Thanks Roy, that worked for me, now I can attach binaries. My Notes follow.

~ stevo

Have to login as root because cannot alter the table as the mysql rtuser.

mysql -u root -p

use rt3;
show tables;

mysql> describe Attachments;
| Field | Type | Null | Key | Default | Extra |
| id | int(11) | | PRI | NULL | auto_increment |
| TransactionId | int(11) | | MUL | 0 | |
| Parent | int(11) | | MUL | 0 | |
| MessageId | varchar(160) | YES | | NULL | |
| Subject | varchar(255) | YES | | NULL | |
| Filename | varchar(255) | YES | | NULL | |
| ContentType | varchar(80) | YES | | NULL | |
| ContentEncoding | varchar(80) | YES | | NULL | |
| Content | longtext | YES | | NULL | |
| Headers | longtext | YES | | NULL | |
| Creator | int(11) | | | 0 | |
| Created | datetime | YES | | NULL | |
12 rows in set (0.00 sec)

ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;

6

Jesse Vincent wrote:

Hi!

We’ve freshly set up RT on a Gentoo box and most of it runs very well by
now. Most tickets will be opened through incoming emails.

This is my current issue: Only text attachments are saved to the
database.
All other (tested with JPG) file types that are sent in via mail (inline
or as attachment) or attached on the web GUI don’t work.

We had the same problem. In our case, the problem was: MySQL database
created with a default encoding of UTF8. The solution for us was to
modify the RT code where it opens up the database connection to
immediately issue the appropriate commands to reset the session to
binary mode.

7

Roy El-Hames schrieb:

Steven,Mario;
Have a look at :
http://lists.fsck.com/pipermail/rt-users/2006-July/040843.html
it maybe related.
Roy

Hi folks

Sorry for my late response, didn’t find the time to try it during the
last days.

Now it’s working! The link above led me to the following MySQL query,
which solved the problem once applied to the database:

ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;

Don’t forget to backup before you start doing such stuff.

Thanks for the help I (once again) got in the list!
Mario