Re: [rt-users] incoming mail lost after possible httpd crash
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jesse Vincent wrote: * Can rt-mailgate be configured not to drop the mail on the floor if the reception fails? I would like the mail delivery to be retried by the mail system. ..it should already be doing this. rt-mailgate only tells your MTA that it has dealt successfully with a message after the server comes back and says that it's written the message into the database. Ok, that's good to know. Off to check the mail configuration then... Cheers, Marcus -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAkrlW1UACgkQXjXn6TzcAQkQAACdEgnAEg7xngy1neX3FfpDr4hh Jd0AoJtXjO+ntb56YuGCLQnNErNzIiab =kMxt -END PGP SIGNATURE- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] new status
Hello, I added a new status validation_RS . I added this line in my RT_SiteConfig.pm : Set(@ActiveStatus, qw(new open validation_RS stalled)); It works : I see it on rt but I can't use it. When I try to change the ticket's status with this status, RT doesn't want : it tells me Bad value for status. Don't i forget to do something ? Thanks, -- Alexandre ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Searching on CF's not working with RT3.8.6
Sorry, my fault, there was a Tickets_Overlay_SQL.pm in the /opt/rt3/local/lib/RT folder with a line in it to replace __CurrentUserEmail__ with $self-CurrentUser-EmailAddress. -Original Message- From: Jesse Vincent [mailto:je...@bestpractical.com] Sent: 23 October 2009 18:02 To: Alex Young Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Searching on CF's not working with RT3.8.6 On Fri, Oct 23, 2009 at 10:47:02AM +0100, Alex Young wrote: We have just upgraded from 3.8.2 to 3.8.6 and everything has been fine, but we have ran into our first problem; when searching on custom fields it's ignoring the CF and returning all results. This is one of the searches we are trying: Queue = 'Client Support' AND Subject LIKE 'schedule' AND 'CF.{Client}' LIKE 'ClientName' AND 'CF.{Client category}' LIKE 'Core Client' Can you turn on database logging and capture the SQL RT is generating? (In an ideal world, you could also bring up a copy of your old 3.8.2 instance and do the same thing, but I understand how hard that is) -j ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] new status
On 10/26/2009 05:53 AM, Alexandre PIASER wrote: Hello, I added a new status validation_RS . I added this line in my RT_SiteConfig.pm : Set(@ActiveStatus, qw(new open validation_RS stalled)); It works : I see it on rt but I can't use it. When I try to change the ticket's status with this status, RT doesn't want : it tells me Bad value for status. Don't i forget to do something ? Thanks, It's too long - a status name is limited to 10 characters. Jeff Voskamp ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.8.x serious security issue with mixing sessions
On Friday 23 of October 2009, Jerrad Pierce wrote: A tool like the firefox developer toolbar is an easy way to do this. HTTPFox might be a good solution too. You can simply tell it to start tracking as you use RT, and stop it once you encounter the problem. Examine the results, debug, and or sanitize and share. Everyone experiencing the problem doesn't have to install the add-on, just someone who has the issue. Can I log session id here somehow? lib/RT/Interface/Web.pm: $RT::Logger-info(Successful login for @{[$ARGS-{user}]} from $ENV{'REMOTE_ADDR'}); So far it's like this: - user logged as A - suddently he becomes user B - he logged off and on as A again httpfox shows three session ids but I found only last one in sessions table and it was user A session. User B was logged in on it's own computer at that time but with totally different session id than three above (so I assume user A become user B with some old session of user B). Will try to get more information... -- Arkadiusz MiśkiewiczPLD/Linux Team arekm / maven.plhttp://ftp.pld-linux.org/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.8.x serious security issue with mixing sessions
On Mon, Oct 26, 2009 at 02:40:29PM +0200, Arkadiusz Miskiewicz wrote: On Friday 23 of October 2009, Jerrad Pierce wrote: A tool like the firefox developer toolbar is an easy way to do this. HTTPFox might be a good solution too. You can simply tell it to start tracking as you use RT, and stop it once you encounter the problem. Examine the results, debug, and or sanitize and share. Everyone experiencing the problem doesn't have to install the add-on, just someone who has the issue. Can I log session id here somehow? lib/RT/Interface/Web.pm: $RT::Logger-info(Successful login for @{[$ARGS-{user}]} from $ENV{'REMOTE_ADDR'}); There are two bits you want to log: * $session{_session_id} * the session cookie the user sent: in 3.8.6, look at LoadSessionFromCookie So far it's like this: - user logged as A - suddently he becomes user B - he logged off and on as A again httpfox shows three session ids but I found only last one in sessions table and it was user A session. Logging out should be clearing that B session, so that bit isn't too surprising.. User B was logged in on it's own computer at that time but with totally different session id than three above (so I assume user A become user B with some old session of user B). *nod* Has _anybody_ else been seeing this? With 3.8.6 or any other version of RT? Jesse ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.8.x serious security issue with mixing sessions
Hi, On Mon, Oct 26, 2009 at 14:58, Jesse Vincent je...@bestpractical.com wrote: User B was logged in on it's own computer at that time but with totally different session id than three above (so I assume user A become user B with some old session of user B). *nod* Has _anybody_ else been seeing this? With 3.8.6 or any other version of RT? I saw this issue a few times on RT 3.8.2 . However it doesn't happen often, and I can't think of a way to catch it. I believe, the issue appeared after we upgraded from 3.6.5 . -- Leonid Mamchenkov ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] hierarchical custom fields
the upgrade says this is optional. will the CFs still work the way they did if we upgraded to 3.8.6 and not use the hierarchical custom fields? will it break upgradability in the future? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT : Apache Resource Usage
On Mon, Oct 26, 2009 at 10:37:03AM +0530, Varun wrote: Hello Jesse Yeah your right infact we have more than 30 concurrently users using RT and I can't bring the number of Fastcgi processes less than 30. So I want to make sure that will recent version of RT i.e. 3.8 will work well as far as memory allocation is concerned and second thing I want to know is, Is it possible to upgrade my RT on production as well and preserving the customization and scrips we have placed over there. If not then what's the way to achieve this backup stuff on application side and to upgrade it also. Waiting for a valuable answer from your side. I can't really promise that your local changes to RT will work perfectly across an upgrade without auditing your code. If that's the sort of thing you're looking for, please contact me off list and we'll see about getting some sort of contract set up. Best, Jesse ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Reverse SquelchMailTo -- cc's hard-coded somewhere?
Hi, I'm running RT 3.4.5. I inherited it and had never worked with it before, and I don't know the extent to which it has been customized. I've searched the wiki and list archives, but can't find my issue mentioned. Basically, people are being cc'd on tickets when they shouldn't be. In our configuration, the default for the squelched addresses on a ticket is ON; in other words, you have to check the box if you don't want email sent to that address. Which is fine, but for some tickets, addresses appear in that list in the UI, even though they are not requestors, owners, admincc's, or cc's on the ticket. In the db, I see the SquelchMailTo Attribute records for those addresses on that ticket, but I can't discover where they come from or how they're created. It seems to correlate to particular queues, but I can't figure out how or where. Thanks for any insight, Michael Blakley Technical Support Manager Yesmail, Inc. http://www.yesmail.com/ Michael Blakley Technical Support Manager Yesmail, Inc. An infoUSA Company (NASDAQ: IUSA) 503-419-0617 Phone 503-896-6720 Mobile 503-241-4185 Fax mblak...@yesmail.com mailto:man...@yesmail.com Email www.yesmail.com http://www.yesmail.com Web 309 SW Sixth Avenue, Suite 900 Portland, OR 97204-1765 image001.gifimage002.gifimage003.gifimage004.gif___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] hierarchical custom fields
Can't say as to the future, but, for the present they continue to work as previously. I upgraded from 3.8.4 to 3.8.6 without them changing behavior. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of slamp slamp Sent: Monday, October 26, 2009 11:48 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] hierarchical custom fields the upgrade says this is optional. will the CFs still work the way they did if we upgraded to 3.8.6 and not use the hierarchical custom fields? will it break upgradability in the future? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com This e-mail message is intended only for the personal use of the recipient(s) named above. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the Hearst Service Center (cad...@hearstsc.com) immediately by email and delete the original message. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT-IR IP lookup slow
Hi, On 23.10.2009, at 20:36, Ruslan Zakirov wrote: Laas, This SQL is too heavy and incorrect, RT 3.8.6 has a fix. Upgrading to 3.8.6 seems to have fixed this issue - lookup IP is now fast again. Thank you. Best, Laas ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Reverse SquelchMailTo -- cc's hard-coded somewhere?
address. Which is fine, but for some tickets, addresses appear in that list in the UI, even though they are not requestors, owners, admincc’s, or cc’s on the ticket. In the db, I see the SquelchMailTo Attribute records for those addresses on that ticket, but I can’t discover where they come from or how they’re created. Check Configuration Queues ___ Watchers (or something like that)? -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Reverse SquelchMailTo -- cc's hard-coded somewhere?
That's what I needed. Thanks, Jerrad! mb -Original Message- From: Jerrad Pierce [mailto:jpie...@cambridgeenergyalliance.org] Sent: Monday, October 26, 2009 9:34 AM To: Blakley, Michael Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Reverse SquelchMailTo -- cc's hard-coded somewhere? address. Which is fine, but for some tickets, addresses appear in that list in the UI, even though they are not requestors, owners, admincc's, or cc's on the ticket. In the db, I see the SquelchMailTo Attribute records for those addresses on that ticket, but I can't discover where they come from or how they're created. Check Configuration Queues ___ Watchers (or something like that)? -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Patch for approvals
As I was trying to get approvals to work using the CreateTicket action and instructions found on the wiki, I encoutered a few problems: 1. AdminCcs of ___Approvals weren't notified, because the approval action only notified the owner. Of course, there can't be more than one owner, so getting approval from a few people doesn't work. 2. The notice of approval said that the script was approved by nobody, because there was no owner of the approval request. Using a normal change owner script didn't work, since the email was generated before the owner change would take effect. So I fixed that by (1) using Notify AdminCcs instead of Notify Owner, and (2) by changing the owner of the approval ticket, if it wasn't set. The patch after the fold. -- Mathieu Longtin 1-514-803-8977 diff -ur lib/RT/Approval/Rule/NewPending.pm local/lib/RT/Approval/Rule/NewPending.pm --- lib/RT/Approval/Rule/NewPending.pm 2009-08-10 14:45:44.0 -0400 +++ local/lib/RT/Approval/Rule/NewPending.pm2009-10-14 15:39:13.0 -0400 @@ -75,7 +75,8 @@ # first txn entry of the approval ticket local $self-{TransactionObj} = $to; -$self-RunScripAction('Notify Owner', 'New Pending Approval', @_); +$self-RunScripAction('Notify AdminCcs', 'New Pending Approval', @_); +#$self-RunScripAction('Notify Owner', 'New Pending Approval', @_); return; diff -ur lib/RT/Approval/Rule/Passed.pm local/lib/RT/Approval/Rule/Passed.pm --- lib/RT/Approval/Rule/Passed.pm 2009-08-10 14:45:44.0 -0400 +++ local/lib/RT/Approval/Rule/Passed.pm2009-10-15 13:52:37.0 -0400 @@ -63,6 +63,19 @@ sub Commit { my $self = shift; my $note; + +# Assign approval ticket to transaction creator, if it's not owned already +if ( $self-TicketObj-Owner == $RT::Nobody-id ) { + my $ActorObj = $self-TransactionObj-CreatorObj; + + $RT::Logger-info(Auto assigning ticket #.$self-TicketObj-id. to user . $ActorObj-Name); + my ($status, $msg) = $self-TicketObj-SetOwner( $ActorObj-id ); + unless( $status ) { + $RT::Logger-warning(Error assigning ticket #.$self-TicketObj-id. to .$ActorObj-Name.: .$msg); + return undef; + } +} + my $t = $self-TicketObj-Transactions; while ( my $o = $t-Next ) { diff -ur lib/RT/Approval/Rule/Rejected.pm local/lib/RT/Approval/Rule/Rejected.pm --- lib/RT/Approval/Rule/Rejected.pm2009-08-10 14:45:44.0 -0400 +++ local/lib/RT/Approval/Rule/Rejected.pm 2009-10-15 14:01:30.0 -0400 @@ -63,6 +63,19 @@ sub Commit {# XXX: from custom prepare code my $self = shift; + +# Assign approval ticket to transaction creator, if it's not owned already +if ( $self-TicketObj-Owner == $RT::Nobody-id ) { + my $ActorObj = $self-TransactionObj-CreatorObj; + + $RT::Logger-info(Auto assigning ticket #.$self-TicketObj-id. to user . $ActorObj-Name); + my ($status, $msg) = $self-TicketObj-SetOwner( $ActorObj-id ); + unless( $status ) { + $RT::Logger-warning(Error assigning ticket #.$self-TicketObj-id. to .$ActorObj-Name.: .$msg); + return undef; + } +} + if ( my ($rejected) = $self-TicketObj-AllDependedOnBy( Type = 'ticket' ) ) { my $note = ''; ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com