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);

Set($WebBaseURL, http://server.com:80;);

Set($WebPath, );

Set(@LexiconLanguages, qw(en));

Set($Timezone, Europe/London);

Set($CorrespondAddress, 'corresp...@gmail.com');

Set($CommentAddress, 'comm...@gmail.com');

Set(%Lifecycles,
default = {
initial = [ 'new' ],
active  = [ 'open', 'stalled' ],
inactive= [ 'resolved', 'rejected', 'deleted' ],

defaults = {
on_create = 'new',
on_merge  = 'resolved',
approved  = 'open',
denied= 'rejected',
reminder_on_open = 'open',
reminder_on_resolve  = 'resolved',
},

transitions = {
''   = [qw(new open resolved)],

# from   = [ to list ],
new  = [qw(open stalled resolved rejected deleted)],
open = [qw(new stalled resolved rejected deleted)],
stalled  = [qw(new open rejected resolved deleted)],
resolved = [qw(new open stalled rejected deleted)],
rejected = [qw(new open stalled resolved deleted)],
deleted  = [qw(new open stalled rejected resolved)],
},
rights = {
'* - deleted'  = 'DeleteTicket',
'* - *'= 'ModifyTicket',
},
actions = [
'new - open'  = {
label  = 'Open It', # loc
update = 'Respond',
},
'new - resolved'  = {
label  = 'Resolve', # loc
update = 'Comment',
},
'new - rejected'  = {
label  = 'Reject', # loc
update = 'Respond',
},
'new - deleted'   = {
label  = 'Delete', # loc
},
'open - stalled'  = {
label  = 'Stall', # loc
update = 'Comment',
},
'open - resolved' = {
label  = 'Resolve', # loc
update = 'Comment',
},
'open - rejected' = {
label  = 'Reject', # loc
update = 'Respond',
},
'stalled - open'  = {
label  = 'Open It', # loc
},
'resolved - open' = {
label  = 'Re-open', # loc
update = 'Comment',
},
'rejected - open' = {
label  = 'Re-open', # loc
update = 'Comment',
},
'deleted - open'  = {
label  = 'Undelete', # loc
},
],
},
# don't change lifecyle of the approvals, they are not capable to deal with
# custom statuses
 approvals = {
initial = [ 'new' ],
active  = [ 'open', 'stalled' ],
inactive= [ 'resolved', 'rejected', 'deleted' ],

defaults = {
on_create = 'new',
on_merge = 'resolved',
reminder_on_open = 'open',
reminder_on_resolve  = 'resolved',
},

transitions = {
''   = [qw(new open resolved)],

# from   = [ to list ],
new  = [qw(open stalled resolved rejected deleted)],
open = [qw(new stalled resolved rejected deleted)],
stalled  = [qw(new open rejected resolved deleted)],
resolved = [qw(new open stalled rejected deleted)],
rejected = [qw(new open stalled resolved deleted)],
deleted  = [qw(new open stalled rejected resolved)],
},
rights = {
'* - deleted'  = 'DeleteTicket',
'* - rejected' = 'ModifyTicket',
'* - *'= 'ModifyTicket',
},
actions = [
'new - open'  = {
label  = 'Open It', # loc
update = 'Respond',
},
'new - resolved'  = {
label  = 'Resolve', # loc
update = 'Comment',
},
'new - rejected'  = {
label  = 'Reject', # loc
update = 'Respond',
},
'new - deleted'   = {
label  = 'Delete', # loc
},
'open - stalled'  = {
label  = 'Stall', # loc
update = 'Comment',
},
'open - resolved' = {
label  = 'Resolve', # loc
update = 'Comment',
},
'open - rejected' = {
label  = 'Reject', # loc
update = 'Respond',
},
'stalled - open'  = {
label  = 'Open It', # loc
},
   

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
2) Set the One-time Cc to the person receiving the forward
3) Uncheck all other recipients from the Scrips and Recipients box.
This should be easier if you enable the $SimplifiedRecipients option.

Then the forward will come from RT originally, only go to the one-time
cc, and be recorded on the ticket.  Any replies will end up as comments
on the ticket (assuming your queue comment address and /etc/aliases is
setup correctly).  Less steps, less needing to go outside RT only to
shove stuff back in.




--
Cristiano Guadagnino
Servizio Data Administration
Bankadati S.I.
Gruppo Credito Valtellinese
Tel. +39-0342-522172


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

[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 a configuration option to
enable it. The majority of the time when setting the priority it's
done via QuickUpdate, users will try and type low|meduim|high into the
field, and it will unify the Priority display in the UI.

--
Later,
Darin


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


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 meugeni...@gmail.comwrote:

 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);

 Set($WebBaseURL, http://server.com:80;);

 Set($WebPath, );

 Set(@LexiconLanguages, qw(en));

 Set($Timezone, Europe/London);

 Set($CorrespondAddress, 'corresp...@gmail.com');

 Set($CommentAddress, 'comm...@gmail.com');

 Set(%Lifecycles,
 default = {
 initial = [ 'new' ],
 active  = [ 'open', 'stalled' ],
 inactive= [ 'resolved', 'rejected', 'deleted' ],

 defaults = {
 on_create = 'new',
 on_merge  = 'resolved',
 approved  = 'open',
 denied= 'rejected',
 reminder_on_open = 'open',
 reminder_on_resolve  = 'resolved',
 },

 transitions = {
 ''   = [qw(new open resolved)],

 # from   = [ to list ],
 new  = [qw(open stalled resolved rejected deleted)],
 open = [qw(new stalled resolved rejected deleted)],
 stalled  = [qw(new open rejected resolved deleted)],
 resolved = [qw(new open stalled rejected deleted)],
 rejected = [qw(new open stalled resolved deleted)],
 deleted  = [qw(new open stalled rejected resolved)],
 },
 rights = {
 '* - deleted'  = 'DeleteTicket',
 '* - *'= 'ModifyTicket',
 },
 actions = [
 'new - open'  = {
 label  = 'Open It', # loc
 update = 'Respond',
 },
 'new - resolved'  = {
 label  = 'Resolve', # loc
 update = 'Comment',
 },
 'new - rejected'  = {
 label  = 'Reject', # loc
 update = 'Respond',
 },
 'new - deleted'   = {
 label  = 'Delete', # loc
 },
 'open - stalled'  = {
 label  = 'Stall', # loc
 update = 'Comment',
 },
 'open - resolved' = {
 label  = 'Resolve', # loc
 update = 'Comment',
 },
 'open - rejected' = {
 label  = 'Reject', # loc
 update = 'Respond',
 },
 'stalled - open'  = {
 label  = 'Open It', # loc
 },
 'resolved - open' = {
 label  = 'Re-open', # loc
 update = 'Comment',
 },
 'rejected - open' = {
 label  = 'Re-open', # loc
 update = 'Comment',
 },
 'deleted - open'  = {
 label  = 'Undelete', # loc
 },
 ],
 },
 # don't change lifecyle of the approvals, they are not capable to deal with
 # custom statuses
  approvals = {
 initial = [ 'new' ],
 active  = [ 'open', 'stalled' ],
 inactive= [ 'resolved', 'rejected', 'deleted' ],

 defaults = {
 on_create = 'new',
 on_merge = 'resolved',
 reminder_on_open = 'open',
 reminder_on_resolve  = 'resolved',
 },

 transitions = {
 ''   = [qw(new open resolved)],

 # from   = [ to list ],
 new  = [qw(open stalled resolved rejected deleted)],
 open = [qw(new stalled resolved rejected deleted)],
 stalled  = [qw(new open rejected resolved deleted)],
 resolved = [qw(new open stalled rejected deleted)],
 rejected = [qw(new open stalled resolved deleted)],
 deleted  = [qw(new open stalled rejected resolved)],
 },
 rights = {
 '* - deleted'  = 'DeleteTicket',
 '* - rejected' = 'ModifyTicket',
 '* - *'= 'ModifyTicket',
 },
 actions = [
 'new - open'  = {
 label  = 'Open It', # loc
 update = 'Respond',
 },
 'new - resolved'  = {
 label  = 'Resolve', # loc
 update = 'Comment',
 },
 'new - rejected'  = {
 label  = 'Reject', # loc
 update = 'Respond',
 },
 'new - deleted'   = {
 label  = 'Delete', # loc
 },
 'open - stalled'  = {
 label  = 'Stall', # loc
 update = 'Comment',
  

[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,
Darin


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


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 meugeni...@gmail.comwrote:

 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.


hm. this needs investigation. If you want this thread not to disappear in
the mailing list then file a bug report to
http://issues.bespractical.comwith summary and link to this thread in
some online archive.

What is the different between using WebDomain or WebBaseURL? What is the
 reason to set WebDomain  instead?


The reason is that WebDomain now is not set to correct value.

http://bestpractical.com/rt/docs/latest/RT_Config.html#WebBaseURL-WebURL

Thanks,
 Maria




 2013/5/14 Ruslan Zakirov r...@bestpractical.com

 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 
 meugeni...@gmail.comwrote:

 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);

 Set($WebBaseURL, http://server.com:80;);

 Set($WebPath, );

 Set(@LexiconLanguages, qw(en));

 Set($Timezone, Europe/London);

 Set($CorrespondAddress, 'corresp...@gmail.com');

 Set($CommentAddress, 'comm...@gmail.com');

 Set(%Lifecycles,
 default = {
 initial = [ 'new' ],
 active  = [ 'open', 'stalled' ],
 inactive= [ 'resolved', 'rejected', 'deleted' ],

 defaults = {
 on_create = 'new',
 on_merge  = 'resolved',
 approved  = 'open',
 denied= 'rejected',
 reminder_on_open = 'open',
 reminder_on_resolve  = 'resolved',
 },

 transitions = {
 ''   = [qw(new open resolved)],

 # from   = [ to list ],
 new  = [qw(open stalled resolved rejected deleted)],
 open = [qw(new stalled resolved rejected deleted)],
 stalled  = [qw(new open rejected resolved deleted)],
 resolved = [qw(new open stalled rejected deleted)],
 rejected = [qw(new open stalled resolved deleted)],
 deleted  = [qw(new open stalled rejected resolved)],
 },
 rights = {
 '* - deleted'  = 'DeleteTicket',
 '* - *'= 'ModifyTicket',
 },
 actions = [
 'new - open'  = {
 label  = 'Open It', # loc
 update = 'Respond',
 },
 'new - resolved'  = {
 label  = 'Resolve', # loc
 update = 'Comment',
 },
 'new - rejected'  = {
 label  = 'Reject', # loc
 update = 'Respond',
 },
 'new - deleted'   = {
 label  = 'Delete', # loc
 },
 'open - stalled'  = {
 label  = 'Stall', # loc
 update = 'Comment',
 },
 'open - resolved' = {
 label  = 'Resolve', # loc
 update = 'Comment',
 },
 'open - rejected' = {
 label  = 'Reject', # loc
 update = 'Respond',
 },
 'stalled - open'  = {
 label  = 'Open It', # loc
 },
 'resolved - open' = {
 label  = 'Re-open', # loc
 update = 'Comment',
 },
 'rejected - open' = {
 label  = 'Re-open', # loc
 update = 'Comment',
 },
 'deleted - open'  = {
 label  = 'Undelete', # loc
 },
 ],
 },
 # don't change lifecyle of the approvals, they are not capable to deal
 with
 # custom statuses
  approvals = {
 initial = [ 'new' ],
 active  = [ 'open', 'stalled' ],
 inactive= [ 'resolved', 'rejected', 'deleted' ],

 defaults = {
 on_create = 'new',
 on_merge = 'resolved',
 reminder_on_open = 'open',
 reminder_on_resolve  = 'resolved',
 },

 transitions = {
 ''   = [qw(new open resolved)],

 # from   = [ to list ],
 new  = [qw(open stalled resolved rejected deleted)],
 open = [qw(new stalled resolved rejected deleted)],
 stalled  = [qw(new open rejected resolved deleted)],
 resolved = [qw(new open stalled rejected deleted)],
 rejected = [qw(new open stalled 

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 da...@darins.net 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 be mandatory in queue XYZ. Can this be
 done?

 --
 Later,
 Darin


 --
 RT Training in Seattle, June 19-20: http://bestpractical.com/training




-- 
Best regards, Ruslan.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

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 the upgrade.

This time, I have been able to get as far as 3.9.8 before getting any
errors. This is a lot further than I have ever got before, so I'm feeling
slightly more encouraged that I can get this working eventually.

Anyway, the error message I now get is as follows :-

..
snip
..
Processing 3.9.8
Now populating database schema.
Now inserting data.
[Tue May 14 15:49:07 2013] [warning]: 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...
  ^ at
/usr/share/request-tracker4/etc/upgrade/3.9.8/content line 3.
(/usr/share/request-tracker4/etc/upgrade/3.9.8/content:3)
Couldn't finish 'upgrade' step.

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...
  ^ at
/usr/share/request-tracker4/etc/upgrade/3.9.8/content line 3.

I'm going to try Googling about this error, but any more formal and
knowledgeable response would be gratefully received.

Gary




--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Problems-upgrading-from-3-9-3-tp53543p53840.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


[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 distrib packages.  
Additionally installed a newer version of Perl and fought with character set 
issues between old and new server configurations.
2. mysqldump'd data from old server and imported into an empty rt4 mysql 
database on the new server
3. Upgraded mysql RT3 data to RT4 using make upgrade-database (4.0.12).
3. Prepped Oracle schema using RT 4.0.12 configuration and then truncated all 
tables from new schema as well as disabled constraints as prep for import.
4. Ran a perl script obtained from a user from this thread: 
http://requesttracker.8502.n7.nabble.com/mysql-to-oracle-migration-td34166.html.
  Script pretty much copies records from their mysql tables into their 
respective Oracle tables
5. Re-created the Oracle sequences after import.
6. Re-enabled Oracle table constraints.

I could forward you a PDF of the actual upgrade steps however it's not for 
public digestion since it's replete with confidential data that'd be a PIA to 
scrub.

What do these queries return? 

select id, Name, Created, LastUpdated from Users where Name in ('RT_System', 
'Nobody', 'root'); 

ID  NAME,CREATED,LASTUPDATED
10  Nobody,6-Sep-05,6-Sep-05
1   RT_System,6-Sep-05,6-Sep-05
12  root,6-Sep-05,  4-May-13

select id, Domain, Type, Created, LastUpdated from Groups where Type in 
('Everyone', 'Privileged', 'Unprivileged'); 

ID  DOMAIN, TYPE,CREATED,LASTUPDATED
3   SystemInternal,Everyone,,   
4   SystemInternal,Privileged,, 
5   SystemInternal,Unprivileged,,



Disclaimer: This electronic message may contain information that is 
Confidential or legally privileged. It is intended only for the use of the 
individual(s) and entity named in the message. If you are not an intended 
recipient of this message, please notify the sender immediately and delete the 
material from your computer. Do not deliver, distribute or copy this message 
and do not disclose its contents or take any action in reliance on the 
information it contains.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


[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 basic
request-tracker queues.

This is also a request for help in extending the module to support
more operating systems! Currently it only supports SuSE systems, my
distro of choice, so I'm hopeful people from the community who use RT
and Puppet will extend this module to support a more verbose set of
operating systems. If you're interested in contributing please contact
me off-list and I'll help get you up to speed.

Enjoy!

Puppet Forge: http://forge.puppetlabs.com/darin/rt
GitHub: https://github.com/deadpoint/puppet-rt
Installation: puppet module install darin-rt

--
Later,
Darin


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


[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 attached messages, not a single 
listing.

I also tried installing the windows generic / text printer driver and the 
output rendered terribly (not surprising).

Thanks,
Brent


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

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...
   ^ at
 /usr/share/request-tracker4/etc/upgrade/3.9.8/content line 3.

What version of Pg are you running?



-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


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 be mandatory in queue XYZ. Can this be
 done?

Depending on your definition of mandatory, the plugin
RT-Extension-MandatoryOnTransition might be what you want.  It lets you
specify per-queue mandatoryness, but does expect that you're only
requiring the CFs are filled on creation or resolution or some other
particular status transition.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


[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 and upgrading 
RT.

The only change I want to make in RT is AD Authentication. I don't want to add 
new users if they don't exist in RT but do in AD (so $WebExternalAuto will be 
set to 0).

If the user has an account in RT (set up by an RT administrator) they should 
still have the same functionality, just authentication is coming from AD and 
not the internal RT database.

If the user does not have an account in AD they should be denied access.

If the user does not have an account in RT, they should be directed to the 
self-service pages.

If the user does have an account in RT, they should not notice any difference 
after installing the AD Authentication module.

Given the above requirements, will the following steps accomplish this?

1.  Install RT::Authen::ExternalAuth

2.  Configure same to use LDAP

3.  Set $WebExternalAuth to 0 in RT_SiteConfig.pm

4.  Set $AutoCreateNonExternalUsers to 0 (I don't want to create any 
account in RT unless I do it myself)

Are there any other RT specific set up variables that I should be considering? 
Anything else that I need to look at before trying this update?

I appreciate the input on this topic, and am thankful that Best Practical is 
hosting a service such as this.

Regards,
Scott MacKillip
Configuration Manager
ID Analytics, Inc.
Office:  858.312.6393
Fax:  858.451.9051
www.idanalytics.comhttp://www.idanalytics.com/



-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

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 from REMOTE_USER entirely
b) autoconvert the @xyz to @real.domain

c) (least preferable) have the autocreate routines, atomatically fill in 
@real.domain as the email address

You can accomplish (b) with these options:
http://bestpractical.com/rt/docs/latest/RT_Config.html#CanonicalizeEmailAddressMatch-CanonicalizeEmailAddressReplace

You can also do more sophisticated munging by writing your own
RT::User::CanonicalizeUserInfo:
http://bestpractical.com/rt/docs/latest/RT/User.html#CanonicalizeUserInfo-HASH-of-ARGS

Or you can take the easy way of (a) by setting the mod_auth_kerb config
option that Jok pointed out earlier.




Well, I'm back, now that I've had more time to follow up :)

I have tried out using the KrbLocalUser tweak, and run into problems.
The email field does not get filled out on autocreate of an account.

I then attempted to do the fallback suggested via

CanonicalizeEmailAddressMatch

after removing the KrbLocalUser from my apache configs.
however, the replace did not seem to have any effect. I'm still getting 
logged in as

u...@kerb.my.com
rather than u...@my.com

for the record, I'm using a match string of
'\@.*\.my.com$'

and replace of
'\@my.com'

it's kinda odd that I cant seem to google any sample RT_Config.pm files 
for this'






--
RT Training in Seattle, June 19-20: http://bestpractical.com/training


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 t...@bestpractical.comwrote:

 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/training

[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( CleanEnv GetCurrentUser );

CleanEnv();
RT::LoadConfig();
RT::Init();

my $user = RT::User-new( $RT::SystemUser );
my $group = RT::Group-new( $RT::SystemUser );
my $inputgroup = $ARGV[0];

$group-LoadUserDefinedGroup( $inputgroup );

open FILE, user_list.txt or die $!;

while (FILE)
{
  $user-Load( $_ );
  $group-AddMember( $user-PrincipalObj-Id );
}

close FILE;


$ ./rtgroupmember.pl MYGROUP
[Tue May 14 20:34:50 2013] [error]: Couldn't get principal for not loaded
object (/opt/rt3/lib/RT/User_Overlay.pm:1154)
[Tue May 14 20:34:50 2013] [crit]: Can't call method Id on an undefined
value at ./rtgroupmember.pl line 28, FILE line 1. (/opt/rt3/lib/RT.pm:377)
Can't call method Id on an undefined value at ./rtgroupmember.pl line 28,
FILE line 1.

So I changed the RT::User-new with RT::User_Overlay-new and I got a
different error saying cannot use object method new.


Don't speak much OOO perl yet.


Any suggestion would be appreciated.


-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

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 equivalent)

Thanks,
Jok


-- 
| Joachim Thuau | IT Systems Engineer - Linux / SpaceX |





On 5/14/13 1:41 PM, Philip Brown p...@usc.edu wrote:

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 from REMOTE_USER entirely
 b) autoconvert the @xyz to @real.domain

 c) (least preferable) have the autocreate routines, atomatically fill
in @real.domain as the email address
 You can accomplish (b) with these options:
 
http://bestpractical.com/rt/docs/latest/RT_Config.html#CanonicalizeEmailA
ddressMatch-CanonicalizeEmailAddressReplace

 You can also do more sophisticated munging by writing your own
 RT::User::CanonicalizeUserInfo:
 
http://bestpractical.com/rt/docs/latest/RT/User.html#CanonicalizeUserInfo
-HASH-of-ARGS

 Or you can take the easy way of (a) by setting the mod_auth_kerb config
 option that Jok pointed out earlier.



Well, I'm back, now that I've had more time to follow up :)

I have tried out using the KrbLocalUser tweak, and run into problems.
The email field does not get filled out on autocreate of an account.

I then attempted to do the fallback suggested via

CanonicalizeEmailAddressMatch

after removing the KrbLocalUser from my apache configs.
however, the replace did not seem to have any effect. I'm still getting
logged in as
u...@kerb.my.com
rather than u...@my.com

for the record, I'm using a match string of
'\@.*\.my.com$'

and replace of
'\@my.com'

it's kinda odd that I cant seem to google any sample RT_Config.pm files
for this'





-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training



-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


[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 doit être correctement rempli

use strict;
use lib /opt/rt3/lib;

use RT;
use RT::User;
use RT::Interface::CLI;

RT::LoadConfig();
RT::Init();

my $user = new RT::User($RT::SystemUser);
my $group = new RT::Group($RT::SystemUser);
my $inputgroup = $ARGV[0];

$group-LoadUserDefinedGroup( $inputgroup );

open FILE, usernames.txt or die $!;

while (FILE)
{
  $user-Load( $_ );
  $group-AddMember( $user-PrincipalObj-Id );
  #print $user-PrincipalObj-Id .\n;
}

close FILE;


$ ./rtgroupmember.pl MYGROUP

[Wed May 15 01:23:15 2013] [error]: Couldn't get principal for not loaded
object (/opt/rt3/lib/RT/User_Overlay.pm:1154)
[Wed May 15 01:23:15 2013] [crit]: Can't call method Id on an undefined
value at ./rtgroupmember.pl line 26, FILE line 1. (/opt/rt3/lib/RT.pm:377)
Can't call method Id on an undefined value at ./rtgroupmember.pl line 26,
FILE line 1

Any suggestion would be appreciated

Thanks

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

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 vad...@gmail.com 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 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 doit être correctement rempli

 use strict;
 use lib /opt/rt3/lib;

 use RT;
 use RT::User;
 use RT::Interface::CLI;

 RT::LoadConfig();
 RT::Init();

 my $user = new RT::User($RT::SystemUser);
 my $group = new RT::Group($RT::SystemUser);
 my $inputgroup = $ARGV[0];

 $group-LoadUserDefinedGroup( $inputgroup );

 open FILE, usernames.txt or die $!;

 while (FILE)
 {
   $user-Load( $_ );
   $group-AddMember( $user-PrincipalObj-Id );
   #print $user-PrincipalObj-Id .\n;
 }

 close FILE;


 $ ./rtgroupmember.pl MYGROUP

 [Wed May 15 01:23:15 2013] [error]: Couldn't get principal for not loaded
 object (/opt/rt3/lib/RT/User_Overlay.pm:1154)
 [Wed May 15 01:23:15 2013] [crit]: Can't call method Id on an undefined
 value at ./rtgroupmember.pl line 26, FILE line 1.
 (/opt/rt3/lib/RT.pm:377)
 Can't call method Id on an undefined value at ./rtgroupmember.pl line
 26, FILE line 1

 Any suggestion would be appreciated

 Thanks

 --
 Asif Iqbal
 PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
 A: Because it messes up the order in which people normally read text.
 Q: Why is top-posting such a bad thing?




-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

[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 in Seattle, June 19-20: http://bestpractical.com/training

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.



From: Jok Thuau [jth...@spacex.com]
Sent: Tuesday, May 14, 2013 05:36 PM
To: Philip Brown; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] REMOTE_USER, external auth, and email mismatching

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 equivalent)

Thanks,
Jok


--
| Joachim Thuau | IT Systems Engineer - Linux / SpaceX |





On 5/14/13 1:41 PM, Philip Brown p...@usc.edu wrote:

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 from REMOTE_USER entirely
 b) autoconvert the @xyz to @real.domain

 c) (least preferable) have the autocreate routines, atomatically fill
in @real.domain as the email address
 You can accomplish (b) with these options:

http://bestpractical.com/rt/docs/latest/RT_Config.html#CanonicalizeEmailA
ddressMatch-CanonicalizeEmailAddressReplace

 You can also do more sophisticated munging by writing your own
 RT::User::CanonicalizeUserInfo:

http://bestpractical.com/rt/docs/latest/RT/User.html#CanonicalizeUserInfo
-HASH-of-ARGS

 Or you can take the easy way of (a) by setting the mod_auth_kerb config
 option that Jok pointed out earlier.



Well, I'm back, now that I've had more time to follow up :)

I have tried out using the KrbLocalUser tweak, and run into problems.
The email field does not get filled out on autocreate of an account.

I then attempted to do the fallback suggested via

CanonicalizeEmailAddressMatch

after removing the KrbLocalUser from my apache configs.
however, the replace did not seem to have any effect. I'm still getting
logged in as
u...@kerb.my.com
rather than u...@my.com

for the record, I'm using a match string of
'\@.*\.my.com$'

and replace of
'\@my.com'

it's kinda odd that I cant seem to google any sample RT_Config.pm files
for this'





--
RT Training in Seattle, June 19-20: http://bestpractical.com/training





-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training


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 vad...@gmail.com wrote:

 while (FILE)
 {
   $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 removed the PrincipalObj and it is working now. So from the script this
is part that I needed to fix.

while (FILE)
{
  chop($_);
  $user-Load( $_ );
  $group-AddMember( $user-id );
}

I also had to add more use lib for the extensions to be loaded or failing
to run

use lib '/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib';
use lib '/opt/rt3/local/plugins/RT-Extension-CommandByMail/lib';




-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training