[rt-users] Create new validation

2006-05-24 Thread Mathew Snyder
I want to create a new validation for custom fields that would check the
format of a date.  Where would I add this?

-- 
Mathew Snyder
Systems Administrator
Network+
ServerVault TechOps

___
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-24 Thread Flynn, Timothy J
Eric,

That's the weird part.  It is the same exact query.  They perform the
search and see the web results, then they click the spreadsheet link and
it comes up different than what is in the web results.  I haven't
applied the patch yet.  Will that fix it?

Thanks,
-Tim
 

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

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


[rt-users] RT 3.4.4 Links Error

2006-05-24 Thread Torsten Brumm
Hi RT Users,

I get a very strange error at the Links Section of a ticket (and also if i
use the links Tab)

This Ticket has a Refered by Link from RTFM and it was merged into another
ticket. I have tried to reproduce this error, but no luck... It only occurs
from time to time.

Torsten

The error:

System error
error:  Can't call method IsLocal on an undefined value at
/opt/rt3/lib/RT/URI.pm line 247.
context:
... 
243:=cut
244:
245:sub IsLocal {
246:my $self = shift;
247:return $self-Resolver-IsLocal;
248:}
249:
250:
251:# }}}
... 
code stack: /opt/rt3/lib/RT/URI.pm:247
/opt/rt3/lib/RT/Links_Overlay.pm:159
/opt/rt3/share/html/Elements/EditLinks:109
/opt/rt3/share/html/Ticket/ModifyLinks.html:58
/opt/rt3/share/html/autohandler:215
raw error






























Can't call method IsLocal on an undefined value at /opt/rt3/lib/RT/URI.pm
line 247.


Trace begun at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Exceptions.pm line
131
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method IsLocal on
an undefined value at /opt/rt3/lib/RT/URI.pm line 247.^J') called at
/opt/rt3/lib/RT/URI.pm line 247
RT::URI::IsLocal('RT::URI=HASH(0xa6e8d5c)') called at
/opt/rt3/lib/RT/Links_Overlay.pm line 159
RT::Links::Next('RT::Links=HASH(0xa601900)') called at
/opt/rt3/share/html/Elements/EditLinks line 109
HTML::Mason::Commands::__ANON__('Object', 'RT::Ticket=HASH(0xa3d43d8)',
'Merge', 1) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm
line 136
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa297bc
4)', 'Object', 'RT::Ticket=HASH(0xa3d43d8)', 'Merge', 1) called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1074
eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, 'Object',
'RT::Ticket=HASH(0xa3d43d8)', 'Merge', 1) called at
/opt/rt3/share/html/Ticket/ModifyLinks.html line 58
HTML::Mason::Commands::__ANON__('id', 287349, 'id', 287349) called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 136
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa6a918
4)', 'id', 287349, 'id', 287349) called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1074
eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, 'id', 287349, 'id', 287349) called
at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 760
HTML::Mason::Request::call_next('HTML::Mason::Request::CGI=HASH(0xa3bc678)',
'id', 287349) called at /opt/rt3/share/html/autohandler line 215
HTML::Mason::Commands::__ANON__('id', 287349) called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 136
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9d6baa
0)', 'id', 287349) called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1069
eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, undef, 'id', 287349) called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 338
eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 338
eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 297
HTML::Mason::Request::exec('HTML::Mason::Request::CGI=HASH(0xa3bc678)')
called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line 197
eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line
197
HTML::Mason::Request::CGI::exec('HTML::Mason::Request::CGI=HASH(0xa3bc678)')
called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Interp.pm line 216
HTML::Mason::Interp::exec(undef, undef, 'id', 287349) called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line 127
eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line
127
HTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x99af8c8)',
'HASH(0xa2769dc)') called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line 76
HTML::Mason::CGIHandler::handle_cgi_object('HTML::Mason::CGIHandler=HASH(0x9
9af8c8)', 'CGI::Fast=HASH(0xa1cd504)') called at
/opt/rt3/bin/mason_handler.fcgi line 76
eval {...} at /opt/rt3/bin/mason_handler.fcgi line 76

___
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-24 Thread Flynn, Timothy J
Eric,

I just dumped the TSV results to a txt file and opened with
ultraedit and the data is fine.  Excel is messing up the data somehow.
Doesn't appear to be an RT issue, but it might be an escaping issue due
to some of the content in the ticket.

Thanks for the link on the patch for the columns!

-Tim
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 8:05 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

Eric,

That's the weird part.  It is the same exact query.  They perform the
search and see the web results, then they click the spreadsheet link and
it comes up different than what is in the web results.  I haven't
applied the patch yet.  Will that fix it?

Thanks,
-Tim
 

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

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
___
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] Field validation

2006-05-24 Thread Thiago Cristino dos Santos
Hi,
there's some way to perform field validation in RT (mandatory fields, date formats, number formats, etc) ?

Thiago
___
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] Field validation

2006-05-24 Thread Todd Chapman
On Wed, May 24, 2006 at 10:22:28AM -0300, Thiago Cristino dos Santos wrote:
 Hi,
 there's some way to perform field validation in RT (mandatory fields, date
 formats, number formats, etc) ?
 
 Thiago

Install RT 3.6 when it comes out. 3.6rc2 is available now.

-Todd
___
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] Create new validation

2006-05-24 Thread Todd Chapman
On Wed, May 24, 2006 at 03:20:36AM -0400, Mathew Snyder wrote:
 I want to create a new validation for custom fields that would check the
 format of a date.  Where would I add this?
 

This is in RT 3.6.
___
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] ldap overlay auth methods

2006-05-24 Thread Chris Hall

Hello,

I'm using the LDAP overlay and having trouble with getting RT to 
autocreate new users.


The user creation is working now, but now LDAP users are able to login 
using both their LDAP passwords, and the previously used RT passwords. 
My AuthMethods are:


Set($AuthMethods, ['LDAP', 'Internal']);

I would expect that if a user existed in ldap, but entered the wrong 
password, it wouldnt then try internal authentication, but that doesnt 
seem the case.


Should I be disabling the existing RT accounts in the database?

Thanks,

- Chris
___
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] Slow query results on search in content.

2006-05-24 Thread Dave Wells

Hi,

My users have been experiencing issues when they try and search on
content in all Tickets. The problems they experience are a very long
wait 30-40 mins for the results to appear or most often the page will
just hang and go to a blank page.

We have approx 45000 tickets in our database.

I have done a little experimenting with the kind of queries they have
been using as below:

 SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2  WHERE
((Transactions_1.ObjectType = 'RT::Ticket')) AND ((main.EffectiveId =
main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket'))
AND ( ( (Attachments_2.Content LIKE
'%catalog%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) );
+-+
| COUNT(DISTINCT main.id) |
+-+
| 244 |
+-+
1 row in set (3 min 57.46 sec)

As you can see the mysql query is appearing to take a lil under 4 mins
which is ok, however it does not seem to reflect this speed using the
web browser.

I also ran an Explain as below:

 explain SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2  WHERE
((Transactions_1.ObjectType = 'RT::Ticket')) AND ((main.EffectiveId =
main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket'))
AND ( ( (Attachments_2.Content LIKE
'%catalog%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) );
+++---+-+-+-
+---+-+
| table  | type   | possible_keys | key | key_len |
ref | rows  | Extra   |
+++---+-+-+-
+---+-+
| Attachments_2  | ALL| Attachments2  | NULL|NULL |
NULL| 67372 | Using where |
| Transactions_1 | eq_ref | PRIMARY,Transactions1 | PRIMARY |   4 |
Attachments_2.TransactionId | 1 | Using where |
| main   | eq_ref | PRIMARY   | PRIMARY |   4 |
Transactions_1.ObjectId | 1 | Using where |
+++---+-+-+-
+---+-+


I think the indeices look right but I am NO mysql guru so not entriley
sure.

I shall include the main RT conf options below:
Loaded perl modules
Perl v5.8.7 under linux
  Apache v1.27;
  Apache::Connection v1.00;
  Apache::Constants v1.09;
  Apache::DBI v0.9901;
  Apache::Request v1.33;
  Apache::Server v1.01;
  Apache::Session v1.6;
  Apache::Session::Generate::MD5 v2.1;
  Apache::Session::Lock::MySQL v1.00;
  Apache::Session::MySQL v1.01;
  Apache::Session::Serialize::Storable v1.00;
  Apache::Session::Store::DBI v1.02;
  Apache::Session::Store::MySQL v1.04;
  Apache::Status v2.03;
  Apache::Table v0.01;
  AutoLoader v5.60;
  B v1.09;
  base v2.07;
  Benchmark v1.07;
  bytes v1.02;
  Cache::Simple::TimedExpiry v0.23;
  Carp v1.04;
  CGI v3.10;
  CGI::Cookie v1.25;
  CGI::Util v1.5;
  Class::Container v0.12;
  Class::Data::Inheritable v0.02;
  Class::ReturnValue v0.53;
  constant v1.05;
  Cwd v3.05;
  Data::Dumper v2.121_04;
  DBD::mysql v3.0002_1;
  DBI v1.48;
  DBIx::SearchBuilder v1.32;
  DBIx::SearchBuilder::Unique v0.01;
  Devel::StackTrace v1.11;
  Devel::StackTraceFrame v0.6;
  Digest::base v1.00;
  Digest::MD5 v2.33;
  DynaLoader v1.05;
  Encode v2.10;
  Encode::Alias v2.03;
  Encode::Config v2.00;
  Encode::Encoding v2.02;
  Errno v1.0901;
  Exception::Class v1.21;
  Exception::Class::Base v1.2;
  Exporter v5.58;
  Exporter::Heavy v5.58;
  Fcntl v1.05;
  fields v2.03;
  File::Basename v2.73;
  File::Glob v1.04;
  File::Path v1.07;
  File::Spec v3.05;
  File::Spec::Unix v1.5;
  File::Temp v0.16;
  FileHandle v2.01;
  HTML::Entities v1.29;
  HTML::Mason v1.3101;
  HTML::Mason::ApacheHandler v1.69;
  HTML::Mason::Exception v1.1;
  HTML::Mason::Exception::Abort v1.1;
  HTML::Mason::Exception::Compilation v1.1;
  HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
  HTML::Mason::Exception::Compiler v1.1;
  HTML::Mason::Exception::Decline v1.1;
  HTML::Mason::Exception::Params v1.1;
  HTML::Mason::Exception::Syntax v1.1;
  HTML::Mason::Exception::System v1.1;
  HTML::Mason::Exception::TopLevelNotFound v1.1;
  HTML::Mason::Exception::VirtualMethod v1.1;
  HTML::Mason::Exceptions v1.43;
  HTML::Parser v3.45;
  HTML::Scrubber v0.08;
  I18N::LangTags v0.35;
  I18N::LangTags::Detect v1.03;
  integer v1.00;
  IO v1.21;
  IO::File v1.11;
  IO::Handle v1.24;
  IO::InnerFile v2.110;
  IO::Lines v2.110;
  IO::Scalar v2.110;
  IO::ScalarArray v2.110;
  IO::Seekable v1.09;
  IO::Wrap v2.110;
  IO::WrapTie v2.110;
  IPC::Open2 v1.01;
  IPC::Open3 v1.0106;
  lib v0.5565;
  List::Util v1.14;
  locale v1.00;
  

Re: [rt-users] RT 3.4.4 Links Error

2006-05-24 Thread Frank Pater
Hi Torsten,

I ran into this last week (RT 3.4.5), and wasn't able to find much on Google or 
the list archives about it. It does seem to come up when people are trying to 
do different things.

In our situation, it was the result of the following:

1) Two tickets were created for the same issue (customer double-submitted it)
2) A link was created between them (Depends on/Depended on by)
3) The link was removed
4) One was deleted, and subsequently purged from the database with RTx::Shredder

With the database in this state, trying to load the ticket that hadn't been 
deleted resulted in the error you describe. My solution was to restore the 
deleted ticket using the dumpfile created by rtx-shredder's --sqldump switch, 
and set its status to rejected so that it isn't automatically purged by our 
nightly rtx-shredder job. 

I'm not sure if we could've done anything else (removed the link transaction(s) 
from the database perhaps? I didn't try this because I'd rather add unnecessary 
data than delete anything), or if this is a bug or an unavoidable consequence 
of using RTx::Shredder to purge our database of spam (there is plenty). The 
bottom line, for us, was that the two tickets should've been merged, as they 
were both from a legitimate customer. Deleting one was the incorrect solution.

Sincerely,
Frank Pater
DCANet
http://www.dca.net
voice: 888-4-DCANET (888-432-2638)
fax: 302-426-6386

On Wed, May 24, 2006 at 03:05:58PM +0200, Torsten Brumm wrote:
 Hi RT Users,
 
 I get a very strange error at the Links Section of a ticket (and also if i
 use the links Tab)
 
 This Ticket has a Refered by Link from RTFM and it was merged into another
 ticket. I have tried to reproduce this error, but no luck... It only occurs
 from time to time.
 
 Torsten
 
 The error:
 
 System error
 error:Can't call method IsLocal on an undefined value at
 /opt/rt3/lib/RT/URI.pm line 247.
 context:  
 ...   
 243:  =cut
 244:  
 245:  sub IsLocal {
 246:  my $self = shift;
 247:  return $self-Resolver-IsLocal;
 248:  }
 249:  
 250:  
 251:  # }}}
 ...   
 code stack:   /opt/rt3/lib/RT/URI.pm:247
 /opt/rt3/lib/RT/Links_Overlay.pm:159
 /opt/rt3/share/html/Elements/EditLinks:109
 /opt/rt3/share/html/Ticket/ModifyLinks.html:58
 /opt/rt3/share/html/autohandler:215
 raw error
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 Can't call method IsLocal on an undefined value at /opt/rt3/lib/RT/URI.pm
 line 247.
 
 
 Trace begun at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Exceptions.pm line
 131
 HTML::Mason::Exceptions::rethrow_exception('Can\'t call method IsLocal on
 an undefined value at /opt/rt3/lib/RT/URI.pm line 247.^J') called at
 /opt/rt3/lib/RT/URI.pm line 247
 RT::URI::IsLocal('RT::URI=HASH(0xa6e8d5c)') called at
 /opt/rt3/lib/RT/Links_Overlay.pm line 159
 RT::Links::Next('RT::Links=HASH(0xa601900)') called at
 /opt/rt3/share/html/Elements/EditLinks line 109
 HTML::Mason::Commands::__ANON__('Object', 'RT::Ticket=HASH(0xa3d43d8)',
 'Merge', 1) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm
 line 136
 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa297bc
 4)', 'Object', 'RT::Ticket=HASH(0xa3d43d8)', 'Merge', 1) called at
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1074
 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1068
 HTML::Mason::Request::comp(undef, undef, 'Object',
 'RT::Ticket=HASH(0xa3d43d8)', 'Merge', 1) called at
 /opt/rt3/share/html/Ticket/ModifyLinks.html line 58
 HTML::Mason::Commands::__ANON__('id', 287349, 'id', 287349) called at
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 136
 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa6a918
 4)', 'id', 287349, 'id', 287349) called at
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1074
 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1068
 HTML::Mason::Request::comp(undef, undef, 'id', 287349, 'id', 287349) called
 at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 760
 HTML::Mason::Request::call_next('HTML::Mason::Request::CGI=HASH(0xa3bc678)',
 'id', 287349) called at /opt/rt3/share/html/autohandler line 215
 HTML::Mason::Commands::__ANON__('id', 287349) called at
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 136
 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9d6baa
 0)', 'id', 287349) called at
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1069
 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1068
 HTML::Mason::Request::comp(undef, undef, undef, 'id', 287349) called at
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 338
 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 338
 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 297
 

AW: [rt-users] RT 3.4.4 Links Error

2006-05-24 Thread Torsten Brumm
Hi Frank,

We didn't delete something, but we merged to tickets and one of them had a
referer to RTFM. It drives me crazy, that i can't reproduce this and i'm
also stepping in the dark, because i can't figure out the way the steps
where done, because the Extract Article from the Ticket to the RTFM
generates no History Entry...

Hopefully Jesse or someone else has an idea or solution.

Torsten 

 -Ursprüngliche Nachricht-
 Von: Frank Pater [mailto:[EMAIL PROTECTED] 
 Gesendet: Mittwoch, 24. Mai 2006 16:46
 An: Torsten Brumm
 Cc: rt-users@lists.bestpractical.com
 Betreff: Re: [rt-users] RT 3.4.4 Links Error
 
 Hi Torsten,
 
 I ran into this last week (RT 3.4.5), and wasn't able to find 
 much on Google or the list archives about it. It does seem to 
 come up when people are trying to do different things.
 
 In our situation, it was the result of the following:
 
 1) Two tickets were created for the same issue (customer 
 double-submitted it)
 2) A link was created between them (Depends on/Depended on by)
 3) The link was removed
 4) One was deleted, and subsequently purged from the database 
 with RTx::Shredder
 
 With the database in this state, trying to load the ticket 
 that hadn't been deleted resulted in the error you describe. 
 My solution was to restore the deleted ticket using the 
 dumpfile created by rtx-shredder's --sqldump switch, and set 
 its status to rejected so that it isn't automatically 
 purged by our nightly rtx-shredder job. 
 
 I'm not sure if we could've done anything else (removed the 
 link transaction(s) from the database perhaps? I didn't try 
 this because I'd rather add unnecessary data than delete 
 anything), or if this is a bug or an unavoidable consequence 
 of using RTx::Shredder to purge our database of spam (there 
 is plenty). The bottom line, for us, was that the two tickets 
 should've been merged, as they were both from a legitimate 
 customer. Deleting one was the incorrect solution.
 
 Sincerely,
 Frank Pater
 DCANet
 http://www.dca.net
 voice: 888-4-DCANET (888-432-2638)
 fax: 302-426-6386
 
 On Wed, May 24, 2006 at 03:05:58PM +0200, Torsten Brumm wrote:
  Hi RT Users,
  
  I get a very strange error at the Links Section of a ticket 
 (and also 
  if i use the links Tab)
  
  This Ticket has a Refered by Link from RTFM and it was merged into 
  another ticket. I have tried to reproduce this error, but 
 no luck... 
  It only occurs from time to time.
  
  Torsten
  
  The error:
  
  System error
  error:  Can't call method IsLocal on an undefined value at
  /opt/rt3/lib/RT/URI.pm line 247.
  context:
  ... 
  243:=cut
  244:
  245:sub IsLocal {
  246:my $self = shift;
  247:return $self-Resolver-IsLocal;
  248:}
  249:
  250:
  251:# }}}
  ... 
  code stack: /opt/rt3/lib/RT/URI.pm:247
  /opt/rt3/lib/RT/Links_Overlay.pm:159
  /opt/rt3/share/html/Elements/EditLinks:109
  /opt/rt3/share/html/Ticket/ModifyLinks.html:58
  /opt/rt3/share/html/autohandler:215
  raw error
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Can't call method IsLocal on an undefined value at 
  /opt/rt3/lib/RT/URI.pm line 247.
  
  
  Trace begun at 
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Exceptions.pm 
  line
  131
  HTML::Mason::Exceptions::rethrow_exception('Can\'t call method 
  IsLocal on an undefined value at /opt/rt3/lib/RT/URI.pm line 
  247.^J') called at /opt/rt3/lib/RT/URI.pm line 247
  RT::URI::IsLocal('RT::URI=HASH(0xa6e8d5c)') called at 
  /opt/rt3/lib/RT/Links_Overlay.pm line 159
  RT::Links::Next('RT::Links=HASH(0xa601900)') called at 
  /opt/rt3/share/html/Elements/EditLinks line 109 
  HTML::Mason::Commands::__ANON__('Object', 
  'RT::Ticket=HASH(0xa3d43d8)', 'Merge', 1) called at 
  /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm
  line 136
  
 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x
  a297bc 4)', 'Object', 'RT::Ticket=HASH(0xa3d43d8)', 
 'Merge', 1) called 
  at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm 
 line 1074 eval 
  {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 
  1068 HTML::Mason::Request::comp(undef, undef, 'Object', 
  'RT::Ticket=HASH(0xa3d43d8)', 'Merge', 1) called at 
  /opt/rt3/share/html/Ticket/ModifyLinks.html line 58 
  HTML::Mason::Commands::__ANON__('id', 287349, 'id', 287349) 
 called at 
  /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 136
  
 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x
  a6a918 4)', 'id', 287349, 'id', 287349) called at 
  /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1074 eval 
  {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 
  1068 HTML::Mason::Request::comp(undef, undef, 'id', 287349, 'id', 
  287349) called at 
 /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm 
  line 760 
  
 

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

2006-05-24 Thread Flynn, Timothy J
After reviewing my changes further I believe I came up with a better
solution for escaping tabs.

In the file rtroot/share/html/Search/Elements/Results.tsv 


Instead of the line:
$val =~ s/(\n|\r)//g;

And instead of the previous change I suggested:

$val =~ s/(\n|\r|\t)//g;

I am going to change it to this:

$val =~ s/\s/ /g;

My thinking is if the intent of a newline, tab, or other whitespace
character was to separate data, then a single space would be more
fitting than nothing at all.  Hope this helps someone else.  Also
wouldn't be a bad idea to add this fix to future versions even if it
doesn't match what I did above.  I would think having tabs escaped would
be required for a tab delimited file to work properly.

-Tim


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 9:16 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

 
Woops, just found this:

 $val =~ s/(\n|\r)//g;

Looks like I just need to change to:

$val =~ s/(\n|\r|\t)//g;


-Tim

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 9:15 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

I think I found the root of the problem.  It doesn't appear that tab
characters or newlines are being escaped from the result set.  This
would cause issues with the presentation in Excel.  I will add some
coding to do this to the rows after I apply the patch.  I am surprised
this never affected anyone before.

Thanks,
-Tim
 

-Original Message-
From: Stephen Turner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 24, 2006 9:04 AM
To: Flynn, Timothy J; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

At Tuesday 5/23/2006 04:50 PM, Flynn, Timothy J wrote:
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


The mechanism use in searching for the web view is different from 
that used in the full spreadsheet download.

That said, you should still see the same number of rows. When you get 
14 rows in the web view are you actually seeing 14 tickets in the 
list, or is that number from the 'Found 14 tickets' message? It's 
just possible that you only have permission to see 11 of the 14 rows
returned.

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


[rt-users] Display User Information

2006-05-24 Thread Craig Moscicki
Good morning!  We are trying to display information in the More  
about... section of the Basics tab for users.  We want to show the  
Address, Phone Number and Department for our customers.  We are using  
this callback:
/opt/rt36prod/local/html/Callbacks/local/Ticket/Elements/ 
ShowRequestor/AboutThisUser

with this code:
%args
$requestor = undef
/%args
strongAddress:/strong %$requestor-Address1%br/
strongPhone:/strong %$requestor-WorkPhone%br/
strongOrganization:/strong %$requestor-Organization%br/

Everything shows up fine for us as administrators, but our normal  
techs only see the Organization info.  They see words Address and  
Phone bolded, but nothing shows up as far as the actual address or  
phone number.  If we give them the AdminUsers right globally, Address  
and Phone information show up, but we don't want to give that right  
when we only need them to be able to view the information.  Does  
anyone have any idea why Address and Phone wouldn't show up, but  
Organization does?  Or what we can do to solve the problem?  We are  
using RT 3.6.0rc2 if it makes a difference.  Please let me know if  
you need any other info.  Thanks!


Craig Moscicki
[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] Adding comments to a ticket via the API, scrips don't activate?

2006-05-24 Thread Stephen Turner

At Wednesday 5/24/2006 10:35 AM, Stewart Tranter wrote:

Hi,

As part of an escalation script, I need to add a comment to the 
escalated ticket and then CC this comment to another user.  I have 
created the following code:


CCMessageTo = $queueadmin,


Stewart,

I think the arg name should be CcMessageTo (second 'c' is lower case).

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] Display User Information

2006-05-24 Thread Todd Chapman
See sub _OverlayAccessible in lib/RT/Users_Overlay.pm.

On Wed, May 24, 2006 at 10:49:26AM -0400, Craig Moscicki wrote:
 Good morning!  We are trying to display information in the More  
 about... section of the Basics tab for users.  We want to show the  
 Address, Phone Number and Department for our customers.  We are using  
 this callback:
 /opt/rt36prod/local/html/Callbacks/local/Ticket/Elements/ 
 ShowRequestor/AboutThisUser
 with this code:
 %args
 $requestor = undef
 /%args
 strongAddress:/strong %$requestor-Address1%br/
 strongPhone:/strong %$requestor-WorkPhone%br/
 strongOrganization:/strong %$requestor-Organization%br/
 
 Everything shows up fine for us as administrators, but our normal  
 techs only see the Organization info.  They see words Address and  
 Phone bolded, but nothing shows up as far as the actual address or  
 phone number.  If we give them the AdminUsers right globally, Address  
 and Phone information show up, but we don't want to give that right  
 when we only need them to be able to view the information.  Does  
 anyone have any idea why Address and Phone wouldn't show up, but  
 Organization does?  Or what we can do to solve the problem?  We are  
 using RT 3.6.0rc2 if it makes a difference.  Please let me know if  
 you need any other info.  Thanks!
 
 Craig Moscicki
 [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
___
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] Display User Information

2006-05-24 Thread Todd Chapman
Sorry, that's User_Overlay.pm

On Wed, May 24, 2006 at 10:49:26AM -0400, Craig Moscicki wrote:
 Good morning!  We are trying to display information in the More  
 about... section of the Basics tab for users.  We want to show the  
 Address, Phone Number and Department for our customers.  We are using  
 this callback:
 /opt/rt36prod/local/html/Callbacks/local/Ticket/Elements/ 
 ShowRequestor/AboutThisUser
 with this code:
 %args
 $requestor = undef
 /%args
 strongAddress:/strong %$requestor-Address1%br/
 strongPhone:/strong %$requestor-WorkPhone%br/
 strongOrganization:/strong %$requestor-Organization%br/
 
 Everything shows up fine for us as administrators, but our normal  
 techs only see the Organization info.  They see words Address and  
 Phone bolded, but nothing shows up as far as the actual address or  
 phone number.  If we give them the AdminUsers right globally, Address  
 and Phone information show up, but we don't want to give that right  
 when we only need them to be able to view the information.  Does  
 anyone have any idea why Address and Phone wouldn't show up, but  
 Organization does?  Or what we can do to solve the problem?  We are  
 using RT 3.6.0rc2 if it makes a difference.  Please let me know if  
 you need any other info.  Thanks!
 
 Craig Moscicki
 [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
___
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] First Impressions of RT V3.6.0rc2

2006-05-24 Thread Nick Metrowsky








Hi Everyone,



I thought I would take a look at RT 3.6.0rc2 this morning to
see what it would take to upgrade from 3.4.4. 



On installation, the install required installing two perl
CPAN modules and it failed to do it via make fixdeps, so I had to
do them by hand. Not a big deal. The rest of the install/upgrade went
flawlessly. Lets just say it was much easier to go from 3.4.4 to
3.6.0rc, than it was to go from 2.4.x to 3.4.4. I had the software configured
and upgraded in less than 10 minutes.



Logging in, frankly I like the user interface to 3.4.4
better, I think the lack of shading and borders causes a lot more eye strain, especially
on an all white background. My eyes are not very good and the lack of
definition is really hard on the eyes. Also, because of the much larger fonts,
one needs a 20 screen or larger to get a good display; on smaller
displays one will be either seeing a lot of line wraps or using the arrow bars
on the side and bottom of the screen to move the display around.



I found the adding of reports was a good addition, as well
as validation in custom fields. I suspect there is a setting in RT_Config.pm that
allows for entering dates in MM/DD/ format. Yes, I know the US is one of
the few countries that use it; I personally prefer the DD/MM/ format, but I
am in a minority here.



I like the Ticket Quick Search option



Some bugs I noticed. Links do not show up in Asset Tracker
(v1.2.3) and the Tickets per day per Queue screen for
RTx::Statistics (v0.1.8) does not display anything, but the spreadsheet does.
All the other RTx::Statistics functions work. RTx::Matrix and RTFM seem to
work, but I really did nothing but display things.



I did not do an extensive test like create tickets,
manipulate assets, etc, but I did a cursory look at the software. All in all
this looks like a great upgrade, but I would give folks the option to keep the
3.4.4 style interface or use the interface introduced in 3.6.0rc2.



Take care!



Nick







-

Nick
Metrowsky

Consulting
System Administrator

303-684-4785
Office

303-684-4100
Fax

[EMAIL PROTECTED]

DigitalGlobe
, An Imaging and Information Company

http://www.digitalglobe.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] Shared Search for Tickets Resolved by me

2006-05-24 Thread Todd Chapman
Try: Owner = '__CurrentUser__'

I think that only works in 3.6 though.

-Todd

On Wed, May 24, 2006 at 09:47:37AM -0500, Steve Waltner wrote:
 I would like to create a Shared Search on RT 3.4.4 which queries for  
 tickets that I resolved during the last month. The problem is I  
 can't figure out how to tell the search engine to query for me  
 based on who is currently logged into the web interface. I'm very new  
 to using RT, so I probably have simply overlooked something simple.
 
 I currently have the following as my Saved Search, which works fine  
 for myself
 
 Owner = 'swaltner'
 AND Status = 'resolved'
 AND Resolved  'Today'
 AND Resolved  '-35 Days'
 
 The problem comes when I save this into the shared searches with our  
 other group members. jdoe doesn't want to search for tickets that  
 swaltner owned, they are interested in tickets that are owned by  
 jdoe. Granted each user can load the shared search, update it with  
 their name, and save it into their personal saved searches, but that  
 isn't convenient and doesn't make sure that everyone is using the  
 same queries.
 
 Hopefully there is a keyword like myself (similar to today for  
 the date searches) that would help here. I've looked through the  
 mailing list archives and on the Wiki, but don't seem to find  
 anything useful there. Any assistance would be greatly appreciated.
 
 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
___
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] First Impressions of RT V3.6.0rc2

2006-05-24 Thread Nick Metrowsky
Hi Jesse,

Thank you for the tip. It is appreciated.

Also, when I switched to 3.4-compat mode, the links for Asset Tracker
V1.2.3 now work. I will admit, 3.4-compat mode is much easier on the
eyes and it provides slightly larger fonts, the best of both worlds.

Take care!

Nick

PS I found where to change the date format, as well.
 

-
Nick Metrowsky
Consulting System Administrator
303-684-4785 Office
303-684-4100 Fax
[EMAIL PROTECTED]
DigitalGlobe (r), An Imaging and Information Company
http://www.digitalglobe.com

-

-Original Message-
From: Jesse Vincent [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 24, 2006 9:25 AM
To: Nick Metrowsky
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] First Impressions of RT V3.6.0rc2




 
 I did not do an extensive test like create tickets, manipulate assets,
 etc, but I did a cursory look at the software. All in all this looks
 like a great upgrade, but I would give folks the option to keep the
 3.4.4 style interface or use the interface introduced in 3.6.0rc2.

We've done that. Have a look in RT's configuration file. 
___
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] Famous RT + FastCGI error

2006-05-24 Thread Avishay Aton
I am trying to setup rt 3.4.5 with fastcgi on redhat enterprise 4 .i took the configuration from RHEL4InstallGuide.
I also read the RT Essential bookmy /etc/httpd/conf/httpd.conf Virtual host :NameVirtualHost *:80 VirtualHost *:80 ServerAdmin root ServerName 
rt3.example.com DocumentRoot /opt/rt3/share/html/ AddDefaultCharset UTF-8 # Adding the following for RT (the ticket tracker) AddHandler fastcgi-script .fcgi Directory /opt/rt3/share/html
 Options FollowSymLinks ExecCGI AllowOverride None /Directory### # Pass through requests to for noauth Alias /NoAuth/images /opt/rt3/share/html/NoAuth/images ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/
 /VirtualHost FastCgiIpcDir /tmp FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4whenever i run apache(without errors ) , i get in the log file:[warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi started (pid 9452)
[Wed May 24 18:38:38 2006] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fcgi started (pid 9453)[Wed May 24 18:38:39 2006] [warn] FastCGI: server /opt/rt3/bin/mason_handler.fwhen i try :
http://rt3.example.com/i get the following in the error log:[error] [client x.x.x.x] FastCGI: incomplete headers (0 bytes) received from server /opt/rt3/bin/mason_handler.fcgi
whenever comment out the line ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/then restart apache , i get the famous you're Almost there page.I checked all permissions (rt was as installed with the same user apache runs)
i checked the /opt/rt3/bin/mason_handler.fcgi manually and it works.I read the FastCGIConfiguration dozen of times.
'I also tried to put ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/ in different places of httpd.conf.what is wrong with my configuration ?thanks
___
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] Cannot find the location of RT.pm that defines $RT::LocalPath

2006-05-24 Thread Roger Mastrude








I'm running Makefile.pm to
install RTFM 2.1.40, and getting an error message:



Cannot find the
location of RT.pm that defines $RT::LocalPath in: inc
/usr/lib/perl5/5.8.7/i586-linux-thread-multi /usr/lib/perl5/5.8.7
/usr/lib/perl5/site_perl/5.8.7/i586-linux-thread-multi

/usr/lib/perl5/site_perl/5.8.7
/usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.7/i586-linux-thread-multi

/usr/lib/perl5/vendor_perl/5.8.7
/usr/lib/perl5/vendor_perl . /opt/rt3/lib /opt/lib/rt3 /opt/lib /usr/local/rt3/lib
/usr/local/lib/rt3 /usr/local/lib /home/rt3/lib /home/lib/rt3 /home/lib
/usr/rt3/lib /usr/lib/rt3 /usr/lib /sw/rt3/lib /sw/lib/rt3 /sw/lib Path
to your RT.pm:



I'm slightly crippled by not
knowing Perl syntax. I do have an RT.pm, and it's in /opt/rt3/lib. If I
type in either /opt/rt3/lib or /opt/rt3/lib/RT.pm, I just get the same
message again. Any quotes, other wrappers, relative addressing required?



Would someone be kind enough
to help me out? Thanks.








___
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] Shared Search for Tickets Resolved by me

2006-05-24 Thread Steve Waltner

Todd,

Thanks for the suggestion. As you suspected, this appears to be a  
feature that is being added in 3.6. This returned no results for me,  
when Owner = 'swaltner' returned 19 tickets.


We'll keep an eye out for the release of 3.6.0 and upgrade to that  
when it gets released.


Steve

On May 24, 2006, at 10:26 AM, Todd Chapman wrote:

Try: Owner = '__CurrentUser__'

I think that only works in 3.6 though.

-Todd

On Wed, May 24, 2006 at 09:47:37AM -0500, Steve Waltner wrote:

I would like to create a Shared Search on RT 3.4.4 which queries for
tickets that I resolved during the last month. The problem is I
can't figure out how to tell the search engine to query for me
based on who is currently logged into the web interface. I'm very new
to using RT, so I probably have simply overlooked something simple.

I currently have the following as my Saved Search, which works fine
for myself

Owner = 'swaltner'
AND Status = 'resolved'
AND Resolved  'Today'
AND Resolved  '-35 Days'

The problem comes when I save this into the shared searches with our
other group members. jdoe doesn't want to search for tickets that
swaltner owned, they are interested in tickets that are owned by
jdoe. Granted each user can load the shared search, update it with
their name, and save it into their personal saved searches, but that
isn't convenient and doesn't make sure that everyone is using the
same queries.

Hopefully there is a keyword like myself (similar to today for
the date searches) that would help here. I've looked through the
mailing list archives and on the Wiki, but don't seem to find
anything useful there. Any assistance would be greatly appreciated.

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


___
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] First Impressions of RT V3.6.0rc2

2006-05-24 Thread Duncan Shannon
Logging in, frankly I like the user interface to 3.4.4 better, I think
the lack of shading and borders causes a lot more eye strain,
especially on an 

Does anyone have any screen shots of the new interface handy? Im quite
excited to see it.

duncan
___
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] First Impressions of RT V3.6.0rc2

2006-05-24 Thread Joshua Colson
On Wed, 2006-05-24 at 11:16 -0500, Duncan Shannon wrote:
 Logging in, frankly I like the user interface to 3.4.4 better, I think
 the lack of shading and borders causes a lot more eye strain,
 especially on an 
 
 Does anyone have any screen shots of the new interface handy? Im quite
 excited to see it.

I setup a quick an dirty demo instance of RT
3.6.0rc2/SQLite/Standalone_HTTPD available at
http://demo.request-tracker.org:8080/ I'll leave it up for a few days if
anyone wants to see what the new version looks like. Be warned however,
it is very slow (my system, not RT). Login is 'guest' with 'rt36guest'

Enjoy

-- 
Joshua Colson [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] Famous RT + FastCGI error

2006-05-24 Thread Avishay Aton
Hi,I already done thatswitched to user web which is the user ,apache run underand typing : /opt/rt3/bin/mason_handler.fcgi yields the RT LOGIN PAGE(i can see the html in the console)
here is part of the output:Pragma: no-cacheSet-cookie: RT_SID_example.com.=3db8545102152ba16be3ca0dc20e48d1; path=/Cache-control: no-cacheContent-Type: text/html; charset=utf-8HTML
HEADTITLELogin/TITLElink rel=shortcut icon href="" type=image/png /link media=all rel=stylesheet href="" type=text/css /
link media=print rel=stylesheet href="" type=text/css /scriptfunction hideshow(num) { idstring = element- + num;
 chunk = document.getElementById(idstring);Pragma: no-cacheSet-cookie: RT_SID_compugen.co.il.=3db8545102152ba16be3ca0dc20e48d1; path=/Cache-control: no-cacheContent-Type: text/html; charset=utf-8
On 5/24/06, Vivek Khera [EMAIL PROTECTED] wrote:
On May 24, 2006, at 11:48 AM, Avishay Aton wrote: [error] [client x.x.x.x] FastCGI: incomplete headers (0 bytes) received from server /opt/rt3/bin/mason_handler.fcgiat the command line, run the mason_handler.fcgi and see what errors
it produces.for best results, run it as the same user ID as yourhttpd server runs the fastcgi process.___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-usersCommunity help: http://wiki.bestpractical.comCommercial support: 
[EMAIL PROTECTED]Discover RT's hidden secrets with RT Essentials from O'Reilly Media.Buy a copy at http://rtbook.bestpractical.comWe'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

[rt-users] Impressions of 3.6.0r2

2006-05-24 Thread Mike Patterson

Thanks for the demo site Joshua.

So far I'm impressed with 3.6.0, simple search will do a lot to 
appease the masses (wah, searching is too hard, so I'll keep 
creating new tickets to ask about old tickets). 

I was hoping that it would include a feature to change ticket history 
sorting (ascending/descending) as an individual preference (e.g.  
showing newest transactions at the top, patch: 
http://wiki.bestpractical.com/index.cgi?ReverseHistoryOrder).  This 
would be especially useful for long tickets.  This was a very important 
feature for me when my pages were loading slowly on old hardware (e.g. 2 
minutes when there are a lot of transactions), but now that I'm running 
RT on real server hardware and those especially long pages just take a 
few seconds. I do realize of course that I can apply the patch (wh, 
how come the feature I want isn't in the main build...).


But I can see that click-sorting can be done for lists of tickets 
which is really great.


Regarding the new layout:
* Losing the left nav-bar is a great choice.
* The rounded top nav-bars look good.
* The Ticket metadata seems to take up a lot more space now, especially 
if you have a lot of custom fields.  I like the older style smaller 
fonts better.  If you are viewing on a laptop screen, that would be 2 
page-downs before you got to the transactions.
* There seems to be larger whitespace between sections   Also there 
appears to be extra border area on the outside edges of the different 
boxes.  Both of those are wastes of space IMHO.
* Could everything above the top nav-bar (logo, search, new ticket in, 
logged in as) be moved to the same level as the top nav-bar somehow, or 
just be the width 1 a nav-bar?
* Would people be able to choose a 3.4.x classic layout just by 
changing the stylesheet?  It might be nice to have a large-font and 
small-font style-sheet option.
* I agree with other folks that all of the white space makes it too 
bright, thus adding eye-strain. Perhaps a more muted color, like the 
one used in wikipedia's style sheet, for empty space would help (or just 
having less white space).


Thanks for all the hard work!

--
Mike Patterson
Systems Manager
UC Berkeley Extension

___
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] Shared Search for Tickets Resolved by me

2006-05-24 Thread Kenneth Crocker

Steve Waltner wrote:
I would like to create a Shared Search on RT 3.4.4 which queries for 
tickets that I resolved during the last month. The problem is I 
can't figure out how to tell the search engine to query for me based 
on who is currently logged into the web interface. I'm very new to 
using RT, so I probably have simply overlooked something simple.


I currently have the following as my Saved Search, which works fine 
for myself


Owner = 'swaltner'
AND Status = 'resolved'
AND Resolved  'Today'
AND Resolved  '-35 Days'

The problem comes when I save this into the shared searches with our 
other group members. jdoe doesn't want to search for tickets that 
swaltner owned, they are interested in tickets that are owned by jdoe. 
Granted each user can load the shared search, update it with their 
name, and save it into their personal saved searches, but that isn't 
convenient and doesn't make sure that everyone is using the same queries.


Hopefully there is a keyword like myself (similar to today for the 
date searches) that would help here. I've looked through the mailing 
list archives and on the Wiki, but don't seem to find anything useful 
there. Any assistance would be greatly appreciated.


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



Steve,

   Don't think so. I think RT was designed to give flexibility but the 
cost is a little work like saving a query with a different search name 
to make it specific. You might be able to create a scrip that has a 
variable the searcher fills in and then runs but, that takes work and RT 
won't do it for you outright. Gotta spend some to get some.


Kenn
___
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] First Impressions of RT V3.6.0rc2

2006-05-24 Thread Vivek Khera
On May 24, 2006, at 11:23 AM, Nick Metrowsky wrote:On installation, the install required installing two perl CPAN modules and it failed to do it via “make fixdeps”, so I had to do them by hand. Not a big deal. The rest of the install/upgrade went flawlessly. Let’s just say it was much easier to go from 3.4.4 to 3.6.0rc, than it was to go from care to share what those two modules were?

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

[rt-users] Requestors not receiving mail

2006-05-24 Thread Thomas Vincent








I am running RT 3.4.5, and today I added another 6 ques for
an even dozen. But my new queues even though they appear identical to the old
ones, do not send email the requestor. We have disabled autoreply upon initial
creation of the ticket. Other then that it is a default install. Scrips havent
bee modified either. 



Logs say: 



No recipients found. Not sending.
(/usr/lib/perl5/vendor_perl/5.8.6/RT/Action/SendEmail.pm:249)





Thanks in advance,



Cheers,

Tom






___
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] Mason question

2006-05-24 Thread Luke Vanderfluit

Hi.

I'm running RT on a test box and want to run another application that 
uses HTML::Mason


In my httpd.conf file I've set up an alias for the other application as 
follows:


/~~~
DocumentRoot /usr/local/rt3/share/html
#DocumentRoot /usr/local/stow/apache-2.0.58/apache-2.0/htdocs
Directory /
   Options FollowSymLinks
   AllowOverride None
/Directory

#PerlRequire /usr/local/rt3/bin/webmux.pl

#Directory /usr/local/rt3/share/html
#Options Indexes FollowSymLinks
#AllowOverride None
#Order allow,deny
#Allow from all
#PerlSetEnv DBI_PROFILE DBI::ProfileDumper::Apache
#   SetHandler perl-script
#   perlhandler RT::Mason
#/Directory

Alias /dashboard /usr/local/stow/apache-2.0.58/apache-2.0/htdocs

PerlModule HTML::Mason::ApacheHandler

Directory /usr/local/stow/apache-2.0.58/apache-2.0/htdocs
   Options Indexes FollowSymLinks
   AllowOverride None
   Order allow,deny
   Allow from all
   SetHandler perl-script
   PerlHandler HTML::Mason::ApacheHandler
/Directory
\__

When I use it as above, I can't get mason to work.
If I change the DocumentRoot it works as expected.

Any ideas why this is so.
Any suggestions on how I can run another application using Mason on the 
same server?


Thanks.
Kind regards.

--
Luke Vanderfluit.
Analyst/Programmer.
Internode Systems Pty. Ltd.

___
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