[rt-users] RT-3.6.1-4 - DB connection problem

2008-04-02 Thread Albert Czarnecki
Hi I'm using debian etch and RT version 3.6.1-4 , now I have problem to connect DB, when I run from shell: perl /usr/share/request-tracker3.6/libexec/mason_handler.fcgi I get some error: DBI connect('dbname=rt_test;host=192.168.1.11;port=3306','rt_test',...) failed: received invalid response to

[rt-users] Archiving the Attachments Table

2008-04-02 Thread Justin Hayes
Hi, Our attachments table is currently taking up 2.3gb and is easily the largest table in our RT 3.6.3 DB. I know that that table contains both the text of comments/replies as well as the files that are attached to tickets. Has anyone looked at archiving this table? Ideally I'd like to keep

Re: [rt-users] Archiving the Attachments Table

2008-04-02 Thread Benjamin Weser
Why don't you make a general backup of your mysql database (you can also export this table only) and then use the Shredder to get rid of the attachments? Justin Hayes schrieb: Hi, Our attachments table is currently taking up 2.3gb and is easily the largest table in our RT 3.6.3 DB. I

Re: [rt-users] Archiving the Attachments Table

2008-04-02 Thread Justin Hayes
Thanks I'll take a look at the Shredder - I was thinking about deleting rows using SQL but if there's an extension to do it I'll use that. However am I easily going to be able to get files back from the backup if I need them? The files are stored as data in a column of that table. If 3

Re: [rt-users] Enhancements and workflows that we have added

2008-04-02 Thread Kenneth Crocker
Aaron, Sure. Thanks for asking. The following is a copy of the code just above what your addition is to just below: *** beginning copy ** my $EditComponent = EditCustomField$Type; $m-comp('/Elements/Callback', _CallbackName = 'EditComponentName', Name = \$

[rt-users] RT Update and Bulk Update

2008-04-02 Thread Hossein Rafighi
Hi all, I have a question regarding RT update verses Bulk Update. If we don’t wish a message to be sent to a Cc or Bcc member of any given ticket we have to check a box in front of their name(s) and then click on “Save changes” button, then click on the “Update Ticket” to accomplish this

[rt-users] How to reset Preferences - Search options?

2008-04-02 Thread Jean-Sebastien Morisset
Hi everyone, Is there a way to reset the user's Preferences - Search options to the $DefaultSearchResultFormat? A Defaults button on the SearchOptions.html page, for example, could be handy. Thansk, js. -- Jean-Sebastien Morisset, Sr. UNIX Administrator [EMAIL PROTECTED]

[rt-users] autoreply template content

2008-04-02 Thread Gary Gina Koteras
Hello, It doesn't look like I have privs to the autoreply global template. Would anybody be able to email me the content of that template so I can see how it is setup? thanks, Gary _ More immediate than e-mail? Get instant

Re: [rt-users] How to reset Preferences - Search options?

2008-04-02 Thread Jean-Sebastien Morisset
On Wed, Apr 02, 2008 at 05:49:07PM +, Jean-Sebastien Morisset wrote: Hi everyone, Is there a way to reset the user's Preferences - Search options to the $DefaultSearchResultFormat? A Defaults button on the SearchOptions.html page, for example, could be handy. I've been able to add the

Re: [rt-users] How to reset Preferences - Search options?

2008-04-02 Thread Jean-Sebastien Morisset
On Wed, Apr 02, 2008 at 06:35:35PM +, Jean-Sebastien Morisset wrote: On Wed, Apr 02, 2008 at 05:49:07PM +, Jean-Sebastien Morisset wrote: Hi everyone, Is there a way to reset the user's Preferences - Search options to the $DefaultSearchResultFormat? A Defaults button on the

Re: [rt-users] RT Update and Bulk Update

2008-04-02 Thread Hossein Rafighi
No. What I want is a way NOT to send email to Admin Cc or Cc people when ticket(s) are resolved through Bulk Update. I tried Remove Admin Cc: but to no avail. I can easily accomplish this when I am resolving tickets individually by checking the boxes next to Admin Cc and Cc names and then

Re: [rt-users] RT Update and Bulk Update

2008-04-02 Thread Kenneth Crocker
Hossein, AAHH! Now I understand. I thought you were just talking about the way it updates. You want THAT without the automatic email when the ticket status is changed. HHHMM. I wonder if there is a way to identify when the transaction is coming from bulk update? Then you could use

[rt-users] installing on RHEL4

2008-04-02 Thread Nelson Pereira
Is there an up to date install instruction apart from: http://wiki.bestpractical.com/view/RHEL4InstallGuide I see a RPM rt-3.6.6-1.noarch.rpm but it's missing a WACK load of dependencies How do I install this RPM and satisfy all dependencies? Nelson Pereira Senior

Re: [rt-users] installing on RHEL4

2008-04-02 Thread Mike Peachey
Nelson Pereira wrote: Is there an up to date install instruction apart from: http://wiki.bestpractical.com/view/RHEL4InstallGuide I see a RPM rt-3.6.6-1.noarch.rpm but it’s missing a WACK load of dependencies…. How do I install this RPM and satisfy all dependencies? Personally I

[rt-users] Self Service Permissions

2008-04-02 Thread Stephen Cochran
Our unprivileged users can't see the queue names (we have multiple queues) in the Self Service interface, the field is just blank. What permission is needed to see that field? Currently set up with: unprivileged: CreateTicket SeeQueue requester: ReplyToTicket

[rt-users] Due Date in Ticket Creation Page

2008-04-02 Thread Stephen Cochran
Has anyone hacked the Create ticket form to show the due date? Can easily create a custom field that shows on the entry form, but seems silly since the ticket object already has a due date. In the archives I noticed a lot posts referencing using PHP etc as a front end and just having the