<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thank You! and will do with replies<div><br></div><div>Joe</div><div><br><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Joe Kirby , Assistant Vice President, Business Systems</div><div>Division of Information Technology (DoIT) </div><div>Support Response - <a href="http://www.umbc.edu/doit">http://www.umbc.edu/doit</a> </div><div>Administration 627</div><div>Office - 410-455-3020 </div><div>Email - <a href="mailto:kirby@umbc.edu">kirby@umbc.edu</a></div></div></span></span>
</div>
<br><div><div>On Aug 14, 2013, at 12:00 PM, <a href="mailto:rt-users-request@lists.bestpractical.com">rt-users-request@lists.bestpractical.com</a> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Send rt-users mailing list submissions to<br><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br><span class="Apple-tab-span" style="white-space:pre"> </span>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users<br>or, via email, send a message with subject or body 'help' to<br><span class="Apple-tab-span" style="white-space:pre"> </span>rt-users-request@lists.bestpractical.com<br><br>You can reach the person managing the list at<br><span class="Apple-tab-span" style="white-space:pre"> </span>rt-users-owner@lists.bestpractical.com<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of rt-users digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Modify CF dropdown list from external DB based off of<br> another CFs value (Joe Harris)<br> 2. Re: MySQL issue - Windows vs. Linux - Table name<br> (Cena, Stephen (ext. 300))<br> 3. Re: RT-at-a-Glance Saved Searches not showing RT System<br> searches (Kevin Falcone)<br> 4. Re: sendmailpipe returns EX_TEMPFAIL (Kevin Falcone)<br> 5. Re: Re-send a previously attached attachment? (Kevin Falcone)<br> 6. Re: sendmailpipe returns EX_TEMPFAIL (Thomas Sibley)<br> 7. Groups in LDAP (Donny Brooks)<br> 8. RT4 and GIT; RT4 and Eclipse (Lisa Tomalty)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 14 Aug 2013 07:23:23 -0400<br>From: Joe Harris <drey111@gmail.com><br>To: "scott.dalzell" <scott.dalzell@aveva.com><br>Cc: "rt-users@lists.bestpractical.com"<br><span class="Apple-tab-span" style="white-space:pre"> </span><rt-users@lists.bestpractical.com><br>Subject: Re: [rt-users] Modify CF dropdown list from external DB based<br><span class="Apple-tab-span" style="white-space:pre"> </span>off of another CFs value<br>Message-ID:<br><span class="Apple-tab-span" style="white-space:pre"> </span><CABoWt8TU411HZLZU2BJQW09CG2D_bF57oE_ESjjC-Lk_7msyEA@mail.gmail.com><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>I had a similar need. But instead of connecting to an external database<br>from within RT, I put together 2 scripts to check for content change and<br>dump and load my custom fields in cron. In my case, I was pulling time<br>sheet codes which are:<br>client_project and task_code. Each client_project has specific task_codes<br>so task_codes is dependent on client_project. Mine is probably way more<br>complicated than you need and could be done easier in perl. I'm a bash man<br>at heart so here is my method. They could be run from one script as long<br>as the server has access to get to both databases. Since custom fields are<br>added to transactions as the actual field values (and not relational by<br>id's) this was the best way foe me to get this done. During the day if the<br>finance department adds or removes codes, within an hour the RT system is<br>updated. Also in my case, client_project and task_code are each<br>concatenated from 4 fields in my original search (fields 1 and 2 make up<br>client_project and fields 3 and 4 make up task_code). Hope this helps in<br>some way and apologies for the long message...<br><br>The first script is run on the external server and creates a load file.<br>This script is run every hour between 8am and 5pm from cron.<br><br>#!/bin/bash<br>NEWFILE=/tmp/codes.txt<br>OLDFILE=/tmp/codes.last<br>/bin/mv $NEWFILE $OLDFILE<br>/usr/bin/psql -A -t -c "select field1,field2 from table where criteria like<br>'your_criteria' -U postgres_user databasename >$NEWFILE<br>if /usr/bin/diff $NEWFILE $OLDFILE >/dev/null ; then<br>echo "NoChanges" >/tmp/codes.status<br>else<br>echo "Changes" >/tmp/codes.status<br>fi<br><br>Then on another server, I look at the codes.status file and check for<br>changes. If there are, I pull over the file and dump and load the<br>customfieldvalues table where the customfield is in my case 1 and 2. This<br>script is run 5 minutes after the other one.<br><br>#!/bin/bash<br>HOME=/path/to/scripts<br>STATUSFILE=/tmp/codes.status<br>LOADFILE=/tmp/codes.txt<br>LASTFILE=/tmp/codes.txt<br>LOGFILE=$HOME/codes.log<br>PGSERVER=RT_PGSERVERNAME_REDACTED<br>PGUSER=RT_USER_REDACTED<br>PGDB=RT_DBNAME_REDACTED<br>TODAY=`date +%Y-%m-%d-%H:%M:%S`<br>echo "Starting script at $TODAY"<br># Start logging<br>exec > >(tee $LOGFILE)<br>exec 2>&1<br><br>#Fetch status file<br>scp root@EXT_SERVERNAME_REDACTED:$STATUSFILE /tmp/<br>STATUS=`cat $STATUSFILE`<br>echo $STATUS > $LOGFILE<br>if [ $STATUS == "Changes" ] ; then<br>echo "Making Changes">> $LOGFILE<br><br># Fetch update file<br>scp root@EXT_SERVERNAME_REDACTED:$LOADFILE /tmp/<br><br># Clean up previous sql load files and remove the old custom fields<br>rm -f $HOME/client_project.*<br>rm -f $HOME/task_code.*<br>rm -f $HOME/sequence.tmp<br>mv $HOME/client_project_backup $HOME/client_project_backup-$TODAY<br>psql -A -t -c "select * from customfieldvalues where customfield='1'" -h<br>$PGSERVER -U $PGUSER $PGDB >>$HOME/client_project_backup<br>psql -A -t -c "select * from customfieldvalues where customfield='2'" -h<br>$PGSERVER -U $PGUSER $PGDB >>$HOME/task_code_backup<br>psql -A -c "delete from customfieldvalues where customfield='1'" -h<br>$PGSERVER -U $PGUSER $PGDB<br>psql -A -c "delete from customfieldvalues where customfield='2'" -h<br>$PGSERVER -U $PGUSER $PGDB<br># Add a placeholder to notify users that update is taking place<br>psql -A -c "insert into customfieldvalues<br>(customfield,name,creator,created) values ('1','Tasks are being updated.<br>Refresh in 2-5 minutes','22',now())" -h $PGSERVER -U $PGUSER $PGDB<br><br># Start numbering<br>echo "5" >$HOME/sequence.tmp<br><br># Parse through load file and capture variables to populate Client/Project<br>field<br>OIFS=$IFS<br>IFS='<br>'<br>for m in `cat $LOADFILE`<br>do<br>CLIENT=`echo $m|cut -d"|" -f1`<br>PROJECT=`echo $m|cut -d"|" -f2`<br>CLIENTPROJECT="${CLIENT}[${PROJECT}]"<br>echo "$CLIENTPROJECT" >>$HOME/client_project.tmp<br>done<br><br># Get Unique Client Project Codes to load to database<br>cat $HOME/client_project.tmp |sort -u >> $HOME/client_project.txt<br>OIFS=$IFS<br>IFS='<br>'<br>for c in `cat $HOME/client_project.txt`<br>do<br>NAME=`echo $c |cut -d"|" -f1`<br># Send load file info to SQL file for troubleshooting, then update the<br>database with the new Client Project Values<br>echo "psql -A -c \"insert into customfieldvalues<br>(customfield,name,creator,created) values ('1','$c','22',now())\" -h<br>$PGSERVER -U $PGUSER $PGDB" >>$HOME/client_project.sql<br>psql -A -c "insert into customfieldvalues<br>(customfield,name,creator,created) values ('1','$c','22',now())" -h<br>$PGSERVER -U $PGUSER $PGDB<br><br>#Increment sequence file for sorting in the Web GUI<br>sequence=`tail -n1 $HOME/sequence.tmp`<br>SEQUENCE=`expr $sequence + 5`<br>CLEANNAME=`echo $NAME |sed -e 's/\[/\|/g; s/\]//g'`<br><br># Using the formatted Client/Project codes, loop through the loadfile and<br>capture Task codes for each Client/Project code<br>OIFS=$IFS<br>IFS='<br>'<br>for task in `cat $LOADFILE|grep $CLEANNAME`<br>do<br>TASK=`echo $task|cut -d"|" -f3`<br>CODE=`echo $task|cut -d"|" -f4`<br>CLIENT=`echo $task|cut -d"|" -f1`<br>PROJECT=`echo $task|cut -d"|" -f2`<br>CLIENTPROJECT="${CLIENT}[${PROJECT}]"<br>TASKCODE="${TASK}[${CODE}]"<br>echo "psql -A -c \"insert into customfieldvalues<br>(customfield,name,creator,created,category,sortorder) values<br>('2','$TASKCODE','22',now(),'$CLIENTPROJECT','$SEQUENCE')\" -h $PGSERVER -U<br>$PGUSER $PGDB" >>$HOME/task_code.sql<br>psql -A -c "insert into customfieldvalues<br>(customfield,name,creator,created,category,sortorder) values<br>('2','$TASKCODE','22',now(),'$CLIENTPROJECT','$SEQUENCE')" -h $PGSERVER -U<br>$PGUSER $PGDB<br>echo $SEQUENCE >$HOME/sequence.tmp<br>done<br>done<br>psql -A -c "delete from customfieldvalues where name='Tasks are being<br>updated. Refresh in 2-5 minutes'" -h $PGSERVER -U $PGUSER $PGDB<br>echo "Complete" >>$LOGFILE<br>else<br>echo "No Changes">>$LOGFILE<br>fi<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130814/75815045/attachment-0001.html><br><br>------------------------------<br><br>Message: 2<br>Date: Wed, 14 Aug 2013 08:19:38 -0400<br>From: "Cena, Stephen \(ext. 300\)" <SJC@qvii.com><br>To: <rt-users@lists.bestpractical.com><br>Subject: Re: [rt-users] MySQL issue - Windows vs. Linux - Table name<br>Message-ID:<br><span class="Apple-tab-span" style="white-space:pre"> </span><4DD6AB329450D847913EA76D7F3C6B8312F7F634@valkyrie.ogp.qvii.com><br>Content-Type: text/plain;<span class="Apple-tab-span" style="white-space:pre"> </span>charset="us-ascii"<br><br>Maciek - I figured it was more a MySQL issue than an RT one. I manually<br>went in & changed each table to the correct one (users to Users) and<br>that appeared to work. However, this won't fix my problem if I have to<br>move several databases over (we have a lot of MySQL dependant apps<br>here). Thank you for the link. I'll take a look at it today & see if it<br>will help. I'm just glad to know it's a MySQL issue and not an RT one!<br><br>Steve<br><br><br>------------------------------<br><br>Message: 3<br>Date: Wed, 14 Aug 2013 10:33:03 -0400<br>From: Kevin Falcone <falcone@bestpractical.com><br>To: rt-users@lists.bestpractical.com<br>Subject: Re: [rt-users] RT-at-a-Glance Saved Searches not showing RT<br><span class="Apple-tab-span" style="white-space:pre"> </span>System searches<br>Message-ID: <20130814143303.GI2007@jibsheet.com><br>Content-Type: text/plain; charset="us-ascii"<br><br>Joe - it helps if you trim the rest of the digest when replying.<br><br>On Tue, Aug 13, 2013 at 12:43:08PM -0400, Joe Kirby wrote:<br><blockquote type="cite"><blockquote type="cite"><br> I would like to know how to make RT System Searches show when the Saved Searches is added to<br> RT-at-a-Glance.<br><br> This is a great feature for My Closed Tickets type reports that are really not needed on the<br> page as its own.<br><br> At this time it seems like only SuperUser gets these.<br><br> Is there a setting that would allow this?<br><br> Thanks in advance<br></blockquote><br> Usually when I do not hear back on a topic it means that it is either not clear what I am<br> asking for or it is a stupid question.<br> I have looked back through the wiki again with no luck on how to have RT System Searches<br> available to the delivered Saved Search.<br> The reports saved as RT System Searches are available to be placed on the RT-at-a-Glance but<br> do not show up in the Saved Search option.<br> I am trying to avoid having to generate many copies of a system wide report so it shows up in<br> folks Saved Search collection.<br> At the risk of being an annoyance I am reporting<br> Thanks in advance<br></blockquote><br>RT System Searches don't automatically show up for all users unless<br>their name is in a specific format (compare with the system default<br>searches we ship). I consider this an oversight, and it'll probably<br>be fixed in a future release. At this time, your best solution is<br>finding the widest group you can and assigning the search to that<br>group.<br><br>-kevin<br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: not available<br>Type: application/pgp-signature<br>Size: 235 bytes<br>Desc: not available<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130814/867e8268/attachment-0001.pgp><br><br>------------------------------<br><br>Message: 4<br>Date: Wed, 14 Aug 2013 10:35:25 -0400<br>From: Kevin Falcone <falcone@bestpractical.com><br>To: rt-users@lists.bestpractical.com<br>Subject: Re: [rt-users] sendmailpipe returns EX_TEMPFAIL<br>Message-ID: <20130814143525.GJ2007@jibsheet.com><br>Content-Type: text/plain; charset="us-ascii"<br><br>On Tue, Aug 13, 2013 at 10:55:57AM +0200, Nathan Cutler wrote:<br><blockquote type="cite"><blockquote type="cite">Does anyone have any other ideas for debugging this issue? Especially<br>I am interested in how I could confirm or deny that it's related to<br>mod_perl "cohabitation" -- i.e. two different Perl applications in a<br>single mod_perl host?<br></blockquote><br>I noticed that when I don't have "PerlOptions +Parent" in the apache<br>config, the Perl library search order on the System Configuration page<br>is different than when I do. Here's what it looks like _without_<br>PerlOptions +Parent (omitting the line numbers which do not<br>copy-paste):<br><br>Perl library search order<br><br> /usr/share/request-tracker/local/lib<br> /usr/share/request-tracker/local/plugins/RT-Extension-MergeUsers/lib<br> /usr/lib/perl5/vendor_perl/5.10.0<br> /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi<br> /srv/www/perl-lib<br> /srv/www/vhosts/pdb/<br> /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi<br> /usr/lib/perl5/site_perl/5.10.0<br> /usr/lib/perl5/vendor_perl<br> /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi<br> /usr/lib/perl5/5.10.0<br> .<br> /srv/www<br><br>Notice lines 5 and 6 which obviously come from the other mod_perl application.<br><br>Now, here's what it says _with_ PerlOptions +Parent:<br><br>Perl library search order<br><br> /usr/share/request-tracker/local/lib<br> /usr/share/request-tracker/local/plugins/RT-Extension-MergeUsers/lib<br> /usr/lib/perl5/vendor_perl/5.10.0<br> /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi<br> /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi<br> /usr/lib/perl5/site_perl/5.10.0<br> /usr/lib/perl5/vendor_perl<br> /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi<br> /usr/lib/perl5/5.10.0<br> .<br> /srv/www<br><br>So maybe the problem is solved? I did have PerlOptions +Parent in the<br>apache configuration before, but maybe not correctly? I checked the<br>other application's vhosts file and it _does_ have PerlOptions<br>+Parent.<br></blockquote><br>While PerlOptions +Parent is important if you need to run two mod_perl<br>apps, you should keep your log in place, and possibly dig up one of<br>the shims from the mailing list archives that has been used to debug<br>this.<br><br>In the past, it was bugs in mod_perl and the handler type, but it's<br>nearly impossible to debug from the standard RT debug and mail logs.<br><br>-kevin<br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: not available<br>Type: application/pgp-signature<br>Size: 235 bytes<br>Desc: not available<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130814/277df552/attachment-0001.pgp><br><br>------------------------------<br><br>Message: 5<br>Date: Wed, 14 Aug 2013 10:36:17 -0400<br>From: Kevin Falcone <falcone@bestpractical.com><br>To: rt-users@lists.bestpractical.com<br>Subject: Re: [rt-users] Re-send a previously attached attachment?<br>Message-ID: <20130814143617.GK2007@jibsheet.com><br>Content-Type: text/plain; charset="us-ascii"<br><br>On Tue, Aug 13, 2013 at 09:49:54PM +0000, Beachey, Kendric wrote:<br><blockquote type="cite"><br><blockquote type="cite">-----Original Message-----<br>From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Boli<br>Sent: Tuesday, August 13, 2013 3:36 PM<br>To: RT users<br>Subject: [rt-users] Re-send a previously attached attachment?<br><br>Hi All,<br><br>Apologies if I have missed something obvious.<br><br>How can I re-send an attachment that has previously been attached to a ticket without downloading it and re-attaching it.<br><br>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.<br><br>Comments/Suggestions welcomed<br><br>Regards,<br></blockquote><br>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.<br><br>(assuming you don't have a security policy that would prevent this)<br></blockquote><br>The alternate (attaching a previously attached attachment to a new<br>reply) is something we've explored in a few branches with clients, but<br>nothing we've written has stuck or been right for mainstream release.<br><br>-kevin<br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: not available<br>Type: application/pgp-signature<br>Size: 235 bytes<br>Desc: not available<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130814/4ce32213/attachment-0001.pgp><br><br>------------------------------<br><br>Message: 6<br>Date: Wed, 14 Aug 2013 08:19:14 -0700<br>From: Thomas Sibley <trs@bestpractical.com><br>To: rt-users@lists.bestpractical.com<br>Subject: Re: [rt-users] sendmailpipe returns EX_TEMPFAIL<br>Message-ID: <520B9FF2.7080903@bestpractical.com><br>Content-Type: text/plain; charset=UTF-8<br><br>On 08/14/2013 07:35 AM, Kevin Falcone wrote:<br><blockquote type="cite"><blockquote type="cite">So maybe the problem is solved? I did have PerlOptions +Parent in the<br>apache configuration before, but maybe not correctly? I checked the<br>other application's vhosts file and it _does_ have PerlOptions<br>+Parent.<br></blockquote><br>While PerlOptions +Parent is important if you need to run two mod_perl<br>apps, you should keep your log in place, and possibly dig up one of<br>the shims from the mailing list archives that has been used to debug<br>this.<br><br>In the past, it was bugs in mod_perl and the handler type, but it's<br>nearly impossible to debug from the standard RT debug and mail logs.<br></blockquote><br>Adding on to what Kevin said...<br><br>You could also just save yourself some time and switch to a different<br>deployment option for RT. Running it under mod_fastcgi or mod_fcgid is<br>simple and would avoid any mod_perl bugs with +Parent. Why fight with<br>mod_perl?<br><br><br>------------------------------<br><br>Message: 7<br>Date: Wed, 14 Aug 2013 10:42:46 -0500<br>From: "Donny Brooks" <dbrooks@mdah.state.ms.us><br>To: rt-users@lists.bestpractical.com<br>Subject: [rt-users] Groups in LDAP<br>Message-ID: <7597-520ba580-5-2262d0c0@25267501><br>Content-Type: text/plain; charset="utf-8"<br><br>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.<br>-- <br><br>Donny B.<br><br><br>------------------------------<br><br>Message: 8<br>Date: Wed, 14 Aug 2013 15:47:52 +0000<br>From: Lisa Tomalty <ltomalty@uwaterloo.ca><br>To: "rt-users@lists.bestpractical.com"<br><span class="Apple-tab-span" style="white-space:pre"> </span><rt-users@lists.bestpractical.com><br>Subject: [rt-users] RT4 and GIT; RT4 and Eclipse<br>Message-ID: <360FA71407D1624082F4F84DBACABD541220677C@connmbx5><br>Content-Type: text/plain; charset="us-ascii"<br><br><br>1) Re: GIT <-> RT4 integration:<br>---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)?<br><br>2) Does anyone know of a way to connect Eclipse and RT4 (mylin used to do this with an older version of RT)?<br><br>Thanks!<br>Lisa :)<br><br>--------------------------------------------------------------------------------<br>Lisa Tomalty<br>Information Systems & Technology/Arts Computing Office<br><br>MC 2052/PAS 2023<br>University of Waterloo<br>Waterloo, Ontario, Canada<br>MC2025/PAS1083<br>(519) 888-4567 X35873<br>ltomalty@uwaterloo.ca<mailto:ltomalty@uwaterloo.ca><br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130814/2f54ba02/attachment-0001.html><br><br>------------------------------<br><br>--------<br>rt-users mailing list<br>rt-users@lists.bestpractical.com<br>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users<br><br><br><br>End of rt-users Digest, Vol 113, Issue 20<br>*****************************************<br></blockquote></div><br></div></body></html>