[rt-users] Time fields in days

2011-05-04 Thread Joosep
Hi list!

RT version is 3.8.10 running on postgres 8.3.14 and debian 5.0.

I'm trying to set RT to use unit days in time fields in addition to
minutes and hours.
I found similar thread in list archives:
http://www.gossamer-threads.com/lists/rt/users/82265

RT version in that thread was 3.8.2. It seems that things are changed a
little since then.
I have found, that some of necessary code is  in the file
share/html/Elements/SelectTimeUnits.
I have now unit days in the right place, but there is no relation between
days and hours/minutes. I.e RT doesn't know how much minutes/hours 1 day is.
Any idea where i can find that logic?
If anybody knows better way to do it, i would be greatful to hear it.

Thanks in advance,
Joosep


Re: [rt-users] Manual for Full-text search

2011-05-04 Thread Johan Sjöberg
Hi.

Thank you for your reply. We will probably start looking at migrating from 
MySQL to Postgres, since it seems like that is much better way to go. Looking 
forward to the full-text search documentation.

/Johan

-Original Message-
From: Alex Vandiver [mailto:ale...@bestpractical.com] 
Sent: den 3 maj 2011 17:53
To: Johan Sjöberg
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Manual for Full-text search

On Mon, 2011-05-02 at 13:52 +, Johan Sjöberg wrote:
 I am currently evaluating RT4 on our RT test-server. I noticed that 
 improved fulltext-search is one of the things mentioned in the release 
 notes, and I can also see some settings regarding FullTextSearch in 
 RT_Config.pm.
 
 Is there any documentation on how to setup and use this feature? It 
 would be very useful to us.

We will be shipping much-improved documentation on the full-text searching in 
RT 4.0.1.  There is also a sizable bug which prevents it from working on MySQL 
in RT 4.0.0, which we hope to resolve quickly enough to also land in RT 4.0.1.

 We are using MySQL 5.0

The updated documentation will also make clear that as MySQL does not include 
built-in full-text search capabilities, we rely on the external Sphinx FTS 
tool.  Unfortunately, the SphinxSE engine which allows us to make FTS queries 
from within MySQL requires recompiling MySQL.  You can find complete 
instructions on how to do this at 
http://sphinxsearch.com/docs/2.0.1/sphinxse-installing.html

 - Alex



Re: [rt-users] Manual for Full-text search

2011-05-04 Thread Patrick Fish
I've been debating the same thing...would the procedure shown on the MySQLToPg 
page on the Wiki still be valid for 4.0.x?

Patrick


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Johan Sjöberg
Sent: Wednesday, May 04, 2011 12:38 AM
To: Alex Vandiver
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Manual for Full-text search

Hi.

Thank you for your reply. We will probably start looking at migrating from 
MySQL to Postgres, since it seems like that is much better way to go. Looking 
forward to the full-text search documentation.

/Johan

-Original Message-
From: Alex Vandiver [mailto:ale...@bestpractical.com]
Sent: den 3 maj 2011 17:53
To: Johan Sjöberg
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Manual for Full-text search

On Mon, 2011-05-02 at 13:52 +, Johan Sjöberg wrote:
 I am currently evaluating RT4 on our RT test-server. I noticed that 
 improved fulltext-search is one of the things mentioned in the release 
 notes, and I can also see some settings regarding FullTextSearch in 
 RT_Config.pm.
 
 Is there any documentation on how to setup and use this feature? It 
 would be very useful to us.

We will be shipping much-improved documentation on the full-text searching in 
RT 4.0.1.  There is also a sizable bug which prevents it from working on MySQL 
in RT 4.0.0, which we hope to resolve quickly enough to also land in RT 4.0.1.

 We are using MySQL 5.0

The updated documentation will also make clear that as MySQL does not include 
built-in full-text search capabilities, we rely on the external Sphinx FTS 
tool.  Unfortunately, the SphinxSE engine which allows us to make FTS queries 
from within MySQL requires recompiling MySQL.  You can find complete 
instructions on how to do this at 
http://sphinxsearch.com/docs/2.0.1/sphinxse-installing.html

 - Alex



Re: [rt-users] RT 4.0 with fcgid

2011-05-04 Thread john s.


Thomas Sibley wrote:
 
 You should read docs/web_deployment.pod.
 
 


Hello Thomas 

I have read the document.

And here is my config: 

 Here is my config:

AddDefaultCharset UTF-8

Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/
ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/

#   ServerAdmin webmaster@localhost

DocumentRoot /opt/rt4/share/html/
Location /
Order allow,deny
Allow from all
Options +ExecCGI
AddHandler fcgid-script fcgi
/Location

# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
LogLevel warn

CustomLog /var/log/apache2/access.log combined


#RewriteEngine on
#RewriteRule ^/rt$ /rt/
#RewriteRule ^/rt/(.*)$ /opt/rt4/share/html/$1
#RewriteCond %{REQUEST_FILENAME} -d
#RewriteRule ^(/opt/rt4/share/html.*)/$ $1/index.html



#Include /opt/rt4/apache2-modperl2.conf
#RedirectMatch ^/$ /rt


/VirtualHost

Now apache gives me error : 

fbfailed to resolve handler `RT::Mason': Can't locate RT/Mason.pm in @INC
(@INC contains: /etc/perl /usr/local/lib/perl/5.10.1
/usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .
/etc/apache2) at (eval 9) line 3.\n
RT failed to resolve handler `RT::Mason'




Whats wrong with my config ? or is an module still missing? 

best regards john s.

 
-- 
View this message in context: 
http://old.nabble.com/RT-4.0-with-fcgid-tp31532665p31539327.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



Re: [rt-users] Manual for Full-text search

2011-05-04 Thread Johan Sjöberg
I wanted to ask the same question, so I know if I should do the migration 
before or after upgrading to RT 4.
There are a lot of different methods on that page, and the simplest ones seem 
to be just dumping the MySQL database and importing it into Postgres. Is there 
any general consensus regarding which method is best, with the biggest chance 
of getting non-corrupted attachments etc.?

/Johan

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Patrick Fish
Sent: den 4 maj 2011 09:51
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Manual for Full-text search

I've been debating the same thing...would the procedure shown on the MySQLToPg 
page on the Wiki still be valid for 4.0.x?

Patrick


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Johan Sjöberg
Sent: Wednesday, May 04, 2011 12:38 AM
To: Alex Vandiver
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Manual for Full-text search

Hi.

Thank you for your reply. We will probably start looking at migrating from 
MySQL to Postgres, since it seems like that is much better way to go. Looking 
forward to the full-text search documentation.

/Johan

-Original Message-
From: Alex Vandiver [mailto:ale...@bestpractical.com]
Sent: den 3 maj 2011 17:53
To: Johan Sjöberg
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Manual for Full-text search

On Mon, 2011-05-02 at 13:52 +, Johan Sjöberg wrote:
 I am currently evaluating RT4 on our RT test-server. I noticed that 
 improved fulltext-search is one of the things mentioned in the release 
 notes, and I can also see some settings regarding FullTextSearch in 
 RT_Config.pm.
 
 Is there any documentation on how to setup and use this feature? It 
 would be very useful to us.

We will be shipping much-improved documentation on the full-text searching in 
RT 4.0.1.  There is also a sizable bug which prevents it from working on MySQL 
in RT 4.0.0, which we hope to resolve quickly enough to also land in RT 4.0.1.

 We are using MySQL 5.0

The updated documentation will also make clear that as MySQL does not include 
built-in full-text search capabilities, we rely on the external Sphinx FTS 
tool.  Unfortunately, the SphinxSE engine which allows us to make FTS queries 
from within MySQL requires recompiling MySQL.  You can find complete 
instructions on how to do this at 
http://sphinxsearch.com/docs/2.0.1/sphinxse-installing.html

 - Alex



Re: [rt-users] Manual for Full-text search

2011-05-04 Thread Emmanuel Lacour
On Wed, May 04, 2011 at 08:01:58AM +, Johan Sjöberg wrote:
 I wanted to ask the same question, so I know if I should do the
 migration before or after upgrading to RT 4.
 There are a lot of different methods on that page, and the simplest
 ones seem to be just dumping the MySQL database and importing it into
 Postgres. Is there any general consensus regarding which method is
 best, with the biggest chance of getting non-corrupted attachments
 etc.?
 

I had success to do this using a script that select in source DB and
insert in the destination DB (with a schema without datas).

Test: Oracle-Pg, MySQL - Pg

to my knowledge and experience, this is the best way to do this.

You can do this either:

- 4.0 schema and datas - 4.0 schema
- 3.8 schema and datas - 3.8 schema - run 3.8-4.0 upgrades scripts




Re: [rt-users] Manual for Full-text search

2011-05-04 Thread Johan Sjöberg
Hi.

This sounds great. Is this script one of the methods at 
http://requesttracker.wikia.com/wiki/MySQLToPg ?

/Johan

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Emmanuel Lacour
Sent: den 4 maj 2011 10:48
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Manual for Full-text search

On Wed, May 04, 2011 at 08:01:58AM +, Johan Sjöberg wrote:
 I wanted to ask the same question, so I know if I should do the 
 migration before or after upgrading to RT 4.
 There are a lot of different methods on that page, and the simplest 
 ones seem to be just dumping the MySQL database and importing it into 
 Postgres. Is there any general consensus regarding which method is 
 best, with the biggest chance of getting non-corrupted attachments 
 etc.?
 

I had success to do this using a script that select in source DB and insert in 
the destination DB (with a schema without datas).

Test: Oracle-Pg, MySQL - Pg

to my knowledge and experience, this is the best way to do this.

You can do this either:

- 4.0 schema and datas - 4.0 schema
- 3.8 schema and datas - 3.8 schema - run 3.8-4.0 upgrades scripts




Re: [rt-users] Manual for Full-text search

2011-05-04 Thread Emmanuel Lacour
On Wed, May 04, 2011 at 09:02:28AM +, Johan Sjöberg wrote:
 Hi.
 
 This sounds great. Is this script one of the methods at 
 http://requesttracker.wikia.com/wiki/MySQLToPg ?
 

I used a script inspired from AndreSachs one (slightly modified because
I had MySQL encoding changes to handle at the same time).


[rt-users] Reuse RT System Saved Searches for all users

2011-05-04 Thread Lars Reimann

Hi,

we stored a saved search (Tickets) in RT System's saved searches with 
the intention to make the search visible to all users.


However,

normal users cannot even see saved searches. We do require users to load 
them only and i gave the showsavedsearch and loadsavedsearch to every one.


It is not clear to me which access rights are needed to enable users to 
see those system searches.


If this is not possible via RT System's saved searches, how do I make 
searches available to all users?
Otherwise every user has to save his/her own identical query which is 
impractical and most of our users do not want to understand detailed 
search semantics.


greetings,
l.r.



Re: [rt-users] RT 4.0 with fcgid

2011-05-04 Thread john s.


Okay now my system works ... but i think it more slowly than the normal
modperl solution 

My apache error.log says the following:

 mod_deflate.c(615): [client 192.168.112.1] Zlib: Compressed 0 to 2 : URL
/NoAuth/Login.html, referer: http://192.168.112.26/
[Wed May 04 13:16:55 2011] [debug] mod_deflate.c(615): [client
192.168.112.1] Zlib: Compressed 23402 to 4577 : URL /, referer:
http://192.168.112.26

is that a normal behaviour?


and is there any way to make an performance test?

best regards john s.







-- 
View this message in context: 
http://old.nabble.com/RT-4.0-with-fcgid-tp31532665p31540753.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



Re: [rt-users] Reuse RT System Saved Searches for all users

2011-05-04 Thread Raed El-Hames
Lars:

 we stored a saved search (Tickets) in RT System's saved searches with
 the intention to make the search visible to all users.

RT System Saved Searches are only available to SuperUsers, these are the 
searches you include as default in home page etc etc.
I think for your purposes and if its possible for you (pending number of users 
etc), I would suggest you create a new generic group and add all your users as 
members, then make your search as the new group search.

Over here I have few generic groups, AllStaff which include all our staff, 
AllCustomers include our customers groups 
And 3rdParty which include suppliers groups etc, having these generic groups 
make my life much easier when applying permissions / dashboards and saved 
searches etc.


Regards;
Roy 

 -Original Message-
 From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
 boun...@lists.bestpractical.com] On Behalf Of Lars Reimann
 Sent: 04 May 2011 11:43
 To: rt-users@lists.bestpractical.com
 Subject: [rt-users] Reuse RT System Saved Searches for all users
 
 Hi,
 
 we stored a saved search (Tickets) in RT System's saved searches with
 the intention to make the search visible to all users.
 
 However,
 
 normal users cannot even see saved searches. We do require users to load
 them only and i gave the showsavedsearch and loadsavedsearch to every one.
 
 It is not clear to me which access rights are needed to enable users to
 see those system searches.
 
 If this is not possible via RT System's saved searches, how do I make
 searches available to all users?
 Otherwise every user has to save his/her own identical query which is
 impractical and most of our users do not want to understand detailed
 search semantics.
 
 greetings,
 l.r.



Re: [rt-users] RT 4.0 with fcgid

2011-05-04 Thread Thomas Sibley
On 05/04/2011 07:18 AM, john s. wrote:
 Okay now my system works ... but i think it more slowly than the normal
 modperl solution 

Posting what was wrong with your configuration would be helpful for
future mailing list searches.

 My apache error.log says the following:
 
  mod_deflate.c(615): [client 192.168.112.1] Zlib: Compressed 0 to 2 : URL
 /NoAuth/Login.html, referer: http://192.168.112.26/
 [Wed May 04 13:16:55 2011] [debug] mod_deflate.c(615): [client
 192.168.112.1] Zlib: Compressed 23402 to 4577 : URL /, referer:
 http://192.168.112.26
 
 is that a normal behaviour?

As the messages indicate, you have mod_deflate turned on in Apache.
mod_default is not part of RT, and those messages don't come from RT.

 and is there any way to make an performance test?

There are lots of third party tools to benchmark websites, but you
provide no details of what seems slower, so I can't recommend anything.


[rt-users] Searching for AdminCc

2011-05-04 Thread Lars Braeuer
Hello,

first of all, thanks for this great piece of software.

We are using RT for quite a while now. We are currently testing RT 4.0.0 and 
were wondering, if
there is a work around for what we are doing, without actually having to modify 
the code.

We have a saved search that allows us to display all tickets on the dashboard, 
that are not owned by
the user running the search, but all tickets that a user is AdminCc on.

In order to achieve this, I changed the code to use __CurrentUserEmail__ in the 
search:

--- lib/RT/Tickets_SQL.pm.orig  2011-05-02 21:47:49.0 +0200
+++ lib/RT/Tickets_SQL.pm   2011-05-04 16:15:00.0 +0200
@@ -202,6 +202,8 @@
 # replace __CurrentUser__ with id
 $value = $self-CurrentUser-id if $value eq '__CurrentUser__';

+# replace __CurrentUserEmail__ with EmailAddress
+$value = $self-CurrentUser-EmailAddress if $value eq 
'__CurrentUserEmail__';

 unless( $dispatch{ $class } ) {
 die No dispatch method for class '$class'


The query of the saved search is:
Owner != 'Nobody' AND Status != 'resolved' AND Status != 'rejected' AND Status 
!= 'stalled' AND
Owner != '__CurrentUser__' AND AdminCc.EmailAddress LIKE '__CurrentUserEmail__'

This is working fine for us, but it's really annoying to carry on the change 
through all releases.

Is there another easy way to achieve what we are trying to do, or could you 
consider to add this
patch upstream?

Best regards,

Lars Bräuer


Re: [rt-users] Searching for AdminCc

2011-05-04 Thread Thomas Sibley
On 05/04/2011 11:00 AM, Lars Braeuer wrote:
 The query of the saved search is:
 Owner != 'Nobody' AND Status != 'resolved' AND Status != 'rejected' AND 
 Status != 'stalled' AND
 Owner != '__CurrentUser__' AND AdminCc.EmailAddress LIKE 
 '__CurrentUserEmail__'
 
 This is working fine for us, but it's really annoying to carry on the change 
 through all releases.
 
 Is there another easy way to achieve what we are trying to do, or could you 
 consider to add this
 patch upstream?

Your change isn't necessary.  Just use AdminCc.id = '__CurrentUser__'
instead (that's been supported for a long time).

Thomas


Re: [rt-users] Searching for AdminCc

2011-05-04 Thread Lars Braeuer
Hi Thomas,

thanks a lot. That's it and it's so obvious, I should have stumbled accross it 
when setting up the
query. Thanks again.

Lars

Am 04.05.2011 18:05, schrieb Thomas Sibley:
 On 05/04/2011 11:00 AM, Lars Braeuer wrote:
 The query of the saved search is:
 Owner != 'Nobody' AND Status != 'resolved' AND Status != 'rejected' AND 
 Status != 'stalled' AND
 Owner != '__CurrentUser__' AND AdminCc.EmailAddress LIKE 
 '__CurrentUserEmail__'

 This is working fine for us, but it's really annoying to carry on the change 
 through all releases.

 Is there another easy way to achieve what we are trying to do, or could you 
 consider to add this
 patch upstream?
 
 Your change isn't necessary.  Just use AdminCc.id = '__CurrentUser__'
 instead (that's been supported for a long time).
 
 Thomas
 


Re: [rt-users] Messages to AdminCCs , as Cc not Bcc

2011-05-04 Thread Matteo Sgalaberni
On Fri, Apr 29, 2011 at 10:00:52AM -0400, Kevin Falcone wrote:
 On Thu, Apr 28, 2011 at 03:36:27PM +0100, Brahim Sakka wrote:
 Hello list,
 I've got a couple of AdminCCs in my Queue. They are getting emails as 
  Bcc ; but I want them to
 be emailed as Cc. Is there a way to do that in RT?
 Thank you in advance, and sorry if I'm missing something obvious here
 
 That would require customizations to the Notify action since it always
 treats AdminCcs as Bccs (this allows you to notify AdminCcs along with
 other Watchers while keeping the AdminCcs invisible)
Hi Kevin, seems that this question is recurring in this mailing list.
I'm still searching a way to do this. I read in this ml that someone
suggested to hack the sourcecode... but your last solution sound
better and clean... Can you write/explain what should be inserted in the
action to perform this?

Thanks,

Matteo


Re: [rt-users] Time fields in days

2011-05-04 Thread Kenneth Crocker
Joosep,

I did that. However, I wanted to maintain the concept of 'hours', so I
changed the DataBase to contain all time fields with 3 decimal positions
(.125 = 1 hour). I changed all the displays, etc. to show that.

Kenn
LBNL

On Tue, May 3, 2011 at 11:21 PM, Joosep joos...@gmail.com wrote:

 Hi list!

 RT version is 3.8.10 running on postgres 8.3.14 and debian 5.0.

 I'm trying to set RT to use unit days in time fields in addition to
 minutes and hours.
 I found similar thread in list archives:
 http://www.gossamer-threads.com/lists/rt/users/82265

 RT version in that thread was 3.8.2. It seems that things are changed a
 little since then.
 I have found, that some of necessary code is  in the file
 share/html/Elements/SelectTimeUnits.
 I have now unit days in the right place, but there is no relation between
 days and hours/minutes. I.e RT doesn't know how much minutes/hours 1 day is.
 Any idea where i can find that logic?
 If anybody knows better way to do it, i would be greatful to hear it.

 Thanks in advance,
 Joosep



Re: [rt-users] Messages to AdminCCs , as Cc not Bcc

2011-05-04 Thread Kevin Falcone
On Wed, May 04, 2011 at 06:37:01PM +0200, Matteo Sgalaberni wrote:
 On Fri, Apr 29, 2011 at 10:00:52AM -0400, Kevin Falcone wrote:
  On Thu, Apr 28, 2011 at 03:36:27PM +0100, Brahim Sakka wrote:
  Hello list,
  I've got a couple of AdminCCs in my Queue. They are getting emails as 
   Bcc ; but I want them to
  be emailed as Cc. Is there a way to do that in RT?
  Thank you in advance, and sorry if I'm missing something obvious here
  
  That would require customizations to the Notify action since it always
  treats AdminCcs as Bccs (this allows you to notify AdminCcs along with
  other Watchers while keeping the AdminCcs invisible)
 Hi Kevin, seems that this question is recurring in this mailing list.
 I'm still searching a way to do this. I read in this ml that someone
 suggested to hack the sourcecode... but your last solution sound
 better and clean... Can you write/explain what should be inserted in the
 action to perform this?

Modifying Notify is changing the source code.
The best way might be to make a new Action based on Notify with your
modifications as a local customization

-kevin


pgpvsRK0jxcx6.pgp
Description: PGP signature


Re: [rt-users] Is a time zone user preference available?

2011-05-04 Thread Eli Guzman
Thanks for the information Raphaël. I am using 0.8_01, but I am having some 
issues getting FF4 to work properly with it (as far as SSO is concerned). I may 
just wait for the next release of RT::Authen:ExternalAuth, and see if this 
fixes the issue. Thanks once more for your reply :).

Regards,
--Eli



From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Raphaël MOUNEYRES
Sent: Tuesday, May 03, 2011 8:25 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Is a time zone user preference available?



In fact it does work with FF4, even if the same SSO Failed and no user to test 
with. Nexting message appears in my logs... i'm just living with it 
my  version of RT::Authen:ExternalAuth is 0.08 running on a Mandriva 2010 
i have not tested with later versions of authen plugin (maybe i should) 

Raphaël 





Eli Guzman eguz...@cvimellesgriot.com 

02/05/2011 20:06 


A
Raphaël MOUNEYRES raphael.mouney...@sagemcom.com, 
rt-users@lists.bestpractical.com 
cc

Objet
RE: [rt-users] Is a time zone user preference available?







Thanks for the information Raphaël. I have tried SSO with Firefox 4 as well, 
and the LDAP authentication piece works but I have been unable to get the SSO 
piece working properly. Same error gets generated in FF4 as it does in IE8:

[Mon May  2 16:16:37 2011] [debug]: Attempting to use external auth service: 
My_LDAP 
(/opt/rt3/local/plugins/RT-uthen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:64)
[Mon May  2 16:16:37 2011] [debug]: SSO Failed and no user to test with. 
Nexting 
(/opt/rt3/local/plugins/RT-Authn-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:92)
[Mon May  2 16:16:37 2011] [debug]: Autohandler called ExternalAuth. Response: 
(0, No User) 
(/opt/rt3/local/plugns/RT-Authen-ExternalAuth/html/Elements/DoAuth:26)

I am running 3.8.9 rather than 3.8.8, so that may be the key difference 
(besides being on RHEL 5.6). If you don't mind me asking what version of 
RT::Authen:ExternalAuth are you currently running (and on what server 
platform)? Not sure if you are on an earlier/later version, but if you are on a 
later version this may be useful information, as I may just need to upgrade it.

Thanks,
Eli


From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Raphaël MOUNEYRES
Sent: Monday, May 02, 2011 1:31 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Is a time zone user preference available?



Hi, 

Just to recap: LDAP authentication works, the SSO piece (the automatic
logon into the interface) fails. 

on my RT 3.8.8, the only Way to have SSO working is to use firefox (wich writes 
the cookie corerctly) 
I've not been able to have Internet Explorer write the cookie, so i'm using 
firefox 4.0. 

Raphaël


#
 Ce courriel et les documents qui lui sont joints peuvent contenir des
informations confidentielles ou ayant un caractère privé. S'ils ne vous sont
pas destinés, nous vous signalons qu'il est strictement interdit de les
divulguer, de les reproduire ou d'en utiliser de quelque manière que ce
soit le contenu. Si ce message vous a été transmis par erreur, merci d'en
informer l'expéditeur et de supprimer immédiatement de votre système
informatique ce courriel ainsi que tous les documents qui y sont attachés.


   **

 This e-mail and any attached documents may contain confidential or
proprietary information. If you are not the intended recipient, you are
notified that any dissemination, copying of this e-mail and any attachments
thereto or use of their contents by any means whatsoever is strictly
prohibited. If you have received this e-mail in error, please advise the
sender immediately and delete this e-mail and all attached documents
from your computer system.
#



Re: [rt-users] Is a time zone user preference available?

2011-05-04 Thread Eli Guzman

Original Message
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin
Falcone Sent: Tuesday, May 03, 2011 9:20 AM To:
rt-users@lists.bestpractical.com Subject: Re: [rt-users] Is a time zone
user preference available? 

 Thanks once again for all of the input, IE is indeed the primary
 browser here, but we do have users using Mozilla Firefox 4 as well. I
 have tried logging in within FF4, and I get the same errors as I do
 in 
 IE. I think that there is some basic link not taking place between
 IE(FF4) and RT (RT::Auth*), which is interesting (or rather odd)
 since 
 as I mentioned before, I am able to login using LDAP directly (though
 unable I may be of passing the SSO check itself). I read on a
 previous 
 message that
 RT::Auth* was now at 0.08_02 (not sure if this is correct)? Perhaps I
 should use this version with RT 3.89 and see if this fixes the issue.
 
 You mentioned mod_auth_kerb, and I actually do have mod_auth_kerb
 installed for Apache2, so I'm thinking this could be another likely
 way to go (would this work for FF4 as well?). I've also used Likewise
 Open to physically join the server to our primary domain controller,
 but this has not made much of a difference (yet) - although I am sure
 that a separate connector has to probably be setup within Likewise
 for 
 RT (but I am at the moment not familiar with this option). As another
 feasible option for SSO, would it be better to just use an AD
 synchronized OpenLDAP server, using something like a DBI
 Authentication module? 
 
 RT::Authen::ExternalAuth does not provide transparent SSO using
 spnego What you're seeing in the logs is the support for cookie based
 SSO  
 
 If you want to tie IE or a kerberized FF to an AD server using
 windows SSO, you want mod_auth_kerb 
 
 -kevin


Thanks for the reply Kevin, I am looking at configuring mod-auth-kerb.
Should I yield any positive results, I'll make sure to post a follow up
to the list.

--Eli


Re: [rt-users] Reuse RT System Saved Searches for all users

2011-05-04 Thread Kenneth Crocker
Lars,

All searches are saved based on two things; personal and group membership.
Therefore, I give all the search rights (See, Create, Load, etc.) to all
privileged users, GLOBALLY. Reason, you can only see a search that either
you own or for a group you are a member of. Granting those search rights
globally does NOT give anyone the right to see some search they shouldn't.
That is always dependant on the groups you are a member of. This saves a LOT
of time when setting up.maintaining rights.

As Raed explained, simply create a group with all the user you want to see a
set of searches and put the users in that group.

Kenn
LBNL

On Wed, May 4, 2011 at 3:43 AM, Lars Reimann l.reim...@metaways.de wrote:

 Hi,

 we stored a saved search (Tickets) in RT System's saved searches with the
 intention to make the search visible to all users.

 However,

 normal users cannot even see saved searches. We do require users to load
 them only and i gave the showsavedsearch and loadsavedsearch to every one.

 It is not clear to me which access rights are needed to enable users to see
 those system searches.

 If this is not possible via RT System's saved searches, how do I make
 searches available to all users?
 Otherwise every user has to save his/her own identical query which is
 impractical and most of our users do not want to understand detailed search
 semantics.

 greetings,
 l.r.




[rt-users] Change FriendlyFromLineFormat to include name of responder instead of queue name

2011-05-04 Thread Lars Braeuer
Hello,

here's another fix we implemented, in order to change the friendly from line 
format. I'd be
interessted, if there is a better solution for that?

In RT_SiteConfig.pm we have:

Set($FriendlyFromLineFormat , \My Company %s\ %s);

When sending a mail from queue Incidents this results in the from line:
'My Company Incidents queue-mail-address'

Instead of the queue name we would like to replace the first %s with the name 
of the person
answering the request, resulting in 'My Company John Doe 
queue-mail-address'.

Until now we are using another patch for that:

--- lib/RT/Action/Autoreply.pm.orig 2011-05-02 21:47:49.0 +0200
+++ lib/RT/Action/Autoreply.pm  2011-05-04 17:08:48.0 +0200
@@ -97,7 +97,7 @@
 my $friendly_name;

if (RT-Config-Get('UseFriendlyFromLine')) {
-   $friendly_name = $self-TicketObj-QueueObj-Description ||
+   $friendly_name = $self-TransactionObj-CreatorObj-RealName ||
$self-TicketObj-QueueObj-Name;
}

Is there an easier way to achieve this without patching the code?

If not, could you introduce a new variable like $FriendlyFromLineName to enable 
user to pick which
variable to use out of a few selected ones?

Best regards,

Lars


Re: [rt-users] Messages to AdminCCs , as Cc not Bcc

2011-05-04 Thread Matteo Sgalaberni
On Wed, May 04, 2011 at 12:42:00PM -0400, Kevin Falcone wrote:
 
 Modifying Notify is changing the source code.
 The best way might be to make a new Action based on Notify with your
 modifications as a local customization
No one in the list have implemented this or suggest what to do in some
official way?

Can be that peoples that are asking this (like me) have misunderstood
the meaning of the AdminCC notification?

For example:

if I have an RT opened that explain a customer problem:

Requestor: customer
Cc: customercollegue
AdminCc: internal peoples that are involved in the resolution of the RT and 
need to be informed about all phases of the RT

When someone add a comment, every internal people should like to receive
the notification and see all the destination of that notification...no?

Does I misunderstood something?

Thanks!

Matteo



Re: [rt-users] Messages to AdminCCs , as Cc not Bcc

2011-05-04 Thread Kevin Falcone
On Wed, May 04, 2011 at 07:39:59PM +0200, Matteo Sgalaberni wrote:
 On Wed, May 04, 2011 at 12:42:00PM -0400, Kevin Falcone wrote:
  
  Modifying Notify is changing the source code.
  The best way might be to make a new Action based on Notify with your
  modifications as a local customization
 No one in the list have implemented this or suggest what to do in some
 official way?
 
 Can be that peoples that are asking this (like me) have misunderstood
 the meaning of the AdminCC notification?

I believe your original question was how to make AdminCc a CC not a Bcc

 Requestor: customer
 Cc: customercollegue
 AdminCc: internal peoples that are involved in the resolution of the RT and 
 need to be informed about all phases of the RT
 
 When someone add a comment, every internal people should like to receive
 the notification and see all the destination of that notification...no?

This is different from that, you can use the existing
Notify Owner, Requestors, Ccs and AdminCcs
action and the email will go to everyone at once.  If you want to skip
the Owner, you'd need to add another Action to RT that only does
Requestors Ccs and AdminCcs which is a simple matter of initialdata.

Please note that this prevents you from having a different Template
for AdminCcs and for end users, which is why RT splits those into two
separate notifications by default

In general, I wouldn't want Requestors/Ccs to see me (as an AdminCc)
on a ticket email, since they'll either hit Reply-All and then I get
mail from them AND from RT or they reply directly to me, taking RT out
of the loop.  This is why AdminCcs are Bcc'ed

-kevin


pgpM0y0Yz1y4l.pgp
Description: PGP signature


[rt-users] HTTP/HTTPS bug in 4.0?

2011-05-04 Thread Dario Landazuri

Greetings,

We are running an RT instance under https only.  I just noticed a small 
issue - when you're looking at a ticket, the links for a requestor's 
other tickets are non-https (http://...).  On our system, that leads to 
a 404.  Other links in the ticket (creating links, last ticket 
transaction, etc) all properly go to https://...


Cheers,
Dario

--

Dario Landazurida...@astro.as.utexas.edu
Systems Administrator (512) 471-3334
McDonald Observatory




smime.p7s
Description: S/MIME Cryptographic Signature


Re: [rt-users] HTTP/HTTPS bug in 4.0?

2011-05-04 Thread Alex Vandiver
On Wed, 2011-05-04 at 14:27 -0500, Dario Landazuri wrote:
 We are running an RT instance under https only.  I just noticed a small 
 issue - when you're looking at a ticket, the links for a requestor's 
 other tickets are non-https (http://...).  On our system, that leads to 
 a 404.  Other links in the ticket (creating links, last ticket 
 transaction, etc) all properly go to https://...

This does look to be a bug; I'll bounce your mail into the
issues.bestpractical.com to track it.
 - Alex



Re: [rt-users] HTTP/HTTPS bug in 4.0?

2011-05-04 Thread Stoned Elipot
Hi,

On Wed, May 4, 2011 at 9:49 PM, Alex Vandiver ale...@bestpractical.com wrote:
 On Wed, 2011-05-04 at 14:27 -0500, Dario Landazuri wrote:
 We are running an RT instance under https only.  I just noticed a small
 issue - when you're looking at a ticket, the links for a requestor's
 other tickets are non-https (http://...).  On our system, that leads to
 a 404.  Other links in the ticket (creating links, last ticket
 transaction, etc) all properly go to https://...

 This does look to be a bug; I'll bounce your mail into the
 issues.bestpractical.com to track it.
  - Alex

Playing around with a 4.0.0 test clone of a 3.8.10 RT instance I noticed
the same thing, both for the requestor's other tickets links and for
the related tickets links.
Then I noticed that the 3.8.10 instance also exhibits the same
behaviour, only it was
masqueraded by the web server doing HTTP to HTTPS redirection :-}

Cheers, Stoned.


Re: [rt-users] HTTP/HTTPS bug in 4.0?

2011-05-04 Thread Lars Braeuer
Hi,

are you talking about the More about the requestors section when viewing a 
ticket?

Our RT 4.0.0 test instance runs on https, but all the links (i.e. 10 most 
important active tickets)
are https, just as expected.

Lars

Am 04.05.2011 23:06, schrieb Stoned Elipot:
 Hi,
 
 On Wed, May 4, 2011 at 9:49 PM, Alex Vandiver ale...@bestpractical.com 
 wrote:
 On Wed, 2011-05-04 at 14:27 -0500, Dario Landazuri wrote:
 We are running an RT instance under https only.  I just noticed a small
 issue - when you're looking at a ticket, the links for a requestor's
 other tickets are non-https (http://...).  On our system, that leads to
 a 404.  Other links in the ticket (creating links, last ticket
 transaction, etc) all properly go to https://...

 This does look to be a bug; I'll bounce your mail into the
 issues.bestpractical.com to track it.
  - Alex
 
 Playing around with a 4.0.0 test clone of a 3.8.10 RT instance I noticed
 the same thing, both for the requestor's other tickets links and for
 the related tickets links.
 Then I noticed that the 3.8.10 instance also exhibits the same
 behaviour, only it was
 masqueraded by the web server doing HTTP to HTTPS redirection :-}
 
 Cheers, Stoned.
 


[rt-users] rt-shredder issues

2011-05-04 Thread Mike W



Since upgrading to 3.8.10 I've been having a problem with rt-shredder. 
It claims Tickets plugin doesn't exist but when you run help for it it 
shows it in the list.



../sbin/rt-shredder --plugin help-Tickets Couldn't find 
plugin 'Tickets'

Plugins list:
Objects
Users
Attachments
Summary
Tickets
SQLDump
---
This is the full command I normally run:

../sbin/rt-shredder --force --plugin 'Tickets=query,Status=deleted AND 
LastUpdated  14 days ago;limit,100'


when I run list is shows this:

 ../sbin/rt-shredder --plugin list
Plugins list:
Objects
Users
Attachments
Summary
Tickets
SQLDump


Which seems odd because Tickets does infact exist. Any thoughts?

--

Mike Wilson



[rt-users] Linking to RT from MS Excel

2011-05-04 Thread Yan Seiner

I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket. 
I've tried the hyperlink function and also a directl link; no matter
what I do RT only goes to the home page.

Hyperlinking directly to a ticket seems to work otherwise.  Is there
something particular about excel that makes it break?  Does anyone know
where to look?

-- 
If you have eight hours to chop down a tree
spend six sharpening your axe.
--Abraham Lincoln



Re: [rt-users] Linking to RT from MS Excel

2011-05-04 Thread Yan Seiner

On Wed, May 4, 2011 3:48 pm, Yan Seiner wrote:

 I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket.
 I've tried the hyperlink function and also a directl link; no matter
 what I do RT only goes to the home page.

 Hyperlinking directly to a ticket seems to work otherwise.  Is there
 something particular about excel that makes it break?  Does anyone know
 where to look?

Here's the apache logs of the exchange:

140.211.84.66 - - [04/May/2011:16:06:26 -0700] GET
/Ticket/Display.html?id=9 HTTP/1.1 302 439 - Mozilla/4.0 (compatible;
MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR
3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDS; .NET4.0C;
InfoPath.2)
140.211.84.66 - - [04/May/2011:16:06:28 -0700] GET
/NoAuth/Login.html?next=e7071bf98bd712fceaa850abf5cc00e6 HTTP/1.1 200
5559 - Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0;
SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media
Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)
140.211.84.66 - - [04/May/2011:16:06:31 -0700] GET
/Ticket/Display.html?id=9 HTTP/1.1 302 439 - Mozilla/4.0 (compatible;
MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR
3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDS; .NET4.0C;
InfoPath.2)
140.211.84.66 - - [04/May/2011:16:06:32 -0700] GET
/NoAuth/Login.html?next=f6e5ec0408aa263848c49978088df779 HTTP/1.1 200
5559 - Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0;
SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media
Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)
140.211.84.66 - - [04/May/2011:16:06:35 -0700] GET
/NoAuth/Login.html?next=f6e5ec0408aa263848c49978088df779 HTTP/1.1 302 384
- Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)
140.211.84.66 - - [04/May/2011:16:06:36 -0700] GET / HTTP/1.1 200 38925
- Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)



Anyone have any clue what's going on?

It looks like a failed login, but the user is logged in on the machine,
and RT opens up on the user's dashboard.

This is repeatable on both my home server and on the Gossamer hosted
installation we have.

-- 
If you have eight hours to chop down a tree
spend six sharpening your axe.
--Abraham Lincoln



Re: [rt-users] Linking to RT from MS Excel

2011-05-04 Thread Lai Zit Seng
On May 5, 2011, at 7:10 AM, Yan Seiner wrote:

 On Wed, May 4, 2011 3:48 pm, Yan Seiner wrote:
 
 I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket.
 I've tried the hyperlink function and also a directl link; no matter
 what I do RT only goes to the home page.
 
 Hyperlinking directly to a ticket seems to work otherwise.  Is there
 something particular about excel that makes it break?  Does anyone know
 where to look?
 
 Here's the apache logs of the exchange:

snipped

 Anyone have any clue what's going on?
 
 It looks like a failed login, but the user is logged in on the machine,
 and RT opens up on the user's dashboard.

I've encountered similar problems with other sort of websites if hyperlinked 
from Office (not necessarily Excel, but also Word and PowerPoint). It's very 
irritating. I understand the issue is that Office programs will make an initial 
web request NOT using your favourite web browser, where it does not have the 
correct login credentials (or cookies of a pre-existing logged in session), and 
thus ends up with the wrong web content. If that initial web request results in 
a HTTP 403 error (forbidden), the Office program will just pop-up an error 
dialog without even launching the browser (this happens on my Drupal website).

I would love to know if there's a solution to this too.

Regards,

.lzs

[rt-users] Linking to RT from MS Excel

2011-05-04 Thread Payam Poursaied
Install firefox and set it as your default browser, then check if the
problem get solved or not. I think I had experienced the same thing
before with ms IE

On Thursday, May 5, 2011, Yan Seiner y...@seiner.com wrote:

 On Wed, May 4, 2011 3:48 pm, Yan Seiner wrote:

 I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket.
 I've tried the hyperlink function and also a directl link; no matter
 what I do RT only goes to the home page.

 Hyperlinking directly to a ticket seems to work otherwise.  Is there
 something particular about excel that makes it break?  Does anyone know
 where to look?

 Here's the apache logs of the exchange:

 140.211.84.66 - - [04/May/2011:16:06:26 -0700] GET
 /Ticket/Display.html?id=9 HTTP/1.1 302 439 - Mozilla/4.0 (compatible;
 MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR
 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDS; .NET4.0C;
 InfoPath.2)
 140.211.84.66 - - [04/May/2011:16:06:28 -0700] GET
 /NoAuth/Login.html?next=e7071bf98bd712fceaa850abf5cc00e6 HTTP/1.1 200
 5559 - Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0;
 SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media
 Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)
)




 Anyone have any clue what's going on?

 It looks like a failed login, but the user is logged in on the machine,
 and RT opens up on the user's dashboard.



Re: [rt-users] HTTP/HTTPS bug in 4.0?

2011-05-04 Thread Ruslan Zakirov
Check rt config through the web UI.

Regards, Ruslan. From phone.
05.05.2011 3:56 пользователь Lars Braeuer l...@mpexnet.de написал:
 Hi,

 are you talking about the More about the requestors section when viewing
a ticket?

 Our RT 4.0.0 test instance runs on https, but all the links (i.e. 10 most
important active tickets)
 are https, just as expected.

 Lars

 Am 04.05.2011 23:06, schrieb Stoned Elipot:
 Hi,

 On Wed, May 4, 2011 at 9:49 PM, Alex Vandiver ale...@bestpractical.com
wrote:
 On Wed, 2011-05-04 at 14:27 -0500, Dario Landazuri wrote:
 We are running an RT instance under https only. I just noticed a small
 issue - when you're looking at a ticket, the links for a requestor's
 other tickets are non-https (http://...). On our system, that leads to
 a 404. Other links in the ticket (creating links, last ticket
 transaction, etc) all properly go to https://...

 This does look to be a bug; I'll bounce your mail into the
 issues.bestpractical.com to track it.
 - Alex

 Playing around with a 4.0.0 test clone of a 3.8.10 RT instance I noticed
 the same thing, both for the requestor's other tickets links and for
 the related tickets links.
 Then I noticed that the 3.8.10 instance also exhibits the same
 behaviour, only it was
 masqueraded by the web server doing HTTP to HTTPS redirection :-}

 Cheers, Stoned.



Re: [rt-users] Messages to AdminCCs , as Cc not Bcc

2011-05-04 Thread Ruslan Zakirov
Originally requested feature is implemented in 3.999 branch, but nobody
ported it into 4.x.

Regards, Ruslan. From phone.
04.05.2011 23:40 пользователь Matteo Sgalaberni sg...@sgala.com написал:
 On Wed, May 04, 2011 at 12:42:00PM -0400, Kevin Falcone wrote:

 Modifying Notify is changing the source code.
 The best way might be to make a new Action based on Notify with your
 modifications as a local customization
 No one in the list have implemented this or suggest what to do in some
 official way?

 Can be that peoples that are asking this (like me) have misunderstood
 the meaning of the AdminCC notification?

 For example:

 if I have an RT opened that explain a customer problem:

 Requestor: customer
 Cc: customercollegue
 AdminCc: internal peoples that are involved in the resolution of the RT
and need to be informed about all phases of the RT

 When someone add a comment, every internal people should like to receive
 the notification and see all the destination of that notification...no?

 Does I misunderstood something?

 Thanks!

 Matteo



Re: [rt-users] Messages to AdminCCs , as Cc not Bcc

2011-05-04 Thread Matteo Sgalaberni
On Wed, May 04, 2011 at 02:02:17PM -0400, Kevin Falcone wrote:
 Please note that this prevents you from having a different Template
 for AdminCcs and for end users, which is why RT splits those into two
 separate notifications by default
 
 In general, I wouldn't want Requestors/Ccs to see me (as an AdminCc)
 on a ticket email, since they'll either hit Reply-All and then I get
 mail from them AND from RT or they reply directly to me, taking RT out
 of the loop.  This is why AdminCcs are Bcc'ed
Ok I completely agree with you. Follow my point of view:

You also say:

RT splits those into two separate notifications by default. So the
notifications that are sent to AdminCC have a different template and have
as destination only AdminCCs. I remember this in my latest tests.

So, this notification should be sent not in BCC as all destinations are AdminCC
and they know each other.

What do you think? 

Thanks

Matteo