Re: [rt-users] 3.8.4 installation issue

2009-08-05 Thread Brian Gallew
Kevin Falcone wrote:
 On Tue, Aug 04, 2009 at 02:43:33PM +0300, Brian Gallew wrote:
   
 So, I'm installing RT-3.8.4 on a virgin system, for the most part using
 an RT_SiteConfig.pm that is very similar to the 3.6.5 system I have in
 production (database/hostname differences).  I've run the
 testdeps/fixdeps bits repeatedly and they claim I'm up to date.  I've
 even used the CPAN r command to tell met what to update and then
 update as much as I can, all to no avail.  Here is the error I'm getting:
 

 When you configured, did you say --with-web-handler=modperl2
 otherwise make testdeps can't test everything.
 But, if I had to hazard a guess, I'd say your mod_perl install isn't
 quite kosher

I'll actually address a bunch of emails here:

PERL=/home/rt/perl-5.10.0/bin/perl ./configure
--with-web-handler=modperl1 --with-db-type=mysql
--with-db-host=mysql.qatar.cmu.local --with-db-database=rt3_8_1_test
--with-db-rt-user=rt_user --with-db-rt-pass=rt_pass
--with-web-user=nobody --with-web-group=tty --with-rt-group=nogroup
--with-apachectl=/usr/www/bin/apachectl --prefix=/home/rt


The Apache version is 1.3.39.
The perl version is 5.10.0.

The odd paths to perl and RT result from not trying to rebuild the
entire system and instead just running it from ~rt.  The system perl is
5.8.6, and I'm reasonably sure I saw a post indicating compatibility
issues with that version.  Further, that build has been known to be
changed out from underneath me randomly, thus causing mod_perl to break.

Also, the Fedora Core people wouldn't recognize this as a Fedora Core
system at all.  It's been completely overhauled and integrated with our
package/depot/AFS environment.

The configure command for the (built again just for this email!)
mod_perl1 build is:
21 mod_perl-1.31  /home/rt/perl-5.10.0/bin/perl Makefile.PL
EVERYTHING=1 WITH_APXS=/usr/www/bin/apxs USE_APXS=1

It built and installed flawlessly, but I'm still seeing exactly the same
issue.  I've even trashed and re-initialized the database, to no avail.

And the problem with open source software isn't the quality of the
software.  It's the whiners who have *nothing* to contribute except
carping and flames.  The people at BestPractical have made a great piece
of software available to us at no cost, and the very least we can do is
express our gratitude for their efforts.  (Thanks, guys!)
___
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] 3.8.4 installation issue

2009-08-04 Thread Brian Gallew
So, I'm installing RT-3.8.4 on a virgin system, for the most part using
an RT_SiteConfig.pm that is very similar to the 3.6.5 system I have in
production (database/hostname differences).  I've run the
testdeps/fixdeps bits repeatedly and they claim I'm up to date.  I've
even used the CPAN r command to tell met what to update and then
update as much as I can, all to no avail.  Here is the error I'm getting:

Attempt to reload Apache/Table.pm aborted.
Compilation failed in require at
/home/rt/perl-5.10.0/lib/site_perl/5.10.0/i686-linux/Apache/Request.pm
line 21.
BEGIN failed--compilation aborted at
/home/rt/perl-5.10.0/lib/site_perl/5.10.0/i686-linux/Apache/Request.pm
line 21.
Compilation failed in require at
/home/rt/perl-5.10.0/lib/site_perl/5.10.0/HTML/Mason/ApacheHandler.pm
line 254.
BEGIN failed--compilation aborted at
/home/rt/perl-5.10.0/lib/site_perl/5.10.0/HTML/Mason/ApacheHandler.pm
line 259.
Compilation failed in require at
/home/rt/bin/../lib/RT/Interface/Web/Handler.pm line 140.
Compilation failed in require at (eval 8) line 1.

/usr/www/bin/apachectl startssl: httpd could not be started

I'd tell you this is a Fedora Core 3 system, but that would be
misleading as it's suffered many years worth of modification and changes
and therefore bears no similarity.  Google shows no such error, so I'm
wondering if I've done something egregiously stupid.
___
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] RT memory usage

2008-07-10 Thread Brian Gallew
Karel Vervaeke wrote:
 Are there more suggestions you can give me to make RT / apache2 eating
 all the memory?


The standard reply to Apache uses too much memory is use FastCGI. 
See http://wiki.bestpractical.com/view/FastCGI for pages to help you 
reconfigure along those lines.  That said, Chaim's response should be 
taken seriously anyway: any Apache modules that you are not actually 
using should NOT be loaded/configured.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] rt-3.8.0rc testing on same pc running rt-3.6

2008-06-24 Thread Brian Gallew
[EMAIL PROTECTED] wrote:
 I was wondering if I can install a test instance of rt-3.8.0rcX on the 
 same computer running our production rt-3.6.3?

Sure, but it's non-trivial.  You'll need another database repository and 
appropriate setups with your web server.  Really, the only painful issue 
is the mail gateway.  Well, and if you want to simultaneously change 
Perl versions while using mod_perl, you're better off making a different 
choice.

Personally, I would use a virtual machine.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] RT 3.8.0 BETA 3 now available

2008-06-10 Thread Brian Gallew
Jesse Vincent wrote:
 I'm pleased to announce the third beta release of RT 3.8.0.  In the 
 month since beta 2, we've resolved hundreds of tickets (some over 5 
 years old) and averaged over 10 commits per day.  We're really, really 
 hoping to release RT 3.8.0rc1 this Friday but can't do it without your 
 help. Please test out beta 3 and report issues you run into.

First nit: make upgrade fails, because rt-server doesn't already exist
in the old installation.  Copying it in by hand makes it all better, of
course.

Second issue: IPC::Run::SafeHandles is missed in the dependencies if
GraphViz is enabled.

Third issue (probably not widespread): if you use an external
authentication mechanism like PubCookie, GraphViz images don't show in
Safari (Firefox does the right thing) because when Safari load the
image, it really gets an HTML page re-directing it to the auth server,
which will eventually send it back to the original location with an
improved cookie, which will then load the image.  It's sad, really.  I
blame Safari.

 I'm particularly interested in those of you using Internet Explorer.  I 
 just lost a perfectly good evening to IE's quirks and completely redoing 
 RT 3.8's IE compatibility layer. Did my evening of pain have any sort of 
 positive impact?

With MSIE 6.0.2900.blahblahblah there is some minor, but annoying
overlap of all the panes containing tickets on the RT at a Glance page.

The ticket view is *great* except for an overlap in Comments where the
first word of the comment overlaps the dark blue box with the #.


This looks great!

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] 3.7.86 system search editing broken?

2008-06-10 Thread Brian Gallew
In a previous version of RT, I edited two system searches:
Search - Unowned Tickets
Search - My Tickets

I did this so that I could add Take, SPAM, and Resolve columns.  
As part of the upgrade to 3.7.86, I've noticed that the nbsp; that I 
put in place of the column name has apparently been URL-escaped.  So, I 
tried to edit these searches again and was surprised to discover that 
the Query Builder didn't show any query at all!  Switching to Advanced 
mode revealed an empty query, too.  I kind of expected to see a message 
in the logfile, but there was nothing.  Have I found a bug?
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] SearchBuilder and time intervals

2008-05-29 Thread Brian Gallew
Jesse Vincent wrote:
 RT's ticketsql actually should be able to handle this somewhat more simply:
 
 Owner = 'jesse' AND Resolved  '2 weeks ago'
 
 works for me :)

Wow, do I feel stupid!
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] SearchBuilder and time intervals

2008-05-28 Thread Brian Gallew
I'm having a problem doing time interval searches in RT.  What I want is
Owner = '11510' AND
Resolved  datesub(curdate(), interval 2 weeks)

The above syntax works for MySQL (which is what I'm using). 
Unfortunately, SearchBuilder doesn't seem to do the right thing with 
this.  I've also not found a way to get this to work from the 
documentation.  Have I missed something or is this simply impossible?
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] 3.8 suggestion

2008-05-21 Thread Brian Gallew
Here's a minor suggestion for 3.8: versioned schemas.

It would be a lot easier to automate upgrade if you could simply query
the database to determine what schema version is installed.  Yeah, I
know, nothing like coming late to the party, but this came up while I
was attempting to upgrade to the latest beta.

Who knows?  It might even provide a clever programmer the capability of
writing an extension that performs correctly across multiple versions,
or does different things for different versions.


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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Minor patch

2007-10-09 Thread Brian Gallew

Jesse Vincent wrote:
Thanks for the patch. That looks like a kind of strange place to put 
that skip. Is there a reason it's not at the start of the loop?


Because I backtracked to the first place that looked reasonable.  8-)

I have no preferences here, as long as it works!
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Minor patch

2007-10-08 Thread Brian Gallew
The following patch prevents an error message about Unknown update 
type on my RT installation whenever I try to update a multi-choice 
custom field with categories.


--- lib/RT/Interface/Web.pm 2007-07-19 22:30:01.0 +0300
+++ local/lib/RT/Interface/Web.pm   2007-10-07 15:10:17.0 +0300
@@ -1281,6 +1281,7 @@
s/\r//g foreach @values;
}
@values = grep defined  $_ ne '', @values;
+next if $arg =~ /Category$/;

if ( $arg eq 'AddValue' || $arg eq 'Value' ) {
foreach my $value (@values) {

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Custom reports

2007-09-12 Thread Brian Gallew

Fernando Fugita wrote:

Hello,

I need to create a custom report, showing the number of tickets for 
certain type (a custom field of the RT), in a determined period.

I tried the RTx-Statistics, but was not useful.


You really have to write it yourself.  Attached is a report that we use 
at Carnegie Mellon - Qatar.




WorkByClassification.tgz
Description: GNU Zip compressed data
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] RT 4

2007-06-05 Thread Brian Gallew

Robert Grasso wrote:
Microsoft has accustomed so many people to consider that IT IS this 
colorful window with buttons and the mouse, now KDE and Gnome go

this way too (Gnome is hiding every possible technical aspect it can - it's a 
pain to me and geeks and a joy for non-IT people). I
can hear your arguments about the technical limitation of a browser and such. 
But usual people can't and don't want to. Usual people
want to use softwares (whatever software) without any kind of hassle - our 
support staff are these kind of people, and the
workaround that you use and suggest is an unpleasant fix to them, they dislike and 
reject it even if they use it, and the comfort
functions should be added, because this is the way IT goes nowadays (I was 
reporting here my people's opinion).
  


Ignoring the obvious fact that you responded to an honest question about 
desired features with an honest request for a feature, I fear you are 
faced with an insurmountable problem: RT isn't client-based, and 
therefore has no interesting offline mode.  Outlook works the way it 
does because everything is written to local disk, and is running on the 
local machine.  You may want to look into the Java client that was 
advertised earlier (in spite of its deficiencies).


The email interface may actually be a valuable alternative.  Since you 
refer to Outlook, may I assume you are using Exchange Server?  If that's 
the case, there may be some interesting things you can do with forms and 
so forth (really, I don't know, as I don't use either).  Zimbra has a 
nice model which seems like someone with a gift for Exchange should be 
able to copy somewhat, though it's another web based product, and 
therefore subject to the deficiencies of any web-based products.

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] RT 4

2007-05-04 Thread Brian Gallew

Scott Courtney wrote:

3. Active Directory interface/native integration - This is a biggie.
NOBODY want's / needs an extra user ID / password combo to remember.



-1 on Active Directory integration; +1 on Kerberos integration that *also*
works with AD. Please don't go down the platform-specific road; support the
open standard instead.
  


Perhaps I'm weird, but I don't want *any* native authentication in RT.  
Authentication is the domain of the web server.  I vastly prefer RT to 
behave appropriately according to the current web server authentication, 
automatically creating new users as they appear, and all 
non-authenticated users become anonymous.  Of course, RT already 
supports this mode of operation, so I'm happy.  8-)

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Yet another Summer of Code idea (if it's not too late)

2007-03-25 Thread Brian Gallew

Hierarchical ticket views.

Let's say I have a Project, with a number of Tasks under it.  It would
be nice to be able to group the Tasks under the Project, potentially
with the ability to hide/reveal the child tasks.  Trying to do this in
raw SQL would be truly hideous, though I'm sure there is some bright
girl (all the best SQL coders I know are female) out there who could
figure out a way to do it.



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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Attachments and unhappiness

2007-03-08 Thread Brian Gallew
So, I've figured out the attachment issue: not only much the attachments 
table default to the latin1 charset, but your CONNECTION must also be in 
latin1 mode.  In my environment, the mysql (5.0.24a) server (on another 
host) defaults everything to utf8, while the RT installation is using 
mysql-4.0.25, which completely fails to set the connection type based on 
the contents of /etc/my.cnf.  I was able to fix the problem by applying 
the patch at the end. 


--- RT.pm.orig  2007-03-08 11:49:10.0 +0300
+++ RT.pm   2007-03-08 11:38:54.0 +0300
@@ -203,6 +203,7 @@
$Handle = RT::Handle-new();
}
$Handle-Connect();
+$Handle-SimpleQuery(SET NAMES 'latin1');
}

=head2 InitLogging

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Still struggling with truncated attachments

2007-03-04 Thread Brian Gallew
I'm running RT-3.6.1, and I'm having problems with attachments.  The 
problem started when I switched from mysql on the local machine to a 
central mysql service.  I have this sinking feeling that the cause of 
the problem is that the new database server has a default character set 
of UTF8.  I've tried ALTER-ing the Attachments table to be binary and 
latin1, neither of which seem to make the right thing happen.


What does happen is that the attachment is saved into the database, but 
it's truncated at (I think) the first NULL character.  There may be 
other characters that trigger this, but it's clear that, for instance, 
PDFs are saved as 10 bytes (basically, just the file magic).  Images 
mostly end up being just file magic.


So, any ideas?  Is there a specific character set that should be used 
for RT tables?  Are there specific settings for the my.cnf that are 
required to move the data around?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Google Summer of Code

2007-02-28 Thread Brian Gallew

Jesse Vincent wrote:
I'd love to submit RT to Google's Summer of Code this summer.  It's 
probably time to start brainstorming projects.


What would you like to do/see done as part of a RT summer of code 
project?


Better RTx::Shredder integration, with some built-in useful operations 
such as purge all users that are not referenced by any 
tickets/attachments/transactions/etc, one-button validations of 
*everything*, and so forth.


A global scrip repository.  Right now you have global scrips and 
per-queue scrips.  Wouldn't it be nice if, when you set up a new queue, 
that instead of writing a bunch of new scrips that are identical with 
some of the scrip used elsewhere, you can just select them (kind of like 
group membership: these queue execute this scrip)?  Sure, I could write 
*all* my scrips as global scrips and then put queue-name tests in them, 
modifying them each time I add a queue, but that seems to be an 
unnecessary risk.


Integration and clean-up of the RTx::Report(s) module.  Reports are fun!
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Suggestions for auto-archiving?

2007-01-31 Thread Brian Gallew

Roy El-Hames wrote:

This is something I pondered over , few time in the past ..
for moving the tickets possibly have a look at Ruslan's RTx::Shredder 
as a starting point (the principle of that module is to delete 
tickets, however I think you can modify it to copy the tickets else 
where before deleting them).
The problems/obstacle then is how to search tickets that you have 
moved to the archive??


Actually, if you run RTx::Shredder, it write an SQL file out by default 
that can be used to restore the data.  That being the case, you would 
need to replicate the users and queues (by ID) in your backup database 
and load in the archive files.  For the very first purge, I'd be tempted 
to do it backwards: dump the entire database, restore the whole thing to 
the archive instance, and then purge everything newer than X, 
simultaneously purging everything older than X in the real instance.  
Then Shredder could be used to create future diffs to to apply to the 
archive.  You would have to come up with a reasonable way to add 
users/queues in a more or less automated fashion, too.

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Hide Tiket - ability

2007-01-11 Thread Brian Gallew

joey wrote:

Hey,

is it possible to hide a ticket for a given period of time -
user-specific. I want to have a field with hide ticket with a
duration. Anyone done this before?
  


There are two ways that come to mind:
1) Set the ticket status to stalled and create a reminder for it.  This 
requires you to modify the reminder query to not include reminders in 
the future.
2) Set the ticket status to stalled AND set the due date field to be 
the date you want the ticket to come back.  This requires that you add a 
saved query to your RTaaG page that shows all tickets that are both 
stalled and overdue.

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] What kind of hardware setup are you using?

2006-12-05 Thread Brian Gallew

John Arends wrote:
I'm curious what type of machine people here using to run RT as well 
as what sort of database, and if the machines have anything else 
running on them.


At the moment I'm thinking about running the RT instance in a VMWare 
server pointing the database to our departmental MySQL server.


I've built a pair of MySQL servers configured for circular replication 
as VMware images, and have both my production and development RT systems 
running as VMware images also.  It works just peachy, though I will 
admit that I don't have a very large database.


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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] MIME::Entity upgrade problems

2006-12-03 Thread Brian Gallew
I was attempting to upgrade parts of the perl backend on my RT 
installation, and discovered the following badness after updating 
MIME::Entity (among others):


Can't locate auto/MIME/Entity/_Accessible.al in @INC (@INC contains: 
/home/rt/local/lib /home/rt/lib /home/rt/perl-5.8.5/lib/5.8.5/i686-linux 
/home/rt/perl-5.8.5/lib/5.8.5 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/i686-linux 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5 /home/rt/perl-5.8.5/lib/site_perl . 
/usr/www/ /usr/www/lib/perl) at 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 424


Trace begun at /home/rt/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Exceptions.pm 
line 129
HTML::Mason::Exceptions::rethrow_exception('Can\'t locate 
auto/MIME/Entity/_Accessible.al in @INC (@INC contains: /home/rt/local/lib 
/home/rt/lib /home/rt/perl-5.8.5/lib/5.8.5/i686-linux 
/home/rt/perl-5.8.5/lib/5.8.5 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/i686-linux 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5 /home/rt/perl-5.8.5/lib/site_perl . 
/usr/www/ /usr/www/lib/perl) at 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 
424^J') called at /home/rt/perl-5.8.5/lib/5.8.5/Carp.pm line 201
Carp::croak('Can\'t locate auto/MIME/Entity/_Accessible.al in @INC (@INC 
contains: /home/rt/local/lib /home/rt/lib 
/home/rt/perl-5.8.5/lib/5.8.5/i686-linux /home/rt/perl-5.8.5/lib/5.8.5 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/i686-linux 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5 /home/rt/perl-5.8.5/lib/site_perl . 
/usr/www/ /usr/www/lib/perl)') called at 
/home/rt/perl-5.8.5/lib/5.8.5/AutoLoader.pm line 112
AutoLoader::AUTOLOAD('MIME::Entity=HASH(0x9e04628)', 'len', 'read') called at 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 424
DBIx::SearchBuilder::Record::AUTOLOAD('MIME::Entity=HASH(0x9e04628)') called at 
/home/rt/lib/RT/Attachment_Overlay.pm line 153
RT::Attachment::Create('RT::Attachment=HASH(0x9e14534)', 'TransactionId', 
47141, 'Attachment', 'MIME::Entity=HASH(0x9e04628)') called at 
/home/rt/lib/RT/Transaction_Overlay.pm line 485
RT::Transaction::_Attach('RT::Transaction=HASH(0x9e100a0)', 
'MIME::Entity=HASH(0x9e04628)') called at 
/home/rt/lib/RT/Transaction_Overlay.pm line 156
RT::Transaction::Create('RT::Transaction=HASH(0x9e100a0)', 'ObjectId', 5119, 
'ObjectType', 'RT::Ticket', 'TimeTaken', undef, 'Type', 'Comment', 'Data', 'No 
Subject', 'Field', undef, 'NewValue', undef, 'OldValue', undef, 'NewReference', 
undef, 'OldReference', undef, 'ReferenceType', undef, 'MIMEObj', 
'MIME::Entity=HASH(0x9e04628)', 'ActivateScrips', 1, 'CommitScrips', 0) called 
at /home/rt/lib/RT/Record.pm line 1446
RT::Record::_NewTransaction('RT::Ticket=HASH(0x9cda6a8)', 'Type', 'Comment', 
'Data', 'No Subject', 'TimeTaken', undef, 'MIMEObj', 
'MIME::Entity=HASH(0x9e04628)', 'CommitScrips', 0) called at 
/home/rt/lib/RT/Ticket_Overlay.pm line 2442
RT::Ticket::_RecordNote('RT::Ticket=HASH(0x9cda6a8)', 'DryRun', 1, 
'BccMessageTo', undef, 'CcMessageTo', undef, 'NoteType', 'Comment', 
'TimeTaken', undef, 'MIMEObj', 'MIME::Entity=HASH(0x9e04628)', 'Content', 
undef, 'CommitScrips', 0) called at /home/rt/lib/RT/Ticket_Overlay.pm line 2306
RT::Ticket::Comment('RT::Ticket=HASH(0x9cda6a8)', 'CcMessageTo', undef, 
'BccMessageTo', undef, 'MIMEObj', 'MIME::Entity=HASH(0x9e04628)', 'TimeTaken', 
undef, 'DryRun', 1) called at /home/rt/share/html/Ticket/Elements/PreviewScrips 
line 82
HTML::Mason::Commands::__ANON__('TicketObj', 'RT::Ticket=HASH(0x9cda6a8)', 
'Action', 'Comment', 'id', 5119) called at 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9e0adf8)',
 'TicketObj', 'RT::Ticket=HASH(0x9cda6a8)', 'Action', 'Comment', 'id', 5119) 
called at /home/rt/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 
1256
eval {...} at /home/rt/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm 
line 1250
HTML::Mason::Request::comp(undef, undef, 'TicketObj', 
'RT::Ticket=HASH(0x9cda6a8)', 'Action', 'Comment', 'id', 5119) called at 
/home/rt/local/html/Ticket/Update.html line 137
HTML::Mason::Commands::__ANON__('Action', 'Comment', 'id', 5119, 'Action', 
'Comment', 'id', 5119) called at 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9bf8470)',
 'Action', 'Comment', 'id', 5119, 'Action', 'Comment', 'id', 5119) called at 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1256
eval {...} at /home/rt/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm 
line 1250
HTML::Mason::Request::comp(undef, undef, 'Action', 'Comment', 'id', 5119, 
'Action', 'Comment', 'id', 5119) called at 
/home/rt/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 915
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x9ce5690)',
 'Action', 'Comment', 'id', 5119) called at /home/rt/share/html/autohandler 
line 279

Re: [rt-users] cannot attach files to a ticket from the web interface

2006-11-30 Thread Brian Gallew




Jon Daley wrote:
I didn't really follow this conversation, so perhaps I missed 
something.  It isn't a problem with 3.6.1, as that is what I run, 
and attachments work fine.  (I hadn't ever tried an RTF before, but 
I just did, and it worked perfectly fine).
Are you emailing the attachment, or uploading it via the GUI?  
If it is email, perhaps there is something on that end, or a mime 
module that needs to be upgraded or something?
For me, neither the web UI nor the email gateway work for attachments.  
The log shows nothing but complaints about using uninitialized values in 
lots of components in the 3.6.1-native code.  Seeing the earlier 
responses about possible bad versions in various supporting libraries, 
I've updated *everything* except for Perl itself (which is still 5.8.5) 
and B::Concise.  According to CPAN, all other possible libraries are 
up-to-date.  I've even gone so far as to edit and re-run factory to 
regenerate the searchbuilder code in lib/RT.  All to no avail.  Any file 
which contains a NULL is truncated at the first null leaving, e.g., PDFs 
completely useless.


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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] cannot attach files to a ticket from the web interface

2006-11-30 Thread Brian Gallew

Roberto Nunnari wrote:

Jesse Vincent wrote:
Just for kicks, see if updating your CGI.pm to current improves 
things. There was a set of releases with a broken upload() method.


I could not find and CGI.pm file under my RT installation..


CGI.pm is part of the CPAN package CGI.  The typical way of updating
this is to fire up cpan and type install CGI.  That will update it to
the most recent version.  Of course, this assumes that you have CPAN
installed.


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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Attachments truncated

2006-11-22 Thread Brian Gallew

I'm having an issue where RT is completely unable to store binary
attachments (images, PDFs, programs).  While this may be a good thing
from an anti-virus POV, it's kind of annoying when we want to attach
relevant information.  What we're seeing is that RT is storing
everything up to the first NULL.  It does this both for the web UI as
well as the email UI.  Any suggestions?  I've attached my configuration
information.



 System Configuration

   * System Configuration /Admin/Tools/Configuration.html
   * ยท Shredder /Admin/Tools/Shredder


   Loaded perl modules

Perl v5.8.5 under linux
 Apache v1.27;
 Apache::Connection v1.00;
 Apache::Constants v1.09;
 Apache::Request v1.33;
 Apache::Server v1.01;
 Apache::Session v1.81;
 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.02;
 base v2.06;
 Benchmark v1.06;
 bytes v1.01;
 Cache::Simple::TimedExpiry v0.23;
 Carp v1.03;
 CGI v3.20;
 CGI::Cookie v1.27;
 CGI::Util v1.5;
 Class::Container v0.11;
 Class::Data::Inheritable v0.02;
 Class::ReturnValue v0.53;
 Clone v0.20;
 constant v1.04;
 Cwd v3.19;
 Data::Dumper v2.121;
 Date::Format v2.22;
 Date::Parse v2.27;
 DBD::mysql v3.0006;
 DBI v1.51;
 DBIx::SearchBuilder v1.43;
 DBIx::SearchBuilder::Union v0;
 DBIx::SearchBuilder::Unique v0.01;
 Devel::StackTrace v1.13;
 Devel::StackTraceFrame v0.6;
 Digest::base v1.00;
 Digest::MD5 v2.36;
 DynaLoader v1.05;
 Encode v2.01;
 Encode::Alias v2.00;
 Encode::CN v2.00;
 Encode::CN::HZ v2.01;
 Encode::Config v2.00;
 Encode::Encoding v2.00;
 Encode::Guess v2.00;
 Encode::Unicode v2.00;
 Errno v1.09;
 Exception::Class v1.23;
 Exception::Class::Base v1.2;
 Exporter v5.58;
 Exporter::Heavy v5.58;
 Fcntl v1.05;
 File::Basename v2.73;
 File::Glob v1.03;
 File::Path v1.06;
 File::Spec v3.19;
 File::Spec::Unix v1.5;
 File::Temp v0.16;
 FileHandle v2.01;
 HTML::Element v3.16;
 HTML::Entities v1.35;
 HTML::Formatter v2.04;
 HTML::FormatText v2.04;
 HTML::Mason v1.33;
 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.55;
 HTML::Scrubber v0.08;
 HTML::Tagset v3.03;
 HTML::TreeBuilder v3.13;
 HTTP::Date v1.47;
 I18N::LangTags v0.33;
 I18N::LangTags::Detect v1.03;
 integer v1.00;
 IO v1.21;
 IO::File v1.10;
 IO::Handle v1.24;
 IO::InnerFile v2.102 ;
 IO::Lines v2.103 ;
 IO::Scalar v2.105 ;
 IO::ScalarArray v2.103 ;
 IO::Seekable v1.09;
 IO::Wrap v2.102 ;
 IO::WrapTie v2.102 ;
 IPC::Open2 v1.01;
 IPC::Open3 v1.0106;
 lib v0.5565;
 List::Util v1.18;
 Locale::Maketext v1.10;
 Locale::Maketext::Fuzzy v0.02;
 Locale::Maketext::Lexicon v0.62;
 Locale::Maketext::Lexicon::Gettext v0.15;
 Log::Dispatch v2.11;
 Log::Dispatch::Base v1.09;
 Log::Dispatch::Output v1.26;
 Log::Dispatch::Screen v1.17;
 Log::Dispatch::Syslog v1.18;
 Mail::Address v1.74;
 Mail::Field v1.74;
 Mail::Field::AddrList v1.74;
 Mail::Field::Date v1.74;
 Mail::Header v1.74;
 Mail::Internet v1.74;
 MIME::Base64 v3.05;
 MIME::Body v5.420;
 MIME::Decoder v5.420;
 MIME::Decoder::Base64 v5.420;
 MIME::Decoder::NBit v5.420;
 MIME::Decoder::QuotedPrint v5.420;
 MIME::Entity v5.420;
 MIME::Field::ContDisp v5.420;
 MIME::Field::ConTraEnc v5.420;
 MIME::Field::ContType v5.420;
 MIME::Field::ParamVal v5.420;
 MIME::Head v5.420;
 MIME::Parser v5.420;
 MIME::QuotedPrint v3.03;
 MIME::Tools v5.420;
 MIME::Words v5.420;
 mod_perl v1.29;
 Module::Versions::Report v1.02;
 overload v1.01;
 Params::Validate v0.85;
 POSIX v1.08;
 re v0.04;
 Regexp::Common v2.120;
 Regexp::Common::delimited v2.104;
 RT v3.6.1;
 RT::Interface::Email v2;
 Scalar::Util v1.18;
 SelectSaver v1.00;
 Socket v1.77;
 Storable v2.15;
 strict v1.03;
 Symbol v1.05;
 Sys::Hostname v1.11;
 Sys::Syslog v0.05;
 Text::Autoformat v1.13;
 Text::Quoted v1.8;
 Text::Reform v1.11;
 Text::Tabs v98.112801;
 Text::Template v1.44;
 Text::Wrapper v1.000;
 Time::HiRes v1.87;
 Time::JulianDay v2003.1125;
 Time::Local v1.1;
 Time::ParseDate v2003.1126;
 Time::Timezone v2003.0211;
 Time::Zone v2.22;
 Tree::Simple v1.16;
 UNIVERSAL v1.01;
 UNIVERSAL::require v0.10;
 URI v1.34;
 URI::Escape v3.26;
 utf8 v1.04;
 vars v1.01;
 warnings v1.03;
 warnings::register v1.00;
 XSLoader v0.02;




   RT Variables

RT::AmbiguousDayInPast  1
RT::BasePath/home/rt
RT::BinPath /home/rt/bin
RT::CORE_CONFIG_FILE/home/rt/etc/RT_Config.pm
RT::CommentAddress  

[rt-users] Callback question

2006-11-22 Thread Brian Gallew
First of all: callbacks are way cool.  I've used them in a number of 
places and found them to be vastly superior to copying an entire page 
and modifying it.  Unfortunately, this brings me to a problem: figuring 
out where callbacks really are being looked for.  Let me present an example.


I've created a local copy of Update.html which includes the following 
snippet of code inserted just before the end of the form:

 /Ticket/Elements/ShowHistory ,
 Ticket = $TicketObj,
 ShowTitle = 0,
 ShowDisplayModes = 0,
 ShowTitleBarCommands = 0,
 


Obviously, my purpose here is to make the ticket history available to 
the commentor.  To be even more convenient, *all* I want to display are 
comments.  No priority updates, status changes, etc.  So, I then created 
$RTHOME/local/html/Callbacks/CMUQ/Ticket/Update.html/SkipTransaction.  
My thought here is that the ShowHistory element has a callback 
(SkipTransaction) which will allow me to skip all of the uninteresting 
transactions.  Sadly, it's *not* finding this file (verified by simply 
inserting syntax errors which had no effect).


Now, while it would be nice to know the correct place to do this in this 
specific case, it would be nice if there was a developer mode switch 
that I could enable that would make the Callback mechanism reveal each 
place it is looking for a callback.  Clearly this would have performance 
implications, though the reality is that if you are running in developer 
mode then your performance will already be quite poor.


Anyway, I'm running 3.6.1 on RHEL4U4.  My complete configuration 
information was attached to the message I sent 10 minutes ago about 
attachment issues.


___
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