Re: [rt-users] Scrip to automatically set Owner based on a Custom Field
On Thu, Oct 29, 2009 at 04:50:47PM -0700, jrummel wrote: Hi everyone, I have a select-one Custom Field called Product with 5 products in it. Based on what product is selected (on create), I would like a specific user to be set as the Owner (ex: ticket is created with Product A selected, so John Smith works on Product A, thus should automatically be the Owner). Does anyone know the what my Custom Action would look like to accomplish this? You should use two customfields, one ticket customfield used to set the product for the ticket, another _user_ customfield to set the list of product a user works on in the user profile. Then your action will compare those values and set the owner. Here is a not tested code to help you: my $Ticket = $self-TicketObj; # Get products selected for this ticket my $T_product = $Ticket-FirstCustomFieldValue ( 'Product' ); # Try to find a User with this product my $user_found = undef; my $Users = RT::Users-new ( $RT::SystemUser ); while ( my $User = $Users-Next () ) { my $U_products = $User-CustomFieldValues ( 'Products' ); while ( my $product = $U_products-Next ) { if ( $product-Content eq $T_product ) { $user_found = $User; last; } } } if ( $user_found $user_found-Id ) { $RT::Logger-debug(User .$user_found-Name. found for product .$T_product. Ticket .$Ticket-Id ); $Ticket-SetOwner( $user_found ); } else { return 0; } return 1; ___ 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] Scrip to automatically set Owner based on a Custom Field
I did something similar. If the custom field had a particular value, then the owner had to be a particular user. I did it using this scrip: Custom condition: if ($self-TransactionObj-Type eq 'Create' $self-TicketObj-FirstCustomFieldValue('Product') eq 'Product A') { return 1; } return 0; Custom Action: $self-TicketObj-SetOwner('John Smith'); return 1; Hope it helps, Carlos Emmanuel Lacour wrote: On Thu, Oct 29, 2009 at 04:50:47PM -0700, jrummel wrote: Hi everyone, I have a select-one Custom Field called Product with 5 products in it. Based on what product is selected (on create), I would like a specific user to be set as the Owner (ex: ticket is created with Product A selected, so John Smith works on Product A, thus should automatically be the Owner). Does anyone know the what my Custom Action would look like to accomplish this? You should use two customfields, one ticket customfield used to set the product for the ticket, another _user_ customfield to set the list of product a user works on in the user profile. Then your action will compare those values and set the owner. Here is a not tested code to help you: my $Ticket = $self-TicketObj; # Get products selected for this ticket my $T_product = $Ticket-FirstCustomFieldValue ( 'Product' ); # Try to find a User with this product my $user_found = undef; my $Users = RT::Users-new ( $RT::SystemUser ); while ( my $User = $Users-Next () ) { my $U_products = $User-CustomFieldValues ( 'Products' ); while ( my $product = $U_products-Next ) { if ( $product-Content eq $T_product ) { $user_found = $User; last; } } } if ( $user_found $user_found-Id ) { $RT::Logger-debug(User .$user_found-Name. found for product .$T_product. Ticket .$Ticket-Id ); $Ticket-SetOwner( $user_found ); } else { return 0; } return 1; ___ 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 -- ___ ___ | __ __ | Carlos García MontoroIngeniero Informático |_\_Y_/_| Instituto de Física Corpuscular Centro Mixto CSIC - UV |\_] [_/| Servicios Informáticos | [_] | Edificio Institutos de Investigacióncgar...@ific.uv.es |C S I C| Apartado de Correos 22085 E-46071 Valencia Tel: +34 963543706 |___| España / Spain Fax: +34 963543488 attachment: cgarcia.vcf___ 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] Billing for RT customer service.
Hi Todd, We've taken to reporting against the RT database directly. We use custom fields to track the customer, project, billing status, invoice number, etc. Works well. Good luck, Andy Todd Chapman wrote: Hi all, We use RT to perform customer service for our client. RT doesn't really have a good way for us to get the numbers we need to bill our clients. It's easy to get the number of tickets handled, but getting the number of emails sent external (to consumers) during a given time period seems to be pretty difficult (and I have a fair amount of experience with the RT API). Any advice on getting this data? Thanks! -Todd -- === xforty technologies Andrew Libby ali...@xforty.com http://xforty.com === ___ 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 [SOLVED I think!]
On Friday 23 of October 2009, Arkadiusz Miskiewicz wrote: On Friday 23 of October 2009, Jesse Vincent wrote: I don't think I've ever seen this wtih RT, but I have seen it with other applications - the cause is _usually_ an HTTP proxy that's caching RT's pages. Do you have any sort of HTTP proxy between your browsers and your server? No proxy. Also rt is served over https. There is no proxy but apache serving rt had mod_cache module installed which turns out to be caching cookies! Nightmare to track. Uninstalled and so far everything is working nicely. Now the question is can anything be done on rt level to prevent mod_cache from cacheing such stuff and actually creating security issues? ps. issues.apache.org is full of weird mod_cache related things -jesse -- 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] Scrip to automatically set Owner based on a Custom Field
Jrummel, We do this for our queue that reviews requests. Based on the Org code, we set the owner for the person best suited to evaluate tickets for that organization. This is our code: # # Custom action Preparation Code: # # # set new ticket owner id value # #42 - Frank # 148 - Bob # 5125 - Sally # 9324 - Roberta # 73886 - Ted # my %orgs = qw( Budget-Direct 148 Budget-Indirect 148 Controller-AP 5125 Controller-AR 73886 Controller-GA 148 Controller-PR 42 Facilities 42 Field OPS 42 OCFO-Other 42 Procurement 9324 Property9324 SPO 73886 Travel 5125 Other 42 ); my $cf = new RT::CustomField($RT::SystemUser); $cf-LoadByName(Queue = $ticket-QueueObj-id,Name = CFO-Org); return 0 unless $cf-id; my $cfvalue = $ticket-FirstCustomFieldValue('CFO-Org'); my $ownerid = $orgs{$cfvalue}; # set Ticket Due date Owner ID $ticket-SetOwner($ownerid); return 1; # # Custom action Cleanup Code: # return 1; I hope this helps. Kenn LBNL On 10/29/2009 4:50 PM, jrummel wrote: Hi everyone, I have a select-one Custom Field called Product with 5 products in it. Based on what product is selected (on create), I would like a specific user to be set as the Owner (ex: ticket is created with Product A selected, so John Smith works on Product A, thus should automatically be the Owner). Does anyone know the what my Custom Action would look like to accomplish this? Thanks! ___ 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] change location of attachments in RT 3.4.5?
On Thu, Oct 29, 2009 at 11:20 PM, Jesse Vincent je...@bestpractical.comwrote: RT 1.0.x was the last version of RT to store attachments on the filesystem. We're working on an RTx for a client that _might_ end up getting released which would let you do this for RT 3.8. But it's not something I can put a date on. I think I know who the client is because I used to work for them. Well, at the very least we were paying BP to implement similar functionality. :-) Drew ___ 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] Scrip to automatically set Owner based on a Custom Field
Thank you all so much for your time. I got it to work! Expanding on it further: Say I have 40 products, and 5 users. Each of these 5 users works on more than one product. Would I then have to make 5 different scrips with OR statements in them? Ideally, I would like to be able to add a column to the CustomFieldValues table containing a value of 1-5. Then make a small table called UserOwner or something with 2 columns: one column with values 1-5 called id (relating to the added column in CustomFieldValues), and one column with usernames called Name. I guess that's a long way of asking if there is a way to accomplish this in 1 scrip by way of an SQL statement? Hopefully I explained that somewhat coherently. Thanks again! Carlos Garcia Montoro wrote: I did something similar. If the custom field had a particular value, then the owner had to be a particular user. I did it using this scrip: Custom condition: if ($self-TransactionObj-Type eq 'Create' $self-TicketObj-FirstCustomFieldValue('Product') eq 'Product A') { return 1; } return 0; Custom Action: $self-TicketObj-SetOwner('John Smith'); return 1; Hope it helps, Carlos Emmanuel Lacour wrote: On Thu, Oct 29, 2009 at 04:50:47PM -0700, jrummel wrote: Hi everyone, I have a select-one Custom Field called Product with 5 products in it. Based on what product is selected (on create), I would like a specific user to be set as the Owner (ex: ticket is created with Product A selected, so John Smith works on Product A, thus should automatically be the Owner). Does anyone know the what my Custom Action would look like to accomplish this? You should use two customfields, one ticket customfield used to set the product for the ticket, another _user_ customfield to set the list of product a user works on in the user profile. Then your action will compare those values and set the owner. Here is a not tested code to help you: my $Ticket = $self-TicketObj; # Get products selected for this ticket my $T_product = $Ticket-FirstCustomFieldValue ( 'Product' ); # Try to find a User with this product my $user_found = undef; my $Users = RT::Users-new ( $RT::SystemUser ); while ( my $User = $Users-Next () ) { my $U_products = $User-CustomFieldValues ( 'Products' ); while ( my $product = $U_products-Next ) { if ( $product-Content eq $T_product ) { $user_found = $User; last; } } } if ( $user_found $user_found-Id ) { $RT::Logger-debug(User .$user_found-Name. found for product .$T_product. Ticket .$Ticket-Id ); $Ticket-SetOwner( $user_found ); } else { return 0; } return 1; ___ 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 -- ___ ___ | __ __ | Carlos García MontoroIngeniero Informático |_\_Y_/_| Instituto de Física Corpuscular Centro Mixto CSIC - UV |\_] [_/| Servicios Informáticos | [_] | Edificio Institutos de Investigacióncgar...@ific.uv.es |C S I C| Apartado de Correos 22085 E-46071 Valencia Tel: +34 963543706 |___| España / Spain Fax: +34 963543488 begin:vcard fn;quoted-printable:Carlos Garc=C3=ADa Montoro n;quoted-printable:Garc=C3=ADa Montoro;Carlos org;quoted-printable;quoted-printable:Instituto de F=C3=ADsica Corpuscular;Servicios Inform=C3=A1ticos adr;quoted-printable:Apartado de Correos 22085;;Edificio Institutos de Investigaci=C3=B3n;Valencia;Valencia;E-46071;Spain email;internet:carlos.gar...@ific.uv.es tel;work:(+34) 96 354 37 06 x-mozilla-html:TRUE version:2.1 end:vcard ___ 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 -- View this message in context: http://old.nabble.com/Scrip-to-automatically-set-Owner-based-on-a-Custom-Field-tp26122827p26135648.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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 [SOLVED I think!]
On Fri, Oct 30, 2009 at 03:13:33PM +0100, Arkadiusz Miskiewicz wrote: On Friday 23 of October 2009, Arkadiusz Miskiewicz wrote: On Friday 23 of October 2009, Jesse Vincent wrote: I don't think I've ever seen this wtih RT, but I have seen it with other applications - the cause is _usually_ an HTTP proxy that's caching RT's pages. Do you have any sort of HTTP proxy between your browsers and your server? No proxy. Also rt is served over https. There is no proxy but apache serving rt had mod_cache module installed which turns out to be caching cookies! Nightmare to track. Uninstalled and so far everything is working nicely. Now the question is can anything be done on rt level to prevent mod_cache from cacheing such stuff and actually creating security issues? Well, what does mod_cache need to know not to cache requests? ps. issues.apache.org is full of weird mod_cache related things -jesse -- 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] Scrip to automatically set Owner based on a Custom Field
Jrummel, Again, look at the code I sent you. In it you have on a few users working on more than one ORG code. Set up a qw( ...) with your values and you're set. Kenn LBNL On 10/30/2009 12:23 PM, jrummel wrote: Thank you all so much for your time. I got it to work! Expanding on it further: Say I have 40 products, and 5 users. Each of these 5 users works on more than one product. Would I then have to make 5 different scrips with OR statements in them? Ideally, I would like to be able to add a column to the CustomFieldValues table containing a value of 1-5. Then make a small table called UserOwner or something with 2 columns: one column with values 1-5 called id (relating to the added column in CustomFieldValues), and one column with usernames called Name. I guess that's a long way of asking if there is a way to accomplish this in 1 scrip by way of an SQL statement? Hopefully I explained that somewhat coherently. Thanks again! Carlos Garcia Montoro wrote: I did something similar. If the custom field had a particular value, then the owner had to be a particular user. I did it using this scrip: Custom condition: if ($self-TransactionObj-Type eq 'Create' $self-TicketObj-FirstCustomFieldValue('Product') eq 'Product A') { return 1; } return 0; Custom Action: $self-TicketObj-SetOwner('John Smith'); return 1; Hope it helps, Carlos Emmanuel Lacour wrote: On Thu, Oct 29, 2009 at 04:50:47PM -0700, jrummel wrote: Hi everyone, I have a select-one Custom Field called Product with 5 products in it. Based on what product is selected (on create), I would like a specific user to be set as the Owner (ex: ticket is created with Product A selected, so John Smith works on Product A, thus should automatically be the Owner). Does anyone know the what my Custom Action would look like to accomplish this? You should use two customfields, one ticket customfield used to set the product for the ticket, another _user_ customfield to set the list of product a user works on in the user profile. Then your action will compare those values and set the owner. Here is a not tested code to help you: my $Ticket = $self-TicketObj; # Get products selected for this ticket my $T_product = $Ticket-FirstCustomFieldValue ( 'Product' ); # Try to find a User with this product my $user_found = undef; my $Users = RT::Users-new ( $RT::SystemUser ); while ( my $User = $Users-Next () ) { my $U_products = $User-CustomFieldValues ( 'Products' ); while ( my $product = $U_products-Next ) { if ( $product-Content eq $T_product ) { $user_found = $User; last; } } } if ( $user_found $user_found-Id ) { $RT::Logger-debug(User .$user_found-Name. found for product .$T_product. Ticket .$Ticket-Id ); $Ticket-SetOwner( $user_found ); } else { return 0; } return 1; ___ 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 -- ___ ___ | __ __ | Carlos García MontoroIngeniero Informático |_\_Y_/_| Instituto de Física Corpuscular Centro Mixto CSIC - UV |\_] [_/| Servicios Informáticos | [_] | Edificio Institutos de Investigacióncgar...@ific.uv.es |C S I C| Apartado de Correos 22085 E-46071 Valencia Tel: +34 963543706 |___| España / Spain Fax: +34 963543488 begin:vcard fn;quoted-printable:Carlos Garc=C3=ADa Montoro n;quoted-printable:Garc=C3=ADa Montoro;Carlos org;quoted-printable;quoted-printable:Instituto de F=C3=ADsica Corpuscular;Servicios Inform=C3=A1ticos adr;quoted-printable:Apartado de Correos 22085;;Edificio Institutos de Investigaci=C3=B3n;Valencia;Valencia;E-46071;Spain email;internet:carlos.gar...@ific.uv.es tel;work:(+34) 96 354 37 06 x-mozilla-html:TRUE version:2.1 end:vcard ___ 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 ___ 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] Unable to Upgrade RT 3.6.6 to 3.8.x using MySQL 5.0.77 and provided database upgrade scripts
Hello all, I'm having quite the time upgrading RT from 3.6.6 to the last version. I am following the readme and upgrading.mysql docs. ./configure runs fine Make testdeps and fixdeps were also successful Make upgrade ran with no errors Coming up on the section about upgrading the database to 3.7.87 prior to executing the SQL schema as detailed in the upgrading.mysql doc: [r...@help01 rt-3.8.6]# ./sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Name: rt3 User: rt_user DBA:root Enter RT version you're upgrading from: 3.6.6 Going to apply following upgrades: * 3.7.1 * 3.7.3 * 3.7.10 * 3.7.15 * 3.7.19 * 3.7.81 * 3.7.82 * 3.7.85 * 3.7.86 * 3.7.87 * 3.8.0 * 3.8.1 * 3.8.2 * 3.8.3 * 3.8.4 * 3.8.6 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: 3.7.87 Going to apply following upgrades: * 3.7.1 * 3.7.3 * 3.7.10 * 3.7.15 * 3.7.19 * 3.7.81 * 3.7.82 * 3.7.85 * 3.7.86 * 3.7.87 IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP Proceed [y/N]:y Processing 3.7.1 DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Access denied for user 'rt_user'@'localhost' (using password: YES) at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES) at /home/jbarron/rt-3.8.6/sbin/../lib/RT.pm line 204 Using the user/pass specified in the script to connect directly to mysql works fine so I'm not sure why its still failing on me. I've added all the permissions for the rt_user and root user just to test, tried running the script with no arguments except -action upgrade, and I'm still stuck. Thanks kindly, Josh Barron ___ 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] RT slowness but ONLY when sending email
We've got a new RT install (RT 3.8.4 running on Solaris 10) that we've started using here at work. I've read through a bunch of the slow RT threads, but haven't seen what we are. In general the performance is very good. Our problem is when a user takes an action that generates an outbound email message. The application just sits there for a LONG time (maybe 60 seconds or so) before the resulting page is displayed and the mail message is delivered. If a user goes into the preferences and turns off the email functionality, the system performance on the same function is perfectly acceptable. Using sendmail from the command line works just fine with no delay so we're at a loss. It looks like RT is timing out waiting for SOMETHING and then sends the message after the timeout. Any help or advice would be greatly appreciated! -- View this message in context: http://old.nabble.com/RT-slowness-but-ONLY-when-sending-email-tp26101511p26101511.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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 slowness but ONLY when sending email
On 10/31/09 10:23, gunslinger95 wrote: We've got a new RT install (RT 3.8.4 running on Solaris 10) that we've started using here at work. I've read through a bunch of the slow RT threads, but haven't seen what we are. In general the performance is very good. Our problem is when a user takes an action that generates an outbound email message. The application just sits there for a LONG time (maybe 60 seconds or so) before the resulting page is displayed and the mail message is delivered. If a user goes into the preferences and turns off the email functionality, the system performance on the same function is perfectly acceptable. Using sendmail from the command line works just fine with no delay so we're at a loss. It looks like RT is timing out waiting for SOMETHING and then sends the message after the timeout. Any help or advice would be greatly appreciated! How are you calling your outbound mail functions? via SMTP or 'sendmail' ? The one thing that comes to mind for me is, if you're using SMTP and you're using an MTA which has something similar to Sendmail's GreetPause feature, and you don't have it configured properly, you could be causing yourself unnecessary delays. check your etc/RT_SiteConfig or etc/RT_Config files to see what your outbound mail settings are, and then AS THE USER THAT RUNS HTTPD, try to simulate the outbound mail process from the command line to see if that gives you any clues. Also, check your mail and httpd log files to see if there are any clues there. hope this helps. Alan ___ 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 slowness but ONLY when sending email
Read the following miniarticle: http://wiki.bestpractical.com/view/SendmailTips On Sat, Oct 31, 2009 at 9:51 AM, Alan Premselaar al...@12inch.com wrote: On 10/31/09 10:23, gunslinger95 wrote: We've got a new RT install (RT 3.8.4 running on Solaris 10) that we've started using here at work. I've read through a bunch of the slow RT threads, but haven't seen what we are. In general the performance is very good. Our problem is when a user takes an action that generates an outbound email message. The application just sits there for a LONG time (maybe 60 seconds or so) before the resulting page is displayed and the mail message is delivered. If a user goes into the preferences and turns off the email functionality, the system performance on the same function is perfectly acceptable. Using sendmail from the command line works just fine with no delay so we're at a loss. It looks like RT is timing out waiting for SOMETHING and then sends the message after the timeout. Any help or advice would be greatly appreciated! How are you calling your outbound mail functions? via SMTP or 'sendmail' ? The one thing that comes to mind for me is, if you're using SMTP and you're using an MTA which has something similar to Sendmail's GreetPause feature, and you don't have it configured properly, you could be causing yourself unnecessary delays. check your etc/RT_SiteConfig or etc/RT_Config files to see what your outbound mail settings are, and then AS THE USER THAT RUNS HTTPD, try to simulate the outbound mail process from the command line to see if that gives you any clues. Also, check your mail and httpd log files to see if there are any clues there. hope this helps. Alan ___ 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 -- Best regards, Ruslan. ___ 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 slowness but ONLY when sending email
That sounds VERY promising - I'll try that first thing Monday morning and report back. Thanks for the link - as I said - I'm just learning the tool, but EVERYONE in the office likes it so far... Ruslan Zakirov wrote: Read the following miniarticle: http://wiki.bestpractical.com/view/SendmailTips On Sat, Oct 31, 2009 at 9:51 AM, Alan Premselaar al...@12inch.com wrote: On 10/31/09 10:23, gunslinger95 wrote: We've got a new RT install (RT 3.8.4 running on Solaris 10) that we've started using here at work. I've read through a bunch of the slow RT threads, but haven't seen what we are. In general the performance is very good. Our problem is when a user takes an action that generates an outbound email message. The application just sits there for a LONG time (maybe 60 seconds or so) before the resulting page is displayed and the mail message is delivered. If a user goes into the preferences and turns off the email functionality, the system performance on the same function is perfectly acceptable. Using sendmail from the command line works just fine with no delay so we're at a loss. It looks like RT is timing out waiting for SOMETHING and then sends the message after the timeout. Any help or advice would be greatly appreciated! How are you calling your outbound mail functions? via SMTP or 'sendmail' ? The one thing that comes to mind for me is, if you're using SMTP and you're using an MTA which has something similar to Sendmail's GreetPause feature, and you don't have it configured properly, you could be causing yourself unnecessary delays. check your etc/RT_SiteConfig or etc/RT_Config files to see what your outbound mail settings are, and then AS THE USER THAT RUNS HTTPD, try to simulate the outbound mail process from the command line to see if that gives you any clues. Also, check your mail and httpd log files to see if there are any clues there. hope this helps. Alan ___ 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 -- Best regards, Ruslan. ___ 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 -- View this message in context: http://old.nabble.com/RT-slowness-but-ONLY-when-sending-email-tp26101511p26139614.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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