Re: [rt-users] Add group membership via CLI

2013-05-14 Thread Asif Iqbal
On Tue, May 14, 2013 at 5:20 PM, Asif Iqbal wrote: > while () > { > $user->Load( $_ ); > $group->AddMember( $user->PrincipalObj->Id ); > } > I found the hint from another email with subject CLI Question - Add Users to group per Scrip from Feb 28, 2007 from Joe Casadonte at oracle.com. I rem

Re: [rt-users] REMOTE_USER, external auth, and email mismatching

2013-05-14 Thread Philip Brown
Err.. thanks, but that's not what I'm looking for. For one thing, even if I got permission to do that (which I wont), we have 40,000 users in ldap. I dont actually WANT all of them in the rt database. particularly since we have a 15,000 user/year churn rate. _

[rt-users] Flaws on RT::Extension::RepeatTicket search

2013-05-14 Thread Thomas Lau
Hi, I recently tested out the new RT::Extension::RepeatTicket module, it works out great, but the search feature is basically non-existence. How could I search the original ticket which is GOING to repeat later on? Current situation there is no way to do this, please advise. -- RT Training i

Re: [rt-users] Add group membership via CLI

2013-05-14 Thread Asif Iqbal
oops.. sorry for posting twice. I thought it did not make it to the ML first time On Tue, May 14, 2013 at 9:28 PM, Asif Iqbal wrote: > I am trying to add a list of UIDs into one of my group and it is failing. > > I am running the script that was posted with this subject on Nov 22, 2010 > by tan

[rt-users] Add group membership via CLI

2013-05-14 Thread Asif Iqbal
I am trying to add a list of UIDs into one of my group and it is failing. I am running the script that was posted with this subject on Nov 22, 2010 by tanhuy.langloy at bt. I am running it on RT 3.8.2 #!/usr/bin/perl # Utilisation : ./rtgroupmember.pl GROUPNAME # Attention : Le fichier list.txt d

Re: [rt-users] REMOTE_USER, external auth, and email mismatching

2013-05-14 Thread Jok Thuau
I have use the LDAPImport extension to pull all my users out of AD into RT. I even submitted a patch on the cpan bug tracker to add a feature to "automatically grant rights" to some groups based on LDAP queries. (and you'll probably need to "merge" the users that you have now into their imported e

[rt-users] Add group membership via CLI

2013-05-14 Thread Asif Iqbal
I followed the script from Emmanuel and Tanguy from Nov 20, 2010 with this subject to add a list of members to a group and it is failing. I made some changes to match page 99 of the RT Essentials book. #!/usr/bin/perl -w use strict; use lib "/opt/rt3/lib"; use RT; use RT::Interface::CLI qw( Clean

Re: [rt-users] Problems upgrading from 3.9.3

2013-05-14 Thread Ruslan Zakirov
On Tue, May 14, 2013 at 11:27 PM, Thomas Sibley wrote: > spclocation Looks like splocation is gone in Pg 9.2: http://www.postgresql.org/message-id/1334867818.2281.15.camel@localhost.localdomain -- Best regards, Ruslan. -- RT Training in Seattle, June 19-20: http://bestpractical.com/traini

Re: [rt-users] REMOTE_USER, external auth, and email mismatching

2013-05-14 Thread Philip Brown
On 04/26/13 04:38 PM, Thomas Sibley wrote: On 04/26/2013 02:35 PM, Philip Brown wrote: hi there, We are looking at using kerb auth and mod_auth_kerb as our external auth mechanism for RT. ... I was hoping there was potentially a way to do any of the following: a) automatically drop the @xyz f

[rt-users] CF limit size

2013-05-14 Thread Albert Shih
Hi all, I want to use RT to track and most important make a history of all infrastructure problem like power out, hardware failure etc. So what I'm intend to do is create a queue with special CF (custom field) and use the REST interface to extract information for our website. I've got a problem

[rt-users] AD External Authentication

2013-05-14 Thread MacKillip, Scott
Hello, I have a question about installing and using the Active Directory (AD)Authentication extension plug-in for RT that I hope has a straight-forward answer. I have read the mail list archives, perused the book for RT, absorbed as much information from the on-line documentation for installing

Re: [rt-users] making a custom field mandatory for select queues

2013-05-14 Thread Thomas Sibley
On 05/14/2013 07:32 AM, Darin Perusich wrote: > Hello All, > > It's is possible to make a custom field mandatory of selective queues? > Say I have a CF called "Environment" who's values are test, > development, and production which is a global CF since it may apply > any queue, but only needs to b

Re: [rt-users] Problems upgrading from 3.9.3

2013-05-14 Thread Thomas Sibley
On 05/14/2013 08:57 AM, saxmad wrote: > ERROR: One of initial functions failed: DBD::Pg::db table_info failed: > ERROR: column t.spclocation does not exist > LINE 11: ...t(t.spcname) AS "pg_tablespace_name", quote_ident(t.spclocat... >

[rt-users] Getting a clean ticket history

2013-05-14 Thread Brent Wiese
Is there a way to copy/paste, export, or some other means a ticket's entire history? I searched around the archives and didn't find anything that would work for me. I tried to forward a ticket to my email address hoping that would work, but it didn't include comments. It was also a mess of atta

[rt-users] [Announce] Puppet Request Tracker Module

2013-05-14 Thread Darin Perusich
This is a cross-list post. I'd like to announce the initial release of a puppet request-tracker module, darin-rt, for managing Request Tracker. The module will install request-tracker and database packages, install request-tracker extensions (if packages are available in the repo), and create basi

[rt-users] Post upgrade 3.8.5 to 4.0.12 Global->RT At A Glance error

2013-05-14 Thread Pete Beebe
Your system config page and SQL results reveal that you have duplicate copies (3 total of each record) of certain global data. This suggests your migration from MySQL to Oracle was flawed. How did you migrate, exactly? As follows: 1. Created new OEL 6.4 x64 server running Apache/Mysqld from

Re: [rt-users] Problems upgrading from 3.9.3

2013-05-14 Thread saxmad
The need to get this upgrade working is mounting, so I have been trying various combinations of sequences of events to try and make progress. While I still get the errors as previously when trying to run # rt-setup-database-4 --action acl --dba postgres, I decided to ignore that and carry on with

Re: [rt-users] making a custom field mandatory for select queues

2013-05-14 Thread Ruslan Zakirov
Only with some hacking. On Tue, May 14, 2013 at 6:32 PM, Darin Perusich wrote: > Hello All, > > It's is possible to make a custom field mandatory of selective queues? > Say I have a CF called "Environment" who's values are test, > development, and production which is a global CF since it may ap

Re: [rt-users] tmp directory consuming all my disk space

2013-05-14 Thread Ruslan Zakirov
On Tue, May 14, 2013 at 6:21 PM, Mª Eugenia Moreno wrote: > What I have are directories like 0QMkXkZEI3 containing the following > files: > part-28302-1.txt > part-28302-2.html > part-28302-3.CSV > part-28302-4.CSV > part-28302-5.CSV > > The txt file contains the content of an email. The html fil

[rt-users] making a custom field mandatory for select queues

2013-05-14 Thread Darin Perusich
Hello All, It's is possible to make a custom field mandatory of selective queues? Say I have a CF called "Environment" who's values are test, development, and production which is a global CF since it may apply any queue, but only needs to be mandatory in queue XYZ. Can this be done? -- Later, Dar

Re: [rt-users] tmp directory consuming all my disk space

2013-05-14 Thread Mª Eugenia Moreno
What I have are directories like 0QMkXkZEI3 containing the following files: part-28302-1.txt part-28302-2.html part-28302-3.CSV part-28302-4.CSV part-28302-5.CSV The txt file contains the content of an email. The html file seems the same email but in html format. What is the different between us

Re: [rt-users] tmp directory consuming all my disk space

2013-05-14 Thread Ruslan Zakirov
Hi, Can you check content of those tmp files and send head of a file? Set WebDomain instead of WebBaseURL. Otherwise your config is very simple. On Tue, May 14, 2013 at 1:21 PM, Mª Eugenia Moreno wrote: > Sure! Here you are: RT_SiteConfig.pm > > Set($Organization, "company.com"); > > Set($Data

[rt-users] RT::Extension::QuickUpdate feature request

2013-05-14 Thread Darin Perusich
Hello All, I was wanting to create a feature request for RT::Extension::QuickUpdate but there's no project for it in CPAN or way to create github issues so I'm posting it here instead. I'd like to see QuickUpdate extended to support PriorityAsString's if that extension's been enabled, or provide

Re: [rt-users] Problem with mail bounce

2013-05-14 Thread Guadagnino Cristiano
Thomas, thank you very much!!! This is exactly what I was looking for. Also, I am happy to know that this limitation will be removed in 4.2. Bye Cris Thomas Sibley wrote: Instead of doing the above, why don't you just keep it inside RT all along? 1) Copy text to forward into a new RT comment

Re: [rt-users] tmp directory consuming all my disk space

2013-05-14 Thread Mª Eugenia Moreno
Sure! Here you are: RT_SiteConfig.pm Set($Organization, "company.com"); Set($DatabaseHost, "localhost"); Set($DatabaseRTHost, "localhost"); Set($DatabasePort, "3306"); Set($DatabaseUser, "user"); Set($DatabasePassword, "psw"); Set($DatabaseName, "rt4"); Set($DatabaseRequireSSL, undef); Se