[rt-users] Reading commits from external file

2006-05-23 Thread Michael Pickard






I would like to adapt an existing bash script so that
rather than committing the whole of a particular working directory it only
commits those changes identified in the external file.



For example, the external file might contain only two
lines

/src/com/mydomain/myclass.java

/src/com/mydomain/myotherclass.java



In this case my script would (loop?) through the
lines committing each in turn



e.g. svn commit m Passed testing
[filepath from external file]



Does anyone have experience of anything like this ?
Am I missing anything obvious ?



TIA,

Michael









Michael PickardSoftware EngineerVisit London6th Floor,
2 More London Riverside, London, SE1 2RR



Tel: +44 (0)20 7234 5857Fax: +44 (0)20 7234 5751www.visitlondon.com





Visit London is the official visitor organisation for London. Visit London is partly funded by Partnership, the Mayor's London Development Agency and the Association of London Government.


The information contained in this e-mail is confidential and intended for the named recipient(s) only. If you have received it in error, please notify the sender immediately and then delete the message. If you are not the intended recipient, you must not use, disclose, copy or distribute this email. The views expressed in this e-mail are those of the individual and not of Visit London. We reserve the right to read and monitor any email or attachment entering or leaving our systems without prior notice.

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

RE: [rt-users] Reading commits from external file

2006-05-23 Thread Michael Pickard






Apologies to all  wrong list!











From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Pickard
Sent: 23 May 2006 09:47
To:
rt-users@lists.bestpractical.com
Subject: [rt-users] Reading commits from
external file







I would like to adapt an existing bash script so that
rather than committing the whole of a particular working directory it only
commits those changes identified in the external file.



For example, the external file might contain only two
lines

/src/com/mydomain/myclass.java

/src/com/mydomain/myotherclass.java



In this case my script would (loop?) through the
lines committing each in turn



e.g. svn commit m Passed testing
[filepath from external file]



Does anyone have experience of anything like this ?
Am I missing anything obvious ?



TIA,

Michael











Michael Pickard
Software Engineer
Visit London
6th Floor, 2 More London Riverside,
London, SE1 2RR 











Tel: +44 (0)20 7234 5857
Fax: +44 (0)20 7234 5751
www.visitlondon.com












Visit London
is the official visitor organisation for London.
Visit London is
partly funded by Partnership, the Mayor's London Development Agency and the
Association of London Government. 





The information contained in this e-mail
is confidential and intended for the named recipient(s) only. If you have
received it in error, please notify the sender immediately and then delete the
message. If you are not the intended recipient, you must not use,
disclose, copy or distribute this email. The views expressed in this e-mail are
those of the individual and not of Visit London. We reserve the right to read
and monitor any email or attachment entering or leaving our systems without
prior notice.











Michael PickardSoftware EngineerVisit London6th Floor,
2 More London Riverside, London, SE1 2RR



Tel: +44 (0)20 7234 5857Fax: +44 (0)20 7234 5751www.visitlondon.com





Visit London is the official visitor organisation for London. Visit London is partly funded by Partnership, the Mayor's London Development Agency and the Association of London Government.


The information contained in this e-mail is confidential and intended for the named recipient(s) only. If you have received it in error, please notify the sender immediately and then delete the message. If you are not the intended recipient, you must not use, disclose, copy or distribute this email. The views expressed in this e-mail are those of the individual and not of Visit London. We reserve the right to read and monitor any email or attachment entering or leaving our systems without prior notice.

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] RE :Installation Tips

2006-05-23 Thread James Yogo

Hi,

I am really interested in implementing a ticketing system for my 
organisation. I am buffled by what peaple say about it but unfortunately i 
have been defeated on installing the system.


Could someone out there lend a hand probably on Suse 9 or Fedora platforms. 
I have tried on redhad in vain.


Regards,

James Y.

_
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


___
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



We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] problems with rt-mailgate

2006-05-23 Thread Andreas Sinn
Title: problems with rt-mailgate 






When I try to send an email for commenting, the i get the following error:


linuxtest sendmail[9925]: k4N9VXf2009923: to=|/etc/smrsh/rt-mailgate --queue General --debug --action comment --url http://linuxtest/, ctladdr=[EMAIL PROTECTED] (8/0), delay=00:00:01, xdelay=00:00:01, mailer=prog, pri=34832, dsn=4.0.0, stat=Deferred: prog mailer (/usr/sbin/smrsh) exited with EX_TEMPFAIL

please help



___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] changing RT name

2006-05-23 Thread Vladimir Jirasek
Hello,we want to change the RT name but to make sure that the old correspondence is not lost we want to be able to receive emails with both RT names. I did try to change emailparser.pm
 but no luck.Has anyone succeeded? There is a little help in Wiki and I hope I can update it once all is OK.RegardsVladimir
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

RE: [rt-users] RTx::Statistics install issues (found a thread, but no resolution)

2006-05-23 Thread Kelly F. Hickel
Paul,
You said that you're moving your RT from one server to another,
was Statistics working before the move?

Did you move it by installing as if a clean installation on the new
server, or did you just copy /opt/rt3?

You definitely should *not* just unpack the archive in /opt/rt3, follow
the instructions in the README file to run make. Since you've unpacked
the archive directly, if it was me, I'd remove /opt/rt3 and start over
(since rt doesn't take that long to install).  The errors that your
seeing don't ring any bells with me as to what the problem is.

-- 

Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
[EMAIL PROTECTED]


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:rt-users-
 [EMAIL PROTECTED] On Behalf Of Paul Crossman
 Sent: Monday, May 22, 2006 1:25 PM
 To: rt-users@lists.bestpractical.com
 Subject: [rt-users] RTx::Statistics install issues (found a thread,but
 no resolution)
 
 I'm having issues with an RTx::Statistics 1.0.8 installation and this
 thread in the list
 (http://archives.free.net.ph/message/20060105.052158.ffebdbaa.en.html)
 is the exact problem I'm having, however the thread just ends with no
 resolution.  If you are one of the posters having this problem (Bill
 and/or Austin), could you contact me with your eventual solution if
 you
 ever found one?
 
 I'm moving my RT installation from one RHEL sever to another and the
 link for Statistics doesn't show up on the left column on the new
 server.
 
 The only strange thing I can see is this error appears on my apache
 error.log.
 
 [Mon May 22 11:47:08 2006] [error] [client 1.2.3.4] FastCGI: server
 /opt/rt3/bin/mason_handler.fcgi stderr: Use of uninitialized value
 in
 length at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Resolver/File.pm
 line 52., referer: http://myrtserver.tvguide.com/rt/
 
 Current config:
 RT 3.4.2
 RHEL 4
 
 I've tried both using the Makefile and just copying the files to
 /opt/rt3/share.
 
 I can go to links by hand, but I can't click on any in the Stats
 screens.  I get HTTP errors.
 
 Example:
 
 System error
 error:could not find component for initial path
 '/RTx/OpenStalled/index.html' (component roots are:
 '/opt/rt3/local/html', '/opt/rt3/share/html')
 context:
 ...
 200:  $self-{out_method} = sub { $$bufref .= $_[0] };
 201:  }
 202:  $self-{use_internal_component_caches} =
 203:  $self-{interp}-use_internal_component_caches;
 204:  $self-_initialize;
 205:
 206:  return $self;
 207:  }
 208:
 ...
 code stack:
   /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:204
 /usr/lib/perl5/site_perl/5.8.5/Class/Container.pm:275
 /usr/lib/perl5/site_perl/5.8.5/Class/Container.pm:353
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Interp.pm:348
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Interp.pm:342
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm:123
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm:73
 /opt/rt3/bin/mason_handler.fcgi:76
 raw error
 
 
 Any help would be appreciated.
 
 Thanks,
 Paul C.
 
 ___
 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
 
 
 We're hiring! Come hack Perl for Best Practical:
 http://bestpractical.com/about/jobs.html
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] RE :Installation Tips

2006-05-23 Thread Dmitri Tikhonov
On Tue, 2006-05-23 at 05:18 -0400, James Yogo wrote:
 Could someone out there lend a hand probably on Suse 9 or Fedora
 platforms.
 I have tried on redhad in vain.

On Fedora Cora 5, installing RT is as easy as

  # yum install rt3

They really did a great job of packaging RT, those Fedora guys.  I
recommend.

  - Dmitri.


___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Multiple tickets per incoming email

2006-05-23 Thread Schultz, Eric
United *On*line, not United *Air*lines :-)

Eric Schultz
United *On*line 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf 
 Of Vivek Khera
 Sent: Monday, May 22, 2006 2:08 PM
 To: RT-Users list
 Subject: Re: [rt-users] Multiple tickets per incoming email
 
 
 On May 18, 2006, at 11:37 AM, Schultz, Eric wrote:
 
  Eric Schultz
  United Online
 
 Heh... i'm reading and responding to my email (offline) on a United  
 flight from frankfurt to washington... when do we get satellite  
 hookups to the net?  Then I could check my RT status too... :-)
 
 
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] Question about ticket appearance.

2006-05-23 Thread Kristopher Lusk








Hello List,



We would like to be able to tell which comments in the
tickets are ours, and which comments come from customers  just by
looking at the comment. As sometimes comments and replies can become very
wordy, it would be nice to be able to jump right to customer issues in order to
handle them more quickly. Is there any significance to the blue/green/grey/white/red
color scheme on the tickets? If not is there a way to change how the text
appears (font, color, format), or the cell background color, dependant upon
which link (Reply, Comment) is clicked? Does RT support this? Please
advise.



Thanks,

Kris






___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

[rt-users] ticket taking a long time to draw

2006-05-23 Thread George Barnett

Hi,

Tickets are taking a very long time to draw on our RT install.  After a 
bit of digging, I've found it's the 'More about XYZ' box that lists 
other tickets the user has open.


This query:

SELECT DISTINCT main.* FROM (((Tickets main  JOIN Groups Groups_1  ON ( 
Groups_1.Instance = main.id))  LEFT JOIN CachedGroupMembers 
CachedGroupMembers_2  ON ( CachedGroupMembers_2.GroupId = Groups_1.id) 
AND( (CachedGroupMembers_2.GroupId != CachedGroupMembers_2.MemberId))) 
LEFT JOIN Users Users_3  ON ( Users_3.id = 
CachedGroupMembers_2.MemberId))   WHERE ((Groups_1.Domain = 
'RT::Ticket-Role')) AND ((Groups_1.Type = 'Requestor')) AND 
((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND 
((main.Type = 'ticket')) AND ( (  ( (Users_3.EmailAddress = 
'[EMAIL PROTECTED]') )  ) AND ( (main.Status = 'new')OR(main.Status = 
'open') ) )  ORDER BY main.Priority DESC  LIMIT 10;


We have around 800K tickets in the database and this is causing the 
select to take about 16 seconds.  The DB server isn't small either, it's 
a 4 way opteron.


after doing an explain select, I noticed the row estimate of 230K
++-+--++-++-+---++--+ 
| id | select_type | table| type   | possible_keys   | 
key| key_len | ref   | rows   | 
Extra| 
++-+--++-++-+---++--+ 
|  1 | SIMPLE  | Groups_1 | ref| Groups1,Groups2 | 
Groups2|  65 | const | 231336 | 
Using where; Using temporary; Using filesort |
|  1 | SIMPLE  | main | eq_ref | PRIMARY | 
PRIMARY|   4 | rt3.Groups_1.Instance |  1 | 
Using where|
|  1 | SIMPLE  | CachedGroupMembers_2 | ref| DisGrouMem  | 
DisGrouMem |   5 | rt3.Groups_1.id   |  1 | 
Using index; Distinct|
|  1 | SIMPLE  | Users_3  | eq_ref | PRIMARY,Users4  | 
PRIMARY|   4 | rt3.CachedGroupMembers_2.MemberId |  1 | 
Using where; Distinct|

++-+--++-++-+---++--+

Hence I have added an index on Groups(Domain,Type) which has lowered 
this number to 20k, however it still takes ages.


Is there something I'm missing?

rt 3.4.5
searchbuilder 1.37





--
George Barnett
Reality Engineer

m: (+44) 797 457 1868
e: [EMAIL PROTECTED]

Hello?  Enema Bondage?  I'm calling because I want to be happy, I guess ...
___
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



We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] RT mail gateway

2006-05-23 Thread James Lee
hi,
i have a question on setting up mail gateway for RT. 
we're using rt3.2.2 with about 200 queues.  is it
possible to setup the gateway so that when someone
reply to a ticket, the gateway would read the subject
of the mail and utilize the ticket number in the
subject field to update the ticket?  from looking at
the documentation, email alias are setup to a specific
queue so we'd have hundreds of email aliases and
everytime we add a new queue we'd have to add another
email alias.  is this correct?  thanks
jim

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Multiple tickets per incoming email

2006-05-23 Thread Vivek Khera
duh.  and i even know that untd.com is juno, bluelight, etc.  sorry.   
that's what happens at 2am (or was it 8pm) when you're messing up  
timezones.




On May 23, 2006, at 11:02 AM, Schultz, Eric wrote:


United *On*line, not United *Air*lines :-)

Eric Schultz
United *On*line


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Vivek Khera
Sent: Monday, May 22, 2006 2:08 PM
To: RT-Users list
Subject: Re: [rt-users] Multiple tickets per incoming email


On May 18, 2006, at 11:37 AM, Schultz, Eric wrote:


Eric Schultz
United Online


Heh... i'm reading and responding to my email (offline) on a United
flight from frankfurt to washington... when do we get satellite
hookups to the net?  Then I could check my RT status too... :-)






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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Re: [rt-users] RT mail gateway

2006-05-23 Thread Stephen Turner

At Tuesday 5/23/2006 11:19 AM, James Lee wrote:

hi,
i have a question on setting up mail gateway for RT.
we're using rt3.2.2 with about 200 queues.  is it
possible to setup the gateway so that when someone
reply to a ticket, the gateway would read the subject
of the mail and utilize the ticket number in the
subject field to update the ticket?


This is the default behavior - you're all set on that one.


  from looking at
the documentation, email alias are setup to a specific
queue so we'd have hundreds of email aliases and
everytime we add a new queue we'd have to add another
email alias.  is this correct?  thanks
jim


Yes - but it's not too hard to automate this. We have a cron job that 
sweeps through the queue mail addresses regularly and makes the 
corresponding updates to the aliases file.


Steve 


___
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



We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] RTx::Statistics install issues (found a thread, but no resolution)

2006-05-23 Thread Paul Crossman
Yes, I have Statistics working on the current servers.  Works great too.

I'm doing the move by installing everything from scratch on the new
server and then importing the mysql database from the existing
environment.  I'm installing Statistics post importing the database
though.  Any thoughts on that? 

As far as the error goes, I don't get them on my existing server.

Paul C.

 -Original Message-
 From: Kelly F. Hickel [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, May 23, 2006 8:08 AM
 To: Paul Crossman; rt-users@lists.bestpractical.com
 Subject: RE: [rt-users] RTx::Statistics install issues (found a
thread,but
 no resolution)
 
 Paul,
   You said that you're moving your RT from one server to another,
 was Statistics working before the move?
 
 Did you move it by installing as if a clean installation on the new
 server, or did you just copy /opt/rt3?
 
 You definitely should *not* just unpack the archive in /opt/rt3,
follow
 the instructions in the README file to run make. Since you've unpacked
 the archive directly, if it was me, I'd remove /opt/rt3 and start over
 (since rt doesn't take that long to install).  The errors that your
 seeing don't ring any bells with me as to what the problem is.
 
 --
 
 Kelly F. Hickel
 Senior Software Architect
 MQSoftware, Inc
 952.345.8677
 [EMAIL PROTECTED]
 
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:rt-users-
  [EMAIL PROTECTED] On Behalf Of Paul Crossman
  Sent: Monday, May 22, 2006 1:25 PM
  To: rt-users@lists.bestpractical.com
  Subject: [rt-users] RTx::Statistics install issues (found a
thread,but
  no resolution)
 
  I'm having issues with an RTx::Statistics 1.0.8 installation and
this
  thread in the list
 
(http://archives.free.net.ph/message/20060105.052158.ffebdbaa.en.html)
  is the exact problem I'm having, however the thread just ends with
no
  resolution.  If you are one of the posters having this problem (Bill
  and/or Austin), could you contact me with your eventual solution if
  you
  ever found one?
 
  I'm moving my RT installation from one RHEL sever to another and the
  link for Statistics doesn't show up on the left column on the new
  server.
 
  The only strange thing I can see is this error appears on my apache
  error.log.
 
  [Mon May 22 11:47:08 2006] [error] [client 1.2.3.4] FastCGI: server
  /opt/rt3/bin/mason_handler.fcgi stderr: Use of uninitialized value
  in
  length at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Resolver/File.pm
  line 52., referer: http://myrtserver.tvguide.com/rt/
 
  Current config:
  RT 3.4.2
  RHEL 4
 
  I've tried both using the Makefile and just copying the files to
  /opt/rt3/share.
 
  I can go to links by hand, but I can't click on any in the Stats
  screens.  I get HTTP errors.
 
  Example:
 
  System error
  error:  could not find component for initial path
  '/RTx/OpenStalled/index.html' (component roots are:
  '/opt/rt3/local/html', '/opt/rt3/share/html')
  context:
  ...
  200:$self-{out_method} = sub { $$bufref .= $_[0] };
  201:}
  202:$self-{use_internal_component_caches} =
  203:$self-{interp}-use_internal_component_caches;
  204:$self-_initialize;
  205:
  206:return $self;
  207:}
  208:
  ...
  code stack:
  /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:204
  /usr/lib/perl5/site_perl/5.8.5/Class/Container.pm:275
  /usr/lib/perl5/site_perl/5.8.5/Class/Container.pm:353
  /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Interp.pm:348
  /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Interp.pm:342
  /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm:123
  /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm:73
  /opt/rt3/bin/mason_handler.fcgi:76
  raw error
 
 
  Any help would be appreciated.
 
  Thanks,
  Paul C.
 
  ___
  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
 
 
  We're hiring! Come hack Perl for Best Practical:
  http://bestpractical.com/about/jobs.html
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] RE :Installation Tips

2006-05-23 Thread Les Mikesell
On Tue, 2006-05-23 at 07:43, Dmitri Tikhonov wrote:
 On Tue, 2006-05-23 at 05:18 -0400, James Yogo wrote:
  Could someone out there lend a hand probably on Suse 9 or Fedora
  platforms.
  I have tried on redhad in vain.
 
 On Fedora Cora 5, installing RT is as easy as
 
   # yum install rt3
 
 They really did a great job of packaging RT, those Fedora guys.  I
 recommend.
 

Do you know if it is possible to install asset tracker on
top of it?

-- 
  Les Mikesell
   [EMAIL PROTECTED]


___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] RE :Installation Tips

2006-05-23 Thread Dmitri Tikhonov
On Tue, 2006-05-23 at 13:10 -0400, Les Mikesell wrote:
 Do you know if it is possible to install asset tracker on
 top of it?

That I don't know, sorry.

  - Dmitri.


___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] RE :Installation Tips

2006-05-23 Thread Les Mikesell
On Tue, 2006-05-23 at 14:04, Frank Pater wrote:
 Hi Les,
 
 On our CentOS 4.3 (Final) RT server, the stock mod_perl,
 according to yum, is 1.99_16-4.centos4. This prevents
 RT 3.4.5 from building properly with mod_perl, iirc. Are
 you using an additional repository, by any chance? The
 various CentOS mirrors seem to confirm this mod_perl version.

Ah, that's it.  It is included in the repository added when
you follow the instructions for yum at:
http://wiki.bestpractical.com/index.cgi?RPMInstall.
I was just confused by the wiki changes that seem to have
been added later about rebuilding mod_perl because that
wasn't necessary for me.  The yum install did it all.

-- 
  Les Mikesell
   [EMAIL PROTECTED]


___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] RT ignoring reply-to address queue setting

2006-05-23 Thread Joe Auty
I have my RT queues configured with appropriate reply-to and comment- 
to addresses, but tickets that are emailed are set with reply-to  
addresses differing from this setting. My DNS entry for the machine  
is only a CNAME, and because of our networking structure and this  
machine sitting behind a router and being assigned a private IP  
address, it is not possible to create an A record for this machine.


Is this a bug? What are these queue settings for if not for  
controlling how outgoing email headers will be set as?



---
Joe Auty
UITS Messaging
Indiana University
[EMAIL PROTECTED]






PGP.sig
Description: This is a digitally signed message part
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

RE: [rt-users] RTx::Statistics install issues (found a thread, but no resolution)

2006-05-23 Thread Kelly F. Hickel

 -Original Message-
 From: Paul Crossman [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, May 23, 2006 2:44 PM
 To: Kelly F. Hickel; rt-users@lists.bestpractical.com
 Subject: RE: [rt-users] RTx::Statistics install issues (found a
 thread,but no resolution)
 
 I actually just finished flushing my install at the destination.
 
 Just an initial DB.
 
 Still no go.
 
 [Tue May 23 14:34:29 2006] [error] [client 172.28.8.23] FastCGI:
 server
 /opt/rt3/bin/mason_handler.fcgi stderr: Use of uninitialized value
 in
 concatenation (.) or string at
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Resolver/File.pm line 51.
 [Tue May 23 14:34:29 2006] [error] [client 172.28.8.23] FastCGI:
 server
 /opt/rt3/bin/mason_handler.fcgi stderr: Use of uninitialized value
 in
 length at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Resolver/File.pm
 line 52.
 
 Those errors show up in the httpd error log.
 
 The installation I have that works all the Statistics files are
 root:root and the RT3 files are root:bin.  Everything works fine.
 Could
 the HTML::Mason perl module be a problem?  How can I remove the module
 and reinstall it?

[Kelly F. Hickel] Well, is Statistics the only thing that isn't working,
or is the rest of RT broken too?  Fixing Mason installation problems is
beyond me, I consider myself lucky when I can get through a clean
install and everything is working!

 
 Paul C.
 
  -Original Message-
  From: Kelly F. Hickel [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, May 23, 2006 3:34 PM
  To: Paul Crossman; rt-users@lists.bestpractical.com
  Subject: RE: [rt-users] RTx::Statistics install issues (found a
 thread,but
  no resolution)
 
  Paul,
  It looks like the files in rt3/share are from unpacking the
  archive directly, so I'd remove those listed below first.  Then do
 an
 ls
  -l in /opt/rt3/share/html.  I find that when I install statistics I
 do
  it as root, but my whole /opt/rt3 tree has to be owned by
 apache.apache.
  So, if the directories /opt/rt3/share/RTx, /opt/rt3/share/Callbacks
 and
  /opt/rt3/share/Callbacks/kStatistics (and all their children) aren't
  owned by the same user and group as the other directories in
  /opt/rt3/share, do a chown -R on the and try again
 
  --
 
  Kelly F. Hickel
  Senior Software Architect
  MQSoftware, Inc
  952.345.8677
  [EMAIL PROTECTED]
 
 
   -Original Message-
   From: Paul Crossman [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, May 23, 2006 2:03 PM
   To: Kelly F. Hickel; rt-users@lists.bestpractical.com
   Subject: RE: [rt-users] RTx::Statistics install issues (found a
   thread,but no resolution)
  
   Sure!!!
  
   /opt/rt3 is the original working system.
   rt3/ is a exploded tar from the system I'm migrating to.
  
   # diff -r /opt/rt3/ rt3/
   Only in rt3/etc: RCS
   diff -r /opt/rt3/etc/RT_SiteConfig.pm rt3/etc/RT_SiteConfig.pm
   279c279
Set($WebBaseURL , http://source.tvguide.com:80;);
   ---
Set($WebBaseURL , http://destination.tvguide.com:80;);
   Only in /opt/rt3/local/html: Callbacks
   Only in /opt/rt3/local/html/NoAuth: webrt.css.matt
   Only in /opt/rt3/local/html/NoAuth: webrt.css.orig
   Only in /opt/rt3/local/html/NoAuth: webrt.css.working
   Only in /opt/rt3/local/html: RTx
   Only in /opt/rt3/local/lib: auto
   Only in rt3/share: CHANGELOG
   Only in rt3/share: MANIFEST
   Only in rt3/share: META.yml
   Only in rt3/share: Makefile.PL
   Only in rt3/share: README
   Only in rt3/share: inc
   Only in rt3/share: lib
   Only in rt3/var/mason_data: etc
   Only in rt3/var/mason_data/obj: .__obj_create_marker
  
   Paul C.
  
  
-Original Message-
From: Kelly F. Hickel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 1:30 PM
To: Paul Crossman; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RTx::Statistics install issues (found a
   thread,but
no resolution)
   
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:rt-
 users-
 [EMAIL PROTECTED] On Behalf Of Paul Crossman
 Sent: Tuesday, May 23, 2006 11:43 AM
 To: rt-users@lists.bestpractical.com
 Subject: RE: [rt-users] RTx::Statistics install issues (found
 a
 thread,but no resolution)

 Yes, I have Statistics working on the current servers.  Works
   great
 too.

 I'm doing the move by installing everything from scratch on
 the
   new
 server and then importing the mysql database from the existing
 environment.  I'm installing Statistics post importing the
   database
 though.  Any thoughts on that?
[Kelly F. Hickel] Doesn't seem like that should cause a problem.
   

 As far as the error goes, I don't get them on my existing
 server.
[Kelly F. Hickel] Is it feasible to run a diff between the two
   /opt/rt3
directories?
   

 Paul C.
   
[Kelly F. Hickel] -Kelly
   

  -Original Message-
  From: Kelly F. Hickel [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, May 23, 2006 8:08 AM
  To: Paul Crossman; 

[rt-users] Spreadsheet view displays more columns than in search

2006-05-23 Thread Flynn, Timothy J

When my users are searching for tickets, they select the columns they
want and then search.  A lot of them like the spreadsheet view so they
can make reports.  One problem is in the spreadsheet view there are a
lot of extra columns that they didn't add.  They appear to be most of
the default time fields in RT (IE, told date, due date, etc).  Is there
a way to omit these?

RT 3.4.5

Thanks!
-Tim
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Spreadsheet view displays more columns than in search

2006-05-23 Thread Schultz, Eric

 When my users are searching for tickets, they select the columns they
 want and then search.  A lot of them like the spreadsheet view so they
 can make reports.  One problem is in the spreadsheet view there are a
 lot of extra columns that they didn't add.  They appear to be most of
 the default time fields in RT (IE, told date, due date, etc). 
  Is there
 a way to omit these?
 
 RT 3.4.5

This is what you want:
http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields
It was vandalized, so I reverted to the previous saved version.

Eric Schultz
United Online
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] Modifying RT Email Address Question

2006-05-23 Thread Timothy Ewing

Hi,

I am trying to get RT to send out email in a specific form and have
been unable to do so to this point.  I'm writing to the list in hopes
that someone else has solved this problem or can point me in the right
direction.

I have a Linux system running RT with an IP address of 172.20.8.103.
This IP address is actually listed as hostname.some.domain.com and
it's also listed in hostname.domain.com (depending on the nameserver
used).  This IP address is tied to RT specifically (meaning that the
Apache/RT configuration can failover to one of three machines).

Here is a brief description of my environment

Physical Host A = 172.20.8.31   (hostname = ccla1g.some.domain.com)
Physical Host B = 172.20.8.32   (hostname = ccla2g.some.domain.com)
Physical Host C = 172.20.8.33   (hostname = ccla3g.some.domain.com)

RT Service = 172.20.8.103  (vcalgn1g.some.domain.com)

These names are according to the nameserver authoritative for some.domain.com.

When a ticket is created, email goes out as it should.  When I open
the email it shows Lastname, Firstname via RT
[EMAIL PROTECTED]

Since 172.20.8.103 is tied to RT, I want the change the email so that
when someone replies it goes to [EMAIL PROTECTED]).

In other words I want the ticket to read as follows:
Lastname, Firstname via RT [EMAIL PROTECTED]

I don't really want to make a global sendmail change.  What I want to
do is make a change such that when RT sends tickets out, it shows the
shorter domain.

Let me know if this does not make sense and I'll try to do a better
job explaining.

- Tim
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Spreadsheet view displays more columns than in search

2006-05-23 Thread Flynn, Timothy J
Thanks Eric,  do you know why I'd be getting different results in
spreadsheet vs the web list?  On one report I am getting 14 tickets in
the web view and in the spreadsheet I am getting 11 and the data is
wrong..  FYI the web results are correct and the spreadsheet is not.  Is
something not being escaped that is affecting the query?

-Tim
 

-Original Message-
From: Schultz, Eric [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 23, 2006 3:32 PM
To: Flynn, Timothy J; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 


 When my users are searching for tickets, they select the columns they
 want and then search.  A lot of them like the spreadsheet view so they
 can make reports.  One problem is in the spreadsheet view there are a
 lot of extra columns that they didn't add.  They appear to be most of
 the default time fields in RT (IE, told date, due date, etc). 
  Is there
 a way to omit these?
 
 RT 3.4.5

This is what you want:
http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields
It was vandalized, so I reverted to the previous saved version.

Eric Schultz
United Online
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] User creation via e-mail

2006-05-23 Thread Schultz, Eric
 As far as I can understand when a new user sends e-mail to RT for the
 first time he is created in RT databases, but he cannot logon to RT.
 
 But what should I do if I do not want to create users by e-mail? only
 registered users should be able to create tickets. If user 
 whose e-mail is
 not in RT database sends an e-mail to RT I want the e-mail to bounce,
 without creating the user in RT databases.
 
 I do not want the external users to post and create tickets, 
 since this
 invites spam. Is there a smimple way to block user creation by e-mail?
 There must be, I am sure.

Maybe this from RT_Config.pm?

# If $SenderMustExistInExternalDatabase is true, RT will refuse to
# create non-privileged accounts for unknown users if you are using
# the LookupSenderInExternalDatabase option.
# Instead, an error message will be mailed and RT will forward the
# message to $RTOwner.
#
# If you are not using $LookupSenderInExternalDatabase, this option
# has no effect.
#
# If you define an AutoRejectRequest template, RT will use this
# template for the rejection message.

Set($SenderMustExistInExternalDatabase , undef);

But it looks like you have to have $LookupSenderInExternalDatabase, and
I don't see that defined in RT_Config.pm.  Also, not sure if you can
fool things and have $LookupSenderInExternalDatabase really be local.

Eric Schultz
United Online
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Spreadsheet view displays more columns than in search

2006-05-23 Thread Schultz, Eric
Only thing I can think of is that you somehow modified the query before
doing one query vs. the other?  Maybe using the browser navigation vs.
the application navigation?  If the spreadsheet had more, I would say it
could be something with that query being less restrictive, but that's
not the case.

 Thanks Eric,  do you know why I'd be getting different results in
 spreadsheet vs the web list?  On one report I am getting 14 tickets in
 the web view and in the spreadsheet I am getting 11 and the data is
 wrong..  FYI the web results are correct and the spreadsheet 
 is not.  Is
 something not being escaped that is affecting the query?
 
 -Tim
  
 
 -Original Message-
 From: Schultz, Eric [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, May 23, 2006 3:32 PM
 To: Flynn, Timothy J; rt-users@lists.bestpractical.com
 Subject: RE: [rt-users] Spreadsheet view displays more columns than in
 search 
 
 
  When my users are searching for tickets, they select the 
 columns they
  want and then search.  A lot of them like the spreadsheet 
 view so they
  can make reports.  One problem is in the spreadsheet view 
 there are a
  lot of extra columns that they didn't add.  They appear to 
 be most of
  the default time fields in RT (IE, told date, due date, etc). 
   Is there
  a way to omit these?
  
  RT 3.4.5
 
 This is what you want:
 http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields
 It was vandalized, so I reverted to the previous saved version.
 
 Eric Schultz
 United Online
 
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] User creation via e-mail

2006-05-23 Thread Stephen Turner

At Tuesday 5/23/2006 04:37 PM, Tomasz Wlodek wrote:

Hi,

As far as I can understand when a new user sends e-mail to RT for the
first time he is created in RT databases, but he cannot logon to RT.

But what should I do if I do not want to create users by e-mail? only
registered users should be able to create tickets. If user whose e-mail is
not in RT database sends an e-mail to RT I want the e-mail to bounce,
without creating the user in RT databases.

I do not want the external users to post and create tickets, since this
invites spam. Is there a smimple way to block user creation by e-mail?
There must be, I am sure.

Any hints how to do this?


I _think_ you can do this by making sure that CreateTicket is not 
granted to Everyone - only to your registered users.


Steve 


___
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



We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html