[rt-users] Not getting connection to mysql and disabled Configuration Tab on main page of RT

2008-02-19 Thread Dhananjay Joshi
Hello, 1. I am trying to install Request Tracker on linux machine. I have installed it on one machine with all the prerequisites. and I have configured it on web so that I can browse it and I am getting the home page of the RT. By mistake in the configuration part super user is disabled. now I ca

[rt-users] Round Robin Scheme

2008-02-19 Thread Kaushal Shriyan
Hi Is there a Round Robin Scheme of assigning Tickets to the users who are using Request Tracker Thanks and Regards Kaushal ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial s

Re: [rt-users] Approvals for resolved tickets?

2008-02-19 Thread Kenneth Crocker
Samuel, I forgot; select "Notify CC's". Kenn On 2/19/2008 3:19 PM, Kenneth Crocker wrote: > Samuel, > > > I would create a Billing Group and put the appropriate UserIDs in that > group (primary person and backup?). Then, add that group as a "CC" > Watcher for every Queue you wa

Re: [rt-users] Approvals for resolved tickets?

2008-02-19 Thread Kenneth Crocker
Samuel, I would create a Billing Group and put the appropriate UserIDs in that group (primary person and backup?). Then, add that group as a "CC" Watcher for every Queue you want this group to be notified from on resolved tickets. Then go to Configuration->Queues->Templates and select

Re: [rt-users] Downloading query results to spreadsheet

2008-02-19 Thread Kenneth Crocker
Stephen & Todd, I copied the Results.html file from /share/html/Search/ to /local/html/Search/. Then I made the changes to /local/html/Search/Results.html (one line for the spreadsheet link. I also removed the code at the end of the line for "RSS" and "Offline") and then I added the n

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Kenneth Crocker
Karl, Now see if the Id number is disabled in the PRINCIPALS Tables. Kenn LBNL On 2/19/2008 12:39 PM, Karl Boyken wrote: > Kenn, is this what you mean? > > mysql> select * from Groups where Description='ACL equiv. for user 12'; > ++-++--

Re: [rt-users] Approvals for resolved tickets?

2008-02-19 Thread Samuel P. Howard
Hi Kenn, At this point, we aren't using Approvals at all, so the answer about ANY ticket is "sorta" ... we do have a few queues that we don't want to know about ... we have other partners using queues in our RT implementation, so we'd probably have to do a user defined condition, I suppose. I

[rt-users] Missing "take" link for some users

2008-02-19 Thread Keith Edmunds
RT 3.6.1 We have four users on this system. In "10 newest unowned tickets", one user has the ticket number as a link and also a 'take' link; the other three users have only a plain-text ticket number and no take link. At first I thought this was down to permissions, but I have granted one use ful

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Karl Boyken
Kenn, is this what you mean? mysql> select * from Groups where Description='ACL equiv. for user 12'; ++-+++---+--+ | id | Name| Description| Domain | Type | Instance | ++-+--

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Kenneth Crocker
Karl, What do you get from the "GROUPS" table? There could be an "equivilancy ID" for that userID. Kenn LBNL On 2/19/2008 11:30 AM, Karl Boyken wrote: > One additional bit of info: > > When I run the Perl code from Wiki that's supposed to restore superuser, > I get "Principal 12 not f

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Kenneth Crocker
Karl, Go to the PRINCIPALS table and look up the correct UserID in the and see if it is enabled/disabled. The USers table doesn't have that info. Kenn LBNL On 2/19/2008 11:10 AM, Karl Boyken wrote: > Yes, I've poked around a bit in the database. I haven't seen anything > glaringly w

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Karl Boyken
One additional bit of info: When I run the Perl code from Wiki that's supposed to restore superuser, I get "Principal 12 not found." root has id 12 in the Users table. Here's the Perl code: /usr/bin/perl -I/opt/rt3/lib -MRT -e'RT::LoadConfig; RT::Init; > my $u=RT::User->new($RT::SystemUser

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Karl Boyken
Yes, I've poked around a bit in the database. I haven't seen anything glaringly wrong yet, but that could be more a statement about my ignorance of the RT schema than anything else. The 'root' user is in Users, and it looks like it has all the settings it would have from creating the initial

Re: [rt-users] Approvals for resolved tickets?

2008-02-19 Thread Kenneth Crocker
Samuel, Do you want to alert billing to ANY ticket that gets resolved, regardless if it was in the Approvals queue or not? if so, a simple scrip with the "onResolve" condition would do it. However, if you have other conditions you want considered, you will need to make that condition

Re: [rt-users] pointers on debugging rt 3.6.5 page hanging problem

2008-02-19 Thread Kenneth Crocker
Tom, Would you mind listing for me any scrips you have relating to a status change and emails as a result of said change? What kind of action precipitated the initial scrip being triggered? Could be that an email notification scrip is looking for a template that you modified or misna

Re: [rt-users] RT Reporting - We need your wishlists

2008-02-19 Thread Jesse Vincent
On Feb 19, 2008, at 1:28 PM, Mathew Snyder wrote: > What kind of time frame are we looking at delivery on this? I've > been holding > off on writing complex reports while I figure out how to create > another > interface for it. However, if these reports will be available in > the next 6 >

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Kenneth Crocker
Karl, Have you gone into the DataBase with SQL and looked at what is in the table records? especially for root? That might help, especially if you see something glaringly odd. Then you could find out what you need to change and modify that particular record. Normally, I wouldn't recomm

[rt-users] pointers on debugging rt 3.6.5 page hanging problem

2008-02-19 Thread Tom Hodder
Hi, A problem appeared today where the browser hangs when the status of a ticket is changed. There do not seem to be any associated errors in the log file, and the page waits for about 30 seconds and then goes to a blank page. I have the level set to debug; [Tue Feb 19 18:44:54 2008] [debug]: A

Re: [rt-users] Linking tickets across queues

2008-02-19 Thread Kenneth Crocker
Mathew, Have you tried the "DependsOn" or "RefersTo" links? I use them and they work great. When I "Display" any ticket with these links, the ticket number, subject, and ticket status shows up in the links section for the current ticket. It does not matter what queue the "linked" ticke

[rt-users] Shredder bug? (was: Shredder web gui, bad path to tickets)

2008-02-19 Thread Gene LeDuc
I found the problem with displaying objects returned by the Shredder search and I think it might be a bug. The files in /share/html/Admin/Tools/Shredder/Elements/Object return a path using $RT::WebBaseURL instead of $RT::WebURL; this leaves off $RT::WebPath. So on my system, links point to

Re: [rt-users] Downloading query results to spreadsheet

2008-02-19 Thread Stephen Turner
At Tuesday 2/19/2008 12:53 PM, Kenneth Crocker wrote: >Stephen, > > thanks. I'm definitely going to look at it. I had modified > the default set of columns in my local directory for this very > purpose. It seems a waste of time to have to delete any unwanted > columns one at a time and t

Re: [rt-users] RT Reporting - We need your wishlists

2008-02-19 Thread Mathew Snyder
What kind of time frame are we looking at delivery on this? I've been holding off on writing complex reports while I figure out how to create another interface for it. However, if these reports will be available in the next 6 months I can probably convince my boss that my delays are justifiable.

Re: [rt-users] RT Reporting - We need your wishlists

2008-02-19 Thread The Anarcat
Not sure this qualifies as a wishlist, but more Munin plugins like this would be useful: http://stats.koumbit.net/koumbit.net/lethe.koumbit.net.html#Rt The source for those is available in: https://lethe.koumbit.net/svn/koumbit/trunk/munin-plugins/ -- Rock journalism is people who can't write

[rt-users] help with custom scrip condition

2008-02-19 Thread Vivek Khera
I have the following scrip condition for my one of my queues, to prevent auto-replies to mail declared spam by spam assassin: --cut here-- if ($self->TransactionObj->Type eq 'Create') { $RT::Logger->error("Got a create transacation..."); my $co = $self->TransactionObj->ContentObj; retur

Re: [rt-users] Downloading query results to spreadsheet

2008-02-19 Thread Kenneth Crocker
Stephen, thanks. I'm definitely going to look at it. I had modified the default set of columns in my local directory for this very purpose. It seems a waste of time to have to delete any unwanted columns one at a time and then to have them show up anyway in a downloaded result. Oh well,

Re: [rt-users] Downloading query results to spreadsheet

2008-02-19 Thread Kenneth Crocker
Todd, thanks. I'll definitely look at this one and the one Stephen Turner mentioned. Thanks a bunch! Kenn LBNL On 2/16/2008 1:48 PM, Todd Chapman wrote: > You need this RT extension for better control of export to spreadsheet. > > http://svn.bestpractical.com/cgi-bin/index.cgi/bps/bro

Re: [rt-users] Linking tickets across queues

2008-02-19 Thread Mathew Snyder
Sweet, thanks to Ruslan and Todd. Looks like the perfect solution Mathew Todd Chapman wrote: > Set StrictLinkACL to 0 in RT_SiteConfig.pm > > > # When this feature is enabled an user need ModifyTicket right on both > # tickets to link them together, otherwise he can have right on any of > # t

[rt-users] Approvals for resolved tickets?

2008-02-19 Thread Samuel P. Howard
Hi. In order to help our billing person, I am trying to find a way to alert her when a ticket gets resolved. I've come up with a few options, and would like some thoughts, opinions, suggestions, etc: 1 - Write a custom scrip that e-mails her upon Status -> Resolved 2 - Try to convince the App

Re: [rt-users] Linking tickets across queues

2008-02-19 Thread Todd Chapman
Set StrictLinkACL to 0 in RT_SiteConfig.pm # When this feature is enabled an user need ModifyTicket right on both # tickets to link them together, otherwise he can have right on any of # two. Set($StrictLinkACL, 1); On 2/19/08, Mathew Snyder <[EMAIL PROTECTED]> wrote: > Our rights scheme is de

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Karl Boyken
Yep, did all that. I rolled back to 3.6.5, and still have the same problem. I suspect I may at some point have screwed up the rt3 database somehow. I use rtx-shredder and at one point, last December, after I first began using it, I inadvertently deleted root, but I restored it and was able t

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Ruslan Zakirov
Have you updated deps, cleaned mason cache and restarted apache server? On Feb 19, 2008 8:19 PM, Karl Boyken <[EMAIL PROTECTED]> wrote: > I don't see even Preferences in the menu bar. I was expecting to be > able to manipulate rights--that's gone. All I see in the menu bar are: > > *Hom

[rt-users] Linking tickets across queues

2008-02-19 Thread Mathew Snyder
Our rights scheme is designed such that each queue has a group associated with it. Users have the Create Ticket right in all other queues so as to be able to move tickets around but they can't own or modify tickets in other queues. This has led to a question from my manager regarding linking tick

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Karl Boyken
I don't see even Preferences in the menu bar. I was expecting to be able to manipulate rights--that's gone. All I see in the menu bar are: *Home * · Simple Search * · Tickets * · Tools * · Approval In other words, root seems to have the same functionality in the GUI as

Re: [rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Todd Chapman
What are you expecting to see? On 2/19/08, Karl Boyken <[EMAIL PROTECTED]> wrote: > Yesterday, I upgraded RT from 3.6.5 to 3.6.6 and now when I login as > root, I don't see any superuser functions available. I don't remember > the last time I logged in as root, but it could only have been a month

[rt-users] Upgraded to 3.6.6 and superuser functionality missing

2008-02-19 Thread Karl Boyken
Yesterday, I upgraded RT from 3.6.5 to 3.6.6 and now when I login as root, I don't see any superuser functions available. I don't remember the last time I logged in as root, but it could only have been a month or two ago. We're using MySQL 5.0.22 as the backend on RedHat Enterprise Server Rel

Re: [rt-users] RT Reporting - We need your wishlists

2008-02-19 Thread Todd Chapman
On 2/14/08, Jesse Vincent <[EMAIL PROTECTED]> wrote: > Hi Everybody, > > I have an RT hacker working on a new, expanded reporting tool for RT. > While I can't promise that we'll implement _every_ report you want, we > could really use your wishlists. > > What reporting and statistics do you want to

Re: [rt-users] Email from RT landing in yahoo bulk folder

2008-02-19 Thread Nadeem Faruque
Vivek Khera wrote, On 18/02/2008 18:47: > On Feb 17, 2008, at 11:32 AM, Erek Dyskant wrote: > >> RT includes a Precedence: Bulk header, which is normally a hint to >> vacation autorepliers that an autoreply is not wanted. However, Yahoo >> sticks any Precedence: Bulk mail into the bulk folder. >

Re: [rt-users] Mapping attributes.

2008-02-19 Thread Fábio M. Catunda
Hi Craig, I searched for my @emailAddress = $$args{'Name'); inside the file that you sent me but I couldnt find. I was wondering to put my modifications at the same place. Are you sure that this is your User_Local.pm file? Thankz! Patterson, Craig escreveu: > I'm not sure if you wanted this

Re: [rt-users] Mapping attributes.

2008-02-19 Thread Patterson, Craig
I'd put some debug statements in there, especially after you bind and after you search so you can isolate where it's dying. Craig -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Fábio M. Catunda" Sent: Monday, February 18, 2008 5:36 PM To: rt-users@lis

Re: [rt-users] Downloading query results to spreadsheet

2008-02-19 Thread Stephen Turner
At Friday 2/15/2008 05:55 PM, Kenneth Crocker wrote: >To all, > > I have just upgraded to 3.6.4 and am having some difficulty > getting the >results of a query into a spreadsheet with the fields I selected for the >query. Instead, I get all sorts of tickets fields I did NOT select and >am

[rt-users] Query to display tickets over a certain size?

2008-02-19 Thread Shannon Adams
I want to list all tickets in RT over 1 mb in size. Any ideas? Thanks, Shannon Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR

[rt-users] modify ticket changes are not completing, the page hangs during submission

2008-02-19 Thread Tom Hodder
Hi, I have got a problem with rt 3.6.5 on rhel4. This was working fine, and I can see no changes to configuration in the last few days (that I have made) If I open a ticket from the home page, and add a comment and change the status to resolved, the page does no complete loading. And just sits an

Re: [rt-users] CLI change owner ship

2008-02-19 Thread Toby Darling
Hi Michael Hess wrote: > I am looking for a way, that I can search all tickets that have not >>> been updated in 72 hours, and change the owner on them to nobody from >>> the CLI. >> >> something like: >> >> /usr/bin/rt list -i "lastupdated = '4 days ago'" | while read t; do >> /usr/bin/rt edit