How are attachments handled in RT?

RT Users
1

I just uploaded a ticket with an attachments.
If I look at the path from RT (when I look at the link), I cannot find
the file on the RT server.

If I do a search on the RT server for that file I cannot find it either?

How are attachments handled in RT?

Thanks,
Phil

2

a message of 17 lines which said:

If I look at the path from RT (when I look at the link), I cannot
find the file on the RT server.

It is in the database (SELECT * FROM Attachments WHERE filename LIKE
‘%.pdf’ for instance…)

3

I mean where are the actual files saved to?From: Stephane Bortzmeyer [mailto:bortzmeyer@nic.fr]
Sent: Thursday, April 14, 2005 3:32 PM
To: Labonte, Phil
Cc: rt-users@lists.bestpractical.com
Subject: Re: How are attachments handled in RT?

a message of 17 lines which said:

If I look at the path from RT (when I look at the link), I cannot
find the file on the RT server.

It is in the database (SELECT * FROM Attachments WHERE filename LIKE
‘%.pdf’ for instance…)

4

What Stephanie was saying is that they aren’t stored on the disk,
but are instead stored inside of the database.
So, the only way to get them is by using a database query like the
one she provided.
Depending on what database you use, you could do a dump/backup of
the database to extract all the attachments if you wanted to.On Thu, 14 Apr 2005, Labonte, Phil wrote:

I mean where are the actual files saved to?

-----Original Message-----
From: Stephane Bortzmeyer [mailto:bortzmeyer@nic.fr]
Sent: Thursday, April 14, 2005 3:32 PM
To: Labonte, Phil
Cc: rt-users@lists.bestpractical.com
Subject: Re: How are attachments handled in RT?

On Thu, Apr 14, 2005 at 02:12:12PM -0400, Labonte, Phil phil.labonte@transcore.com wrote
a message of 17 lines which said:

If I look at the path from RT (when I look at the link), I cannot
find the file on the RT server.

It is in the database (SELECT * FROM Attachments WHERE filename LIKE
‘%.pdf’ for instance…)

The rt-users Archives

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

5

ThanksFrom: Jon Daley [mailto:bestpractical@daley.snurgle.org]
Sent: Thursday, April 14, 2005 5:23 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RE: How are attachments handled in RT?

What Stephanie was saying is that they aren't stored on the

disk,
but are instead stored inside of the database.
So, the only way to get them is by using a database query like
the
one she provided.
Depending on what database you use, you could do a dump/backup
of
the database to extract all the attachments if you wanted to.

I mean where are the actual files saved to?

-----Original Message-----
From: Stephane Bortzmeyer [mailto:bortzmeyer@nic.fr]
Sent: Thursday, April 14, 2005 3:32 PM
To: Labonte, Phil
Cc: rt-users@lists.bestpractical.com
Subject: Re: How are attachments handled in RT?

a message of 17 lines which said:

If I look at the path from RT (when I look at the link), I cannot
find the file on the RT server.

It is in the database (SELECT * FROM Attachments WHERE filename LIKE
‘%.pdf’ for instance…)

The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact
training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact
training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com