Re: [rt-users] MySQL issue - Windows vs. Linux - Table name case seems to matter

2013-08-14 Thread Maciej Dobrzanski
Stephen,

MySQL does not maintain internal dictionary where it could keep the list of
tables (but InnoDB does for its own purpose!). Instead, MySQL relies on the
information from the underlying file system. Since Windows does not care
about case of file names, 'users.frm', 'Users.frm' and 'UsErS.frm' are all
the same file, in MySQL 'users', 'Users' and 'USERS' will all be the same
table. On the other hand, Linux has case sensitive file names, so
'users.frm' and 'Users.frm' are two different files. In this case 'users'
and 'Users' also become two different tables.

Your problem is easy to fix, but the solution will depend on how the MySQL
server on Windows was configured and how the tables were created both in
MySQL and on disk. Typically either performing dump  restore or setting
lower_case_table_names=1 option (or both) on Linux is enough, however in
certain circumstances it may not be.

Please refer to this page
http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html as
it will most likely contain the answers you need.

Maciek



[rt-users] Modify CF dropdown list from external DB based off of another CFs value

2013-08-14 Thread scott.dalzell
I have 2 ticket CFs (Version_No and Product)

i currently have a perl script to update the Version_No CF drop down list
from an external database with a manually set Where value set in the code.
(This all works fine for controlling the drop down list values to show only
the version numbers for the manually set product)

i would now like to modify the code to allow the drop down list to be
updated with values which contain the same catagory as the value set in the
Product CF, similar to using the Categories are based on Field when you
create your own list

To do this i have added the following line

my $dbwherevalue = $self-TicketObj-FirstCustomFieldValue('Product');

but i also get the following error

[error]: Can't locate object method TicketObj via package
RT::CustomFieldValues::Version_No at
/opt/rt4/sbin/../lib/RT/CustomFieldValues/Version_No.pm line 60

would someone be able to advice me what to do to resolve this error

below is my code

---CODE START---
##
##Prep
##

package RT::CustomFieldValues::Version_No;

use strict;
use warnings;
use DBI;
use DBD::Mysql;
use base qw(RT::CustomFieldValues::External);

##
##List Description
##

sub SourceDescription {
return 'Version Numbers';
}

##
##VARIABLES
##

sub ExternalValues {
my $self = shift;

# External Database details

my $dbhost = [HostName];
my $dbtype = [DatabaseType];
my $dbname = [DatabaseName]; 
my $dbtable=customfieldvalue;
my $dbcolumn=Name;

my $dbwherecolumn=Category;
#my $dbwherevalue='Testing1234';
 my $dbwherevalue =
$self-TicketObj-FirstCustomFieldValue('Product');

my $dbuser = [UserName]; 
my $dbpass = [Password];

my $i = 0;
my @res;
my $Hostname;

##
##Connect to Database
##
#Database on remote server
my $dbh = DBI-connect(DBI:$dbtype:$dbname;host=$dbhost, $dbuser,
$dbpass,
{ RaiseError = 1 }
   );

##
##Run Search of DB for values you wish in CF List
##

my $req = SELECT distinct $dbcolumn FROM $dbtable where
$dbwherecolumn=$dbwherevalue;
my $hreq = $dbh-prepare($req);
$hreq-execute();;
$hreq-bind_columns(\$Hostname);
while ($hreq-fetch()){
push @res, {
name= $Hostname,
description = $Hostname,
sortorder   = $i++,
};
}
return \@res;
}

RT::Base-_ImportOverlays();

1;

---CODE END-

thank you in advanced

Scott



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Modify-CF-dropdown-list-from-external-DB-based-off-of-another-CFs-value-tp55012.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


Re: [rt-users] Modify CF dropdown list from external DB based off of another CFs value

2013-08-14 Thread Joe Harris
I had a similar need.  But instead of connecting to an external database
from within RT, I put together 2 scripts to check for content change and
dump and load my custom fields in cron.  In my case, I was pulling time
sheet codes which are:
client_project and task_code.  Each client_project has specific task_codes
so task_codes is dependent on client_project.  Mine is probably way more
complicated than you need and could be done easier in perl.  I'm a bash man
at heart so here is my method.  They could be run from one script as long
as the server has access to get to both databases.  Since custom fields are
added to transactions as the actual field values (and not relational by
id's) this was the best way foe me to get this done.  During the day if the
finance department adds or removes codes, within an hour the RT system is
updated.  Also in my case, client_project and task_code are each
concatenated from 4 fields in my original search (fields 1 and 2 make up
client_project and fields 3 and 4 make up task_code). Hope this helps in
some way and apologies for the long message...

The first script is run on the external server and creates a load file.
This script is run every hour between 8am and 5pm from cron.

#!/bin/bash
NEWFILE=/tmp/codes.txt
OLDFILE=/tmp/codes.last
/bin/mv $NEWFILE $OLDFILE
/usr/bin/psql -A -t -c select field1,field2 from table where criteria like
'your_criteria' -U postgres_user databasename $NEWFILE
if /usr/bin/diff $NEWFILE $OLDFILE /dev/null ; then
echo NoChanges /tmp/codes.status
else
echo Changes /tmp/codes.status
fi

Then on another server, I look at the codes.status file and check for
changes.  If there are, I pull over the file and dump and load the
customfieldvalues table where the customfield is in my case 1 and 2.  This
script is run 5 minutes after the other one.

#!/bin/bash
HOME=/path/to/scripts
STATUSFILE=/tmp/codes.status
LOADFILE=/tmp/codes.txt
LASTFILE=/tmp/codes.txt
LOGFILE=$HOME/codes.log
PGSERVER=RT_PGSERVERNAME_REDACTED
PGUSER=RT_USER_REDACTED
PGDB=RT_DBNAME_REDACTED
TODAY=`date +%Y-%m-%d-%H:%M:%S`
echo Starting script at $TODAY
# Start logging
exec  (tee $LOGFILE)
exec 21

#Fetch status file
scp root@EXT_SERVERNAME_REDACTED:$STATUSFILE /tmp/
STATUS=`cat $STATUSFILE`
echo $STATUS  $LOGFILE
if [ $STATUS == Changes ] ; then
echo Making Changes $LOGFILE

# Fetch update file
scp root@EXT_SERVERNAME_REDACTED:$LOADFILE /tmp/

# Clean up previous sql load files and remove the old custom fields
rm -f $HOME/client_project.*
rm -f $HOME/task_code.*
rm -f $HOME/sequence.tmp
mv $HOME/client_project_backup $HOME/client_project_backup-$TODAY
psql -A -t -c select * from customfieldvalues where customfield='1' -h
$PGSERVER -U $PGUSER $PGDB $HOME/client_project_backup
psql -A -t -c select * from customfieldvalues where customfield='2' -h
$PGSERVER -U $PGUSER $PGDB $HOME/task_code_backup
psql -A -c delete from customfieldvalues where customfield='1' -h
$PGSERVER -U $PGUSER $PGDB
psql -A -c delete from customfieldvalues where customfield='2' -h
$PGSERVER -U $PGUSER $PGDB
# Add a placeholder to notify users that update is taking place
psql -A -c insert into customfieldvalues
(customfield,name,creator,created) values ('1','Tasks are being updated.
Refresh in 2-5 minutes','22',now()) -h $PGSERVER -U $PGUSER $PGDB

# Start numbering
echo 5 $HOME/sequence.tmp

# Parse through load file and capture variables to populate Client/Project
field
OIFS=$IFS
IFS='
'
for m in `cat $LOADFILE`
do
CLIENT=`echo $m|cut -d| -f1`
PROJECT=`echo $m|cut -d| -f2`
CLIENTPROJECT=${CLIENT}[${PROJECT}]
echo $CLIENTPROJECT $HOME/client_project.tmp
done

# Get Unique Client Project Codes to load to database
cat $HOME/client_project.tmp |sort -u  $HOME/client_project.txt
OIFS=$IFS
IFS='
'
for c in `cat $HOME/client_project.txt`
do
NAME=`echo $c |cut -d| -f1`
# Send load file info to SQL file for troubleshooting, then update the
database with the new Client Project Values
echo psql -A -c \insert into customfieldvalues
(customfield,name,creator,created) values ('1','$c','22',now())\ -h
$PGSERVER -U $PGUSER $PGDB $HOME/client_project.sql
psql -A -c insert into customfieldvalues
(customfield,name,creator,created) values ('1','$c','22',now()) -h
$PGSERVER -U $PGUSER $PGDB

#Increment sequence file for sorting in the Web GUI
sequence=`tail -n1 $HOME/sequence.tmp`
SEQUENCE=`expr $sequence + 5`
CLEANNAME=`echo $NAME |sed -e 's/\[/\|/g; s/\]//g'`

# Using the formatted Client/Project codes, loop through the loadfile and
capture Task codes for each Client/Project code
OIFS=$IFS
IFS='
'
for task in `cat $LOADFILE|grep $CLEANNAME`
do
TASK=`echo $task|cut -d| -f3`
CODE=`echo $task|cut -d| -f4`
CLIENT=`echo $task|cut -d| -f1`
PROJECT=`echo $task|cut -d| -f2`
CLIENTPROJECT=${CLIENT}[${PROJECT}]
TASKCODE=${TASK}[${CODE}]
echo psql -A -c \insert into customfieldvalues
(customfield,name,creator,created,category,sortorder) values
('2','$TASKCODE','22',now(),'$CLIENTPROJECT','$SEQUENCE')\ -h $PGSERVER -U
$PGUSER $PGDB 

Re: [rt-users] MySQL issue - Windows vs. Linux - Table name

2013-08-14 Thread Cena, Stephen (ext. 300)
Maciek - I figured it was more a MySQL issue than an RT one. I manually
went in  changed each table to the correct one (users to Users) and
that appeared to work. However, this won't fix my problem if I have to
move several databases over (we have a lot of MySQL dependant apps
here). Thank you for the link. I'll take a look at it today  see if it
will help. I'm just glad to know it's a MySQL issue and not an RT one!

Steve


Re: [rt-users] RT-at-a-Glance Saved Searches not showing RT System searches

2013-08-14 Thread Kevin Falcone
Joe - it helps if you trim the rest of the digest when replying.

On Tue, Aug 13, 2013 at 12:43:08PM -0400, Joe Kirby wrote:

 I would like to know how to make RT System Searches show when the Saved 
 Searches is added to
 RT-at-a-Glance.

 This is a great feature for My Closed Tickets type reports that are 
 really not needed on the
 page as its own.

 At this time it seems like only SuperUser gets these.

 Is there a setting that would allow this?

 Thanks in advance
 
Usually when I do not hear back on a topic it means that it is either not 
 clear what I am
asking for or it is a stupid question.
I have looked back through the wiki again with no luck on how to have RT 
 System Searches
available to the delivered Saved Search.
The reports saved as RT System Searches are available to be placed on the 
 RT-at-a-Glance but
do not show up in the Saved Search option.
I am trying to avoid having to generate many copies of a system wide 
 report so it shows up in
folks Saved Search collection.
At the risk of being an annoyance I am reporting
Thanks in advance

RT System Searches don't automatically show up for all users unless
their name is in a specific format (compare with the system default
searches we ship).  I consider this an oversight, and it'll probably
be fixed in a future release.  At this time, your best solution is
finding the widest group you can and assigning the search to that
group.

-kevin


pgpUo4_6ZF9FJ.pgp
Description: PGP signature


Re: [rt-users] sendmailpipe returns EX_TEMPFAIL

2013-08-14 Thread Kevin Falcone
On Tue, Aug 13, 2013 at 10:55:57AM +0200, Nathan Cutler wrote:
  Does anyone have any other ideas for debugging this issue? Especially
  I am interested in how I could confirm or deny that it's related to
  mod_perl cohabitation -- i.e. two different Perl applications in a
  single mod_perl host?
 
 I noticed that when I don't have PerlOptions +Parent in the apache
 config, the Perl library search order on the System Configuration page
 is different than when I do. Here's what it looks like _without_
 PerlOptions +Parent (omitting the line numbers which do not
 copy-paste):
 
 Perl library search order
 
 /usr/share/request-tracker/local/lib
 /usr/share/request-tracker/local/plugins/RT-Extension-MergeUsers/lib
 /usr/lib/perl5/vendor_perl/5.10.0
 /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi
 /srv/www/perl-lib
 /srv/www/vhosts/pdb/
 /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi
 /usr/lib/perl5/site_perl/5.10.0
 /usr/lib/perl5/vendor_perl
 /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi
 /usr/lib/perl5/5.10.0
 .
 /srv/www
 
 Notice lines 5 and 6 which obviously come from the other mod_perl application.
 
 Now, here's what it says _with_ PerlOptions +Parent:
 
 Perl library search order
 
 /usr/share/request-tracker/local/lib
 /usr/share/request-tracker/local/plugins/RT-Extension-MergeUsers/lib
 /usr/lib/perl5/vendor_perl/5.10.0
 /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi
 /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi
 /usr/lib/perl5/site_perl/5.10.0
 /usr/lib/perl5/vendor_perl
 /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi
 /usr/lib/perl5/5.10.0
 .
 /srv/www
 
 So maybe the problem is solved? I did have PerlOptions +Parent in the
 apache configuration before, but maybe not correctly? I checked the
 other application's vhosts file and it _does_ have PerlOptions
 +Parent.

While PerlOptions +Parent is important if you need to run two mod_perl
apps, you should keep your log in place, and possibly dig up one of
the shims from the mailing list archives that has been used to debug
this.

In the past, it was bugs in mod_perl and the handler type, but it's
nearly impossible to debug from the standard RT debug and mail logs.

-kevin


pgpyQVSUZUDNE.pgp
Description: PGP signature


Re: [rt-users] Re-send a previously attached attachment?

2013-08-14 Thread Kevin Falcone
On Tue, Aug 13, 2013 at 09:49:54PM +, Beachey, Kendric wrote:
 
-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Boli
Sent: Tuesday, August 13, 2013 3:36 PM
To: RT users
Subject: [rt-users] Re-send a previously attached attachment?

Hi All,

Apologies if I have missed something obvious.

How can I re-send an attachment that has previously been attached to a ticket 
without downloading it and re-attaching it.

For example, if a new requestor or CC is added to a ticket, and I want to get 
them up to date quickly by referring to previously discussed/attached 
information.

Comments/Suggestions welcomed

Regards,
 
 Point them to the web view of the ticket?  The attachment should be there in 
 the ticket history, so they can download/view it at their leisure.
 
 (assuming you don't have a security policy that would prevent this)

The alternate (attaching a previously attached attachment to a new
reply) is something we've explored in a few branches with clients, but
nothing we've written has stuck or been right for mainstream release.

-kevin


pgpVxdg53TJnN.pgp
Description: PGP signature


Re: [rt-users] sendmailpipe returns EX_TEMPFAIL

2013-08-14 Thread Thomas Sibley
On 08/14/2013 07:35 AM, Kevin Falcone wrote:
 So maybe the problem is solved? I did have PerlOptions +Parent in the
 apache configuration before, but maybe not correctly? I checked the
 other application's vhosts file and it _does_ have PerlOptions
 +Parent.
 
 While PerlOptions +Parent is important if you need to run two mod_perl
 apps, you should keep your log in place, and possibly dig up one of
 the shims from the mailing list archives that has been used to debug
 this.
 
 In the past, it was bugs in mod_perl and the handler type, but it's
 nearly impossible to debug from the standard RT debug and mail logs.

Adding on to what Kevin said...

You could also just save yourself some time and switch to a different
deployment option for RT.  Running it under mod_fastcgi or mod_fcgid is
simple and would avoid any mod_perl bugs with +Parent.  Why fight with
mod_perl?


[rt-users] Groups in LDAP

2013-08-14 Thread Donny Brooks
I have successfully setup RT4.0.17 on a CentOS 6.4 machine with 
RT::Authen::ExternalAuth to authenticate against our OpenLDAP. My question is, 
can I have certain groups in LDAP that are automatically privileged in RT? Like 
setup a helpdesk group and everyone in there are automatically set with the 
proper abilities.
-- 

Donny B.


[rt-users] RT4 and GIT; RT4 and Eclipse

2013-08-14 Thread Lisa Tomalty

1) Re: GIT - RT4 integration:
---Does anyone know of a way to tie a commit (in GIT) to a ticket in RT4, by 
putting an RT ticket # in the commit (and, ideally, back to the code)?

2) Does anyone know of a way to connect Eclipse and RT4 (mylin used to do this 
with an older version of RT)?

Thanks!
Lisa :)


Lisa Tomalty
Information Systems  Technology/Arts Computing Office

MC 2052/PAS 2023
University of Waterloo
Waterloo, Ontario, Canada
MC2025/PAS1083
(519) 888-4567 X35873
ltoma...@uwaterloo.camailto:ltoma...@uwaterloo.ca



Re: [rt-users] RT4 and GIT; RT4 and Eclipse

2013-08-14 Thread Jok Thuau


1) Re: GIT - RT4 integration:
---Does anyone know of a way to tie a “commit” (in GIT) to a ticket in RT4, by 
putting an RT ticket # in the commit (and, ideally, back to the code)?

Git has hooks where you can call specific scripts at different stages in the 
commit process. You should be able to use a post-commit hook to poke at RT 
and do what you need.


2) Does anyone know of a way to connect Eclipse and RT4 (mylin used to do this 
with an older version of RT)?


Not familiar with either of those, so I can't be of much help here.

University of Waterloo
Waterloo, Ontario, Canada

Go Warriors!

Thanks,
Jok


Re: [rt-users] Groups in LDAP

2013-08-14 Thread Jok Thuau
There is an extension that will allow you to import groups from LDAP into
RT. The extension, by default, just loads users, then groups. My patch
(which is in the queue for that extension -- see below), adds a filter to
the config to automatically privilege those users that match a second
search.

You can find the patch here:
https://rt.cpan.org/Public/Bug/Display.html?id=76926

It is far from the most elegant way of doing this, but It Works For Me()

Thanks,
Jok
-- 
| Joachim Thuau | IT Systems Engineer - Linux / SpaceX |





On 8/14/13 8:42 AM, Donny Brooks dbro...@mdah.state.ms.us wrote:

I have successfully setup RT4.0.17 on a CentOS 6.4 machine with
RT::Authen::ExternalAuth to authenticate against our OpenLDAP. My
question is, can I have certain groups in LDAP that are automatically
privileged in RT? Like setup a helpdesk group and everyone in there are
automatically set with the proper abilities.
-- 

Donny B.



Re: [rt-users] rt-users Digest, Vol 113, Issue 20

2013-08-14 Thread Joe Kirby
 psql -A -c delete from customfieldvalues where customfield='2' -h
 $PGSERVER -U $PGUSER $PGDB
 # Add a placeholder to notify users that update is taking place
 psql -A -c insert into customfieldvalues
 (customfield,name,creator,created) values ('1','Tasks are being updated.
 Refresh in 2-5 minutes','22',now()) -h $PGSERVER -U $PGUSER $PGDB
 
 # Start numbering
 echo 5 $HOME/sequence.tmp
 
 # Parse through load file and capture variables to populate Client/Project
 field
 OIFS=$IFS
 IFS='
 '
 for m in `cat $LOADFILE`
 do
 CLIENT=`echo $m|cut -d| -f1`
 PROJECT=`echo $m|cut -d| -f2`
 CLIENTPROJECT=${CLIENT}[${PROJECT}]
 echo $CLIENTPROJECT $HOME/client_project.tmp
 done
 
 # Get Unique Client Project Codes to load to database
 cat $HOME/client_project.tmp |sort -u  $HOME/client_project.txt
 OIFS=$IFS
 IFS='
 '
 for c in `cat $HOME/client_project.txt`
 do
 NAME=`echo $c |cut -d| -f1`
 # Send load file info to SQL file for troubleshooting, then update the
 database with the new Client Project Values
 echo psql -A -c \insert into customfieldvalues
 (customfield,name,creator,created) values ('1','$c','22',now())\ -h
 $PGSERVER -U $PGUSER $PGDB $HOME/client_project.sql
 psql -A -c insert into customfieldvalues
 (customfield,name,creator,created) values ('1','$c','22',now()) -h
 $PGSERVER -U $PGUSER $PGDB
 
 #Increment sequence file for sorting in the Web GUI
 sequence=`tail -n1 $HOME/sequence.tmp`
 SEQUENCE=`expr $sequence + 5`
 CLEANNAME=`echo $NAME |sed -e 's/\[/\|/g; s/\]//g'`
 
 # Using the formatted Client/Project codes, loop through the loadfile and
 capture Task codes for each Client/Project code
 OIFS=$IFS
 IFS='
 '
 for task in `cat $LOADFILE|grep $CLEANNAME`
 do
 TASK=`echo $task|cut -d| -f3`
 CODE=`echo $task|cut -d| -f4`
 CLIENT=`echo $task|cut -d| -f1`
 PROJECT=`echo $task|cut -d| -f2`
 CLIENTPROJECT=${CLIENT}[${PROJECT}]
 TASKCODE=${TASK}[${CODE}]
 echo psql -A -c \insert into customfieldvalues
 (customfield,name,creator,created,category,sortorder) values
 ('2','$TASKCODE','22',now(),'$CLIENTPROJECT','$SEQUENCE')\ -h $PGSERVER -U
 $PGUSER $PGDB $HOME/task_code.sql
 psql -A -c insert into customfieldvalues
 (customfield,name,creator,created,category,sortorder) values
 ('2','$TASKCODE','22',now(),'$CLIENTPROJECT','$SEQUENCE') -h $PGSERVER -U
 $PGUSER $PGDB
 echo $SEQUENCE $HOME/sequence.tmp
 done
 done
 psql -A -c delete from customfieldvalues where name='Tasks are being
 updated. Refresh in 2-5 minutes' -h $PGSERVER -U $PGUSER $PGDB
 echo Complete $LOGFILE
 else
 echo No Changes$LOGFILE
 fi
 -- next part --
 An HTML attachment was scrubbed...
 URL: 
 http://lists.bestpractical.com/pipermail/rt-users/attachments/20130814/75815045/attachment-0001.html
 
 --
 
 Message: 2
 Date: Wed, 14 Aug 2013 08:19:38 -0400
 From: Cena, Stephen \(ext. 300\) s...@qvii.com
 To: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] MySQL issue - Windows vs. Linux - Table name
 Message-ID:
   4dd6ab329450d847913ea76d7f3c6b8312f7f...@valkyrie.ogp.qvii.com
 Content-Type: text/plain; charset=us-ascii
 
 Maciek - I figured it was more a MySQL issue than an RT one. I manually
 went in  changed each table to the correct one (users to Users) and
 that appeared to work. However, this won't fix my problem if I have to
 move several databases over (we have a lot of MySQL dependant apps
 here). Thank you for the link. I'll take a look at it today  see if it
 will help. I'm just glad to know it's a MySQL issue and not an RT one!
 
 Steve
 
 
 --
 
 Message: 3
 Date: Wed, 14 Aug 2013 10:33:03 -0400
 From: Kevin Falcone falc...@bestpractical.com
 To: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] RT-at-a-Glance Saved Searches not showing RT
   System searches
 Message-ID: 20130814143303.gi2...@jibsheet.com
 Content-Type: text/plain; charset=us-ascii
 
 Joe - it helps if you trim the rest of the digest when replying.
 
 On Tue, Aug 13, 2013 at 12:43:08PM -0400, Joe Kirby wrote:
 
I would like to know how to make RT System Searches show when the Saved 
 Searches is added to
RT-at-a-Glance.
 
This is a great feature for My Closed Tickets type reports that are 
 really not needed on the
page as its own.
 
At this time it seems like only SuperUser gets these.
 
Is there a setting that would allow this?
 
Thanks in advance
 
   Usually when I do not hear back on a topic it means that it is either not 
 clear what I am
   asking for or it is a stupid question.
   I have looked back through the wiki again with no luck on how to have RT 
 System Searches
   available to the delivered Saved Search.
   The reports saved as RT System Searches are available to be placed on the 
 RT-at-a-Glance but
   do not show up in the Saved Search option.
   I am trying to avoid having to generate many copies of a system wide 
 report so it shows up in
   folks Saved Search collection.
   At the risk of being an annoyance I am

Re: [rt-users] RT4 and GIT; RT4 and Eclipse

2013-08-14 Thread Jeff Voskamp

On 08/14/2013 12:09 PM, Jok Thuau wrote:



1) Re: GIT - RT4 integration:
---Does anyone know of a way to tie a “commit” (in GIT) to a ticket in RT4, by 
putting an RT ticket # in the commit (and, ideally, back to the code)?

Git has hooks where you can call specific scripts at different stages in the commit 
process. You should be able to use a post-commit hook to poke at RT and do 
what you need.


2) Does anyone know of a way to connect Eclipse and RT4 (mylin used to do this 
with an older version of RT)?


Not familiar with either of those, so I can't be of much help here.

University of Waterloo
Waterloo, Ontario, Canada

Go Warriors!

Thanks,
Jok


RT::Integration::SVN is a start but has some significant limitations.
I took a look at a year or so ago.

Jeff


[rt-users] Malformed RT response when trying to create ticket from cli (rt)

2013-08-14 Thread Raed El-Hames
Hi
RT  version 4.0.13
I am having problems creating ticket from REST interface

[root@myrt RestClient]# RTDEBUG=3 ./rt create -t ticket set id='ticket/new' 
Queue='Testing' subject='new ticket'
POST http://myrturl/REST/1.0/show
Content-Length: 264
Content-Type: multipart/form-data; boundary=xYzZY

--xYzZY
Content-Disposition: form-data; name=format

l
--xYzZY
Content-Disposition: form-data; name=id

ticket/new
--xYzZY
Content-Disposition: form-data; name=user

root
--xYzZY
Content-Disposition: form-data; name=pass
mypass
--xYzZY--
HTTP/1.1 200 OK
Connection: close
Date: Thu, 15 Aug 2013 01:29:04 GMT
Server: Apache/2.2.15 (CentOS)
Content-Type: text/plain; charset=utf-8
Client-Date: Thu, 15 Aug 2013 01:29:04 GMT
Client-Peer: 194.143.161.11:80
Client-Response-Num: 1
Client-Transfer-Encoding: chunked
Set-Cookie: RT_SID_myrt.80=0e3b9b4e581aa0237b098fefdb98e37f; path=/; HttpOnly
X-Frame-Options: DENY

RT/4.0.13 200 Ok

# Required: id, Queue

id: ticket/new
Queue: General
Requestor: root
Subject:
Cc:
AdminCc:
Owner:
Status: new
Priority: 100
InitialPriority: 100
FinalPriority: 60
TimeEstimated: 0
Starts: 2013-08-15 01:29:04
Due: 2013-08-15 01:29:04
Text:

rt: Malformed RT response from http://myrt.

Can anyone give any pointers ,rather urgent , The only plugins I added :
(RT::Extension::TicketLocking RT::Extension::MergeUsers RTx::Calendar 
RT::Extension::SLA)

Roy

[cid:image301004.PNG@a4a14fa2.4ea5c3f8]


This email (and any attachments) contains information, which may be privileged 
and/or confidential. It's meant only for the individual(s) or entity named 
above. If you're not the intended recipient, please note that disclosing, 
copying, distributing or using this information is prohibited. If you've 
received this email in error, please let me know immediately by emailing me at 
the email address above and then delete all traces of this email from your 
system.  We monitor our email system, and may record your emails.

Computer viruses can be transmitted by email. You should check this email and 
any attachments for the presence of viruses. We accept no liability for any 
damage caused by any virus transmitted by this email or any attachments.

Daisy Communications Ltd
Registered office: Daisy House, Lindred Road Business Park, Nelson, Lancashire, 
BB9 5SR
Registered in England and Wales with company number: 4145329

inline: image301004.PNG