On 11/3/2010 1:59 PM, Jesse Vincent wrote:
On Wed 3.Nov'10 at 10:45:54 -0400, Jeff Blaine wrote:
The "Spreadsheet" link exports TSV which completely botches
the data values associated with our custom fields. The
Custom Field data appears in all the wrong columns.
That'
The "Spreadsheet" link exports TSV which completely botches
the data values associated with our custom fields. The
Custom Field data appears in all the wrong columns.
Is this a known bug?
If I want to change the code in
share/html/Ticket/Elements/EditCustomFields by copying it to
a 'local' area, where would that be?
I have tried local/html/Ticket/Elements/EditCustomFields
(with Mason cache clear + restart) and the master copy
still seems to be chosen.
We want to show (in view *and* edit modes) some custom fields only
if SomeCustomField is set to "Yes"
Any tips where to start digging?
RT Training in Washington DC, USA on Oct 25 & 26 2010
Last one this year -- Learn how to get the most out of RT!
L
On Wed, Sep 29, 2010 at 10:28 AM, Jeff Blaine mailto:jbla...@kickflop.net>> wrote:
Kenn,
I still just suspect some sort of caching issue. There
is no specific RowsPerPage field for this in the DB schema
definitions themselves. Looking around, it seems this
data is
wonder if there is some setting that goes with this preference that I
am missing.
Kenn
LBNL
On Wed, Sep 29, 2010 at 9:26 AM, Jeff Blaine mailto:jbla...@kickflop.net>> wrote:
3.8.7 here, no problem setting it to 10 and getting 10
On 9/29/2010 12:20 PM, Kenneth Crocker wrote:
3.8.7 here, no problem setting it to 10 and getting 10
On 9/29/2010 12:20 PM, Kenneth Crocker wrote:
To list,
I'm noticing that when I change my "Preferences" setting for search
limits on rows returned, it's basically ignored. I usually have it set
at 50 (and to be honest, I haven't really spen
ain VACUUM would."
We *did* in fact RT-Shredder-ify 50% of the tickets 4
weeks ago (bogus tickets from the user's misconfigured code).
At any rate, VACUUM FULL ANALYZE solved the problem, which
should be addressed going forward by auto-vacuum.
Thanks again
Cheers,
Ken
On Wed, Sep 2
ics updated and run a full
database-wide re-analyze to update the stats. Then try your query again.
Regards,
Ken
On Wed, Sep 22, 2010 at 12:57:58PM -0400, Jeff Blaine wrote:
We have this in place:
CREATE INDEX ObjectCustomFieldValues3 ON ObjectCustomFieldValues
(ObjectId,ObjectType);
ostgreSQL old. Certainly there have
been many, many performance improvements since v8.1.x. While
upgrading would help, you really need to run an EXPLAIN ANALYZE
for your slow queries to see if there is a problem area. Also,
you should check to wiki to see if you have all of the recommended
PostgreSQL i
Please bear with my ignorance on this topic. I realize
this isn't a PostgreSQL tuning forum, but since it's RT-related
I thought I'd ask here.
RT 3.8.7 (and RTFM) with PostgreSQL 8.1.18 via RHELv5 running
as a VM.
We're experiencing significant delays today with various
PostgreSQL statements ta
On 9/8/2010 9:24 AM, Steven Platt wrote:
Hi,
I'm trying to achieve this using a chopped version of
http://wiki.bestpractical.com/view/SetOwnerAndQueueBySubject and some
wisdom clipped from elsewhere in the wiki (some of the scrips pages, I
forget exactly which), and here is what I have:
Condi
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
Is there any way to prioritize Scrips? Or perhaps someone
can suggest something else based on the following?
I'm doing something in Scrip 1 that may alter custom field X
(employee numbers).
Scrip 2 which is in place and working fine right now has the
job of looking up some employee details for
;Deleted' AND LastUpdated< '30 days
ago';limit,100" --sqldump /{somepath}/shredder-restore-tickets.sql
Might contain your answer - found that
http://wiki.bestpractical.com/view/Shredder
Peter
On 21 Jul 2010, at 18:20, Jeff Blaine wrote:
I searched around and couldn't
I searched around and couldn't find the answer. How does one
override the default 10 object threshold with rt-shredder?
Using RT 3.8.7
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Jul 6 20:11:11 rtx sendmail[23530]: o671BA52023529:
to="|/home/rtx/bin/rt-mailgate --queue QR-Help --action correspond
--url http://rtx.mydomain.com/ --debug ",
ctladdr= (8/0), delay=00:00:01,
xdelay=00:00:01, mailer=prog, pri=35277, dsn=4.0.0, stat=Deferred:
prog mailer (/usr/sbin/smrsh) exited
)
using lower(upper(abc)) == abc since it would produce
ab == abc and fail. I think that you may be seeing something
like that with your dot character.
Regards,
Ken
On Mon, May 17, 2010 at 03:30:27PM -0400, Jeff Blaine wrote:
On 5/17/2010 3:26 PM, Kenneth Marshall wrote:
Hi Jeff,
Those are j
em. What is the collation of an attachment
that matches one query but not the other?
Thanks for the reply.
I'll gladly provide any info I can, but you're talking over
my head re: collation. Can you provide some more info? I'm
not a DB person.
Ken
On Mon, May 17, 2010 at 03:20:
attachment
that matches one query but not the other?
Thanks for the reply.
I'll gladly provide any info I can, but you're talking over
my head re: collation. Can you provide some more info? I'm
not a DB person.
Ken
On Mon, May 17, 2010 at 03:20:00PM -0400, Jeff Blaine wrote
ery, then the problem is somewhere
else. If the query differs, try running the query manually to
see why it is giving unexpected results. Again as others have
mentioned, collation/encoding could cause these types of differences.
Cheers,
Ken
On Mon, May 17, 2010 at 02:48:49PM -0400, Jeff Blaine wr
Another example of this failing:
rt list -t ticket "Content like members.linode AND Owner = jsmith"
14 results
rt list -t ticket "Content like linode AND Owner = jsmith"
77 results, all of which have "members.linode" in the content.
On 4/26/2010 5:32 PM, Jeff Bl
[ Answering self ]
# custom condition
if ($self->TransactionObj->Type eq "Create") {
return 1;
}
# other custom condition code here...
On 5/10/2010 2:43 PM, Jeff Blaine wrote:
Probably an easy answer to this one.
I have a custom condition for a scrip
Thanks Eleanor
Duh!
On 5/10/2010 2:23 PM, Eleanor J. Evans [Panix Staff] wrote:
On Mon, May 10, 2010 at 02:15:36PM -0400, Jeff Blaine wrote:
Name:Occurred Date
Applies to: Tickets
Type:Enter multiple values
Validate:(?#-MM-DD)^\d\d\d\d-\d\d-\d\d$
Creating a new
Probably an easy answer to this one.
I have a custom condition for a scrip which deals with a
custom field. The condition and the rest of the code all works
great, except when the submitted ticket is *brand new*
(New ticket in --> queuename).
I would like to add to my custom condition logic to
RT 3.8.7
I must be misunderstanding something, because as I see it, it
appears that defining a validation regexp for a Custom Field
causes that Custom Field to be non-optional.
Name:Occurred Date
Applies to: Tickets
Type:Enter multiple values
Validate:(?#-MM-DD)^\d\d\d\d
RT 3.8.7
Just found a custom field whose name was "Shared with ABC "
Trying to reference it in a Scrip as "Shared with ABC"
(lacking trailing space) failed, of course.
I can't think of any reason to allow trailing whitespace
in CF names, so I consider this a bug.
Discover RT's hidden secrets w
On 4/29/2010 5:16 AM, Raed El-Hames wrote:
> I really do not understand why you would need nagios for this?
I highly doubt they installed Nagios *just* for this.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Carlos, I was going to respond the same way, but that
is more than "cc a group when a ticket is filed"
^
On 4/27/2010 2:18 AM, Carlos Garcia Montoro wrote:
Add the group as a CC watcher of the queue (or ticket) that you are
interested in.
For queues
of data you should really plan on using the full-text index
support for PostgreSQL/RT that is described in the wiki.
Speaking as one whose database was brought to its knees by
some creative data mining. :)
Good luck and let us know what you find to be the cause.
Regards,
Ken
On Mon, Apr 26, 20
correctly
as valid matches. I believe that the PostgreSQL release
notes mentioned that need. Maybe that is your problem. We
are using RT-3.8.5 and PostgreSQL 8.4.2 here with the full-text
support without an issue.
Regards,
Ken
On Mon, Apr 26, 2010 at 03:00:39PM -0400, Jeff Blaine wrote:
On 4/26/2010
it comes with RHELv5 + updates from yum
Clearing the Mason cache didn't help :|
Cheers,
Ken
On Mon, Apr 26, 2010 at 12:47:22PM -0400, Jeff Blaine wrote:
On 4/26/2010 12:29 PM, Raed El-Hames wrote:
Jeff;
Does your CLI user have permissions on the queue that ticket 39 is in??
login to th
om
foo.com blah blah... 1 line... not including in this email
[r...@rtsrv1 etc]#
[r...@rtsrv1 etc]# /apps/rt/bin/rt show 23 | grep foo.com
foo.com blah blah... not including in this email
foo.com matching lines 66 more times... not including in this email
[r...@rtsrv1 etc]#
Regards;
Roy
Jeff
RT searching
for 'foo.com'
Ticket 39 has 1 of those parts and is not returned when RT searching
for 'foo.com'
By "DB query logging" do you mean Set($StatementLog, "DEBUG");
or something?
Thanks for the reply, Ken
Jeff
Cheers,
Ken
On Mon, Apr 26, 2010 at 11:21
Does anyone have any suggestions for how to go about
figuring out what is wrong here?
On 4/22/2010 2:09 PM, Jeff Blaine wrote:
RT 3.8.7
A search for 'Content matches foo.com' is returning some tickets
and missing others that clearly have foo.com in the Content.
[r...@rtsrv1 bin]#
RT 3.8.7
A search for 'Content matches foo.com' is returning some tickets
and missing others that clearly have foo.com in the Content.
[r...@rtsrv1 bin]# ./rt show 39 | grep foo.com | wc -l
1
[r...@rtsrv1 bin]#
[r...@rtsrv1 bin]# ./rt show 23 | grep foo.com | wc -l
67
[r...@rtsrv1 bin]#
23 sh
A. Thanks.
On 4/19/2010 1:21 PM, Jeff Voskamp wrote:
On 04/19/2010 01:12 PM, Jeff Blaine wrote:
I've searched and found no previous thread on the topic.
Before I start digging around in RT 3.8.7 files...
Priority does not show up in our RT when using 'Create
New Ticket In...
I've searched and found no previous thread on the topic.
Before I start digging around in RT 3.8.7 files...
Priority does not show up in our RT when using 'Create
New Ticket In..." and we'd like it to. Is something
broken, or is it correct and we'll need to make local
mods?
Discover RT's hidde
On 4/12/2010 1:47 PM, Kevin Falcone wrote:
On Mon, Apr 12, 2010 at 12:51:37PM -0400, Jeff Blaine wrote:
Is it possible to use FCKeditor for editing RTFM stuff?
No.
Any brief further info you could provide on the topic would be
great. Like, "Would require massive code changes.&quo
Is it possible to use FCKeditor for editing RTFM stuff?
How?
Thanks!
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Nevermind. I figured it out. Based on the number of results
I found regarding this problem when searching, perhaps it
needs to be noted more strongly what one must do to get an
actual working RT instance?
On 4/1/2010 3:16 PM, Jeff Blaine wrote:
For some reason we cannot get the 'Co
For some reason we cannot get the 'Content' portion of an
RTFM article to be displayed as editable content.
RT 3.8.7 and RTFM 2.4.2
The users in question (myself included) have all RTFM privs.
Any ideas?
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://
We have a need to hide (ideally) certain standard RT fields
from privileged users.
I don't see that this is possible with the standard rights
controls.
Is that accurate?
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
I have never once installed RT with 'make fixdeps'
actually working 100% to completion with all
Perl modules built and installed.
You're going to have to watch the 'make fixdeps'
output and solve any problems by hand, then re-run
(wash, rinse, repeat).
On 3/31/2010 5:20 AM, Jnaneshwar Bantanur w
riate debug lines are logged when one is viewing
an "initial" Modify.html. There is, in my case, the appro-
priate single custom field noted as modifiable.
b) As a 'result' page, debug lines are logged indicating EVERY
field is modifiable
c) All debug lines in a + b ind
On 3/29/2010 7:04 PM, Jesse Vincent wrote:
On Mon, Mar 29, 2010 at 06:50:27PM -0400, Jeff Blaine wrote:
Just sharing. This is how I disabled editing of certain custom
fields via the web UI.
Part 1: Make the word READONLY appear in your custom field's
description.
Part 2: Edit
Just sharing. This is how I disabled editing of certain custom
fields via the web UI.
Part 1: Make the word READONLY appear in your custom field's
description.
Part 2: Edit share/html/Tickets/Elements/EditCustomFields
(or whatever proper 'local' file :)) to look like this
The solution that worked for me last night
was to run completely separate instances of
httpd for each RT instance, instead of using
vhost definitions under 1 httpd instance.
On 3/23/2010 6:26 PM, Jeff Blaine wrote:
Adding some 'warn' statements to Mason/Resolver/
r in the installed tree under
/apps/rt_rtsrv1_dev/*
On 3/23/2010 3:34 PM, Jeff Blaine wrote:
And...
the following in RT_SiteConfig.pm does not help (a
solution that worked for someone in 2009):
Set($MasonComponentRoot, "/apps/rt_rtsrv1_dev/share/html");
Set($MasonLocalComponentRoot, "/app
dev/var/mason_data");
Set($MasonSessionDir, "/apps/rt_rtsrv1_dev/var/session_data");
:(
On 3/23/2010 3:30 PM, Jeff Blaine wrote:
This is 3.8.7 + mod_perl
On 3/23/2010 2:57 PM, Jeff Blaine wrote:
This has me really scratching my head. If it makes any
difference, this host (rtdev1) serves two
This is 3.8.7 + mod_perl
On 3/23/2010 2:57 PM, Jeff Blaine wrote:
This has me really scratching my head. If it makes any
difference, this host (rtdev1) serves two separate RT
instances, each on different ports. The other is working
fine
rtdev1 RT: [Mason] Cannot resolve file to component
This has me really scratching my head. If it makes any
difference, this host (rtdev1) serves two separate RT
instances, each on different ports. The other is working
fine
rtdev1 RT: [Mason] Cannot resolve file to component:
/apps/rt_rtsrv1_dev/share/html/index.html (is file outside component
On 3/23/2010 11:07 AM, Kevin Falcone wrote:
On Mon, Mar 22, 2010 at 01:13:03PM -0400, Jeff Blaine wrote:
Hmm, I never saw Kevin Falcone's original response until
I browsed the rt-users archive just now.
http://lists.bestpractical.com/pipermail/rt-users/2010-March/063739.html
Which versi
Hmm, I never saw Kevin Falcone's original response until
I browsed the rt-users archive just now.
http://lists.bestpractical.com/pipermail/rt-users/2010-March/063739.html
Which version of DateTime do you have installed?
perl -MDateTime\ 9
-kevin
Answer: the latest from CPAN
# perl -MDateTi
> Custom Condition:
> if ($self->$ticket->OwnerObj->Owner eq 'userid') {
> return 1;
> }
This says:
if value for 'Owner' field matches the *literal string*
'userid' return 1
I doubt that's what you want.
___
http://lists.bestpractical.com/cgi-bin
I need to write a custom Condition for a scrip that
equates to 'If Custom Field X's value changed'
Is there an API call for doing that, or do I need to
code the logic to retrieve the old + new values and
compare them? I can't seem to find a single call for it,
but I wanted to check.
RT 3.8.7
___
RT 3.8.7
I'm looking to establish a read-only custom field, writable
only by $RT::SystemUser (in a scrip).
In trying to do so, I have made the rights to this custom field
'SeeCustomField' by some people, but nobody has ModifyCustomField
permissions.
That is:
there are no defined user right
I'm looking to fill in custom fields with data retrieved
from an LDAP server.
That is, someone with permission to modify an existing
ticket will enter some data into a custom field, then
save the modification. At save time, the code will
use that custom field to populate another custom field
with
Has anyone done this? I have the mod_ssl portion of this
up and working (requiring valid client certificate for
SSL negotioation), but don't really know where to look
for hooking that into RT authentication.
___
http://lists.bestpractical.com/cgi-bin/mai
RT-Authen-ExternalAuth-0.08
Please see 'Cannot determine...' and Warning below. What
are these? What is broken?
...
Using RT configuration from /apps/rt/lib/RT.pm:
./etc => /apps/rt/local/plugins/RT-Authen-ExternalAuth/etc
./html => /apps/rt/local/plugins/RT-Authen-ExternalAuth/html
./lib
Hi folks -- does anyone have any idea what is wrong here?
'make testdeps' was perfectly happy at install time and
everything else appears to work just fine.
RT 3.8.7
Preferences -> About Me
Error during compilation of /apps/rt/share/html/Elements/SelectTimezone:
Can't locate object method "now"
201 - 261 of 261 matches
Mail list logo
