[rt-users] subcribe

2014-01-28 Thread Sanka Dissanayake




Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Jonah Hirsch
Yeah I'd removed AssetTracker a while ago. Looks like I missed the _Vendor 
files since that's all that remained (CustomFields, CustomField, System, and 
Ticket _Vendor.pm files).

Removing those files has fixed the issue. Thanks for helping me track this down!

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Tuesday, January 28, 2014 2:28 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

On Tue, 2014-01-28 at 21:12 +, Jonah Hirsch wrote:
> I got the upgrades to run successfully, but I still get the memory 
> issue when merging tickets.
> 
> I noticed that System_Vendor.pm wasn't a stock RT file either, but I'm 
> not sure where it came from. Here's its contents:

That would be the third-party RTx::AssetTracker extension -- which as fas as 
I'm aware does not function on RT 4.2.  If it's installed into /opt/rt4/lib/, 
it's also installed incorrectly, which will make removing it somewhat more 
difficult -- you should remove all *_Vendor.pm, *_Overlay.pm, and *_Local.pm 
files from /opt/rt4/lib/
 - Alex



Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Alex Vandiver
On Tue, 2014-01-28 at 21:12 +, Jonah Hirsch wrote:
> I got the upgrades to run successfully, but I still get the memory
> issue when merging tickets.
> 
> I noticed that System_Vendor.pm wasn't a stock RT file either, but I'm
> not sure where it came from. Here's its contents:

That would be the third-party RTx::AssetTracker extension -- which as
fas as I'm aware does not function on RT 4.2.  If it's installed
into /opt/rt4/lib/, it's also installed incorrectly, which will make
removing it somewhat more difficult -- you should remove all
*_Vendor.pm, *_Overlay.pm, and *_Local.pm files from /opt/rt4/lib/
 - Alex



Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Jonah Hirsch
I got the upgrades to run successfully, but I still get the memory issue when 
merging tickets.

I noticed that System_Vendor.pm wasn't a stock RT file either, but I'm not sure 
where it came from. Here's its contents:

package RT::System;

use strict;
no warnings qw(redefine);

sub AvailableRights {
my $self = shift;

my $queue = RT::Queue->new(RT->SystemUser);
my $group = RT::Group->new(RT->SystemUser);
my $cf= RT::CustomField->new(RT->SystemUser);
my $class = RT::Class->new(RT->SystemUser);
#my $type =  RTx::AssetTracker::Type->new(RT->SystemUser);

my $qr = $queue->AvailableRights();
my $gr = $group->AvailableRights();
my $cr = $cf->AvailableRights();
my $clr = $class->AvailableRights();
#my $tr = $type->AvailableRights();

# Build a merged list of all system wide rights, queue rights and group 
rights.
my %rights = (%{$RT::System::RIGHTS}, %{$gr}, %{$qr}, %{$cr}, %{$clr});#, 
%$tr);
delete $rights{ExecuteCode} if RT->Config->Get('DisallowExecuteCode');

return(\%rights);
}

sub RightCategories {
my $self = shift;

my $queue = RT::Queue->new(RT->SystemUser);
my $group = RT::Group->new(RT->SystemUser);
my $cf= RT::CustomField->new(RT->SystemUser);
my $class = RT::Class->new(RT->SystemUser);
#my $type =  RTx::AssetTracker::Type->new(RT->SystemUser);

my $qr = $queue->RightCategories();
my $gr = $group->RightCategories();
my $cr = $cf->RightCategories();
my $clr = $class->RightCategories();
   # my $tr = $type->RightCategories();

# Build a merged list of all system wide rights, queue rights and group 
rights.
my %rights = (%{$RT::System::RIGHT_CATEGORIES}, %{$gr}, %{$qr}, %{$cr}, 
%{$clr});#, %$tr);

return(\%rights);
}

1;

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Tuesday, January 28, 2014 12:41 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

On Tue, 2014-01-28 at 19:18 +, Jonah Hirsch wrote:
> I just remembered that when upgrading I had some database upgrade 
> errors.  I checked the upgrade history in RT and saw that it failed 
> upgrading the DB schema from 4.1.12 on. When I try to run
> 
> /opt/rt4/sbin/rt-setup-database --action insert --datafile content
> 
>  From the /rt-4.2.2/etc/upgrade/4.1.12 directory I get the following 
> including an error:

The right way to try to resume the upgrade is

/opt/rt4/sbin/rt-setup-database --action upgrade

...and enter 4.1.12 as the starting version.

> Now inserting data.
> [52450] [Tue Jan 28 19:16:07 2014] [debug]: Going to load 'content' 
> data file (/opt/rt4/sbin/../lib/RT/Handle.pm:814)
> [52450] [Tue Jan 28 19:16:07 2014] [debug]: Creating ACL... 
> (/opt/rt4/sbin/../lib/RT/Handle.pm:1017)
> [52450] [Tue Jan 28 19:16:07 2014] [critical]: Can't use an undefined 
> value as a HASH reference at /opt/rt4/sbin/../lib/RT/System_Vendor.pm line 
> 22, <$handle> line 1. (/opt/rt4/sbin/../lib/RT.pm:393) Can't use an undefined 
> value as a HASH reference at /opt/rt4/sbin/../lib/RT/System_Vendor.pm line 
> 22, <$handle> line 1.

RT doesn't ship a System_Vendor.pm, so color me extremely suspicious.
 - Alex



Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Alex Vandiver
On Tue, 2014-01-28 at 19:18 +, Jonah Hirsch wrote:
> I just remembered that when upgrading I had some database upgrade
> errors.  I checked the upgrade history in RT and saw that it failed
> upgrading the DB schema from 4.1.12 on. When I try to run
> 
> /opt/rt4/sbin/rt-setup-database --action insert --datafile content
> 
>  From the /rt-4.2.2/etc/upgrade/4.1.12 directory I get the following 
> including an error:

The right way to try to resume the upgrade is

/opt/rt4/sbin/rt-setup-database --action upgrade

...and enter 4.1.12 as the starting version.

> Now inserting data.
> [52450] [Tue Jan 28 19:16:07 2014] [debug]: Going to load 'content' data file 
> (/opt/rt4/sbin/../lib/RT/Handle.pm:814)
> [52450] [Tue Jan 28 19:16:07 2014] [debug]: Creating ACL... 
> (/opt/rt4/sbin/../lib/RT/Handle.pm:1017)
> [52450] [Tue Jan 28 19:16:07 2014] [critical]: Can't use an undefined value 
> as a HASH reference at /opt/rt4/sbin/../lib/RT/System_Vendor.pm line 22, 
> <$handle> line 1. (/opt/rt4/sbin/../lib/RT.pm:393)
> Can't use an undefined value as a HASH reference at 
> /opt/rt4/sbin/../lib/RT/System_Vendor.pm line 22, <$handle> line 1.

RT doesn't ship a System_Vendor.pm, so color me extremely suspicious.
 - Alex



Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Jonah Hirsch
I just remembered that when upgrading I had some database upgrade errors.  I 
checked the upgrade history in RT and saw that it failed upgrading the DB 
schema from 4.1.12 on. When I try to run

/opt/rt4/sbin/rt-setup-database --action insert --datafile content

 From the /rt-4.2.2/etc/upgrade/4.1.12 directory I get the following including 
an error:

Now inserting data.
[52450] [Tue Jan 28 19:16:07 2014] [debug]: Going to load 'content' data file 
(/opt/rt4/sbin/../lib/RT/Handle.pm:814)
[52450] [Tue Jan 28 19:16:07 2014] [debug]: Creating ACL... 
(/opt/rt4/sbin/../lib/RT/Handle.pm:1017)
[52450] [Tue Jan 28 19:16:07 2014] [critical]: Can't use an undefined value as 
a HASH reference at /opt/rt4/sbin/../lib/RT/System_Vendor.pm line 22, <$handle> 
line 1. (/opt/rt4/sbin/../lib/RT.pm:393)
Can't use an undefined value as a HASH reference at 
/opt/rt4/sbin/../lib/RT/System_Vendor.pm line 22, <$handle> line 1.


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jonah Hirsch
Sent: Tuesday, January 28, 2014 11:59 AM
To: Alex Vandiver; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

I get nothing in logs with debugging on before the system locks up.  The issue 
still occurs after disabling all extensions but RT::Authen::ExternalAuth.

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Tuesday, January 28, 2014 11:45 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

On Tue, 2014-01-28 at 16:23 +, Jonah Hirsch wrote:
> It seems to occur for any ticket. I tried it on our most innocuous 
> queue and it still occurred. Removed all people from the ticket, no 
> special things in the ticket, and it still causes its apache process 
> to lock up the system.

Do you have any extensions or customizations installed?  Are there any errors 
in your error logs?
 - Alex



Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Jonah Hirsch
I get nothing in logs with debugging on before the system locks up.  The issue 
still occurs after disabling all extensions but RT::Authen::ExternalAuth.

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Tuesday, January 28, 2014 11:45 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

On Tue, 2014-01-28 at 16:23 +, Jonah Hirsch wrote:
> It seems to occur for any ticket. I tried it on our most innocuous 
> queue and it still occurred. Removed all people from the ticket, no 
> special things in the ticket, and it still causes its apache process 
> to lock up the system.

Do you have any extensions or customizations installed?  Are there any errors 
in your error logs?
 - Alex



Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Alex Vandiver
On Tue, 2014-01-28 at 16:23 +, Jonah Hirsch wrote:
> It seems to occur for any ticket. I tried it on our most innocuous
> queue and it still occurred. Removed all people from the ticket, no
> special things in the ticket, and it still causes its apache process to
> lock up the system.

Do you have any extensions or customizations installed?  Are there any
errors in your error logs?
 - Alex



Re: [rt-users] Displaying HTML in RT4?

2014-01-28 Thread Emmanuel Lacour
On Tue, Jan 28, 2014 at 04:22:23PM +, Giuseppe Sollazzo wrote:
> 
> Hi,
> I'm trying to understand if RT4 can display html e-mails. As far as I
> can see, it has support for sending html out as multi-part e-mails, but
> nothing obvious on the receiving side of things.
> 
> The only two things I find are
> - - something called ScrubHTML, but that was just in RT3
> - - Set($PreferRichText, true); - which parses some rich text and html,
> like text decoration or font face, but not tables for example.
> 
> Is there any known way of doing this?
> 


You may do it yourself
(http://www.bestpractical.com/docs/rt/4.2/RT/Interface/Web.html#NewScrubber)

or have a look at this plugin:

https://github.com/bestpractical/rt-extension-permissivehtmlmail


-- 
Easter-eggs  Spécialiste GNU/Linux
44-46 rue de l'Ouest  -  75014 Paris  -  France -  Métro Gaité
Phone: +33 (0) 1 43 35 00 37-   Fax: +33 (0) 1 43 35 00 76
mailto:elac...@easter-eggs.com  -   http://www.easter-eggs.com


[rt-users] Displaying HTML in RT4?

2014-01-28 Thread Giuseppe Sollazzo

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,
I'm trying to understand if RT4 can display html e-mails. As far as I
can see, it has support for sending html out as multi-part e-mails, but
nothing obvious on the receiving side of things.

The only two things I find are
- - something called ScrubHTML, but that was just in RT3
- - Set($PreferRichText, true); - which parses some rich text and html,
like text decoration or font face, but not tables for example.

Is there any known way of doing this?

Thanks,
Giuseppe

- -- 


Giuseppe Sollazzo
Senior Systems Analyst
Computing Services
Information Services
St. George's, University Of London
Cranmer Terrace
London SW17 0RE

Email: gsoll...@sgul.ac.uk
Direct Dial: +44 20 8725 5160
Fax: +44 20 8725 3583
Twitter: http://twitter.com/sgulit
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJS59k/AAoJEAqigArPBfJXaUwH/1UCZjByLQ9CVrwMHKZg/YdV
C+R2t/Y/AWWfG9dYPl0F0uOO0egrnA/fLQu41xnj143YJqC4qV3+3K8rRpgj7g+u
UMSxoxUC74boF+MY8zdxl2TP6KcNaEU/EE9iGzgm/OM7rD4vF27EIIybnR9RWQRS
NGqp6gCOTV59soBRAY/NCyMM9fdjmyUySHap0Z/GYvxLkM+XG6SbKMNZq5wB6Elu
dj3uVv0hT+FWfhxnekDDobpM21C/N8fjWWWFLYAfXYUlBKnXWij52Xe5i+i1NfMw
uZOUu7UGWT/VvKXLnLTuoctJ6EyQRfHjxND3StULLYIyaHfqNBzYgAtO3ZMmSEg=
=fvuf
-END PGP SIGNATURE-



0xCF05F257.asc
Description: application/pgp-keys


Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

2014-01-28 Thread Jonah Hirsch
It seems to occur for any ticket. I tried it on our most innocuous queue and it 
still occurred. Removed all people from the ticket, no special things in the 
ticket, and it still causes its apache process to lock up the system.

Unfortunately I don't currently have the resources to set up a test RT system 
to see if it occurs.

I'm running Ubuntu 12.04.4, perl 5.14.2, Apache 2.2.22, and MySQL 
5.5.35-0ubuntu0.12.04.1-log on Ubuntu 12.04.4

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Monday, January 27, 2014 2:19 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Memory leak when merging tickets, RT 4.2.2

On Fri, 2014-01-24 at 17:43 +, Jonah Hirsch wrote:
> I just upgraded to RT 4.2.2 yesterday, and whenever a user merges a 
> ticket, the responsible apache processes maxes out memory usage on the 
> system and the system slows to a crawl until the OS kills the process, 
> since the system is out of memory.
>
> Is this a known issue? Anyone have any thoughts on what I can do to 
> try to solve this problem?

This is the first I've heard of it.  Does it occur for any ticket merge?
Can you replicate it in a clean RT 4.2.2?
 - Alex