Re: [rt-users] Single SignOn

2010-02-23 Thread Tod Detre
I recently modified RT-Authen-ExtrenaAuth to authenticate to a RubyCAS server. The patching I did definitely doesn't follow all of the conventions as I don't pass config options from RT_SiteConfig like I should, etc. But if you or anyone else is interested I could post the code. It requires the use

[rt-users] TicketHistory slow on 4.2.0

2013-10-23 Thread Tod Detre
I have just upgraded an RT install to 4.2.0. We are experiencing a problem where the ticket history is very slow. Everything else seems to load just fine and the history will load in ~50-60 seconds. Also, if you go to the same ticket in a short period of time, the history will load quickly (probabl

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-23 Thread Tod Detre
Mysql 5.5.23 On Wed, Oct 23, 2013 at 12:21 PM, Alex Vandiver wrote: > On Wed, 2013-10-23 at 12:14 -0400, Tod Detre wrote: > > I have just upgraded an RT install to 4.2.0. We are experiencing a > > problem where the ticket history is very slow. Everything else seems > > to l

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-23 Thread Tod Detre
I've had the mysql slow log on, but it does not show any slow queries. Another interesting point, the mobile site does not seem to have the same problem. On Wed, Oct 23, 2013 at 12:34 PM, Alex Vandiver wrote: > On Wed, 2013-10-23 at 12:27 -0400, Tod Detre wrote: > > Mysql 5.5

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-23 Thread Tod Detre
On Wed, Oct 23, 2013 at 2:25 PM, Alex Vandiver wrote: > On Wed, 2013-10-23 at 13:47 -0400, Tod Detre wrote: > > I've had the mysql slow log on, but it does not show any slow > > queries. > > That is surprising to me, as the symptoms of "first load is slow, > suc

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-24 Thread Tod Detre
_2.GroupId = G roups_1.id ) WHERE ( ( ( main.Queue = 'S' OR main.Queue = 'S' ) OR ( CachedGroupMembers_2.MemberId IS NOT NULL AND Groups_1.Name = 'S' ) OR ( main.Owne r = 'S' ) ) ) AND (main.IsMerged IS NULL) AND (main.Status != 'S') AND (main.Type =

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-25 Thread Tod Detre
Here are the EXPLAIN results: mysql> EXPLAIN SELECT count(main.id)FROM ObjectCustomFieldValues main; ++-+---+---+---+--+-+--+-+-+ | id | select_type | table | type | possible_keys | key | key_le

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-28 Thread Tod Detre
rt4/sbin/../lib/RT/Interface/Web.pm:1292) On Fri, Oct 25, 2013 at 5:22 PM, Alex Vandiver wrote: > On Fri, 2013-10-25 at 16:56 -0400, Tod Detre wrote: >> Here are the EXPLAIN results: [snip] >> >> So it looks like the first query is using an index, but the second is >

Re: [rt-users] TicketHistory slow on 4.2.0

2013-10-31 Thread Tod Detre
utohandler:53] On Thu, Oct 31, 2013 at 1:09 PM, Alex Vandiver wrote: > On Mon, 2013-10-28 at 09:54 -0400, Tod Detre wrote: >> Adding the index did indeed fix the issue. I've pasted the line from >> the SQL log below. It looks like the query is coming from >> RT::Transa

[rt-users] RT 4.2.0 caching issues?

2013-11-18 Thread Tod Detre
My users are seeing some strange problems that appear to be related to some sort of caching. One of the problems is they will set an owner of a ticket and then perform a search that includes that ticket and the owner will display as nobody in the search list. I'd like to eliminate the MySQL query

[rt-users] RT 4.2.0 jquery.min.map 404

2013-11-18 Thread Tod Detre
In attempting to diagnose other issues, I've found that RT is requesting a jquery file that does not exist. The path is below: /NoAuth/js/jquery.min.map The initiator of the request seems to be made from every page. Is this something wrong with my config that it's not looking for the correct fil

Re: [rt-users] RT 4.2.0 jquery.min.map 404

2013-11-18 Thread Tod Detre
Ahh, thank you for the explanation. On Mon, Nov 18, 2013 at 4:24 PM, Alex Vandiver wrote: > On Mon, 2013-11-18 at 16:17 -0500, Tod Detre wrote: >> In attempting to diagnose other issues, I've found that RT is >> requesting a jquery file that does not exist. The path is bel