[rt-users] Remove a ticket

2009-02-17 Thread Alberto Villanueva
Hi all, I would to remove all tickets, but I don't remove the whole database. Does someone know which the best manner to do that? I have a solution, but I don't know if it's the best: mysql -p password use database delete * from Transactions; delete * from Tickets; Regards,

Re: [rt-users] Set a ticket custom field based on a User Custom field scrip action

2009-02-17 Thread Emmanuel Lacour
On Mon, Feb 16, 2009 at 06:11:30PM -0600, Joel Schuweiler wrote: Here's the scenario: 1) A User has a custom field called Billable with two choices, yes, and no. 2) User creates ticket 3) Scrip checks Billable and sets ticket billable if user is billable I'm having a

Re: [rt-users] Remove a ticket

2009-02-17 Thread Emmanuel Lacour
On Tue, Feb 17, 2009 at 09:21:27AM +0100, Alberto Villanueva wrote: Hi all, I would to remove all tickets, but I don't remove the whole database. Does someone know which the best manner to do that? You can use RTx::Shredder for this (as a module from CPAN if RT 3.8, included in

Re: [rt-users] Remove a ticket

2009-02-17 Thread Alberto Villanueva
Hi, When I execute the sentence (rt-shredder --force -plugin 'Tickets=status,new'), I get the next error: [warning]: RT::CachedGroupMember-12--- bla,bla,bla I'sorry by the warning. Any idea?? Thanks a lot! Regards, ALBERTO VILLANUEVA VAL Consultor

Re: [rt-users] Remove a ticket

2009-02-17 Thread Alberto Villanueva
I also created the indexes: CREATE INDEX SHREDDER_CGM1 ON CachedGroupMembers(MemberId, GroupId, Disabled); CREATE INDEX SHREDDER_CGM2 ON CachedGroupMembers(ImmediateParentId, MemberId); CREATE UNIQUE INDEX SHREDDER_GM1 ON GroupMembers(MemberId, GroupId); CREATE INDEX SHREDDER_TXN1

[rt-users] Global CustomField not displaying

2009-02-17 Thread Jim Tambling
Hello I have created a custom field to appear in all tickets. I have enabled it globally for all queues but it does not appear in any new ticket. Where am I going wrong? Regards, Jim ___

Re: [rt-users] Global CustomField not displaying

2009-02-17 Thread Potla, Ashish Bassaliel
Hi Did you apply the group-rights and the user-rights with ShowCustomField and ModifyCustomField rights? Might be worth a look. -Ashish From: rt-users-boun...@lists.bestpractical.com [rt-users-boun...@lists.bestpractical.com] On Behalf Of Jim Tambling

Re: [rt-users] Global CustomField not displaying

2009-02-17 Thread Jim Tambling
Thank you sir, that worked :) -Original Message- From: Potla, Ashish Bassaliel [mailto:c_apo...@qualcomm.com] Sent: 17 February 2009 12:42 To: Jim Tambling; rt-us...@bestpractical.com Subject: RE: Global CustomField not displaying Hi Did you apply the group-rights and the user-rights

Re: [rt-users] Set a ticket custom field based on a User Custom field scrip action

2009-02-17 Thread Joel Schuweiler
[Tue Feb 17 14:06:09 2009] [error]: Scrip 67 Prepare failed: Can't call method FirstCustomFieldValue without a package or object reference at (eval 932) line 1. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf

[rt-users] [Fwd: quick configuration question...]

2009-02-17 Thread Marcin Stangel
Hi there! I have RT system (3.8.1) running on RHEL 5 64bit server, using apache 2.23. For authentication I use the plugin RT::Authen::ExternalAuth to authenticate against Active Directory and it all works great...but... We wanted to make it even more simply and to utilize Kerbreros. Our Linux

Re: [rt-users] Set a ticket custom field based on a User Custom field scrip action

2009-02-17 Thread Emmanuel Lacour
On Tue, Feb 17, 2009 at 08:08:50AM -0600, Joel Schuweiler wrote: [Tue Feb 17 14:06:09 2009] [error]: Scrip 67 Prepare failed: Can't call method FirstCustomFieldValue without a package or object reference at (eval 932) line 1. my $billable =

Re: [rt-users] Set a ticket custom field based on a User Custom field scrip action

2009-02-17 Thread Raed El-Hames
Or maybe : my $billable = $self-TransactionObj-CreatorObj-FirstCustomFieldValue('Billable'); note the (Obj) at the end of Creator Regards; Roy Emmanuel Lacour wrote: On Tue, Feb 17, 2009 at 08:08:50AM -0600, Joel Schuweiler wrote: [Tue Feb 17 14:06:09 2009] [error]: Scrip 67 Prepare

Re: [rt-users] ruby - REST

2009-02-17 Thread Jesse Vincent
It also seems bizarre to me to implement the interface that way. Basically its like making a web page with a single text area named content and then requiring formatting within that one field. Why not have the REST interface have discrete fields? Coding to it would be certainly be

Re: [rt-users] is it possible to demerge a ticket?

2009-02-17 Thread Mathieu Longtin
Thanks, that worked. Go in the DB, change the effectiveid of the ticket back to its ID. It could be easier, but not the end of the world. -- Mathieu Longtin 1-514-803-8977 On Mon, Feb 16, 2009 at 12:28 PM, Emmanuel Lacour elac...@easter-eggs.comwrote: On Mon, Feb 16, 2009 at 12:20:38PM

[rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Tim Cutts
We migrated our RT server to RT 3.8.2 a week ago, and all went well until today, when suddenly we've been hit by a massive performance problem. It seems that almost any query which touches the Attachments table takes an absolute age to complete. For example, I've just logged into the

[rt-users] RT::Extension::SLA Question

2009-02-17 Thread Steve O'Brien
I am try to use RT to replace our current help desk system but have been struggling with 2 points: 1.)We have an SLA with our customers and need to be able to incorporate that into our ticket system. I have installed and begun configuring the SLA extension but I am not really sure if it

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Jesse Vincent
On Tue 17.Feb'09 at 16:51:57 +, Tim Cutts wrote: We migrated our RT server to RT 3.8.2 a week ago, and all went well until today, From what version? when suddenly we've been hit by a massive performance problem. It seems that almost any query which touches the Attachments

Re: [rt-users] RT::Extension::SLA Question

2009-02-17 Thread Ruslan Zakirov
As far as I recall SLA extension supports multiple business hours, so you have to define: %RT::ServiceBusinessHours = ( 'Default' = { ... your description description ... }, ); Such config allow you to define multiple business hours sets. Values of the SLA

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Jesse Vincent
On Tue 17.Feb'09 at 17:47:43 +, Dave Holland wrote: Tim's just got into his car to go home, but I can provide some answers... On Tue, Feb 17, 2009 at 12:29:10PM -0500, Jesse Vincent wrote: On Tue 17.Feb'09 at 16:51:57 +, Tim Cutts wrote: We migrated our RT server to RT 3.8.2 a

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Dave Holland
On Tue, Feb 17, 2009 at 12:59:17PM -0500, Jesse Vincent wrote: And just to be sure, you ran the commands in UPGRADING.mysql? I believe so (Tim did it). # Query_time: 240 Lock_time: 0 Rows_sent: 4 Rows_examined: 27 SELECT DISTINCT main.Id AS id, main.Filename AS filename,

Re: [rt-users] RT::Extension::SLA Question

2009-02-17 Thread Matthew Seaman
Steve O'Brien wrote: I am try to use RT to replace our current help desk system but have been struggling with 2 points: Yep. Same here. 1.)We have an SLA with our customers and need to be able to incorporate that into our ticket system. I have installed and begun configuring the SLA

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Jesse Vincent
I believe so (Tim did it). # Query_time: 240 Lock_time: 0 Rows_sent: 4 Rows_examined: 27 That just looks...crazy. Can you try an OPTIMIZE TABLE Attachments; ? (It may take ... a while.) pgpUvNTAP2WCd.pgp Description: PGP signature ___

Re: [rt-users] is it possible to demerge a ticket?

2009-02-17 Thread Raed El-Hames
You would also need to check if the requesters list for each of your tickets is as they should be, when you merge tickets both set of requesters(and Ccs) get merged into the master ticket. Regards; Roy Mathieu Longtin wrote: Thanks, that worked. Go in the DB, change the effectiveid of the

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Dave Holland
Tim's just got into his car to go home, but I can provide some answers... On Tue, Feb 17, 2009 at 12:29:10PM -0500, Jesse Vincent wrote: On Tue 17.Feb'09 at 16:51:57 +, Tim Cutts wrote: We migrated our RT server to RT 3.8.2 a week ago, and all went well until today, From what

Re: [rt-users] RT::Extension::SLA Question

2009-02-17 Thread Ruslan Zakirov
[snip] There's one feature I'd love to have added to RT::Extension::SLA -- setting initial and final ticket priorities automatically -- exactly as 'Starts' and 'Due' dates are set. One of these days I'll have enough spare time to have a go at coding that up. In 3.8 there is

Re: [rt-users] RT::Extension::SLA Question

2009-02-17 Thread Ruslan Zakirov
[snip] You just need to configure the SLA custom field in the usual way -- as a 'Select one value' and then add your service levels as the list of available options. Now when you go to set the SLA on a ticket it should automatically set the 'Starts' and 'Due' dates on the ticket. You'll

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Ruslan Zakirov
On Tue, Feb 17, 2009 at 8:47 PM, Dave Holland d...@sanger.ac.uk wrote: Tim's just got into his car to go home, but I can provide some answers... On Tue, Feb 17, 2009 at 12:29:10PM -0500, Jesse Vincent wrote: On Tue 17.Feb'09 at 16:51:57 +, Tim Cutts wrote: We migrated our RT server to

[rt-users] CommandByEmail confusion

2009-02-17 Thread Kenneth Crocker
To all, I am VERY confused. I went to Bestpractical (http://cpansearch.perl.org/src/FALCONE/RT-Extensions) to download the CommandByEmail Extension. I am on 3.6.4 so I'm unsure that .06 will work for me. I went to insatlling Instruction and it mentioned the install commands and also

[rt-users] Disabled RT Administration group - Priv users staying BASIC

2009-02-17 Thread O'Leary, Paul
Hello, I need help to get my RT 363 system back online. By mistake, I unchecked the enabled button for the RT administration group, and have disabled it. Now I am unable to perform any admin tasks. I went into the database (Oracle) and checked the principals and cachegroupmembers table and

Re: [rt-users] RT::Extension::SLA Question

2009-02-17 Thread Matthew Seaman
Ruslan Zakirov wrote: [snip] You just need to configure the SLA custom field in the usual way -- as a 'Select one value' and then add your service levels as the list of available options. Now when you go to set the SLA on a ticket it should automatically set the 'Starts' and 'Due' dates on

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Tim Cutts
On 17 Feb 2009, at 6:09 pm, Dave Holland wrote: On Tue, Feb 17, 2009 at 12:59:17PM -0500, Jesse Vincent wrote: And just to be sure, you ran the commands in UPGRADING.mysql? I believe so (Tim did it). Indeed. All done pukka according to the upgrade docs. Tim -- The Wellcome Trust

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Tim Cutts
On 17 Feb 2009, at 6:16 pm, Jesse Vincent wrote: I believe so (Tim did it). # Query_time: 240 Lock_time: 0 Rows_sent: 4 Rows_examined: 27 That just looks...crazy. Can you try an OPTIMIZE TABLE Attachments; ? (It may take ... a while.) Might as well do that now, since we're out of

[rt-users] webmux.pl crashes apache2 start

2009-02-17 Thread Krishnamurti L. L. V. Nunes
Hello world! I have a brand new installation of RT 3.8.2. The configure, testdeps, e install worked propperly, and I was able to run initialize-database, all ok so far. But setting apache to run the web interface fails because of bin/webmux.pl file. Whenever I have the line: PerlRequire

[rt-users] Multiple attachments error

2009-02-17 Thread Ian Trenfield
Hi, I've seen this question asked before, but have not seen a definitive reply yet so thought it worth asking again. We have an intermittent issue regarding attachments, and it seems to happen more often when users are including multiple attachments. The error message is as follows: read-open

Re: [rt-users] Multiple attachments error

2009-02-17 Thread Jesse Vincent
On Tue 17.Feb'09 at 21:15:52 +, Ian Trenfield wrote: Hi, I've seen this question asked before, but have not seen a definitive reply yet so thought it worth asking again. We have an intermittent issue regarding attachments, and it seems to happen more often when users are including

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Tim Cutts
On 17 Feb 2009, at 6:16 pm, Jesse Vincent wrote: I believe so (Tim did it). # Query_time: 240 Lock_time: 0 Rows_sent: 4 Rows_examined: 27 That just looks...crazy. Can you try an OPTIMIZE TABLE Attachments; ? (It may take ... a while.) OK, OPTIMIZE TABLE done, but performance on

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Tom Lahti
Now, I may be being silly here, but how can a table with only 806180 id's in its primary key have more than 3 million rows? And counting them takes three minutes, which really isn't many rows a second... Is this stored in InnoDB by chance? If it were me, I would mysqldump all databases,

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Jesse Vincent
OK, OPTIMIZE TABLE done, but performance on SELECT COUNT(id) FROM Attachments is still terrible: This does sort of smell like an optimiser bug - it says it's using indices, but the level of I/O being done by the machine suggests it's actually performing a full table scan. Indeed.

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Tim Cutts
On 17 Feb 2009, at 6:39 pm, Ruslan Zakirov wrote: I hope you see that mysql examined only 27 rows and spend 240 seconds to do that. I suspect that it's related to very high IO activity that were going parallel with this query and blocked mysql's IO requests. That was my worry. I've shuffled

[rt-users] Attachments table constantly fragmenting

2009-02-17 Thread Rob Munsch
Hello, I've been using the mysqltuner script to check up on things, tune mem use to our resources, etc. One thing remains consistent: no matter what i have things set to, within a few hours of restart or full stop / start (at most), the Attachments table becomes fragmented. Here's the most

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Tim Cutts
On 17 Feb 2009, at 10:52 pm, Jesse Vincent wrote: OK, OPTIMIZE TABLE done, but performance on SELECT COUNT(id) FROM Attachments is still terrible: This does sort of smell like an optimiser bug - it says it's using indices, but the level of I/O being done by the machine suggests it's

Re: [rt-users] Attachments table constantly fragmenting

2009-02-17 Thread Tom Lahti
[!!] Total fragmented tables: 1 [--] Reads / Writes: 64% / 36% Fragmentation is normal, especially with that read/write ratio. It doesn't necessarily indicate a problem. You can periodically optimize the fragmented tables to improve performance, if performance becomes an issue, which should

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Ruslan Zakirov
First time I see something like that. May be it's better to ask on mysql lists. And sure you should keep digging into a reason. My practice shows that there is no such thing as suddenly in IT. There is always some change that turn world up side down. optimize/analyze on InnoDB don't do the same

Re: [rt-users] RT::Extension::SLA Question

2009-02-17 Thread Steve OBrien
Thanks Matthew! I am still a bit foggy on how to use this module and what it really does. I configured the custom fields with a sort value, name and description (I did not know what to put for category). Care to share your ColorMap config with the SLA priorities? TIA, Steve On Tue, 2009-02-17

Re: [rt-users] Severe performance problems suddenly in RT 3.8.2

2009-02-17 Thread Tim Cutts
On 18 Feb 2009, at 12:48 am, Ruslan Zakirov wrote: First time I see something like that. May be it's better to ask on mysql lists. And sure you should keep digging into a reason. My practice shows that there is no such thing as suddenly in IT. There is always some change that turn world up

[rt-users] Errors after upgrade to 3.8.2

2009-02-17 Thread Kevin McClusky
Hi All Have just updated 3.8.1 to 3.8.2 on FC10 using yum update, and now the httpd service will not start up. The following errors are in the log file. Any help would be appreciated as I am pretty new to Linux: [Wed Feb 18 07:12:50 2009] [error] Base class package Class::Accessor::Fast is