Re: [rt-users] How to convert an existing RT from Postgres to MySQL?

2008-06-17 Thread Joop
Todd Chapman wrote: Someone wants me to convert their Postgres backed RT to MySQL. Doesn't matter why, they want it. :) Here's what I am thinking. 1. Shut down the web server. 2. Dump the DB data. 3. Reconfigure RT for MySQL. 4. Run initdb 5. Load the data. 6. Restart the RT/web

[rt-users] RT

2008-06-17 Thread B K
How does RT manage user logon. We run an Active Directory environment and looking at implementing RT. We do not want to replicate our users in linux for them to be able to login to RT to log jobs and check progress. How does RT manage users from AD and does anyone have a very good URL for a

[rt-users] Splitting queues into separate databases

2008-06-17 Thread Johan Baarman
Hi list, My company runs support for different customers on the same RT instance but now due to company policy's we would have the need to split these into separate databases. This would of course involve more than just the queues. Is it possible to do this? The structure of the RT database is

[rt-users] Export from one DB to another?

2008-06-17 Thread Jean-Sebastien Morisset
Hi everyone, I was just given responsibility for a basic RT installation with MySQL in another department. Since it's mostly non-functional right now, I've also been asked to export it's data and import it into our Ops RT installation running with Postgres (this one is _very_ customized). I can

Re: [rt-users] Splitting queues into separate databases

2008-06-17 Thread Joop
Johan Baarman wrote: Hi list, My company runs support for different customers on the same RT instance but now due to company policy's we would have the need to split these into separate databases. This would of course involve more than just the queues. Is it possible to do this? The

[rt-users] Ticket Queries w/ History?

2008-06-17 Thread Jean-Sebastien Morisset
Hi everyone, When running queries for tickets, all the fields appear to be available for display, except the replies, comments, etc. Is there a way to include a ticket's 'history' in the ticket search results? Thanks, js. -- Jean-Sebastien Morisset, Sr. UNIX Administrator [EMAIL PROTECTED]

Re: [rt-users] Sort by DueDate excluding 'not set' tickets

2008-06-17 Thread Jason Fenner
Tom Lanyon wrote: Hi all, I need to sort tickets by due date ascending to display oldest due dates first. Tickets with no due date should come after as there's no impending timeline. However, because a due date of 'not set' is numerically 0, it sorts before any tickets that have a

Re: [rt-users] RT

2008-06-17 Thread Jason Fenner
B K wrote: How does RT manage user logon. We run an Active Directory environment and looking at implementing RT. We do not want to replicate our users in linux for them to be able to login to RT to log jobs and check progress. How does RT manage users from AD and does anyone have a

Re: [rt-users] Ticket Queries w/ History?

2008-06-17 Thread Jason Fenner
Jean-Sebastien Morisset wrote: Hi everyone, When running queries for tickets, all the fields appear to be available for display, except the replies, comments, etc. Is there a way to include a ticket's 'history' in the ticket search results? Thanks, js. What do you mean? What do you

[rt-users] Unable to delete watcher admincc

2008-06-17 Thread Fred Blaise
Hello all, I am trying to remove a group as AdminCC of a queue. When I try to do so, I get: Jun 17 15:34:21 xx RT: Unable to revoke delegated rights for principal 1087 (//var/www/xx/rt-3.6.3/lib/RT/GroupMember_Overlay.pm:334) Jun 17 15:34:21 xx RT: Failed to delete group 949 member

[rt-users] Transaction-level custom fields not working?

2008-06-17 Thread Eirik Øverby
Hi, I'm trying to implement a way to silence the resolve message to requestor. However, I cannot make the following code - or any variant over it - work as expected: return 1 unless ($self-TransactionObj- FirstCustomFieldValue('Silent') =~ /Yes/i ); I have created a customfield named

[rt-users] Transaction-level custom fields not working?

2008-06-17 Thread Eirik Øverby
Hi, I'm trying to implement a way to silence the resolve message to requestor. However, I cannot make the following code - or any variant over it - work as expected: return 1 unless ($self-TransactionObj- FirstCustomFieldValue('Silent') =~ /Yes/i ); I have created a customfield named

Re: [rt-users] Ticket Queries w/ History?

2008-06-17 Thread Jean-Sebastien Morisset
On Tue, Jun 17, 2008 at 09:34:00AM -0400, Jason Fenner wrote: Jean-Sebastien Morisset wrote: Hi everyone, When running queries for tickets, all the fields appear to be available for display, except the replies, comments, etc. Is there a way to include a ticket's 'history' in the ticket

Re: [rt-users] user logon to rt in active directory environment

2008-06-17 Thread Mike Peachey
Jason Fenner wrote: B K wrote: Please be advised that the current wiki page relating to Active Directory authentication is this: http://wiki.bestpractical.com/view/LDAP -- Kind Regards, __ Mike Peachey, IT Tel: +44 114 281 2655 Fax: +44 114

Re: [rt-users] Ticket Queries w/ History?

2008-06-17 Thread Steve Holmes
On Tue, Jun 17, 2008 at 9:34 AM, Jason Fenner [EMAIL PROTECTED] wrote: Jean-Sebastien Morisset wrote: Hi everyone, When running queries for tickets, all the fields appear to be available for display, except the replies, comments, etc. Is there a way to include a ticket's 'history' in

Re: [rt-users] How to convert an existing RT from Postgres to MySQL?

2008-06-17 Thread Todd Chapman
Good point Joop! I'll make sure the initial data doesn't get inserted. Thanks! -Todd On Tue, Jun 17, 2008 at 2:21 AM, Joop [EMAIL PROTECTED] wrote: Todd Chapman wrote: Someone wants me to convert their Postgres backed RT to MySQL. Doesn't matter why, they want it. :) Here's what I am

Re: [rt-users] Transaction-level custom fields not working?

2008-06-17 Thread Drew Barnes
I think that setting a custom field is a separate transaction than the resolve. Try looking into TransactionBatch in RT_SiteConfig.pm and for your scrip. Should be a bit of info on the wiki. Eirik Øverby wrote: Hi, I'm trying to implement a way to silence the resolve message to

[rt-users] RT - group transactions

2008-06-17 Thread Kenneth Crocker
Hey RT gang, I'm interested in catching transactions that occurs when the membership of a group changes. Purpose: I need my ticket owners to be able to select from a list of group members as to whom they want to do the QA test on a ticket. I don't know how to make the group visable for

[rt-users] Tickets for multiple groups

2008-06-17 Thread Chuck Boeheim
Hi Folks, We've been using RT for some years, but now with a decision to ditch Remedy and move all groups to RT, we're getting quite a few new queues. This has caused the situation to arise where some tickets fall into the cracks between groups. A user might send email to the addresses for the

Re: [rt-users] RT - group transactions

2008-06-17 Thread Todd Chapman
RT doesn't have scrips for anything but tickets. You could use Hook::Lexwrap to monitor the methods in Groups_Overlay.pm, but that isn't going to give you any ticket context, so then you would have to search for the affected tickets. On Tue, Jun 17, 2008 at 11:50 AM, Kenneth Crocker [EMAIL

Re: [rt-users] RT - group transactions

2008-06-17 Thread Kenneth Crocker
Todd, Yes, I figured my code would all be new, I just wanted to know if RT had any way of distinguishing a transaction modifying a group as opposed to a trans modifying a ticket. I can code the other stuff. Thanks. Kenn LBNL On 6/17/2008 10:12 AM, Todd Chapman wrote: RT doesn't

Re: [rt-users] RT - group transactions

2008-06-17 Thread Stephen Turner
At 6/17/2008 11:50 AM, Kenneth Crocker wrote: Hey RT gang, I'm interested in catching transactions that occurs when the membership of a group changes. Purpose: I need my ticket owners to be able to select from a list of group members as to whom they want to do the QA test on a ticket.

[rt-users] RT goes down with 500 error - (2)No such file or directory: FastCGI: failed to connect to server /opt/rt3/bin/mason_handler.fcgi:

2008-06-17 Thread tom
Hi, My users starting calling and emailing today, apparently the RT3 web site was down with a 500 error. I am currently running 3.6.6 on RHEL4. The error in the apache log was; [Tue Jun 17 14:15:48 2008] [error] [client 10.127.5.6] (2)No such file or directory: FastCGI: failed to connect to

[rt-users] Can't call method Delete on an undefined value

2008-06-17 Thread Paul O'Leary
Hello All, I just migrated our RT 363 instance from a RHEL 4/Oracle Express instance to a RHEL5.1 64bit Oracle instance. All went fairly well, the data import seemed to be fine. However, I am having trouble with the Take and assign actions. If I create a new ticket and then try to take it or

Re: [rt-users] RT goes down with 500 error - (2)No such file or directory: FastCGI: failed to connect to server /opt/rt3/bin/mason_handler.fcgi:

2008-06-17 Thread jmoseley
I would chalk it up to a temporary problem (bug) with Apache or the FastCGI module... James Moseley [EMAIL PROTECTED] .uk

Re: [rt-users] Transaction-level custom fields not working?

2008-06-17 Thread Eirik Øverby
Thanks, that was helpful. However, I seem to be too stupid to create the proper scrip condition. I thought it should do the following: - Identify transaction as a resolve - Determine whether the customfield (Silent) has a given value (Yes) - If Silent == Yes, do not send resolved

[rt-users] RT Not Sending emails Out

2008-06-17 Thread Enrique Gaona
Hello RT users, I was wondering if anyone knows of a solution to this problem. RT is not sending any email messages and its returning an Undefined subroutine Scalar::Util. I've verified that particular perl lib does exist on the system.Any thoughts? Here are the log messages: Jun 17

[rt-users] The ShowSavedSearches right and a patch for SavedSearches.pm

2008-06-17 Thread William J. Horka
Hello all, Does anyone have experience with granting the ShowSavedSearches right? I found that it wasn't working as I expected and posted this question and patch to the rt-devel list back in February and got no response. I noticed that the behavior is still the same in RT 3.6.7, so I was

Re: [rt-users] RT - group transactions

2008-06-17 Thread Kenneth Crocker
Stephen, That's a thought. I may have to create some jobs down the line, so that would be another way. Thanks. Kenn On 6/17/2008 10:52 AM, Stephen Turner wrote: At 6/17/2008 11:50 AM, Kenneth Crocker wrote: Hey RT gang, I'm interested in catching transactions that occurs

[rt-users] $WebPath not always used

2008-06-17 Thread Brett Pemberton
Hey, I have an RT install (3.6.7) acting odd. The relevant sections of SiteConfig are: Set($WebPath , /rt); Set($WebBaseURL , https://staff.vpac.org;); Set($WebURL , $WebBaseURL . $WebPath . /); Now. On my main screen, in the priority tickets section, there are two links per ticket ... one for

[rt-users] Login on every page problem /Gentoo box/

2008-06-17 Thread Ilia Kantor
Hi, I installed RT via package on Gentoo. It allows me to log in, but every click leads to login page. Login goes ok, but then another click leads to login again etc etc. Every action requires re-login. What's up? I tried lighttpd, nginx with fastcgi, apache with modperl. RT version is 3.6.6,