Re: [rt-users] Ldap Authentication setup question

2008-10-29 Thread Sean McCreadie
Hello,

Ive been battling trying to get AD external Authentication going as
well.  Im pretty new at RT also, but I have read over all the docs and
these posts several times trying to get it working.  I am having the
exact same issue as Michael in this thread, and I haven't been able to
resolve.  Have either of you figured out a solution?  When I got to my
servers URL I am presented with the normal login screen, but if I try to
login as root, I get this error:

RT::User::UpdateFromExternal Unimplemented in HTML::Mason::Commands.
(/opt/rt3/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAu
th/autohandler/Auth line 82)

If I refresh in the browser it then takes me to roots home screen and
everything functions as normal.  I can logout and repeat, I have to
refresh once to get in.  If I try to login as an AD user, I get this
error:


Can't call method Disabled on an undefined value at
/opt/rt3/bin/../lib/RT/User_Overlay.pm line 971.


I have drilled over my RT_SiteConfig.pm and compared it to the ones
posted on the lists.  I turned on logging to file and it didn't generate
anything I could see that was related.  I checked file permissions on
the files listed below and they are OK.  

 Thanks in advance for all the great help.

Sean


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike
Peachey
Sent: Monday, October 27, 2008 2:55 AM
To: Michael Mollard; RT Users
Subject: Re: [rt-users] Ldap Authentication setup question

Michael Mollard wrote:
 Mike,
 Let me know when you're up and about again.  I've installed
RT::Authen::ExternalAuth v.06_2 and now just logging in as local root
generates this error.
 
 RT::User::UpdateFromExternal Unimplemented in HTML::Mason::Commands.
(/srv/www/vhosts/rt.mbc.qld.edu.au/local/plugins/RT-Authen-ExternalAuth/
html/Callbacks/ExternalAuth/autohandler/Auth line 73)

This generally means that the User_Vendor.pm has not been found in the
right place to make its methods available. UpdateFromExternal is an
RT::User method, RT looks in User.pm and doesn't find it, ande then
checks for its existence in User_Local.pm and User_Vendor.pm. Obviously
it's just not finding or is unable to read User_Vendor.pm.

File permissions perhaps?

-- 
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
___
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] Ticket Transction custom field scrip

2008-10-29 Thread Manjunath K.P
Hi All,

I am running RT 3.4.5 pgsql + Ubuntu as the backend.

I have created a custom field AssistedBy as a Custom Fields for Ticket 
Transactions and type Select one value and applies to ticket transactions.

I have created one more Custom field  Assistance (Applicable to Tickets ).

I would like to know how to write a scrip which will update Assisatnce( In 
tickets ) based on the value of AssistedBy ( Transactions ). 

For Eg:-

If AssistedBy(Transcation CF) = manju  on resolve it should update 
Assistance(Ticket CF) = manju

Hope I am clear on my question. I would greatly appreciate any input from you 
guys.

Thanks in advance

Regards,
Manjunath


  
___
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] Ldap Authentication setup question

2008-10-29 Thread Michael Mollard

Sean,
Identical to my error.  I did find a 'make fixperms' which I stumbled 
across, not documented anywhere I could find, alongside 'make testdeps', 
and 'make fixdeps'.  But it didn't change anything.  Same errors.


If I ever get this going, I may need to write a wiki article for the 
'rest of us' who are new at this.  If I ever get it working ;-)


Keep in touch Sean, if I find anything I'll let you know.

Michael Mollard
Network Administrator
Moreton Bay College
Email: [EMAIL PROTECTED]
Web: http://www.mbc.qld.edu.au
Phone: (Direct) 07 3907 5712 / (Mob) 0417 631 801 
Fax: 07 3390 8919




Sean McCreadie wrote:

Hello,

Ive been battling trying to get AD external Authentication going as
well.  Im pretty new at RT also, but I have read over all the docs and
these posts several times trying to get it working.  I am having the
exact same issue as Michael in this thread, and I haven't been able to
resolve.  Have either of you figured out a solution?  When I got to my
servers URL I am presented with the normal login screen, but if I try to
login as root, I get this error:

RT::User::UpdateFromExternal Unimplemented in HTML::Mason::Commands.
(/opt/rt3/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAu
th/autohandler/Auth line 82)

If I refresh in the browser it then takes me to roots home screen and
everything functions as normal.  I can logout and repeat, I have to
refresh once to get in.  If I try to login as an AD user, I get this
error:


Can't call method Disabled on an undefined value at
/opt/rt3/bin/../lib/RT/User_Overlay.pm line 971.


I have drilled over my RT_SiteConfig.pm and compared it to the ones
posted on the lists.  I turned on logging to file and it didn't generate
anything I could see that was related.  I checked file permissions on
the files listed below and they are OK.  


 Thanks in advance for all the great help.

Sean


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike
Peachey
Sent: Monday, October 27, 2008 2:55 AM
To: Michael Mollard; RT Users
Subject: Re: [rt-users] Ldap Authentication setup question

Michael Mollard wrote:
  

Mike,
Let me know when you're up and about again.  I've installed


RT::Authen::ExternalAuth v.06_2 and now just logging in as local root
generates this error.
  

RT::User::UpdateFromExternal Unimplemented in HTML::Mason::Commands.


(/srv/www/vhosts/rt.mbc.qld.edu.au/local/plugins/RT-Authen-ExternalAuth/
html/Callbacks/ExternalAuth/autohandler/Auth line 73)

This generally means that the User_Vendor.pm has not been found in the
right place to make its methods available. UpdateFromExternal is an
RT::User method, RT looks in User.pm and doesn't find it, ande then
checks for its existence in User_Local.pm and User_Vendor.pm. Obviously
it's just not finding or is unable to read User_Vendor.pm.

File permissions perhaps?

  
___
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] Stale data in CachedGroupMembers

2008-10-29 Thread Dave Holland
On Mon, Oct 27, 2008 at 08:39:59PM +0300, Ruslan Zakirov wrote:
 New reimplementation of rt-validator landed in the repository and will
 be shipped with RT 3.8.2. It can resurrect CachedGroupMembers table
 from information in other tables.

Is it safe to run this new rt-validator in resolve mode on an older RT
database? In particular we have a version 3.4.2 database that has many
inconsistencies according to rt-validator. Or would it be better to
upgrade RT first?

thanks,
Dave
-- 
** Dave Holland ** Systems Support -- Infrastructure Management **
** 01223 496923 ** The Sanger Institute, Hinxton, Cambridge, UK **
It is often easier to not do something dumb than it is to do
something smart.


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE. 
___
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] Can't revoke superuser right for everyone on RT 3.8.1

2008-10-29 Thread Drew Barnes
Are any users explicitly granted SuperUser rights?  If not, the system 
may reject the attempt to remove it from everyone as that would leave no 
SuperUsers.

Tim Thomas wrote:
 Hmm, I have tried this with 2 log-ins including root (see attached) 
 and no luck.  Any other suggestions, or thoughts on manually revoking 
 this in the DB?

 Thanks,
 Tim


 





 







 On Oct 28, 2008, at 12:43 PM, Ruslan Zakirov wrote:

 Just made a test: granted everyone with SuperUser, then revoked it and
 everything went fine. I do believe that RT can refuse such operation
 if user has no personal SuperUser right when you're revoking global.

 On Tue, Oct 28, 2008 at 5:11 PM, Tim Thomas 
 [EMAIL PROTECTED] wrote:
 We are refining our security needs now as we expand, and want to
 revoke the global superuser right for the group everyone, but RT
 refuses to revoke that right.  I am logged in as root, and are using
 RT 3.8.1.  Any suggestions short of going into the database to change
 this directly?

 Thanks,
 Tim

 

 ___
 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

-- 
Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

___
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] Stalled tickets on RT At A Glance

2008-10-29 Thread Reginaldo Russinholi




Hi all, 

Is it possible to put my stalled tickets on "RT At A Glance" view?


I mean, where is showed the "10
highest priority tickets I own" I want to show the stalled tickets that
I own. Is it possible?


Reginaldo L. Russinholi
Developer  Sys. Admin.
IRapida Telecom


___
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-crontool errors with rt3.8.1 using RT::Search::FromSQL

2008-10-29 Thread falz
Upgraded from RT 3.6.x to 3.8.1 the other day. The upgrade was
actually a clean install of RT, and the necessary db changes. I use
rt-crontool to do a few things like un-stall tickets using TicketSQL.
Here's an example:

/usr/local/bin/rt-crontool \
--search RT::Search::FromSQL \
--search-arg \
Status = 'resolved' \
AND Queue = 'Incoming' \
AND Owner != 'Nobody' \
--action RT::Action::AutoOpen \
--verbose


When either runs, they fail with:

Wed Oct 29 12:24:48 2008] [crit]: Can't call method Message on an
undefined value at /usr/local/lib/rt38/RT/Action/AutoOpen.pm line 77.
(/usr/local/lib/rt38/RT.pm:377)
Can't call method Message on an undefined value at
/usr/local/lib/rt38/RT/Action/AutoOpen.pm line 77.
28776: Processing without transaction, some conditions and actions may
fail. Consider using --transaction argumentCondition matches

This user appears to have the same issue:

http://lists.bestpractical.com/pipermail/rt-users/2008-July/052865.html

Doing what it suggestes, which is adding --transaction to my run seems
to work. However, I don't understand its description:

--transaction - Specify if you want to use either 'first', 'last' or
'all' transactions

If I chose 'last' would this mean that my TicketSQL statement would
only look at the last (meaning most recent?) transaction for a ticket
and act on it?

--falz
___
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] Stale data in CachedGroupMembers

2008-10-29 Thread Ruslan Zakirov
I made a few tests on 3.6 and think it's possible to use it with 3.6,
but I am not 100% sure it will work with 3.4.

On Wed, Oct 29, 2008 at 1:14 PM, Dave Holland [EMAIL PROTECTED] wrote:
 On Mon, Oct 27, 2008 at 08:39:59PM +0300, Ruslan Zakirov wrote:
 New reimplementation of rt-validator landed in the repository and will
 be shipped with RT 3.8.2. It can resurrect CachedGroupMembers table
 from information in other tables.

 Is it safe to run this new rt-validator in resolve mode on an older RT
 database? In particular we have a version 3.4.2 database that has many
 inconsistencies according to rt-validator. Or would it be better to
 upgrade RT first?

 thanks,
 Dave
 --
 ** Dave Holland ** Systems Support -- Infrastructure Management **
 ** 01223 496923 ** The Sanger Institute, Hinxton, Cambridge, UK **
 It is often easier to not do something dumb than it is to do
 something smart.


 --
  The Wellcome Trust Sanger Institute is operated by Genome Research
  Limited, a charity registered in England with number 1021457 and a
  company registered in England with number 2742969, whose registered
  office is 215 Euston Road, London, NW1 2BE.




-- 
Best regards, Ruslan.
___
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] Can't revoke superuser right for everyone on RT 3.8.1

2008-10-29 Thread Tim Thomas
Yes, my user and root both have global superuser rights granted.


On Oct 29, 2008, at 8:35 AM, Drew Barnes wrote:

 Are any users explicitly granted SuperUser rights?  If not, the  
 system may reject the attempt to remove it from everyone as that  
 would leave no SuperUsers.

 Tim Thomas wrote:
 Hmm, I have tried this with 2 log-ins including root (see attached)  
 and no luck.  Any other suggestions, or thoughts on manually  
 revoking this in the DB?

 Thanks,
 Tim

 On Oct 28, 2008, at 12:43 PM, Ruslan Zakirov wrote:

 Just made a test: granted everyone with SuperUser, then revoked it  
 and
 everything went fine. I do believe that RT can refuse such operation
 if user has no personal SuperUser right when you're revoking global.

 On Tue, Oct 28, 2008 at 5:11 PM, Tim Thomas [EMAIL PROTECTED] 
  wrote:
 We are refining our security needs now as we expand, and want to
 revoke the global superuser right for the group everyone, but  
 RT
 refuses to revoke that right.  I am logged in as root, and are  
 using
 RT 3.8.1.  Any suggestions short of going into the database to  
 change
 this directly?

 Thanks,
 Tim


___
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] Modify Rows per Box settings for all users

2008-10-29 Thread Dave Wells
Hi,
 
I have search through the archive and cannot seem to find an answer for
how to set a default rows per box setting to all users I want to set
it to 50 and not the default of 10.
 
I know you can do this individually for each user in the Customise RT
at a Glance section, however I have not given my users the ModifySelf
right and don't want to have to give them this right so they can do
this.
 
Is there anyway to set the rows per box setting globally?
 
Thanks
Dave
___
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] forcibly incrementing ticket numbers once to start out

2008-10-29 Thread Gabriel Cadieux
i know i've seen this, but i can't find it anywhere...

i just want to increment my ticket numbers up to #1000 or something
to start off at a higher number (just to look more normal/professional
than giving out your ticket is #3 or something)...

there must be an easy way to just up the number.. i haven't created ANY tickets
at all yet... so i guess i would want my first one to be #1000.

thanks all!

Gabriel Cadieux
Systems Engineer  IT Security Analyst
STI - Secure Technologies International, Inc.
Tel. (613) 830-3131 ext. 304
Cel. (613) 608-4635
Fax. (613) 830-5320
www.securetechnologies.ca
___
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 3.8.1 and iCal

2008-10-29 Thread Jesse Vincent



On Tue 28.Oct'08 at 14:30:46 -0700, Hossein Rafighi wrote:
 Hi all,
 
 I upgraded our RT from 3.6.4 to 3.81. Can anyone on the list point me to 
 a resource where I can read  and understand how the new iCal feature 
 works on 3.8.1?


There's a link on all ticket search results. You can subscribe to the
due dates of any tasklist as an ical feed by copy-pasting that link into
your calendar app.

For example, I have all our customer project due dates show up in my
google calendar ;)

Best,
Jesse

 
 Many thanks in advance,
 Hossein
 
 -- 
   _  _   _  _   _  _   _   Hossein Rafighi
  |_   _||  _  \ |_   _|| | | || \_/ ||  __|TRIUMF, 4004 Wesbrook Mall
| |  | |_|  )  | |  | | | || || |__ Vancouver BC, Canada, V6T 2A3
| |  |  _  /   | |  | \_/ || \_/ ||  __|Voice: (604) 222-1047
| |  | | \ \  _| |_ | || | | || |   Fax:   (604) 222-1074
|_|  |_|  \_\|_| \___/ |_| |_||_|   Website: http://www.triumf.ca
 
 ___
 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
 

-- 


pgp4B1DdIfi5H.pgp
Description: PGP signature
___
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] forcibly incrementing ticket numbers once to start out

2008-10-29 Thread Hans Dieter Pearcey
On Wed, Oct 29, 2008 at 11:25:39AM -0400, Gabriel Cadieux wrote:
 i just want to increment my ticket numbers up to #1000 or something
 to start off at a higher number (just to look more normal/professional
 than giving out your ticket is #3 or something)...

ALTER TABLE Tickets AUTO_INCREMENT = 1000

hdp.
___
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 3.8.1 and iCal

2008-10-29 Thread Jerrad Pierce
 On Tue 28.Oct'08 at 14:30:46 -0700, Hossein Rafighi wrote:
 Hi all,

 I upgraded our RT from 3.6.4 to 3.81. Can anyone on the list point me to
 a resource where I can read  and understand how the new iCal feature
 works on 3.8.1?
 There's a link on all ticket search results. You can subscribe to the
 due dates of any tasklist as an ical feed by copy-pasting that link into
 your calendar app.
See also the RTx::Calendar for more iCal * general calendaring) fun.

 For example, I have all our customer project due dates show up in my
 google calendar ;)
How do you do that? I assume you're not running under RT under SSL then?
Our RT is over SSL, and google calendar refuses to add an RT iCal feed...

-- 
Cambridge Energy Alliance: Save money  the planet
___
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] forcibly incrementing ticket numbers once tostart out

2008-10-29 Thread Gabriel Cadieux
many thanks :)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Hans
Dieter Pearcey
Sent: Wednesday, October 29, 2008 12:05 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] forcibly incrementing ticket numbers once
tostart out


On Wed, Oct 29, 2008 at 11:25:39AM -0400, Gabriel Cadieux wrote:
 i just want to increment my ticket numbers up to #1000 or something
 to start off at a higher number (just to look more normal/professional
 than giving out your ticket is #3 or something)...

ALTER TABLE Tickets AUTO_INCREMENT = 1000

hdp.
___
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] easy way to display complete ticket history via RT CLI shell

2008-10-29 Thread Gabriel Cadieux
hey all,

using RT 3.6.7..

i'm creating a shell script that will be called by an php page where an 
employee here can enter a service work order ticket number and then the script 
will use the RT shell to generate a nicer, customer-friendly version of the 
ticket, adding certain things (like a place for the custy to sign and date on 
reception), also ommiting certain unnecessary information, and formatting it to 
be printable, and more importantly, more presentable ro the customer than 
printing out an RT ticket straight from a browser.

now, i can manage to do a basic query on a ticket given the number...

'show ticket/number' let's say..

but that doesn't show me the ticket history.

'show ticket/number/history' is great, but the CONTENT (or so-called 
'attachments') isn't displayed, and it also doesn't TELL me if any of these 
items have attachments in them so that i can in turn query them using the 'show 
ticket/number/attachments/atch_number/content'...

i'm very confused as to how useful this can possibly be to me at this point.. 
i'm starting to wonder if it will even be possible to make what i'm trying to 
do..

now, my question is: is there an easy way to get the rt shell (or anything 
else) spit out a list of the entire ticket history, WITH attachment content 
(such as a 'global summary of events') for a specific ticket, so that i can 
just slap that info onto the footer of my page and not have to break my head 
open trying to parse and process all this stuff manually?

for example, i'd like to be able to issue a single command, and be given, just 
like in RT:


# Wed Oct 29 12:32:40 2008  gabe - Ticket created
  Customer wants an eval for a firewall.
# Wed Oct 29 12:32:57 2008  gabe - Status changed from 'new' to 'open'  
 
# Wed Oct 29 12:38:46 2008  gabe - Taken 


or whatever the ticket history is, in FULL..

the problem is, i could technically do all of this with a shitload of partsing 
via awk and whatnot or maybe in perl with some string stuff, but then i still 
couldn't associate ticket history entries with their appropriate 'attachments' 
(i.e. their content), which is what is most important when there are notes in 
the tickets...

please help, this is really important otherwise the whole point of using RT to 
create and manage our service work orders will go down the toilet... i need to 
be able to access the ticket info externally (preferably using the RT CLI shell 
since it already implements the ticketSQL stuff), and then make a nicey-looking 
printable HTML page out of it.. i will do the formatting and selection of what 
fields i want manually for the header of it (all the custy address info, status 
of work order, etc..), but i need the history in whole, so ppl can see what was 
done with the ticket.

btw, we don't use RT emailing at ALL. i have completely disabled emailing 
anything to anyone, we're using this as a simple in-house ticket tracking 
solution.

thanks so much in advance.

-gabe
___
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] assigning tickets

2008-10-29 Thread Gabriel Cadieux
hi list,

why is it that i can't seem to be able to assign tickets to other people,
even when i own them? when i see the main ticket display, it shows my user
as the owner, for example, after taking it... then in the People tab,
only Nobody appears in the list of people to set the owner to.. i don't
want to have to have the person i want the ticket assigned to to have to login
and steal the ticket in order to have it assigned to them, i want to be able
to force them to own it, like it should be...

i can't do this as anyone.. not even root, or a user that has superuser 
priviledges...

rt 3.6.7..

i don't get it :(

-gabe
___
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] easy way to display complete ticket history via RT CLIshell

2008-10-29 Thread Gabriel Cadieux
forgot to add, i also need the date and time associated with each history event 
and its subsequent attachments :(

i also can't find a way to correlate all this info into one big nice block of 
stuff i can include in my final output.

thx!

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Gabriel
Cadieux
Sent: Wednesday, October 29, 2008 12:58 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] easy way to display complete ticket history via RT
CLIshell


hey all,

using RT 3.6.7..

i'm creating a shell script that will be called by an php page where an 
employee here can enter a service work order ticket number and then the script 
will use the RT shell to generate a nicer, customer-friendly version of the 
ticket, adding certain things (like a place for the custy to sign and date on 
reception), also ommiting certain unnecessary information, and formatting it to 
be printable, and more importantly, more presentable ro the customer than 
printing out an RT ticket straight from a browser.

now, i can manage to do a basic query on a ticket given the number...

'show ticket/number' let's say..

but that doesn't show me the ticket history.

'show ticket/number/history' is great, but the CONTENT (or so-called 
'attachments') isn't displayed, and it also doesn't TELL me if any of these 
items have attachments in them so that i can in turn query them using the 'show 
ticket/number/attachments/atch_number/content'...

i'm very confused as to how useful this can possibly be to me at this point.. 
i'm starting to wonder if it will even be possible to make what i'm trying to 
do..

now, my question is: is there an easy way to get the rt shell (or anything 
else) spit out a list of the entire ticket history, WITH attachment content 
(such as a 'global summary of events') for a specific ticket, so that i can 
just slap that info onto the footer of my page and not have to break my head 
open trying to parse and process all this stuff manually?

for example, i'd like to be able to issue a single command, and be given, just 
like in RT:


# Wed Oct 29 12:32:40 2008  gabe - Ticket created
  Customer wants an eval for a firewall.
# Wed Oct 29 12:32:57 2008  gabe - Status changed from 'new' to 'open'  
 
# Wed Oct 29 12:38:46 2008  gabe - Taken 


or whatever the ticket history is, in FULL..

the problem is, i could technically do all of this with a shitload of partsing 
via awk and whatnot or maybe in perl with some string stuff, but then i still 
couldn't associate ticket history entries with their appropriate 'attachments' 
(i.e. their content), which is what is most important when there are notes in 
the tickets...

please help, this is really important otherwise the whole point of using RT to 
create and manage our service work orders will go down the toilet... i need to 
be able to access the ticket info externally (preferably using the RT CLI shell 
since it already implements the ticketSQL stuff), and then make a nicey-looking 
printable HTML page out of it.. i will do the formatting and selection of what 
fields i want manually for the header of it (all the custy address info, status 
of work order, etc..), but i need the history in whole, so ppl can see what was 
done with the ticket.

btw, we don't use RT emailing at ALL. i have completely disabled emailing 
anything to anyone, we're using this as a simple in-house ticket tracking 
solution.

thanks so much in advance.

-gabe
___
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] easy way to display complete ticket history via RT CLIshell

2008-10-29 Thread Jerrad Pierce
Have you tried reading the source?

  share/html/Ticket/Elements/ShowHistory

seems like a good place to start inspecting how the WebUI does it.

-- 
Cambridge Energy Alliance: Save money  the planet
___
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] No permission to create tickets in the queue

2008-10-29 Thread Alan Cheng
Dear all,

I understand that Ticket_Overlay.pm sets the error message when the
requester has no right to create tickets.  I was wondering if there is a
way to customize this message as our users find it grumpy...  We can
modify Ticket_Overlay.pm but I would like to know if we can put
something in a custom template or script to accomplish the same thing. 
Any comments or suggestions are greatly appreciated.

 #Now that we have a queue, Check the ACLS
 unless (
 $self-CurrentUser-HasRight(
 Right  = 'CreateTicket',
 Object = $QueueObj
 )
   )
 {
 return (
 0, 0,
 $self-loc( No permission to create tickets in the queue
 '[_1]', $QueueObj-Name));
 }


Thanks,

Alan
___
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] [Patch] Default to Reply when resolving tickets

2008-10-29 Thread Richard Hartmann
Hi all,

if you want your RT to default to Reply instead of Comment when
you Resolve a ticket, this patch is for you. Of course, using
the overlay directory is better than simply patching the sources.

If anyone tells me how to access RT_SiteConfig parameters
from within Tabs, I will make a proper patch which can then be
applied to RT trunk. :)


Richard
--- share/html/Ticket/Elements/Tabs 2008-09-01 18:56:02.0 +0200
+++ local/html/Ticket/Elements/Tabs 2008-10-29 15:18:11.0 +0100
@@ -177,7 +177,7 @@
 if ( $Ticket-Status ne 'resolved' ) {
 $actions-{'G'} = {
 path =
-Ticket/Update.html?Action=CommentDefaultStatus=resolvedid=
+Ticket/Update.html?Action=RespondDefaultStatus=resolvedid=
 . $id,
 title = loc('Resolve')
 };

___
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 3.8.1 and iCal

2008-10-29 Thread Kevin Falcone

On Oct 29, 2008, at 12:19 PM, Jerrad Pierce wrote:

 For example, I have all our customer project due dates show up in my
 google calendar ;)
 How do you do that? I assume you're not running under RT under SSL  
 then?
 Our RT is over SSL, and google calendar refuses to add an RT iCal  
 feed...

I have all my RT Due dates showing up from an https:// link without
problem.  I've had iCal refuse an ssl link but not google calendar.

-kevin
___
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] Merged Ticket Performance Degredation (still trying!)

2008-10-29 Thread Damon Miller
Hi all,

I posted about this problem a couple of weeks ago but unfortunately
we're still seeing regular hangs and frankly I'm out of ideas.  Here's
the quick summary:

We're using RT 3.6.1 and when loading merged tickets we see severe
performance degredation, e.g. 100 - 300 seconds per ticket.  After 30
seconds, Apache gives up on the FastCGI script and generates a 500.
This problem has been documented and referenced in several posts, but I
have been unable to find a resolution.  The following from Jesse seems
to be the most descriptive:

Yep. it's not recursion. It's RT::Transaction::TicketObj which should
be made smarter. Rather than loading a ticket by id, it should be
loading by id _and_ effective id. I'd love a patch.

Here's the full thread:
http://www.gossamer-threads.com/lists/rt/users/72384.

Mark Blackman suggested I update our Syslog configuration as follows (in
RT_SiteConfig.pm):

@LogToSyslogConf = ( socket = 'native' ) unless (@LogToSyslogConf);

I did this but unfortunately we're seeing the same hangs.  I also tried
reducing the loglevel so the merged ticket messages aren't being stored
at all but that didn't help either (though the log is growing much less
quickly now!). 

Any suggestions would be much-appreciated.

Thanks,

Damon

P.S.  I checked the code for RT 3.8.1 and the TODO regarding merged
ticket loads is still present so I'm assuming the performance issue is
also still present.


--

Damon T. Miller
Director of Application Services
Thinking Phone Networks
[EMAIL PROTECTED] 
617-649-1388 (Office)


___
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] assigning tickets

2008-10-29 Thread Kenneth Crocker
Gabriel,


This is accomplished using privileges and groups. You could also grant 
individual Users the right to own tickets in a queue, but that would be 
a maintenance nightmare. By default, RT will display on the Owner drop 
down any and all members of any group that has the OwnTicket right. If 
they have TakeTicket, along with SeeQueue, then they would be able to 
see tickets in a queue and TAKE any ticket that wasn't already owned. If 
they do NOT have OwnTicket for a queue, then granting the 
StealTicket would not work. They cannot steal something they are not 
allowed to own. So, to make this simple, find out what groups have 
rights to the queue in question, and make sure they have the appropriate 
rights AND make sure the user you want to own tickets is in one of those 
groups. Hope this helps.


Kenn
LBNL

On 10/29/2008 10:10 AM, Gabriel Cadieux wrote:
 hi list,
 
 why is it that i can't seem to be able to assign tickets to other people,
 even when i own them? when i see the main ticket display, it shows my user
 as the owner, for example, after taking it... then in the People tab,
 only Nobody appears in the list of people to set the owner to.. i don't
 want to have to have the person i want the ticket assigned to to have to login
 and steal the ticket in order to have it assigned to them, i want to be able
 to force them to own it, like it should be...
 
 i can't do this as anyone.. not even root, or a user that has superuser 
 priviledges...
 
 rt 3.6.7..
 
 i don't get it :(
 
 -gabe
 ___
 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] Add AdminCC on Owner Change

2008-10-29 Thread Kenneth Crocker
Andy,


I'm a little confused.DO you want to add an AdminCc as a recipient of 
the notification or do you actually want to add this user as an AdminCC 
Watcher of the queue or just add them as an AdminCc for the ticket? 
Oh, by the way, you used as an example of a ticket being owned by x,y,z, 
or q. You do realise that a ticket can be owned by ONLY 1 usedID, right?


Kenn
LBNL

On 10/29/2008 11:15 AM, Andy Jones wrote:
 Hi, gang.
 
 I've looked through the wiki and archives, but haven't seen this issue  
 addressed.
 
 I'd like to be able to add a specific user as AdminCC when the owner  
 of a ticket is changed to any of a range of users.  For instance, if a  
 ticket is owned by x, y, z, or q, add b as AdminCC.
 
 Does anyone else have that kind of setup?  Anyone willing to share a  
 little UserDefined code with me?  :o)
 
 Thanks in advance!
 
 Andy
 
 Andy Jones
 User Support Manager
 510.594.5016
 [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] RT 3.8.1 and iCal

2008-10-29 Thread Hossein Rafighi
Thanks for the info. I did install RTx::Calendar from cpan, but the 
installation procedure put everything in /usr/share/rt3!
Placing Set(@Plugins,(qw(RTx::Calendar))); in RT_SiteConfig is giving 
the following error:
Can't locate RTx/Calendar.pm in @INC (@INC contains: 
/opt/rt3/bin/../local/lib /opt/rt3...
Compilation failed in require at /opt/rt3/bin/mason_handler.fcgi line 
55, DATA line 273.

Any Ideas?
Hossein

Jerrad Pierce wrote:
 On Tue 28.Oct'08 at 14:30:46 -0700, Hossein Rafighi wrote:
 
 Hi all,

 I upgraded our RT from 3.6.4 to 3.81. Can anyone on the list point me to
 a resource where I can read  and understand how the new iCal feature
 works on 3.8.1?
   
 There's a link on all ticket search results. You can subscribe to the
 due dates of any tasklist as an ical feed by copy-pasting that link into
 your calendar app.
 
 See also the RTx::Calendar for more iCal * general calendaring) fun.

   
 For example, I have all our customer project due dates show up in my
 google calendar ;)
 
 How do you do that? I assume you're not running under RT under SSL then?
 Our RT is over SSL, and google calendar refuses to add an RT iCal feed...

   

-- 
  _  _   _  _   _  _   _   Hossein Rafighi
 |_   _||  _  \ |_   _|| | | || \_/ ||  __|TRIUMF, 4004 Wesbrook Mall
   | |  | |_|  )  | |  | | | || || |__ Vancouver BC, Canada, V6T 2A3
   | |  |  _  /   | |  | \_/ || \_/ ||  __|Voice: (604) 222-1047
   | |  | | \ \  _| |_ | || | | || |   Fax:   (604) 222-1074
   |_|  |_|  \_\|_| \___/ |_| |_||_|   Website: http://www.triumf.ca

___
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] Add AdminCC on Owner Change

2008-10-29 Thread Andy Jones
Heya, Kenn.

Sorry if I wasn't clear.  Logically, this is what I'd like:

IF a ticket is owned by user x, y, z, or q,
THEN user b is added as an AdminCC to the ticket.

I'm not terribly concerned that the AdminCC gets notified about which  
of x, y, z, or q actually owns the ticket; moreso, I want to be sure  
the AdminCC is copied on all messages relating to that ticket going  
forward.

Does that make sense?

Thanks,
Andy

On Oct 29, 2008, at 1:30 PM, Kenneth Crocker wrote:

 Andy,


   I'm a little confused.DO you want to add an AdminCc as a recipient  
 of the notification or do you actually want to add this user as an  
 AdminCC Watcher of the queue or just add them as an AdminCc for  
 the ticket? Oh, by the way, you used as an example of a ticket being  
 owned by x,y,z, or q. You do realise that a ticket can be owned by  
 ONLY 1 usedID, right?


 Kenn
 LBNL

 On 10/29/2008 11:15 AM, Andy Jones wrote:
 Hi, gang.
 I've looked through the wiki and archives, but haven't seen this  
 issue  addressed.
 I'd like to be able to add a specific user as AdminCC when the  
 owner  of a ticket is changed to any of a range of users.  For  
 instance, if a  ticket is owned by x, y, z, or q, add b as AdminCC.
 Does anyone else have that kind of setup?  Anyone willing to share  
 a  little UserDefined code with me?  :o)
 Thanks in advance!
 Andy
 Andy Jones
 User Support Manager
 510.594.5016
 [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


Andy Jones
User Support Manager
510.594.5016
[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] Add AdminCC on Owner Change

2008-10-29 Thread Jerrad Pierce
On Wed, Oct 29, 2008 at 16:30, Kenneth Crocker [EMAIL PROTECTED] wrote:
 Andy,


I'm a little confused.DO you want to add an AdminCc as a recipient of
 the notification or do you actually want to add this user as an AdminCC
 Watcher of the queue or just add them as an AdminCc for the ticket?
 Oh, by the way, you used as an example of a ticket being owned by x,y,z,
 or q. You do realise that a ticket can be owned by ONLY 1 usedID, right?

He means any of. It sounds like Andy wants to have RT add an indivdual's
manager as an AdminCC to to watcher to whatever tickets that individual
processes. (But different workers in the same department could have different
managers).

I suspect that hijacking RT's groups would be the way to go about this.

-- 
Cambridge Energy Alliance: Save money  the planet
___
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