Re: [rt-users] FW: mod_fastcgi problems

2009-08-21 Thread Emmanuel Lacour
On Fri, Aug 21, 2009 at 02:03:42PM +0100, Andrew Pike wrote:
 Hi,
 
  
 
 Regarding the below email does anyone know why I am unable to start apache?
 It seems like the fastcgi module is not installed but RT seems to report
 that it is.  Does anyone know how I can check this on Gentoo?
 


RT does not check if the module fastcgi is installed, it only checks if
the needed _perl_ support for fastcgi is installed.

For Gentoo, I cannot really help, but try to find a file named
*fastcgi.so in /usr.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Perl Books for RT

2009-08-21 Thread Eric Chatham
Thank you all for the input...I'm going to the bookstore this weekend.


CONFIDENTIAL.  This e-mail and any attached files are confidential and should 
be destroyed and/or returned if you are not the intended and proper recipient.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Perl Books for RT

2009-08-21 Thread Drew Barnes
Another option would be to see if you can convince work to pay for a Safari
books online subscription.  I have one through work and find it
indispensable.


On 8/21/09 9:27 AM, Eric Chatham echat...@broadvox.com wrote:

 Thank you all for the input...I'm going to the bookstore this weekend.
 
 
 CONFIDENTIAL.  This e-mail and any attached files are confidential and should
 be destroyed and/or returned if you are not the intended and proper recipient.
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 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 Dept.
Raymond Walters College


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] FW: mod_fastcgi problems

2009-08-21 Thread Emmanuel Lacour
On Fri, Aug 21, 2009 at 02:30:38PM +0100, Andrew Pike wrote:
 
 Hi Emmanuel,
 
 Thanks for your help!  I feel a bit of a fool but I didn't install it!!  I
 didn't search Gentoo's package manager properly with the correct full name
 (emerge -v mod_fastcgi).
 
 However, now when I start apache I get a different message, please see
 below.  Can I just disable this line referring to 'suexec2'?  I enabled it
 in my APACHE2_OPTS yesterday out of sheer desperation!
 
  ERROR 
 * apache2 has detected a syntax error in your configuration files:
 Syntax error on line 7 of /etc/apache2/vhosts.d/rt_apache2_fcgi.conf:
 FastCgiWrapper: /usr/sbin/suexec2 execute access for server (uid 81, gid
 81) failed: stat(/usr/sbin/suexec2) failed: No such file or directory
 ===
 
 



Well I personnaly never use suexec, but if you wan't to use it, as
fastcgi, check that it is installed and check the path (maybe not
/usr/sbin/suexec2).

Else, just follow fastcgi instructions in RT README file ;)


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] On saving changes to a ticket edit page displayed

2009-08-21 Thread Kenneth Marshall
On Fri, Aug 21, 2009 at 10:54:10AM +1000, gor...@cryologic.com wrote:
 I know this has been mentioned before but I haven't been able to find in 
 the lists the reason for this small, possible inconsistency.
 
 When you Update a ticket after adding a comment the modified ticket is 
 displayed.
 
 When you Save Changes to a ticket, after modifying fields in the edit 
   Basics page (for instance) the edit window remains displayed, rather 
 than returning to the ticket display page.
 
 I am sure there is a logical reason for this, and am just trying to find 
 out what it is to provide our users with an explanation.
 
 thanks
 Gordon

Hi Gordon,

One reason is that certain scip actions can be based on the settings
of particular fields. So you need to first set one field and then
another to produce the correct action. One field we have is whether
or not to send E-mail when a ticket is resolved. To have this work
you first need to set that field and then resolve the ticket.
Otherwise the mail is sent. That is one example but having to re-enter
the basics screen over and over would be clumsy at best.

Regards,
Ken
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Unable to see the Web UI - URL issues

2009-08-21 Thread Andrew Pike
Hi,

 

I've just finished installing RT and I think everything is working (just
needs configuring!).  For some reason I am unable to access via the URL (or
IP).  It navigates to a page displaying It works!.  I think it is looking
in /var/www/localhost/htdocs/index.html but I don't know why!  Can anyone
help?

 

Many thanks,

Andy

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] _default_ VirtualHost overlap on port 443, the first has precedence

2009-08-21 Thread testwreq wreq
* I have managed to get it all set up and RT running OK with named virtual
host over http. However, I am having problems with getting them to work over
https. When I set a virtual host name, it always serves the first listed
domain. See settings below. https:firstone serves the correct folder, but
https:rt serves firstone's documents

my settings:

VirtualHost *:443

DocumentRoot C:/Development/firstone
ServerName firstone
ServerAdmin webmas...@localhost
ErrorLog logs/ssl/error.log
TransferLog logs/ssl/access.log

SSLEngine on...etc
/VirtualHost

VirtualHost *:443
   ServerName rt.hostname.com
   DocumentRoot /data/rt3/share/html
   AddDefaultCharset UTF-8
   PerlModule Apache::DBI
   PerlRequire /data/rt3/bin/webmux.pl
Location /NoAuth/images
SetHandler default
/Location
   ErrorLog logs/ssl_error_log
   TransferLog logs/ssl_access_log
   LogLevel warn
   Directory /
  SSLRequireSSL
   /Directory
SSLEngine on
SSLProtocol all -SSLv2
SSLCipherSuite ALL:!ADH:!EXPORT:!SSLv2:RC4+RSA:+HIGH:+MEDIUM:+LOW
SSLCertificateFile /etc/sslcertificate/server.crt
SSLCertificateKeyFile /etc/sslcertificate/server.key
/VirtualHost
while restarting apache I get a warning  _default_ VirtualHost overlap on
port 443, the first has precedence

Any suggestions???

Thanks in advance,
rq
*
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] _default_ VirtualHost overlap on port 443, the first has precedence

2009-08-21 Thread Curtis Bruneau
Each SSL site pretty much needs to be on it's own IP address, the 
reasoning is the cert negotiation isn't name based header as apache 
would. The only other way would be to have them on different ports but 
then you'd have to specify the port when going to the site.

testwreq wreq wrote:
 *
 I have managed to get it all set up and RT running OK with named 
 virtual host over http. However, I am having problems with getting 
 them to work over https. When I set a virtual host name, it always 
 serves the first listed domain. See settings below. https:firstone 
 serves the correct folder, but https:rt serves firstone's documents

 my settings:

 VirtualHost *:443

 DocumentRoot C:/Development/firstone
 ServerName firstone
 ServerAdmin webmas...@localhost
 ErrorLog logs/ssl/error.log
 TransferLog logs/ssl/access.log

 SSLEngine on...etc
 /VirtualHost

 VirtualHost *:443
ServerName rt.hostname.com http://rt.hostname.com
DocumentRoot /data/rt3/share/html
AddDefaultCharset UTF-8
PerlModule Apache::DBI
PerlRequire /data/rt3/bin/webmux.pl
 Location /NoAuth/images
 SetHandler default
 /Location
ErrorLog logs/ssl_error_log
TransferLog logs/ssl_access_log
LogLevel warn
Directory /
   SSLRequireSSL
/Directory
 SSLEngine on
 SSLProtocol all -SSLv2
 SSLCipherSuite ALL:!ADH:!EXPORT:!SSLv2:RC4+RSA:+HIGH:+MEDIUM:+LOW
 SSLCertificateFile /etc/sslcertificate/server.crt
 SSLCertificateKeyFile /etc/sslcertificate/server.key
 /VirtualHost
 while restarting apache I get a warning  _default_ VirtualHost 
 overlap on port 443, the first has precedence
  
 Any suggestions???

 Thanks in advance,
 rq
 *
 

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 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: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] _default_ VirtualHost overlap on port 443, the first has precedence

2009-08-21 Thread testwreq wreq
Actually, I should have mentioned before that our rt installation is on a
different IP.

On Fri, Aug 21, 2009 at 11:09 AM, Curtis Bruneau curt...@vianet.ca wrote:

 Each SSL site pretty much needs to be on it's own IP address, the reasoning
 is the cert negotiation isn't name based header as apache would. The only
 other way would be to have them on different ports but then you'd have to
 specify the port when going to the site.

 testwreq wreq wrote:

 *
 I have managed to get it all set up and RT running OK with named virtual
 host over http. However, I am having problems with getting them to work over
 https. When I set a virtual host name, it always serves the first listed
 domain. See settings below. https:firstone serves the correct folder, but
 https:rt serves firstone's documents

 my settings:

 VirtualHost *:443

 DocumentRoot C:/Development/firstone
 ServerName firstone
 ServerAdmin webmas...@localhost
 ErrorLog logs/ssl/error.log
 TransferLog logs/ssl/access.log

 SSLEngine on...etc
 /VirtualHost

 VirtualHost *:443
   ServerName rt.hostname.com http://rt.hostname.com
   DocumentRoot /data/rt3/share/html
   AddDefaultCharset UTF-8
   PerlModule Apache::DBI
   PerlRequire /data/rt3/bin/webmux.pl
Location /NoAuth/images
SetHandler default
/Location
   ErrorLog logs/ssl_error_log
   TransferLog logs/ssl_access_log
   LogLevel warn
   Directory /
  SSLRequireSSL
   /Directory
SSLEngine on
SSLProtocol all -SSLv2
SSLCipherSuite ALL:!ADH:!EXPORT:!SSLv2:RC4+RSA:+HIGH:+MEDIUM:+LOW
SSLCertificateFile /etc/sslcertificate/server.crt
SSLCertificateKeyFile /etc/sslcertificate/server.key
 /VirtualHost
 while restarting apache I get a warning  _default_ VirtualHost overlap
 on port 443, the first has precedence
  Any suggestions???

 Thanks in advance,
 rq
 *
 

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 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: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] _default_ VirtualHost overlap on port 443, the first has precedence

2009-08-21 Thread Drew Barnes
Try naming the virtual hosts.  *:443 means any domain that resolves to that
machine will get the first one, since it matches.

Curtis may also be right (never tried two https sites on the same box), but
try having the first one be VirtualHost firstone:443 and the second one
VirtualHost rt:443 and see if it works for you.



On 8/21/09 11:13 AM, testwreq wreq testw...@gmail.com wrote:

 Actually, I should have mentioned before that our rt installation is on a
 different IP.
 
 On Fri, Aug 21, 2009 at 11:09 AM, Curtis Bruneau curt...@vianet.ca wrote:
 Each SSL site pretty much needs to be on it's own IP address, the reasoning
 is the cert negotiation isn't name based header as apache would. The only
 other way would be to have them on different ports but then you'd have to
 specify the port when going to the site.
 
 testwreq wreq wrote:
 * 
 
 I have managed to get it all set up and RT running OK with named virtual
 host over http. However, I am having problems with getting them to work over
 https. When I set a virtual host name, it always serves the first listed
 domain. See settings below. https:firstone serves the correct folder, but
 https:rt serves firstone's documents
 
 my settings:
 
 VirtualHost *:443
 
 DocumentRoot C:/Development/firstone
 ServerName firstone
 ServerAdmin webmas...@localhost
 ErrorLog logs/ssl/error.log
 TransferLog logs/ssl/access.log
 
 SSLEngine on...etc
 /VirtualHost
 
 VirtualHost *:443
       ServerName rt.hostname.com http://rt.hostname.com/
 http://rt.hostname.com http://rt.hostname.com/ http://rt.hostname.com
 lt;http://rt.hostname.com/  
 
       DocumentRoot /data/rt3/share/html
       AddDefaultCharset UTF-8
       PerlModule Apache::DBI
       PerlRequire /data/rt3/bin/webmux.pl
        Location /NoAuth/images
                SetHandler default
        /Location
       ErrorLog logs/ssl_error_log
       TransferLog logs/ssl_access_log
       LogLevel warn
       Directory /
          SSLRequireSSL
       /Directory
        SSLEngine on
        SSLProtocol all -SSLv2
        SSLCipherSuite ALL:!ADH:!EXPORT:!SSLv2:RC4+RSA:+HIGH:+MEDIUM:+LOW
        SSLCertificateFile /etc/sslcertificate/server.crt
        SSLCertificateKeyFile /etc/sslcertificate/server.key
 /VirtualHost
 while restarting apache I get a warning  _default_ VirtualHost overlap on
 port 443, the first has precedence
  Any suggestions???
 
 Thanks in advance,
 rq
 *
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 http://wiki.bestpractical.com/
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a
 copy at http://rtbook.bestpractical.com http://rtbook.bestpractical.com/
 
 
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 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 Dept.
 Raymond Walters College

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] On saving changes to a ticket edit page displayed

2009-08-21 Thread Jerrad Pierce
 One reason is that certain scip actions can be based on the settings
 of particular fields. So you need to first set one field and then
 another to produce the correct action. One field we have is whether
 or not to send E-mail when a ticket is resolved. To have this work
 you first need to set that field and then resolve the ticket.
 Otherwise the mail is sent. That is one example but having to re-enter
 the basics screen over and over would be clumsy at best.

It's not clear why this is a two step process, you can set
custom fields when replying to the ticket. If you do not
wish to reply or comment, you could still do this with Jumbo.
-- 
Cambridge Energy Alliance: Save money. Save the planet.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] _default_ VirtualHost overlap on port 443, the first has precedence

2009-08-21 Thread testwreq wreq
I tried VirtualHost firstone:443 and the second one Virtual Host rt:443
but still https://rt.hostname.com goes to https;//firstone

While restarting apache, the warning message now was:
[Fri Aug 21 11:20:23 2009] [warn] VirtualHost firstname:443 overlaps with
VirtualHost rt.hostname.com:443, the first has precedence, perhaps you need
a NameVirtualHost directive

Not sure what NameVirtualHost directive is
On Fri, Aug 21, 2009 at 11:17 AM, Drew Barnes barne...@ucrwcu.rwc.uc.eduwrote:

 Try naming the virtual hosts.  *:443 means any domain that resolves to that
 machine will get the first one, since it matches.

 Curtis may also be right (never tried two https sites on the same box), but
 try having the first one be VirtualHost firstone:443 and the second one
 VirtualHost rt:443 and see if it works for you.



 On 8/21/09 11:13 AM, testwreq wreq testw...@gmail.com wrote:

  Actually, I should have mentioned before that our rt installation is on a
 different IP.

 On Fri, Aug 21, 2009 at 11:09 AM, Curtis Bruneau curt...@vianet.ca
 wrote:

 Each SSL site pretty much needs to be on it's own IP address, the reasoning
 is the cert negotiation isn't name based header as apache would. The only
 other way would be to have them on different ports but then you'd have to
 specify the port when going to the site.

 testwreq wreq wrote:

 *

 I have managed to get it all set up and RT running OK with named virtual
 host over http. However, I am having problems with getting them to work over
 https. When I set a virtual host name, it always serves the first listed
 domain. See settings below. https:firstone serves the correct folder, but
 https:rt serves firstone's documents

 my settings:

 VirtualHost *:443

 DocumentRoot C:/Development/firstone
 ServerName firstone
 ServerAdmin webmas...@localhost
 ErrorLog logs/ssl/error.log
 TransferLog logs/ssl/access.log

 SSLEngine on...etc
 /VirtualHost

 VirtualHost *:443
   ServerName rt.hostname.com 
 http://rt.hostname.com/http://rt.hostname.com/ http://rt.hostname.com
 http://rt.hostname.com/http://rt.hostname.com+%3chttp//rt.hostname.com/

   DocumentRoot /data/rt3/share/html
   AddDefaultCharset UTF-8
   PerlModule Apache::DBI
   PerlRequire /data/rt3/bin/webmux.pl
Location /NoAuth/images
SetHandler default
/Location
   ErrorLog logs/ssl_error_log
   TransferLog logs/ssl_access_log
   LogLevel warn
   Directory /
  SSLRequireSSL
   /Directory
SSLEngine on
SSLProtocol all -SSLv2
SSLCipherSuite ALL:!ADH:!EXPORT:!SSLv2:RC4+RSA:+HIGH:+MEDIUM:+LOW
SSLCertificateFile /etc/sslcertificate/server.crt
SSLCertificateKeyFile /etc/sslcertificate/server.key
 /VirtualHost
 while restarting apache I get a warning  _default_ VirtualHost overlap on
 port 443, the first has precedence
  Any suggestions???

 Thanks in advance,
 rq
 *
 

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 http://wiki.bestpractical.com/ http://wiki.bestpractical.com/
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a
 copy at http://rtbook.bestpractical.com 
 http://rtbook.bestpractical.com/http://rtbook.bestpractical.com/



 --

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 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 Dept.
 Raymond Walters College

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] _default_ VirtualHost overlap on port 443, the first has precedence

2009-08-21 Thread Jerrad Pierce
On Fri, Aug 21, 2009 at 11:09, Curtis Bruneaucurt...@vianet.ca wrote:
 Each SSL site pretty much needs to be on it's own IP address, the
 reasoning is the cert negotiation isn't name based header as apache
 would. The only other way would be to have them on different ports but
 then you'd have to specify the port when going to the site.

In practice yes, but technically no. SNI allows https to do name-based
virtual hosts,
although mod_ssl (and older browsers) do not support it. For this reason we use
mod_gnutls. http://www.outoforder.cc/projects/apache/mod_gnutls/sni/
-- 
Cambridge Energy Alliance: Save money. Save the planet.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] On saving changes to a ticket edit page displayed

2009-08-21 Thread Kenneth Marshall
On Fri, Aug 21, 2009 at 11:19:12AM -0400, Jerrad Pierce wrote:
  One reason is that certain scip actions can be based on the settings
  of particular fields. So you need to first set one field and then
  another to produce the correct action. One field we have is whether
  or not to send E-mail when a ticket is resolved. To have this work
  you first need to set that field and then resolve the ticket.
  Otherwise the mail is sent. That is one example but having to re-enter
  the basics screen over and over would be clumsy at best.
 
 It's not clear why this is a two step process, you can set
 custom fields when replying to the ticket. If you do not
 wish to reply or comment, you could still do this with Jumbo.

If the custom field is not set before the reply/resolve scrip
is executed, the notice still goes out. Then the CF value is
changed.

Ken
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Contributed script: A time worked reporting tool

2009-08-21 Thread Ken Crocker

Drew, Fran,

Is there anything unique to this scrip per RT version? In otherwords, 
will it work on 3.6.4 as well as 3.8.4?


Kenn
LBNL

On 8/21/2009 10:42 AM, Drew Barnes wrote:

To second Fran, I have also been using this script in production for a while
now and have found it to be a good reporting tool for management.

We use it both on the command line, and with a wrapper to fit RT's look and
feel.  If needed, I would be happy to share that off list.



On 8/21/09 12:48 PM, Fran Fabrizio f...@cis.uab.edu wrote:

  

I've attached a script I've developed over the summer to help me produce
time worked reports for my staff.  Its features are:

# FEATURES
#  - Produces a simple text report of the number of minutes worked per
#person per ticket in a given datetime range for all tickets that
#experienced  0 minutes worked in that time period
#  - Allows user to specify one or more queues to include in the ticket
#search
#  - Assumes start and end datetimes entered in local time and adjusts for
#GMT which is RT's internal representation (but see --gmtime flag)
#  - Correctly calculates time one person puts onto another person's ticket
#  - Correctly calculates TimeWorked when directly updated via the Basics or
#Jumbo ticket update page as well as when added to a comment or reply
#  - Optional --debug mode for verbose output
#  - Basic --help text display
#  - Uses RT's API (does not query database directly)

The script is pretty well documented so most questions should be
answered within.  For usage, run timeworked.pl --help.  There is one
line within the script, the use lib line, that may need to be edited
before it'll work for you - I've noted this in the script documentation.

I'd certainly like to get feedback on the script, to see if this is
useful for others.  It also could use more validation/testing - I've
been using and developing it for a while and I think it's doing pretty
well now, but I only have so much data and so many scenarios to test
against in my own RT install.  Also, in the interest of full disclosure,
I should point out that it's my first RT API script.  :-)  Comments and
suggestions very welcome.

Thanks,
Fran



  
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Contributed script: A time worked reporting tool

2009-08-21 Thread Allen
 I've attached a script I've developed over the summer to help me produce
 time worked reports for my staff.

Thanks for this. It's very nice.

It did put out a warning on my system, though:
[Fri Aug 21 18:30:08 2009] [warning]: Use of uninitialized value in
string eq at ./rt-timeworked.pl line 273. (./rt-timeworked.pl:273)

Looks like this line:  if (($tr-TimeTaken != 0) || ($tr-Field eq
'TimeWorked')) {

Thank you!

A
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Inbound E-mail to server

2009-08-21 Thread Eric Chatham


-Original Message-
From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
boun...@lists.bestpractical.com] On Behalf Of Eric Chatham
Sent: Thursday, August 20, 2009 12:37
To: 'Jerrad Pierce'
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Inbound E-mail to server

On Thursday, August 20, 2009 12:30, Jerrad Pierce wrote,

 Try changing your subject line to [$Organization #ticket_id]

 No go.  I even tried $rtname.

 Just to be clear, you're using the value assigned to these variable
 sin your site config,
 and not the literal strings '$rtname', correct? And a ticket with the
 ID you're using
 already exists? And the account you're emailing form has the necessary
 ACLs to write
 to the ticket?

I created a file called mail and tried sending it to the rt-mailgateway but I 
receive an e-mail error.

COMMAND:
cat mail | /opt/rt3/bin/rt-mailgate --queue MIS --action comment --url 
http://clehbrtrckr01.broadvox.local

MAIL Message:
---
FROM: r...@server.domain.local
TO: r...@server.domain.local
Subject: [MIS #9] A test

Test
---


ERROR E-mail Message from the server:
---
FROM: r...@server.domain.local
TO: r...@server.domain.local
Subject: Could not load a valid user

RT could not load a valid user, and RT's configuration does not allow for the 
creation of a new user for your email.
---

I'm guessing that r...@server.domain.local is not the same as RTUSER, root.

Eric.

CONFIDENTIAL.  This e-mail and any attached files are confidential and should 
be destroyed and/or returned if you are not the intended and proper recipient.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] This transaction appears to have no content

2009-08-21 Thread testwreq wreq
RT guru's: when an ownership changes or when the ticket has no comment, the
ticket content produces  a message
This transaction appears to have no content

We would like to change this default message to This transaction has been
updated. Please see above the changes

Any suggestion on how I can accomplish this?

Thanks in advance, rq.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Viewing user profiles without modification rights?

2009-08-21 Thread Johnathan Bell
I figured it out. It may not be the cleanest, but it works...

I have an overlaid version of Ticket/Elements/ShowRequestor, below  
are my modificaitons (in the order that they are in the file):

Change this:
next if $requestor-Privileged;

To this:
#next if $requestor-Privileged;

Change this:
title_href = $has_right_adminusers? RT-Config-Get('WebPath')./ 
Admin/Users/Modify.html?id=.$requestor-id: undef,

To this:
title_href = RT-Config-Get('WebPath')./Admin/Users/Modify.html? 
id=.$requestor-id,

Add this:
|/lUser Profile/:br/

% my $requestorP = RT::User-new($RT::SystemUser);
% $requestorP-Load($requestor-id);
% my @items = (
%# Change etc to whatever makes sense for your org.
%   [etc,  $requestorP-Organization],
%   [etc,  $requestorP-WorkPhone],
%   [etc, $requestorP-City],
%   [etc, $requestorP-Address2] );

ul
% foreach my $item ( @items ) {
%   if ( ${$item}[1] ne  ) {
   li% ${$item}[0] %: % ${$item}[1] %/li
%   }
% }
/ul

Wherever you want in the profile (I do just before |/lGroups this  
user belongs to/)

Thanks,
Johnathan


On Aug 6, 2009, at 2:01 PM, Jerrad Pierce wrote:

 On Mon, Jul 27, 2009 at 08:57, Johnathan  
 Belljohnathan.b...@baker.edu wrote:
 Actually, no, the modify user page produces an error... the page  
 actually
 doesn't say anything, (except for the page footer text of Time to  
 display:
 x.xxx and RT 3.8.4 Copyright 1996-2009 Best Practical blah blah
 blah... the long itself says nothing either.

 Apparently you also need ShowConfigTab

 -- 
 Cambridge Energy Alliance: Save money. Save the planet.

--
Johnathan Bell
Internet System Administrator, Baker College

Office Hours: 7A - 4P Eastern, M-F

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] This transaction appears to have no content

2009-08-21 Thread Nick Kartsioukas
On Fri, 21 Aug 2009 15:37:50 -0400, testwreq wreq testw...@gmail.com
said:
 RT guru's: when an ownership changes or when the ticket has no comment,
 the ticket content produces  a message
 This transaction appears to have no content
 
 We would like to change this default message to This transaction has
 been updated. Please see above the changes
 
 Any suggestion on how I can accomplish this?

Search for $content = $self-loc('This transaction appears to have no
content'); in /lib/RT/Transaction_Overlay.pm and edit the text to your
liking.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] This transaction appears to have no content

2009-08-21 Thread Drew Barnes
Create a template and use that to say whatever you wish.  I can give you an
example of our owner change template when I have better access to our
system.


On 8/21/09 3:37 PM, testwreq wreq testw...@gmail.com wrote:

 RT guru's: when an ownership changes or when the ticket has no comment, the
 ticket content produces  a message
  
 This transaction appears to have no content
  
 We would like to change this default message to This transaction has been
 updated. Please see above the changes
  
 Any suggestion on how I can accomplish this?
  
 Thanks in advance, rq.
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 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 Dept.
 Raymond Walters College

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] This transaction appears to have no content

2009-08-21 Thread Stephen Turner
On Fri, 21 Aug 2009 15:37:50 -0400, testwreq wreq testw...@gmail.com  
wrote:

 RT guru's: when an ownership changes or when the ticket has no comment,  
 the ticket content produces  a message

 This transaction appears to have no content

 We would like to change this default message to This transaction has  
 been updated. Please see above the changes

 Any suggestion on how I can accomplish this?

 Thanks in advance, rq.

That message is coming from code in a template, something like this:

{$Transaction-Content()}

So you could modify the template code to read:

{
my $out = ;
if ($Transaction-Content() eq 'This transaction appears to have no  
content') {
$out = 'This transaction has been updated. Please see above the changes'
} else {
$out = $Transaction-Content();
}
$out;
}

or more simply

{$Transaction-Content() eq 'This transaction appears to have no content' ?
   'This transaction has been updated. Please see above the changes' :
   $Transaction-Content();
}

Haven't tested the code so there may be typos, but the general idea should  
work.

Steve

-- 
Stephen Turner
Senior Programmer/Analyst - SAIS
MIT IST
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Contributed script: A time worked reporting tool

2009-08-21 Thread Allen Lee
$ perl -e 'use lib /usr/share/request-tracker3.8/lib; use
RT::Transaction; print $RT::VERSION'
3.8.4

I think you are right that the warning is due to comparing string
against what is in the DB as NULL.

This fixed it for me:

Line 273:

- if (($tr-TimeTaken != 0) || ($tr-Field eq 'TimeWorked')) {
+ if (($tr-TimeTaken != 0) || ($tr-Field  $tr-Field eq 'TimeWorked')) {


Thank you again!


Allen Lee
Crystalfontz America, Incorporated
12412 East Saltese Avenue
Spokane Valley, WA 99216-0357
Twitter @Crystalfontz al...@crystalfontz.com http://www.crystalfontz.com
voice (509) 892-1200 fax (509) 892-1203 US toll-free (888) 206-9720



On Fri, Aug 21, 2009 at 1:09 PM, Fran Fabriziof...@cis.uab.edu wrote:

 Ok so it is complaining about an uninitialized value in the eq comparison
 $tr-Field eq TimeWorked.  Some transactions have NULL in the Field field
 in the database.  The question is when there is NULL in the database, what
 does RT::Transaction object return?  Maybe it's trying undef eq TimeWorked
 and throwing the warning.  The question is, why don't I see those?  What
 version of RT.pm are you using?

 What does:

  perl -e 'use lib /usr/local/rt/lib; use RT::Transaction; print
 $RT::VERSION'

 show?  (Of course, updating the /usr/local/rt/lib path).

 Maybe (off the wall, but) an older version of the RT::Transaction
 returns undef when NULL is read from the database, but the one I am using
 (3.8.2) returns '' or something?

 Allen Lee wrote:

 Hi,

 The script still worked fine.

 It looked like it was throwing that warning for every iteration of the
 loop. Below, it finds 1 tickets with Time Worked filled in, but more
 than 24 warnings are thrown:

 # rt-timeworked.pl --startdate 2009-08-15 --enddate 2009-08-22 --queues
 testy
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)
 [Fri Aug 21 19:54:28 2009] [warning]: Use of uninitialized value in
 string eq at /usr/sbin/rt-timeworked.pl line 273.
 (/usr/sbin/rt-timeworked.pl:273)