Re: [rt-users] RT 3.6.6 / LDAP (AD) set up

2008-03-17 Thread Mike Peachey
bkmail08 wrote: Hello, Does anyone know if a solution was posted to this specific thread (see below). If so could you please send me the link? I've googled and the same references keep popping up, but none of them seem to have the solution posted. I am working with RHEL5 server and

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

2008-03-17 Thread Mathew
Well, in that case, I recommend witchcraft. ;) Mathew Richard Ellis wrote: Hi All, We have upgraded to 3.6.6 over the weekend and also run some optimisation against the database but performance is still very poor. I have looked at RTx::RightMatrix and Everyone definately does not have

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

2008-03-17 Thread Richard Ellis
Hi All, We have upgraded to 3.6.6 over the weekend and also run some optimisation against the database but performance is still very poor. I have looked at RTx::RightMatrix and Everyone definately does not have OwnTickets rights unless that is lying to me, which I doubt. I've used the

Re: [rt-users] Since upgrading to 3.6.6 can only set owner of ticket tonobody

2008-03-17 Thread Hoogstraten, Ton
Geoff, Check your Perl module dependencies. I had the same problem and it turned out that perl-DBIx-SearchBuilder needed and update to the latest version. Download the src tar.gz and do a 'configure' 'make testdeps' to see if you are missing modules required. Regards, Ton -Original

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

2008-03-17 Thread Ham MI-ID, Torsten Brumm
Hi Mathew, Richard, I tried also this weekend to upgrade to 3.6.6 and gave it up yesterday evening (rolled back to 3.6.5). To your Problem: If you open the Search Builder menu, it takes a long time to build the page.?!? Have a loko into the owner dropdown menu. Did you find there more people

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

2008-03-17 Thread Mathew
You shouldn't have had to write a patch to fix the immense user drop down. I've created queues with matching groups and assigned the own ticket right to only the groups that correspond to each queue. The Everyone group only has CreateTicket on two public facing queues (all others are

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

2008-03-17 Thread Ham MI-ID, Torsten Brumm
Hi Matthew, We have: Everyone: CreateTicket Privileged: CreateSavedSearch, EditSavedSearches, LoadSavedSearch, ShowSavedSearches Roles: Requestor: ReplyToTicket, ShowTicket The rest is done on a queue base. OK, if i have now 1 Queue and grant to this queue 1 Group the right to OwnTicket,

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

2008-03-17 Thread Mathew
We have Everyone: CreateTicket on two public facing queues Privileged: CommentOnTicket, CreateTicket, SeeQueue, ShowOutgoingEmail, ShowTicket, ShowTicketComments, Watch on all queues Unprivileged: CreateTicket, SeeQueue on one public facing queue (now that I think about it CreateTicket here

Re: [rt-users] RT-Users Digest, Vol 48, Issue 42

2008-03-17 Thread Mike Winn
David, When you do post this 'AD integration for dummies' would you be so kind as to send a link to me or email (even a rough copy is fine!) of your notes? I'm about to undertake the same thing and consider myself new to RT: We're running a test on it to see how well that it will work in

[rt-users] Bounces back to tickets?

2008-03-17 Thread Tom Lanyon
List, Emails coming from RT have a Return-Path of our postmaster, so bounced messages are sent there. Has anyone redirected these bounce messages back into RT to be added as comments/correspondence onto the related ticket? Any side-effects or issues that we should be wary of? Regards, Tom

Re: [rt-users] Fw: Moving RT to another Server

2008-03-17 Thread John BORIS
James, I did what you suggested and made my httpd.conf file look like this with one exception. I have to use the server IP address since my real server is still in operation. So here is my current setting: VirtualHost 172.31.6.213 AddDefaultCharset UTF-8 ErrorLog logs/rt_error_log ServerAdmin

Re: [rt-users] Fw: Moving RT to another Server

2008-03-17 Thread jmoseley
John, use the name of the new server (or whatever 172.31.6.213 resolves to) in RT_SiteConfig. Also, any reason you are using a virtual host? Lastly, I assume you are calling RT at the following URL: http://172.31.6.213/rt/ James Moseley

Re: [rt-users] Bounces back to tickets?

2008-03-17 Thread Vivek Khera
On Mar 17, 2008, at 8:22 AM, Tom Lanyon wrote: Has anyone redirected these bounce messages back into RT to be added as comments/correspondence onto the related ticket? Any side-effects or issues that we should be wary of? http://rt.bestpractical.com/view/RtBounceHandler Latest version

Re: [rt-users] Fw: Moving RT to another Server

2008-03-17 Thread John BORIS
I did set the RT_SiteConfig variable to my IP address. I am calling RT to http://172.31.6.213/ This server is multihomed. I have a limited budget here so any server does more then single duty. Also the systems don't get much work. My trouble tickets have decreased over the years to about two or

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

2008-03-17 Thread Jesse Vincent
On Mar 17, 2008, at 8:29 AM, Richard Ellis wrote: Hi Guys, I'm seeing the same thing. A lot more users in that dropdown than should be there. Richard, I'd like to help get to the bottom of this. Can you send the output of: SELECT * from ACL where RightName = 'OwnTicket' PGP.sig

Re: [rt-users] Fw: Moving RT to another Server

2008-03-17 Thread jmoseley
You defintitely need to be calling it via http://172.31.6.213/rt/ As to your other errors, those are definitely problems. Did you install RT via source or yum repository? Either way, have you done a 'make testdeps' in the source directory to ensure all the Perl modules have been installed?

Re: [rt-users] Scrip question and how to debug?

2008-03-17 Thread John Arends
Vivek: Looking at log output made me realize that $Owner does not contain the name of the owner. Where is the actual owner name stored as a string? I want to compare that string to Nobody. This seems like it should be fairly simple but I don't understand enough about how RT works internally

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

2008-03-17 Thread Jesse Vincent
On Mar 17, 2008, at 11:48 AM, Richard Ellis wrote: Hi Jesse, Ok. Next up: select * from ACL, CachedGroupMembers, Groups where ACL.RightName = 'OwnTicket' and ACL.PrincipalId = Groups.id and Groups.id = CachedGroupMembers.GroupId and (CachedGroupMembers.MemberId = '3' or

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

2008-03-17 Thread Jesse Vincent
On Mon, Mar 17, 2008 at 04:08:52PM +, Richard Ellis wrote: ok, that doesn't look good mysql select * from ACL, CachedGroupMembers, Groups where ACL.RightName = 'OwnTicket' and ACL.PrincipalId = Groups.id and Groups.id = CachedGroupMembers.GroupId and (CachedGroupMembers.MemberId =

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

2008-03-17 Thread Richard Ellis
Hi Jesse, That's worrying because according to the master list of users I have, their should only be 88 users who have permissions to own tickets. Thats probably not the cause of the performance issue though, so I'll shelve that for now to look at later. I'll turn slow queries on now and

Re: [rt-users] Scrip question and how to debug?

2008-03-17 Thread Ham MI-ID, Torsten Brumm
You compare owner-id with nobody string?!? Nobody id is 10 compare owner id with nobody id could work. Torsten Kühne + Nagel (AG Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Alfred Manke, Thorsten Meincke, Mark Reinhardt (Stellv.), Jens

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

2008-03-17 Thread Kenneth Crocker
Mathew, You mentioned needing SeeQueue for Unprivileged users and you already have it for Privileged users. Why not grant CreateTicket, SeeQueue Globally for Everyone (saves redundant granting) and ShowTicket Globally for Requestors? That way any requestor can always See their ticket

[rt-users] Query builder error

2008-03-17 Thread Roger Mastrude
Hi, folks. Can anyone give me a steer on this issue: I'm using the query builder to create a search, Requester Email contains PRB123. When I try to search on it, I'm getting the error message Unknown field: Requestor.EmailAddress. This happens when I try to search onother Requester attributes

Re: [rt-users] Scrip question and how to debug?

2008-03-17 Thread John Arends
$Owner-Name was what I was looking for. I'll have to post my scrip so other people can figure out what is going on. John Arends wrote: Vivek: Looking at log output made me realize that $Owner does not contain the name of the owner. Where is the actual owner name stored as a string? I

[rt-users] Upgrade Oracle to 10g r2

2008-03-17 Thread Kenneth Crocker
To all, Does anyone know if there is an RT problem related to upgrading Oracle DB to 10g r2? We're running 3.6.4 and planning to do that but I wanted to see if that would cause any RT problems. Thanks in advance. Kenn LBNL ___

Re: [rt-users] Upgrade Oracle to 10g r2

2008-03-17 Thread Joop van de Wege
Kenneth Crocker wrote: To all, Does anyone know if there is an RT problem related to upgrading Oracle DB to 10g r2? We're running 3.6.4 and planning to do that but I wanted to see if that would cause any RT problems. Thanks in advance. I have been running RT on Oracle XE, not quite

Re: [rt-users] Upgrade Oracle to 10g r2

2008-03-17 Thread Joe Casadonte
On 3/17/2008 2:40 PM, Kenneth Crocker wrote: Does anyone know if there is an RT problem related to upgrading Oracle DB to 10g r2? We're running 3.6.4 and planning to do that but I wanted to see if that would cause any RT problems. Thanks in advance. I'm running RT on systems with

Re: [rt-users] Upgrade Oracle to 10g r2

2008-03-17 Thread Kenneth Crocker
Joop, Kool. Thanks. What version are you on now? Kenn LBNL On 3/17/2008 12:37 PM, Joop van de Wege wrote: Kenneth Crocker wrote: To all, Does anyone know if there is an RT problem related to upgrading Oracle DB to 10g r2? We're running 3.6.4 and planning to do that but I

Re: [rt-users] Upgrade Oracle to 10g r2

2008-03-17 Thread Stephen Turner
At Monday 3/17/2008 03:43 PM, Joe Casadonte wrote: On 3/17/2008 2:40 PM, Kenneth Crocker wrote: Does anyone know if there is an RT problem related to upgrading Oracle DB to 10g r2? We're running 3.6.4 and planning to do that but I wanted to see if that would cause any RT problems.

Re: [rt-users] Upgrade Oracle to 10g r2

2008-03-17 Thread Kenneth Crocker
Joe, Thanks. Good to know. Kenn LBNL On 3/17/2008 12:43 PM, Joe Casadonte wrote: On 3/17/2008 2:40 PM, Kenneth Crocker wrote: Does anyone know if there is an RT problem related to upgrading Oracle DB to 10g r2? We're running 3.6.4 and planning to do that but I wanted to

[rt-users] User ID in a script?

2008-03-17 Thread John Arends
I wrote a quick perl script that outputs a bunch of information about all the users in my RT instance. I noticed that the ID numbers are all over the place. One of my early users was created with an ID of 22, and then the next user has an ID of 29, and then the next one is somewhere in the mid

Re: [rt-users] Upgrade Oracle to 10g r2

2008-03-17 Thread Joe Casadonte
On 3/17/2008 3:54 PM, Stephen Turner wrote: Do you see anything in the RT log? We've had this symptom when using Oracle-specific sql functions against a mysql database. The RT log revealed the problem in our case. It's been a long time since I've looked into this. I remember capturing the

Re: [rt-users] Bounces back to tickets?

2008-03-17 Thread Tom Lanyon
On 18/03/2008, at 12:28 AM, Vivek Khera wrote: On Mar 17, 2008, at 8:22 AM, Tom Lanyon wrote: Has anyone redirected these bounce messages back into RT to be added as comments/correspondence onto the related ticket? Any side-effects or issues that we should be wary of?

[rt-users] Ability to attach RTFM article at ticket creation

2008-03-17 Thread Paul Choi
Hello, Is there a way to attach an RTFM article at the time of ticket creation via the web interface? I see that when we are replying only we can use RTFM. We are using the web interface to create a ticket (kind of like an incident report) to notify partners and customers. And then they can

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

2008-03-17 Thread Gene LeDuc
Hi John, You can use this script as a starting point to loop through all your users: #!/usr/bin/perl -w ### External libraries ### use strict; ### Modify the next line to fit your installation use lib (/opt/local/software/rt-3.6.3/lib); package RT; use RT::Interface::CLI qw(CleanEnv loc); use

Re: [rt-users] Since upgrading to 3.6.6 can only set owner of ticket tonobody

2008-03-17 Thread Geoff Roberts
Hi Ton/Jesse, On Mon, 17 Mar 2008 09:36:48 pm you wrote: Check your Perl module dependencies. I had the same problem and it turned out that perl-DBIx-SearchBuilder needed and update to the latest version. Download the src tar.gz and do a 'configure' 'make testdeps' to see if you are missing

Re: [rt-users] RT 3.6.6 / LDAP (AD) set up

2008-03-17 Thread bkmail08
Hi Mike, It would seem that you do not have your logging level set to debug -- that would certainly help by printing out more information. I have debug enabled: Set($LogToFileNamed, /var/log/rt3/rt.log); Set($LogToFile, 'debug'); in RT_SiteConfig.pm -- is there another place I should enable