[rt-users] Problem : A custom field edited via REST will be disabled

2014-02-07 Thread Sylvain Auguy
Hi,

When I edit a custom field via REST, the associated
ObjectCustomFieldValue will, by default, appear as disabled in the
database.
Is there any reason for that ? How can I avoid it ?
I use RT 3.8.4.

Sylvain


Re: [rt-users] Forwarding an e-mail with an HTML alternative

2014-02-07 Thread Martin Drasar
On 6.2.2014 17:21, Kevin Falcone wrote:
 On Thu, Feb 06, 2014 at 01:07:26PM +0100, Martin Drasar wrote:
 4.2 does a much better job passing along multipart mails.
 You cannot easily force RT to send a custom alternative email,
 especially not in 4.0.

Thanks for your response. I am not necessarily looking for an easy way
to make RT do my bidding and upgrade is not an option right now. In a
way, I do not really need to use the template at all, incoming messages
are formated just as I want them to be.

I wanted to create a scrip that would just forward the mail to
requestors (that are set on ticket create via the REST interface). But I
have some problems with it.

This is my scrip:

*
package RT::Action::ForwardGatewayReport;

use strict;
use warnings;

use base qw(RT::Action::SendEmail);

use Email::Address;

sub Prepare {
my $self = shift;
# Set recipients to ticket requestors
$self-SetRecipients();
return 1;
}

sub Commit {
  my $self = shift;

  my $mail;

  # ???
  # What here?
  # ???

  my $rc = $self-SendMessage($mail);
  if ($rc  RT-Config-Get('RecordOutgoingEmail'))
  {
$self-RecordOutgoingMailTransaction($mail);
  }
  return $rc;
}
**

I have tried to recreate the $mail with transaction attachments read as
ContentAsMIME() but I have never managed to successfully extract the
original email.

The other thing I have in mind is to create a new mime object of type
multipart/alternative and insert those two text/plain and text/html
parts. But that seems to me a bit cumbersome, given that everything is
already there.

Other issue I am having is that using this script, the correspondence
gets recorded gazzilion times and not just once. Do you have any idea,
where the problem might be?

Thanks,
Martin


[rt-users] Error while trying rt-assets-import-csv

2014-02-07 Thread Joop

Hi All,

I installed a test instance of rt-4.2.2 (from source, on Centos-6.5, 
perl-5.10.1 x64) and installed the shiny new Assets extension and its 
import part but get the following error:
Insecure dependency in require while running with -T switch at 
/usr/share/perl5/Pod/Perldoc.pm line 1548

when I run rt-assets-import-csv.
Pardon my perl ignorance but how to fix this??

Thanks,

Joop



Re: [rt-users] RT 4.2 change scrip stage

2014-02-07 Thread Christian Loos
Am 05.02.2014 17:00, schrieb Kevin Falcone:
 I've filed
 http://issues.bestpractical.com/Ticket/Display.html?id=28873
 about the terrible Disabled UI, and it touches briefly on Deleted.
 We'll address this after we fix display of Disabled Scrips.

Can you please add me to the ticket so I get notified on any changes.

Thanks.

Chris


[rt-users] Odd behavior of queue name translation in RT::TIcket::LimitCustomFIeld()

2014-02-07 Thread Len Jaffe
We're on RT 4.0.17.

I have this code snippet in a test (Yay TDD):
 my $tickets = RT::Tickets-new(GetCurrentUser());
 my $queue ='foo'
 $tickets-LimitCustomField(CUSTOMFIELD = $internal_gid, OPERATOR = '=',
VALUE = i$generic_id, QUEUE = $queue );
 my $ticket = $tickets-Next;


The error from ticket-Next() is:

[Fri Feb  7 16:00:07 2014] [warning]: RT::Queue '{83}' doesn't exist,
parsed from '{83}.{Internal_GenericID}'

The queue in question is the queue with ID 83, and does exist. I just added
the ticket to it.

Is this a known bug in queue name handling, is it something I've done
wrong,
is there a known workaround?

Thanks,
Len.



-- 
lenja...@jaffesystems.com   614-404-4214@lenjaffe
Information Technology Smoke Jumper, Host of Columbus Code
Jamhttp://www.meetup.com/techlifecolumbus/
www.lenjaffe.com http://www.theycomewithcheese.com
Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent
Calendars: Perlish and otherwise.


Re: [rt-users] apache segfaults with 4.2

2014-02-07 Thread Marko Cupać
On Fri, 20 Dec 2013 10:30:49 -0500
Kevin Falcone falc...@bestpractical.com wrote:

Hi Kevin,
sorry for my late reply, I finally found the time to troubleshoot this.

 Try commenting out the SSL settings and see if Apache will start up
 with RT but without SSL.
Unfortunately I do not have the luxury of doing so. This server holds a
bunch of Active Directory integrated web services, I wouldn't want to
have passwords transported over plain http.

 Alternatively, this is almost certainly some sort of shared library
 conflict and you can work around it by running RT with fastcgi instead
 of mod_perl.
I switched to fastcgi, and I do not have any more segfaults in apache.

If someone is interested in investigation of possible shared library
conflict I would be glad to follow instruction.

Regards,
-- 
Marko Cupać


Re: [rt-users] Error while trying rt-assets-import-csv

2014-02-07 Thread Alex Vandiver
On Fri, 2014-02-07 at 14:16 +0100, Joop wrote:
 I installed a test instance of rt-4.2.2 (from source, on Centos-6.5, 
 perl-5.10.1 x64) and installed the shiny new Assets extension and its 
 import part but get the following error:
 Insecure dependency in require while running with -T switch at 
 /usr/share/perl5/Pod/Perldoc.pm line 1548
 when I run rt-assets-import-csv.
 Pardon my perl ignorance but how to fix this??

This is probably https://rt.perl.org/Public/Bug/Display.html?id=72550

Try upgrading Pod::Perldoc
 - Alex



[rt-users] Trying to get RT4.2.2 to use mysql and not sqllite3

2014-02-07 Thread john boris
I installed RT4.2.2 using apt-get from the repositories on Ubuntu 12.10
LTS. When I try to start apache I get a database error whic states

 [warning]: DBI
connect('dbname=/var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb;

I selected mysql when I did the install but the config files seem to
telling it to use sqlite3.
I have looked through the config files and I thought I had mysql selected.

Where do I change the config to tell RT to use mysql?

TIA
-- 
John J. Boris, Sr.
Online Services
www.onlinesvc.com


Re: [rt-users] RT doesn't quote previous conversation in reply

2014-02-07 Thread Kevin Falcone
On Thu, Feb 06, 2014 at 07:53:24PM +0200, Stefan Gofferje wrote:
  The original message is *only* quoted if you click on Reply in the
  transaction history, not Reply from the top of the page.
 
 THAT works, thanks! Is that always like this under any circumstances or
 is there a possibility that I inadvertently changed some other setting
 when I changed the timezone in the config file?

There is no setting to control this.

-kevin


pgpwx5cicQPa8.pgp
Description: PGP signature


Re: [rt-users] Trying to get RT4.2.2 to use mysql and not sqllite3

2014-02-07 Thread Kevin Falcone
On Fri, Feb 07, 2014 at 11:40:19AM -0500, john boris wrote:
I installed RT4.2.2 using apt-get from the repositories on Ubuntu 12.10 
 LTS. When I try to

I'm not aware of RT 4.2 packages on Ubuntu or Debian.  Ubuntu in fact
tends to run multiple versions of packages behind the Debian release.

start apache I get a database error whic states
[warning]: DBI 
 connect('dbname=/var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb;
I selected mysql when I did the install but the config files seem to 
 telling it to use
sqlite3.
I have looked through the config files and I thought I had mysql selected.
Where do I change the config to tell RT to use mysql?

Since you're using the debian packages, which offer you database
choices during setup, you should rerun their setup script with
dpkg-reconfigure request-tracker4 and also ensure that you've
installed the rt4-db-mysql package.

If you've in fact installed from source, then you should rerun
configure selecting mysql, not sqlite.  RT's default is MySQL so you
would have had to pass an explicit selection of sqlite.

-kevin


pgpaJciqO_1Le.pgp
Description: PGP signature


Re: [rt-users] Problem : A custom field edited via REST will be disabled

2014-02-07 Thread Kevin Falcone
On Fri, Feb 07, 2014 at 11:05:04AM +0100, Sylvain Auguy wrote:
When I edit a custom field via REST, the associated 
 ObjectCustomFieldValue will, by default,
appear as disabled in the database.
Is there any reason for that ? How can I avoid it ?
I use RT 3.8.4.

When you update the value of a custom field on a ticket, the old
ObjectCustomFieldValue is disabled and a new row with the current
value is inserted.

-kevin


pgpjEANdW1Gsf.pgp
Description: PGP signature


Re: [rt-users] Forwarding an e-mail with an HTML alternative

2014-02-07 Thread Kevin Falcone
On Fri, Feb 07, 2014 at 12:40:29PM +0100, Martin Drasar wrote:
 On 6.2.2014 17:21, Kevin Falcone wrote:
  On Thu, Feb 06, 2014 at 01:07:26PM +0100, Martin Drasar wrote:
  4.2 does a much better job passing along multipart mails.
  You cannot easily force RT to send a custom alternative email,
  especially not in 4.0.
 
 Thanks for your response. I am not necessarily looking for an easy way
 to make RT do my bidding and upgrade is not an option right now. In a
 way, I do not really need to use the template at all, incoming messages
 are formated just as I want them to be.

On Create Notify Requestors with template Corresopnd

which will relay your mail to the requestors during creation.
Your Scrip is honestly likely to cause all the problems you saw.

Or just set your requestors and then correspond on the ticket with
your content.

4.2 will do a better job of not mangling your mail.  Reading the
outgoing mail transaction though is almost guaranteed to fail.
Just use normal RT correspond actions.

-kevin


pgpdkNdrhiTGs.pgp
Description: PGP signature


Re: [rt-users] Odd behavior of queue name translation in RT::TIcket::LimitCustomFIeld()

2014-02-07 Thread Kevin Falcone
On Fri, Feb 07, 2014 at 11:10:52AM -0500, Len Jaffe wrote:
  my $tickets = RT::Tickets-new(GetCurrentUser());
  my $queue ='foo'
  $tickets-LimitCustomField(CUSTOMFIELD = $internal_gid, OPERATOR = '=',
 VALUE = i$generic_id, QUEUE = $queue );
  my $ticket = $tickets-Next;
 The error from ticket-Next() is:
 
 [Fri Feb  7 16:00:07 2014] [warning]: RT::Queue '{83}' doesn't exist,
 parsed from '{83}.{Internal_GenericID}'
 
 The queue in question is the queue with ID 83, and does exist. I just added
 the ticket to it.

In the future, please leave on the part of the warning message which
includes that it happened in lib/RT/Tickets.pm with a line number, it
saves time.

 Is this a known bug in queue name handling, is it something I've done
  wrong, is there a known workaround?

$Tickets-LimitCustomField is used infrequently (unused in core on
Tickets).
Is there a reason you're not using TicketSQL (what's visible in the
Query Builder when you build a query?)

$tickets-FromSQL(CF.{Foo} = 'i$generic_id');
possible with a And Queue = '$queue' in there or if you don't want
to limit on Queue, you can use CF.83.{Foo}.

The problem is that passing QUEUE to LimitCustomField is undocumented
and as a result poorly supported by the code that deciphers custom
field names.  However, without digging deeper, I don't know that
CustomFieldDecipher of LimitCustomField needs the bugfix.

-kevin


pgpFRwqtRUXX9.pgp
Description: PGP signature


Re: [rt-users] Trying to get RT4.2.2 to use mysql and not sqllite3

2014-02-07 Thread john boris
Kevin,
Thanks for the reply. I reran the script and selected mysql (which I did
originally) it had an error at the end and I had a choice to retry, abort,
retry (skip questions) so I said retry and it asked me the questions again
and I answered as before and the script ended without an error. I went into
Mysql with phpmyadmin and the database was created by when I go to the web
address I now get


   - Config file /etc/request-tracker4/RT_SiteConfig.pm is locked

I checked all of my windows and I don't have it opened anywhere.
I restarted the server just in case but I still get the message.




On Fri, Feb 7, 2014 at 11:49 AM, Kevin Falcone falc...@bestpractical.comwrote:

 On Fri, Feb 07, 2014 at 11:40:19AM -0500, john boris wrote:
 I installed RT4.2.2 using apt-get from the repositories on Ubuntu
 12.10 LTS. When I try to

 I'm not aware of RT 4.2 packages on Ubuntu or Debian.  Ubuntu in fact
 tends to run multiple versions of packages behind the Debian release.

 start apache I get a database error whic states
 [warning]: DBI
 connect('dbname=/var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb;
 I selected mysql when I did the install but the config files seem to
 telling it to use
 sqlite3.
 I have looked through the config files and I thought I had mysql
 selected.
 Where do I change the config to tell RT to use mysql?

 Since you're using the debian packages, which offer you database
 choices during setup, you should rerun their setup script with
 dpkg-reconfigure request-tracker4 and also ensure that you've
 installed the rt4-db-mysql package.

 If you've in fact installed from source, then you should rerun
 configure selecting mysql, not sqlite.  RT's default is MySQL so you
 would have had to pass an explicit selection of sqlite.

 -kevin




-- 
John J. Boris, Sr.
Online Services
www.onlinesvc.com


Re: [rt-users] segmentation fault

2014-02-07 Thread Alex Vandiver
On Wed, 2014-02-05 at 18:50 -0600, José Luis Gordillo Ruiz 
 My RT 4.2 instance is not working properly. Sometimes it gets errors
 in creating tickets or sending mails. Logs show segmentation faults of
 httpd. On of the cores I could get
 shows that the segmentation happens in malloc
 
 
 This RT is running in a virtual machine. At the beginning, it had 512
 MB of RAM and was very slow when several sessions were open. Then we
 increased the RAM to 1 GB. The speed is now good but this strange
 behavior started.

While segfaults are not the form I'd generally expect the failure to
take, this is likely still memory contention.  What do your monitoring
tools tell you about memory usage on the box?

If you're also running your database server on the same machine, I'd
expect 1G to definitely be insufficient.
 - Alex




Re: [rt-users] Forwarding an e-mail with an HTML alternative

2014-02-07 Thread Martin Drašar

Dne 7.2.2014 17:52, Kevin Falcone napsal(a):

Thanks for your response. I am not necessarily looking for an easy way
to make RT do my bidding and upgrade is not an option right now. In a
way, I do not really need to use the template at all, incoming messages
are formated just as I want them to be.


On Create Notify Requestors with template Corresopnd

which will relay your mail to the requestors during creation.
Your Scrip is honestly likely to cause all the problems you saw.

Or just set your requestors and then correspond on the ticket with
your content.


Correspond template is not working for me as I would like it to work - 
i.e. in the template I have RT-Attach-Message: Yes, but if I don't 
supply body in the text of the template (because I don't want to insert 
any other text, except the one I have received), no mail is sent.


Can I do something with it?

Another thing is a the RT-Ataach-Message mechanism. If I take a look at 
the sent message from within the RT I see two RT-Attachment headers. 
Does that mean that those two attachments are going to be sent 
separately and not inside multipart/alternative?



4.2 will do a better job of not mangling your mail.  Reading the
outgoing mail transaction though is almost guaranteed to fail.
Just use normal RT correspond actions.


By outgoing mail transaction, do you mean the Correspondence 
transaction? Because I have previously altered the Notify.pm scrip 
(albeit to much lesser extent) to add one special attachment to each 
outgoing e-mail and I had no problems with it at all...


Thanks,
Martin


Re: [rt-users] Forwarding an e-mail with an HTML alternative

2014-02-07 Thread Martin Drašar
Hmm... so I have just hacked the Template.pm _DowngradeFromHTML() to 
check for multipart/alternative in transaction and supply the text/plain 
part from it, instead of using the HTML::TreeBuilder and 
HTML::FormatText. Seems to work like a charm.


Now I wonder, when it's going to bite me :-)

Martin


Re: [rt-users] mod_fcgid: read data timeout leads to SIGKILL

2014-02-07 Thread Mathew Snyder
Unfortunately, the log seems to have been recreated and all of the
timestamps which would line up with the already-provided log entry are
gone. I'll have to keep an eye on this and provide it at a later date.

-Mathew

When you do things right, people won't be sure you've done anything at
all. - God; Futurama

We'll get along much better once you accept that you're wrong and neither
am I. - Me


On Wed, Feb 5, 2014 at 5:38 AM, Kevin Falcone falc...@bestpractical.comwrote:

 On Mon, Feb 03, 2014 at 11:22:16AM -1000, Mathew Snyder wrote:
 Looking for support on an issue that I haven't found online through
 searches.
 New instance of RT 4.2.2 on CentOS 6.5 with Apache 2.2.15-29 and FCGIÂ
 2.3.9-1.Â

 You really need to show your RT debug logs, the logs you're showing are
 what apache is getting back from RT (or failing to get back from RT).
 Since you're running 4.2.2, go to Admin - Tools - System Configuration
 and read the Logging summary box.

 40 seconds to display a ticket is much too slow and points to either a
 bad local modification, a misconfigured database or some other
 problem, but we can't comment without details.

 -kevin

 Everything runs fine for the most part, however, intermittently theÂ
 following log entries show up and I get an internal server error.Â
 
 [Fri Jan 31 22:48:36 2014] [warn] [client 192.168.236.64] mod_fcgid:
 readÂ
 data timeout in 40 seconds, referer:Â
 [1]http://rt.example.com/Ticket/Display.html?id=2Â
 [Fri Jan 31 22:48:36 2014] [error] [client 192.168.236.64] Premature
 end ofÂ
 script headers: rt-server.fcgi, referer:Â
 [2]http://rt.example.com/Ticket/Display.html?id=2Â
 FastCGI: manager (pid 8954): received signal TERMÂ
 FastCGI: manager (pid 8954): sending TERM to PIDs, 8960Â
 [Fri Jan 31 22:48:46 2014] [warn] mod_fcgid: process 8954 graceful
 killÂ
 fail, sending SIGKILLÂ
 FastCGI: server (pid 8960): safe exit after SIGTERMÂ

 -kevin



Re: [rt-users] Odd behavior of queue name translation in RT::TIcket::LimitCustomFIeld()

2014-02-07 Thread Len Jaffe
On Fri, Feb 7, 2014 at 12:06 PM, Kevin Falcone falc...@bestpractical.comwrote:

 On Fri, Feb 07, 2014 at 11:10:52AM -0500, Len Jaffe wrote:




 $tickets-FromSQL(CF.{Foo} = 'i$generic_id');
 possible with a And Queue = '$queue' in there or if you don't want
 to limit on Queue, you can use CF.83.{Foo}.


FromSQL() resolved my issue.
Thanks!




 The problem is that passing QUEUE to LimitCustomField is undocumented


QUEUE is documented here:
https://www.bestpractical.com/docs/rt/4.0/RT/Tickets.html#LimitCustomField


Len.


-- 
lenja...@jaffesystems.com   614-404-4214@lenjaffe
Information Technology Smoke Jumper, Host of Columbus Code
Jamhttp://www.meetup.com/techlifecolumbus/
www.lenjaffe.com http://www.theycomewithcheese.com
Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent
Calendars: Perlish and otherwise.


[rt-users] Can only one ticket be created even if mail marks to multiple queue

2014-02-07 Thread Ajay Kumar
Dear All,
It has been observed that our members send same mail to multiple queues
and RT generate multiple tickets.One ticket for one queue. Can we stop
multiple tickets for same mail. If yes,pls suggest the steps.

We are manual merging the tickets. Hoping for response pls.


Regards,
Ajay

.
Please don't print this email unless you really need to. This will preserve
trees on our planet.