I wrote a patch that allows to store non-text attachments to be stored out of DB - in my case it greatly reduced DB swelling. Just for now it uses constant string in Attachments->Content to indicate that file is written to FS.
You will need to specify some variables in RT_Siteconfig.pm: Set($AttachmentsDirectory, '/var/RT/attachments'); Set($LogAttachmentsLoading, "1"); Set($LogAttachmentsSaving, "1"); Set($StoreNonTextAttachmensInDB, undef); #Set($StoreNonTextAttachmensInDB, "1"); A new share/html/Ticket/Attachment/dhandler and attach.patch for rest of RT distribution is in attachment. Gregory Harper, you can find more complex set of patches allowing to produce & show image thumbs automaticly in attachment too. Some more variables must be specified in RT_Siteconfig.pm Set($ShowTransactionImages, 1); Set($ProduceImageThumbs, 1); Set($ImageThumbsDirectory, '/var/RT/thumbs'); I wonder why bestprcactical is not interested in intergating these patches into RT: From: Jesse Vincent Sent: 21 march 2007 г., 23:53 To: lytochkin Subject: [RT 3.6] Storing attachments away from DB Hi Boris, Thanks very much for the mail, but I think we're not really interested in offering this feature within RT. Best, Jesse -- Boris Lytochkin, JSC e-port, Moscow web: www.e-port.ru, wap: wap.e-port.ru tel: +7 (495) 777 1872, ext. 251 ____________ Date: Mon, 06 Aug 2007 12:31:31 -0500 From: Gregory Harper <[EMAIL PROTECTED]> Subject: Re: [rt-users] Attachments table of RT's Mysql database To: Justin Brodley <[EMAIL PROTECTED]> Cc: rt-users@lists.bestpractical.com Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Justin Brodley wrote: > We actually had to disable the attachment feature as we were having our > customers attach enormous files and killed our DB processing. Ultimately we > are looking > into rewriting the attachment feature to store the attachments on the web > server to alleviate this overhead from the DB. I understand that the > attachment table also > stores all updates to a ticket, not just the attachments. > > > Justin Brodley > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gregory Harper > Sent: Wednesday, August 01, 2007 12:41 PM > To: rt-users@lists.bestpractical.com > Subject: [rt-users] Attachments table of RT's Mysql database > > Hello everybody. > > We've been using RT for more than three months as part of our > customer concern processes. Overall, things have been going well. > The configuration includes Mysql, Apache2 and Postfix running on Ubuntu > 6.06. I've made no modifications to the databases. > The primary concern at this point is that the Attachments table of the > Mysql database is growing significantly. Our CSR's want to attach > PDFs, jpegs, etc. to the tickets with the jpegs usually created by our > customers. The digital photos are the main culprit. I've read about > scaling back the photos, creating thumbnails, etc. and we need to find a > way to limit the attachment size prior to attachment. > > Has anyone else using RT had this type of problem? > > What are the best approaches for minimizing and controlling the size > of the Attachments table? > > Any information, feedback and guidance are appreciated. > > thanks - Gregory Harper , Stevens Industries > > > > > > _______________________________________________ > 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 > > Thanks Justin for the feedback. Anyone else have input regarding their experiences with Attachments and RT? thanks - Greg ------------------------------ Message: 3 Date: Mon, 6 Aug 2007 11:53:13 -0700 (PDT) From: Ed Matthews <[EMAIL PROTECTED]> Subject: [rt-users] Kwiki Table Rendering? To: rt-users@lists.bestpractical.com Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=us-ascii Happy Monday. Does anyone know why Kwiki renders tables on this page, http://wiki.bestpractical.com/view/ManualScrips but not on this page http://wiki.bestpractical.com/view/ManualRights nor in my personal page . I tried copy pasting the first ManualScrips table wiki markup into another edit page and saving, and it wouldn't render there either after save. Ed Matthews [EMAIL PROTECTED] ____________________________________________________________________________________ Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC ------------------------------ Message: 4 Date: Tue, 7 Aug 2007 10:20:33 +0100 From: Luke E Morgan <[EMAIL PROTECTED]> Subject: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install To: rt-users@lists.bestpractical.com Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="us-ascii" I'm sure I'm just missing something simple, but I cannot seem to change the BP logo on my install of RT 3.6.3 on Fedora Core 7. I've installed RT using yum (lazy I know, but it works apart from this issue). It has been installed into /usr/share/rt3 I've created /usr/local/rt3/html/Elements/ and copied the Logo file into that directory. I've added the logo I want to use into /usr/share/rt3/html/NoAuth/images It is a 92x50pixels jpeg. Following suggestions from the wiki and the mailing list archives, I put this line into the Logo file : <a href="<%$RT::LogoLinkURL%>"><img src="<%$RT::LogoURL%>" alt="Intranet" width="<%$RT::LogoWidth%>" height="<%$RT::LogoHeight%>" /></a> I have modified by RT_SiteConfig.pm file. If I log into the web interface, under tools, choose system configuration, the following variables are set : RT::LogoLinkURL http://192.168.66.1 RT::LogoURL /rt3/NoAuth/images/mtllogo.jpg RT::LogoWidth 92 RT::LogoHeight 50 RT::MasonDataDir /var/cache/rt3/mason_data I've tried stopping the webserver, deleting Logo.obj from /var/cache/rt3/mason_data/obj/3989424063/standard When I restart apache, and refresh the RT page, Logo.obj is recreated with the best practical logo in it. Where am I going wrong ? Can anyone point me in the right direction please ? Thanks in advance Luke _____________________________________________________________ This email message may contain privileged/confidential information and/or copyright material. It is intended only for the use of the person(s) to whom it is addressed and any unauthorised use may be unlawful. If you receive this email by mistake, please advise the sender immediately by using the reply facility in your email software and delete the material from your computer. The material contained in this message does not constitute a binding contract with any company within the MTL Instruments Group plc. Opinions, conclusions and other information in this email that do not relate to the official business of this organisation shall be understood as neither given nor endorsed by it. Registered in England No. 1871978, VAT Reg. No 449343040, MTL Instruments Ltd, Power Court, Luton, LU1 3JJ -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm ------------------------------ Message: 5 Date: Tue, 7 Aug 2007 12:39:04 +0100 From: Luke E Morgan <[EMAIL PROTECTED]> Subject: Re: {Disarmed} [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install To: Boris Jordanov <[EMAIL PROTECTED]> Cc: rt-users@lists.bestpractical.com Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="us-ascii" Skipped content of type multipart/alternative-------------- next part -------------- A non-text attachment was scrubbed... Name: graycol.gif Type: image/gif Size: 105 bytes Desc: not available Url : http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/graycol.gif -------------- next part -------------- A non-text attachment was scrubbed... Name: pic05705.gif Type: image/gif Size: 1255 bytes Desc: not available Url : http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/pic05705.gif -------------- next part -------------- A non-text attachment was scrubbed... Name: ecblank.gif Type: image/gif Size: 45 bytes Desc: not available Url : http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/910b3d6a/ecblank.gif ------------------------------ _______________________________________________ RT-Users mailing list RT-Users@lists.bestpractical.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users End of RT-Users Digest, Vol 41, Issue 20 ****************************************
attach.patch
Description: Binary data
dhandler
Description: Binary data
attach_and_thumbs.patch2.diff
Description: Binary data
attach_and_thumbs.patch1.diff
Description: Binary data
_______________________________________________ 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