[rt-users] RT Book : does it worth?

2009-02-05 Thread Andrea Perotti
Hi guys
is the book published by O'Reilly still actual or too much time has
passed since 2005 and the info written there are no more updated?

I've seen in changelog from 3.6 to 3.8 a big step head and reading about
the idea of release 4.0 during 2009 make me even more in doubt about
buying it...

Have you read it? Did you find it useful, or the way RT is intended to
be documented nowadays is via wiki and this ML ?

Thank you for your answers and opinions.


cheers

-- 
Andrea Perotti
   Cutaway S.r.l.
   c/o Seat PagineGialle
   email : apero...@cutaway.it
   www   : http://www.cutaway.it


smime.p7s
Description: S/MIME Cryptographic Signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] 10 Newest Unowned tickets i'm allowed to see

2009-02-05 Thread Emmanuel Lacour
On Wed, Feb 04, 2009 at 08:58:33PM -0500, Rob Munsch wrote:
 Hello list,
 
 After some initial confusion, i realized that a user's 10 latest
 block gets the 10 latest tickets, and THEN filters it for what queues
 that user is allowed to see - sometimes resulting in 4 tickets, or 1
 ticket, or no tickets at all!
 
 I'm not sure how, or if i can, change this behaviour.  I'd like the 10
 most recent to show 10 tickets at all times - for
 permissions-filtering to occur before the 10 most recent are counted.
 Any ideas?
 

Depending on your RT version, you can try the following option:

 Set($UseSQLForACLChecks, 1);

but read comment on it in RT_Config.pm before enabling it.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] RT Book : does it worth?

2009-02-05 Thread Ham MI-ID, Torsten Brumm
Hi Andrea,

i remember a threat like this some months ago and again: Yes, the book is still 
actual! There are many changes since 2005 but the core and most of the main 
features are working the same way.

Torsten
 


Kuehne + Nagel (AG  Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), 
Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, 
Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer 
Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 
812773878, Persoenlich haftende Gesellschaft: Kuehne  Nagel A.G., Sitz: 
Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne



-Urspruengliche Nachricht-
Von: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Andrea Perotti
Gesendet: Donnerstag, 5. Februar 2009 10:11
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] RT Book : does it worth?

Hi guys
is the book published by O'Reilly still actual or too much time has 
passed since 2005 and the info written there are no more updated?

I've seen in changelog from 3.6 to 3.8 a big step head and reading about the 
idea of release 4.0 during 2009 make me even more in doubt about buying it...

Have you read it? Did you find it useful, or the way RT is intended to be 
documented nowadays is via wiki and this ML ?

Thank you for your answers and opinions.


cheers

--
Andrea Perotti
   Cutaway S.r.l.
   c/o Seat PagineGialle
   email : apero...@cutaway.it
   www   : http://www.cutaway.it

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] custom reports newbie

2009-02-05 Thread Calvin Chiang
Hi All,

I'm a newbie to custom reports. Are there any good templates floating 
about to start from? or any good guides to building them?

Cheers,

-- 
Calvin Chiang
Network Admin
Utilyx
1st Floor, 55 North Wharf Road
Paddington
London, W2 1LA
Tel: 020 7087 8673
www.utilyx.com


__
Utilyx is the trading name of Utilyx Limited and Utilyx Risk Management 
Limited (URML). URML is authorised and regulated by the Financial Services 
Authority (FSA). This message contains information that may be privileged or 
confidential and is the property of Utilyx. It is intended only for the person 
to whom it is addressed. No confidentiality or privilege is waived or lost by 
any mistransmission. Any views or opinions expressed in this message are solely 
those of the author and do not necessarily represent those of Utilyx. Unless 
otherwise stated, any pricing information given in this message is indicative 
only and does not constitute an offer to deal at any price quoted. If you are 
not the intended recipient, you are not authorized to read, print, retain, 
copy, disseminate, distribute or use this message or any part thereof. If you 
receive this message in error, please notify the sender immediately and delete 
all copies of this message.
__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] Merging 2 RT systems

2009-02-05 Thread Bjoern Schulz
Hi,

If I remember correctly,
we use  RT-Extension-RT2toRT3 several years ago.
Kevin programmed it.

http://www.cpan.org/authors/id/F/FA/FALCONE/RT-Extension-RT2toRT3-1.26.readme

Cheers,
   Björn


Bashir Jahed wrote:
 Hi All,
 
  
 
 I have a request from business to merge 2 RT systems. One is RT 3.x and 
 the other is RT 2.x
 
  
 
 Is this possible, if yes could anyone advise on best route to take?
 
  
 
 Thanks
 
  
 
 
 
 bashir jahed
 nha | enhance
  
 
 5 protea road | claremont | 7708
 po box 24 | newlands | 7725
  
 
 telephone +27 (21) 657-2574
 
   
 
 mobile +27 (83) 414-0453
 
 facsimile +27 (21) 657-2575
 
   
 
 e-mail | messenger bashir.ja...@nha.co.za mailto:bashir.ja...@nha.co.za
 
 
 
 this message is subject to the disclaimer at 
 www.nha.co.za/disclaimer.asp http://www.nha.co.za/disclaimer.asp or 
 disclai...@nha.co.za 
 mailto:disclai...@nha.co.za?subject=request%20disclaimer
 
  
 
  
 
 
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 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: sa...@bestpractical.com


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


Re: [rt-users] 10 Newest Unowned tickets i'm allowed to see

2009-02-05 Thread Rob Munsch
On Thu, Feb 5, 2009 at 8:15 AM, Emmanuel Lacour elac...@easter-eggs.com wrote:

 Depending on your RT version, you can try the following option:

  Set($UseSQLForACLChecks, 1);

 but read comment on it in RT_Config.pm before enabling it.

Go not to the docs for counsel, for they will say both no and yes.
In some cases it result in performance improvements, but some setups
can not handle it.
Is this hardware- or memory-dependent?  What are the variables in
whether it improves or degrades...?

At any rate, trying it now, as this sys isn't in production yet.
Thanks for the pointer, i saw that option but i didn't understand what
it meant at the time.

-- 
/chown -R us:us /yourbase
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] RT Book : does it worth?

2009-02-05 Thread Rainer Duffner
Ham MI-ID, Torsten Brumm schrieb:
 Hi Andrea,

 i remember a threat like this some months ago and again: Yes, the book is 
 still actual! There are many changes since 2005 but the core and most of the 
 main features are working the same way.

 Torsten
  
   


That said, maybe somebody finds the time to do a follow-up that
O'Reilly can sell in the form of their PDF-only short-cuts for 10 USD.

But I guess Bestpractical makes more money by hosting trainings than
through the sales of the book...



Rainer

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] RT Book : does it worth?

2009-02-05 Thread Jesse Vincent

 
 That said, maybe somebody finds the time to do a follow-up that
 O'Reilly can sell in the form of their PDF-only short-cuts for 10 USD.
 
 But I guess Bestpractical makes more money by hosting trainings than
 through the sales of the book...
 

That may be true, but has nothing to do with why I haven't been
pressuring O'Reilly to do a new RT book.  I'd love to see it happen -
It's just not very high on the priority list...and I'd rather see a new
book covering RT4 than RT 3.8.  (http://wiki.bestpractical.com/view/RT4)


pgpymlEKYYroN.pgp
Description: PGP signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] RT Book : does it worth?

2009-02-05 Thread Rainer Duffner
Jesse Vincent schrieb:
 That said, maybe somebody finds the time to do a follow-up that
 O'Reilly can sell in the form of their PDF-only short-cuts for 10 USD.

 But I guess Bestpractical makes more money by hosting trainings than
 through the sales of the book...

 

 That may be true, 

Well, it wasn't meant to sound negative. Just realistic ;-)

 but has nothing to do with why I haven't been
 pressuring O'Reilly to do a new RT book.

Hm. I thought you wrote the book ;-)
(With some others)


   I'd love to see it happen -
 It's just not very high on the priority list...and I'd rather see a new
 book covering RT4 than RT 3.8.  (http://wiki.bestpractical.com/view/RT4)
   

Ah, interesting read.
I wish you good progress ;-)
But realistically, somebody would need to start writing that book now.
Like all those Missing manual books that are released shortly after
the software hits the street.

Can you make an announcement, once you have a version that can be built
and run to get an idea of what it looks like?

I always want to make a VM-image of RT3.8 on FreeBSD with Postgres, but
I never get around doing that, either...



Best Regards,
Rainer



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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] RT Book : does it worth?

2009-02-05 Thread Jesse Vincent


 Well, it wasn't meant to sound negative. Just realistic ;-)

No worries. I just want to be clear that we're not intentionally holding
back on docs to sell training :)
 
I'd love to see it happen -
  It's just not very high on the priority list...and I'd rather see a new
  book covering RT4 than RT 3.8.  (http://wiki.bestpractical.com/view/RT4)

 Can you make an announcement, once you have a version that can be built
 and run to get an idea of what it looks like?


The first alphas will really be look! It compiles! don't use it.

We've started by gutting the internals and leaving the featureset alone. 
After 5+ years, it's something RT really needs. As we get toward beta,
it will be more worth playing with.

-j 


pgpeFrZhSKSDP.pgp
Description: PGP signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] 10 Newest Unowned tickets i'm allowed to see

2009-02-05 Thread Kenneth Marshall
On Thu, Feb 05, 2009 at 10:59:13AM -0500, Rob Munsch wrote:
 On Thu, Feb 5, 2009 at 8:15 AM, Emmanuel Lacour elac...@easter-eggs.com 
 wrote:
 
  Depending on your RT version, you can try the following option:
 
   Set($UseSQLForACLChecks, 1);
 
  but read comment on it in RT_Config.pm before enabling it.
 
 Go not to the docs for counsel, for they will say both no and yes.
 In some cases it result in performance improvements, but some setups
 can not handle it.
 Is this hardware- or memory-dependent?  What are the variables in
 whether it improves or degrades...?
 
 At any rate, trying it now, as this sys isn't in production yet.
 Thanks for the pointer, i saw that option but i didn't understand what
 it meant at the time.
 

I suspect that with certain backends or SearchBuilder versions, the
DB plans could be umm... non-optimal for this feature. :) I am trying
it here as well.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] 10 Newest Unowned tickets i'm allowed to see

2009-02-05 Thread Jesse Vincent

 I suspect that with certain backends or SearchBuilder versions, the
 DB plans could be umm... non-optimal for this feature. :) I am trying
 it here as well.

Indeed. It's still largely experimental. I'd always been fairly certain
that it was impossible, but Ruslan worked a whole bunch of magic.
Feedback would be hugely appreciated.


pgpEBp0Ymi7b6.pgp
Description: PGP signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] RT 3.8.2, Postfix, and external aliases

2009-02-05 Thread Damon Miller
Hi all.  I need a little guidance on a problem I'm having with RT 3.8.2
using Postfix as the MTA.



The issue is that replies are not sent from RT when an external alias is
used; these messages are identified as bounces because their
'Return-Path' header is empty.  Replies are sent without incident when
the actual address on the RT server is used.



I do not have control over the remote server's configuration (running
Microsoft Exchange).  I do have control over my own Postfix server.



The basic configuration is as follows:

helpdesk-supp...@provider.com  --  RT's queue address (for the Support
queue)

supp...@consumer.com  --  Remote alias used for convenience

The supp...@consumer.com address points to helpdesk-supp...@provider.com
by way of a Distribution List which contains only one Contact, the
target address.  I'm told this is how one creates an alias on Exchange
without having to create a new mailbox.



When Postfix receives mail by way of the alias the headers look
something like this:

From MAILER-DAEMON  Wed Feb  4 14:21:39 2009
Return-Path: 
X-Original-To: testinstance-supp...@provider.com

[etc.]

I do see the original destination address further down but that's
expected since the message has to originate somewhere.



When Postfix receives mail sent to the actual local address, the headers
are more complete:

From testacco...@gmail.com  Thu Feb  5 09:36:41 2009
Return-Path: testacco...@gmail.com
X-Original-To: helpdesk-supp...@provider.com



I realize this may be a Postfix question but I'm just not sure where to
start...  My understanding is that the local delivery agent is
responsible for setting the Return-Path and From headers but I
assumed Postfix would do that if necessary.  It is doing this for
messages sent directly to addresses.  The remote server is not setting
these headers; I verified by sniffing the SMTP session.



Any suggestions would be most appreciated.



Thanks very much,

Damon


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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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.2, Postfix, and external aliases

2009-02-05 Thread Jo Rhett
I don't know if postfix supports this, but Sendmail proper allows - 
ba which means that it populates the envelope sender from the From:  
line in the message.  Adding this to the sendmailpipe invocation would  
solve your problem if postfix does this as well.

On Feb 5, 2009, at 11:23 AM, Damon Miller wrote:
 Hi all.  I need a little guidance on a problem I'm having with RT  
 3.8.2
 using Postfix as the MTA.



 The issue is that replies are not sent from RT when an external  
 alias is
 used; these messages are identified as bounces because their
 'Return-Path' header is empty.  Replies are sent without incident when
 the actual address on the RT server is used.



 I do not have control over the remote server's configuration (running
 Microsoft Exchange).  I do have control over my own Postfix server.



 The basic configuration is as follows:

 helpdesk-supp...@provider.com  --  RT's queue address (for the Support
 queue)

 supp...@consumer.com  --  Remote alias used for convenience

 The supp...@consumer.com address points to helpdesk-supp...@provider.com
 by way of a Distribution List which contains only one Contact, the
 target address.  I'm told this is how one creates an alias on Exchange
 without having to create a new mailbox.



 When Postfix receives mail by way of the alias the headers look
 something like this:

 From MAILER-DAEMON  Wed Feb  4 14:21:39 2009
 Return-Path: 
 X-Original-To: testinstance-supp...@provider.com

 [etc.]

 I do see the original destination address further down but that's
 expected since the message has to originate somewhere.



 When Postfix receives mail sent to the actual local address, the  
 headers
 are more complete:

 From testacco...@gmail.com  Thu Feb  5 09:36:41 2009
 Return-Path: testacco...@gmail.com
 X-Original-To: helpdesk-supp...@provider.com



 I realize this may be a Postfix question but I'm just not sure where  
 to
 start...  My understanding is that the local delivery agent is
 responsible for setting the Return-Path and From headers but I
 assumed Postfix would do that if necessary.  It is doing this for
 messages sent directly to addresses.  The remote server is not setting
 these headers; I verified by sniffing the SMTP session.



 Any suggestions would be most appreciated.



 Thanks very much,

 Damon


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

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


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

-- 
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source  
and other randomness


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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


[rt-users] Quick hack to add Resolved column to Quicksearch

2009-02-05 Thread Sam Chenkin
I had a request from one of my users to add a link to view all
resolved tickets to he Quicksearch block in the rt-at-a-glance.
Thought someone might find this useful.

Make the following change to /opt/rt3/share/html/Elements (add line
65). You can add any other status by changing that line. It ONLY
affects the quicksearch.

62foreach ( RT::Queue-ActiveStatusArray ) {
63push @conditions, { cond = Status = '$_', name = loc($_) };
64}
65 +  push @conditions, { cond = Status = 'resolved', name='resolved'};

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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.2, Postfix, and external aliases

2009-02-05 Thread Damon Miller
Jo,

Thanks very much for your reply.  I don't think Postfix's command-line
'sendmail' supports this option, unfortunately...  Postfix's
documentation states that the local delivery agent ('local') does
prepend Return-Path and From headers but this isn't happening for me.
I'll send a note to the Postfix list.  Hopefully someone will provide
some guidance.

Thanks again,

Damon

--

Damon T. Miller
Director of Application Services
Thinking Phone Networks
da...@thinkingphones.com 
617-649-1388 (Office)


 -Original Message-
 From: Jo Rhett [mailto:jrh...@netconsonance.com]
 Sent: Thursday, February 05, 2009 2:56 PM
 To: Damon Miller
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] RT 3.8.2, Postfix, and external aliases
 
 I don't know if postfix supports this, but Sendmail proper allows -
 ba which means that it populates the envelope sender from the From:
 line in the message.  Adding this to the sendmailpipe invocation would
 solve your problem if postfix does this as well.
 
 On Feb 5, 2009, at 11:23 AM, Damon Miller wrote:
  Hi all.  I need a little guidance on a problem I'm having with RT
  3.8.2
  using Postfix as the MTA.
 
 
 
  The issue is that replies are not sent from RT when an external
  alias is
  used; these messages are identified as bounces because their
  'Return-Path' header is empty.  Replies are sent without incident
when
  the actual address on the RT server is used.
 
 
 
  I do not have control over the remote server's configuration
(running
  Microsoft Exchange).  I do have control over my own Postfix server.
 
 
 
  The basic configuration is as follows:
 
  helpdesk-supp...@provider.com  --  RT's queue address (for the
Support
  queue)
 
  supp...@consumer.com  --  Remote alias used for convenience
 
  The supp...@consumer.com address points to
helpdesk-supp...@provider.com
  by way of a Distribution List which contains only one Contact,
the
  target address.  I'm told this is how one creates an alias on
Exchange
  without having to create a new mailbox.
 
 
 
  When Postfix receives mail by way of the alias the headers look
  something like this:
 
  From MAILER-DAEMON  Wed Feb  4 14:21:39 2009
  Return-Path: 
  X-Original-To: testinstance-supp...@provider.com
 
  [etc.]
 
  I do see the original destination address further down but that's
  expected since the message has to originate somewhere.
 
 
 
  When Postfix receives mail sent to the actual local address, the
  headers
  are more complete:
 
  From testacco...@gmail.com  Thu Feb  5 09:36:41 2009
  Return-Path: testacco...@gmail.com
  X-Original-To: helpdesk-supp...@provider.com
 
 
 
  I realize this may be a Postfix question but I'm just not sure where
  to
  start...  My understanding is that the local delivery agent is
  responsible for setting the Return-Path and From headers but I
  assumed Postfix would do that if necessary.  It is doing this for
  messages sent directly to addresses.  The remote server is not
setting
  these headers; I verified by sniffing the SMTP session.
 
 
 
  Any suggestions would be most appreciated.
 
 
 
  Thanks very much,
 
  Damon
 
 
  ___
  http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
  Community help: http://wiki.bestpractical.com
  Commercial support: sa...@bestpractical.com
 
 
  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
  Buy a copy at http://rtbook.bestpractical.com
 
 --
 Jo Rhett
 Net Consonance : consonant endings by net philanthropy, open source
 and other randomness
 

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] RT Time fields in days?

2009-02-05 Thread Kenneth Crocker
Kristian,

Thanks. I'll give it a try.

Kenn
LBNL

On 2/4/2009 2:46 AM, Kristian Davies wrote:
 Not my code, but in the interest of sharing:
 
 local/html/Elements/SelectTimeUnits
 
 %# END BPS TAGGED BLOCK }}}
 % my $selected = 'minutes';
 % $selected = 'hours' if $minutes  60;
 % $selected = 'days'  if $minutes  480;
 select class=TimeUnits id=% $Name % name=% $Name %
 option value=minutes % (($selected eq
 'minutes')?'selected=selected':'') %% loc('Minutes') %/option
 option value=hours % (($selected eq
 'hours')?'selected=selected':'') %% loc('Hours') %/option
 option value=days % (($selected eq
 'days')?'selected=selected':'') %% loc('Days') %/option
 /select
 %INIT
 $Name .= '-TimeUnits' unless $Name =~ /-TimeUnits$/io;
 /%INIT
 %ARGS
 $Name = ''
 $minutes = ''
 /%ARGS
 
 Kristian
 

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] Security risk! Passwords can be compromised!

2009-02-05 Thread Jesse Vincent



On Tue  3.Feb'09 at 22:37:59 -0500, Isaac Vetter wrote:
  The docs for 'LogStackTrace' have been updated as follows. How do
  folks feel about the new notice?
 
  If set then logging will include stack
   traces for messages with level equal or greater than
  specified.
 
  NOTICE: Stack traces include parameters that functions or methods
  were called with. It is possible for stack trace logging to reveal sensitive
  information such as passwords and ticket content in your logs.
 
 Jesse,
 
 Since you're asking (and towards the goal of something useful coming from
 this thread). :)
 
 I would say that, in this case, you shouldn't end a sentence with a
 preposition.
 
 How about:
 Stack traces include the parameters of called functions.
 or
 Stack traces include the parameters used within methods and functions.
 or
 ...

I've just checked in this:

NOTICE: Stack traces include parameters supplied to functions or
methods. It is possible for stack trace logging to reveal sensitive
information such as passwords or ticket content in your logs.



pgpmijWY9UzUx.pgp
Description: PGP signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Scrip send email on create

2009-02-05 Thread Kenneth Crocker
Dan,


I may be wrong, but I believe you can order the sequence of scrips by 
the name field. I put a 1a, 1b, 2a, 2c in front of the name of several 
scrips I have that run for the same transaction, but need them to run in 
sequence. That and setting the TransactionBatch to 1 works for me. Hope 
this helps. Hope this helps.

Kenn
LBNL

On 2/4/2009 10:34 AM, Dan O'Neill wrote:
 Jeremy Burke wrote:
 I think you need 2 scrips.  The scrip you have below and then another scrip 
 to send e-mail on create to the AdminCCs.  You need to make sure the Add 
 AdminCC scrip you have below is executed before the scrip that sends to the 
 AdminCCs.

 I'm using RT 3.8.1 and this is how I have it setup to work.  The 1 at the 
 beginning of Scrip #2's description forces this scrip to be run before scrip 
 #1
 
 Jeremy,
 
 Thanks for the information. This helps, but doesn't solve the problem 
 because I'm using RT 3.4.5 which does not guarantee scrip order.  Thus, 
 an upgrade is likely to be the path I have to take.  I really don't want 
 to upgrade right now.
 
 This wiki article 
 http://wiki.bestpractical.com/view/TransactionBatchStage covers my 
 problem well.
 
 Does anyone have a solution for rt 3.4.5?
 
 Dan
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 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: sa...@bestpractical.com


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


Re: [rt-users] FW: Quick Ticket Creation widget - how to remove it?

2009-02-05 Thread Kenneth Crocker
Jim,

I'mnot sure, but I think you have to remove that particular entry from 
the ATTRIBUTES Table for each user that has selected the feature on 
their home page (3.6+). Also, you need to remove it from the 
RT_SiteConfig.pm file. I removed it from mine - 
Set($HomepageComponents, [qw(Quicksearch MySupportQueues MyReminders 
RefreshHomepage)]);. Hope this helps.


Kenn
LBNL

On 2/4/2009 6:53 AM, Jim Tambling wrote:
 That only removes it from the layout of the user that's logged in. I
 want to remove it from everyone's layout.
 
 Jim
 
 -Original Message-
 From: Jeff Voskamp [mailto:javos...@uwaterloo.ca] 
 Sent: 04 February 2009 14:49
 To: Jim Tambling
 Subject: Re: [rt-users] Quick Ticket Creation widget - how to remove it?
 
 Jim Tambling wrote:
 As per the subject, fairly new to RT but I have looked everywhere and 
 can't find a simple way to do it.

 Regards

 Configuration-Global-RT at a Glance and pull it from the layout.
 
 Jeff
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 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: sa...@bestpractical.com


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


Re: [rt-users] Security risk! Passwords can be compromised!

2009-02-05 Thread Rob Munsch
On Thu, Feb 5, 2009 at 3:47 PM, Jesse Vincent je...@bestpractical.com wrote:



 On Tue  3.Feb'09 at 22:37:59 -0500, Isaac Vetter wrote:
  The docs for 'LogStackTrace' have been updated as follows. How do
  folks feel about the new notice?
 
  If set then logging will include stack
   traces for messages with level equal or greater than
  specified.
 
  NOTICE: Stack traces include parameters that functions or methods
  were called with. It is possible for stack trace logging to reveal 
  sensitive
  information such as passwords and ticket content in your logs.

 Jesse,

 Since you're asking (and towards the goal of something useful coming from
 this thread). :)

 I would say that, in this case, you shouldn't end a sentence with a
 preposition.

 How about:
 Stack traces include the parameters of called functions.
 or
 Stack traces include the parameters used within methods and functions.
 or
 ...

 I've just checked in this:

 NOTICE: Stack traces include parameters supplied to functions or
 methods. It is possible for stack trace logging to reveal sensitive
 information such as passwords or ticket content in your logs.

That sounds perfect.  Once i was done testing ExternalAuth, i turned
off stack traces then manually blew away those sections of the logs
that contained the passwords anyway, just to keep in paranoia
practice.

-- 
/chown -R us:us /yourbase
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] FW: Quick Ticket Creation widget - how to remove it?

2009-02-05 Thread Rob Munsch
On Thu, Feb 5, 2009 at 3:54 PM, Kenneth Crocker kfcroc...@lbl.gov wrote:
 Jim,

I'mnot sure, but I think you have to remove that particular entry from
 the ATTRIBUTES Table for each user that has selected the feature on
 their home page (3.6+). Also, you need to remove it from the
 RT_SiteConfig.pm file. I removed it from mine -
 Set($HomepageComponents, [qw(Quicksearch MySupportQueues MyReminders
 RefreshHomepage)]);. Hope this helps.


 Kenn
 LBNL

 On 2/4/2009 6:53 AM, Jim Tambling wrote:
 That only removes it from the layout of the user that's logged in. I
 want to remove it from everyone's layout.

 Jim

 -Original Message-
 From: Jeff Voskamp [mailto:javos...@uwaterloo.ca]
 Sent: 04 February 2009 14:49
 To: Jim Tambling
 Subject: Re: [rt-users] Quick Ticket Creation widget - how to remove it?

 Jim Tambling wrote:
 As per the subject, fairly new to RT but I have looked everywhere and
 can't find a simple way to do it.

 Regards

 Configuration-Global-RT at a Glance and pull it from the layout.

 Jeff

When logged in as root, Global - RT at a glance - which describes
itself as altering the default view - lets me remove QuickCreate.
Logging out as root and back in as a normal (privileged, in a group)
user no longer has the QuickCreate widget in my At A Glance,
indicating that it does indeed modify the default view for all users.
The user as far as i can tell does not have permissions to add it
back.

This is in 3.8.2, if that matters.

-- 
/chown -R us:us /yourbase
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


[rt-users] FW: 3.8.1 - New upgrade slow on 'New Search click

2009-02-05 Thread Stuart Browne
I sent this through a while ago, but got no responses.

Anybody know what can help with this slow 'Search page' coming up issue?

I've since seen a few other people mention the issue, but no response there 
either..

Anybody?

Stuart

-Original Message-
From: Stuart Browne
Sent: Thursday, 4 December 2008 12:06
To: 'rt-users@lists.bestpractical.com'
Subject: 3.8.1 - New upgrade slow on 'New Search click

Hi,

After doing a 3.8.1 upgrade (install into new directory, upgrade db from 
3.6.5), clicking on 'Tickets' / 'New Search' causes a 10-15 second pause.

Digging through the active queries when that occurs shows the following query:

SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4 JOIN Principals 
Principals_1  ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers 
CachedGroupMembers_2  ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) 
JOIN Groups Groups_3  ON ( Groups_3.id = CachedGroupMembers_2.GroupId )  WHERE 
(Principals_1.Disabled = '0') AND (ACL_4.PrincipalType = Groups_3.Type) AND 
(Principals_1.id != '1') AND (Principals_1.PrincipalType = 'User') AND 
(ACL_4.RightName = 'OwnTicket' OR ACL_4.RightName = 'SuperUser') AND 
(Groups_3.Domain = 'RT::Queue-Role') AND ((ACL_4.ObjectType = 'RT::Queue') OR 
(ACL_4.ObjectType = 'RT::System'))  ORDER BY main.Name ASC

Eww.

Anyway.  The explain on this shows:

*** 1. row ***
   id: 1
  select_type: SIMPLE
table: main
 type: range
possible_keys: PRIMARY
  key: PRIMARY
  key_len: 4
  ref: NULL
 rows: 65
Extra: Using where; Using temporary; Using filesort
*** 2. row ***
   id: 1
  select_type: SIMPLE
table: Principals_1
 type: eq_ref
possible_keys: PRIMARY
  key: PRIMARY
  key_len: 4
  ref: rt3.main.id
 rows: 1
Extra: Using where; Distinct
*** 3. row ***
   id: 1
  select_type: SIMPLE
table: CachedGroupMembers_2
 type: ref
possible_keys: DisGrouMem,CachedGroupMembers3
  key: CachedGroupMembers3
  key_len: 5
  ref: rt3.Principals_1.id
 rows: 1
Extra: Using where; Distinct
*** 4. row ***
   id: 1
  select_type: SIMPLE
table: ACL_4
 type: range
possible_keys: ACL1
  key: ACL1
  key_len: 54
  ref: NULL
 rows: 82
Extra: Using where; Using index; Distinct
*** 5. row ***
   id: 1
  select_type: SIMPLE
table: Groups_3
 type: eq_ref
possible_keys: PRIMARY,Groups1,Groups2
  key: PRIMARY
  key_len: 4
  ref: rt3.CachedGroupMembers_2.GroupId
 rows: 1
Extra: Using where; Distinct

Using google, two possible matches were found.

- One of the queues has a 'Group Right' allowing 'Everyone' to 'Own Ticket'.  I 
have gone through all our queues, found one queue with this permission.  
Removed the permission, issue still persists.  I've even gone through and 
verified disabled queue's group rights.

- The explain shows 'Using filesort' and the 'tmp_table_size' should be 
increased.  Changing this to 4 times the default has had no effect.  This 
coupled with the fact that our DB isn't that big.

So, I was wondering if anybody else was experiencing this pause, and preferably 
if anybody knows what's causing it so I can fix it.

Thanks

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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


Re: [rt-users] 10 Newest Unowned tickets i'm allowed to see

2009-02-05 Thread Ruslan Zakirov
DB and setup dependent. ACL checks in RT are painful for all DBs,
however these days we at least know how to cook old queries and there
are a lot of knowledge on the web. This new feature changes balance.
New queries may need new indexes, new execution paths may need new
optimizations and bug fixes and...

On Thu, Feb 5, 2009 at 6:59 PM, Rob Munsch rob.mun...@gmail.com wrote:
 On Thu, Feb 5, 2009 at 8:15 AM, Emmanuel Lacour elac...@easter-eggs.com 
 wrote:

 Depending on your RT version, you can try the following option:

  Set($UseSQLForACLChecks, 1);

 but read comment on it in RT_Config.pm before enabling it.

 Go not to the docs for counsel, for they will say both no and yes.
 In some cases it result in performance improvements, but some setups
 can not handle it.
 Is this hardware- or memory-dependent?  What are the variables in
 whether it improves or degrades...?

 At any rate, trying it now, as this sys isn't in production yet.
 Thanks for the pointer, i saw that option but i didn't understand what
 it meant at the time.

 --
 /chown -R us:us /yourbase
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


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




-- 
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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