Re: [rt-users] mysql DB engine ndbdcluster
At the risk of picking a fight, I'd like to understand this a bit better. As long as the database supports minimum functions, such as transactions, joins, datatypes, etc., why should an application care about the underlying storage engine? Are you trying to imply that ndbcluster simply isn't production-ready? If so, then end of conversation. Otherwise, what are some of the issues the OP will have to look forward to? Thanks. Mike. On Tuesday, December 13, 2016 09:05:11 PM Alex Vandiver wrote: > On Tue, 13 Dec 2016 12:25:37 +0100 > > Pescoller Reinhold <reinh...@aiding.it> wrote: > > Thanks for your informations. > > > > I tried to do so but rt give me an error that innodb is required and > > that I should upgrade my tables. > > Have I to change this direct in the code? > > lib/RT/Handle.pm: > https://github.com/bestpractical/rt/blob/095caac2a4b4fc7baba0d7878a79f8b4865 > 79854/lib/RT/Handle.pm#L291 > > I'll reiterate that while RT may appear to work in trivial > conditions, you're setting yourself up for a world of both poor > performance and nasty race condition bugs. You get to keep all of the > pieces when it bursts into flames in production -- NDB is in no way a > supported, suggested, or sane backing engine for RT. > - Alex > - > RT 4.4 and RTIR training sessions, and a new workshop day! > https://bestpractical.com/training * Los Angeles - January 9-11 2017 -- Mike Diehl Diehlnet Communications, LLC. Sales: (800) 254-6105 Voice: (505) 903-5700 Fax: (505) 903-5701 - RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Los Angeles - January 9-11 2017
Re: [rt-users] Custom Field Search??
I think the original poster has a similar question to one I've been pondering. In my case, I have a custom field in the tickets that stores SLA information. I would like to be able to query my tickets to see which tickets have a particular SLA setting and are older than a certain age. Can this be done in the query-by-example web interface? I hope I haven't hijacked your question. Please forgive me if I have. On Tuesday, April 12, 2016 01:59:17 PM Matt Zagrabelny wrote: > On Tue, Apr 12, 2016 at 1:44 PM, Jesse Maseto > > <je...@bywatersolutions.com> wrote: > > Hello Matt, > > > > Sorry I should have added more content of what I was actually doing. > > > > So I wanted to create a custom field that applies to a users group that > > their a member of. > > Are you trying to duplicate data that is already in RT, then? > > Group membership is already stored in the database. > > Once I’ve created this custom field I would like to be > > > able to search for this. Here is a screen shot of where I’m adding this > > field. > > Sure. > > > I know that if I created this custom field and set to to apply for > > tickets, > > I’m able to search using the standard RT search but can’t find a way to > > search the groups. > > Generally if you want to see what is in a group, you'd go to the Group > and click the Members link. > > If you want to see what groups a user is in, you'd go to that user and > click memberships. > > -m > - > RT 4.4 and RTIR Training Sessions https://bestpractical.com/training > * Washington DC - May 23 & 24, 2016 -- Mike Diehl Diehlnet Communications, LLC. Voice: (505) 903-5700 Fax: (505) 903-5701 - RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016
[rt-users] A few Op's questions from a new user
Hi all, I've recently started using RT. I chose it because it was written in Perl (as is the rest of my system) and had a lot of integration and extension hooks. I have it setup to automatically create users if they send email to the appropriate address. My eventual goals are: 1. Allow my customers to manage their tickets from the web. 2. Be able to send my customers a monthly ticket summary. 3. Completely integrate RT with my normal Ops. So, here are my questions: 1. I would like to (somehow) keep my customer database in sync with the RT user database. However, my db only has the customer information; each customer might have multiple users as identified by email address. I don't want to do a lot of double data entry, but I don't mind coding. 2. When I stall a ticket, I'd like to be able to set the due date at that time. Right now, I do that as a separate step. Can this be changed? 3. If a customer opens a ticket but requests several things, what is the best way to track the progress of those tasks individually? I see that I should be able to create associated tickets, but I don't see/understand how those get related and updated. I would love some comments on how others manage this. Thanks for your time and I look forward to your comments. -- Mike Diehl Diehlnet Communications, LLC. Voice: (505) 903-5700 Fax: (505) 903-5701
