[rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Khusro Jaleel
Hello, I am thinking of migrating an RT instance from a machine running RT 3.8.1 to a machine running 3.6, but I'm not sure if this is even possible? Is it possible to move the MySQL DBs straight across from 3.8 to 3.6 without any issues? If there are any tweaks to be done, are they major?

Re: [rt-users] Retrieving tickets with activities since a give date?

2010-12-13 Thread Kevin Falcone
On Sat, Dec 11, 2010 at 11:07:22AM -0700, Thierry Thelliez wrote: I would like to retrieve all the tickets for which activities have happened after a give date (any correspondence, status change,...). Is there a way to do that from the UI? (actually I am interested in the REST interface).

Re: [rt-users] Changing database connection options?

2010-12-13 Thread Kevin Falcone
On Sat, Dec 11, 2010 at 11:40:17PM +0100, hubert depesz lubaczewski wrote: Hi, another question: is there any way to change database connections options from config? I.e. I want to change what's being passed as 4th argument to DBI-connect(). You'd need to patch DBIx::SearchBuilder to provide

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Kevin Falcone
On Mon, Dec 13, 2010 at 01:50:44PM +, Khusro Jaleel wrote: I am thinking of migrating an RT instance from a machine running RT 3.8.1 to a machine running 3.6, but I'm not sure if this is even possible? Is it possible to move the MySQL DBs straight across from 3.8 to 3.6 without any issues?

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Jacob Ritorto
RedHat is god, ftw! On 12/13/10 10:59, Kevin Falcone wrote: On Mon, Dec 13, 2010 at 01:50:44PM +, Khusro Jaleel wrote: I am thinking of migrating an RT instance from a machine running RT 3.8.1 to a machine running 3.6, but I'm not sure if this is even possible? Is it possible to move the

Re: [rt-users] associating customFields to QuickCalls?

2010-12-13 Thread Giuseppe Sollazzo
Dear Kevin, thanks for the advice. I was thinking of using a scrip/template together with QuickCalls, but I'll also check about Quick Create on the mailing list. I'm trying to avoid customizing too heavily for the moment, until we move to a stable and tested situation. Best regards,

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread John Arends
I don't understand people's desire to use 3rd party RT packages. You're then at the mercy of the packager, and it makes it harder to fix problems and apply upgrades when new RT releases come out. It's better to learn the internals of RT and deal with its idiosyncrasies than to use a package

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Khusro Jaleel
On 13/12/2010 16:26, John Arends wrote: I don't understand people's desire to use 3rd party RT packages. You're then at the mercy of the packager, and it makes it harder to fix problems and apply upgrades when new RT releases come out. It's better to learn the internals of RT and deal with

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread John Arends
CPAN makes me cranky, but trying to package all the perl modules as RPMs makes me crankier. It's like wrapping one packaging system around another one, and fighting with both of them. The reality is, every time RHEL updates perl, RT will break. I solve this by having an identical test system.

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Kenneth Marshall
On Mon, Dec 13, 2010 at 11:43:14AM -0600, John Arends wrote: CPAN makes me cranky, but trying to package all the perl modules as RPMs makes me crankier. It's like wrapping one packaging system around another one, and fighting with both of them. The reality is, every time RHEL updates perl,

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Jesse Vincent
RHEL is a major platform, and I'd love it if BestPractical supported it in some official way so we don't have these kinds of problems we have to work around. I try pretty hard not to push the commercial side of the business on the mailing lists, but BPS _is_ a business and we tend to spend

Re: [rt-users] notification

2010-12-13 Thread Kurt Engle
So here is the code that I am working with inside my template: Script: Condition: On Create Action: Notify Other Recipients Template: My Notify Stage: TransactionBatch 'My Notify' code --- { my $trans = $self-TransactionObj; my $ticket =

Re: [rt-users] notification

2010-12-13 Thread Kurt Engle
I have removed the blank lines, thank you for that tip. I am sending in the 'ticket' as a user other than myself and I am trying to notify someone other than myself. I am still not seeing the scrip being run. But, if I put the following code in the template: - {my $to_address =

Re: [rt-users] RT Query - how to display last comment

2010-12-13 Thread Kenneth Crocker
Ruslan, Would this be the correct code: Comment = { title = 'Comment', # last comment attribute = 'Comment', value = sub { return $_[0]-TransObj-Id( $_[0]-id )-Field('Type')-Value('Comment') } }, Thanks. Kenn LBNL On Sun, Dec 12, 2010 at 6:13 AM,

Re: [rt-users] notification

2010-12-13 Thread Kevin Falcone
On Mon, Dec 13, 2010 at 11:50:53AM -0800, Kurt Engle wrote: I have removed the blank lines, thank you for that tip. I am sending in the 'ticket' as a user other than myself and I am trying to notify someone other than myself. I am still not seeing the scrip being run. But, if

Re: [rt-users] notification

2010-12-13 Thread Kenneth Crocker
Kurt, Not sure why you start the scrip with a { and end with one. Just start with the my $trans=. Your code should be in the Prep Action and you should add this at the end of the code you've got: else { $to_address= rubble; ### after the above line, the code should look like this: #

[rt-users] Possible? Canned replies with attachments for a Customer Service queue

2010-12-13 Thread Steven Aranaga
Hello all! I have tried searching, and maybe my understanding is a bit behind when it comes to this, but I am trying to get a site setup for our customer service department. I need to see if RT is a possible solution for us… What I need is to be able to define a number of replies (80-100)

Re: [rt-users] Possible? Canned replies with attachments for a Customer Service queue

2010-12-13 Thread Kevin Falcone
On Mon, Dec 13, 2010 at 12:20:36PM -0800, Steven Aranaga wrote: What I need is to be able to define a number of replies (80-100) that my CS department can choose from. So, for instance, if someone emails in an issue with a product, and we have an internal patch we want them to try,

[rt-users] RT Slow to add and remove group members

2010-12-13 Thread Todd Chapman
Our production RT instance (3.6.3 - old, I know) takes a really, really long time to add and remove group members. Our database is MySQL and the CachedGroupMembers table has the index: KEY `CachedGroupMembers3` (`MemberId`,`ImmediateParentId`) What can we do to improve the situation (yes, I

Re: [rt-users] Possible? Canned replies with attachments for a Customer Service queue

2010-12-13 Thread Todd Chapman
RTFM doesn't support this but it could be done with some custom code. On Mon, Dec 13, 2010 at 3:20 PM, Steven Aranaga saran...@nolo.com wrote: Hello all! I have tried searching, and maybe my understanding is a bit behind when it comes to this, but I am trying to get a site setup for our

Re: [rt-users] notification

2010-12-13 Thread Kurt Engle
This code was entered in a template not a script. I was trying Kevin's suggestion with doing it all in one go. I figure that if I can capture the CustomField in the template code and test on that value to return my $to_address, then I am pretty much set to create my outgoing e-mail at the same

Re: [rt-users] notification

2010-12-13 Thread Kurt Engle
The error that I am getting is: [Mon Dec 13 22:05:45 2010] [info]: rt-3.8.8-18199-1292277945-1004.587-2...@4j.lane.edu #587/7702 - Scrip 26 Email TSS from Template (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:300) [Mon Dec 13 22:05:45 2010] [info]:

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Stuart Browne
CPAN makes me cranky, but trying to package all the perl modules as RPMs makes me crankier. It's like wrapping one packaging system around another one, and fighting with both of them. I've done this quite successfully. I've got RH distributed perl + packages plus those that I've manually

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Gary Greene
On 13/12/10 9:43 AM, John Arends jare...@illinois.edu wrote: CPAN makes me cranky, but trying to package all the perl modules as RPMs makes me crankier. It's like wrapping one packaging system around another one, and fighting with both of them. This is why I use cpan2rpm every time. The

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread John Arends
On Dec 13, 2010, at 6:06 PM, Gary Greene wrote: On 13/12/10 9:43 AM, John Arends jare...@illinois.edu wrote: CPAN makes me cranky, but trying to package all the perl modules as RPMs makes me crankier. It's like wrapping one packaging system around another one, and fighting with both of them.

Re: [rt-users] Possible to downgrade DB from 3.8 to 3.6?

2010-12-13 Thread Gary Greene
I've been working on one for SuSE on the wiki. I'm still a little behind on getting it all done. On 13/12/10 4:14 PM, John Arends jare...@illinois.edu wrote: On Dec 13, 2010, at 6:06 PM, Gary Greene wrote: On 13/12/10 9:43 AM, John Arends jare...@illinois.edu wrote: CPAN makes me cranky,

[rt-users] Exchange tip

2010-12-13 Thread Jason Knight
Just thought I'd throw this tip out there if you are running Exchange in your environment. I have RT configured on my CentOS 5.5 box, help.domain.com. My /etc/alias file uses h...@help.domain.commailto:h...@help.domain.com for incoming requests into my main helpdesk queue. What I've done

Re: [rt-users] RT Slow to add and remove group members

2010-12-13 Thread Ruslan Zakirov
On Tue, Dec 14, 2010 at 12:27 AM, Todd Chapman t...@chaka.net wrote: Our production RT instance (3.6.3 - old, I know) takes a really, really long time to add and remove group members. Our database is MySQL and the CachedGroupMembers table has the index: KEY `CachedGroupMembers3`

[rt-users] parallel requests from same user hang?

2010-12-13 Thread Mathias Koerber
We are running 3.2.1. I am using Firefox 3 (but Safari shows the same issue) with several TABS open to the RT 'Home' page. When I start some operation (show a large ticket, search, update a ticket etc) and it takes a more than a second, and I then go to another TAB and do something else, both