Re: [rt-users] Custom Condition To Send Email on Resolve if No Article Sent as Part of Resolve

2014-08-02 Thread Foggi, Nicola
Thanks Alex, That code with some modification worked for me, I only want the scip to apply IF Status changed -> resolved AND NOT if RefersTo link is added (I can ignore the correspondence I think safely as the significant event is the addlink to the article (that it's set already to send out v

Re: [rt-users] Custom Condition To Send Email on Resolve if No Article Sent as Part of Resolve

2014-08-02 Thread Foggi, Nicola
# # //RUZ Looks like that comment still exists in the 4.2 code? Any ideas on a workaround if this is indeed what I'm running into? Nicola ________ From: Foggi, Nicola Sent: Saturday, August 02, 2014 7:45 PM To: rt-users@lists.bestpractical.com Subject: C

[rt-users] Custom Condition To Send Email on Resolve if No Article Sent as Part of Resolve

2014-08-02 Thread Foggi, Nicola
Version : RT-4.0.19 Hey All, Running into a slight problem with a new queue I'm attempting to roll out a new queue that uses some "pre-canned" template responses using Articles from the integrated RTFM system in 4.0.19 now. I've changed the lifecycle to make the open -> resolve a default RESP

Re: [rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8

2010-08-18 Thread Foggi, Nicola
I had the same problem and ended up dropping the Groups2 index and performance went back to "normal" Nicola -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Alex Young Sent: Wed 8/18/2010 6:07 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] Slow

Re: [rt-users] Approvals not working

2010-07-29 Thread Foggi, Nicola
.com/rt/Search/Results.html?Query=Queue = 'ChangeApproval' AND (Status = 'new' OR Status = 'open' OR Status = 'stalled') Why don't any of the approvals with status=new show in the results screen? Any ideas what is going on here? Mike >>&g

Re: [rt-users] Mysql queries slow

2010-07-21 Thread Foggi, Nicola
with no real mysql tweaking on RT 3.8.8 I get: mysql> select count(id) from Attachments; +---+ | count(id) | +---+ | 41636 | +---+ 1 row in set (0.62 sec) while significantly less that yours, .62 seconds isn't too shabby... -Original Message- From: rt-user

Re: [rt-users] RT 3.8.8 - Can a superuser reset a users password?

2010-07-10 Thread Foggi, Nicola
hange. -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Kevin Falcone Sent: Sat 7/10/2010 3:17 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 3.8.8 - Can a superuser reset a users password? On Fri, Jul 09, 2010 at 09:22:58PM -0500, Foggi, Nicola

Re: [rt-users] RT 3.8.8 - Can a superuser reset a users password?

2010-07-09 Thread Foggi, Nicola
nevermind... just found the thread on the rt-devel list... http://www.gossamer-threads.com/lists/rt/devel/93818 Nicola -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Foggi, Nicola Sent: Fri 7/9/2010 9:22 PM To: rt-users@lists.bestpractical.com Subject

[rt-users] RT 3.8.8 - Can a superuser reset a users password?

2010-07-09 Thread Foggi, Nicola
Hey Everyone, So under 3.8.8 you need to know the old password for the user. If a user forgets the password, and an admin needs to reset it, it appears the admin has to also know the old password (as when i left it blank it told me to enter my current password). Maybe i'm missing something s

Re: [rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Foggi, Nicola
I did just have a problem with 3.8.8 and one of the indexes (didn't have the problem on 3.8.6 or below). It turned out to be the index GROUPS2 on the Groups table... dropped the index, and performance was back to normal (pre 3.8.8) Nicola -Original Message- From: rt-users-boun...@lis

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
--+---+ 4 rows in set (0.00 sec) Nicola -Original Message- From: ruslan.zaki...@gmail.com on behalf of Ruslan Zakirov Sent: Fri 6/25/2010 11:05 AM To: Foggi, Nicola Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] s

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
tell where it goes wrong, but any ideas on where to start? My guess is something around the "IncludeSystemRights" logic somewhere in WhoHaveRight or WhoHaveRoleRight? Nicola -Original Message- From: ruslan.zaki...@gmail.com on behalf of Ruslan Zakirov Sent: Fri 6/25/2010 11:05

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
not sure if this helps tracking it down... still having figured out what the Groups_3.Domain = 'RT::System-Role'... Nicola -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Foggi, Nicola Sent: Fri 6/25/2010 11:07 AM To: Ruslan Zakirov Cc: rt-users

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
ives the same results in under 1 second vs 11-12 seconds, but bot sure what that OR is adding into the mix. That query is what is performed when I display a ticket through the web interface. Any help is appreciated! Nicola -Original Message----- From: ruslan.zaki...@gmail.com on behal

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
pals_1.PrincipalType = 'User') AND ((Groups_3.Domain = 'RT::Queue-Ro le' AND Groups_3.Instance = '3') OR (Groups_3.Domain = 'RT::System-Role')) AND (Groups_3.Type = 'AdminCc') ORDER BY main.Name ASC; Is there a reason it's looking at 331467

[rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-24 Thread Foggi, Nicola
hey everyone, after upgrading from 3.8.6 to 3.8.8 we're getting a slow query on this query: use rt3; SELECT DISTINCT main.* FROM Users main JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principa

[rt-users] Ticket Status Change on Final Chained Approval

2010-03-23 Thread Foggi, Nicola
Hey Everyone, So we have implemented approvals under RT 3.8.6 basically to track and approval purchase requests. The request has to go through 2 levels of approvals, at which point i have it setup to email our purchasing department the information to complete the purchase. In researching how

Re: [rt-users] Approval Queue Approved/Rejected Templates and "Parent" Request Correspondence

2010-03-03 Thread Foggi, Nicola
ical.com Subject: Re: [rt-users] Approval Queue Approved/Rejected Templates and "Parent" Request Correspondence On Tue, Mar 02, 2010 at 11:33:24PM -0600, Foggi, Nicola wrote: >Hey Everyone, > >So we're utilizing approvals, and when an approver approvals or rejects

Re: [rt-users] Approval Queue Approved/Rejected Templates and "Parent"Request Correspondence

2010-03-02 Thread Foggi, Nicola
I should of mentioned it's 3.8.6... -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Foggi, Nicola Sent: Tue 3/2/2010 11:33 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Approval Queue Approved/Rejected Templates and "Pare

[rt-users] Approval Queue Approved/Rejected Templates and "Parent" Request Correspondence

2010-03-02 Thread Foggi, Nicola
Hey Everyone, So we're utilizing approvals, and when an approver approvals or rejects a request, the owner of the "parent" request gets double notifications. The first is from the templates: Approval Passed All Approvals Passed Approval Rejected the 2nd email is the fact that it puts the not

Re: [rt-users] ExternalAuth TLS to Active DirectoryLDAP_OPERATIONS_ERROR 1 on Bind

2009-11-18 Thread Foggi, Nicola
rt_tls command, but still nothing... Thoughts? Nicola -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Foggi, Nicola Sent: Wed 11/18/2009 1:41 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] ExternalAuth TLS to Active DirectoryLDAP_OPERATIONS_ERROR

[rt-users] ExternalAuth TLS to Active Directory LDAP_OPERATIONS_ERROR 1 on Bind

2009-11-18 Thread Foggi, Nicola
Hey Everyone, So I got the ExternalAuth module working to Active Directory NON TLS enabled, however, when I set it to use TLS I get a: LDAP_OPERATIONS_ERROR returned on the bind. I'm looking at ways to troubleshoot it, i have tls set to verify=>none so it shouldn't be a certificate problem,

[rt-users] RTx::WorkFlowBuilder Depends On Question

2009-11-17 Thread Foggi, Nicola
Hey Everyone, I'm working on setting up RTx::WorkFlowBuilder, I have the following in my RT_SiteConfig: Set($WorkflowBuilderStages, { 'approver1-approval' => { content => 'content', subject => 'Architect Approval for Request: {$Approving->Id} - {$Approvin

[rt-users] Upgrade from RT 3.8.4 to 3.8.6 Required Newer Mod_Perl 1.x under Apache 1.3.41

2009-11-05 Thread Foggi, Nicola
Just in case anyone else runs into this, not sure if it was supposed to be this way or not, but after upgrading to RT 3.8.6 from 3.8.4 we were getting an: [error] Can't call method "get" on an undefined value at /5.8.6/HTML/Mason/ApacheHandler.pm line 563.\nCompilation failed in require at /bi

[rt-users] Upgrade from RT 3.8.4 to 3.8.6 Required Newer Mod_Perl 1.x under Apache 1.3.41

2009-11-05 Thread Foggi, Nicola
Just in case anyone else runs into this, not sure if it was supposed to be this way or not, but after upgrading to RT 3.8.6 from 3.8.4 we were getting an: [error] Can't call method "get" on an undefined value at /5.8.6/HTML/Mason/ApacheHandler.pm line 563.\nCompilation failed in require at /bi

[rt-users] Approvals on 3.8.4 not going to ___Approvals Queue and Attachments

2009-11-03 Thread Foggi, Nicola
Hey Everyone, So I've been looking at ways to create approvals, and initially i created my own approval queue called po-approvals, created the template to create the approval ticket in it, that all worked, however, i wasn't getting notified of the pending approval (though i could see it waitin