Re: [rt-users] 3.4.2 to 4.x
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 Sphinx nonsense. That task, however, is turning out to be a nightmare. The gory details are at the link below, but the short story is that PostgreSQL does not like some of the bytes (mostly when trying to INSERT into Attachments). Cleaning the dump file of all non-ASCII characters, then trying the data load again, bought me nothing (!!??). http://dba.stackexchange.com/questions/9792/no-nulls-yet-invalid-byte-sequence-for-encoding-utf8-0x00 If anyone has any advice, please share! RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] 3.4.2 to 4.x
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 helpful, I ran into a few issues performing the update because of AssetTracker. Ping me off-list and I'll share them. On 12/28/2011 09:30 AM, Jeff Blaine wrote: 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 Sphinx nonsense. That task, however, is turning out to be a nightmare. The gory details are at the link below, but the short story is that PostgreSQL does not like some of the bytes (mostly when trying to INSERT into Attachments). Cleaning the dump file of all non-ASCII characters, then trying the data load again, bought me nothing (!!??). http://dba.stackexchange.com/questions/9792/no-nulls-yet-invalid-byte-sequence-for-encoding-utf8-0x00 If anyone has any advice, please share! RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- Darin Perusich Email: darin.perus...@ctg.com Office: 716-888-3690 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you are not the intended recipient of this message, please contact the sender and delete this material from this computer. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RT-Extention-QueueDeactivatedScrips
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 maintenance involved in working with identical scrips in different queues. Here is how I've set it up on my 4.0.4 environment: === wget https://github.com/tbrumm/RT-Extension-QueueDeactivatedScrips/zipball/master unzip master cd tbrumm-RT-Extension-QueueDeactivatedScrips-54c7982/ perl Makefile.PL make make install make initdb rm -rf /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/lib/ rm -rf /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/html/ tar -xvf deactivate_scrips_rt402.tar cd patch/rt_local mv * /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/ === In RT_SiteConfig.pm: Set(@Plugins, qw(RT::Extension::QueueDeactivatedScrips)); Restarted Apache. Now, when looking at Global Scrips, I have this screen. Not sure if this is where it should be showing - this should be when looking at a queue's scrips, no ? http://i.imgur.com/Fp37v.png Looking at a Queue's scrips shows the default version of Scrips.html, not one I would expect (the version that shows in the global scrips section). Therefore, when looking at a Queue, I do not have the ability to deactivate a global scrip. I've tried clearing mason's cache and copying the plugin files directly to the local folder instead of inside the plugin folder. No go. Am I doing something wrong ? I'm also thinking it could be nice that, instead of going inside a queue to deactivate a global scrip, you could go inside a global scrip and see a list of queues it is enabled on and change activation parameters there. But, that's entirely another extension I would think! *David Moreau Simard* On 11-12-05 4:41 AM, Givano wrote: Hi, here is the diff patch and full files of the extension for RT4.0.2. For SQL table use the SQL scripts from Thorstens extension on the github https://github.com/tbrumm/RT-Extension-QueueDeactivatedScrips. This modifications are fully based on Thorstens extension for RT3.8. If you need some help in setting up the extension for your RT please ask. BR, Ivan PS: @David: would be really interesting to hear if it also works with 4.0.4. 2011/12/2 David Moreau Simard dmsim...@iweb.com mailto:dmsim...@iweb.com I, for one, would be highly interested in trying the patch out. I have a 4.0.4 development environment on which I could test it on - I would report back with compatibility details. - David On 11-12-02 9:10 AM, Givano wrote: Hi guys, if it's still interesting, I have done the patch for rt 4.0.2 and it works fine for me. Only three files need to be modified two html and one lib. If you want I can send you diffs or the files for rt4.0.2. I dont know if it will work with 4.0.4. BR, Ivan 2011/10/6 Ruslan Zakirov r...@bestpractical.com mailto:r...@bestpractical.com Hi, On Thu, Oct 6, 2011 at 7:25 PM, Randy Black randy.bl...@buckle.com mailto:randy.bl...@buckle.com wrote: Know of anyone working on the port? I don't know. It's on github and there is no forks of the project. Torsten packaged the extension, probably newer version depends on patches people would send and/or on his upgrade schedule. -Original Message- From: ruslan.zaki...@gmail.com mailto:ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Thursday, October 06, 2011 12:24 PM To: Randy Black Cc: rt-users@lists.bestpractical.com mailto:rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-Extention-QueueDeactivatedScrips Hi, File that couldn't be found was deleted between RT3 and RT4. What means that extension has not been ported over RT4. On Thu, Oct 6, 2011 at 4:45 PM, Randy Black randy.bl...@buckle.com mailto:randy.bl...@buckle.com wrote: Does anyone use this extension and have it working in a production 4.0.2 instance of RT? I have it installed, but when selecting a queue and then selecting ‘scrips select’ from the menu, I get “could not find component for path ‘/Admin/Elements/QueueTabs’” Looking through the doc, the wiki and google, produced nothing. Thanks, Randy RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA — October 18 19, 2011 * Washington DC, USA — October 31 November 1, 2011 *
Re: [rt-users] 3.4.2 to 4.x
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, Oh jeez. I wish I'd known about that earlier! It's working fine so far. Chugging along. 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. On 12/28/2011 09:30 AM, Jeff Blaine wrote: 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 Sphinx nonsense. That task, however, is turning out to be a nightmare. The gory details are at the link below, but the short story is that PostgreSQL does not like some of the bytes (mostly when trying to INSERT into Attachments). Cleaning the dump file of all non-ASCII characters, then trying the data load again, bought me nothing (!!??). http://dba.stackexchange.com/questions/9792/no-nulls-yet-invalid-byte-sequence-for-encoding-utf8-0x00 If anyone has any advice, please share! RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RT-Extention-QueueDeactivatedScrips
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 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 maintenance involved in working with identical scrips in different queues. Here is how I've set it up on my 4.0.4 environment: === wget https://github.com/tbrumm/RT-Extension-QueueDeactivatedScrips/zipball/master unzip master cd tbrumm-RT-Extension-QueueDeactivatedScrips-54c7982/ perl Makefile.PL make make install make initdb rm -rf /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/lib/ rm -rf /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/html/ tar -xvf deactivate_scrips_rt402.tar cd patch/rt_local mv * /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/ === In RT_SiteConfig.pm: Set(@Plugins, qw(RT::Extension::QueueDeactivatedScrips)); Restarted Apache. Now, when looking at Global Scrips, I have this screen. Not sure if this is where it should be showing - this should be when looking at a queue's scrips, no ? http://i.imgur.com/Fp37v.png Looking at a Queue's scrips shows the default version of Scrips.html, not one I would expect (the version that shows in the global scrips section). Therefore, when looking at a Queue, I do not have the ability to deactivate a global scrip. I've tried clearing mason's cache and copying the plugin files directly to the local folder instead of inside the plugin folder. No go. Am I doing something wrong ? I'm also thinking it could be nice that, instead of going inside a queue to deactivate a global scrip, you could go inside a global scrip and see a list of queues it is enabled on and change activation parameters there. But, that's entirely another extension I would think! *David Moreau Simard* On 11-12-05 4:41 AM, Givano wrote: Hi, here is the diff patch and full files of the extension for RT4.0.2. For SQL table use the SQL scripts from Thorstens extension on the github https://github.com/tbrumm/RT-Extension-QueueDeactivatedScrips. This modifications are fully based on Thorstens extension for RT3.8. If you need some help in setting up the extension for your RT please ask. BR, Ivan PS: @David: would be really interesting to hear if it also works with 4.0.4. 2011/12/2 David Moreau Simard dmsim...@iweb.com mailto:dmsim...@iweb.com I, for one, would be highly interested in trying the patch out. I have a 4.0.4 development environment on which I could test it on - I would report back with compatibility details. - David On 11-12-02 9:10 AM, Givano wrote: Hi guys, if it's still interesting, I have done the patch for rt 4.0.2 and it works fine for me. Only three files need to be modified two html and one lib. If you want I can send you diffs or the files for rt4.0.2. I dont know if it will work with 4.0.4. BR, Ivan 2011/10/6 Ruslan Zakirov r...@bestpractical.com mailto:r...@bestpractical.com Hi, On Thu, Oct 6, 2011 at 7:25 PM, Randy Black randy.bl...@buckle.com mailto:randy.bl...@buckle.com wrote: Know of anyone working on the port? I don't know. It's on github and there is no forks of the project. Torsten packaged the extension, probably newer version depends on patches people would send and/or on his upgrade schedule. -Original Message- From: ruslan.zaki...@gmail.com mailto:ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Thursday, October 06, 2011 12:24 PM To: Randy Black Cc: rt-users@lists.bestpractical.com mailto:rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-Extention-QueueDeactivatedScrips Hi, File that couldn't be found was deleted between RT3 and RT4. What means that extension has not been ported over RT4. On Thu, Oct 6, 2011 at 4:45 PM, Randy Black randy.bl...@buckle.com mailto:randy.bl...@buckle.com wrote: Does anyone use this extension and have it working in a production 4.0.2 instance of RT? I have it installed, but when selecting a queue and then selecting ‘scrips select’ from the menu, I get “could not find component for path ‘/Admin/Elements/QueueTabs’” Looking through the doc, the wiki and google, produced nothing. Thanks, Randy RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA — October 18 19, 2011 * Washington DC, USA — October 31 November 1, 2011 * Barcelona, Spain — November 28 29, 2011 -- Best regards, Ruslan. -- Best regards, Ruslan.
Re: [rt-users] 3.4.2 to 4.x
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 service and tested it and I have to say, it was incredible how fast content fulltext searching is. We have about 28000 tickets in our system and some obscure searches yielded results in seconds where before (on 3.8.7) would take a long time and make the system non-responsive in some cases. An awesome addition to RT!!! Only facet was in the update script I had to add the rt libs path to the script as we have a nonstandard installation path. The updates (hourly) take only seconds. Just wanted to add my 2 cents. Sent via BlackBerry by ATT -Original Message- From: Jeff Blaine jbla...@kickflop.net Sender: rt-users-boun...@lists.bestpractical.com Date: Wed, 28 Dec 2011 12:27:47 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x 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, Oh jeez. I wish I'd known about that earlier! It's working fine so far. Chugging along. 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. On 12/28/2011 09:30 AM, Jeff Blaine wrote: 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 Sphinx nonsense. That task, however, is turning out to be a nightmare. The gory details are at the link below, but the short story is that PostgreSQL does not like some of the bytes (mostly when trying to INSERT into Attachments). Cleaning the dump file of all non-ASCII characters, then trying the data load again, bought me nothing (!!??). http://dba.stackexchange.com/questions/9792/no-nulls-yet-invalid-byte-sequence-for-encoding-utf8-0x00 If anyone has any advice, please share! RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RT-Extention-QueueDeactivatedScrips
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 4 root bin 4096 Dec 28 12:24 Articles -rw-r--r-- 1 root bin 2263 Dec 28 12:24 autohandler drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Dashboards -rw-r--r-- 1 root bin 2285 Dec 28 12:24 dhandler drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Download drwxr-xr-x 15 root bin 4096 Dec 28 12:24 Elements drwxr-xr-x 4 root bin 4096 Dec 28 12:24 Helpers -rw-r--r-- 1 root bin 5158 Dec 28 12:24 index.html drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Install -rw-r--r-- 1 root bin 2188 Dec 28 12:24 l drwxr-xr-x 5 root bin 4096 Dec 28 12:24 m drwxr-xr-x 9 root bin 4096 Dec 28 12:24 NoAuth drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Prefs drwxr-xr-x 3 root bin 4096 Dec 28 12:24 REST drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Search drwxr-xr-x 5 root bin 4096 Dec 28 12:24 SelfService drwxr-xr-x 5 root bin 4096 Dec 28 12:24 Ticket drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Tools drwxr-xr-x 2 root bin 4096 Dec 28 12:24 User drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Widgets Now, in the rt_local folder of the patch, the html folder looks like this: drwxrwxrwx 3 root root 4096 Dec 5 03:49 Admin drwxrwxrwx 2 root root 4096 Dec 5 03:50 Queues Notice the Queues folder ? I moved it inside Admin - just like in the default hierarchy: # ls -al /opt/rt4/share/html/Admin/ total 48 drwxr-xr-x 10 root bin 4096 Dec 28 12:24 . drwxr-xr-x 20 root bin 4096 Dec 28 12:24 .. drwxr-xr-x 4 root bin 4096 Dec 28 12:24 Articles -rw-r--r-- 1 root bin 2213 Dec 28 12:24 autohandler drwxr-xr-x 2 root bin 4096 Dec 28 12:24 CustomFields drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Elements drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Global drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Groups -rw-r--r-- 1 root bin 2268 Dec 28 12:24 index.html drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Queues drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Tools drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Users I now get the global scrip activation toggles inside the queue scrips configuration. I'm now testing to see if I am able to get the expected behavior from my global scrips. I've created a dummy global scrip which re-opens a ticket if the status is changed. If I change the status to stalled, it resets the ticket's status to open. Now, I've tried deactivating the scrip both through the global section and the queue section but it keeps going. Trying to figure out what is the issue and I will report back ! *David Moreau Simard* On 11-12-28 12:35 PM, David Moreau Simard wrote: 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 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 maintenance involved in working with identical scrips in different queues. Here is how I've set it up on my 4.0.4 environment: === wget https://github.com/tbrumm/RT-Extension-QueueDeactivatedScrips/zipball/master unzip master cd tbrumm-RT-Extension-QueueDeactivatedScrips-54c7982/ perl Makefile.PL make make install make initdb rm -rf /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/lib/ rm -rf /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/html/ tar -xvf deactivate_scrips_rt402.tar cd patch/rt_local mv * /opt/rt4/local/plugins/RT-Extension-QueueDeactivatedScrips/ === In RT_SiteConfig.pm: Set(@Plugins, qw(RT::Extension::QueueDeactivatedScrips)); Restarted Apache. Now, when looking at Global Scrips, I have this screen. Not sure if this is where it should be showing - this should be when looking at a queue's scrips, no ? http://i.imgur.com/Fp37v.png Looking at a Queue's scrips shows the default version of Scrips.html, not one I would expect (the version that shows in the global scrips section). Therefore, when looking at a Queue, I do not have the ability to deactivate a global scrip. I've tried clearing mason's cache and copying the plugin files directly to the local folder instead of inside the plugin folder. No go. Am I doing something wrong ? I'm also thinking it could be nice that, instead of going inside a queue to deactivate a global scrip, you could go inside a global scrip and see a list of queues it is enabled on and change activation parameters there. But, that's entirely another extension I would think! *David Moreau Simard* RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Auto assign owner on ticket creation
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
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 that. However, when I placed the extended Scrip.pm into local/lib/RT, scrip activation and deactivation worked as expected. Any ideas ? *David Moreau Simard* On 11-12-28 2:17 PM, David Moreau Simard wrote: 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 4 root bin 4096 Dec 28 12:24 Articles -rw-r--r-- 1 root bin 2263 Dec 28 12:24 autohandler drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Dashboards -rw-r--r-- 1 root bin 2285 Dec 28 12:24 dhandler drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Download drwxr-xr-x 15 root bin 4096 Dec 28 12:24 Elements drwxr-xr-x 4 root bin 4096 Dec 28 12:24 Helpers -rw-r--r-- 1 root bin 5158 Dec 28 12:24 index.html drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Install -rw-r--r-- 1 root bin 2188 Dec 28 12:24 l drwxr-xr-x 5 root bin 4096 Dec 28 12:24 m drwxr-xr-x 9 root bin 4096 Dec 28 12:24 NoAuth drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Prefs drwxr-xr-x 3 root bin 4096 Dec 28 12:24 REST drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Search drwxr-xr-x 5 root bin 4096 Dec 28 12:24 SelfService drwxr-xr-x 5 root bin 4096 Dec 28 12:24 Ticket drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Tools drwxr-xr-x 2 root bin 4096 Dec 28 12:24 User drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Widgets Now, in the rt_local folder of the patch, the html folder looks like this: drwxrwxrwx 3 root root 4096 Dec 5 03:49 Admin drwxrwxrwx 2 root root 4096 Dec 5 03:50 Queues Notice the Queues folder ? I moved it inside Admin - just like in the default hierarchy: # ls -al /opt/rt4/share/html/Admin/ total 48 drwxr-xr-x 10 root bin 4096 Dec 28 12:24 . drwxr-xr-x 20 root bin 4096 Dec 28 12:24 .. drwxr-xr-x 4 root bin 4096 Dec 28 12:24 Articles -rw-r--r-- 1 root bin 2213 Dec 28 12:24 autohandler drwxr-xr-x 2 root bin 4096 Dec 28 12:24 CustomFields drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Elements drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Global drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Groups -rw-r--r-- 1 root bin 2268 Dec 28 12:24 index.html drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Queues drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Tools drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Users I now get the global scrip activation toggles inside the queue scrips configuration. I'm now testing to see if I am able to get the expected behavior from my global scrips. I've created a dummy global scrip which re-opens a ticket if the status is changed. If I change the status to stalled, it resets the ticket's status to open. Now, I've tried deactivating the scrip both through the global section and the queue section but it keeps going. Trying to figure out what is the issue and I will report back ! *David Moreau Simard* RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Full Text Search on mysql 5.6.4 off the shelf
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, though it's good to see it's come down the pike! RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Apache 2 revers proxy
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 default apache v host: ProxyPass / http://localhost:8080/ ProxyPassReverse / http://localhost:8080/ When I try to connect it says I don't have access to /. What am I missing? RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RT-Extention-QueueDeactivatedScrips
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 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 that. However, when I placed the extended Scrip.pm into local/lib/RT, scrip activation and deactivation worked as expected. Any ideas ? *David Moreau Simard* On 11-12-28 2:17 PM, David Moreau Simard wrote: 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 4 root bin 4096 Dec 28 12:24 Articles -rw-r--r-- 1 root bin 2263 Dec 28 12:24 autohandler drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Dashboards -rw-r--r-- 1 root bin 2285 Dec 28 12:24 dhandler drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Download drwxr-xr-x 15 root bin 4096 Dec 28 12:24 Elements drwxr-xr-x 4 root bin 4096 Dec 28 12:24 Helpers -rw-r--r-- 1 root bin 5158 Dec 28 12:24 index.html drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Install -rw-r--r-- 1 root bin 2188 Dec 28 12:24 l drwxr-xr-x 5 root bin 4096 Dec 28 12:24 m drwxr-xr-x 9 root bin 4096 Dec 28 12:24 NoAuth drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Prefs drwxr-xr-x 3 root bin 4096 Dec 28 12:24 REST drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Search drwxr-xr-x 5 root bin 4096 Dec 28 12:24 SelfService drwxr-xr-x 5 root bin 4096 Dec 28 12:24 Ticket drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Tools drwxr-xr-x 2 root bin 4096 Dec 28 12:24 User drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Widgets Now, in the rt_local folder of the patch, the html folder looks like this: drwxrwxrwx 3 root root 4096 Dec 5 03:49 Admin drwxrwxrwx 2 root root 4096 Dec 5 03:50 Queues Notice the Queues folder ? I moved it inside Admin - just like in the default hierarchy: # ls -al /opt/rt4/share/html/Admin/ total 48 drwxr-xr-x 10 root bin 4096 Dec 28 12:24 . drwxr-xr-x 20 root bin 4096 Dec 28 12:24 .. drwxr-xr-x 4 root bin 4096 Dec 28 12:24 Articles -rw-r--r-- 1 root bin 2213 Dec 28 12:24 autohandler drwxr-xr-x 2 root bin 4096 Dec 28 12:24 CustomFields drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Elements drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Global drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Groups -rw-r--r-- 1 root bin 2268 Dec 28 12:24 index.html drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Queues drwxr-xr-x 3 root bin 4096 Dec 28 12:24 Tools drwxr-xr-x 2 root bin 4096 Dec 28 12:24 Users I now get the global scrip activation toggles inside the queue scrips configuration. I'm now testing to see if I am able to get the expected behavior from my global scrips. I've created a dummy global scrip which re-opens a ticket if the status is changed. If I change the status to stalled, it resets the ticket's status to open. Now, I've tried deactivating the scrip both through the global section and the queue section but it keeps going. Trying to figure out what is the issue and I will report back ! *David Moreau Simard* RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Apache 2 revers proxy
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 configure Apache correctly it should work. I added the following to the default apache v host: ProxyPass / http://localhost:8080/ ProxyPassReverse / http://localhost:8080/ When I try to connect it says I don't have access to /. What am I missing? Never tried apache as reverse proxy. If you're not tied to apache then you can take a look at RT-Extension-Nginx. With apache you can start RT as external FCGI server [1]. However, Nginx solution comes with additional features. [1] http://search.cpan.org/~miyagawa/Plack-0.9985/lib/Plack/Handler/FCGI.pm RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Auto assign owner on ticket creation
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 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston — March 5 6, 2012 -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] cannot get result of search Chinese character - centos 5.4
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
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. The RT server which handled your email did not behave as expected. It said: Unknown encoding 'GB18030' at /opt/rt4/sbin/../lib/RT/I18N.pm line 323 Stack: [/usr/local/lib/perl5/5.10.1/Carp.pm:44] [/usr/local/lib/perl5/5.10.1/i686-linux-thread-multi/Encode.pm:189] [/opt/rt4/sbin/../lib/RT/I18N.pm:323] [/opt/rt4/sbin/../lib/RT/I18N.pm:542] [/opt/rt4/sbin/../lib/RT/I18N.pm:214] [/opt/rt4/sbin/../lib/RT/EmailParser.pm:282] [/opt/rt4/sbin/../lib/RT/Interface/Email.pm:1400] [/opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway:61] ) I tried to install Encode::HanExtra, but still have the same error message. Refer: http://www.gossamer-threads.com/lists/rt/commit/106389 -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] 3.4.2 to 4.x
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 you would be willing to share regarding the issues you faced with upgrading to Postgres because of AT. I'm getting ready to upgrade to RT 4.0.4 and would like to take the opportunity to migrate to Postgres. Thanks, Dustin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012