Re: [rt-users] Adding additional Grouped by fields to bar and pie charts (3.8.1)

2008-10-17 Thread Jesse Vincent
On Tue 7.Oct'08 at 20:01:52 -0400, David Anderson wrote: >When I create a query and select to view a chart of it, I can select a >drop down with a list of group by fields that allows me to organize my >chart. Does anyone know how I would go about adding additional Group by >option

[rt-users] Issue Installing RT

2008-10-17 Thread AMIT K. SHARMA ( Gmail )
Hi, I am struggling for installing RT on a linux box. During the installation its not able to find all the dependencies. the following 2 are missing and i am unable to find it on the net. Time-Parseclate Mail-mimer Any help would be appreciated. ~Amit ___

Re: [rt-users] help with scrip

2008-10-17 Thread Violetta Wawryk
Hi Rene, brauch mal dringend hilfe vom perlguru. ich möchte was abfrage und zwar wenn ich im subject akut *nicht* drinnen steht dann solls zutreffen $self->TicketObj->Subject !=~ /[A|a]kut: / --> tut nicht $self->TicketObj->Subject !~ /[A|a]kut: / --> tut nicht wie muss das denn richtig heiss

Re: [rt-users] help with scrip

2008-10-17 Thread Violetta Wawryk
Hi, >> > if ($self->TransactionObj->Type eq "Create" && >> > ($self->TicketObj->Subject !=~ /[P|p]roje[c|k]t: / || >> > $self->TicketObj->Subject !=~/[A|a]kut: / ) ) > > I'm pretty sure that && is a higher precedence than ||, so the result > without parentheses would be the same as ( ( A

[rt-users] RT-Authen-ExternalAuth-0.05

2008-10-17 Thread Jason Doran
Hi, I am using RT-Authen-ExternalAuth-0.05 and all is generally good. Our users are in OpenLDAP which looks something like the following. dc=ourdomain,dc=ie ou=Users ou=Students ou=50 uid=501.. uid=502...

Re: [rt-users] help with scrip

2008-10-17 Thread Violetta Wawryk
sorry, the german mail was not meant for the mailinglist *args* -- Vorstand/Board of Management: Dr. Bernd Finkbeiner, Dr. Florian Geyer, Dr. Roland Niemeier, Dr. Arno Steitz, Dr. Ingrid Zech Vorsitzender des Aufsichtsrats/ Chairman of the Supervisory Board: Prof. Dr. Hanns Ruder Sitz/Registered O

[rt-users] scrip change customfieldvalue on certain value

2008-10-17 Thread Violetta Wawryk
Hi, has anyone a scrip or an idea how my condition for the following situation has to be written? My customfield called "CFA" has for example the value "value1" and "value2". The value is currently set to "value1". I now want my scrip to check wheather the value has changed and to which value

[rt-users] E-mail Templates are only a single character

2008-10-17 Thread Timothy Butkiewicz
I applied the following (sql.queries output) to our RT database (mysql 4.1.18) and now my e-mail templates only list a single character. It appears to be the first character of the template. Like S or R. ALTER DATABASE rt3 DEFAULT CHARACTER SET utf8; ALTER TABLE ACL DEFAULT CHARACTER SET utf8; ALT

Re: [rt-users] E-mail Templates are only a single character

2008-10-17 Thread Panu
> ALTER TABLE Templates MODIFY Content CHAR NULL DEFAULT NULL; > ALTER TABLE Templates MODIFY Content BLOB NULL DEFAULT NULL; I think this is the problem. I had the same happening to me. Ole Graig told me the following: --- cut --- the sql.queries file that I got out of running "etc/upgrade/sch

Re: [rt-users] E-mail Templates are only a single character

2008-10-17 Thread Timothy Butkiewicz
Thanks I will check this. As it appears that my templates are hosed, could you send me a copy of the "Content" for one of your templates, say Autoreply? I pulled the data from initialdata, but rt.log spits an error: Template parsing error: Can't find string terminator "'" anywhere befor

[rt-users] Merged Ticket Performance Degredation

2008-10-17 Thread Damon Miller
Hi all, We're experiencing an issue with RT 3.6.1 wherein loading merged tickets results in severe performance degredation, e.g. 100 - 300 seconds per ticket. After 30 seconds, Apache gives up on the FastCGI script and generates a 500. This problem has been documented and referenced in several p

Re: [rt-users] Merged Ticket Performance Degredation

2008-10-17 Thread Mark Blackman
On 17 Oct 2008, at 16:39, Damon Miller wrote: > Hi all, > > We're experiencing an issue with RT 3.6.1 wherein loading merged > tickets > results in severe performance degredation, e.g. 100 - 300 seconds per > ticket. After 30 seconds, Apache gives up on the FastCGI script and > generates a 500

Re: [rt-users] help with scrip

2008-10-17 Thread Gene LeDuc
Hi Violetta, Try this: if ( $self->TransactionObj->Type eq "Create" && ! ( $self->TicketObj->Subject =~ /proje[c|k]t: /i || $self->TicketObj->Subject =~ /akut: /i ) ) Regards, Gene At 02:59 AM 10/17/2008, Violetta Wawryk wrote: >Hi, > > >> > if ($self->TransactionObj->Type eq "Cr

Re: [rt-users] Continuous 500 errors

2008-10-17 Thread scollins
This is getting very frustrating. I've completely re-installed a fresh RT and database following the instructions at http://wiki.bestpractical.com/view/RHEL4InstallGuide exactly. The only exception is I'm using Module::Build 0.30 from cpan instead of the old perl-Module-Build-0.2612-1.rhel4.noarch.

Re: [rt-users] Continuous 500 errors

2008-10-17 Thread Drew Barnes
Install Scalar::util from cpan and not from RPM. RedHat's RPM install is broken. scollins wrote: > This is getting very frustrating. I've completely re-installed a fresh > RT and database following the instructions at > http://wiki.bestpractical.com/view/RHEL4InstallGuide exactly. The only > ex

Re: [rt-users] E-mail Templates are only a single character

2008-10-17 Thread Timothy Butkiewicz
I've managed to get the templates working, but e-mail does not appear to be generating on certain scrips and queues. I am seeing this in the log: [Fri Oct 17 17:15:13 2008] [debug]: Working on mailfield Bcc; recipients are (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:640) [Fri Oct 17 17:15:13 20

Re: [rt-users] Continuous 500 errors

2008-10-17 Thread scollins
The install wiki doesn't say to install that via rpm and I don't. I double checked and it is in fact installed via cpan. I force re-installed to be sure: Scalar::Util is up to date (1.19). 500 errors still happening. Any other ideas? -steven On Fri, 2008-10-17 at 12:33 -0400, Drew Barnes wrote

[rt-users] CLI question

2008-10-17 Thread Roy El-Hames
Hi ; Using rt-3.6.3 Is there a bug in using: ./rt edit ticket/$tid add cc="[EMAIL PROTECTED]" or am i doing something wrong, I get back # Syntax error. and the ticket detail (as if show ticket) ; the add seems not to work with anything add bcc or add CF- do not work either ?? Similar the del

[rt-users] Template to include name of person who performed last action

2008-10-17 Thread Helmuth Ramirez
I've searched around for this, but I'm not sure I am searching the right keywords. Here is what we would like to do: We have a scrip that runs when someone changes a custom field to a particular value. That triggers an e-mail to be sent based on a template. I figured out how to include the v

Re: [rt-users] Template to include name of person who performed last action

2008-10-17 Thread Gene LeDuc
You probably want the creator of the transaction: $self->TransactionObj->CreatorObj->RealName At 10:59 AM 10/17/2008, Helmuth Ramirez wrote: >Content-class: urn:content-classes:message >Content-Type: multipart/alternative; > boundary="_=_NextPart_001_01C93082.0B746043" > >I’ve searche

[rt-users] RT 3.8 - Change tickets color in views

2008-10-17 Thread Filipe José Silva Clemente
Hi, How can I in RT 3.8 change the ticket line color to red in the view, if the ticket is opened for about a week? TIA, Filipe Portugal smime.p7s Description: S/MIME cryptographic signature ___ http://lists.bestpractical.com/cgi-bin/mai

Re: [rt-users] scrip change customfieldvalue on certain value

2008-10-17 Thread Kenneth Crocker
Violetta, Try something like this: # condition execution on value of CF "CFA" my $trans = $self->TransactionObj; my $ticket = $self->TicketObj; if ($trans->Type eq 'CustomField') {my $cf = new RT::CustomField($RT::SystemUser); $cf->LoadByName(Queue => $ticket->QueueObj->

Re: [rt-users] E-mail Templates are only a single character

2008-10-17 Thread Kenneth Crocker
Timothy, There could be a couple reasons for this. For example, if the scrip action is "Notify Others" and you only have Watcher CC's, then they don't get included. There is a distinction between "Watcher" CC's, Others (added CC's at the time of clicking "Update" when in Reply) and al

Re: [rt-users] Template to include name of person who performed last action

2008-10-17 Thread Kenneth Crocker
Helmuth, Or "my $whomever = $self->TransactionObj->CreatorObj->Name;".You could also get the user's ID. Hope this helps. Kenn LBNL On 10/17/2008 11:06 AM, Gene LeDuc wrote: > You probably want the creator of the transaction: > $self->TransactionObj->CreatorObj->RealName > > At 10:5

Re: [rt-users] Continuous 500 errors

2008-10-17 Thread Drew Barnes
Try searching list archives for segmentation faults: http://www.gossamer-threads.com/lists/engine?list=rt;do=search_results;search_forum=forum_3;search_string=segmentation%20fault;search_type=AND&sb=post_time Could also be Text::Quoted needs re-install. I also see some mysql possibilities in the

Re: [rt-users] Merged Ticket Performance Degredation

2008-10-17 Thread Damon Miller
Mark, Thanks very much for your quick reply. I updated our config file as suggested but either the 'native' socket type isn't supported in Perl 5.8.5 on Linux or I'm doing something wrong. Here's what happened when I started the FastCGI handler from the command-line: Invalid argument passed to

Re: [rt-users] Merged Ticket Performance Degredation

2008-10-17 Thread Mark Blackman
You just need to upgrade your Sys::Syslog version. should be fine after that. - Mark On 17 Oct 2008, at 19:57, Damon Miller wrote: > Mark, > > Thanks very much for your quick reply. I updated our config file as > suggested but either the 'native' socket type isn't supported in Perl > 5.8.5 on

Re: [rt-users] Continuous 500 errors

2008-10-17 Thread scollins
Yes, I had already tried re-installing Text::Quoted as I had been searching for an answer in the user list long before posting to it. Seems there are a lot of similar issues but nothing exactly like mine. It's either my system or the RT version I'm using (3.8.1) and it's not easy to eliminate eithe

Re: [rt-users] Template to include name of person who performed last action

2008-10-17 Thread Helmuth Ramirez
Thanks Gene, Although I'm clearing doing something wrong. I am putting the following in my template: Updated by: $self->TransactionObj->CreatorObj->RealName But the name doesn't show up, just the line I put in the template :( Thanks -Original Message- From: Gene LeDuc [mailto:[EMAIL PR

Re: [rt-users] Template to include name of person who performed last action

2008-10-17 Thread Kenneth Crocker
Helmuth, Try this: Updated by: {$Ticket->CreatorObj->Name} OR Updated by: {$Ticket->CreatorObj->RealName} Kenn LBNL On 10/17/2008 12:58 PM, Helmuth Ramirez wrote: > Thanks Gene, > Although I'm clearing doing something wrong. I am putting the following > in my template: > > Updated

Re: [rt-users] Template to include name of person who performed last action

2008-10-17 Thread Gene LeDuc
Put curly braces around the perl stuff: Updated by: {$self->TransactionObj->CreatorObj->RealName} At 12:58 PM 10/17/2008, Helmuth Ramirez wrote: >Thanks Gene, >Although I'm clearing doing something wrong. I am putting the following >in my template: > >Updated by: $self->TransactionObj->CreatorO

Re: [rt-users] Template to include name of person who performed last action

2008-10-17 Thread Helmuth Ramirez
Thank you Kenneth and Gene for your help with this! I got it to show the name. Cheers! Helmuth -Original Message- From: Kenneth Crocker [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 4:23 PM To: Helmuth Ramirez Cc: Gene LeDuc; rt-users@lists.bestpractical.com Subject: Re: [rt-

[rt-users] date formats option

2008-10-17 Thread Kenneth Crocker
To all, I noticed that in 3.6.x, the format required when entering the due date for a reminder is "(/mm/dd)". Is there a way to make this the format for other dates, like the "Due Date" for the ticket itself or for a Custom Field? Thanks in advance. Kenn LBNL ___

Re: [rt-users] Add search to RT System's saved searches

2008-10-17 Thread Ben Goodwin
Mathew, I was searching for an answer to this and ran across this post. I thought I'd chime in and say, "me too!" with a couple more details. I'm running a new install of 3.8.1. I created a saved search and saved it to the RT System's searches and expected to be able to see it on all other acco

Re: [rt-users] Template to include name of person who performed last action

2008-10-17 Thread Jerrad Pierce
> > Updated by: {$Ticket->CreatorObj->Name} OR > Updated by: {$Ticket->CreatorObj->RealName} Updated by: {$Ticket->CreatorObj->RealName || $Ticket->CreatorObj->Name } But if you are using FriendlyFrom the the actual email would include this too, wouldn't it? -- Cambridge Energy Alliance: Sa

Re: [rt-users] RT Upgrade 3.2.2 -> 3.8.1: HTML::Mason goes intoinfinite loop.

2008-10-17 Thread Golemon, Buck
t_t --Buck -Original Message- From: Golemon, Buck Sent: Tuesday, October 14, 2008 4:25 PM To: Golemon, Buck; RT Users List Cc: Descamps, Gilles-Eric; Lee, Mark (SV) Subject: RE: [rt-users] RT Upgrade 3.2.2 -> 3.8.1: HTML::Mason goes intoinfinite loop. Did I ask the question the wrong w

[rt-users] Using default scrip actions to create a "tee" for transactions

2008-10-17 Thread Jerrad Pierce
Anyone know an easy way to get ahold of the code for default scrip actions? I'm trying to create a script like "OnCreate Notify AdminCCs" that includes attachments (I've set the default to include links with an updated version of http://wiki.bestpractical.com/view/AddAttachmentLinksToMail) and se