Re: [rt-users] Filter ticket text for display?

2007-07-09 Thread Kevin Falcone


On Jul 9, 2007, at 10:06 AM, Gary Oberbrunner wrote:

Hi folks -- is there a hook to filter or process the ticket history  
texts
(email bodies) when they're displayed?  We'd like to turn certain  
pieces of

text (identified by regex) into html links.


You should be able to use the ModifyDisplay callback in
Tickets/Elements/ShowTransaction to do this.

If you already have html mail, you can turn on PreferRichText
in your config

-kevin

___
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


FW: [rt-users] Why don't link work???

2007-07-09 Thread Mendez, Felix
I am using IE7 and the RT-3.6.3. When I connect to the site of the RT,
this it requests me login and password. But, When I give it shows me
codes of the next link. Please help me

Thanks

Felix


-Original Message-
From: Ben Weston [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 9:57 AM
To: Mendez, Felix
Subject: Re: [rt-users] Why don't link work???

Your a little light on details, but I will say that I've had problems 
working with RT (clicking on links and not going anywhere) under the 
newest version of Firefox (2.0 and higher), and have resorted to using 
IE7 for much of my ticket work.

~Hangs head in shame~

Can you give any more details?


Ben

Mendez, Felix wrote:

 Hi all. The RT Site show me the first page but When I click over the 
 some link, this link don't work. Which can be the problem

  

  

 Thanks for advance

  

 Felix




 ___
 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: FW: [rt-users] Why don't link work???

2007-07-09 Thread jmoseley
Try using a / at the end of your URL. For example:

http://rt.example.com/rt/

You might also want to post the output of the 'codes' you receive after
login.


James Moseley




   
 Mendez, Felix   
 [EMAIL PROTECTED] 
 -intl.com To 
 Sent by:  rt-users@lists.bestpractical.com  
 rt-users-bounces@  cc 
 lists.bestpractic 
 al.comSubject 
   FW: [rt-users] Why don't link   
   work??? 
 07/09/2007 09:24  
 AM
   
   
   
   




I am using IE7 and the RT-3.6.3. When I connect to the site of the RT,
this it requests me login and password. But, When I give it shows me
codes of the next link. Please help me

Thanks

Felix


-Original Message-
From: Ben Weston [mailto:[EMAIL PROTECTED]
Sent: Monday, July 09, 2007 9:57 AM
To: Mendez, Felix
Subject: Re: [rt-users] Why don't link work???

Your a little light on details, but I will say that I've had problems
working with RT (clicking on links and not going anywhere) under the
newest version of Firefox (2.0 and higher), and have resorted to using
IE7 for much of my ticket work.

~Hangs head in shame~

Can you give any more details?


Ben

Mendez, Felix wrote:

 Hi all. The RT Site show me the first page but When I click over the
 some link, this link don't work. Which can be the problem





 Thanks for advance



 Felix




 ___
 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


___
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] Filter ticket text for display?

2007-07-09 Thread Toby Darling

Hi Gary

Hi folks -- is there a hook to filter or process the ticket history texts
(email bodies) when they're displayed?  We'd like to turn certain pieces of
text (identified by regex) into html links.


http://wiki.bestpractical.com/view/CustomizingWithCallbacks
I'm not sure how current it is, but it's working for me on RT 3.4

Essentially I created a file in the local/share/request-tracker3.4 tree 
called html/Callbacks/CCDC/Ticket/Elements/ShowMessageStanza/Default

containing:

%init
my $val = $$content;
use bytes;
$val =~ s/(s?http|https):[\w\/\.:+\-]+/a href=$$\/a/gi;
$$content = $val;
/%init
%args
$content = undef
/%args


If you capture anything in the regexp, you can use $1, $2, ... in the 
replacement, as well as $ for the whole matched string.


$val =~ s;(bug|bz|bugzilla)\s*(\d{4,6});a 
href=http://bugzilla/show_bug\.cgi\?id=$2;$/a;gi;


would turn bug 1234 into a clickable link.



LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform [EMAIL PROTECTED] and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.
___
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] Filter ticket text for display?

2007-07-09 Thread Gary Oberbrunner
Kevin Falcone wrote:
 
 On Jul 9, 2007, at 10:06 AM, Gary Oberbrunner wrote:
 
 Hi folks -- is there a hook to filter or process the ticket history texts
 (email bodies) when they're displayed?  We'd like to turn certain
 pieces of
 text (identified by regex) into html links.
 
 You should be able to use the ModifyDisplay callback in
 Tickets/Elements/ShowTransaction to do this.

Thanks, Kevin -- that looks like exactly what I need.  I'll try it.  Does
anyone have a sample Callbacks/*/Elements/Ticket/ShowTransaction/ModifyDisplay
callback?  I don't really understand the calling convention, i.e. what are the
args and what I'm supposed to return.  Should I write a function, or is it
just bare Mason/perl code?  What are %INIT% and %ARGS% (I see those in some
other callbacks)?  Where do I get the actual ticket text (message body)?

(I looked at the rt wiki page CustomizingWithCallbacks and it explains the
proper file/dir to put the callback in, but doesn't say what it should look 
like.)

thx,

-- Gary
___
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] Filter ticket text for display?

2007-07-09 Thread Gary Oberbrunner
 Essentially I created a file in the local/share/request-tracker3.4 tree
 called html/Callbacks/CCDC/Ticket/Elements/ShowMessageStanza/Default
 containing:
 
 %init
 my $val = $$content;
 use bytes;
 $val =~ s/(s?http|https):[\w\/\.:+\-]+/a href=$$\/a/gi;
 $$content = $val;
 /%init
 %args
 $content = undef
 /%args

Thanks -- that's exactly what I needed!  I updated the wiki page with this code.

-- Gary
___
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] Filter ticket text for display?

2007-07-09 Thread Kevin Falcone


On Jul 9, 2007, at 10:56 AM, Gary Oberbrunner wrote:


Kevin Falcone wrote:


On Jul 9, 2007, at 10:06 AM, Gary Oberbrunner wrote:

Hi folks -- is there a hook to filter or process the ticket  
history texts

(email bodies) when they're displayed?  We'd like to turn certain
pieces of
text (identified by regex) into html links.


You should be able to use the ModifyDisplay callback in
Tickets/Elements/ShowTransaction to do this.


Thanks, Kevin -- that looks like exactly what I need.  I'll try  
it.  Does
anyone have a sample Callbacks/*/Elements/Ticket/ShowTransaction/ 
ModifyDisplay
callback?  I don't really understand the calling convention, i.e.  
what are the
args and what I'm supposed to return.  Should I write a function,  
or is it
just bare Mason/perl code?  What are %INIT% and %ARGS% (I see those  
in some
other callbacks)?  Where do I get the actual ticket text (message  
body)?


(I looked at the rt wiki page CustomizingWithCallbacks and it  
explains the
proper file/dir to put the callback in, but doesn't say what it  
should look like.)


The RTFM and RTIR packages on http://download.bestpractical.com/pub/ 
rt/devel/ make
extensive use of callbacks.  I'm not sure if they use that specific  
callback, but

you should be able to understand the technique from them.

-kevin
___
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] Re: RT 3.5.1 upgrade (insert) script hanging.

2007-07-09 Thread Allan Fu

k fixed. the database was missing the attribute table for whatever reason.

On 7/4/07, Allan Fu [EMAIL PROTECTED] wrote:

Hello,

I'm currently upgrading from 3.2.1 to 3.6.3
I'm going through the upgrade script.

I've ran
schema / acl / insert upgrades for 3.3.0 , 3.3.11 with no problems.
However, as I run
insert for 3.5.1 ( there is no schema/ acl upgrades for 3.5.1), it
just hangs at the line
Creating predefined searches...'

Any one have any ideas?

Thanks,

Allan


___
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 did not send to recipients

2007-07-09 Thread slamp slamp

e-mail was processed by RT. /var/log/messages states that it sent it
to specified recipients. under history in web view, it shows that it
sent to the specified recipients. but no e-mail were ever sent! this
is the only that did not get sent. other e-mails before and after this
message were sent.

it looks like it was sent using Vista and Office 11. Are there issues
with RT and VISTA/OFFICE11? we do not want to lose mail (by not being
able to see it from our inbox).

here is the html content of the e-mail (extracted from RT)

html xmlns:v=urn:schemas-microsoft-com:vml
xmlns:o=urn:schemas-microsoft-com:office:office
xmlns:w=urn:schemas-microsoft-com:office:word
xmlns=http://www.w3.org/TR/REC-html40;

head
meta http-equiv=Content-Type content=text/html; charset=us-ascii
meta name=Generator content=Microsoft Word 11 (filtered medium)
!--[if !mso]
style
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
/style
![endif]--
style
!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times New Roman;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
--
/style

/head

body lang=EN-US link=blue vlink=purple

div class=Section1

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'TEXT WAS HEREo:p/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'TEXT WAS HEREnbsp; o:p/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'TEXT WAS HEREo:p/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'img width=385 height=195 id=_x_i1025
src=cid:image002.jpg@01C7C22C.7255E590o:p/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'o:pnbsp;/o:p/span/font/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'TEXT WAS HERE/span/fonto:p/o:p/p

p class=MsoNormalfont size=2 face=Arialspan style='font-size:10.0pt;
font-family:Arial'TEXT WAS HERE/span/fonto:p/o:p/p

p class=MsoNormalfont size=3 face=Times New Romanspan style='font-size:
12.0pt'o:pnbsp;/o:p/span/font/p

/div

/body

/html

SYSTEM DETAILS:

CentOS release 4.5
RT 3.6.3

FastCgiIpcDir /var/cache/rt3

VirtualHost rt.domain.com.net:443
   ServerAdmin [EMAIL PROTECTED]
   ServerName  rt.domain.com.net
   TransferLog /var/log/httpd/access_log
   ErrorLog/var/log/httpd/error_log
   DocumentRoot /opt/rt3/share/html

   SSLEngine on
   SSLCertificateFile /etc/httpd/conf/ssl/rt.domain.com.net.crt
   SSLCertificateKeyFile /etc/httpd/conf/ssl/rt.domain.com.net.key
   SSLCACertificateFile /etc/httpd/conf/ssl/sf_issuing.crt

   AddDefaultCharset UTF-8
   AddHandler fastcgi-script .fcgi

   Directory /opt/rt3/share/html
   Options FollowSymLinks ExecCGI
   AllowOverride None
   /Directory

   Alias /NoAuth/images /opt/rt3/share/html/NoAuth/images
   ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/


/VirtualHost
___
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] Display problem in both RT 3.6.1 and 3.6.4

2007-07-09 Thread Sean
Hi,

I've searched the message archives and found someone else mentioning this 
problem, but found no solution. 

Basically, in both RT 3.6.1 and 3.6.4, when I am seeing the following problem:

1. Sometimes menu bars across the top jump down a line or two when I move my 
mouse over them.
This happens in IE 6 and IE 7, but not firefox
2. On the RT At a glance page (and not really any others off the top of my 
head) The right-hand border
of the boxes (plus 1/2 a character) is chopped off (no moving the scroll 
bar to the side either)
This happens in IE 6 and IE 6, but not firefox

and

3. (This is where this problem really affects me) - I created a custom field 
that was a combo-box
I have created the box with anywhere between 1 and 7 entries, and still 
have the problem - 
when going to the ticket to edit the drop-down, the drop-down does not 
appear. I can highlight
around the box, I can type text into the white-space where the box should 
be and even save
what I type - but no drop-down capabilities (so no choosing) - the funny 
thing is - to create
the custom field, I use a combo-box on the create a custom field page, so I 
know that the actual
javascript code and my browser work with it.
Again -- This happens  in IE 6 and IE 7, but not firefox

Nearest I can tell, this may be a problem with the way IE parses older CSS, 
which is why I upgraded
my RT to 3.6.4, but this didn't fix it.

I really wouldn't care if it was just #1 and #2, but #3 is really going to have 
a huge impact if i can't implement the combo-box.

 I will be more than happy to gather any required information in order to 
assist in figuring this out.

Thanks,
Jeff


   

Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.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] Is it possible to bulk-import into RTx::AssetTracker ?

2007-07-09 Thread Sean
Hi,

I was able once to find someone asking about bulk importing into AssetTracker, 
but have been unable to re-find the answer. Does anyone know if this is 
possible? We just did a huge inventory, and I would love to get my team using 
AssetTracker, and the ability to rapidly get all of the data we put into 
spreadsheets into RT/AssetTracker would be huge.

Thanks,
Jeff


  

Shape Yahoo! in your own image.  Join our Network Research Panel today!   
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 


___
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] Assigning Tickets

2007-07-09 Thread Canale, Marc
Okay, our general setup is this:

Group1 - Queue1

Group2 - Queue2

I want to be able for Group1 to move a ticket into Queue2 but NOT be able to
see any of the tickets in Queue2 and vice versa.

Is this possible?

Thanks,
Marc


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

[rt-users] posts not making to the database

2007-07-09 Thread Ram Prasad
I am having a weird issue ...

When I try to post to rt, the mail makes to the list and to the mail
gateway and a response is sent to poster. But, it is not there in the
database at all. But, if I restart apache, click on each receips (and
save) for the list, it works .. but only for sometime. Could someone
help me with this please ?

I see these in the log:


[Mon Jul  2 15:20:32 2007] [warning]: Use of uninitialized value in
concatenation (.) or string at
/usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm line 425.
(/usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm:425)
[Mon Jul  2 15:20:32 2007] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm:505)
[Mon Jul  2 15:20:33 2007] [warning]: RT::Handle=HASH(0xb5b32a8)
couldn't execute the query 'SELECT ACL.id from ACL, Groups, Principals,
CachedGroupMembers WHERE  (ACL.RightName = 'SuperUser' OR  ACL.RightName
= 'SeeQueue') AND Principals.Disabled = 0 AND
eval {...} called at
/usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 1252
HTML::Mason::Request::comp('undef', 'undef', 'undef',
'SessionType', 'REST', 'action', 'correspond', 'queue', 'iskme-feature',
...) called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm
line 466


___
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] Odd DB errors

2007-07-09 Thread Oliver Hookins
Hi RT gang,

recently we've started experiencing what looks like database errors in our
RT 3.4.2 installation. We're using it with PostgreSQL 7.4.17 on RHEL4, and
get some errors in the web interface like the following:

error: DBD::Pg::st execute failed: ERROR: current transaction is
aborted, commands ignored until end of transaction block
context:
...
63:
64: $self-{update_sth}-bind_param(1, $session-{serialized});
65: $self-{update_sth}-bind_param(2, $session-{data}-{_session_id});
66:
67: $self-{update_sth}-execute;
68:
69: $self-{update_sth}-finish;
70: }
71:
...
code stack: /usr/lib/perl5/site_perl/5.8.5/Apache/Session/Store/DBI.pm:67   
/usr/lib/perl5/site_perl/5.8.5/Apache/Session.pm:523
/usr/lib/perl5/site_perl/5.8.5/Apache/Session.pm:477
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:1078
raw error

In the RT log there are a lot of messages (most of which look like
diagnostics) but this one caught my eye:

[Mon Jul  9 21:17:29 2007] [warning]: DBD::Pg::st execute failed: ERROR:
access to noncontiguous page in hash index transactions_oid
 (/opt/rt3/lib/RT.pm:277)

The only thing that occurred to me was that the indexes needed rebuilding on
that table, which I did, but the problem has come back. I'm not sure if the
error messages are related.

I also have reports from users that they get errors like message not
recorded when adding comments occasionally.

Any ideas what all this might mean?

--
Regards,
Oliver
___
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