[rt-users] summing time per queue

2012-10-17 Thread Chris Herrmann
Hi all, Is it possible to use ticket sql to sum a list of tickets by queue? I.e. is there an equivalent to the SQL SUM and Group by construct? Thanks, Chris Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractic

Re: [rt-users] time worked etc display in hours by default?

2012-10-17 Thread Kenneth Crocker
Alex, I had a customer that wanted all time recorded in man days. An entry of 1 would = 1 day (8 hours) and an entry of 1.5 would = 12 hours or 1.5 days. To get this to happen for all search results and displays, I had to change the Database to define all the time fields to have 3 decimal postions

Re: [rt-users] RT ticket stuck in on_hold status

2012-10-17 Thread Kenneth Crocker
Tue, What is RT doing? A description of how it acts, like error messages, etc. would be helpful. Kenn On Wed, Oct 17, 2012 at 1:45 PM, Tue Minh wrote: > > Hi Sir/Madam, > > we are using RT system for our test request tracking purposes. We have a > ticket that was created, resolved and then put

Re: [rt-users] ServiceBusinessHours issue with more then one definition.

2012-10-17 Thread Joop Boonen
On 2012-10-17 18:45, Thomas Sibley wrote: On 10/17/2012 04:56 AM, Joop Boonen wrote: In the CPAN file on http://search.cpan.org/~tsibley/RT-Extension-SLA-0.07/lib/RT/Extension/SLA.pm#Configuring_business_hours I cant find where the keywords, in my case DEF1, DEF2, etc reference to. I assume

Re: [rt-users] SOLVED postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

2012-10-17 Thread Barry L. Kline
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/17/2012 10:26 AM, Mike James wrote: > I'm no expert with SELinux - but I agree this is the better answer. > I'll see if I can figure out how to do it. Thx. I believe you're going to need to set one or more of the selinux booleans. Try: setsebo

[rt-users] RT ticket stuck in on_hold status

2012-10-17 Thread Tue Minh
Hi Sir/Madam, we are using RT system for our test request tracking purposes. We have a ticket that was created, resolved and then put on hold. However, after this ticket is put on hold, we are unable to changed the ticket to any other status. could you please help me with some guildance on w

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-17 Thread Alex Hanselka
Hi, Ah I should have included this in the first place! I am using Scientific Linux 6.3 (RHEL repack thing) and the latest RT, 4.0.7. SELinux is disabled in this case. The owner and group of mason-data is set to my webserver user. rt-server runs fine but rt-server.fcgi refuses to start rega

Re: [rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-17 Thread Mike James
The usual questions - what os, version of RT? Suggestions that worked for me this week - see if SELinux is blocking, make sure owner on the mason-data folder and contents is set to your web server owner's account. Test with a browser on the localhost, check your firewall iptables. Mike -O

[rt-users] spawn-fcgi and rt-server.fcgi fail

2012-10-17 Thread Alex Hanselka
Hi guys! I've searched the googles and found a similar issue but the result didn't work. When I try to run spawn-fcgi it fails with exit code 255. If I try to run rt-server.fcgi with the --port option, it says that the port is in use no matter the port I choose. The similar issue I found o

Re: [rt-users] ServiceBusinessHours issue with more then one definition.

2012-10-17 Thread Thomas Sibley
On 10/17/2012 04:56 AM, Joop Boonen wrote: > In the CPAN file on > http://search.cpan.org/~tsibley/RT-Extension-SLA-0.07/lib/RT/Extension/SLA.pm#Configuring_business_hours > > I cant find where the keywords, in my case DEF1, DEF2, etc reference to. > I assume it's to a group. Not groups but queue

Re: [rt-users] SOLVED postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

2012-10-17 Thread Mike James
I'm no expert with SELinux - but I agree this is the better answer. I'll see if I can figure out how to do it. Thx. -Original Message- From: k...@rice.edu [mailto:k...@rice.edu] Sent: Wednesday, October 17, 2012 9:17 AM To: Mike James Cc: rt-users@lists.bestpractical.com Subject: Re: [rt

Re: [rt-users] SOLVED postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

2012-10-17 Thread k...@rice.edu
Or better yet, update your SELinux rules to allow it to work properly. Cheers, Ken On Tue, Oct 16, 2012 at 09:59:59PM +, Mike James wrote: > Great, that's the answer! Thanks! > > -Original Message- > From: rt-users-boun...@lists.bestpractical.com > [mailto:rt-users-boun...@lists.bes

[rt-users] ServiceBusinessHours issue with more then one definition.

2012-10-17 Thread Joop Boonen
Hi all, I'm trying to set up ServiceBusinessHours. For some reason it doesn't seem to work, when I have more definitions. Is seems to only use the Default. Set( %ServiceBusinessHours, 'Default' => { 1 => { Name => 'Monday', Start => '9:00', End => '18:00' },

Re: [rt-users] time worked etc display in hours by default?

2012-10-17 Thread Alex Young
Seems displaying the Time Worked field and Time Estimated field on the search results always displays it in minutes in 4.0.5. Does anyone else see this behaviour or is it something wrong with our local RT install? Time Left works correctly, showing hours/weeks etc. Also, is it possible to j