[rt-users] RT Slow Ticket Updates

2009-06-30 Thread Varun Vyas
Hello All In my RT application my creating, updating and closing of tickets are very slow and takes almost 20 sec to insert a ticket and nearly 35 seconds to update a ticket. We have applied many changes on our database side and application side too. But still our RT application is not stabili

Re: [rt-users] How to make the subject field mandatory?

2009-06-30 Thread Bill Cole
Kevin Gagel wrote, On 6/30/09 4:41 PM: > How can I make the subject field a mandatory field? Write a BeforeCreate callback to validate that the subject meets your needs. The callback routine needs to be placed in: $RT_ROOT/local/html/Callbacks/$localtag/Ticket/Create.html/BeforeCreate $RT_ROOT/lo

Re: [rt-users] Ticket ID as CHAR(32)?

2009-06-30 Thread Jesse Vincent
> Are you aware of anywhere that the code does anything with that ticket > ID other than pass it around? I haven't yet (but haven't done deep > digging) seen it being used for anything other than in the queries > themselves and displayed on the web UI and emails. My change from > signed int(11)

Re: [rt-users] Ticket ID as CHAR(32)?

2009-06-30 Thread Dusty Wilson [Megagram]
On Tue, Jun 30, 2009 at 4:28 PM, Jesse Vincent wrote: > On Tue, Jun 30, 2009 at 03:06:17PM -0500, Dusty Wilson [Megagram] wrote: >> I just sent an email about UNSIGNED INT for the database.  This is a >> separate (but related) question:  Is there a reason why ticket IDs >> can't be CHAR(32)?  I'd l

Re: [rt-users] Ticket ID as CHAR(32)?

2009-06-30 Thread Jesse Vincent
On Tue, Jun 30, 2009 at 03:06:17PM -0500, Dusty Wilson [Megagram] wrote: > I just sent an email about UNSIGNED INT for the database. This is a > separate (but related) question: Is there a reason why ticket IDs > can't be CHAR(32)? I'd love to use a proper UUID as a ticket ID. That's going t

Re: [rt-users] Anyone know of a few enhancements to RT...

2009-06-30 Thread Gary Greene
On 6/30/09 12:24 PM, "Kevin Falcone" wrote: > On Jun 30, 2009, at 2:02 PM, Gary Greene wrote: >> I've been trying to get Minerva using RT for a bit now, however I've >> run >> into a few feature requests that my users (read bosses) view as >> blockers. >> Does anyone know of a plug in that would a

Re: [rt-users] Anyone know of a few enhancements to RT...

2009-06-30 Thread Jerrad Pierce
> Its been in svn for years.  Its finally made it onto cpan also > http://search.cpan.org/dist/RT-Extension-QuickCalls/ Ok, Cool. Ay yes. The SVN. Home to many magical things sometimes, but not always mentioned elsewhere :-P -- Cambridge Energy Alliance: Save money. Save the planet. _

[rt-users] How to make the subject field mandatory?

2009-06-30 Thread Kevin Gagel
How can I make the subject field a mandatory field? Kevin W. Gagel Network Administrator Local 5448 My blog: http://mail.cnc.bc.ca/blogs/gagel My shared files: http://mail.cnc.bc.ca/users/gagel ___ http://lists.bestpractical.com/cgi-bin/mailman/listi

Re: [rt-users] Anyone know of a few enhancements to RT...

2009-06-30 Thread Kevin Falcone
On Jun 30, 2009, at 3:29 PM, Jerrad Pierce wrote: >> You may be able to do this with RT-Extension-QuickCalls which adds >> a homepage widget. Otherwise you'd have to hack up Ticket Create >> or add JS > What does that live? Nothing on CPAN or the wiki (anymore). Its been in svn for years. Its

Re: [rt-users] Problem with RT-Authen-ExternalAuth when a CN name has a comma in it

2009-06-30 Thread Kevin Falcone
On Jun 29, 2009, at 2:53 PM, Wes Topping wrote: > I am not sure what is happening here. All I know is that if a user > in AD is created without a comma in the container name they log in > just fine. When someone that does have a comma in their CN name > tries to authenticate this is what hap

[rt-users] Ticket ID as CHAR(32)?

2009-06-30 Thread Dusty Wilson [Megagram]
I just sent an email about UNSIGNED INT for the database. This is a separate (but related) question: Is there a reason why ticket IDs can't be CHAR(32)? I'd love to use a proper UUID as a ticket ID. If I convert a UUID from hex (base 16) to alphanumeric (case sensitive: base 62; case insensitiv

[rt-users] Can the ticket ID fields in the database be INT UNSIGNED?

2009-06-30 Thread Dusty Wilson [Megagram]
I've noticed that in the tables that the ticket ID is not unsigned. Is there a use for ticket IDs smaller than zero? I've adjusted the schema for my system to use INT UNSIGNED for all of the ticket ID fields. I'm needing a big ticket ID number for my purposes. I just wonder if I'm going to be br

Re: [rt-users] Anyone know of a few enhancements to RT...

2009-06-30 Thread Jerrad Pierce
> You may be able to do this with RT-Extension-QuickCalls which adds > a homepage widget.  Otherwise you'd have to hack up Ticket Create > or add JS What does that live? Nothing on CPAN or the wiki (anymore). ___ http://lists.bestpractical.com/cgi-bin/mai

Re: [rt-users] Anyone know of a few enhancements to RT...

2009-06-30 Thread Kevin Falcone
On Jun 30, 2009, at 2:02 PM, Gary Greene wrote: > I've been trying to get Minerva using RT for a bit now, however I've > run > into a few feature requests that my users (read bosses) view as > blockers. > Does anyone know of a plug in that would add an address book feature > to the > BCC an

Re: [rt-users] "Modify Ticket" permissions too broad?

2009-06-30 Thread Jerrad Pierce
Can't you assign the permission by role in Group Rights? I.e; Requestor can modify ticket? -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestp

Re: [rt-users] Disable WYSIWYG Editor

2009-06-30 Thread Kevin Falcone
On Jun 29, 2009, at 11:01 AM, Mike Harris wrote: > I found a previous post from lwebb from April or so, asking how to > permanently disable the WYSIWYG editor, and there weren't any > responses to him. > > I too, would like to disable users from changing to the WYSIWYG > editor. I found the RT_Si

Re: [rt-users] "Modify Ticket" permissions too broad? [solved]

2009-06-30 Thread Nick Kartsioukas
Oh geeze, how did I miss the StrictLinkACL setting in RT_Config before :/ Sorry folks! That defaults to 1, setting it to 0 should take care of this issue for me. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http:

Re: [rt-users] "Modify Ticket" permissions too broad?

2009-06-30 Thread Nick Kartsioukas
On Tue, 30 Jun 2009 14:42:34 -0400, "Jerrad Pierce" said: > Can't you assign the permission by role in Group Rights? > I.e; Requestor can modify ticket? Not unless there's a way to nest privileges that I'm missing (such as Requestor who is a member of Group A), otherwise our customers will have M

Re: [rt-users] Search's ticket count includes tickets I don't have permission to view

2009-06-30 Thread Kevin Falcone
On Jun 29, 2009, at 10:01 AM, Vetter, Isaac A wrote: > Hi All; > > We run multiple queues for a few self-contained IT groups. These > groups do > not have permissions to one another's queues. > > One of these groups reported that ticket count (and pagination!) > resulting > from a search occu

[rt-users] "Modify Ticket" permissions too broad?

2009-06-30 Thread Nick Kartsioukas
I'm finding the "modify ticket" permission setting is too broad for some situations. Here's my issue... Let's say I have two queues, A, and B. I have a group associated with each queue as the "responsible" group (as in this group will handle tickets in each queue, so they can own tickets, close

[rt-users] Anyone know of a few enhancements to RT...

2009-06-30 Thread Gary Greene
I've been trying to get Minerva using RT for a bit now, however I've run into a few feature requests that my users (read bosses) view as blockers. Does anyone know of a plug in that would add an address book feature to the BCC and CC fields when posting a ticket? Also, I need to know if there is a

[rt-users] Malformed mulipart POSt when using MSIE 7 with RT 3.8.4.

2009-06-30 Thread James Bromberger
Hello all, I have just updated by RT to 3.8.4 (Debian package), and while I am a Firefox user, I have just seen that using MSIE 7 is getting an empty response at certain times, such as when updating a ticket (Update.html). Looking at the Apache error log shows "Malformed multipart POST (/usr/sh

[rt-users] Problems with RT 3.8.2 - SQL bugs

2009-06-30 Thread Rafael Martinez
Hello We have found two bugs in the SQL statements sent to the database (RT-3.8.2 / postgreSQL 8.3.7). 1) The first one gives us the wrong result when generating the statistics graph for a queue (grouped by Status). The problem is that it used DISTINCT outside the aggregate function count(). Thi

Re: [rt-users] RT Query Logging

2009-06-30 Thread Raed El-Hames
There is no bother, what I meant is the list will be more helpful than me. for tweaks and performance tuning the wiki and mailing list is better place than me, because it varies depending on the database server you use. Start with observation and detect your bottle necks , ist the web part or the

Re: [rt-users] RT Query Logging

2009-06-30 Thread Varun Vyas
And can you can tell me what kind of maintainance you have done on application side i.e RT side to enhance its performance and what kind of tweaks you have applied in apache configuration file and RT_SiteConfig.pm file Thanks In Advance Raed El-Hames wrote: > Varun; > > You should make it a ha

Re: [rt-users] RT Query Logging

2009-06-30 Thread Varun Vyas
Hi Raed El-Hames I am so sorry if i have bothered you but as i am new to this mail list i am also not aware that i need to reply to all users in list and not individual. Raed El-Hames wrote: > Varun; > > You should make it a habit to reply to the list and not individuals , > I have never depl

Re: [rt-users] RT Query Logging

2009-06-30 Thread Raed El-Hames
Varun; You should make it a habit to reply to the list and not individuals , I have never deployed RT with Oracle so can't help you -- few in the may though ps: A pointer so you know what RT is capable of , our RT db is > 50G in size, the attachments table alone is > 26G, our db server is quad

Re: [rt-users] RT Query Logging

2009-06-30 Thread Raed El-Hames
Varun; There is no straight forward answer to this , you possibly should start by stating your RT version, DB type(oracle,mysql ??) and version , apache, mod_perl or fastcgi etc .. Also search the wiki and mailing list there are lots of posts and a good article in the wiki covering this.(sorry

Re: [rt-users] RT Query Logging

2009-06-30 Thread Raed El-Hames
From RT_Config.pm # DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be # the level that you wish SQL statements to be logged at. Set($StatementLog,undef); I am not sure what the different levels but : Set($StatementLog,1); will be a good start. Remember to restart your web serv