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
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
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/" Order allow,deny Allow from all Options +ExecCGI AddHandler fcgid-script fcgi # 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 Now apache gives me error : fb>failed 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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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?
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" 02/05/2011 20:06 A Raphaël MOUNEYRES , 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?
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
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 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
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" ' 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" '. 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
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
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?
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?
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?
Hi, On Wed, May 4, 2011 at 9:49 PM, Alex Vandiver 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?
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 > 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
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
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
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
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: > 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
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 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?
Check rt config through the web UI. Regards, Ruslan. From phone. 05.05.2011 3:56 пользователь "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 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
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" написал: > 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
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
Re: [rt-users] RT 4.0 with fcgid
Hello Thomas Sorry my fault Okay, Solution: Give the RT Log File more rights otherwise RT 4.0 won't work 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. in my feeling i think everyone is more slowly than with modperl -The reload takes longer - The navigation in the menuetree - Waiting for processsing to create a ticket and so on.. best regards john s. -- View this message in context: http://old.nabble.com/RT-4.0-with-fcgid-tp31532665p31547911.html Sent from the Request Tracker - User mailing list archive at Nabble.com.