[rt-users] Attachments table of RT's Mysql database

Tue Aug 7 08:15:02 EDT 2007

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 <gregh at stevensind.com>
Subject: Re: [rt-users] Attachments table of RT's Mysql database
To: Justin Brodley <jbrodley at sumtotalsystems.com>
Cc: rt-users at lists.bestpractical.com
Message-ID: <46B75AF3.3080200 at stevensind.com>
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: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Gregory Harper
> Sent: Wednesday, August 01, 2007 12:41 PM
> To: rt-users at 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: sales at bestpractical.com
>
>
> 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 <g8orade at yahoo.com>
Subject: [rt-users] Kwiki Table Rendering?
To: rt-users at lists.bestpractical.com
Message-ID: <569062.32875.qm at web51102.mail.re2.yahoo.com>
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
g8orade at yahoo.com

____________________________________________________________________________________
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 <lmorgan at mtl-inst.com>
Subject: [rt-users] Trying to change the logo. Fedora Core 7,   RT3.6.3
        yum install
To: rt-users at lists.bestpractical.com
Message-ID:
        <OF74585201.1DEBE7DD-ON80257330.003044E6-80257330.0033159C at mtl-inst.com>

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 <lmorgan at mtl-inst.com>
Subject: Re: {Disarmed} [rt-users] Trying to change the logo. Fedora
        Core 7, RT3.6.3 yum install
To: Boris Jordanov <jordanov at brg.bg>
Cc: rt-users at lists.bestpractical.com
Message-ID:
        <OF7F7C160E.3A42C7E0-ON80257330.003EF00C-80257330.003FC412 at mtl-inst.com>

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 at lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

End of RT-Users Digest, Vol 41, Issue 20
****************************************

-------------- next part --------------
A non-text attachment was scrubbed...
Name: attach.patch
Type: application/octet-stream
Size: 5361 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/454a0c9a/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dhandler
Type: application/octet-stream
Size: 4434 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/454a0c9a/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: attach_and_thumbs.patch2.diff
Type: application/octet-stream
Size: 5634 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/454a0c9a/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: attach_and_thumbs.patch1.diff
Type: application/octet-stream
Size: 6772 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/454a0c9a/attachment-0003.obj>