[rt-users] Upgrade 3.2.2 to 3.8.7

2010-06-09 Thread Andrew Best
Im in the process of preparing to upgrade an ancient RT 3.2.2 instance to 3.8.7. The plan is pretty straight forward. Run up new Ubuntu 10.04 host, install and configure blank 3.8.7 instance as per Ubuntu packages. Dump database on old 3.2.2 host, import database onto new Ubuntu host. Run necessar

[rt-users] Problems with multiple instances on FC4

2010-06-09 Thread Randy Paries
Hello, i currently have in production rt version RT 3.4.4 i have just gone thru the build process and install for rt-3.8.8 i have two sub domains, once for each installation rt3 for the old and rtx for the new I have them both set up as below , when i try to access the original rt3.mydomain.com,

[rt-users] LDAP External Authentication Issue

2010-06-09 Thread borngunners
I have been trying to configure my RT to communicate with my ldap, but I have been running into problems. I did install the perl module below is my configuration and error after I restart apache (apache failed to restart): # THE BASICS: Set($rtname, 'TAG'); Set($Organization, 'TAG'); Set(

Re: [rt-users] Spawn multiple child tickets

2010-06-09 Thread Kenneth Crocker
Jonathan, Try something like this: Condition: User Defined Action: Create Tickets Template: Create Child Ticket Stage: TransactionBatch Custom Condition: my $trans = $self->TransactionObj; my $ticket = $self->TicketObj; if ($trans->Type eq 'CustomField') {my $cf = new RT::CustomField($RT

Re: [rt-users] How to change the RT Self Service web interface for Unprivileged user?

2010-06-09 Thread Saiful Islam Sumon
Hi Kevin, Thanks for your reply. I have able to add the date column in RT Self Service by adding "Created" parameter in the file in "/opt/rt3/share/html/SelfService/Elements/MyRequest". /Sumon On 6/9/2010 2:20 AM, Kevin Falcone wrote: On Wed, Jun 09, 2010 at 12:31:06AM +0200, Saiful Islam S

Re: [rt-users] RT email time

2010-06-09 Thread Kevin Falcone
On Wed, Jun 09, 2010 at 12:08:04PM -0400, Juan N. DLC wrote: >OK, so what will be the best approach to resolve my issue? I still don't know what your issue is. If your issue is that RT is storing dates in the database in UTC then you really don't have an approach other than 'rewrite RT' -kev

Re: [rt-users] Spawn multiple child tickets

2010-06-09 Thread Jonathan Rummel
That's correct, Kenn. If they select 3 values, I want 3 child tickets and so on. However, that's my main problem. I've done what you're suggesting (by using the code I provided, with one scrip for each state), and it only creates a child ticket for the first option selected. Any ideas? Jonath

Re: [rt-users] Spawn multiple child tickets

2010-06-09 Thread Kenneth Crocker
Jonathan, If I understand this right, you want to create a child ticket for every value the user selects in the Custom Field. If they choose Florida and Maine, then you want two child tickets. If they select Florida, you want one. What if they select 3 or 4 values? If this is the case, I would cre

Re: [rt-users] Spawn multiple child tickets

2010-06-09 Thread Jonathan Rummel
Thanks, Kevin. I'm pretty much doing this on a novice level, and could use a little more explaining if possible. Please see notes in caps and parenthesis below: Jonathan Your condition only checks if the first value is Florida and then again hardcodes the first value into the ticket creation.

Re: [rt-users] RT email time

2010-06-09 Thread Juan N. DLC
OK, so what will be the best approach to resolve my issue? On Wed, Jun 9, 2010 at 11:53 AM, Kevin Falcone wrote: > On Wed, Jun 09, 2010 at 11:31:28AM -0400, Juan N. DLC wrote: > >For correction, I'm not trying to tdo queries to my RT DB, my problem > is that for some reason > >between RT

Re: [rt-users] RT email time

2010-06-09 Thread Kevin Falcone
On Wed, Jun 09, 2010 at 11:31:28AM -0400, Juan N. DLC wrote: >For correction, I'm not trying to tdo queries to my RT DB, my problem is > that for some reason >between RT and MySQL is a time_zone problem. my RT GUI have the correct > time/date but MySQL is >using UTC time, 4 hours ahea

[rt-users] Summary - winmail.dat attachments only on ticket Replies

2010-06-09 Thread Steve O'Brien
I figured it out, in case anyone else runs into the same issue. I was trying to figure out why replies were being handled differently and I knew that the original header becomes wrapped in the reply header. So it occurred to me to try piping the message through the tnef decoder twice and viola

Re: [rt-users] RT email time

2010-06-09 Thread Juan N. DLC
Thank you for all your replays, For correction, I'm not trying to tdo queries to my RT DB, my problem is that for some reason between RT and MySQL is a time_zone problem. my RT GUI have the correct time/date but MySQL is using UTC time, 4 hours ahead the real time. On Wed, Jun 9, 2010 at 10:57 AM

[rt-users] FW: winmail.dat attachments only on ticket Replies

2010-06-09 Thread Steve O'Brien
I figured it out, in case anyone else runs into the same issue. I was trying to figure out why replies were being handled differently and I knew that the original header becomes wrapped in the reply header. So it occurred to me to try piping the message through the tnef decoder twice and viola

[rt-users] Apache2::RequestIO::rflush

2010-06-09 Thread Sergio Charpinel Jr.
Hi, I'm getting a lot of messages like that in log: [crit]: Apache2::RequestIO::rflush: (103) Software caused connection abort at /usr/local/share/perl/5.10.0/HTML/Mason/ApacheHandler.pm line 1020 (/opt/rt3/bin/webmux.pl:165) What could cause this?? I'm using RT 3.8.5 Thanks in advance. -- S

Re: [rt-users] RT email time

2010-06-09 Thread Kevin Falcone
On Wed, Jun 09, 2010 at 09:01:34AM -0400, Juan N. DLC wrote: >So then, there is no way to change this? other than move my server local > time 4 hours behind >the real time? That would affect the RT GUI too. Juan As James correctly stated, RT stores dates in the database in GMT and conver

Re: [rt-users] migrating database

2010-06-09 Thread ronald higgins
Thanks very much for the info all. On Wed, Jun 9, 2010 at 2:52 PM, Emmanuel Lacour wrote: > On Wed, Jun 09, 2010 at 02:37:59PM +0200, ronald higgins wrote: >> Hi All, >> >> We're currently running RT 3.8.0 plugging into MySQL 5.0 (local) >> running on Centos 5.4. >> Due to performance issues i am

Re: [rt-users] RT email time

2010-06-09 Thread Kenneth Marshall
On Wed, Jun 09, 2010 at 09:01:34AM -0400, Juan N. DLC wrote: > So then, there is no way to change this? other than move my server local > time 4 hours behind the real time? That would affect the RT GUI too. > > On Thu, Jun 3, 2010 at 11:46 AM, James Moseley > wrote: > > > I believe RT, by design

Re: [rt-users] RT email time

2010-06-09 Thread Juan N. DLC
So then, there is no way to change this? other than move my server local time 4 hours behind the real time? That would affect the RT GUI too. On Thu, Jun 3, 2010 at 11:46 AM, James Moseley wrote: > I believe RT, by design, uses the UTC timestamp when storing data in the > database. > > -- > James

Re: [rt-users] migrating database

2010-06-09 Thread Emmanuel Lacour
On Wed, Jun 09, 2010 at 02:37:59PM +0200, ronald higgins wrote: > Hi All, > > We're currently running RT 3.8.0 plugging into MySQL 5.0 (local) > running on Centos 5.4. > Due to performance issues i am looking at partitioning the Attachments > & Tickets tables > to try and squeeze out some performa

Re: [rt-users] migrating database

2010-06-09 Thread Kenneth Marshall
It is set in the RT_Config.pm/RT_SiteConfig.pm files. Ken On Wed, Jun 09, 2010 at 02:37:59PM +0200, ronald higgins wrote: > Hi All, > > We're currently running RT 3.8.0 plugging into MySQL 5.0 (local) > running on Centos 5.4. > Due to performance issues i am looking at partitioning the Attachmen

[rt-users] migrating database

2010-06-09 Thread ronald higgins
Hi All, We're currently running RT 3.8.0 plugging into MySQL 5.0 (local) running on Centos 5.4. Due to performance issues i am looking at partitioning the Attachments & Tickets tables to try and squeeze out some performance. However, MySQL 5.1 isnt available via Centos 5.4. So my solution is too