Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread Jeff Blaine
The RT 3.4 to RT 4.0.4 upgrade went fine. Now with our data in MySQL 5.1.x, instead of the old MySQL 4.1, and our new instance not in production yet, we want to migrate to PostgreSQL 8.4.9, largely in order to get performant full-text searching without doing something hackish with MySQL and

Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread Darin Perusich
Hi Jeff, I did an upgrade from mysql to postgres a few month back and it went very smoothly. I used the rt-mysql2pg script available at http://wiki-archive.bestpractical.com/view/rt-mysql2pg to convert the data which performed seamlessly. I have a bunch of notes I can share which might be

Re: [rt-users] RT-Extention-QueueDeactivatedScrips

2011-12-28 Thread David Moreau Simard
Hi there, So, I've finally got the chance to grant some time at trying this out. Before going ahead, I just wanted to say that I've never actually used this plugin so I am not certain what is the expected behavior. However, this seems like it would be really useful in reducing the amount of

Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread Jeff Blaine
On 12/28/2011 9:50 AM, Darin Perusich wrote: Hi Jeff, I did an upgrade from mysql to postgres a few month back and it went very smoothly. I used the rt-mysql2pg script available at http://wiki-archive.bestpractical.com/view/rt-mysql2pg to convert the data which performed seamlessly. Hi Darin,

Re: [rt-users] RT-Extention-QueueDeactivatedScrips

2011-12-28 Thread David Moreau Simard
Just tested the same procedure under a fresh 4.0.2 install I've made and it reproduced the same results. *David Moreau Simard* On 11-12-28 12:10 PM, David Moreau Simard wrote: Hi there, So, I've finally got the chance to grant some time at trying this out. Before going ahead, I just wanted

Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread drey111
As you go down this path. I want to let you (and the list) know that we upgraded to 4.0.4 recently and Monday I set up the indexing. The initial index took hours and increased the size of the database in postgres considerably (which was fine as it's not too large). Yesterday we restarted the

Re: [rt-users] RT-Extention-QueueDeactivatedScrips

2011-12-28 Thread David Moreau Simard
Okay, I've figured it out what was the issue. In the patch you provided, the file hierarchy isn't the same as the one I have. If I look at /opt/rt4/share/html, I have the following: drwxr-xr-x 10 root bin 4096 Dec 28 12:24 Admin drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Approvals drwxr-xr-x

[rt-users] Auto assign owner on ticket creation

2011-12-28 Thread Chris Robison
We've created a queue where all tickets created in it need to be assigned to a specific user. Is there a way to do this automatically? Chris Robison RT Training Sessions (http://bestpractical.com/services/training.html) * Boston — March 5 6, 2012

Re: [rt-users] RT-Extention-QueueDeactivatedScrips

2011-12-28 Thread David Moreau Simard
Okay, I've managed to make it work. In the patch, there is a file Scrip_Overlay.pm - now, I've renamed this file to Scrip.pm since this is the file that it is meant to extend. After doing some tests, I could not get RT to use the extended Scrip.pm - maybe you could provide some insight on

[rt-users] Full Text Search on mysql 5.6.4 off the shelf

2011-12-28 Thread Ram Moskovitz
From the mysql 5.6.4 release notes: MySQL Server 5.6.4 (Milestone Release) is a new version of the world's most popular open source database. MySQL now supports FULLTEXT indexes for InnoDB tables. http://forums.mysql.com/read.php?3,506409,506409 I can't get this release onto a production box,

[rt-users] Apache 2 revers proxy

2011-12-28 Thread Damien Hull
Here's what I have 1. Ubuntu 10.04 2. RT 4.0.4 installed and configured 3. Starman 5. LAMP 6. Test Server I can access the login page for RT directly by using :8080. That's where RT and Starman are. That tells me if I configure Apache correctly it should work. I added the following to the

Re: [rt-users] RT-Extention-QueueDeactivatedScrips

2011-12-28 Thread David Moreau Simard
I've made an updated version available as a forked project on Github: https://github.com/dmsimard/RT-Extension-QueueDeactivatedScrips Feel free to use it, I will surely update it in the near future. *David Moreau Simard* On 11-12-28 4:27 PM, David Moreau Simard wrote: Okay, I've managed to

Re: [rt-users] Apache 2 revers proxy

2011-12-28 Thread Ruslan Zakirov
On Thu, Dec 29, 2011 at 02:33, Damien Hull dh...@section9.us wrote: Here's what I have 1. Ubuntu 10.04 2. RT 4.0.4 installed and configured 3. Starman 5. LAMP 6. Test Server I can access the login page for RT directly by using :8080. That's where RT and Starman are. That tells me if I

Re: [rt-users] Auto assign owner on ticket creation

2011-12-28 Thread Ruslan Zakirov
On Thu, Dec 29, 2011 at 01:01, Chris Robison chrisdrobi...@gmail.com wrote: We've created a queue where all tickets created in it need to be assigned to a specific user. Is there a way to do this automatically? http://requesttracker.wikia.com/wiki/AutoSetOwnerForQueue Chris Robison

Re: [rt-users] cannot get result of search Chinese character - centos 5.4

2011-12-28 Thread nectar
Sir, Looks like can search Chinese character when use Perl 5.10 instead of Perl 5.8.8 on CentOS 5. -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012

[rt-users] Unknown encoding 'GB18030' at RT4.0.4

2011-12-28 Thread nectar
Sir, Emails which encode with 'GB18030' can not receive by RT-4.0.4. Mail log as: Dec 29 08:51:08 server postfix/local[26843]: A58FF51008F: to=email-address, relay=local, delay=239881, delays=239880/0.95/0/0.35, dsn=4.3.0, status=deferred (temporary failure. Command output: RT server error.

Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread Dustin Berube
On Wed, Dec 28, 2011 at 9:50 AM, Darin Perusich darin.perus...@ctg.comwrote: I have a bunch of notes I can share which might be helpful, I ran into a few issues performing the update because of AssetTracker. Ping me off-list and I'll share them. Darin, I'd be interested in seeing any notes