[rt-users] TicketSQL search for requested tickets of current user?

2007-05-01 Thread Justin Hayes
! -- Justin Hayes Support Manager [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT

Re: [rt-users] TicketSQL search for requested tickets of current user?

2007-05-02 Thread Justin Hayes
Thanks Gene Is there any documentation on what's possible or am I going to have to figure this out from code? The TicketSQL page on the wiki doesn't seem to contain much. Cheers, Justin -- Justin Hayes Support Manager [EMAIL

Re: [rt-users] TicketSQL search for requested tickets of current user?

2007-05-03 Thread Justin Hayes
with Open Tickets by Requestor [EMAIL PROTECTED] 4 [EMAIL PROTECTED] 2 jsmith 6 and those link using something like http://openbugrt.orbis/Search/ Results.html?Query=Requestor.RealName='Justin Hayes' AND (Status = 'new' OR Status = 'open') So a requestor can find

[rt-users] Global Default Search Display Options? Is this possible?

2007-06-07 Thread Justin Hayes
table when migrating users from my current system, but once the migration is done and we're live I don't want to have to be hacking the DB data to reset a user's options. Any help appreciated. Justin -- Justin Hayes Support Manager

Re: [rt-users] Global Default Search Display Options? Is this possible?

2007-06-07 Thread Justin Hayes
not create user') ); } -- Justin Hayes Support Manager [EMAIL PROTECTED] On 7 Jun 2007, at 09:51, Justin Hayes wrote: I'm using 3.6.3. You can set up a global default At A Glance layout in the options, which is great. However I can't

[rt-users] Strong Password Checking

2007-06-07 Thread Justin Hayes
-- Justin Hayes Support Manager [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED

Re: [rt-users] Global Default Search Display Options? Is thispossible?

2007-06-12 Thread Justin Hayes
Just in case it's of interest I found what I want in RT_Config.pm: # $DefaultSearchResultFormat is the default format for RT search results . . -- Justin Hayes Support Manager [EMAIL PROTECTED] On 7 Jun 2007, at 10:22, Justin Hayes wrote

Re: [rt-users] ImageAutoResize in RT 3.6.3

2007-06-14 Thread Justin Hayes
-- Justin Hayes Support Manager [EMAIL PROTECTED] On 7 May 2007, at 08:34, Baytalskiy, Sal wrote: Hello! I found an article on automatic image resizing for RT 3.2 on the Wiki. However it talks about some files that seem to be very different in RT 3.6.3 that i'm

Re: [rt-users] Prevent Status from changing upon inbound message

2007-06-16 Thread Justin Hayes
maybe try the following contribition: http://wiki.bestpractical.com/view/NonTransitioningStatus worked fine for me an now I can choose which statusses get set back to open on correspondance Justin -- Justin Hayes Support Manager [EMAIL

[rt-users] Help - Clicking the reply/comment links from header bar causes transactions/scrips

2007-07-03 Thread Justin Hayes
-- Justin Hayes Support Manager [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets

Re: [rt-users] Help - Clicking the reply/comment links from headerbarcauses transactions/scrips

2007-07-03 Thread Justin Hayes
/pipermail/rt-users/ attachments/20070204/4f331f76/rt-3.6.3-transaction_batch.bin Read it before trying Batch out but hadn't understood it's implication. Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] On 3 Jul 2007, at 20:25, Justin Hayes

Re: [rt-users] CC field addressee does not get message

2007-07-12 Thread Justin Hayes
figured this out - for ad-hoc cc-ing it's not CC you need to be notifying in the scrip it's 'other recipients'. HTH Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] On 12 Jul 2007, at 15:56, Justin Hayes wrote: I'm having

Re: [rt-users] Large number of SELECT queries run when displayingticket

2007-08-03 Thread Justin Hayes
-- Justin Hayes Support Manager [EMAIL PROTECTED] On 3 Aug 2007, at 12:04, Roy El-Hames wrote: Justin; Not sure if it'll help you ; I had the same issue, where tickets with 100 or so updates/comments were taking over 1 minute to display .. In our RT we do

[rt-users] Large number of SELECT queries run when displaying ticket

2007-08-03 Thread Justin Hayes
. Or maybe my install is broken or maybe some of our customisations are causing it. Any thoughts/opinions welcome... Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] ___ http

[rt-users] Archiving the Attachments Table

2008-04-02 Thread Justin Hayes
textual comment/replies but remove attached files. I'd also like to do it in a way that would mean I could get them back later if needed. Any ideas? Justin -- Justin Hayes Support Manager [EMAIL PROTECTED

Re: [rt-users] Archiving the Attachments Table

2008-04-02 Thread Justin Hayes
the backup. So I have a live streamlined install and a bloated backup install. Cheers, Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] On 2 Apr 2008, at 14:18, Benjamin Weser wrote: Why don't you make a general backup of your mysql

[rt-users] FireFox3 Font Size Issue

2008-06-23 Thread Justin Hayes
to the ticket history. Anyone else experiencing something similar? I've tried googling but not found anything that seems related, and I've had a look at the CSS and nothing obvious is jumping out at me. Cheers, Justin -- Justin Hayes Support Manager

[rt-users] Resolve Ticket Option

2008-06-25 Thread Justin Hayes
-- Justin Hayes Support Manager [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden

Re: [rt-users] Resolve Ticket Option

2008-06-25 Thread Justin Hayes
figured that would be ok as you'd have to have the permission to see the ticket in the first place. Your method might be safer though, as you can permission it. Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] On 25 Jun 2008, at 09:45

Re: [rt-users] Resolve Ticket Option

2008-06-25 Thread Justin Hayes
permission if you run SetStatus in %INIT? Justin -- Justin Hayes Support Manager [EMAIL PROTECTED] On 25 Jun 2008, at 10:08, Brian Gallew wrote: Justin Hayes wrote: I'd like to offer my customers an option to resolve a ticket themselves

Re: [rt-users] Resolve Ticket Option

2008-06-25 Thread Justin Hayes
-- Justin Hayes Support Manager [EMAIL PROTECTED] On 25 Jun 2008, at 10:20, Benjamin Weser wrote: Hi Justin, I established the indirect method of changing the ticket status here at our RT to get a kind of workflow. You can set permissions of each CF

[rt-users] Locking accounts on password failure

2008-08-07 Thread Justin Hayes
Has anyone implemented locking accounts after so many login attempts? I'm sure I can add it myself but if there's a solution out there already. I'm using 3.6.3 Cheers, Justin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

[rt-users] Search for logged-in user as requestor

2009-01-07 Thread Justin Hayes
Hi, I would like to be able to create saved searches that will find tickets where the logged in user is the Requestor. This is easy for Owner as you can use Owner = '__CurrentUser__'. Is there a way to do this for Requestor though? I tried Requestor = '__CurrentUser__' but

Re: [rt-users] Search for logged-in user as requestor

2009-01-08 Thread Justin Hayes
maybe Requestor.Id would do? HTH, Gabriele Franzini ICT Applications Manager Nerviano Medical Sciences SRL 20014 Nerviano Italy - Message: 1 Date: Wed, 7 Jan 2009 09:43:12 + From: Justin Hayes justin.ha...@orbisuk.com Subject: [rt

Re: [rt-users] Search for logged-in user as requestor

2009-01-08 Thread Justin Hayes
{'CurrentUser'}- Id/ge; $SearchArg-{'Query'} =~ s/__CurrentUserEmail__/ $session{'CurrentUser'}-EmailAddress/ge; You can then use the following in searches that you add to the At A Glance screen: Requestor.EmailAddress = '__CurrentUserEmail__' Cheers, Justin On 7 Jan 2009, at 09:43, Justin Hayes

[rt-users] Slow loading of long tickets in 3.6.3

2009-04-28 Thread Justin Hayes
the attachments, but I'm sure that's a simplistic view of it. Any thoughts welcome! Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com ___ http://lists.bestpractical.com/cgi-bin

Re: [rt-users] Slow loading of long tickets in 3.6.3

2009-04-28 Thread Justin Hayes
there are the line numbers Roy Justin Hayes wrote: Hi, Some of our tickets can get pretty long and the longer they get the longer the page takes to load. So for a long ticket with say 100 comments/replies and assorted status changes etc it might take 10+ seconds to render

Re: [rt-users] Slow loading of long tickets in 3.6.3

2009-04-28 Thread Justin Hayes
you do the change .. I am on 3.6.3 and some of our monitoring tickets are over 300 updates long .. having been through the pain you having, I tried all possible options Roy Justin Hayes wrote: Thanks for the advice Roy, but I think I'd already tried that at some point in the past

Re: [rt-users] Slow loading of long tickets in 3.6.3

2009-04-28 Thread Justin Hayes
skipped uninteresting transactions. Maybe an approach like that would help. Cheers, Ken On Tue, Apr 28, 2009 at 04:19:21PM +0100, Justin Hayes wrote: I've put some high resolution timestamping into the code and found some interesting things. Am example ticket that took 10 seconds to render

Re: [rt-users] Slow loading of long tickets in 3.6.3

2009-04-29 Thread Justin Hayes
being a micro-optimization at best. As you have noticed, the key is to reduce the amount of transactions processed completely. Just nuking the RT_System transactions really helped. My two cents, Ken On Tue, Apr 28, 2009 at 06:29:13PM +0100, Justin Hayes wrote: I'm already skipping a load

Re: [rt-users] Slow loading of long tickets in 3.6.3

2009-04-29 Thread Justin Hayes
) and then work out how much to show based on how many transactions the ticket has. Justin On 29 Apr 2009, at 07:35, Justin Hayes wrote: Thanks Ken but I think I'm already doing that in my SkipTransaction callback: %init my $ttype; $ttype = $Transaction-Type; $$skip = 1

Re: [rt-users] Slow loading of long tickets in 3.6.3

2009-04-29 Thread Justin Hayes
, History.html etc etc to decide when you want to do the truncating.. Hope this is useful to someone! Justin On 29 Apr 2009, at 08:01, Justin Hayes wrote: Alternatively I might look into only showing say the first 10 transactions and last 30 for tickets with over 100 transactions

Re: [rt-users] Slow loading of long tickets in 3.6.3

2009-04-29 Thread Justin Hayes
, Ken On Wed, Apr 29, 2009 at 09:53:36AM +0100, Justin Hayes wrote: I've implemented stripping out the middle portion of long tickets (set to more than 200 transactions atm) and here's how I did it in case you would like to do something similar. For a ticket with 100 comments/ replies

[rt-users] Bug in 3.6.3 At A Glance saved search display

2009-05-11 Thread Justin Hayes
the user can see, then show the last 10. Does anyone know if this can be fixed, or if it is fixed in 3.8? Thanks, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com ___ http

Re: [rt-users] Bug in 3.6.3 At A Glance saved search display

2009-05-11 Thread Justin Hayes
Many thanks Kevin. Does it have any other effects? Just trying to understand why it's off by default. Looks like another reason to work on the upgrade. Cheers, Justin On 11 May 2009, at 15:20, Kevin Falcone wrote: On May 11, 2009, at 2:36 AM, Justin Hayes wrote: I create a saved search

Re: [rt-users] Bug in 3.6.3 At A Glance saved search display

2009-05-12 Thread Justin Hayes
Ok many thanks Kevin. I'm hoping to set up a 3.8 test environment so I'll have a play around with that setting on there. Justin On 11 May 2009, at 18:02, Kevin Falcone wrote: On May 11, 2009, at 12:50 PM, Justin Hayes wrote: Many thanks Kevin. Does it have any other effects? Just trying

[rt-users] MakeClicky call back example doesn't seem to work (RT3.8.4)

2009-07-14 Thread Justin Hayes
- Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa

Re: [rt-users] MakeClicky call back example doesn't seem to work(RT3.8.4)

2009-07-14 Thread Justin Hayes
doing something stupid) Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 14 Jul 2009, at 18:12, Justin Hayes wrote: Hi, Has anyone tried the example MakeClicky Callback in the docs (extending_clickable_links.pod

Re: [rt-users] MakeClicky call back example doesn't seem to work (RT3.8.4)

2009-07-14 Thread Justin Hayes
Thanks Kevin. RT version is 3.8.4 as given in the subject of my mail. Perl is 5.10.0 I believe. I'll try adding that debug and see what I get. Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 14 Jul 2009, at 21:14

Re: [rt-users] MakeClicky call back example doesn't seem to work (RT3.8.4)

2009-07-14 Thread Justin Hayes
' = '-', 'empty' = '', 'quoter' = '', 'raw' = '-' - Justin Hayes Orbis Support Manager

Re: [rt-users] MakeClicky call back example doesn't seem to work (RT3.8.4)

2009-07-15 Thread Justin Hayes
Ah that might be it - I have got the httpurl one turned on as well. I've got the patch and will let you know how it goes. Thanks again! Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 14 Jul 2009, at 22:43, Kevin

Re: [rt-users] MakeClicky call back example doesn't seem to work (RT3.8.4)

2009-07-15 Thread Justin Hayes
Works great. Thanks very much for fixing this so quickly!! Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 14 Jul 2009, at 22:40, Ruslan Zakirov wrote: Try attached patch. Don't forget to flush mason cache and send us

[rt-users] Relationship Graphs not working in RT 3.8.4

2009-08-05 Thread Justin Hayes
/Mason/CGIHandler.pm:73] [/ opt/rt3/bin/mason_handler.fcgi:79] Cheers, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt

Re: [rt-users] Relationship Graphs not working in RT 3.8.4

2009-08-05 Thread Justin Hayes
- Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 5 Aug 2009, at 14:27, Ruslan Zakirov wrote: Hello Justin, Have you restarted the server after install? On Wed, Aug 5, 2009 at 3:26 PM, Justin Hayesjustin.ha...@orbisuk.com wrote: Anyone had any problems getting the ticket

Re: [rt-users] Relationship Graphs not working in RT 3.8.4

2009-08-05 Thread Justin Hayes
Tried restarting the server itself, but still get the same error :( Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 5 Aug 2009, at 14:27, Ruslan Zakirov wrote: Hello Justin, Have you restarted the server after

Re: [rt-users] Relationship Graphs not working in RT 3.8.4

2009-08-05 Thread Justin Hayes
I didn't do the initial install, but I'm guessing probably not... Is there any way to do it retrospectively? Thanks again Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 5 Aug 2009, at 16:58, Kevin Falcone wrote

Re: [rt-users] Relationship Graphs not working in RT 3.8.4

2009-08-06 Thread Justin Hayes
Simply installing IPC::Run::SafeHandles did the trick. Thanks Kevin! Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 5 Aug 2009, at 17:36, Kevin Falcone wrote: On Wed, Aug 05, 2009 at 05:11:22PM +0100, Justin Hayes

[rt-users] Dashboard subscriptions not working in RT 3.8.4

2009-08-06 Thread Justin Hayes
daily at 1pm but I never get any emails. Are there any configs I have to turn on to get this to work? I'm getting other RT mails from the system so it's not like mail is broken or something. Cheers in advance, Justin - Justin Hayes Orbis

Re: [rt-users] Dashboard subscriptions not working in RT 3.8.4

2009-08-06 Thread Justin Hayes
/sbin/rt-email-digest -m daily 0 0 * * 0 /opt/rt3/sbin/rt-email-digest -m weekly 0 * * * * /opt/rt3/sbin/rt-email-dashboards - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 6 Aug 2009, at 13:38, Joop van de

[rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-09-15 Thread Justin Hayes
. Perhaps the DB wasn't dumped using binary character set? How could I check that and how should the IT guys have dumped the DB to make sure it was in binary? Any thoughts? Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com

Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-09-16 Thread Justin Hayes
corruption. Regards, Aaron Guise 07 838 7793 027 212 6638 aa...@guise.net.nz On Wed, Sep 16, 2009 at 7:54 AM, Justin Hayes justin.ha...@orbisuk.com wrote: Hi guys, I'm just testing an upgrade from 3.6.3 to 3.8.4. I ran the rt-setup- database fine: /opt/rt_support.openbet.com/sbin/rt-setup

Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-09-16 Thread Justin Hayes
they are here somewhere. Might take a day though. Regards, Aaron Guise 07 838 7793 027 212 6638 aa...@guise.net.nz On Wed, Sep 16, 2009 at 9:20 PM, Justin Hayes justin.ha...@orbisuk.com wrote: Thanks a lot for the info and advise Aaron. Don't suppose you kept the scripts you used

[rt-users] 3.8.4 looks different in IE7

2009-10-07 Thread Justin Hayes
Hi guys,For me IE7 seems to render 3.8.4 differently to IE8, Safari and Firefox. It's missing all the nice round edges on the various buttons and panel headers etc, and generally doesn't look as nice.IE7:Safari:Is that expected, or is there something wrong with my install perhaps?I can see this in

Re: [rt-users] 3.8.4 looks different in IE7

2009-10-07 Thread Justin Hayes
Gotta love different browser implementations :) Still one less problem that I actually need to try and fix. Thanks for the quick reply Jesse! Justin On 7 Oct 2009, at 16:53, Jesse Vincent wrote: On Wed, Oct 07, 2009 at 04:48:40PM +0100, Justin Hayes wrote: Hi guys, For me IE7 seems

Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-10-19 Thread Justin Hayes
storage system :-) Regards, Aaron Guise 07 838 7793 027 212 6638 aa...@guise.net.nz On Thu, Sep 17, 2009 at 11:00 AM, Tom Lahti t...@bitstatement.net wrote: Justin Hayes wrote: Thanks Aaron. I've always wondered why file attachments are stored in the db at all. I'd have thought those

Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-10-19 Thread Justin Hayes
838 7793 027 212 6638 aa...@guise.net.nz On Thu, Sep 17, 2009 at 11:00 AM, Tom Lahti t...@bitstatement.net wrote: Justin Hayes wrote: Thanks Aaron. I've always wondered why file attachments are stored in the db at all. I'd have thought those would have been better placed out

[rt-users] UseSQLForACLChecks causes slow performance

2009-10-31 Thread Justin Hayes
is now out. Were there improvements in that that would help with this setting? Cheers, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com ___ http://lists.bestpractical.com/cgi-bin

Re: [rt-users] UseSQLForACLChecks causes slow performance

2009-10-31 Thread Justin Hayes
to just isolate the queries for just 1 user hitting the main page. Justin On 31 Oct 2009, at 16:09, Kenneth Marshall wrote: On Sat, Oct 31, 2009 at 11:21:08AM +, Justin Hayes wrote: I've just upgraded to 3.8.4 and as part of that I've enabled UseSQLForACLChecks RT_SiteConfig.pm:Set

[rt-users] Very slow ticket search creation/edit screen 3.8.4

2010-02-15 Thread Justin Hayes
and speed things up, but it didn't help. We're using 3.8.4 Thanks, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt

Re: [rt-users] Very slow ticket search creation/edit screen 3.8.4

2010-02-15 Thread Justin Hayes
something obvious :) Cheers, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 15 Feb 2010, at 16:52, Jesse Vincent wrote: On Mon, Feb 15, 2010 at 04:30:32PM +, Justin Hayes wrote: On one of our RT installs it's

Re: [rt-users] Very slow ticket search creation/edit screen 3.8.4

2010-02-15 Thread Justin Hayes
- Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 15 Feb 2010, at 17:20, Jesse Vincent wrote: On Mon, Feb 15, 2010 at 05:18:53PM +, Justin Hayes wrote: That doesn't seem to be an answer. So it's just slow if you want to have a lot of owners

Re: [rt-users] Very slow ticket search creation/edit screen 3.8.4

2010-02-15 Thread Justin Hayes
Ah ok, so even if all my users have OwnTicket for a queue getting that list is still faster than showing all users on the Search screen, even though the resulting list is the same length? Total rows in Users is 543. Justin - Justin Hayes Orbis

Re: [rt-users] Very slow ticket search creation/edit screen 3.8.4

2010-02-24 Thread Justin Hayes
.PrincipalType = 'User') AND (ACL_4.RightName = 'OwnTicket' OR ACL_4.RightName = 'SuperUser') AND (Groups_3.Domain = 'RT::Queue-Role') AND ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System')) ORDER BY main.Name ASC; - Justin Hayes

[rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Justin Hayes
Thanks, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Justin Hayes
Hi Kenneth, I'm using MYSQL, How can I tell which query it is? I get no logging and nothing in the MYSQL slow search log, I assume because it never completes? Thanks, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 29

Re: [rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Justin Hayes
to be something else that's the problem. Something rights related? Thanks, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 29 Apr 2010, at 17:27, Ruslan Zakirov wrote: Hi Justin, First of all use Requestor.EmailAddress

[rt-users] Search for tickets with unresolved dependants

2010-05-22 Thread Justin Hayes
- Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com

[rt-users] Time taken to open ticket history

2010-06-03 Thread Justin Hayes
. Any suggestions or tweaks that people have done would be great, before I start investigating what's going on at a lower level. Thanks, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com Discover RT's hidden secrets with RT

Re: [rt-users] Time taken to open ticket history

2010-06-08 Thread Justin Hayes
at too high a level in the code? Thanks, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 7 Jun 2010, at 21:53, Kenneth Marshall wrote: Hi Justin, The last time I looked at this problem, the slow step is simply

Re: [rt-users] Time taken to open ticket history

2010-06-08 Thread Justin Hayes
too late at this point for performance reasons, as we're already processing the entry? Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 7 Jun 2010, at 21:53, Kenneth Marshall wrote: Hi Justin, The last time I looked

[rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Justin Hayes
numbers from theirs for longer tickets? It would be really appreciated. Thanks, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http

Re: [rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Justin Hayes
takes anything up to 20+ seconds. So I'm not sure how the DB can be an issue here? Unless I'm wrong about it doing 1 big query at the start and there are loads of little queries inside the loop. Cheers, Justin - Justin Hayes OpenBet Support

Re: [rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Justin Hayes
- Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 29 Jun 2010, at 15:22, Jason Doran wrote: Hi, If you are using mysqld have a look at mysqltuner.pl perl script (google) This has fixed quickly many performance issues on both RT

Re: [rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Justin Hayes
- Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 29 Jun 2010, at 15:28, Charles Johnson wrote: Justin, thank you for the kindness of your reply. I didn't intend to send you chasing rabbits, so to speak. Just offering something to add

Re: [rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Justin Hayes
) interactive_timeout ( 28800) query_cache_size ( 16M) join_buffer_size ( 2.0M, or always use indexes with joins) tmp_table_size ( 128M) max_heap_table_size ( 64M) innodb_buffer_pool_size (= 10G) - Justin Hayes OpenBet Support Manager

Re: [rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Justin Hayes
- Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 29 Jun 2010, at 15:49, Foggi, Nicola wrote: I did just have a problem with 3.8.8 and one of the indexes (didn't have the problem on 3.8.6 or below). It turned out to be the index GROUPS2 on the Groups

Re: [rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Justin Hayes
out of mysql then... Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 29 Jun 2010, at 15:53, Justin Hayes wrote: Seem to be quite a few things to look at Jason. Need to figure out what they all mean first. Justin

Re: [rt-users] Slow Ticket History 3.8.8

2010-07-01 Thread Justin Hayes
We do Kenneth, but most tickets don't have many file attachments, so I assume that's not an issue? Cheers, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 29 Jun 2010, at 17:54, Kenneth Crocker wrote: Justin, I

Re: [rt-users] Slow Ticket History 3.8.8

2010-07-01 Thread Justin Hayes
the slow query log to troubleshoot bad queries Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** innodb_buffer_pool_size (= 10G) - Justin Hayes OpenBet Support

Re: [rt-users] Slow Ticket History 3.8.8

2010-07-01 Thread Justin Hayes
- Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 1 Jul 2010, at 11:51, Raed El-Hames wrote: Justin, Do you use Transaction custom fields, if you do n’t ; try and comment out lines 70,71,72 from html/Ticket/Elements/ShowTransaction % if ( $Transaction

Re: [rt-users] Slow Ticket History 3.8.8

2010-07-01 Thread Justin Hayes
* to be DB or server related, I just don't know how... Thanks, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 1 Jul 2010, at 12:28, Raed El-Hames wrote: Hi Justin; Our database is ~ 59G, the attachments table is ~ 40G

Re: [rt-users] Slow Ticket History 3.8.8

2010-07-01 Thread Justin Hayes
Thanks Alberto. Will look at those as well. Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 1 Jul 2010, at 14:42, Alberto Villanueva wrote: Have you read next links? Maybe you could be good for your server. http

[rt-users] 3.8.4 - Customers able to see tickets for queues they don't have rights on

2010-07-08 Thread Justin Hayes
. If I turn that off then at least they can't see things they shouldn't, but now the search results are very messed up and you might have to page until you can find a visible ticket. Justin - Justin Hayes OpenBet Support Manager justin.ha

Re: [rt-users] Scrips and Recipients section not picking up TransactionBatch scrips - 3.8.8

2010-07-13 Thread Justin Hayes
Is that this one Kenn? RT_Config.pm:Set($UseTransactionBatch, 1); Cheers, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 13 Jul 2010, at 16:52, Kenneth Crocker wrote: Justin, I hate to ask, but did you make sure

Re: [rt-users] 3.8.4 - Customers able to see tickets for queues they don't have rights on

2010-07-15 Thread Justin Hayes
Thanks Jesse. I know it's beta, but does fix some other issues so having it on was better than not, if you see what I mean :) I'm upgrading to 3.8.8 soon anyway which will fix it. Justin - Justin Hayes OpenBet Support Manager justin.ha

Re: [rt-users] Scrips and Recipients section not picking up TransactionBatch scrips - 3.8.8

2010-07-15 Thread Justin Hayes
- Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 13 Jul 2010, at 19:36, Kenneth Crocker wrote: Justin, Yep. But I'd make the change in RT_SiteConfig.pm. I like to leave original files/info alone in case I ever need to reference an original setting, etc. RT

Re: [rt-users] Scrips and Recipients section not picking up TransactionBatch scrips - 3.8.8

2010-07-15 Thread Justin Hayes
guy's going to be trying some of the settings you sent me, as there are lots of innoDB configs in there that we've not set at all. Hopefully we'll get somewhere. Cheers, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 15

[rt-users] Add a user to a group via RT CLI?

2010-07-30 Thread Justin Hayes
Is it possible to add a user to a group via the CLI? I can find the command to create a new user, and I can create a new group. But how can I put one in the other? Cheers, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com

[rt-users] Incremental page load stopped with 3.8.8

2010-08-26 Thread Justin Hayes
. Is that a deliberate change? Anyone know if there's a way to set it back to incremental? Thanks! Justin Justin Hayes Support Manager T: +44 208 742 1600 +44 208 987 0715 M: +44 779 337 2866 E

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-06 Thread Justin Hayes
of the same problems on that OS. Perhaps perl is just slow on the 64bit ubuntu we've currently got live. No idea if it's going to have any effect though :( Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 6 Sep 2010

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

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

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Justin Hayes
- Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 7 Sep 2010, at 10:30, Justin Hayes wrote: Tried Centos last night, and no difference at all. - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-07 Thread Justin Hayes
at that. We've also tried running the web services on a separate server to the DB. This also made no difference. Cheers, Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 7 Sep 2010, at 11:13, Torsten Brumm wrote: Hi

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-09 Thread Justin Hayes
We've tried all of those. We've also tried the RT inbuilt webserver and results were the same in all cases. - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 7 Sep 2010, at 11:36, Torsten Brumm wrote: Are you running mod_perl2

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-09 Thread Justin Hayes
Thanks Torsten. We'll have a look at those settings as well. Appreciate the help! Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 7 Sep 2010, at 12:45, Torsten Brumm wrote: Hi Justin, just created inside a RT Test VM

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-09 Thread Justin Hayes
- Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 7 Sep 2010, at 12:45, Torsten Brumm wrote: 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

Re: [rt-users] Slow Ticket History

2010-09-09 Thread Justin Hayes
for the patch! Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 7 Sep 2010, at 12:24, Tim Cutts wrote: On 6 Sep 2010, at 5:54 pm, rt-users-requ...@lists.bestpractical.com wrote: So far we've tried installing RT

Re: [rt-users] Slow Ticket History 3.8.8

2010-09-09 Thread Justin Hayes
the history rewrite in it. Going to try the patches from that other slow ticket history thread as well to see if that brings it down further. Justin - Justin Hayes OpenBet Support Manager justin.ha...@openbet.com On 9 Sep 2010, at 08:13, Justin

  1   2   >