[rt-users] Get Queue CustomField value
Hello, I have a queue named AAA. Then there are a custum field for queues - SubUnit with values: a, b, c. Queue AAA has a value 'a' of SubUnit custom field. How can I extract that value? I want to use that value on scrip. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Get-Queue-CustomField-value-tp55642.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Update all tickets of queue
Hello, Is it posible with the help of scrip to do such thing: My Queue has a custom field and when you create a ticket in that queue, the ticket custom field is set by the value of queue custom field value. How can I change all queue tickets custom field value on Queue custom field value change? -- View this message in context: http://requesttracker.8502.n7.nabble.com/Update-all-tickets-of-queue-tp55643.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] Update all tickets of queue
Have you tried bulk update? Kenn Sent from my Windows Phone From: andkulb Sent: 10/29/2013 6:21 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] Update all tickets of queue Hello, Is it posible with the help of scrip to do such thing: My Queue has a custom field and when you create a ticket in that queue, the ticket custom field is set by the value of queue custom field value. How can I change all queue tickets custom field value on Queue custom field value change? -- View this message in context: http://requesttracker.8502.n7.nabble.com/Update-all-tickets-of-queue-tp55643.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] canonicalizing URI fsck.com?
FOr some of my users, I see meesages of this form in my rt.log: [Tue Oct 29 19:25:25 2013] [debug]: Canonicalizing URI '21' to 'fsck.com-rt://mydomain.com/ticket/21' (/u01/app/PROD/rt4-efts/sbin/../lib/RT/URI.pm:108) What's up with fsck.com? Did I misconfigure something back in the beginning? Can I get rid of the references to fsck.com? Can I get rid of the messages about canonicalizing the URI altogether? Thanks, Len. -- lenja...@jaffesystems.com 614-404-4214@lenjaffe Software Engineer, Founder Volunteerable http://www.volunteerable..com/, Host of Columbus Code Jam http://www.meetup.com/techlifecolumbus/ www.lenjaffe.com http://www.theycomewithcheese.com Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent Calendars: Perlish and otherwise.
Re: [rt-users] Restrictions and limitations on use of ReferrerWhitelist, RestrictReferrer, RestrictReferrer (cross-site request forgery warning message)
Hi .. . Date: Mon, 28 Oct 2013 12:20:42 -0400 From: Kevin Falcone falc...@bestpractical.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Restrictions and limitations on use of ReferrerWhitelist, RestrictReferrer, RestrictReferrer (cross-site request forgery warning message) Message-ID: 20131028162042.ga1...@jibsheet.com Content-Type: text/plain; charset=us-ascii On Sat, Oct 26, 2013 at 11:31:29PM -0700, Duncan Napier wrote: As for @ReferrerWhitelist, you'd have to show an actual error message to compare with the domains that you're whitelisting in order to know what's wrong. This is the preferred solution (white list the source of your ticket form submissions). -kevin OK ... thanks for clarification. I think my problem with the Whitelist is that I have whitespace in my $Organization name. The Apache error log shows [Fri Oct 25 20:03:48 2013] [error]: your $Organization setting (Another Company) appears to contain whitespace. Please fix this. (/usr/local/rt/sbin/../lib/RT/Config.pm:505) [Fri Oct 25 20:03:48 2013] [notice]: Possible CSRF: your browser did not supply a Referrer header (/usr/local/rt/sbin/../lib/RT/Interface/Web.pm:1458) Does Whitelist use $Organization as a reference/lookup? When I set RT up, using my domain didn't make much sense because MY domain is different from the organizational unit that I am supporting, so I put in the ACTUAL NAME of the the other organizational unit I support. I realize now that spaces in $Organization are not allowed in RT, but I have not had any problems up to now. I am prepared to change it if necessary and I have seen instructions on this list to do an $Organization search-and-replace in MySQL to preserve links. While this is an error, and will cause you problems in Linking and if you ever use Articles, it is unrelated to your CSRF problem. I actually meant the error message printed in the browser for the end user. Normally when linking from an external form, it will say 'invalid referred' for the host of the external form. However, if you're getting no Referrer, why is that? -kevin The error in the browser is RT has detected a possible cross-site request forgery for this request, because your browser did not supply a Referrer header. A malicious attacker may be trying to create a ticket on your behalf. If you did not initiate this request, then you should alert your security team. If you really intended to visit /Ticket/Create.html and create a ticket, then click here to resume your request. Clicking on the link here to resume your request sends the user to the ticket creation page. I have done some research and apparently referrer headers are turned on and off in the browser. There are options to enable/diable referer headers in various browsers, but that doesn't make much sense from an organizational standpoint to ask hundreds of users to configure their browser settings. So I have no idea how whitelisting gets around this issue. Anyway, I have figured out how to do what I need (namely to allow non-privileged users to create a SelfService ticket) with Set($RestrictReferrer, '0') and simply changing the direct link I was using http://server-alias1.example.com/Ticket/Create.html?Queue=12Subject=Computer%20Setup%20Request... to http://support1.mbb.sfu.ca/SelfService/Create.html?Queue=12Subject=Computer%20Setup%20Request... Thanks for all you help! Duncan.
[rt-users] Upgraded 3.8.8 - 4.2.0, IE issues
I just upgraded from 3.8.8 to 4.2.0, and we're having some difficulty with Internet Explorer. It seems it is unable to submit forms except for the Jumbo form. There's no errors, it just redisplays the page. This is manifesting in a number of forms including the actions comment and reply, when trying to save user preferences, when clicking Add these terms and Search in the search builder, and so forth. The only thing that works for commenting and replying is to use the Jumbo form, which is far from ideal. I've tried a number of things like turning off the CKeditor, disabling extensions, changing Internet Explorer options and settings, and I haven't come across the magic yet. Has anyone else experienced this and knows what the issue is? Googling has not been fortuitous, either. -- Tom Lahti t...@dmsolutions.com This e-mail message is confidential and is intended solely for the use of the addressee(s) named above. If you are not the intended recipient, or the person responsible to deliver it to the recipient, you are hereby advised that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify the sender by return e-mail. Thank you.
Re: [rt-users] Upgraded 3.8.8 - 4.2.0, IE issues
Tom -- I have also experienced this issue along with the previously communicated broken email issues, both of which are blocking a 4.2.0 upgrade in our environment. No resolution on either, yet. - Cory -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Tom Lahti Sent: Tuesday, October 29, 2013 4:43 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Upgraded 3.8.8 - 4.2.0, IE issues I just upgraded from 3.8.8 to 4.2.0, and we're having some difficulty with Internet Explorer. It seems it is unable to submit forms except for the Jumbo form. There's no errors, it just redisplays the page. This is manifesting in a number of forms including the actions comment and reply, when trying to save user preferences, when clicking Add these terms and Search in the search builder, and so forth. The only thing that works for commenting and replying is to use the Jumbo form, which is far from ideal. I've tried a number of things like turning off the CKeditor, disabling extensions, changing Internet Explorer options and settings, and I haven't come across the magic yet. Has anyone else experienced this and knows what the issue is? Googling has not been fortuitous, either. -- Tom Lahti t...@dmsolutions.com This e-mail message is confidential and is intended solely for the use of the addressee(s) named above. If you are not the intended recipient, or the person responsible to deliver it to the recipient, you are hereby advised that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify the sender by return e-mail. Thank you.
Re: [rt-users] Upgraded 3.8.8 - 4.2.0, IE issues
I was sent a patch for this at one point, and was told the fix is coming in 4.2.1. IIRC, the problem is in /opt/rt4/share/static/js/forms.js (or where ever you have RT installed at). I can't remember which line needs to change, but here's what mine looks like: jQuery(function() { jQuery('form').submit(function() { jQuery(this).find('input[type=submit]').attr('disabled','disabled'); return true; }) jQuery('input[type=submit]').click(function() { var $this = jQuery(this); var name = $this.attr('name'); if (!name) { return true; } $this.after( jQuery('input/', {type: hidden, name: name, value: $this.val()} ) ); return true; }) }); -Tyler Sweet On 10/29/2013 at 3:54 PM, in message 19ae285f8495424fa7af79f7ccca6b8726bc3...@embx-clft2.cdc.gov, Wright, Cory (CDC/OID/NCIRD) (CTR) w...@cdc.gov wrote: Tom -- I have also experienced this issue along with the previously communicated broken email issues, both of which are blocking a 4.2.0 upgrade in our environment. No resolution on either, yet. - Cory -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Tom Lahti Sent: Tuesday, October 29, 2013 4:43 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Upgraded 3.8.8 - 4.2.0, IE issues I just upgraded from 3.8.8 to 4.2.0, and we're having some difficulty with Internet Explorer. It seems it is unable to submit forms except for the Jumbo form. There's no errors, it just redisplays the page. This is manifesting in a number of forms including the actions comment and reply, when trying to save user preferences, when clicking Add these terms and Search in the search builder, and so forth. The only thing that works for commenting and replying is to use the Jumbo form, which is far from ideal. I've tried a number of things like turning off the CKeditor, disabling extensions, changing Internet Explorer options and settings, and I haven't come across the magic yet. Has anyone else experienced this and knows what the issue is? Googling has not been fortuitous, either. -- Tom Lahti t...@dmsolutions.com This e-mail message is confidential and is intended solely for the use of the addressee(s) named above. If you are not the intended recipient, or the person responsible to deliver it to the recipient, you are hereby advised that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify the sender by return e-mail. Thank you. THIS MESSAGE AND ACCOMPANYING DOCUMENTS ARE COVERED BY THE ELECTRONIC COMMUNICATIONS PRIVACY ACT, 18 U.S.C. §§ 2510-2521, AS AMENDED, AND CONTAINS INFORMATION INTENDED FOR THE SPECIFIED INDIVIDUAL(S) ONLY. THIS INFORMATION IS CONFIDENTIAL. IF YOU ARE NOT THE INTENDED RECIPIENT OR AN AGENT RESPONSIBLE FOR DELIVERING IT TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT YOU HAVE RECEIVED THIS DOCUMENT IN ERROR AND THAT ANY REVIEW, DISSEMINATION, COPYING, OR THE TAKING OF ANY ACTION BASED ON THE CONTENTS OF THIS INFORMATION IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY US IMMEDIATELY BY E-MAIL, AND DELETE THE ORIGINAL MESSAGE. IN AN EFFORT TO PROTECT PRIVATE CONSUMER INFORMATION AND TO MAINTAIN STRICT COMPLIANCE WITH THE HEALTH INSURANCE PORTABILITY AND ACCOUNTABILITY ACT (HIPAA), P.L.104-191, AS AMENDED AND THE GRAMM-LEACH-BLILEY ACT (GLBA), P.L.106-102, CBE COMPANIES, INC., AND ALL OF ITS SUBSIDIARIES AND AFFILIATES, DOES NOT SEND AND ENCOURAGES OTHERS NOT TO SEND NONPUBLIC PERSONAL INFORMATION (NPI) OR PERSONAL HEALTH INFORMATION (PHI) VIA UNSECURED E-MAIL.
Re: [rt-users] Upgraded 3.8.8 - 4.2.0, IE issues
Ah, sorry for the double-post. I found the message here: http://lists.bestpractical.com/pipermail/rt-users/2013-October/081725.html On 10/29/2013 at 3:58 PM, in message 526fdb3b022c0002b...@iris.cbe.com, Tyler Sweet tbsw...@cbecompanies.com wrote: I was sent a patch for this at one point, and was told the fix is coming in 4.2.1. IIRC, the problem is in /opt/rt4/share/static/js/forms.js (or where ever you have RT installed at). I can't remember which line needs to change, but here's what mine looks like: jQuery(function() { jQuery('form').submit(function() { jQuery(this).find('input[type=submit]').attr('disabled','disabled'); return true; }) jQuery('input[type=submit]').click(function() { var $this = jQuery(this); var name = $this.attr('name'); if (!name) { return true; } $this.after( jQuery('input/', {type: hidden, name: name, value: $this.val()} ) ); return true; }) }); -Tyler Sweet On 10/29/2013 at 3:54 PM, in message 19ae285f8495424fa7af79f7ccca6b8726bc3...@embx-clft2.cdc.gov, Wright, Cory (CDC/OID/NCIRD) (CTR) w...@cdc.gov wrote: Tom -- I have also experienced this issue along with the previously communicated broken email issues, both of which are blocking a 4.2.0 upgrade in our environment. No resolution on either, yet. - Cory -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Tom Lahti Sent: Tuesday, October 29, 2013 4:43 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Upgraded 3.8.8 - 4.2.0, IE issues I just upgraded from 3.8.8 to 4.2.0, and we're having some difficulty with Internet Explorer. It seems it is unable to submit forms except for the Jumbo form. There's no errors, it just redisplays the page. This is manifesting in a number of forms including the actions comment and reply, when trying to save user preferences, when clicking Add these terms and Search in the search builder, and so forth. The only thing that works for commenting and replying is to use the Jumbo form, which is far from ideal. I've tried a number of things like turning off the CKeditor, disabling extensions, changing Internet Explorer options and settings, and I haven't come across the magic yet. Has anyone else experienced this and knows what the issue is? Googling has not been fortuitous, either. -- Tom Lahti t...@dmsolutions.com This e-mail message is confidential and is intended solely for the use of the addressee(s) named above. If you are not the intended recipient, or the person responsible to deliver it to the recipient, you are hereby advised that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify the sender by return e-mail. Thank you. THIS MESSAGE AND ACCOMPANYING DOCUMENTS ARE COVERED BY THE ELECTRONIC COMMUNICATIONS PRIVACY ACT, 18 U.S.C. §§ 2510-2521, AS AMENDED, AND CONTAINS INFORMATION INTENDED FOR THE SPECIFIED INDIVIDUAL(S) ONLY. THIS INFORMATION IS CONFIDENTIAL. IF YOU ARE NOT THE INTENDED RECIPIENT OR AN AGENT RESPONSIBLE FOR DELIVERING IT TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT YOU HAVE RECEIVED THIS DOCUMENT IN ERROR AND THAT ANY REVIEW, DISSEMINATION, COPYING, OR THE TAKING OF ANY ACTION BASED ON THE CONTENTS OF THIS INFORMATION IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY US IMMEDIATELY BY E-MAIL, AND DELETE THE ORIGINAL MESSAGE. IN AN EFFORT TO PROTECT PRIVATE CONSUMER INFORMATION AND TO MAINTAIN STRICT COMPLIANCE WITH THE HEALTH INSURANCE PORTABILITY AND ACCOUNTABILITY ACT (HIPAA), P.L.104-191, AS AMENDED AND THE GRAMM-LEACH-BLILEY ACT (GLBA), P.L.106-102, CBE COMPANIES, INC., AND ALL OF ITS SUBSIDIARIES AND AFFILIATES, DOES NOT SEND AND ENCOURAGES OTHERS NOT TO SEND NONPUBLIC PERSONAL INFORMATION (NPI) OR PERSONAL HEALTH INFORMATION (PHI) VIA UNSECURED E-MAIL.
Re: [rt-users] Upgraded 3.8.8 - 4.2.0, IE issues
On 10/29/2013 1:58 PM, Tyler Sweet wrote: I was sent a patch for this at one point, and was told the fix is coming in 4.2.1. IIRC, the problem is in /opt/rt4/share/static/js/forms.js (or where ever you have RT installed at). I can't remember which line needs to change, but here's what mine looks like: jQuery(function() { jQuery('form').submit(function() { jQuery(this).find('input[type=submit]').attr('disabled','disabled'); return true; }) jQuery('input[type=submit]').click(function() { var $this = jQuery(this); var name = $this.attr('name'); if (!name) { return true; } $this.after( jQuery('input/', {type: hidden, name: name, value: $this.val()} ) ); return true; }) }); -Tyler Sweet Yes, that does indeed fix the issue for us. For the record, its just changing $this.append to $this.after. -- Tom This e-mail message is confidential and is intended solely for the use of the addressee(s) named above. If you are not the intended recipient, or the person responsible to deliver it to the recipient, you are hereby advised that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify the sender by return e-mail. Thank you.
Re: [rt-users] Upgrading 4.0.8 - 4.2.0 breaking outgoing email
After some further troubleshooting I have determined that email from the upgraded 4.2.0 instance is in fact working (testing with dashboard subs), but that no scrips execute. The bulk of errors in my debug log are: [6973] [Tue Oct 29 21:24:15 2013] [warning]: DBD::mysql::st execute failed: 'rt_helpdesk_420.main.Name' isn't in GROUP BY at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 589. (/usr/local/share/perl5/ DBIx/SearchBuilder/Handle.pm:589) [6973] [Tue Oct 29 21:24:15 2013] [warning]: RT::Handle=HASH(0x7fd5eea7f588) couldn't execute the query 'SELECT main.* FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields _1.CustomField = main.id ) WHERE (ObjectCustomFields_1.ObjectId = '1' OR ObjectCustomFields_1.ObjectId = '0') AND (main.Disabled = '0') AND (main.LookupType = 'RT::Queue-RT::Ticket') AND (main.id = '0') GROUP BY main.id ORDER BY MIN(ObjectCustomFields_1.SortOrder) ASC ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 602. I am unable to determine the impact of these warnings or if they are the culprit. Full log can also be seen in previous communication. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Wright, Cory (CDC/OID/NCIRD) (CTR) Sent: Monday, October 28, 2013 12:17 PM To: 'Alex Vandiver' Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrading 4.0.8 - 4.2.0 breaking outgoing email DBIx::SearchBuilder 1.65/usr/local/share/perl5/DBIx/SearchBuilder.pm make testdeps indicated no problems, nor did make upgrade-database. J. Cory Wright, RHCE | SRA Contractor | Mobile: 404-268-3402 | Email: nextgensupp...@cdc.govmailto:nextgensupp...@cdc.gov | Ticket: scicompsupp...@mail.biotech.cdc.govmailto:scicompsupp...@mail.biotech.cdc.gov -Original Message- From: Alex Vandiver [mailto:ale...@bestpractical.com] Sent: Monday, October 28, 2013 12:10 PM To: Wright, Cory (CDC/OID/NCIRD) (CTR) Cc: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com Subject: RE: [rt-users] Upgrading 4.0.8 - 4.2.0 breaking outgoing email On Mon, 2013-10-28 at 12:58 +, Wright, Cory (CDC/OID/NCIRD) (CTR) wrote: Thanks Alex -- what's attached is me logging in and performing one correspond in which I expect an email. Hostnames/IPs/db names have been anonymized. Your logs are chock full of SQL statement execution errors, which should have been difficult to miss. Double-check that you have the sufficient version for all of RT's dependencies. Specifically, what version of DBIx::SearchBuilder are you running? You can determine this by going to Admin → Tools → System Configuration, and searching for DBIx::SearchBuilder in the Loaded perl modules section. - Alex