[rt-users] performance slow

2010-09-07 Thread Jyoti Sahu
Hi, We are using RT3.6.3 as one of our internal project for request tracking. However we are facing many many many performance issues. We have our Rt database filled like any thing with live request. So the result is our ticket page opens very slow. Sometimes it takes about 3-4 min in

[rt-users] New between Open

2010-09-07 Thread Ingo . Itter
Hello, can someone explain the different between the Ticket State new and open ? Thank you Greetings from Germany Ingo von Itter ___ Geschäftsführer: Rolf Herzog, Thomas Benk AGES Maut System GmbH Co. KG AG Düsseldorf HRA

Re: [rt-users] performance slow

2010-09-07 Thread Emmanuel Lacour
On Tue, Sep 07, 2010 at 11:37:25AM +0530, Jyoti Sahu wrote: Hi, Hi, We are using RT3.6.3 as one of our internal project for request tracking. Upgrading this to latest version will give you better performances. Especially if you have many queues. FYI latest RT is 3.8.8. However we

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Justin Hayes
Thanks Jeffrey. We're already using UseSQLForACLChecks and don't use web external auth. Tried the combination you've given though and unfortunately no difference :( - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 7 Sep 2010, at

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Justin Hayes
Tried Centos last night, and no difference at all. - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 6 Sep 2010, at 20:49, Justin Hayes wrote: Hi Ruslan, Sorry looks like I shrunk the image too much. The thing I find odd is

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Justin Hayes
I *think* we're just CPU bound. Roy's webservers are 3.6ghz so quite a bit faster than ours. We're going to try it on a faster server and that should drop our times. Guess we just wanted to explore all avenues before throwing hardware at the problem. Justin

Re: [rt-users] 10 newest unowned tickets

2010-09-07 Thread Adriena Šišková
Peter Murfitt wrote / napísal(a): I think this is very similar to what Justin was saying a couple of weeks ago: http://lists.bestpractical.com/pipermail/rt-users/2010-July/065538.html Though it looked like that bug was fixed by 3.8.8 I have same problem, and I am on 3.8.8. Any idea how

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Torsten Brumm
Hi Justin, just found this threat, sounds interessting. What i read so far: You have 1 quad core system with 8GB RAM, running both WEB and DB, correct? Think you should follow Raed's hints first to log the queries generated with RT In terms of debug; if you have not done this yet enable

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Justin Hayes
Thanks Torsten. Will have a look at some of those suggestions. We'd ruled the DB out as we couldn't find an slow ones in the logs, and also because we tried a totally fresh DB with only 1 ticket in it, and it was still slow. But it might just be lots of tiny queries so we'll have another look

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Torsten Brumm
Are you running mod_perl2, FastCGI or FCGID? 2010/9/7 Justin Hayes justin.ha...@openbet.com Thanks Torsten. Will have a look at some of those suggestions. We'd ruled the DB out as we couldn't find an slow ones in the logs, and also because we tried a totally fresh DB with only 1 ticket in it,

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Justin Hayes
Well we've captured the time for all the queries run for our long ticket (which takes ~20secs to generate). Total query time is 0.871493s So it's not the DB. Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 7 Sep 2010,

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Torsten Brumm
OK, now we know, it is not the DB, have you used firebug to check which part of the page takes long? There is a nice addon from BPS to track the page memory used for each request inside github, possible a good point to look next. The time you messured are taken with firefox, Internet explorer?

Re: [rt-users] Slow Ticket History

2010-09-07 Thread Tim Cutts
On 6 Sep 2010, at 5:54 pm, rt-users-requ...@lists.bestpractical.com wrote: So far we've tried installing RT on different hardware, both 32 and 64bit versions of linux. RT is still very slow for long tickets. All the time is taken up by the perl/apache process maxing out a core of CPU.

[rt-users] designing not proper

2010-09-07 Thread Jyoti Sahu
Hi, We have just installed 3.8.8 version of RT. However we are facing some problem related to designing. The page looks proper but without proper css Can anybody suggest how this can be solved? Is some perl module is required to be installed? Regards, Jyoti Sahu RT Training

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Torsten Brumm
Hi Justin, just created inside a RT Test VM (slow one with 500mb ram) a single ticket with around 60 replies and some comments. Tested the speed with different users 1. root user to open this ticket: around 26 sec - 870 single sql queries in around 4 sec! (Queries: http://pastebin.com/7Yekfx2Y)

Re: [rt-users] designing not proper

2010-09-07 Thread Emmanuel Lacour
On Tue, Sep 07, 2010 at 05:02:49PM +0530, Jyoti Sahu wrote: Hi, We have just installed 3.8.8 version of RT. However we are facing some problem related to designing. The page looks proper but without proper css Can anybody suggest how this can be solved?

Re: [rt-users] Report on time worked per user

2010-09-07 Thread Francis L Fabrizio
Yes, the TimeWorkedReport does have the option to show time worked per user per ticket. I can't remember if I coded it to be the default presentation or not, but it's documented on that wiki page IIRC. -Fran -Original Message- From: rt-users-boun...@lists.bestpractical.com

Re: [rt-users] Copy Queue Permissions

2010-09-07 Thread Todd Chapman
Not that I'm aware of but I did write an RT extension that makes it easy to compare queue rights side-by-side and assign them to specific users and groups. http://search.cpan.org/~htchapman/RTx-RightsMatrix-0.03.00/lib/RTx/RightsMatrix.pm On Sun, Sep 5, 2010 at 12:28 PM, John Alberts

Re: [rt-users] Copy Queue Permissions

2010-09-07 Thread John Alberts
Thank you. That helps. On 09/07/2010 10:21 AM, Todd Chapman wrote: Not that I'm aware of but I did write an RT extension that makes it easy to compare queue rights side-by-side and assign them to specific users and groups.

Re: [rt-users] Slow Ticket History

2010-09-07 Thread Jason A. Smith
Hi Tim, You might want to send your patch to the RT devel list. I would be interested to see what others, including the BP people have to say about it. ~Jason On 09/07/2010 07:24 AM, Tim Cutts wrote: On 6 Sep 2010, at 5:54 pm, rt-users-requ...@lists.bestpractical.com wrote: So far

Re: [rt-users] Chose Scrip order?

2010-09-07 Thread Jeff Blaine
On 9/1/2010 4:40 PM, Jeff Blaine wrote: Is there any way to prioritize Scrips? Or perhaps someone can suggest something else based on the following? So, no? :) I'm doing something in Scrip 1 that may alter custom field X (employee numbers). Scrip 2 which is in place and working fine

[rt-users] Get the selected value of a CustomField with a Script

2010-09-07 Thread Marco.deSousa
Hello, I have a ticket with some Custom Fields. I wrote a scrip and i need to read the Custom Fields values, but i don't find the command. For example, if i have a CF myCF(combobox) with values ( red, orange, green), and user select a value ( red ) What command on my script i can use to get

Re: [rt-users] Chose Scrip order?

2010-09-07 Thread Kenneth Crocker
Jeff, Alphabetically. For those with the same name/function, I put numbers in front, like 1a or 1b. Also, be sure to set the stage to TransactionBatch. Kenn LBNL On Tue, Sep 7, 2010 at 8:38 AM, Jeff Blaine jbla...@kickflop.net wrote: On 9/1/2010 4:40 PM, Jeff Blaine wrote: Is there any way

Re: [rt-users] Get the selected value of a CustomField with a Script

2010-09-07 Thread Kenneth Crocker
Marco, Try $Ticket-FirstCustomFieldValue('Name of CF') for templates and $self-TicketObj-FirstCustomFieldValue('Name of CF') for scrips. I believe there is an example in the book. Kenn LBNL On Tue, Sep 7, 2010 at 8:51 AM, marco.deso...@billag.com wrote: Hello, I have a ticket with some

Re: [rt-users] RT::Authen::ExternalAuth AutoCreate [Un]Privileged Users

2010-09-07 Thread Kenneth Crocker
Gabriel, Try removing the group 'rt'. Then use filter to accept a broader range of LDAP users (we use division codes). Then you can use the autocreate Privileged setting. That way anyone who passes the LDAP test will be autocreated as Privileged users. that's my best guess. Kenn LBNL On Mon,

[rt-users] FW: What formatting is available for RTFM Wiki Format?

2010-09-07 Thread Mike Brady
Bump From: Mike Brady Sent: Friday, 3 September 2010 11:21 a.m. To: 'rt-users@lists.bestpractical.com' Subject: What formatting is available for RTFM Wiki Format? I have just been setting up RTFM in our test environment and am confused about the formatting of articles. The

[rt-users] Versions of PostgreSQL supported with RT 3.6.7

2010-09-07 Thread Cliff Flood
Hi all, We're using RT 3.6.7 and would like to know what is the latest version of PostgreSQL this is known to work with? This wasn't a detail I could find on the wiki. Thanks in advance you for your responses. Regards, -- Cliff Flood System Administrator +1 416 673 4151 RT Training in