Re: [rt-users] rt-remind script problem

2014-06-19 Thread Guadagnino Cristiano

Kevin Falcone ha scritto:

On Wed, Jun 18, 2014 at 10:32:52AM +, Guadagnino Cristiano wrote:


the script that I am running comes from here:
http://www.cs.kent.ac.uk/people/staff/tdb/rt3/rt-remind

You can find a reference to this script on Wikia too:
http://requesttracker.wikia.com/wiki/Rt-reminder



Have you considered asking the author about your problems?


No, not until now.

I was not sure if it was a user error or a program error, so I wrote to this 
list to seek other users of this script.






The message Recipient names must be specified does not come from the
script itself, I guess it is coming from sendmail.
Unfortunately a google search, while finding a few hits, did not turn up
to be enlightening.



This implies nothing is being passed to sendmail correctly.

Show a debug output, especially the part where it shows how it calls
sendmail and what it passes.

-kevin



I think I found out the problem. I am reporting it here just for documentation 
if someone has the same problem in the future.

This is an example of invoking rt-remind -A -d (i.e. with the debug flag 
activated):


== Would call '/usr/lib/sendmail -oi' with this input:
Content-Type: text/plain; charset=ISO-8859-15
From: RT Reminder d...@amended.itmailto:d...@amended.it
To: Cristiano Guadagnino 
guadagnino.cristi...@amended.itmailto:guadagnino.cristi...@amended.it
Subject: Outstanding RT tickets

This is a summary of all open, new, stalled or future tickets assigned to:

  Cristiano Guadagnino 
guadagnino.cristi...@amended.itmailto:guadagnino.cristi...@amended.it

   Id  Status  Pri  Created   Subject
50993  stalled  50  Thu 09-05-13  I: Quadrivio RMBS 2013 - Analisi storiche - 
Aggiornamento Aprile 2013

http://rtbkd.amended.bkd/





As you can see, it would call /usr/lib/sendmail -oi. I found out that it 
should be calling /usr/lib/sendmail -t -oi so that sendmail picks the address 
of the recipient from the message itself. Otherwise, sendmail expects to find 
the address of the recipient as a command-line argument.

The strange this is that it gets the command line from RT configuration (you 
can see it at line 136 of the script), and RT is sending emails corectly.
And even stranger is the fact that this script has worked for years.

However, I solved the problem amending the script to add -t to the command 
line. Since this is not part of the core product, I guess we can consider this 
solved.

Thank you!
Cris

-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] New line tag? (autofill addon in FireFox puts br tag, RT does not interpret it )

2014-06-19 Thread Katina Haytova

Hello,

The addon that I am using is called auto-fill forms, the icon is like a 
pencil..


Maybe I need to use some specific Java tag?

On 11/06/14 03:13, Alex Peters wrote:

What is the specific add-on?

To me this sounds like an issue with the add-on rather than with RT.  RT
just uses a standard text area element to my knowledge.


--
RT Training - Boston, September 9-10
http://bestpractical.com/training


[rt-users] Receiving Error in RT-Logs

2014-06-19 Thread Aaron McCarthy
Hi, 

For the past few days I have been messing around with SLA's. I managed to
get them working but ever since then (I think) I have been receiving an
error in RT-Logs.

The error message I am getting is:

 Too late to safely run transaction-batch scrips! This is typically caused
by using ticket objects at the top-level of a script which uses the RT API.
Be sure to explicitly undef such ticket objects, or put them inside of a
lexical scope. at /usr/share/request-tracker4/lib/RT/Ticket.pm line 3334
during global destruction.
(/usr/share/request-tracker4/lib/RT/Ticket.pm:3334)

I do not understand why I am seeing this error. Can any one help please?

Many thanks and regards,

Aaron




--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Receiving-Error-in-RT-Logs-tp57716.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


Re: [rt-users] help: using RT with a gmail acct

2014-06-19 Thread Mike Johnson
I have fetchmail sucking in emails from gmail, and pushing that to
rt-mailgate.

it's pretty easy to setup.

Install fetchmail, get it running as per it's instructions and config it
something like this

poll imap.gmail.com proto imap port 993:
username youracco...@gmail.com password yourpass ssl mda pathto/perl
pathtort
-mailgate --url urltort --queue yourqueue --action transaction type

I am pretty sure you have to log into the gmail account and turn on imap
for you to be able to use fetchmail in imap mode...

Hope that helps!
Mike.



On Tue, Jun 17, 2014 at 11:11 AM, Al Joslin allen.jos...@gmail.com wrote:

 Hi All,

 I've managed to get RT to send emails using a gmail account, but now I'm
 trying to get it to read emails.

 If understand this [email/mta/mua/etc] all correctly then I have to have
 my own mta (as described here:
 http://www.spencerstirling.com/computergeek/email.html) so that the mail
 will be delivered properly to RT

 RT will not go out and read a mailbox -- is this correct?

 thanks
 al;


 --
 RT Training - Boston, September 9-10
 http://bestpractical.com/training




-- 
Mike Johnson
Datatel Programmer/Analyst
Northern Ontario School of Medicine
955 Oliver Road
Thunder Bay, ON   P7B 5E1
Phone: (807) 766-7331
Email: mike.john...@nosm.ca
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

[rt-users] SLA Issue

2014-06-19 Thread Aaron McCarthy
Hello,

I have made SLA's using CustomField and I wrote a scrip that will set a
priority number and a due date depending on which level of SLA it is
assigned to.

When I try to do a Priority Escalate the Priority jumps from e.g. 50 - 1 or
99 - 50 etc. It wont escalate in order. I don't understand why.

Can anyone help please.

Regards,

Aaron



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/SLA-Issue-tp57718.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


Re: [rt-users] Receiving Error in RT-Logs

2014-06-19 Thread Kevin Falcone
On Thu, Jun 19, 2014 at 02:30:56AM -0700, Aaron McCarthy wrote:
 
  Too late to safely run transaction-batch scrips! This is typically caused
 by using ticket objects at the top-level of a script which uses the RT API.
 Be sure to explicitly undef such ticket objects, or put them inside of a
 lexical scope. at /usr/share/request-tracker4/lib/RT/Ticket.pm line 3334
 during global destruction.
 (/usr/share/request-tracker4/lib/RT/Ticket.pm:3334)
 
 I do not understand why I am seeing this error. Can any one help please?
 

As it indicates, this error is caused by something keeping a ticket
around too long.

We would need to know your actual RT version, as well as custom code
you've written.  You may also get more information if you enable
LogStackTraces at the warning level.

It's possible this is tied to your later question where you ask about
misbehaving code, but don't show the code.

-kevin


pgpm9_K9LBq_y.pgp
Description: PGP signature
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] adding custom field type, how to force single value

2014-06-19 Thread Kevin Falcone
On Wed, Jun 18, 2014 at 03:57:23PM -0400, Len Jaffe wrote:
 How do I associate my new custom field Type JSON_Encoded_Resource_Field with
 the Fill in one text area type. Is that a key value pair in the
 CustomField_Local override?

Please note, I wasn't suggesting that you use a custom type if you go
the only override display route.  You use the ShowComponentName
callback in Elements/ShowCustomFields to say For these CFs, use
ShowCustomField_JSON_Encoded_Resource_Field and then editing just
works as a normal text box.

Alternately, again, ensure your MaxValues is set properly for your
custom CF type.

-kevin


pgpoNmSRn8OHT.pgp
Description: PGP signature
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] ticket created from CLI script with wrong Due date; timezone issue?

2014-06-19 Thread Kevin Falcone
On Thu, Jun 19, 2014 at 11:25:52AM +1000, Alex Peters wrote:
 The code posted in my original message, minus the $ticket-Create call,
 generates debug output showing the problem independent of ticket creation.  In
 that message I've highlighted the  discrepancies in that debug output in red. 
 Your comments on that specific output would be greatly appreciated.
 
 I don't believe that the date/time configuration options are relevant, because
 I'm explicitly specifying 11am Wednesday in an RT::Date-Set call and 
 getting
 an epoch for 11am Tuesday.  My timezone is not offset from GMT by 24 hours.

Since RT::Date uses Time::ParseDate, I'm not sure that your syntax is
valid.

https://metacpan.org/pod/Time::ParseDate

Time::ParseDate is going to default to shenanigans when you feed it
bad data.

I'm not yet convinced of an actual RT::Date bug here, just bad input
to ParseDate and timezone confusion (remember whose timezone is
applied when you create an RT::Date with the System User).

use lib './lib';
use RT -init;

my $due_date = RT::Date-new($RT::SystemUser);
$due_date-Set(
 Value = '11am tomorrow',
 Format = 'unknown',
 Timezone = 'America/New_York',
);
print $due_date-ISO;

works fine for me, using days in the parser does not, but that does not
surprise me, Time::ParseDate is fragile, although doesn't try to use the
Julian calendar as often as other parsing modules.

Have you considered
https://metacpan.org/pod/RT::Extension::RepeatTicket

-kevin


pgpRxUaBTT9MK.pgp
Description: PGP signature
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] adding custom field type, how to force single value

2014-06-19 Thread Len Jaffe
On Thu, Jun 19, 2014 at 12:19 PM, Kevin Falcone falc...@bestpractical.com
wrote:

 On Wed, Jun 18, 2014 at 03:57:23PM -0400, Len Jaffe wrote:
  How do I associate my new custom field Type
 JSON_Encoded_Resource_Field with
  the Fill in one text area type. Is that a key value pair in the
  CustomField_Local override?

 Please note, I wasn't suggesting that you use a custom type if you go
 the only override display route.  You use the ShowComponentName
 callback in Elements/ShowCustomFields to say For these CFs, use
 ShowCustomField_JSON_Encoded_Resource_Field and then editing just
 works as a normal text box.


OK. BUT.. I think at some point I got an erro fo rnot having an Edit file
to go along with Show in the /Elements dir.
I'll try it out again later today.






 Alternately, again, ensure your MaxValues is set properly for your
 custom CF type.


Can I do that in the CustomField_Local file or do I have to specifically
manipulate the database?


 Len.


 -kevin

 --
 RT Training - Boston, September 9-10
 http://bestpractical.com/training




-- 
lenja...@jaffesystems.com   614-404-4214@lenjaffe
Information Technology Smoke Jumper, Host of Columbus Code Jam
http://www.meetup.com/techlifecolumbus/
www.lenjaffe.com http://www.theycomewithcheese.com
Advent Planet http://www.lenjaffe.com/AdventPlanet/ - An Aggregation of
Online Advent Calendars.
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Receiving Error in RT-Logs

2014-06-19 Thread Aaron McCarthy
Since then I have resolved the issue of this error in the RT-logs. It turns 
out. It was one of my templates acting up. I was using $ticketObj instead of 
$ticket.

I am still receiving a problem with regards to escalating the priority though.

-Aaron




As it indicates, this error is caused by something keeping a ticket
around too long.

We would need to know your actual RT version, as well as custom code
you've written.  You may also get more information if you enable
LogStackTraces at the warning level.

It's possible this is tied to your later question where you ask about
misbehaving code, but don't show the code.

-kevin



This email and any files transmitted with it are confidential and may be 
privileged and are intended solely for the use of the individual or entity to 
whom they are addressed. If you are not an addressee, any unauthorised direct 
or indirect dissemination, distribution, publication or copying of this message 
and any attachments is strictly prohibited. If you have received this email in 
error please notify the sender immediately, and delete this email from your 
system. This email has been swept for viruses, but it is the responsibility of 
the recipient to ensure that the onward transmission, opening or use of this 
message and any attachments will not adversely affect its system or data.

Please carry out virus and other checks as you consider appropriate. No 
responsibility is accepted by SouthWestern in this regard.

SouthWestern Business Process Services Ltd.

Registered in Ireland, Company Number 377757

Registered Office: Unit B, West Cork Technology Park, Clonakilty, Co. Cork, 
Ireland

Directors: N. O’Leary, U. Kenny, J. Costello, P. Morrissey, K. Calnan, J. 
Walsh, T. Cowhig and D. O'Donohoe.

-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] rt-remind script problem

2014-06-19 Thread Kevin Falcone
On Thu, Jun 19, 2014 at 07:46:56AM +, Guadagnino Cristiano wrote:
 
 As you can see, it would call /usr/lib/sendmail -oi. I found out that it
 should be calling /usr/lib/sendmail -t -oi so that sendmail picks the 
 address
 of the recipient from the message itself. Otherwise, sendmail expects to find
 the address of the recipient as a command-line argument.
 
 The strange this is that it gets the command line from RT configuration (you
 can see it at line 136 of the script), and RT is sending emails corectly.
 And even stranger is the fact that this script has worked for years.

In RT we automatically add/remove the -t as needed.  If you use
sendmailpipe (the default) we add on -t, if you use sendmail, we
remove the -t.  Although we documented removing the -t when changing
your MailCommand, users did not, so it was seen as better to just do
it automatically as needed.  This change landed in 4.2.0.

You should contact the author so their code can be updated to be 4.2
compatible.

-kevin


pgp8gPzRxSxJE.pgp
Description: PGP signature
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

[rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-19 Thread Lists

Hi,

As I have posted recently, I am working on upgrading our current 
production RT 3.8.1 to RT 4.2.5


I have a working copy of RT 3.8.1 on my test server including a copy of 
our current production database which is over 18 gig of old data.  I 
have imported this database into RT 4 and when I run make 
upgrade-database against the RT4 database, it runs a while and then dies 
with a message that the script was killed.


What I would like to be able to do before our real production upgrade 
is to wipeout everything from a given date back, including 
objects/attachments or anything associated with tickets older than 3 
years.  Our current production RT3 database, in all it's glory will be 
archived for posterity.  I was not the original admin of our RT system, 
so I am still on the learning curve and not completely familiar with all 
of the database tables and how they are linked.


Will RT:Shredder do this or do I need to use a custom mysql query to 
catch everything?


Thanks,

Dave




--
RT Training - Boston, September 9-10
http://bestpractical.com/training


Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-19 Thread Darin Perusich
http://requesttracker.wikia.com/wiki/Shredder
--
Later,
Darin


On Thu, Jun 19, 2014 at 12:56 PM, Lists li...@lolling.org wrote:
 Hi,

 As I have posted recently, I am working on upgrading our current production
 RT 3.8.1 to RT 4.2.5

 I have a working copy of RT 3.8.1 on my test server including a copy of our
 current production database which is over 18 gig of old data.  I have
 imported this database into RT 4 and when I run make upgrade-database
 against the RT4 database, it runs a while and then dies with a message that
 the script was killed.

 What I would like to be able to do before our real production upgrade is
 to wipeout everything from a given date back, including objects/attachments
 or anything associated with tickets older than 3 years.  Our current
 production RT3 database, in all it's glory will be archived for posterity.
 I was not the original admin of our RT system, so I am still on the learning
 curve and not completely familiar with all of the database tables and how
 they are linked.

 Will RT:Shredder do this or do I need to use a custom mysql query to catch
 everything?

 Thanks,

 Dave




 --
 RT Training - Boston, September 9-10
 http://bestpractical.com/training
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-19 Thread Alex Vandiver
On 06/19/2014 12:56 PM, Lists wrote:
 I have a working copy of RT 3.8.1 on my test server including a copy of
 our current production database which is over 18 gig of old data.  I
 have imported this database into RT 4 and when I run make
 upgrade-database against the RT4 database, it runs a while and then dies
 with a message that the script was killed.

It would be extremely helpful to see the output of the failed upgrade.

 What I would like to be able to do before our real production upgrade
 is to wipeout everything from a given date back, including
 objects/attachments or anything associated with tickets older than 3
 years.  Our current production RT3 database, in all it's glory will be
 archived for posterity.  I was not the original admin of our RT system,
 so I am still on the learning curve and not completely familiar with all
 of the database tables and how they are linked.
 
 Will RT:Shredder do this or do I need to use a custom mysql query to
 catch everything?

Shredder is the solution to removing data while preserving integrity,
but I would strongly advise instead determining and addressing what your
actual problem is.
 - Alex

-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


[rt-users] non-admin user editing custom field values

2014-06-19 Thread Milt Epstein
Greetings.

I'm using RT 4.0.2.  I set up some custom fields specific to a queue.
They are each of the type Select one value, and for each of them I
defined a few values.

Can the users of this queue (who are not general RT admins) modify
these custom fields' values?  If so, how?

We have things set up where basically for each queue there's a group
that has access to it.  On the queue's Group Rights page, I gave this
group View custom field values (SeeCustomField) under the General
rights tab, and Modify custom field values (ModifyCustomField)
under the Rights for Staff tab.  Should that allow these users
(i.e., members of this group) to modify the custom fields' values?
One of the users tried, but couldn't see a way to do it.  Do they need
some other access?

On a custom field's page, I see that there is also a Group Rights
link/page, with similar permissions as the above two -- View custom
fields (SeeCustomField) under the General rights tab, and Add,
modify and delete custom field values for objects (ModifyCustomField)
under the Rights for Staff tab.  How do these permissions differ
from the above two?  Are they needed in addition to or instead of
them?  Should they allow these users to modify these values?

Thanks.

Milt Epstein
Applications Developer
Graduate School of Library and Information Science (GSLIS)
University of Illinois at Urbana-Champaign (UIUC)
mepst...@illinois.edu
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training