[rt-users] Problem : A custom field edited via REST will be disabled
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
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
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
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()
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
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
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
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
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
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
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
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()
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
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
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
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
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
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()
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
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.