Re: [rt-users] Adding additional Grouped by fields to bar and pie charts (3.8.1)
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 options to RT? I want to create a group by chart for my dashboard for things like priority, weekly trends, etc We don't yet have this functionality, but I'd love to see it done. -jesse pgp7OG8SIP1dQ.pgp Description: PGP signature ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Issue Installing RT
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 ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] help with scrip
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 heissen wenn ich negieren will? $self-TicketObj-Subject =~ /[A|a]kut: / -- das tut wenns zutrifft Danke Violetta -- 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 Office: Tuebingen Registergericht/Registration Court: Stuttgart Registernummer/Commercial Register No.: HRB 382196 ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] help with scrip
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 B ) || C ) instead of ( A ( B || C )) which is what you described. I understand that now. Thank you. But I found out my scrip is not working because of the wrong regex. $self-TicketObj-Subject !=~ /[A|a]kut: / -- doesn't work $self-TicketObj-Subject !~ /[A|a]kut: / -- doesn't work what would be the right expression to make it negative? $self-TicketObj-Subject =~ /[A|a]kut: / -- does work for positiv Thanks Violetta -- 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 Office: Tuebingen Registergericht/Registration Court: Stuttgart Registernummer/Commercial Register No.: HRB 382196 ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT-Authen-ExternalAuth-0.05
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... ou=51 uid=511.. uid=512... All staff emails auto-create an account when email is first sent to RT or when they logon to self-service. External gmail type accounts are OK as well. However, our student accounts generate the below errors. All student account uids are basically their 8 digit student number and emails are of form [EMAIL PROTECTED] I have given 'Everyone' permissions on the relevant queue. Does anyone have any ideas as to why one group of users work but not others. Obvious differences between accounts are that uids for students are all numeric, and their LDAP branch is organised a little differently, but when an email is sent it finds the relevant attrs. from OpenLDAP. When I logon using my credentials, in LDAP log I see a SRCH and then a BIND. But nothing appears when trying a student account self-service login. [EMAIL PROTECTED] ~]# tail -f /var/log/ldap.log|grep jbloggs Oct 17 11:23:14 xxx slapd[29302]: conn=2505948 op=2 SRCH base=dc=ourdomain,dc=ie scope=2 deref=2 filter=((objectClass=posixAccount)(uid=jbloggs)) Oct 17 11:23:15 xxx slapd[29302]: conn=2505950 op=3 BIND dn=uid=jbloggs,ou=Users,dc=ourdomain,dc=ie method=128 Regards, Jason Error when email sent -- Oct 17 10:58:08 rtsandbox RT: RT::User::LookupExternalUserInfo : Returning: EmailAddress: , Name: , RealName: (/opt/rt3/bin/../local/ lib/RT/User_Vendor.pm:703) Oct 17 10:58:08 rtsandbox RT: RT::User::LookupExternalUserInfo : Returning: EmailAddress: [EMAIL PROTECTED], ExternalAuthId: 98765432, Name: 98765432, Organization: NUIM, RealName: JOE BLOGGS(/opt/rt3/bin/../local/lib/RT/User_Vendor.pm:703) Oct 17 10:58:08 rtsandbox RT: RT::User::CanonicalizeUserInfo returning Comments: Autocreated on ticket submission, Disabled: 0, EmailAddress: [EMAIL PROTECTED] , ExternalAuthId: 98765432, Name: 98765432, Organization: NUIM, Password: , Privileged: 0, RealName: JOE BLOGGS(/opt/rt3/bin/../local/ lib/RT/User_Vendor.pm:444) Oct 17 10:58:08 rtsandbox RT: Could not create a new user - Comments- Autocreated on ticket submission-RealName-JOE [EMAIL PROTECTED] *NO-PASSWORD*-Name-98765432-Organization-NUIM-ExternalAuthId-98765432 (/opt/rt3/bin/../lib/RT/User_Overlay.pm:201) Oct 17 10:58:08 rtsandbox RT: User creation failed in mailgateway: Could not create user (/opt/rt3/bin/../lib/RT/Interface/Email.pm:244) Oct 17 10:58:09 rtsandbox RT: Couldn't load user '[EMAIL PROTECTED] '.giving up (/opt/rt3/bin/../lib/RT/Interface/Email.pm:806) Oct 17 10:58:09 rtsandbox RT: User '[EMAIL PROTECTED]' could not be loaded in the mail gateway (/opt/rt3/bin/../lib/RT/ Interface/Email.pm:244) Oct 17 10:58:09 rtsandbox RT: RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for this email ([EMAIL PROTECTED]). You might need to grant 'Everyone' the right 'CreateTicket' for the queue support_pre. (/opt/ rt3/bin/../lib/RT/Interface/Email.pm:244) Oct 17 10:58:09 rtsandbox RT: RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for your email. (/opt/rt3/bin/../lib/RT/Interface/Email.pm:244) Oct 17 10:58:09 rtsandbox RT: Could not record email: Could not load a valid user (/opt/rt3/share/html/REST/1.0/NoAuth/mail-gateway:75) Error on Logon to Self Service -- Oct 17 11:05:12 rtsandbox RT: Couldn't get principal for not loaded object (/opt/rt3/bin/../lib/RT/User_Overlay.pm:1113) Oct 17 11:05:13 rtsandbox RT: Use of uninitialized value in join or string at /usr/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm line 22, DATA line 514. (/opt/rt3/bin/../local/lib/RT/User_Vendor.pm:208) Oct 17 11:05:13 rtsandbox RT: My_LDAP AUTH FAILED: User not found or more than one user found (/opt/rt3/bin/../local/lib/RT/User_Vendor.pm: 208) Oct 17 11:05:13 rtsandbox RT: Use of uninitialized value in join or string at /usr/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm line 22, DATA line 514. (/opt/rt3/bin/../local/lib/RT/User_Vendor.pm:294) Oct 17 11:05:13 rtsandbox RT: RT::User::IsExternalPassword External Auth Failed: (/opt/rt3/bin/../local/lib/RT/User_Vendor.pm:294) Oct 17 11:05:13 rtsandbox RT: Use of uninitialized value in join or string at /usr/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm line 22, DATA line 514. (/opt/rt3/bin/../local/lib/RT/User_Vendor.pm:305) Oct 17 11:05:13 rtsandbox RT: RT::User::IsInternalPassword AUTH FAILED (no passwd): (/opt/rt3/bin/../local/lib/RT/User_Vendor.pm:305) Oct 17 11:05:13 rtsandbox RT: FAILED LOGIN for 98765432 from 149.xx.xx.xx (/opt/rt3/share/html/autohandler:265)
Re: [rt-users] help with scrip
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 Office: Tuebingen Registergericht/Registration Court: Stuttgart Registernummer/Commercial Register No.: HRB 382196 ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] scrip change customfieldvalue on certain value
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 it has changed. And that is exactly my problem. How do I check what the new value is? The first part would be: if ($self-TransactionObj-Type eq CustomField and what comes after ?? Thanks a lot for your help! Violetta -- creating IT solutions Violetta J. Wawryk science + computing ag IT-Service Hagellocher Weg 73 phone +49 7071 9457 282 72070 Tuebingen, Germany fax +49 7071 9457 211 www.science-computing.de -- 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 Office: Tuebingen Registergericht/Registration Court: Stuttgart Registernummer/Commercial Register No.: HRB 382196 ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] E-mail Templates are only a single character
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; ALTER TABLE Attachments DEFAULT CHARACTER SET utf8; ALTER TABLE Attachments MODIFY Subject VARBINARY(255) NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY Subject VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY ContentType VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY Filename VARBINARY(255) NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY Filename VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY Headers LONGBLOB NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY Headers LONGTEXT CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY MessageId VARBINARY(160) NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY MessageId VARCHAR(160) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY Content LONGBLOB NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY ContentEncoding VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Attributes DEFAULT CHARACTER SET utf8; ALTER TABLE Attributes MODIFY ContentType VARBINARY(16) NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY ContentType VARCHAR(16) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY Content BLOB NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY Description VARBINARY(255) NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY Description VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY Name VARBINARY(255) NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY Name VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY ObjectType VARBINARY(64) NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY ObjectType VARCHAR(64) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE CustomFields DEFAULT CHARACTER SET utf8; ALTER TABLE CustomFields MODIFY Pattern BLOB NULL DEFAULT NULL; ALTER TABLE CustomFields MODIFY Pattern TEXT CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE CustomFields MODIFY LookupType VARBINARY(255) NOT NULL DEFAULT ''; ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT ''; ALTER TABLE CustomFields MODIFY Type VARBINARY(200) NULL DEFAULT NULL; ALTER TABLE CustomFields MODIFY Type VARCHAR(200) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE CustomFields MODIFY Description VARBINARY(255) NULL DEFAULT NULL; ALTER TABLE CustomFields MODIFY Description VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE CustomFields MODIFY Name VARBINARY(200) NULL DEFAULT NULL; ALTER TABLE CustomFields MODIFY Name VARCHAR(200) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE CustomFieldValues DEFAULT CHARACTER SET utf8; ALTER TABLE CustomFieldValues MODIFY Description VARBINARY(255) NULL DEFAULT NULL; ALTER TABLE CustomFieldValues MODIFY Description VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE CustomFieldValues MODIFY Name VARBINARY(200) NULL DEFAULT NULL; ALTER TABLE CustomFieldValues MODIFY Name VARCHAR(200) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE GroupMembers DEFAULT CHARACTER SET utf8; ALTER TABLE Groups DEFAULT CHARACTER SET utf8; ALTER TABLE Groups MODIFY Domain VARBINARY(64) NULL DEFAULT NULL; ALTER TABLE Groups MODIFY Domain VARCHAR(64) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Groups MODIFY Type VARBINARY(64) NULL DEFAULT NULL; ALTER TABLE Groups MODIFY Type VARCHAR(64) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Groups MODIFY Description VARBINARY(255) NULL DEFAULT NULL; ALTER TABLE Groups MODIFY Description VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE Groups MODIFY Name VARBINARY(200) NULL DEFAULT NULL; ALTER TABLE Groups MODIFY Name VARCHAR(200) CHARACTER SET utf8 NULL DEFAULT NULL; ALTER TABLE Links DEFAULT CHARACTER SET utf8; ALTER TABLE Links MODIFY Target VARBINARY(240) NULL DEFAULT NULL; ALTER TABLE Links MODIFY Target VARCHAR(240) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Links MODIFY Base VARBINARY(240) NULL DEFAULT NULL; ALTER TABLE Links MODIFY Base VARCHAR(240) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Links MODIFY Type VARBINARY(20) NOT NULL DEFAULT ''; ALTER TABLE Links MODIFY Type VARCHAR(20) CHARACTER SET ascii NOT NULL DEFAULT ''; ALTER TABLE ObjectCustomFields DEFAULT CHARACTER SET utf8; ALTER TABLE ObjectCustomFieldValues DEFAULT CHARACTER SET utf8; ALTER TABLE ObjectCustomFieldValues MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL; ALTER TABLE ObjectCustomFieldValues MODIFY ContentType VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE
Re: [rt-users] E-mail Templates are only a single character
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/schema.mysql-4.0-4.1.pl contained some destructive transforms that I had to change. Several multi-character fields were temporarily transformed into type CHAR, which truncated them to a single character. Check your sql.queries file (e.g. 'grep CHAR sql.queries) and make sure you're not hitting the same thing; in my case, one of the fields that was thus truncated was in fact this same Templates.Content field. RT's templates don't work so good when they consist of only one character. :-) --- cut --- ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] E-mail Templates are only a single character
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 before EOF at template line 4. Somewhere I am missing a separator -Original Message- From: Panu [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 11:19 AM To: rt-users@lists.bestpractical.com Cc: Timothy Butkiewicz Subject: Re: E-mail Templates are only a single character 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/schema.mysql-4.0-4.1.pl contained some destructive transforms that I had to change. Several multi-character fields were temporarily transformed into type CHAR, which truncated them to a single character. Check your sql.queries file (e.g. 'grep CHAR sql.queries) and make sure you're not hitting the same thing; in my case, one of the fields that was thus truncated was in fact this same Templates.Content field. RT's templates don't work so good when they consist of only one character. :-) --- cut --- ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Merged Ticket Performance Degredation
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 posts, but I have been unable to find a resolution. The following from Jesse seems to be the most descriptive: Yep. it's not recursion. It's RT::Transaction::TicketObj which should be made smarter. Rather than loading a ticket by id, it should be loading by id _and_ effective id. I'd love a patch. (Full thread is available at the Gossamer list archive: http://www.gossamer-threads.com/lists/rt/users/72384.) I checked 3.8.1 and the TODO is still present in Ticket_Overlay.pm (Load) so I'm assuming the performance problem is still present in that release. I'd love to help by producing a patch but frankly I don't understand what needs to be done. Has anyone else found a solution to this problem? Following another suggestion, I tried reducing the loglevel such that the We found a merged ticket messages weren't stored but we're still seeing occasional CPU spikes from the FastCGI process (and the associated delays which lead to HTTP/500s from Apache). Without the debug messages turned on I can't be absolutely certain the issue is loading merged tickets, but it seems very likely given that I can reproduce the problem by attempting to load a known-merged ticket with debug logging turned off. Thanks for any suggestions or feedback. Regards, Damon -- Damon T. Miller Director of Application Services Thinking Phone Networks [EMAIL PROTECTED] 617-649-1388 (Office) ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Merged Ticket Performance Degredation
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. This problem has been documented and referenced in several posts, but I have been unable to find a resolution. Thanks for any suggestions or feedback. adding @LogToSyslogConf = ( socket = 'native' ) unless (@LogToSyslogConf); to RT_SiteConfig.pm sped up the merged ticket display from 260 seconds to about 6 seconds for us. probably still too many log messages being written for the reason above I suppose. - Mark ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] help with scrip
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 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 B ) || C ) instead of ( A ( B || C )) which is what you described. I understand that now. Thank you. But I found out my scrip is not working because of the wrong regex. $self-TicketObj-Subject !=~ /[A|a]kut: / -- doesn't work $self-TicketObj-Subject !~ /[A|a]kut: / -- doesn't work what would be the right expression to make it negative? $self-TicketObj-Subject =~ /[A|a]kut: / -- does work for positiv Thanks Violetta -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Continuous 500 errors
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.rpm listed in the wiki. All other perl modules and rpms are consistant with the install guide. I am still seeing 500 errors randomly while navigating the RT insterface: [Fri Oct 17 11:57:43 2008] [error] [client myIP] FastCGI: incomplete headers (0 bytes) received from server /opt/rt3/bin/mason_handler.fcgi, referer: http://rt.mydomain.com/index.html [Fri Oct 17 11:57:43 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi (pid 18996) terminated due to uncaught signal '11' (Segmentation fault) [Fri Oct 17 11:57:45 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi restarted (pid 19036) I also set Set($LogStackTraces , 'debug'); in the RT_SiteConfig.pm file but that does not seem to have yielded any usefull information regarding the segfaults. I really need some help with this. RT is completely unusable for me at this point. -steven ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Continuous 500 errors
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 exception is I'm using Module::Build 0.30 from cpan instead of the old perl-Module-Build-0.2612-1.rhel4.noarch.rpm listed in the wiki. All other perl modules and rpms are consistant with the install guide. I am still seeing 500 errors randomly while navigating the RT insterface: [Fri Oct 17 11:57:43 2008] [error] [client myIP] FastCGI: incomplete headers (0 bytes) received from server /opt/rt3/bin/mason_handler.fcgi, referer: http://rt.mydomain.com/index.html [Fri Oct 17 11:57:43 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi (pid 18996) terminated due to uncaught signal '11' (Segmentation fault) [Fri Oct 17 11:57:45 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi restarted (pid 19036) I also set Set($LogStackTraces , 'debug'); in the RT_SiteConfig.pm file but that does not seem to have yielded any usefull information regarding the segfaults. I really need some help with this. RT is completely unusable for me at this point. -steven ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Drew Barnes Applications Analyst Network Resources Department Raymond Walters College University of Cincinnati ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] E-mail Templates are only a single character
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 2008] [debug]: Subject: *subject* *norm message headers* MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=utf-8 X-RT-Original-Encoding: utf-8 (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:647) [Fri Oct 17 17:15:13 2008] [debug]: Removing deferred recipients from Bcc: line (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:670) [Fri Oct 17 17:15:13 2008] [debug]: Setting deferred recipients for attribute creation (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:679) [Fri Oct 17 17:15:13 2008] [debug]: No recipients found for deferred delivery on transaction #2056671 (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:692) Appears that RT isn't picking up the watcher recipients ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Continuous 500 errors
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: 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 exception is I'm using Module::Build 0.30 from cpan instead of the old perl-Module-Build-0.2612-1.rhel4.noarch.rpm listed in the wiki. All other perl modules and rpms are consistant with the install guide. I am still seeing 500 errors randomly while navigating the RT insterface: [Fri Oct 17 11:57:43 2008] [error] [client myIP] FastCGI: incomplete headers (0 bytes) received from server /opt/rt3/bin/mason_handler.fcgi, referer: http://rt.mydomain.com/index.html [Fri Oct 17 11:57:43 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi (pid 18996) terminated due to uncaught signal '11' (Segmentation fault) [Fri Oct 17 11:57:45 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi restarted (pid 19036) I also set Set($LogStackTraces , 'debug'); in the RT_SiteConfig.pm file but that does not seem to have yielded any usefull information regarding the segfaults. I really need some help with this. RT is completely unusable for me at this point. -steven ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] CLI question
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 method is not working either ?? Thanks; Roy ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Template to include name of person who performed last action
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 value of the custom field, but what is the format to include the name of the person who performed the action to change this value? Does that make sense? Essentially, I would like to be able to pull the name that shows up in the audit logs JoeSmith - comments added, JoeSmith - Status changed..., etc. Thanks everyone! Helmuth ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Template to include name of person who performed last action
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 Ive searched around for this, but Im 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 value of the custom field, but what is the format to include the name of the person who performed the action to change this value? Does that make sense? Essentially, I would like to be able to pull the name that shows up in the audit logs JoeSmith comments added, JoeSmith Status changed , etc. Thanks everyone! Helmuth -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT 3.8 - Change tickets color in views
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/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] scrip change customfieldvalue on certain value
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-id, Name = CFA); return 0 unless $cf-id; if ($trans-Field == $cf-id $trans-NewValue eq Value1) { my $current_Value = Value1; return 1; } else { my $current_Value = $trans-NewValue; } } return 0; Something along those lines should work. I didn't know if you wanted to save the new value or do something, etc. Hope this helps. Kenn LBNL On 10/17/2008 7:16 AM, Violetta Wawryk wrote: 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 it has changed. And that is exactly my problem. How do I check what the new value is? The first part would be: if ($self-TransactionObj-Type eq CustomField and what comes after ?? Thanks a lot for your help! Violetta ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] E-mail Templates are only a single character
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 also, CC's that are on a ticket only. Hope this helps. Kenn LBNL On 10/17/2008 10:18 AM, Timothy Butkiewicz wrote: 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 2008] [debug]: Subject: *subject* *norm message headers* MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=utf-8 X-RT-Original-Encoding: utf-8 (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:647) [Fri Oct 17 17:15:13 2008] [debug]: Removing deferred recipients from Bcc: line (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:670) [Fri Oct 17 17:15:13 2008] [debug]: Setting deferred recipients for attribute creation (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:679) [Fri Oct 17 17:15:13 2008] [debug]: No recipients found for deferred delivery on transaction #2056671 (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:692) Appears that RT isn't picking up the watcher recipients ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Template to include name of person who performed last action
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: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 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 value of the custom field, but what is the format to include the name of the person who performed the action to change this value? Does that make sense? Essentially, I would like to be able to pull the name that shows up in the audit logs “JoeSmith – comments added”, “JoeSmith – Status changed…”, etc. Thanks everyone! Helmuth ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Continuous 500 errors
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=ANDsb=post_time Could also be Text::Quoted needs re-install. I also see some mysql possibilities in there. Good luck. 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 exception is I'm using Module::Build 0.30 from cpan instead of the old perl-Module-Build-0.2612-1.rhel4.noarch.rpm listed in the wiki. All other perl modules and rpms are consistant with the install guide. I am still seeing 500 errors randomly while navigating the RT insterface: [Fri Oct 17 11:57:43 2008] [error] [client myIP] FastCGI: incomplete headers (0 bytes) received from server /opt/rt3/bin/mason_handler.fcgi, referer: http://rt.mydomain.com/index.html [Fri Oct 17 11:57:43 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi (pid 18996) terminated due to uncaught signal '11' (Segmentation fault) [Fri Oct 17 11:57:45 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi restarted (pid 19036) I also set Set($LogStackTraces , 'debug'); in the RT_SiteConfig.pm file but that does not seem to have yielded any usefull information regarding the segfaults. I really need some help with this. RT is completely unusable for me at this point. -steven ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Drew Barnes Applications Analyst Network Resources Department Raymond Walters College University of Cincinnati ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Merged Ticket Performance Degredation
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 setlogsock; must be 'stream', 'unix', 'tcp', 'udp' or 'inet' at /usr/lib/perl5/site_perl/5.8.5/Log/Dispatch/Syslog.pm line 66 To make sure I followed your suggestion correctly, here are the last few entries in our RT_SiteConfig.pm: -- Set($AutoCreateNonExternalUsers,1); Set($LogToFileNamed , rt.log); Set($LogToFile , 'warning'); Set($UseFriendlyFromLine , 0); @LogToSyslogConf = ( socket = 'native' ) unless (@LogToSyslogConf); 1; -- As another potentially-relevant point, I also tried decreasing the verbosity of the logfile so as to eliminate the We found a merged ticket messages entirely. Does that make the syslog update to RT_SiteConfig.pm unnecessary? Even after reducing verbosity, I'm still seeing the hang issue upon trying to load a merged ticket through the UI. Regardless, I just wanted to make sure I wasn't missing something between those two changes. Thanks again, Damon __ Damon T. Miller Director of Application Services Thinking Phone Networks [EMAIL PROTECTED] 617-649-1388 (Office) -Original Message- From: Mark Blackman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 11:58 AM To: Damon Miller Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Merged Ticket Performance Degredation 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. This problem has been documented and referenced in several posts, but I have been unable to find a resolution. Thanks for any suggestions or feedback. adding @LogToSyslogConf = ( socket = 'native' ) unless (@LogToSyslogConf); to RT_SiteConfig.pm sped up the merged ticket display from 260 seconds to about 6 seconds for us. probably still too many log messages being written for the reason above I suppose. - Mark ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Merged Ticket Performance Degredation
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 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 setlogsock; must be 'stream', 'unix', 'tcp', 'udp' or 'inet' at /usr/lib/perl5/site_perl/5.8.5/Log/Dispatch/ Syslog.pm line 66 To make sure I followed your suggestion correctly, here are the last few entries in our RT_SiteConfig.pm: -- Set($AutoCreateNonExternalUsers,1); Set($LogToFileNamed , rt.log); Set($LogToFile , 'warning'); Set($UseFriendlyFromLine , 0); @LogToSyslogConf = ( socket = 'native' ) unless (@LogToSyslogConf); 1; -- As another potentially-relevant point, I also tried decreasing the verbosity of the logfile so as to eliminate the We found a merged ticket messages entirely. Does that make the syslog update to RT_SiteConfig.pm unnecessary? Even after reducing verbosity, I'm still seeing the hang issue upon trying to load a merged ticket through the UI. Regardless, I just wanted to make sure I wasn't missing something between those two changes. Thanks again, Damon __ Damon T. Miller Director of Application Services Thinking Phone Networks [EMAIL PROTECTED] 617-649-1388 (Office) -Original Message- From: Mark Blackman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 11:58 AM To: Damon Miller Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Merged Ticket Performance Degredation 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. This problem has been documented and referenced in several posts, but I have been unable to find a resolution. Thanks for any suggestions or feedback. adding @LogToSyslogConf = ( socket = 'native' ) unless (@LogToSyslogConf); to RT_SiteConfig.pm sped up the merged ticket display from 260 seconds to about 6 seconds for us. probably still too many log messages being written for the reason above I suppose. - Mark ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Continuous 500 errors
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 either of these on a production system just for trouble shooting :( -steven On Fri, 2008-10-17 at 14:56 -0400, Drew Barnes wrote: 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=ANDsb=post_time Could also be Text::Quoted needs re-install. I also see some mysql possibilities in there. Good luck. 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 exception is I'm using Module::Build 0.30 from cpan instead of the old perl-Module-Build-0.2612-1.rhel4.noarch.rpm listed in the wiki. All other perl modules and rpms are consistant with the install guide. I am still seeing 500 errors randomly while navigating the RT insterface: [Fri Oct 17 11:57:43 2008] [error] [client myIP] FastCGI: incomplete headers (0 bytes) received from server /opt/rt3/bin/mason_handler.fcgi, referer: http://rt.mydomain.com/index.html [Fri Oct 17 11:57:43 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi (pid 18996) terminated due to uncaught signal '11' (Segmentation fault) [Fri Oct 17 11:57:45 2008] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi restarted (pid 19036) I also set Set($LogStackTraces , 'debug'); in the RT_SiteConfig.pm file but that does not seem to have yielded any usefull information regarding the segfaults. I really need some help with this. RT is completely unusable for me at this point. -steven ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Template to include name of person who performed last action
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 PROTECTED] Sent: Friday, October 17, 2008 2:06 PM To: Helmuth Ramirez Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Template to include name of person who performed last action 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 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 value of the custom field, but what is the format to include the name of the person who performed the action to change this value? Does that make sense? Essentially, I would like to be able to pull the name that shows up in the audit logs JoeSmith - comments added, JoeSmith - Status changed..., etc. Thanks everyone! Helmuth -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Template to include name of person who performed last action
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 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 PROTECTED] Sent: Friday, October 17, 2008 2:06 PM To: Helmuth Ramirez Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Template to include name of person who performed last action 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 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 value of the custom field, but what is the format to include the name of the person who performed the action to change this value? Does that make sense? Essentially, I would like to be able to pull the name that shows up in the audit logs JoeSmith - comments added, JoeSmith - Status changed..., etc. Thanks everyone! Helmuth ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Template to include name of person who performed last action
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-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 PROTECTED] Sent: Friday, October 17, 2008 2:06 PM To: Helmuth Ramirez Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Template to include name of person who performed last action 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 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 value of the custom field, but what is the format to include the name of the person who performed the action to change this value? Does that make sense? Essentially, I would like to be able to pull the name that shows up in the audit logs JoeSmith - comments added, JoeSmith - Status changed..., etc. Thanks everyone! Helmuth -- Gene LeDuc, GSEC Security Analyst San Diego State University -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Template to include name of person who performed last action
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-users] Template to include name of person who performed last action 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 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 PROTECTED] Sent: Friday, October 17, 2008 2:06 PM To: Helmuth Ramirez Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Template to include name of person who performed last action 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 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 value of the custom field, but what is the format to include the name of the person who performed the action to change this value? Does that make sense? Essentially, I would like to be able to pull the name that shows up in the audit logs JoeSmith - comments added, JoeSmith - Status changed..., etc. Thanks everyone! Helmuth ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] date formats option
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 ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Add search to RT System's saved searches
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 accounts. I can't even find load is as a previously-saved search. It also doesn't show up under Global/Rt at a glance as an option. Have you had any further insights into the problem? Regards, -=| Ben ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Template to include name of person who performed last action
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: Save money the planet ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT Upgrade 3.2.2 - 3.8.1: HTML::Mason goes intoinfinite loop.
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 way? At this point, any ideas are appreciated. Has anyone successfully upgraded their database from =3.2.2 to 3.8.1? --Buck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Golemon, Buck Sent: Monday, October 13, 2008 6:38 PM To: RT Users List Cc: Descamps, Gilles-Eric; Lee, Mark (SV) Subject: [rt-users] RT Upgrade 3.2.2 - 3.8.1: HTML::Mason goes intoinfinite loop. The installation works just find with a pristine database, but when I copy over my old database and follow the instructions at UPGRADING.mysql, I get this error: (see attached). This went on for two million lines before I stopped the server. It finally gets into a three-line loop like this: (again, see attached). I got some errors from schema.mysql-4.0-4.1.pl like this: # perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 rt_user rt_pass sql.queries Use of uninitialized value in numeric gt () at etc/upgrade/schema.mysql-4.0-4.1.pl line 310. Use of uninitialized value in numeric gt () at etc/upgrade/schema.mysql-4.0-4.1.pl line 310. Use of uninitialized value in numeric gt () at etc/upgrade/schema.mysql-4.0-4.1.pl line 310. Use of uninitialized value in numeric gt () at etc/upgrade/schema.mysql-4.0-4.1.pl line 310. I had to replace all the occurrences (three total) of 'BLOB CHARACTER SET utf8' with just 'BLOB', since BLOB doesn't have a character set, and this is a syntax error in mysql. I also dropped and recreated the sessions table because it was corrupted. I did it like this: drop table sessions; CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL default '', `a_session` longblob NOT NULL, `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Thanks in advance, --Buck ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Using default scrip actions to create a tee for transactions
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 sends the transaction to a specific address not otherwise assoicated with any group or role, for backup purposes. I would consider trying to somehow have this account added as a watcher for everything in the system, but that doesn't solve the problem that only it should get attachments. -- Cambridge Energy Alliance: Save money the planet ___ 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 from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com