[rt-users] Insert Content From Main Ticket. Into the Content of the approval Tickets
Hi, I am required to allow users the ability to approve tickets via email. Which I have implemented and working. The only problem is how can they approve something when they don't know what the approval is about because they cant see the content of the Original Ticket. Is there a way of doing this? -- View this message in context: http://requesttracker.8502.n7.nabble.com/Insert-Content-From-Main-Ticket-Into-the-Content-of-the-approval-Tickets-tp58329.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Reply
I need some help I am using RT 4.2.3. The system has lost the ability to Reply to tickets. Nobody including root from any queue can use the reply to a ticket function. Can someone give me some direction as to where to look? Thanks Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 * 262-783-6261 ext. 2296 bba...@copesan.commailto:cstep...@copesan.com www.copesan.comhttp://www.copesan.com/ Servicing North America with Local Care -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Can't locate object method host
On 8/13/2014 8:33 PM, Alex Peters wrote:
What's your WebURL config setting as reported by RT's System
Configuration page?
It looks like that might be malformed.
WebBaseURL 'https://alms2.foo.com'
core config
WebDefaultStylesheet'rudder'
core config
WebDomain 'alms2.foo.com'
site config
WebFlushDbCacheEveryRequest 1
core config
WebHttpOnlyCookies 1
core config
WebImagesURL'/static/images/'
core config
WebNoAuthRegex qr/^ (?:\/+NoAuth\/ | \/+REST\/\d+\.\d+\/NoAuth\/) /x
core config
WebPath ''
core config
WebPort '443'
site config
WebRemoteUserContinuous 1
core config
WebSecureCookies0
core config
WebSessionProperties{}
core config
WebURL 'https://alms2.foo.com/'
core config
On 14/08/2014 10:06 am, Jeff Blaine jbla...@kickflop.net
mailto:jbla...@kickflop.net wrote:
On 8/13/2014 9:24 AM, Kevin Falcone wrote:
On Tue, Aug 12, 2014 at 12:32:18PM -0400, Jeff Blaine wrote:
I keep getting the following errors when using the web UI. Here's one
case just now where I logged in as root at https://alms2.foo.com/ and
was then immediately thrown an error:
[15332] [Tue Aug 12 15:55:24 2014] [info]: Successful login
for root
from 1xx.xx.x.165 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:816)
[15332] [Tue Aug 12 15:55:24 2014] [error]: Can't locate object
method host via package URI::_foreign at
/opt/rt4/sbin/../lib/RT/Interface/Web.pm line 935.
Visiting https://alms2.mitre.org/ shows I *did* login as root though.
Previously, Kevin Falcone had said:
This is RT trying to issue the redirect after login, what
URL did
you use to access RT and what was the next parameter.
I had replied:
I'm not sure what you mean by what was the next parameter.
Look at the code that calls Redirect (which is where your error comes
from).
https://github.com/bestpractical/rt-authen-externalauth/blob/master/html/Elements/DoAuth#L19
What's $next for your user that errors out.
You should also always turn on stacktraces when debugging something
like this.
-kevin
Thanks for the replies, Kevin and Alex P.
The installed URI version is 1.61.
Here's a login and the error it causes with stacktraces on.
Aug 13 19:58:31 alms2 RT: [27927] Successful login for root from
xxx.xx.0.231#012Trace begun at /opt/rt4/sbin
/../lib/RT.pm line
298#012Log::Dispatch::__ANON__('Log::Dispatch=HASH(0x1e0e6c8)',
'Successful login for root from xxx.xx.0.231') called at
/opt/rt4/sbin/../lib/RT/Interface/Web.pm line
816#012RT::Interface::Web::AttemptPasswordAuthentication('HASH(0x7485080)')
called at /opt/rt4/share/html/NoAuth/Login.html line
49#012HTML::Mason::Commands::__ANON__('pass', 'REDACTEDPASSWORD',
'next', '7809d15aff10a9764adc454707dbf271', 'user', 'root') called at
/usr/local/share/perl5/HTML/Mason/Component.pm line
138#012HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x759be50)',
'pass', 'REDACTEDPASSWORD', 'next', '7809d15aff10a9764adc454707dbf271',
'user', 'root') called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1305#012eval {...} at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1295#012HTML::Mason::Request::comp(undef, undef, undef, 'pass',
'REDACTEDPASSWORD', 'next', '7809d15aff10a9764adc454707dbf271', 'user',
'root') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line
600#012RT::Interface::Web::MaybeShowNoAuthPage('HASH(0x75fa250)') called
at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line
315#012RT::Interface::Web::HandleRequest('HASH(0x75fa250)') called at
/opt/rt4/share/html/autohandler line
53#012HTML::Mason::Commands::__ANON__('pass', 'REDACTEDPASSWORD',
'next', '7809d15aff10a9764adc454707dbf271', 'user', 'root') called at
/usr/local/share/perl5/HTML/Mason/Component.pm line
138#012HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x75d6f68)',
'pass', 'REDACTEDPASSWORD', 'next', '7809d15aff10a9764adc454707dbf271',
'user', 'root') called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1300#012eval {...} at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1295#012HTML::Mason::Request::comp(undef, undef, undef, 'pass',
'REDACTEDPASSWORD', 'next', '7809d15aff10a9764adc454707dbf271', 'user',
'root') called at /usr/local/share/perl5/HTML/Mason/Request.pm line
484#012eval {...} at /usr/local/share/perl5/HT
Aug 13 19:58:31 alms2 RT: [27927] Can't locate object method host via
package URI::_foreign at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line
935.#012#012Stack:#012
Re: [rt-users] Coredumps, traceback, etc : 4.2.6 and RT-Authen-ExternalAuth
On 08/01/2014 03:14 PM, Jeff Blaine wrote: RHEL 6.5 RT 4.2.6 RT-Authen-ExternalAuth 0.21 with SSL + TLS on. Using CPAN to install a more modern one, 1.65, results in httpd dumping core at restart time. A support customer recently reported this to us, with enough details to replicate it; I've released RT::Authen::ExternalAuth 0.23 which should address segfaults when run under mod_perl. The bottom line to the failure is that Plack, the tool that RT uses to be run identically under mod_perl, fast_cgi, and standalone, hides the fact that it is running under mod_perl during startup; this is because some modules act overzealously when they notice. Unfortunately, Net::SSLeay needs to know if it is running under mod_perl during server startup, or it fails to acquire the correct locks before initializing OpenSSL's global state. The fix is to not load Net::SSLeay during server startup; RT::Authen::ExternalAuth 0.23 removes the unnecessary $ExternalServiceUsesSSLorTLS option which did so. Fixing Plack to not hide the mod_perl nature of the server is a more complex project which we're still investigating, as it will solve the more general case of this problem. - Alex -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Mysql slowness with subject searches (possibly others)
I'm running RT 4.2.3 with mysql 5.1.71 on RHEL 6.5. This install has been solid for months, then yesterday we start having serious performance issues. We've spent the last two days looking at everything we can think of and still can't crack the problem. I'd appreciate any suggestions for things to investigate. Searches using text in the quick seach box take a very long time and multiple searches bring the whole of RT to a crawl. Subject searches in the searchbuilder show the same behaviour. Searching by ticket number, owner or fulltext (using sphinx) are fast. When things slow down I see very high mysql cpu usage, no io wait. Show processlist shows the thread in Copying to tmp table state. Here's a problematic query. It was the only thing running at this time, it's already taken 24 seconds. During bad times earlier today I saw queries still running after half an hour. | 17 | rt_user | localhost | rt3 | Query | 24 | Copying to tmp table | SELECT DISTINCT main.* FROM Tickets main JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Instance = main.id ) LEFT JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.MemberId = '38844' ) AND ( CachedGroupMembers_2.GroupId = Groups_1.id ) WHERE ( ( ( main.Queue = '3' OR main.Queue = '4' OR main.Queue = '5' OR main.Queue = '6' OR main.Queue = '7' OR main.Queue = '8' OR main.Queue = '9' OR main.Queue = '10' OR main.Queue = '10' OR main.Queue = '11' OR main.Queue = '11' OR main.Queue = '12' OR main.Queue = '12' OR main.Queue = '13' OR main.Queue = '13' OR main.Queue = '14' OR main.Queue = '14' OR main.Queue = '15' OR main.Queue = '16' OR main.Queue = '18' OR main.Queue = '18' OR main.Queue = '19' OR main.Queue = '20' OR main.Queue = '21' OR main.Queue = '21' OR main.Queue = '21' OR main.Queue = '22' OR main. Queue = '23' OR main.Queue = '24' OR main.Queue = '26' OR main.Queue = '29' OR main.Queue = '30' OR main.Queue = '31' OR main.Queue = '32' OR main.Queue = '36' OR main.Queue = '38' OR main.Queue = '44' OR main.Queue = '51' OR main.Queue = '54' OR main.Queue = '55' OR main.Queue = '56' OR main.Queue = '57' OR main.Queue = '58' OR main.Queue = '59' OR main.Queue = '60' OR main.Queue = '61' OR main.Queue = '62' OR main.Queue = '63' OR main.Queue = '64' OR main.Queue = '65' OR main.Queue = '66' OR main.Queue = '67' OR main.Queue = '68' OR main.Queue = '70' OR main.Queue = '72' OR main.Queue = '73' OR main.Queue = '75' OR main.Queue = '77' OR main.Queue = '81' OR main.Queue = '86' OR main.Queue = '87' OR main.Queue = '88' OR main.Queue = '89' OR main.Queue = '90' OR main.Queue = '91' OR main.Queue = '92' OR main.Queue = '93' OR main.Queue = '93' OR main.Queue = '94' OR main.Queue = '95' OR main.Queue = '96' OR main.Queue = '105' OR main.Queue = '106' OR main.Queue = '110' OR main .Queue = '115' OR main.Queue = '120' OR main.Queue = '124' OR main.Queue = '125' OR main.Queue = '128' OR main.Queue = '129' OR main.Queue = '138' OR main.Queue = '139' OR main.Queue = '141' OR main.Queue = '142' OR main.Queue = '148' OR main.Queue = '150' OR main.Queue = '153' OR main.Queue = '154' ) OR ( CachedGroupMembers_2.MemberId IS NOT NULL AND Groups_1.Name = 'Requestor' AND ( main.Queue = '17' OR main.Queue = '46' ) ) OR ( CachedGroupMembers_2.MemberId IS NOT NULL AND Groups_1.Name = 'Cc' AND main.Queue = '17' ) ) ) AND (main.IsMerged IS NULL) AND (main.Status != 'deleted') AND (main.Type = 'ticket') AND (main.Subject LIKE '%blah%') ORDER BY main.id DESC LIMIT 50 | Explain plan for above query: ++-+--++--++-+-+---+--+ | id | select_type | table| type | possible_keys | key| key_len | ref | rows | Extra| ++-+--++--++-+-+---+--+ | 1 | SIMPLE | Groups_1 | ref| groups1,groups2,groups3 | groups2| 67 | const | 40094 | Using where; Using index | | 1 | SIMPLE | CachedGroupMembers_2 | ref| DisGrouMem,CachedGroupMembers3,SHREDDER_CGM1 | DisGrouMem | 12 | rt3.Groups_1.id,const,const | 1 | Using index | | 1 | SIMPLE | main | eq_ref | PRIMARY,Tickets1 | PRIMARY| 4 | rt3.Groups_1.Instance | 1 | Using where | ++-+--++--++-+-+---+--+ my.cnf:
Re: [rt-users] Reply
Is anything showing up in the logs when you attempt to issue a reply, or is the ability to reply completely removed from the interface? What exactly is available and what occurs when you perform any relevant actions (e.g. when you click Update Ticket, if you even can)? On 14 August 2014 23:43, Bryon Baker bba...@copesan.com wrote: I need some help I am using RT 4.2.3. The system has lost the ability to Reply to tickets. Nobody including root from any queue can use the reply to a ticket function. Can someone give me some direction as to where to look? Thanks Bryon Baker Network Operations Manager *Copesan** - Specialists in Pest Solutions* 800-267-3726 • 262-783-6261 ext. 2296 bba...@copesan.com cstep...@copesan.com www.copesan.com *Servicing North America with Local Care* -- RT Training - Boston, September 9-10 http://bestpractical.com/training -- RT Training - Boston, September 9-10 http://bestpractical.com/training
