Re: [rt-users] RT 3.6.4 poor query performance

2008-03-25 Thread Thomas Hecker
Hi Everybody, well fist of all - thanks for this topic. You all made my day, because for the moment my performance problem seems to be fixed. I had the same problem with the owner-dropdown getting bigger and bogger ower time. In my case the problem was the inside the main queue we use for first

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-25 Thread Richard Ellis
Hi Ruslan, I have changed those indexes this morning and will monitor the results today. I created the second new index as CGM2 to prevent the system complaining about duplicate keys. Thanks Richard Ruslan Zakirov wrote: 4 seconds is still slow, but better than 100-400. About your

Re: [rt-users] Not sending Email and Tools menu failure

2008-03-25 Thread Drew Barnes
Force install Scalar::Util from CPAN. RedHat compiles it with the wrong options. Robert Canary wrote: I am get this error when I click on Tools. Also, RT has stopped sending out emails. I am 99% sure these are related. It was working fine, however, I don't know if RedHat updates broke

[rt-users] Re solved scrip problem

2008-03-25 Thread F350
Greetings, I set up a group called All queues with some members inside. These members are supposed to have read and write rights globally on all the queues just like the members of each queue. The problem is that when a member of the All queues group resolves a ticket, the scrip Resolved is not

Re: [rt-users] Refresh rate on RT at a glance page

2008-03-25 Thread Chris Fabri
On 3/24/08 5:58 PM, Gene LeDuc wrote: Hi All, Is there an easy (or not so easy) way to set the default refresh on the RT at a glance page from Don't refresh this page to some value like every 20 minutes? Can it be added to the personal preferences configuration so that it's an

Re: [rt-users] RT 3.6.4 - Threading of comments in a ticket's history?

2008-03-25 Thread Philip Haworth
Thanks for the reply Drew, I have read up the thread I think you are refering to (http://www.gossamer-threads.com/lists/rt/users/16448?search_string=Dirk %20Pape%20fork;#16448), however this is not the issue. My request for a threaded History view is just a visual display of information - the

Re: [rt-users] RT 3.6.4 - Threading of comments in a ticket's history?

2008-03-25 Thread Philip Haworth
I originally sent this email to Kenneth without realising he CC'd his email to this mailing list, so I am sending this email to the list now: Firstly, sorry for the delay in replying - last Friday was good Friday, then the weekend, and this Monday being another bank holiday has lead to a long

Re: [rt-users] RT 3.6.4 - Threading of comments in a ticket's history?

2008-03-25 Thread Drew Barnes
Re-reading your original, I think I see where our minds got crossed. I originally read it as a client clarifying her original request in an email into your RT box, after you had already commented. Upon re-reading, it now seems that she is emailing you and you are copy/pasting her emails into

Re: [rt-users] Re solved scrip problem

2008-03-25 Thread Kenneth Crocker
F350, Would you mind providing some info? What is the Condition and Action on the scrip in question. Do you use a special Template? Can you list the rights you gave the Global group as opposed to the Group of primary users of the queue? thanks. Kenn LBNL On 3/25/2008 6:06 AM, F350

[rt-users] RT and mysql 5.0 segfault

2008-03-25 Thread Musolino, Peter
A bit of info about the env: RHEL4.6_i386 RT version 3.6.6 Apache 2.0.52-38 MySQL-standard 5.0.24a-0 After a bit of stracing the running httpd processes, I found some information leading up to the segfault. munmap(0xb7f6d000, 4096)= 0 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_IGN},

[rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Phil
When I open up RT 3.6.6 for the first time the initial screen is blank... Is this normal? I mean there are no tickets listed,I have to search for all the tickets first? Can I configure it to show the latest received tickets? Is there a way to configure it so that it lists the latest un assigned

[rt-users] A second quick question or 2 about upgrading....

2008-03-25 Thread Greg Evans
I am preparing to upgrade my rt from 3.65. to 3.6.6. I have now successfully fixed my newbie errors of not using the local directories for changes that I have made or that people from the list have helped me make :-), but I have a couple other concerns that I want to ask about. 1)

[rt-users] Custom Field in ticket display - can a drop down box be added?

2008-03-25 Thread Scott T. Hildreth
We have a Queue that has custom fields and when a ticket is created we can see the custom fields in the ticket display. There is a need to have one of the fields be a drop down box in the ticket display. This would allow the status to be changed, much like the Reminders section of the display.

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Kenneth Crocker
Phil, If you have not used your home page before, you have to set it up. Click edit on the right. Select what youwant to display on your home page and then click home. Kenn LBNL On 3/25/2008 11:37 AM, Phil wrote: When I open up RT 3.6.6 for the first time the initial screen is

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Kenneth Crocker
Phil, Actually, the 3.6.1 DB upgrade only inserts a couple queries as options; the Unowned query and the My own tickets query. There are no DB Schema changes, per se. Hope this helps. Kenn LBNL On 3/25/2008 11:55 AM, Jeff Voskamp wrote: Phil wrote: When I open up RT 3.6.6 for the

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Phil
I tried to run the scripts and I get th following error: Creating database schema. Couldn't find schema file for mysql This is what I ran: /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action schema --datadir etc/upgrade/3.5.1/content install-sh Where can I find the

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Kenneth Crocker
Phil, If you are going to run the DB updates, you will most likely have to get the Admin password to do it. DataBases tend to be strctly protected from jobs that change the database without the correct password. The latest received tickets is one of the queries that comes with the

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Drew Barnes
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action schema --datadir etc/upgrade/3.5.1/content install-sh You have an extra install-sh on that line. Also the --action should be insert. Phil wrote: I tried to run the scripts and I get th following error: Creating

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Kenneth Crocker
Phil, OPPS! I meant 3.5.1, not 3.6.1. That's a typo. Kenn LBNL On 3/25/2008 12:05 PM, Kenneth Crocker wrote: Phil, Actually, the 3.6.1 DB upgrade only inserts a couple queries as options; the Unowned query and the My own tickets query. There are no DB Schema changes,

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Phil
Well I tried with install instead and it said it was an invalid action command... What should be the entire command I should run? On Tue, Mar 25, 2008 at 3:09 PM, Drew Barnes [EMAIL PROTECTED] wrote: /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action schema

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Drew Barnes
You don't need the install-sh anywhere. /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action insert --datadir etc/upgrade/3.5.1/content Phil wrote: Well I tried with install instead and it said it was an invalid action command... What should be the entire command

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Jeff Voskamp
Kenneth Crocker wrote: Phil, Actually, the 3.6.1 DB upgrade only inserts a couple queries as options; the Unowned query and the My own tickets query. There are no DB Schema changes, per se. Hope this helps. Kenn LBNL Installs two Searches and HomepageSettings: { Name =

Re: [rt-users] default screen configuration on 3.6.6

2008-03-25 Thread Phil
You guys ROCK That did it... man thank you very much On Tue, Mar 25, 2008 at 3:22 PM, Jeff Voskamp [EMAIL PROTECTED] wrote: Kenneth Crocker wrote: Phil, Actually, the 3.6.1 DB upgrade only inserts a couple queries as options; the Unowned query and the My own tickets

Re: [rt-users] User ID in a script?

2008-03-25 Thread Kevin Falcone
On Mar 25, 2008, at 3:16 PM, John Arends wrote: Gene, When running your script I get this error: [Tue Mar 25 19:12:39 2008] [crit]: Can't locate object method order_by via package RT::Users at ./rtusers.pl line 14. (/usr/lib/perl5/vendor_perl/5.8.5/RT.pm:346) Can't locate object method

Re: [rt-users] Avoiding ticketing system loops from email submissions

2008-03-25 Thread Matthew Pounsett
On 20-Mar-2008, at 18:13 , Jesse Vincent wrote: On Mar 20, 2008, at 4:06 PM, Matthew Pounsett wrote: Has anyone ever addressed the potential for auto-reply loops between instances of RT that get directed at each other? I'm wondering if RT is smart enough to recognize when an incoming

[rt-users] User Information in RT

2008-03-25 Thread John Arends
We've started to populate the user information for our users in RT (Email, phone, organization, etc) but it seems like this information is not really exposed anywhere except to people who have the rights to administer users. At the top of a ticket, it says something like More about John Doe

[rt-users] Ack! Broke RT!

2008-03-25 Thread Greg Evans
Um, just did the upgrade to 3.6.6 and it seems that I have broken the GUI. Any ideas on how to fix it? Probably a permissions issue somewhere? Greg Evans Hood Canal Communications (360) 898-2481 ext.212 ___

[rt-users] RT authing off of LDAP

2008-03-25 Thread Louis Bohm
I am currently running RT 3.6.6 on Centos 5.0 and I want RT to authorize users from an LDAP directory (specifically sun one directory). I have tried the different methods listed on the LDAP wiki page with little success. The Overly method seems to give the best response. When using it I get the

Re: [rt-users] Ack! Broke RT!

2008-03-25 Thread Jesse Vincent
I bet you didn't run rt-test-dependencies like the README tells you to ;) On Tue, Mar 25, 2008 at 02:39:41PM -0700, Greg Evans wrote: Um, just did the upgrade to 3.6.6 and it seems that I have broken the GUI. Any ideas on how to fix it? Probably a permissions issue somewhere? Greg Evans

Re: [rt-users] Ack! Broke RT!

2008-03-25 Thread Greg Evans
OK apparently I am dumb and missed the rt-test-dependencies step (I must have missed it in either the README or the UPGRADING doc?, but I swear I don't see it when I re-read it) Once I did that and installed CSS:Squish all is well, sorry. Greg Evans Hood Canal Communications (360) 898-2481

Re: [rt-users] User asked for an unknown update type for customfield Category for RT

2008-03-25 Thread Aaron Sallade
This happens when you have a custom field select with categories set in the custom field items. It is supposed to group the items into categories. What happens is that the UI doesn't select the category drop down in the custom field with the selected value from the database, so it throws an error.

[rt-users] A brief preview of what RT 3.8 is going to look like

2008-03-25 Thread Jesse Vincent
http://fsck.com/~jesse/rt-3.8/ has screenshots of the new RT 3.8 theme I've been working on over the past few days. Also, it's now much easier for you to create your own themes and styles for RT. -jesse PGP.sig Description: This is a digitally signed message part

Re: [rt-users] A brief preview of what RT 3.8 is going to look like

2008-03-25 Thread Greg Evans
Very very nice. I like it Greg Evans Hood Canal Communications (360) 898-2481 ext.212 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jesse Vincent Sent: Tuesday, March 25, 2008 4:32 PM To: RT Users Subject: [rt-users] A brief preview of what RT 3.8 is

Re: [rt-users] A brief preview of what RT 3.8 is going to look like

2008-03-25 Thread Kenneth Crocker
Jesse, It looks like you are getting away from the 3.6 navigation bars. I kinda liked them. Will there be a way to keep them like you offered for 3.4? Kenn LBNL On 3/25/2008 4:31 PM, Jesse Vincent wrote: http://fsck.com/~jesse/rt-3.8/ has screenshots of the new RT 3.8 theme I've

Re: [rt-users] A brief preview of what RT 3.8 is going to look like

2008-03-25 Thread Todd Chapman
On Tue, Mar 25, 2008 at 7:31 PM, Jesse Vincent [EMAIL PROTECTED] wrote: http://fsck.com/~jesse/rt-3.8/ http://fsck.com/%7Ejesse/rt-3.8/ has screenshots of the new RT 3.8 theme I've been working on over the past few days. Also, it's now much easier for you to create your own themes and

Re: [rt-users] A brief preview of what RT 3.8 is going to look like

2008-03-25 Thread Jesse Vincent
On Mar 25, 2008, at 8:55 PM, Shen, Tyler wrote: Looks good. Jesse, you once mentioned in the mailing list that RT 3.8 will come with message forwarding function. Can't see it in the screen dumps though. It's there, but below the bottom of the displayed ticket history page. Tyler

Re: [rt-users] A brief preview of what RT 3.8 is going to look like

2008-03-25 Thread Jesse Vincent
On Mar 25, 2008, at 8:26 PM, Kenneth Crocker wrote: Jesse, It looks like you are getting away from the 3.6 navigation bars. I kinda liked them. Will there be a way to keep them like you offered for 3.4? Yep. Themes are now a per-user preference (Though the default is settable

[rt-users] How to include initial ticket content included transaction template when changing owner of a ticket

2008-03-25 Thread Adrien Laurent
Hi RT users, I hope the title says it all :-) I've tried to add: {$Ticket-Content} at the end of the transaction template; but it creates a bug a no email is sent when changing owner of a ticket. Thanks a lot for any hint, Adrien -- Adrien Laurent 514 284 2020 x 202 Modulis: WEB -

Re: [rt-users] A brief preview of what RT 3.8 is going to look like

2008-03-25 Thread John Arends
I really like the look of 3.8. Since I'm a little out of the loop, what is the message forwarding function? How far away is 3.8? A few months? On Mar 25, 2008, at 7:55 PM, Shen, Tyler wrote: Looks good. Jesse, you once mentioned in the mailing list that RT 3.8 will come with message