[rt-users] Re: RT 4

One thing I saw mentioned was Mandatory field support - we implemented a pretty robust Mandatory field system in RT here with a separate checkbox so that validation and Mandatory are separate. Also pushed all the code into the core API so it works via REST, email and GUI. This has been submitted

RE: [rt-users] Slow ticket search page becoming a problem

The problem seems to be caused by the ORDER BY clause. If I remove this, it's very fast. PK From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Thursday, April 26, 2007 6:00 AM To: Todd Chapman Cc: Philip Kime; RT Users Subject: Re: [rt-users] Slow ticket

RE: [rt-users] Slow ticket search page becoming a problem

that this would need a SearchBuilder mod to force the use of the index related to the ORDER BY clause? PK From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Thursday, April 26, 2007 6:00 AM To: Todd Chapman Cc: Philip Kime; RT Users Subject: Re: [rt-users] Slow ticket

RE: [rt-users] Slow ticket search page becoming a problem

PROTECTED] Sent: Thursday, April 26, 2007 5:34 PM To: Philip Kime Cc: Jesse Vincent; Todd Chapman; RT Users Subject: Re: [rt-users] Slow ticket search page becoming a problem Philip, please try the following query and send us times and EXPLAIN: SELECT STRAIGHT_JOIN DISTINCT main.* FROM ACL ACL_4

[rt-users] Slow ticket search page becoming a problem

: 1 Extra: Using where; Distinct -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED

RE: [rt-users] Really slow Search page startup suddenly

It's happening all the time now for some reason. This is really odd - it just seems to have started - here's a typical example - state is Copying to tmp table during the execution: # Time: 070406 17:25:05 # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] # Query_time: 38 Lock_time: 0

[rt-users] Really slow Search page startup suddenly

.Domain = 'RT::Queue-Role') OR (Groups_3.Domain = 'RT::System-Role')) ORDER BY main.RealName ASC; -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http

RE: [rt-users] Really slow Search page startup suddenly

Hmm - not that I know of - we don't have that many users, even if they could all own tickets, it would be about 1300 users. Is that large enough to be a problem? Normally the Owner list is less than 100 users so I could check if someone did something. It seems back to normal now though ... I

[rt-users] RE: [ANNOUNCE] A new faster shredder machine available

Nice work Ruslan - this version (with the index additions) reduces the single ticket shredding time down from 5 minutes to about 7-8 seconds. PK ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help:

RE: [rt-users] Longgggg ticket taking a while to load

but didn't see any memcached API calls in there ... PK -Original Message- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 07, 2007 11:35 AM To: Philip Kime Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Long ticket taking a while to load On Thu, Mar

[rt-users] memcached

Has anybody tried using memcached in front of RT? http://danga.com/memcached/ -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com

[rt-users] Upgraded Perl and apache/mod_perl and now a few things are really slow ...

, it doesn't seem to be a DB problem? I did re-compile and install all the RT required perl modules from scratch - perhaps a newer version of some module isn't working properly - anyone know of anything like this? Any ideas? PK -- Philip Kime NOPS Systems Architect 310 401 0407

RE: [rt-users] Upgraded Perl and apache/mod_perl and now a few things are really slow ...

Vincent [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 5:21 PM To: Philip Kime Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgraded Perl and apache/mod_perl and now a few things are really slow ... On Thu, Mar 01, 2007 at 05:18:35PM -0800, Philip Kime wrote: RT 3.6.3

[rt-users] Negative search on multi-CF: broken in 3.6.3?

RT 3.6.3 select or enter multi-field with values: XX YY Then search with CF.{field} NOT LIKE 'XX Returns the ticket, but shouldn't. Anyone else? -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin

[rt-users] Longgggg ticket taking a while to load

and/or MASON stuff and it takes about 15 seconds to load until it gets cleared out of the cache. I wonder if there is a DB index we might add for this? Anybobody else had this? RT 3.6.3 PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http

[rt-users] sessions table size

My sessions table in rt (MySQL) is 1.2Gb. Is this normal? I thought it was fairly temporary data? We have only about 100 users, more automated jobs really but I was surprised to see this so large. It's accounts for nearly 50% of the size of the whole DB. PK -- Philip Kime NOPS Systems

RE: [rt-users] sessions table size

Groan, can't believe I missed this, many thanks. PK -Original Message- From: Tim Rosmus [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 1:44 PM To: Philip Kime Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] sessions table size On Wed, 28 Feb 2007, Philip

[rt-users] CommandByMail question - not falling back to standard mail gateway

with commands, fallback to standard mailgate. And the standard mailgate succeeds. Can we turn off the standard one or disable fallback? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo

[rt-users] Re: RT 3.6.3 Mandatory CF's

Eric Schultz wrote: I thought that using the current interface, if you wanted to make something non- mandatory, you could just wrap a '()?' around it (not including quotes)? I'm pretty sure I've seen that posted to the mailing list as well. You can, but when you try to make sure the other

[rt-users] Suggestions for auto-archiving?

to a different server/DB/RT instance. This probably needs doing at an RT API level to catch all the links etc. PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http

[rt-users] RE: Asset Tracker with RT 3.6

We use AT with older version of RT (3.4.5). Does anyone use it with RT 3.6? Does it work with the most recent RT? Yes, we use Asset Tracker heavily and recently upgraded from 3.4.5 to 3.6 without any problems. One thing I found using the RT make upgrade or whatever is that is chmod'ed the

[rt-users] RE: RT-3.6.3 and RTFM 2.2.0RC4 - how to create custom fields?

PROTECTED] On Behalf Of Bob Goldstein Sent: Sunday, January 21, 2007 8:13 PM To: Philip Kime Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-3.6.3 and RTFM 2.2.0RC4 - how to create custom fields? In my RT: RTFM - Configuration - Custom Fields (under the RTFM heading) - New Custom

[rt-users] Issue with multiple attachments on 3.6.3

you're adding attachments, they are around longer to be stomped on so you only see this (and not always) when adding multiple attachments? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman

RE: [rt-users] RT-3.6.3 and RTFM 2.2.0RC4 - how to create custom fields?

Hmm - that's exactly what mine doesn't have ... PK -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Goldstein Sent: Sunday, January 21, 2007 8:13 PM To: Philip Kime Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-3.6.3 and RTFM

[rt-users] RT-3.6.3 and RTFM 2.2.0RC4 - how to create custom fields?

the usual Tickets Groups Users Assets Ticket Transactions Should I be seeing somthing else? This is a fresh install of RTFM, no previous version. PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman

[rt-users] Re: Timezone wrong in apache error logs.

I would doublecheck the environment for the user Apache is running as. It sounds like that particular user might have a different timezone set. I don't think so - the access logs for apache are all correct, it's only the error logs and it seems to be wrong and then, it's only the errors which

[rt-users] RT 3.6.3 (and earlier) logs via RT::Logger in gmttime only?

Line 239 of RT.pm seems to be why all errors coming from RT in my apache logs have the wrong timezone - it uses gmttime for the stamps - shouldn't this be localised? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http

[rt-users] Re: Status of RTx::AssetTracker

Todd Chapman maintains Asset Tracker and lurks on these lists. I believe that the wiki site for AT is on a personal machine of his so it's not reliably up and it's been wiki-spammed a few times. I think he switched jobs recently so there hasn't been an update in a year or so. But we sed AT 1.2.3 a

[rt-users] Timezone wrong in apache error logs.

-- Philip Kime NOPS Systems Architect 310 401 0407 ___ 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 Essentials

[rt-users] SSL connection from RT-MySQL?

-- Philip Kime NOPS Systems Architect 310 401 0407 ___ 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 Essentials

[rt-users] RE: RT on database in read-only mode?

Look into config. Change session class to Apache::Session::File. Excellent- that's exactly what I needed, I had missed this when looking through the config. I had done it by changing the permissions for the rt_user DB user on all tables except the sessions table but this is much neater. Many

[rt-users] RT on database in read-only mode?

for session data etc. so that the DB can be completely read-only? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support

[rt-users] How to reject email outside of a certain domain?

? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ 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] How to reject email outside of a certain domain?

You can probably override LoadOrCreateByEmail to check the email address. That's useful for another problem I have - wanting to reject adding arbitrary watcher emails, thanks. It seems that rt-mailgate already has a mechanism for doing things like this. I altered

[rt-users] Disable auto-create users when added as watchers?

I'd like to disable the auto-creation of users when added as watchers (so it gives an error if the user/email added doesn't exist in RT) - is this possible? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com

[rt-users] Wierd search results with multiple-valued fields ...

here a way, for example, of saying "show me everything which hasno value matching 'X' CF.{somfield} != 'X' seems to be saying "show me everything which has *any* value which doesn't match 'X' PK -- Philip Kime NOPS Systems Architect 310 401 0407

[rt-users] binary attachment difference in REST between 3.4.5 and 3.6.1

fine in the GUI for both versions - the attachments open fine, it's only when I get them over REST. PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http

[rt-users] Problem creating users when LDAP overlay is enabled

to set the information in LDAP when I create a new user and if so, that means I need to use an LDAP account in the configs which has write access to AD? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin

[rt-users] Re: 3.6 to 3.6.1 server migration

I wrote that srtciale actually ... I've just done a 3.6.0 to 3.6.1 migration - there are no schema changes so all you need to do is a dump and import, that's it. Be aware that 3.6.1 needs a couple of extra Perl modules though - do a make testdeps in the 3.6.1 tree to check for these. PK

[rt-users] rt command commaent -a for adding attachments - MIME type

Using "rt comment -a" in rt 3.6.x seems to always attach the file as text/plain. Is there any way to change the encoding? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinf

[rt-users] LDAP overlay question

but will not let the user log on with the AD password, only the internal RT one. * What about true Single-Sign on? That it, it automatically logs you into RT if you are already logged into the AD domain? Would this need to be done with the Apache mod_ldap extension? PK -- Philip Kime NOPS

RE: [rt-users] RT and LDAP authentication (Win2k AD)

Yes, both set ... DEBUG output doesn't tell me anything, just that it failed to authenticate. PK -Original Message- From: Helmuth Ramirez [mailto:[EMAIL PROTECTED] Sent: 11 August 2006 07:00 To: Philip Kime; rt-users@lists.bestpractical.com Subject: RE: [rt-users] RT and LDAP

[rt-users] LdapAutocreateAuthCallback breaks rt command?

response from the server, which is confusing the RT command? If I remove /usr/local/rt/local/html/Callbacks/LDAP/autohandler/Auth it works fine again. Any ideas? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi

[rt-users] RT and LDAP authentication (Win2k AD)

Aug 11 03:49:33 2006] [error]: FAILED LOGIN for user from 192.168.0.100 (/usr/local/rt/share/html/autohandler:238) -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help

[rt-users] Custom Fields query vs. CLI edit syntax inconsistencies

Why don't they both use the same syntax for referencing custom fields? I'm not sure that's necessarily a bad thing - the REST syntax for CF editing is nice and simple for scripting - the curly brackets would make things more complicated to parse and generally use. When I was deciding on a

RE: [rt-users] Custom Fields query vs. CLI edit syntaxinconsistencies

possible (and easier) to modify the REST search function to allow CF- as well as CF.{}. What about that? PK -Original Message- From: Joshua Colson [mailto:[EMAIL PROTECTED] Sent: 22 June 2006 12:56 To: Philip Kime; Jesse Vincent Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users

RE: [rt-users] Custom Fields query vs. CLI edit syntaxinconsistencies

Here's a simple patch to $rtroot/share/html/REST/1.0/search/ticket to enable searches to use either format *** /usr/local/rt/share/html/REST/1.0/search/ticket 2006-05-25 21:11:58.0 -0700 --- /tmp/ticket 2006-06-22 14:57:12.634046264 -0700 *** *** 82,87 --- 82,91

RE: [rt-users] [Rt-announce] RT 3.6.0 Released

I had the same problems with the stylesheets in 3.6.0 until I cleared my *browser's* cache. PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http

RE: [rt-users] The fsck.com-rt- URI scheme

. PK -Original Message- From: Jason Fenner [mailto:[EMAIL PROTECTED] Sent: 12 June 2006 13:35 To: Philip Kime Cc: Todd Chapman; RT users Subject: Re: [rt-users] The fsck.com-rt- URI scheme What is this URI used for in RT? How does RT use it? Philip Kime wrote: I was more wondering how

[rt-users] The fsck.com-rt- URI scheme

links etc. and every ticket like comes out as "fsck.com-rt-" ... PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commer

RE: [rt-users] The fsck.com-rt- URI scheme

You may well not have done ... I just remembered something about wanting to take it away but not wanting to break too much stuff ...? PK -Original Message- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: 11 June 2006 13:59 To: Philip Kime Cc: RT users Subject: Re: [rt-users

[rt-users] RE: Strange message when changing Select One Value CFs inRT 3.4.5

There seems to be the same issue in RT 3.6 too ... Thanks for the patch - I'll try it out. -Original Message- From: Schultz, Eric [mailto:[EMAIL PROTECTED] Sent: 07 June 2006 12:38 To: Philip Kime; RT users Subject: RE: [rt-users] Strange message when changing Select One Value CFs inRT

[rt-users] RE: Strange message when changing Select One Value CFs inRT 3.4.5

Fixed - thanks - the code was in $rtroot/lib/RTx/AssetTracker/Interface/Web.pm and exactly the same fix fixed it ... PK -Original Message- From: Schultz, Eric [mailto:[EMAIL PROTECTED] Sent: 07 June 2006 18:14 To: Philip Kime; RT users Subject: RE: Strange message when changing Select

[rt-users] Strange message when changing Select One Value CFs in RT 3.4.5

comes from CustomField_Overlay.pm)- it looks like it tries to change it twice and fails the second time because the value is already changed? Any comments? Is this a bug? PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.c

[rt-users] Known bug in RT 3.4.5 with disabled Group display?

the rights on the invisible, disabled one and confused the hell out of me ... $Group-LoadUserDefinedGroup found the disabled group first when loading the group by name ... PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.c

[rt-users] RE: Confused by Custom field rights

Actually, you're quite right - I hadn't factored in that CFs can be applied to different Queues. PK -Original Message- From: Kenneth Crocker [mailto:[EMAIL PROTECTED] Sent: 01 June 2006 09:53 To: Philip Kime Cc: Joshua Colson; RT users Subject: Re: [rt-users] RE: Confused by Custom

[rt-users] Confused by Custom field rights

on assets but this seems to not work - I can't modify any ticket custom fields any more and it only works again when I put the right back on the global Privileged group. PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http

[rt-users] AT REST interface implementation

it's REST, after all ...) PK -- Philip Kime NOPS Systems Architect 310 401 0407 Design notes Custom fields in the CLI use prefix CF_. This makes them obvious and avoids possible conflicts if people have Custom Fields named things like Type and Status. This doesn't apply to the us

[rt-users] RE: Should $RT::SystemUser be able to do arbitrary things?

Ouch ... My script managed to remove the first 80 or so entries I that table ... PK -Original Message- From: Ruslan Zakirov [mailto:[EMAIL PROTECTED] Sent: 26 May 2006 11:51 To: Philip Kime Cc: RT users Subject: Re: [rt-users] Should $RT::SystemUser be able to do arbitrary things? Ceck

[rt-users] Should $RT::SystemUser be able to do arbitrary things?

not the "root" RT user is it? Where are it's rights assigned? I now have to load a "real" user in scripts to get permissions to do anything ... -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin

[rt-users] RE: Why would I want to ...

I think that the problem I see is that the Watcher Roles do two things - they mean that people get certain email notifications and they also provide a mechanism for rights application. If one needs/wants to keep these separate, it can be confusing. For example, if you want some people to get email

[rt-users] Why would I want to ...

want to assign rights via them ... PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover

[rt-users] Where is the fsck.com coming from?

In the REST interface for 3.4.5, when I show a ticket's links: /usr/local/rt/bin/rt show ticket/47126/linksid: ticket/47126/linksDependedOnBy: fsck.com-rt://blah.com/ticket/47125 ?? Surely the link should just read rt://blah.com/ticket/47125 ? -- Philip Kime NOPS Systems Architect

[rt-users] Bug in RT 3.4.5 REST CLI

;rt" cli script tries to numerically sort ids even when the only id is "new". I just put this in the subroutine to fix it: return $list if $list eq "new"; -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http:/

[rt-users] Re: How to debug RT3 better

It's currently working except from the approval link which doesn't show anything even I selected pending, approved or denied, etc. One thing I found when implementing an Approvals system was that testing is impossible without two user IDs. If you try to open a ticket needing approval and try

[rt-users] Re: Upgrade/migration path for RT 3.2.0 - Current Rev

I have RT 3.2.0 running on RHEL 3.0 on an old server that is on its way out the door. I have literally just done this from 3.2.1 to 3.4.5+AT. I have a detailed migration plan that I wrote for it and I would be happy to send it to you. It's not a big deal to do. I even upgraded the Perl and

[rt-users] SOLVED: temp directories and File::Temp problem

by just running the code in perl (this works - it's when it's run under mod_perl that there is a problem), it's almost certainly this. PK -- Philip Kime NOPS Systems Architect 310 401 0407 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt

[rt-users] RE: RT-Users Digest, Vol 25, Issue 63

Replying to myself ... The error is coming from rt path/lib/RT/EmailParser.pm line 624 At the File::Temp::rmtree command The error says Directory not empty, which is somewhat beside the point since it's rm*tree* ... but this usually denotes permissions problems, but the permissions seem to be