[rt-users] 3.8 GraphViz
I cannot seem to get the GraphViz working properly... I am trying to migrate from 3.6.5 to the 3.8.rc5... the issues that I have are: 1. I seem to require copying /opt/rt3/share/html/NoAuth/RichText/FCKeditor/fckstyles.xml up one directory. if I do not do this, when I try to add a comment or a reply to a ticket the dialogue box is not accessible... When I looked at the html source it indicated /RichText/fckstyles... so that is why I tried copying the file up one directory...then things worked... I mentioned this earlier on the list when I first attempted 3.8.0, Jesse mentioned that dhandler should automagically handle this, ( it was the least of my early challenges ), but this still exists even on mylatest numerous attempts. (I mention it because it may be related ) 2. I had version 3.8.rc3 working ( with the above kludge in place so things appeared to be working) and thought I would experiment with the GraphViz feature... This also sorta works... I just cannot get it to draw the relational images , I just get an "unknown icon" image. If I click on the icon , I do get taken back to the record, and if I select the "fill boxes with ... " something the proper information boxes appear in the Legends area.. I tried using different browsers, ugraded the GraphViz and GD...still no luck I am running on SUSE and have used the following configure: ./configure --enable-graphviz --enable-gd --enable-gpg I assume that both above issues are my install attempt related. I have tried numerous re-installs and even a brand new clean ( ie no old database or customizations ) but the result is the same... Any hints at how I got myself in the weeds...( and how to get out of the them !!!) PS: I am running lighttpd with the below /usr/bin/perl ./sbin/rt-test-dependencies --verbose --install --with-mysql --with-fastcgi perl: >=5.8.3(5.8.8)...found users: rt group (www)...found bin owner (root)...found libs owner (root)...found libs group (bin)...found web owner (nobody)...found web group (www)...found CLI dependencies: Term::ReadKey...found Getopt::Long >= 2.24...found HTTP::Request::Common...found Term::ReadLine...found Text::ParseWords...found LWP...found CORE dependencies: Class::ReturnValue >= 0.40...found Text::Quoted >= 2.02...found CSS::Squish >= 0.06...found Encode >= 2.13...found Module::Versions::Report >= 1.05...found MIME::Entity >= 5.425...found DBI >= 1.37...found Locale::Maketext::Lexicon >= 0.32...found Devel::StackTrace >= 1.19...found Digest::base...found Time::ParseDate...found File::Temp >= 0.18...found Locale::Maketext >= 1.06...found Tree::Simple >= 1.04...found Text::Template...found Scalar::Util...found HTML::Scrubber >= 0.08...found File::Spec >= 0.8...found Calendar::Simple...found DBIx::SearchBuilder >= 1.54...found Mail::Mailer >= 1.57...found File::ShareDir...found Regexp::Common...found Digest::MD5 >= 2.27...found HTML::Entities...found Cache::Simple::TimedExpiry...found File::Glob...found Locale::Maketext::Fuzzy...found Time::HiRes...found Text::Wrapper...found Log::Dispatch >= 2.0...found UNIVERSAL::require...found Email::Address...found DASHBOARDS dependencies: HTML::RewriteAttributes >= 0.02...found MIME::Types...found FASTCGI dependencies: CGI::Fast...found CGI >= 3.38...found FCGI...found GD dependencies: GD::Text...found GD...found GD::Graph...found GPG dependencies: PerlIO::eol...found GnuPG::Interface...found GRAPHVIZ dependencies: IPC::Run...found GraphViz...found IPC::Run::SafeHandles...found ICAL dependencies: Data::ICal...found MAILGATE dependencies: Pod::Usage...found HTML::TreeBuilder...found Getopt::Long...found HTML::FormatText...found LWP::UserAgent...found MASON dependencies: Storable >= 2.08...found CSS::Squish >= 0.06...found Apache::Session >= 1.53...found Errno...found Devel::StackTrace >= 1.19...found CGI::Cookie >= 1.20...found Text::WikiFormat >= 0.76...found XML::RSS >= 1.05...found HTML::Mason >= 1.36...found Digest::MD5 >= 2.27...found MYSQL dependencies: DBD::mysql >= 2.1018...found SMTP dependencies: Net::SMTP...found STANDALONE dependencies: Net::Server::PreFork...found Net::Server...found HTTP::Server::Simple >= 0.34...found HTTP::Server::Simple::Mason >= 0.09...found All dependencies have been found.
Re: [rt-users] ExtractCustomFieldValues with attachments.
JS, It is text/plain. Your modified version of ECFV seems to handle looping through the attachments, but misses the initial first attachment, The original ECFV handles the first attachment but in my case is not looping through any additional attachments to the transaction. I will try and merge the two versions today ( they are very different ) Again thanks for your support and interest ... >>> Jean-Sebastien Morisset <[EMAIL PROTECTED]> 29/07/2008 4:09 pm >>> On Tue, Jul 29, 2008 at 03:22:15PM -0400, Roy Sowa wrote: > JS, I spoke too soon... > The issue now is that I extract fine from the attachment, but now if the > matchstring is in the first attachment it is not found... What's the MIME Type of your first attachment? Line #100 might be skipping the first attachment: 97 while (my $Message = $Attachments->Next) { 98 $AttachNumber++; 99 $RT::Logger->info("considering attachment #".$AttachNumber." of type ".$Message->ContentType); 100 next unless $Message->ContentType =~ m!^(text/plain|message|text$)!i; 101 next unless $Message->Content; js. -- Jean-Sebastien Morisset, Sr. UNIX Administrator <[EMAIL PROTECTED]> ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] ExtractCustomFieldValues with attachments.
JS, I spoke too soon... The issue now is that I extract fine from the attachment, but now if the matchstring is in the first attachment it is not found... So I have put back the original file, and am back to not being able to extract from attachments .. So between the two files is the solution... I want to extract the MatchString if it is in either. Off to review the diffs and logicbut if anyone can help me out of the weeds >>> Jean-Sebastien Morisset <[EMAIL PROTECTED]> 29/07/2008 1:30 pm >>> The problem is with the FindMatch function. It only checks the first attachment. I overhauled this perl module quite a bit. Here's my version attached. Diff this one to yours to see the differences. :-) js. On Tue, Jul 29, 2008 at 01:01:49PM -0400, Roy Sowa wrote: > I am currently using RT 3.6.5 and ECFV 1.2.b3 > > I cannot get the extract to work if the MatchString is not in the first > attachment. > I have been using ECFV for a while on basic standard type email tickets, but > now I have the requirement > to extract the MatchString from an attachment. > > It does not seem to matter if the ticket is created via GUI or email. > The simplest test being; >1. Create ticket using GUI with a description that has the MatchString > ( this works CF get populated) >2. Create ticket using GUI without any description and attach text file > that contains MatchString ( this works Cf gets populated) >3. Create ticket using GUI with general desc and attach text file with > MatchString . ( this fails No CF populated ) > > Questions: > Does ExtractCustomFieldValues work with multi part messages if the > matchstring is in the second attachment? > > Where did I go wrong ? > >I have read the list , and ContentObj is what is being used. > Any hints or guidance would be much appreciated. > > Thanks in advance. > > Roy > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Jean-Sebastien Morisset, Sr. UNIX Administrator <[EMAIL PROTECTED]> ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] ExtractCustomFieldValues with attachments.
JS, There was/is a big diff between the two , so I copied your version over to test... Cleared the mason stop/started the web and repeated my tests... Works I will now go through the diffs and try an understand it all ;-) Many thanks for your quick help ( this list rocks ) Roy >>> Jean-Sebastien Morisset <[EMAIL PROTECTED]> 29/07/2008 1:30 pm >>> The problem is with the FindMatch function. It only checks the first attachment. I overhauled this perl module quite a bit. Here's my version attached. Diff this one to yours to see the differences. :-) js. On Tue, Jul 29, 2008 at 01:01:49PM -0400, Roy Sowa wrote: > I am currently using RT 3.6.5 and ECFV 1.2.b3 > > I cannot get the extract to work if the MatchString is not in the first > attachment. > I have been using ECFV for a while on basic standard type email tickets, but > now I have the requirement > to extract the MatchString from an attachment. > > It does not seem to matter if the ticket is created via GUI or email. > The simplest test being; >1. Create ticket using GUI with a description that has the MatchString > ( this works CF get populated) >2. Create ticket using GUI without any description and attach text file > that contains MatchString ( this works Cf gets populated) >3. Create ticket using GUI with general desc and attach text file with > MatchString . ( this fails No CF populated ) > > Questions: > Does ExtractCustomFieldValues work with multi part messages if the > matchstring is in the second attachment? > > Where did I go wrong ? > >I have read the list , and ContentObj is what is being used. > Any hints or guidance would be much appreciated. > > Thanks in advance. > > Roy > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Jean-Sebastien Morisset, Sr. UNIX Administrator <[EMAIL PROTECTED]> ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] ExtractCustomFieldValues with attachments.
I am currently using RT 3.6.5 and ECFV 1.2.b3 I cannot get the extract to work if the MatchString is not in the first attachment. I have been using ECFV for a while on basic standard type email tickets, but now I have the requirement to extract the MatchString from an attachment. It does not seem to matter if the ticket is created via GUI or email. The simplest test being; 1. Create ticket using GUI with a description that has the MatchString ( this works CF get populated) 2. Create ticket using GUI without any description and attach text file that contains MatchString ( this works Cf gets populated) 3. Create ticket using GUI with general desc and attach text file with MatchString . ( this fails No CF populated ) Questions: Does ExtractCustomFieldValues work with multi part messages if the matchstring is in the second attachment? Where did I go wrong ? I have read the list , and ContentObj is what is being used. Any hints or guidance would be much appreciated. Thanks in advance. Roy ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Attach a file when resolving (again)
Hi, I cannot seem to attach a file during/at the resolve screen. Replying to a ticket does allow files to be attached. My support folks are now "replying" with the attachment and then immediately Resolving the ticket .. This gets the attachment to client, but I would like to do it all from the resolve screen in a single step. is this possible ??? any hints or examples Thanks Roy ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Include all ticket attachments in template output
Hi List, I am trying to use a scrip/template to include/attachments that were provided to the ticket in earlier transactions. ( ie the requestor attached a file with the initial request ). The template will send to external non-RT defined users ( ie not CC'c AdminCC's or watchers ) with no access to RT. The template fires based on a selection made to a CF that has the email address's of people in a somewhat long dropdown list. So basically what I have working now is; 1.Ticket comes into RT 2. It may or may not have a file attached 3. AdminCC's of queue are notified, they review ticket request content and then using the Custom field dropdown list , select appropriate person's email . 4. this change to that custom field automatically fires off the template which uses that CF email selection as the TO: in the template. the template boilerplate contains the initial ticket request content The problem I have is I can't seem to get the file ( if there is one ) that was attached by the requestor to be included in the outgoing email as well. Anybody doing something like this and have a hint or two they can share... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Include earlier "binary attachment" in outgoing template
Hi List, I am trying to use a scrip/template to include/attachments that were provided to the ticket in earlier transactions. ( ie the requestor attached a file with the initial request ). The template will send to external non-RT defined users ( ie not CC'c AdminCC's or watchers ) with no access to RT. The template fires based on a selection made to a CF that has the email address's of people in a somewhat long dropdown list. So basically what I have working now is; 1.Ticket comes into RT 2. It may or may not have a file attached 3. AdminCC's of queue are notified, they review ticket request content and then using the Custom field dropdown list , select appropriate person's email . 4. this change to that custom field automatically fires off the template which uses that CF email selection as the TO: in the template. the template boilerplate contains the initial ticket request content The problem I have is I can't seem to get the file ( if there is one ) that was attached by the requestor to be included in the outgoing email as well. Anybody doing something like this and have a hint or two they can share... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Resolved WITH attachment
Anyone have a scrip/template example to include the resolve comment AND also allows an attachment/s to be included when resolving a ticket ? I have seen some examples, that require two emails being sent, but I am hoping to be able to have just a single message sent. Roy ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Not getting queue name in replies...
Found it ... my bad...( more learning ) In /opt/rt3/RT_Config.pm had this line set incorrectly... Set($UseFriendlyFromLine , 0); ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Not getting queue name in replies...
Help.. I don't know how , but i broke it... I send a new request via email to a Queue [EMAIL PROTECTED] Ticket is received O.k. in RT... I get my autoreply message and the FROM: has the proper Queue name ( good ) I reply to the the autoreply message( good) I use the RT gui and reply to this new ticket ticket... mail goes out... BUT the from: field has my username ( not the queue name ) the Reply-To field has the queue name... The email I get as the user has " [EMAIL PROTECTED]" in the FROM: subject line makes correct reference to the ticket.. Replying to ticket does not work ... quickly troubleshooting 3.6.5 mysql What did I do to muck it ... advice asap ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Searching CF Date field using relative (ie: now + Days)
Many hours later, I cannot seem to get this working I am running RT 3.6.5, SUSE 10 , lighttpd, https configuration with the patch for date customfields upgraded to the latest DBIx::SearchBuilder 1.51 ( was at 1.48) . Also have same issue with my 3.6.3 Redhat http configuration without the patch for date customfields. The relative searching works as expected if I use the standard DUE, LastUpdated , Resolved etc fields, but not if I use a CF date field. example : the relational syntax Due< ' +5 Days' works if I use the standard Due field, but not if I use a CF field ... 'CF.{Ready Date}' < '+5 Days'this returns 0 hits., but if I use the actual date... 'CF.{Ready Date}' < '2008-02-14'this works... I am afraid now that I have been staring too long ,and may be missing the obvious.. Any suggestions where I should be focusing on to untangle myself here ? Anybody have this working with a similar install... PS: Thanks Emmanuel for you help so far... Tired, and bleary eyed... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Custom date
On Sat, Feb 09, 2008 at 08:51:16AM -0500, Roy Sowa wrote:>Yes , I am using your calendar patch on this serverI just tried the>same type queries on my older (unpatched ) box and I am having the>same issue.ie: > 'now + 5 Days' or > 'now' , works with the standard>Due date, but not CF date fields.the older box is 3.6.3 and I am using>your patch on a 3.6.5 version.Still digging..> It works here, RT 3.6.6, Debian Etch, DBIx::SearchBuilder 1.51, Mysql> 5.0.32. > I tested using "> 'now'" and "< 'now'". I tested also using "< 'now +> Days'", it works but not with "> 'now - 365 Days'" (with both CF and> Tickets dates).Still not working here..RT 3.6.5 SUSE 10 Ugraded DBIx::SearchBuilder 1.48 to DBIx::SearchBuilder 1.51( same issue on 3.6.3 Redhat box ) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Custom date field
Yes , I am using your calendar patch on this serverI just tried the same type queries on my older (unpatched ) box and I am having the same issue.ie: > 'now + 5 Days' or > 'now' , works with the standard Due date, but not CF date fields.the older box is 3.6.3 and I am using your patch on a 3.6.5 version.Still digging.. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Custom date field
Yes , I will try and test this out on an old non-patched setup stay tuned... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Custom date field search
I have created custom date fields of the format ( -mm-dd ). I would like to create a saved search that would return tickets with upcoming dates less than X days from now. the relational syntax Due< ' +5 Days' works if I use the standard Due field, but not if I use a CF field ... 'CF.{Ready Date}' < '+5 Days' I have multiple dates/fields that I would like to create saved searches against. Any hints / suggestions ? Anyone else doing something similar ? Roy ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Show RealName
Thank you Emmanuel RealNames now showing ps: I also have used your patch to allow calendar pop-up for custom date fields. Working very well. Just wanted to say thanks for helping a novice. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Show RealName
I am trying to show the RealName of the requestors and Cc's on the ModifyPeople page in the Current Watcher Area. I have tried editing a local ShowUserEntry, but this did not change things. Can anyboby point me what files I should be making to make this change ? Roy ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] searching "select multiple" Custom field
My problem/requirement seems to be much like this old thread; http://www.gossamer-threads.com/lists/rt/users/33053?search_string=multiple%20bug;#33053 I was hoping to be able to have single multi-select custom field ( perhaps 50 + choices) , and then easily be able to search/report on tickets that had only a very specific combination ( from that given set of 50 choices) selected . Is anyone else doing something similar? >>> Kenneth Crocker <[EMAIL PROTECTED]> 29/01/2008 1:14 pm >>> Roy, When you used the "OR' and got all thos results, did you notice any differences in the other criteria between the ticket you wanted (using the 'AND") the tickets with just one of the CF's? That might provide a clue as to what you need to change to your query. Kenn LBNL On 1/29/2008 9:45 AM, Roy Sowa wrote: > I only want to return tickets that have both of the values in a ticket , not > one OR the other. > I failed to mention that when I use the AND as in my original post , I return > Zero hits as if the query cannot be satisfied. > but there are single tickets that have only both the criteria selected. > When I use the OR as you suggest , I get all tickets that contain either of > the criteria ...not only those that have both. > > > >>>> Kenneth Crocker <[EMAIL PROTECTED]> 29/01/2008 12:12 pm >>> > Roy, > > > You might get better results if your last "AND" (CF.FOO like AND > CF.FOO like xxx) was an "OR". Your query will only pull those tickets if > that CF has BOTH values. Since you stated the values could be anywhere > from AAA to FFF, then perhaps you would want ANY ticket that has either > of the values you are looking for. Just a thought. > > > Kenn > LBNL > > On 1/29/2008 5:29 AM, Roy Sowa wrote: >> I have a queue specific custom field that may contain multiple values. >> (AAAFFF) >> If I have a ticket which has set multiple values for that custom field >> then I do not find the ticket when I specify a search criteria that >> contains multiple values for that custom field. >> Eg: >> The custom field ( FOO ) may contain the values "AAA" and "CCC". >> My ticket has set both values. The search criteria is: >> >> Queue = 'TEST' AND ( Status = 'open' OR Status = 'new' OR Status = >> 'stalled' ) AND 'CF.{FOO}' LIKE 'AAA' AND 'CF.{FOO}' LIKE CCC' >> >> If I search for one of the criteria then those tickets are found. >> The ticket is not found if I look for "AAA" and "CCC". ( tickets with this >> match do exist in the database ) >> >> I am running 3.6.5. >> Am I missing something, how do I search for those records that only contain >> both 'AAA' and 'CCC' >> >> Roy >> >> >> >> ___ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: [EMAIL PROTECTED] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > > > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] searching "select multiple" Custom field
I only want to return tickets that have both of the values in a ticket , not one OR the other. I failed to mention that when I use the AND as in my original post , I return Zero hits as if the query cannot be satisfied. but there are single tickets that have only both the criteria selected. When I use the OR as you suggest , I get all tickets that contain either of the criteria ...not only those that have both. >>> Kenneth Crocker <[EMAIL PROTECTED]> 29/01/2008 12:12 pm >>> Roy, You might get better results if your last "AND" (CF.FOO like AND CF.FOO like xxx) was an "OR". Your query will only pull those tickets if that CF has BOTH values. Since you stated the values could be anywhere from AAA to FFF, then perhaps you would want ANY ticket that has either of the values you are looking for. Just a thought. Kenn LBNL On 1/29/2008 5:29 AM, Roy Sowa wrote: > > I have a queue specific custom field that may contain multiple values. > (AAAFFF) > If I have a ticket which has set multiple values for that custom field > then I do not find the ticket when I specify a search criteria that > contains multiple values for that custom field. > Eg: > The custom field ( FOO ) may contain the values "AAA" and "CCC". > My ticket has set both values. The search criteria is: > > Queue = 'TEST' AND ( Status = 'open' OR Status = 'new' OR Status = > 'stalled' ) AND 'CF.{FOO}' LIKE 'AAA' AND 'CF.{FOO}' LIKE CCC' > > If I search for one of the criteria then those tickets are found. > The ticket is not found if I look for "AAA" and "CCC". ( tickets with this > match do exist in the database ) > > I am running 3.6.5. > Am I missing something, how do I search for those records that only contain > both 'AAA' and 'CCC' > > Roy > > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] searching "select multiple" Custom field
I have a queue specific custom field that may contain multiple values. (AAAFFF) If I have a ticket which has set multiple values for that custom field then I do not find the ticket when I specify a search criteria that contains multiple values for that custom field. Eg: The custom field ( FOO ) may contain the values "AAA" and "CCC". My ticket has set both values. The search criteria is: Queue = 'TEST' AND ( Status = 'open' OR Status = 'new' OR Status = 'stalled' ) AND 'CF.{FOO}' LIKE 'AAA' AND 'CF.{FOO}' LIKE CCC' If I search for one of the criteria then those tickets are found. The ticket is not found if I look for "AAA" and "CCC". ( tickets with this match do exist in the database ) I am running 3.6.5. Am I missing something, how do I search for those records that only contain both 'AAA' and 'CCC' Roy ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-mailgate HTTPS
That little hint was what I needed , thanks Ruslan It was not intentional, trust me !!! Although everything was working using the GUI, I had numerous ownership and permission confusion throughout my install. The most glaring, carrying over the apache user in my rt group as it was on my original system and now running lighttpd as a different user name. Thanks to you all , for your help and patience. >>> "Ruslan Zakirov" <[EMAIL PROTECTED]> 2008-01-20 13:35 >>> This output suggest me that you've disabled mason for /NoAuth/... paph. Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-mailgate HTTPS
more info... I saw this on the list ... same scenario ... I am moving to new hardware/versions and trying to do SSL so I tried this as well... my error: Connecting to http://x/REST/1.0/NoAuth/mail-gateway at /opt/rt3/bin/rt-mailgate line 102, <> line 1. ---from the list below ( not me) tried to move our RT installation to a new server (New: Debian Etch. Old: Debian Sarge). Copied the DB content and RT_SiteConfig. Everything looks fine, but the mailgate does not work. When testing rt-mailgate manually I get the error: cat mail | /usr/local/rt3/bin/rt-mailgate --debug --queue RT_Test --action correspond --url https://rt.ponton.local/ Connecting to https://rt.ponton.local//REST/1.0/NoAuth/mail-gateway at /usr/local/rt3/bin/rt-mailgate line 100, <> line 1. Segmentation fault The file mail contains: From: foo[at]bar.com To: rt[at]ponton Subject: Test Test ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-mailgate HTTPS
Thanks James, i have provided the info below, and while still stuggling, I have tried to set things up to use either HTTPS or HTTP Ihave that going now, and either one works fine with the GUI. Still cannot get an email through . That is why you will see one http alias in the list. So I am still working my way backwards... Thanks for your time If you need more info just ask ( also this is all new to me so I might not always know how to get what you ask for ) Error from a bounce; RT server error. The RT server which handled your email did not behave as expected. It said: %# BEGIN BPS TAGGED BLOCK {{{ <%flags> inherit => undef # inhibit UTF8 conversion done in /autohandler <%ARGS> $queue => 1 $action => "correspond" $ticket => undef <%init> $m->comp('/Elements/Callback', _CallbackName => 'Pre', %ARGS); use RT::Interface::Email ();# It's an exporter, but we don't care $r->content_type('text/plain; charset=utf-8'); $m->error_format('text'); my ( $status, $error, $Ticket ) = RT::Interface::Email::Gateway( \%ARGS ); if ( $status == 1 ) { $m->out('ok'); if ( $Ticket->Id ) { $m->out( 'Ticket: ' . ($Ticket->Id || '') ); $m->out( 'Queue: ' . ($Ticket->QueueObj->Name || '') ); $m->out( 'Owner: ' . ($Ticket->OwnerObj->Name || '') ); $m->out( 'Status: ' . ($Ticket->Status || '') ); $m->out( 'Subject: ' . ($Ticket->Subject|| '') ); $m->out( 'Requestor: ' . ($Ticket->Requestors->MemberEmailAddressesAsString || '') ); } } else { $RT::Logger->error( "Could not record email: " . $error ); if ( $status == -75 ) { $m->out( "temporary failure - " . $error ); } else { $m->out( 'not ok - ' . $error ); } } $m->abort(); "|/opt/rt3/bin/rt-mailgate --queue 'X' --action correspond --url https://XXX/";... Deferred: prog mailer (/bin/sh) exited with EX_TEMPFAIL Warning: message still undelivered after 4 hours + I saw that about the Crypt::SSLeay , so I installed Crypt-SSLeay-0.57 stop started everything this did not help Aliases: Ticket_ELS: "|/opt/rt3/bin/rt-mailgate --queue 'NAME1' --action correspond --url https://xxx/"; ELS_MSG:"|/opt/rt3/bin/rt-mailgate --queue 'Name2' --action correspond --url https:///"; Ticket_EHIVE: "|/opt/rt3/bin/rt-mailgate --queue 'Name3' --action correspond --url http://xx/"; >>> James Moseley <[EMAIL PROTECTED]> 2008-01-20 11:24 >>> First of all, what error messages were generated when you tried to send email to the RT address via bounced emails or from RT/mail logs? Secondly, rt-mailgate works just fine with HTTPS only installs - you've got to make sure that all your SSL related PERL modules have been installed, namely Crypt::SSLeay Lastly, what do your aliases look like? James Moseley "Roy Sowa" <[EMAIL PROTECTED] c.gc.ca> To Sent by: rt-users-bounces@ cc lists.bestpractic al.comSubject [rt-users] rt-mailgate HTTPS 01/20/2008 08:11 AM I have seen list reference to email tickets not working with HTTPS configurations. Some indicate that a local http connection must exist for the rt-mailgate to work my current install is 3.6.5 using Lighttpd Everything is working fine using the GUI. but I cannot get emails to open tickets. I have verified that I can actually receive smtp mail sent to a user on the box. - I redirect my http to https - my /etc/aliases point to the https url -my lighttpd.conf is below; $SERVER["socket"] == "xx.xx.xx.xx:80" { #server.document
[rt-users] rt-mailgate HTTPS
I have seen list reference to email tickets not working with HTTPS configurations. Some indicate that a local http connection must exist for the rt-mailgate to work my current install is 3.6.5 using Lighttpd Everything is working fine using the GUI. but I cannot get emails to open tickets. I have verified that I can actually receive smtp mail sent to a user on the box. - I redirect my http to https - my /etc/aliases point to the https url -my lighttpd.conf is below; $SERVER["socket"] == "xx.xx.xx.xx:80" { #server.document-root= "/" server.document-root= "/opt/rt3/share/html/" url.redirect = ( "^/(.*)" => "https://mysite/$1"; ) } $SERVER["socket"] == "xx.xx.xx.xx:443" { server.document-root= "/opt/rt3/share/html/" url.rewrite = ( "^(.*)/Ticket/Attachment/(.*)" => "/$1/Ticket/Attachment/$2/" ) fastcgi.map-extensions = ( ".css" => ".html", ".js" => ".html", "/" => ".html" ) ssl.engine = "enable" ssl.pemfile = "/etc/lighttpd/ssl/domain.com/server.pem" $HTTP["useragent"] =~ ".*MSIE.*" {server.max-keep-alive-requests = 0 } } I do not know where best to try and resolve this ...( web config or rt-mailgate ) I would be very grateful if someone could point me in the right direction on what or where to go from here. Thanks Roy ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Mysqldump 3.6.3 -> 3.6.5 ( attachments ) Resolved
Sorry for the confusing post, ( stumbling as I learn ) To fix my issue I have added a url rewrite to my lighttpd.conf to ensure that a trailing slash is added when an attachment link is followed; url.rewrite = ( "^(.*)/Ticket/Attachment/(.*)" => "/$1/Ticket/Attachment/$2/" ) Now things seem to be back on track. Thanks for your patience Roy The Issue does not seem to be a result of the dumping/moving of the data, but instead now seems to be due to a missing trailing slash when I click on the attachment link on a ticket. If I manually add that trailing slash the attachment is indeed there. I am using lighttpd, my lighttpd.conf does have this ... server.document-root= "/" url.redirect = ( "^/(.*)" => "https://MySERVERNAMEHERE/$1"; ( 'https://myservernamehere/$1";' ) and my RT_SiteConfig has this; Set($WebPort , 443); Set($WebBaseURL , "https://MyServerName:$WebPort"; ( 'https://myservername:$WebPort"/' )); Set($WebPath , ""); Set($WebURL , $WebBaseURL . $WebPath . "/"); I have tried adding a trailing slash to the lighttpd.conf, cleared Mason and restarted Still scratching my head though... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Mysqldump 3.6.3 -> 3.6.5 ( attachments )
The Issue does not seem to be a result of the dumping/moving of the data, but instead now seems to be due to a missing trailing slash when I click on the attachment link on a ticket. If I manually add that trailing slash the attachment is indeed there. I am using lighttpd, my lighttpd.conf does have this ... server.document-root= "/" url.redirect = ( "^/(.*)" => "https://MySERVERNAMEHERE/$1"; and my RT_SiteConfig has this; Set($WebPort , 443); Set($WebBaseURL , "https://MyServerName:$WebPort";); Set($WebPath , ""); Set($WebURL , $WebBaseURL . $WebPath . "/"); I have tried adding a trailing slash to the lighttpd.conf, cleared Mason and restarted Still scratching my head though... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Mysqldump 3.6.3 -> 3.6.5 ( attachments )
I am in the process of moving my existing RedHat 3.6.3 install to a SUSE 10 3.6.5 box ... I thought all was going well, but I just stumbled into a problem... I had been using the following mysqldump ; mysqldump --opt --add-drop-table --single-transaction rt3 > backup.out and this restores nicely.. ( I thought I was good to go ). the records look correct and I see the attachment links in the tickets that have them, But now when I try and view an attachment by clicking on the link it says "page not found" the url link matches the search format of that of the original working server ... what I have tried so far... A few searches surfaced that I might try adding this to my dump statement "--default-character-set=binary" but this did not change things... Trying to create a new ticket with a simple attachment also does not work Funny enough If I attach a simple gif, I see the gif in the newly created ticket, however I just cannot click on the download link in the transaction or the link in the attachment area... ( page not found...) So then I found this snippet RE: binary attachment corruption; Hello, Chris. Could you backup your DB, and run next to SQL queries? ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL; Then check if you could binary attachments without problems and report back. This query is safe but anyway I would suggest you to backup data. . This did not change results either... I really would like to convert to the newer server/hardware any suggestions as to where I went wrong or how to move this forward ??? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Add group members as CC on create scrip
Folks, I apologize, but I just cannot get this to work. I have seen ( and tried ) many examples on the list, over the past couple of days, but I am making no headway trying to implement. Once again I seek some expert advice... the situation ... 1. Users can be in multiple groups 2. Users can send tickets to multiple queues but they only should be allowed to see their own tickets. 3. Group members should be added as CC to ticket on create , to allow them to see tickets created by their group . much effort , no results... I am now floundering ... and am asking for a hand. thanks Roy ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Add GroupMembers as CC on create ( help required )
First off, my apologizes for posting to the dev list earlier in error... a true newbie I need some guidance.. I have tried numerous versions of scrips , approaches and examples that I have found thanks to this list, but I just can't get things to work as I expect/want. The below scrip ( found on the list...thank you ) , does work , but it requires that I have the hardcoded "Group_Here_Works" entry. Usin different group names does produce those members as CC's. What I really want to have happen is; the requestor's group/s members be automatically figured out and those members be added as CC's to the ticket on creation. but I can't seem to grasp how. I am struggling to get my head around all this, so any assistance is very welcomed. == my $ticket = $self->TicketObj; my $transaction = $self->TransactionObj; my $derivedGroupName = 'GROUPNAME_HERE_WORKS'; # instantiate a group object my $addGroupObj = RT::Group->new($RT::SystemUser); $addGroupObj->LoadUserDefinedGroup($derivedGroupName); return undef unless $addGroupObj; my $addGroupMembersObj = $addGroupObj->UserMembersObj; my $userObj; # walk through members of group to add; if a given member is not already on the ticket, add to the CC list while ($userObj = $addGroupMembersObj->Next) { if (($ticket->IsRequestor($userObj->PrincipalId)) or ($ticket->IsCc($userObj->PrincipalId))) { $RT::Logger->debug("On Create Add Group CC: '" . $userObj->Name . "' is already a ticket watcher; not adding Cc on ticket \#" . $ticket->id ); } else { $RT::Logger->debug("On Create Add Group CC: Adding '" . $userObj->Name ."' to ticket \#" .$ticket->id); my ($success, $msg)= $ticket->AddWatcher( Type => "Cc", PrincipalId => $userObj->Id); if (! $success) { $RT::Logger->info("On Create Add Group CC: couldn't add '" . $userObj->Name . "' to " . $ticket->id . "': got '" . $msg ."'"); } } } return 1; ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] view tickets opened by a member of my group&[EMAIL PROTECTED]
* Kenneth Crocker [2007-04-04 12:32:27 -0700]: > > How do I assign permissions such that everyone in a certain group > > can view a ticket when a single member of their group opens a ticket > > in some queue? > > Did you get any answers for this? >Yes, I received a scrip right now (off the list) from someone who needed >similar functionailty. I've not yet tested it though. >Thomas Any further follow-up on that script , or hints on how best to do the above ? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] struggling a bit with RT&[EMAIL PROTECTED]
Thank you such quick response this list is awsome !! ( and as my first post to have a response from the name on the book is most impressive ) I will now go try a figure out the group member requestor scrip with renewed vigor RS ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] struggling a bit with RT
Hello, As a novice, I am struggling a bit ( actually a lot ) with two RT features ; I have searched around and bought the book , but still I am in the weeds. Any direction will be appreciated. Issue #1 trying to create CF's with a date popup calendar. Any docs/examples/hints Issue #2 I think I need a scrip that would determine the group members of a requestor and make them cc on a ticket so all group members would then be able to see the ticket.. Also one other point... I can't seem to use the "unlimited" in a search report, 100 works ( bug or me ? ) I am using 3.6.3.. As a novice , I truly thank you all for the many posts to the lists that got me this farRT is very very cool RS. Roy A. Sowa UNIX OS Support (613) 993-0291 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com