Re: [rt-users] insert blank columns in query builder

[Benjamin Weser]

The problem's solved. For the sake of the mailing list, here's the solution.

Just copy $RT_HOME/share/html/Search/Elements/BuildFormatString to local 
and add a  to the array starting at line 68. Then the blank can 
be used everywhere for the search.

# All the things we can display in the format string by default
my @fields = qw(
  id
  Status
  ExtendedStatus

 [snip]

  Children
  NEWLINE
  
);

Best,
Ben


Benjamin Weser schrieb:
> Hi list,
>
> is there a way to add a blank column to the shown column at "Display 
> Columns" in the Query Builder? There is one as default at ShowColumns 
> but there is no chance to add another one from Add Columns. Did I miss 
> anything or is this not possible yet? I have not found anything at the 
> list or the wiki about this issue...
>
> Cheers,
> Ben
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>   

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Self Service

[andrew fay]

Hello,

I am using RT 3.6.4 at the moment on ubuntu 7.10, I have users logging in using 
Mike Peachey's RT::Authen::ExternalAuth extension.

My problem is that on the self service page users have the option to change 
their password which I don't want to be there and in the top right there is a 
goto ticket box that I don't want there as users can enter any ticket number in 
there and jump to other people's tickets which obviously isn't great,

Anyone know how I can get rid of these 2 ?

Thanks in advance,

Andy

_
Amazing prizes every hour with Live Search Big Snap
http://www.bigsnapsearch.com___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Self Service

[Mike Peachey]

andrew fay wrote:
> Hello,
> 
> I am using RT 3.6.4 at the moment on ubuntu 7.10, I have users logging 
> in using Mike Peachey's RT::Authen::ExternalAuth extension.
> 
> My problem is that on the self service page users have the option to 
> change their password which I don't want to be there and in the top 
> right there is a goto ticket box that I don't want there as users can 
> enter any ticket number in there and jump to other people's tickets 
> which obviously isn't great,
> 
> Anyone know how I can get rid of these 2 ?

You don't need to get rid of the Goto Ticket box, simply ensure that 
users don't have permission to view tickets other than their own. This 
is accomplished with giving ShowTicket (you also want ReplyToTicket) to 
the Requestor role for any given queue.

So long only Requestors and Privileged (non-self-service) users can 
ShowTicket.. there's no problem.

As for the password change.. my self-service doesn't show that ability.. 
you probably want to remove the ModifySelf right for "Everyone" or 
something like that.

-- 
Kind Regards,

__

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com
__
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Self Service

[andrew fay]

morning mike!,

thanks for that - sorted,

One more thing, on the self service.. if I change someone's ticket's queue it 
gives them the message :


  afay -  Queue changed from  to

and thats it.. no mention of what queue it has been moved from to,

is there a quick fix for that? as this is our last issue before we can bring RT 
live,

Cheers,

Andy

> Date: Fri, 4 Apr 2008 09:30:08 +0100
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]; rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] Self Service
> 
> andrew fay wrote:
> > Hello,
> > 
> > I am using RT 3.6.4 at the moment on ubuntu 7.10, I have users logging 
> > in using Mike Peachey's RT::Authen::ExternalAuth extension.
> > 
> > My problem is that on the self service page users have the option to 
> > change their password which I don't want to be there and in the top 
> > right there is a goto ticket box that I don't want there as users can 
> > enter any ticket number in there and jump to other people's tickets 
> > which obviously isn't great,
> > 
> > Anyone know how I can get rid of these 2 ?
> 
> You don't need to get rid of the Goto Ticket box, simply ensure that 
> users don't have permission to view tickets other than their own. This 
> is accomplished with giving ShowTicket (you also want ReplyToTicket) to 
> the Requestor role for any given queue.
> 
> So long only Requestors and Privileged (non-self-service) users can 
> ShowTicket.. there's no problem.
> 
> As for the password change.. my self-service doesn't show that ability.. 
> you probably want to remove the ModifySelf right for "Everyone" or 
> something like that.
> 
> -- 
> Kind Regards,
> 
> __
> 
> Mike Peachey, IT
> Tel: +44 114 281 2655
> Fax: +44 114 281 2951
> Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
> Comp Reg No: 3191371 - Registered In England
> http://www.jennic.com
> __

_
The next generation of Windows Live is here
http://www.windowslive.co.uk/get-live___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Self Service

[Mike Peachey]

andrew fay wrote:
> morning mike!,
> 
> thanks for that - sorted,
> 
> One more thing, on the self service.. if I change someone's ticket's 
> queue it gives them the message :
> 
> afay - Queue changed from to
> 
> and thats it.. no mention of what queue it has been moved from to,
> 
> is there a quick fix for that? as this is our last issue before we can 
> bring RT live,

I'm not sure about that one to be honest - I've hardly ever moved a 
Ticket between Queues.

-- 
Kind Regards,

__

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com
__
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Weird error on Owner Change: "Could not change owner. Group already has member"

[Lars Braeuer]

Hi,

I'm using RT 3.6.6, having three Groups defined.

The group I'm in, has all rights granted on the global level.

But still I'm not able to take some of the tickets currently owned by "Nobody".

Whenever I try to change the owner of some tickets (using the "Basics" section 
in the ticket view), I'm getting the error message: "Could not change owner. 
Group already has member"

I tried to debug this issue. So I found out that the first part of the error 
message is originated from lib/RT/Ticket_Overlay.pm line 3079:


 my ( $add_id, $add_msg ) = $self->OwnerGroup->_AddMember(
PrincipalId => 
$NewOwnerObj->PrincipalId,
InsideTransaction => 1 );
 unless ($add_id) {
 $RT::Handle->Rollback();
 return ( 0, $self->loc("Could not change owner. ") . $add_msg );
 }


Digging further down, I was wondering why the AddMember function is used at all?

The second part of the error "Group already has member" is originated from 
lib/RT/Group_Overlay.pm line 985:


 if ( $self->HasMember( $new_member_obj ) ) {

 #User is already a member of this group. no need to add it
 return ( 0, $self->loc("Group already has member") );
 }


Why would it be required, to add the user to a group, when I'm just trying to 
change the owner of the ticket?

Commenting out the block in Ticket_Overlay.pm starting with "unless ($add_id) 
{" 
fixes the issue, but I'm not sure if this is breaking anything.

Thanks in advance for any advice.

Best,

Lars Bräuer
-- 
MPeX.net GmbH   MPeXnetworks
Werner-Voß-Damm 62http://mpexnetworks.de
D-12101 Berlin   Tel: ++49 - 30 - 780 97 180
Germany  Fax: ++49 - 30 - 780 97 181

HRB 76688, Berlin Amtsgericht Charlottenburg
Geschäftsführer:  Gregor Lawatscheck
   Robert Lawatscheck
  Lars Bräuer
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Self Service

[Benjamin Weser]

I think you'll need the right SeeQueue for that. Otherwise the queue is 
invisible and can't be resolved by the template. But I'm not so sure 
about that either.

Mike Peachey schrieb:
> andrew fay wrote:
>   
>> morning mike!,
>>
>> thanks for that - sorted,
>>
>> One more thing, on the self service.. if I change someone's ticket's 
>> queue it gives them the message :
>>
>> afay - Queue changed from to
>>
>> and thats it.. no mention of what queue it has been moved from to,
>>
>> is there a quick fix for that? as this is our last issue before we can 
>> bring RT live,
>> 
>
> I'm not sure about that one to be honest - I've hardly ever moved a 
> Ticket between Queues.
>
>   

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] A hoary goat.

[Robert Logan]

Long time listener 1st time caller 

A few snippets of advice required please.

Ive just started at a new post and have been tasked to look after the RT 
system here. Its version 3.1.4 and fairly vanilla in setup.

I intend to take this (2005) system and move it to the latest, with a 
hardware and OS/Db update as well. Im assuming that the upgrade to 3.6.6 
(current) will be more or less painless (follow the guide), but I'd like 
some pointers to making changes thereafter in terms of custom forms for 
ticket submission (various custom fields) and any caveats anyone has ..

MY RT history is one of installs and very simple setups of v3 RTs (on 
slackware - so I know how to mess with stuff) and a lot of time with RT2 
back in the day.

Any pointers will be much appreciated

bert
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Editing Custom Fields using CLI

[Jesse Vincent]

On Apr 2, 2008, at 10:40 PM, Terence Monteiro wrote:

Hi,

I'm using RT 3.6.4, which I had installed using the ubuntu  
repositiries. I'm
using mysql as the backend DBMS. I have a custom field "Month of  
application",

which I want to set while creating tickets. The queue I want to create
tickets in has this custom field as one of its fields.



We've fixed a bunch of bugs related to CFs and the commandline in  
3.6.5 and 3.6.6It's worth giving RT 3.6.6 a shot.


-jesse


PGP.sig
Description: This is a digitally signed message part
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] RT improving security/privacy

[holland holland]

Dear all,

My problem started with people putting by mistake users on admincc,
with the terrible effect of having those people viewing comments.

Basically I'm trying to detect AdminCc (watchers) set on ticket and Queues.

I think of 3 possible solutions:

1/
A scrip that prevent certain users of being put as AdminCc (For Ticket
and Queue):

Custom action preparation code:
---

Track when Admincc added at ticket or Queue level.
Check against list of authorized users (authorized to be on admincc)

Custom action cleanup code:
-

send alert or others.


I started with this piece, but it only check at ticket level:

my $transactionType = $self->TransactionObj->Type;
my $watcherType = $self->TransactionObj->Field;
if (($transactionType eq 'AddWatcher') and ($watcherType eq 'AdminCc')) {
 return 1;
}
 return undef;



2/

When pressing "Save Changes" button,  end user will be warned that
this user cannot be set as admincc (not found against list of
authorized users).

By far the best solution to me.



3/
SQL in a cronjob, but not pro-active enough.


I found this SQL statement (at the ticket level) so far:
---


SELECT DISTINCT
   t1.id Ticket_id,
   g2.id RoleGroup_id,
   g2.Type Role_Type,
   cgm3.MemberId RoleMember_id,
   p4.PrincipalType,
   u5.Name
FROM
   Tickets t1,
   Groups g2,
   CachedGroupMembers cgm3,
   Principals p4,
   Users u5
WHERE
   t1.id > 1 AND
   g2.Domain = 'RT::Ticket-Role' AND g2.Instance = t1.id AND
   cgm3.GroupId = g2.id AND
   p4.id = cgm3.MemberId AND
   p4.Disabled = 0 AND
   p4.PrincipalType = 'User'
   AND g2.Type = 'AdminCc'
   AND u5.id = p4.id;



---
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] A hoary goat.

[Rainer Duffner]

Robert Logan schrieb:
> Long time listener 1st time caller 
>
> A few snippets of advice required please.
>
> Ive just started at a new post and have been tasked to look after the RT 
> system here. Its version 3.1.4 and fairly vanilla in setup.
>
> I intend to take this (2005) system and move it to the latest, with a 
> hardware and OS/Db update as well. Im assuming that the upgrade to 3.6.6 
> (current) will be more or less painless (follow the guide), but I'd like 
> some pointers to making changes thereafter in terms of custom forms for 
> ticket submission (various custom fields) and any caveats anyone has ..
>
> MY RT history is one of installs and very simple setups of v3 RTs (on 
> slackware - so I know how to mess with stuff) and a lot of time with RT2 
> back in the day.
>
> Any pointers will be much appreciated
>   


OS?
DB?
Webserver?
mod_perl?

Clairvoyants not included


cheers,
Rainer
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Log file dates are off.

[Mark Fraser]

I just recently installed RT 3.6.6 on a fresh/clean load Linux system. I
have noticed that the logs going into the /var/log/rt3/rt.log file have
times that are 6 hours later than the RT logs going into my
/var/log.messages log file. Here is a cut from my RT_Config.pm file:

# $Timezone is used to convert times entered by users into GMT and back
again
# It should be set to a timezone recognized by your local unix box.
Set($Timezone , 'US/Eastern');

I have not changed this ever, so it appears that RT is treating the time as
being GMT.

Mark P. Fraser
Netstream
Visit us at http://www.mynetstream.com/

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Install RT on RHEL5

[Nelson Pereira]

Is there a special instructions to install RT3 on RHEL5?

Or simply follow RHEL4 manual install?

 

 

Nelson Pereira 
Senior Network Administrator 

Protus IP Solutions Inc. 
[EMAIL PROTECTED] 
phone: 613.733. ext.528 
MyFax: 613.822.5083 
www.myfax.com 

Refer your friends and colleagues to MyFax! 
Click here for more information.
  

   

 

<>___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Log file dates are off.

[Kenneth Marshall]

RT logs in UTC. The user interface displays in localtime.

Ken

On Fri, Apr 04, 2008 at 10:37:22AM -0400, Mark Fraser wrote:
> I just recently installed RT 3.6.6 on a fresh/clean load Linux system. I
> have noticed that the logs going into the /var/log/rt3/rt.log file have
> times that are 6 hours later than the RT logs going into my
> /var/log.messages log file. Here is a cut from my RT_Config.pm file:
> 
> # $Timezone is used to convert times entered by users into GMT and back
> again
> # It should be set to a timezone recognized by your local unix box.
> Set($Timezone , 'US/Eastern');
> 
> I have not changed this ever, so it appears that RT is treating the time as
> being GMT.
> 
> Mark P. Fraser
> Netstream
> Visit us at http://www.mynetstream.com/
> 

> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Install RT on RHEL5

[Mike Peachey]

Nelson Pereira wrote:
> Is there a special instructions to install RT3 on RHEL5?
> 
> Or simply follow RHEL4 manual install?

As I've said before, I heavily recommend following the Manual Install 
instructions instead.

-- 
Kind Regards,

__

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com
__
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] User based timestamps

[Martin Lee]

Dear all,

Is there any way to have time stamps based on the individual user,
rather than on the localtime that the server is using?  It does get more
than a little tiring brain-juggling timezones, especially for those as
dim-witted as I.  If not, is there a feature request address?

 

Thank you

 

Martin Lee

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] User based timestamps

[Jeff Voskamp]

Martin Lee wrote:
>
> Dear all,
>
> Is there any way to have time stamps based on the individual user, 
> rather than on the localtime that the server is using?  It does get 
> more than a little tiring brain-juggling timezones, especially for 
> those as dim-witted as I.  If not, is there a feature request address?
>
>  
>
> Thank you
>
>  
>
> Martin Lee
>
There's a Timezone entry in User Preferences in the 3.8 beta (alpha?), 
so one is coming.

Jeff Voskamp
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] A hoary goat.

[Robert Logan]

Rainer Duffner wrote:
> Robert Logan schrieb:
>> Long time listener 1st time caller 
>>
>> A few snippets of advice required please.
>>
>> Ive just started at a new post and have been tasked to look after the 
>> RT system here. Its version 3.1.4 and fairly vanilla in setup.
>>
>> I intend to take this (2005) system and move it to the latest, with a 
>> hardware and OS/Db update as well. Im assuming that the upgrade to 
>> 3.6.6 (current) will be more or less painless (follow the guide), but 
>> I'd like some pointers to making changes thereafter in terms of custom 
>> forms for ticket submission (various custom fields) and any caveats 
>> anyone has ..
>>
>> MY RT history is one of installs and very simple setups of v3 RTs (on 
>> slackware - so I know how to mess with stuff) and a lot of time with 
>> RT2 back in the day.
>>
>> Any pointers will be much appreciated
>>   
> 
> 
> OS?
> DB?
> Webserver?
> mod_perl?
> 
> Clairvoyants not included
> 
> 
> cheers,
> Rainer


Ahh - apologies - currently the usual RHEL 4, FastCGI, Apache/2.0.52
and mysql 4, but am as stated amenable to change for changes sake. Im a 
moderately competent sql/perl developer (mod_perl) - Mason doesnt 
frighten me as such.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] A hoary goat.

[Rainer Duffner]

Robert Logan schrieb:
> Rainer Duffner wrote:
>   
>> Robert Logan schrieb:
>> 
>>> Long time listener 1st time caller 
>>>
>>> A few snippets of advice required please.
>>>
>>> Ive just started at a new post and have been tasked to look after the 
>>> RT system here. Its version 3.1.4 and fairly vanilla in setup.
>>>
>>> I intend to take this (2005) system and move it to the latest, with a 
>>> hardware and OS/Db update as well. Im assuming that the upgrade to 
>>> 3.6.6 (current) will be more or less painless (follow the guide), but 
>>> I'd like some pointers to making changes thereafter in terms of custom 
>>> forms for ticket submission (various custom fields) and any caveats 
>>> anyone has ..
>>>
>>> MY RT history is one of installs and very simple setups of v3 RTs (on 
>>> slackware - so I know how to mess with stuff) and a lot of time with 
>>> RT2 back in the day.
>>>
>>> Any pointers will be much appreciated
>>>   
>>>   
>> OS?
>> DB?
>> Webserver?
>> mod_perl?
>>
>> Clairvoyants not included
>>
>>
>> cheers,
>> Rainer
>> 
>
>
> Ahh - apologies - currently the usual RHEL 4, FastCGI, Apache/2.0.52
> and mysql 4, but am as stated amenable to change for changes sake. Im a 
> moderately competent sql/perl developer (mod_perl) - Mason doesnt 
> frighten me as such.
> ___
>   


Well, I only migrated my RT from FreeBSD5 to FreeBSD6 and PostgreSQL8.0 
to 8.2 (and from RT3.4 to RT3.6).
Inbetween these PostgreSQL-releases, the PostgreSQL-team put in a lot of 
unicode checks, so that the import of the binary-dump didn't work.

When that was solved, everything worked again.
It seems, BestPractical has put *a lot* of effort into the upgrade process.
I wish, I could say this for all vendors whose software we use...



cheers,
Rainer



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] RT improving security/privacy

[Kenneth Crocker]

Holland,


That seems like a lot of work to me when all you really need to do is 
use the privileges to not allow these people the ability to do all that. 
Sounds like you have allowed too much at the global level. If you'd 
answer the following questions for me, I think we can come up with a 
prudent scheme that will give your users robust abilities and still 
preserve the security you're after: What rights have you set up for 
Global access for what groups/users? What kind of function are your 
queues used for? How many? What kind of groups have you set up and what 
are their responsibilities per queue? Who works on tickets and what kind 
of rights do you want them to have as opposed to the users sending in 
requests? Who administrates your RT? Thanks.

Kenn
LBNL

On 4/4/2008 6:10 AM, holland holland wrote:
> Dear all,
> 
> My problem started with people putting by mistake users on admincc,
> with the terrible effect of having those people viewing comments.
> 
> Basically I'm trying to detect AdminCc (watchers) set on ticket and Queues.
> 
> I think of 3 possible solutions:
> 
> 1/
> A scrip that prevent certain users of being put as AdminCc (For Ticket
> and Queue):
> 
> Custom action preparation code:
> ---
> 
> Track when Admincc added at ticket or Queue level.
> Check against list of authorized users (authorized to be on admincc)
> 
> Custom action cleanup code:
> -
> 
> send alert or others.
> 
> 
> I started with this piece, but it only check at ticket level:
> 
> my $transactionType = $self->TransactionObj->Type;
> my $watcherType = $self->TransactionObj->Field;
> if (($transactionType eq 'AddWatcher') and ($watcherType eq 'AdminCc')) {
>  return 1;
> }
>  return undef;
> 
> 
> 
> 2/
> 
> When pressing "Save Changes" button,  end user will be warned that
> this user cannot be set as admincc (not found against list of
> authorized users).
> 
> By far the best solution to me.
> 
> 
> 
> 3/
> SQL in a cronjob, but not pro-active enough.
> 
> 
> I found this SQL statement (at the ticket level) so far:
> ---
> 
> 
> SELECT DISTINCT
>t1.id Ticket_id,
>g2.id RoleGroup_id,
>g2.Type Role_Type,
>cgm3.MemberId RoleMember_id,
>p4.PrincipalType,
>u5.Name
> FROM
>Tickets t1,
>Groups g2,
>CachedGroupMembers cgm3,
>Principals p4,
>Users u5
> WHERE
>t1.id > 1 AND
>g2.Domain = 'RT::Ticket-Role' AND g2.Instance = t1.id AND
>cgm3.GroupId = g2.id AND
>p4.id = cgm3.MemberId AND
>p4.Disabled = 0 AND
>p4.PrincipalType = 'User'
>AND g2.Type = 'AdminCc'
>AND u5.id = p4.id;
> 
> 
> 
> ---
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Apply a custom field to a queue

[Firas Batal]

Hi everyone,

I am using RT 3.6.3 on a Fedora core 8 Box.  

This is my dilemma: I am writing a Perl script that enables me to create
custom fields from an external Excel spreadsheet.   I would like to
create one custom field and apply it to a number of queues, just as we
can do that manually using the web interface.  

In the beginning, I have used the following API:

my $system_user = initialise_rt();
my $rtObj_cf = RT::CustomField->new($system_user);
my $rt_queue = RT::Queue->new($system_user);

foreach my $queue ( keys %{ $rec->{queue_record} } ) {
print "queue: $queue \n";
my $queue_id = $rt_queue->Load($queue);
print qq~queue id: $queue_id\n~;
next if ( !defined $queue_id || !$queue_id || $queue eq '' );
foreach my $cf ( keys %{ $rec->{lcf_record} } ) {
if ( defined $rec->{lcf_record}{$cf}{Pattern} &&
$rec->{lcf_record}{$cf}{Pattern} ne '' &&
$rec->{lcf_record}{$cf}{Pattern} =~ /Yes|Mandatory/i ) {
foreach my $site ( keys %{ $rec->{site_record} } ) {
my ( $id, $msg ) = $rtObj_cf->Create(
Name=> $site. '_' . $queue . '_' . $cf,
Queue   => $queue_id,
Description => 'Custom Field ' . $site. '_' .
$queue . '_' .  $cf,
Pattern => '(?#Mandatory).',
SortOrder   => '1',
Type=> $rec->{lcf_record}{$cf}{Type}
);
if ( !$id ) {
print qq~Problem to create the costum field:
$cf, message: $msg \n~;
next;
}
$rtObj_cf->Load($id);


The following segment of code loops through all queues defined in the
excel spread-sheet and create custom fields for each queue according to
the number of custom fields I have.  So, if I have 3 custom fields in
the excel sheet and 4 queues, then the total number of custom fields is
12.   

The problem with this approach is that you create redundant custom
fields (or access custom fields).  What I would like to do is to take
advantage, using a script; of the facility of which RT 3.6.0+ can create
custom fields and apply them to each queue.  So, instead of creating 12
custom fields, I need to create 3 custom fields and apply to all queues.

Is there an API that one could use, after creating the custom field, to
apply the custom field to the queue under question?

Thanks and I apologize for the innconvenience
Firas

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Changing the server URL to RT in httpd.conf

[Nelson Pereira]

Guys...

 

With the modification for virtual host to put in the httpd.conf:

 



ServerName your.rt.server.hostname

DocumentRoot /opt/rt3/share/html

AddDefaultCharset UTF-8

 

PerlModule Apache::DBI

PerlRequire /opt/rt3/bin/webmux.pl

 



 SetHandler perl-script

 PerlHandler RT::Mason





 

What do I change to have a login page URL of http://localhost/rt3 ?

The reason is I have an index page on / that has multiple link, and when
I put this in httpd.conf, the url http://localhost 
goes directly to RT and I don't see my default index.html file

 

Thanks

 

 

 

Nelson Pereira 
Senior Network Administrator 

Protus IP Solutions Inc. 
[EMAIL PROTECTED] 
phone: 613.733. ext.528 
MyFax: 613.822.5083 
www.myfax.com 

Refer your friends and colleagues to MyFax! 
Click here for more information.
  

   

 

<>___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Data Migration from Track-It to RT?

[Aaron Sallade]

We are getting ready to attempt a migration of  20,000 tickets from
Track-it! (version 7) to RT 3.6.6 .

 

RT is running on Ubuntu Fiesty, mySQL, Apache2.

 

Any advice or caveats to share?

 

Should we plan on using the CLI interface for ticket import?

 

Aaron Sallade'
Application Manager
PTSO of Washington
"Shared Technology for Community Health"
(206) 613-8938 Desk
(206) 521-8833 Main
(206) 613-5078 Fax
[EMAIL PROTECTED]

 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Changing the server URL to RT in httpd.conf

[Nelson Pereira]

Found my answer...

 

RTFM !  LOL

 

 

Nelson Pereira 
Senior Network Administrator 

Protus IP Solutions Inc. 
[EMAIL PROTECTED] 
phone: 613.733. ext.528 
MyFax: 613.822.5083 
www.myfax.com 

Refer your friends and colleagues to MyFax! 
Click here for more information.
  

   

 



From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nelson
Pereira
Sent: Friday, April 04, 2008 2:45 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Changing the server URL to RT in httpd.conf

 

Guys...

 

With the modification for virtual host to put in the httpd.conf:

 



ServerName your.rt.server.hostname

DocumentRoot /opt/rt3/share/html

AddDefaultCharset UTF-8

 

PerlModule Apache::DBI

PerlRequire /opt/rt3/bin/webmux.pl

 



 SetHandler perl-script

 PerlHandler RT::Mason





 

What do I change to have a login page URL of http://localhost/rt3 ?

The reason is I have an index page on / that has multiple link, and when
I put this in httpd.conf, the url http://localhost 
goes directly to RT and I don't see my default index.html file

 

Thanks

 

 

 

Nelson Pereira 
Senior Network Administrator 

Protus IP Solutions Inc. 
[EMAIL PROTECTED] 
phone: 613.733. ext.528 
MyFax: 613.822.5083 
www.myfax.com 

Refer your friends and colleagues to MyFax! 
Click here for more information.
  

  

 

<>___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Data Migration from Track-It to RT?

[Kenneth Marshall]

I have used the Offline option under Tools for bulk ticket
creation. You can use perl or other scripting languages to
generate the template file and then it will create all of
the tickets for you. I would probably batch them in groups
of 1000 or less to keep it manageable, but the process is
very easy and works well.

Cheers,
Ken

On Fri, Apr 04, 2008 at 12:13:19PM -0700, Aaron Sallade wrote:
> We are getting ready to attempt a migration of  20,000 tickets from
> Track-it! (version 7) to RT 3.6.6 .
> 
>  
> 
> RT is running on Ubuntu Fiesty, mySQL, Apache2.
> 
>  
> 
> Any advice or caveats to share?
> 
>  
> 
> Should we plan on using the CLI interface for ticket import?
> 
>  
> 
> Aaron Sallade'
> Application Manager
> PTSO of Washington
> "Shared Technology for Community Health"
> (206) 613-8938 Desk
> (206) 521-8833 Main
> (206) 613-5078 Fax
> [EMAIL PROTECTED]
> 
>  
> 

> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] installing on RHEL4

[Les Mikesell]

Mike Peachey wrote:
>
>> How do I install this RPM and satisfy all dependencies?
> 
> Personally I would recommend ditching the RPM and the RHEL-specific 
> installation and doing a manual installation. There a number of reasons 
> why this would be preferable, least of all that your RT directory 
> structure will remain separate from the rest of your OS and make life 
> that much more simple for you.
> 
> Aside from that, Red Hat packaged software is asking for trouble as they 
> seem to like to change the defaults that developers have worked on 
> carefully to whatever they think they should be.
> 
> It is for this reason, for example, that you should be careful if you 
> upgrade your Perl installation via RPM because the Red Hat defaults 
> cause RT to break in attempting to use Scalar::Util.

Can someone elaborate on this issue?  Are there other problems to be 
expected from RPM-packaged perl modules or is this a case of mixing CPAN 
and rpm packages?

-- 
   Les Mikesell
[EMAIL PROTECTED]
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Need RT to fetchmail...

[Nelson Pereira]

Hi all,

 

Finaly got it all setup with the instructions on wiki on a RHEL5
fresh...

 

I have went through all the manual instructions and everything seems
well.

 

Now, I need RT to fetch the emails from a POP3 box and bring them into
RT.

 

How can I achieve this? Is there docs on this setup?

 

Thansk

 

 

 

Nelson Pereira 
Senior Network Administrator 

Protus IP Solutions Inc. 
[EMAIL PROTECTED] 
phone: 613.733. ext.528 
MyFax: 613.822.5083 
www.myfax.com 

Refer your friends and colleagues to MyFax! 
Click here for more information.
  

   

 

<>___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] installing on RHEL4

[Kanwar Ranbir Sandhu]

On Fri, 2008-04-04 at 14:17 -0500, Les Mikesell wrote:
> Can someone elaborate on this issue?  Are there other problems to be 
> expected from RPM-packaged perl modules or is this a case of mixing CPAN 
> and rpm packages?

Sounds like a case of mixing source installs on a RPM distro.  Usually,
if one has no choice, this works okay, but obviously sometimes there
will be issues.

I'd recommend using rpmforge to get all the dependencies for RT
resolved. I asked them to add some packages a while ago just for RT, and
now I can get everything in RPM form.  I only install RT itself from the
tar.gz now.

Regards,

Ranbir

-- 
Kanwar Ranbir Sandhu
Linux 2.6.22.14-72.fc6 i686 GNU/Linux 
16:18:22 up 5 days, 20:00, 2 users, load average: 0.82, 0.66, 0.80 


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Need RT to fetchmail...

[james machado]

Nelson,

If you must pull from a POP3 account I would look at
fetchmailto pull in the mail.  OTOH, not
knowing your specific reasons for using
POP3, I would look at ETRN or mail relaying from your host mail system to
use the standard setup with an SMTP mail server on your RT box.  However
fetchmail can be configured to pull from POP3 and submit via SMTP so that
may take care of it for you.

James Machado

On Fri, Apr 4, 2008 at 12:50 PM, Nelson Pereira <[EMAIL PROTECTED]> wrote:

>  Hi all,
>
>
>
> Finaly got it all setup with the instructions on wiki on a RHEL5 fresh…
>
>
>
> I have went through all the manual instructions and everything seems well.
>
>
>
> Now, I need RT to fetch the emails from a POP3 box and bring them into RT.
>
>
>
> How can I achieve this? Is there docs on this setup?
>
>
>
> Thansk
>
>
>
>
>
>
>
> *Nelson Pereira*
> Senior Network Administrator
>
> Protus IP Solutions Inc.
> [EMAIL PROTECTED]
> phone: 613.733. ext.528
> MyFax: 613.822.5083
> www.myfax.com
>
> Refer your friends and colleagues to MyFax!
> Click here for more information.
>
> [image: www.MyFax.com] 
>
>
>
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
<>___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Need RT to fetchmail...

[Vitaliy Okulov]

Sample config:

/usr/bin/fetchmail -f /opt/rt3/.fetchmailrc -a -m "/opt/rt3/bin/rt-mailgate
--queue General --action correspond --url http://localhost/"; >/dev/null

cat /opt/rt3/.fetchmailrc
set logfile=/opt/rt3/fetchmail
poll pop.mail.com proto pop3 user [EMAIL PROTECTED] with pass "blabla" to rt3
here

2008/4/4, Nelson Pereira <[EMAIL PROTECTED]>:
>
> Hi all,
>
>
>
> Finaly got it all setup with the instructions on wiki on a RHEL5 fresh…
>
>
>
> I have went through all the manual instructions and everything seems well.
>
>
>
> Now, I need RT to fetch the emails from a POP3 box and bring them into RT.
>
>
>
> How can I achieve this? Is there docs on this setup?
>
>
>
> Thansk
>
>
>
>
>
>
>
> *Nelson Pereira*
> Senior Network Administrator
>
> Protus IP Solutions Inc.
> [EMAIL PROTECTED]
> phone: 613.733. ext.528
> MyFax: 613.822.5083
> www.myfax.com
>
> Refer your friends and colleagues to MyFax!
> Click here for more information.
>
> [image: www.MyFax.com] 
>
>
>
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
<>___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com