Re: [rt-users] rt-shredder - quicker method?

2009-06-29 Thread Simon Jester
Ruslan Zakirov ruslan.zakirov at gmail.com writes:

 
 Hello,
 
 In additon to indexes described in shredder documentation people
 suggested index on Via column in CachedGroupMembers table and said
 that it improves performance amazingly.
 

Has anyone else noticed a marked delay in the Query Builder search page after
adding the recommended indexes?  Where it used to display in less than ~5
seconds, it's now averaging ~16 seconds.  

What have I managed to break, now?

Simon



___
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.6 Change look and feel of customized fields

2009-02-26 Thread Simon Jester
Eggers, Ken F. keggers at mitre.org writes:

 Can the fields look and feel as displayed in the browser be
 altered (see how much I am a novice!)??
 

 Not looking to major radical changes, just some simple
 sizing to allow text in the field to display completely.

 
 Ken
 

I created local EditCustomFields  in /opt/rt3/local/html/Elements/ which changed
the $Rows  $Columns values to 5 and 75, respectively. 

Now the boxes are large enough that my users aren't complaining.  :)


sklutch

___
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] Possible dumb question...be warned

2008-10-01 Thread Simon Jester
Is there a limitation on the number of queues that can be created?


sklutch

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

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


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


Re: [rt-users] Possible dumb question...be warned

2008-10-01 Thread Simon Jester
Gabriel Cadieux gcadieux at securetechnologies.ca writes:

 
 depends, is that you or management asking? LOL :)
 
 (real answer: i have no idea, but probably, yes. and the number is most
 likely gargantuan for realistic purposes.)
 

I had my previous programmer tell me that there was a limitation on the 
number of queues that could be created, because of programmatic reasons.

I was busy with 3 other projects and just took his word for it...but later
my brain said it was all just table data and databases can have silly levels
of table data.

Just looking for verification before I create a whole slew of new queues.

Yes, at the request of mgmt.  :)


sklutch

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

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


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


Re: [rt-users] Possible dumb question...be warned

2008-10-01 Thread Simon Jester
Kenneth Crocker KFCrocker at lbl.gov writes:

 What is your customer base or service?
 
 Kenn
 LBNL
 


Heh, I only have to support a gang of 30, at present.  In future, might even go
up to 60 people.

sklutch

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

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


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


[rt-users] Anyone using SSL-encrypted backend mysql calls?

2008-09-30 Thread simon jester
Due to circumstances beyond my control (mgmt), my RT instances will be moved 
from their present isolated network into the mainstream with other corporate 
devices. As I don't want any sniffers that *might* exist on the wire to inspect 
my traffic to/from the database servers, I'm looking at using the SSL 
encryption feature...but I don't know what incantations need to be used for the 
front-end RT instance to successfully communicate.

If this is explained in a FAQ or manual somewhere, please point me to it.

Thanks, in advance...


sklutch

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

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


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


Re: [rt-users] Anyone using SSL-encrypted backend mysql calls?

2008-09-30 Thread Simon Jester
David Chandek-Stark david.chandek.stark at duke.edu writes:

 
 
 How about stunnel?
 --David

I've been asked not to use custom software solutions in our corporate
environment. *sigh*


sklutch

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

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


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


Re: [rt-users] Anyone using SSL-encrypted backend mysql calls?

2008-09-30 Thread Simon Jester

Gabriel Cadieux gcadieux at securetechnologies.ca writes:
 OpenSSL is far from what i'd call a custom software solution lol

 push management a little, sometimes they actually give in :)
 -gabe

If it isn't in the begin corpspeak Known support lexicon /end corpspeak,
then it's a custom solution and requires singing/dancing/alms/blood to
implement.  Otoh, if I use an existing capability of the MySQL server and a
(hopefully) simple modification to RT it doesn't register on the not from
around here meter.

wierd breaks are for my posting client's requirements

sklutch


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

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


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


Re: [rt-users] Anyone using SSL-encrypted backend mysql calls?

2008-09-30 Thread Simon Jester
Matt Simerson matt at corp.spry.com writes:

 
 
 Do NOT use mysql SSL in a production environment.



Well, that's emphatic enough...guess that means it's forgiveness vs
permission time. :)

sklutch

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

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


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


Re: [rt-users] Changing Password for user

2008-05-21 Thread Simon Jester
IT GUY itinfoguy at gmail.com writes:

 
 
 I searched but I didn't find any option ModifySelf in RT  3.6.5. I think I 
have to prepare for an upgrade.

Admin user:  Configuration-Global-Group/User Rights.

I've set my Privileged Users to be able to ModifySelf so they can keep their 
personal data up-to-date, as well.

sklutch



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

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


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

[rt-users] Custom Fields containing HTML being rendered?!

2008-04-21 Thread Simon Jester
Hello everyone!

I recently began the process of switching over my users from a 3.6.3 RT 
frontend to a 3.6.5 frontend and discovered something that surprised me.

If I copy/paste in a packet which contains HTML, RT does it's best to render 
this data when displaying the contents of the custom field.  That doesn't 
happen in the 3.6.3 code, so something has been tweaked that I need to un-
tweak.  :)


Doing a straight diff comparison of the Display.htm files shows that the code 
for that file was reorg'd past the point of my admittedly poor python/perl 
skills.

Is this behavior intentional?


sklutch

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

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


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


Re: [rt-users] Editing ShowCustomFields file to maintain Cu stom Field value formatting

2008-03-05 Thread Simon Jester
Simon Jester sklutch at hostile.org writes:

Okay, issue resolved. One of the programmers here pointed out that I'd picked 
the wrong place for the insertion and showed me were it *should* go.

Much thanks to everyone who responded off-list (Todd Chapman, Joe Casadonte) 
for their assistance.

Sorry, Todd, but CallBacks have always been my nemesis. I don't recall having 
gotten a single one to work for me, ever...

Thanks, Joe, but I got your email after my programmer had already laughed at me 
and tweaked the file...

I still love RT and the fact that I *can* customize it, I just wish I had my 
Perl-wings/Mason-fins and could cleanly dive in and customize with abandon.

Now, on to the next emergency/fire...


sklutch


Begin snippet/diff code

   i|/l(no value)//i
   % } elsif ( $count == 1 ) {
   pre  ---Added
   %   $print_value-( $CustomField, $Values-First );
   /pre ---Added
   % } else {
   ul
   % while ( my $Value = $Values-Next ) {

   diff results for file:

   57a58
   pre
   58a60
   /pre

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

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


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


[rt-users] Editing ShowCustomFields file to maintain Custom Field value formatting

2008-03-04 Thread Simon Jester
Morning, everyone!

Long time lurker (with occasional stupid questions) running into an issue with 
a customization to ShowCustomFields file.

In 3.6.1, I edited the ShowCustomfields file to inject a pre/pre statement 
just inside the li blocks. This took care of an issue in which the carriage 
returns in the custom field value were being stripped on display by the 
browsers. (Interestingly enough, the returns were in the page source but were 
stripped on display). This worked for some time and all was happy. 

Now, I'm deploying replacement hardware (beefy!) and taking the opportunity to 
bump my installation to 3.6.5 and I'm stymied by the changes made to the 
ShowCustomFields file in which the code block that was present in 3.6.1 was 
moved to a subroutine and updated. If I use the same logic and insert my 
pre/pre statement just inside the li block, it just gets ignored and the 
custom fields are a jumble of text.

What up with that?  Can someone point me to the proper place/method to insert 
these statements?  Or is there a better way that I've completely missed in my 
zeal to edit source files?  :)

sklutch

3.6.1 file changes
% while (my $Value = $Values-Next()) {
li
   pre  ---Added
% if ($CustomField-LinkValueTo) {
a href=%$Value-LinkValueTo|n% target=_new
% }
(...)
script!--
ahah('%$Value-IncludeContentForValue%', 'object_cf_value_%
$Value-id%');
--/script
% }
   /pre ---Added
/li



3.6.5 Unsuccessful file changes
ul
% while ( my $Value = $Values-Next ) {
li
 pre  ---Added
% $print_value-( $CustomField, $Value );
 /pre ---Added
/li
% }
/ul




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

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


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