Re: [rt-users] Slow Query Log

2008-08-07 Thread Jesse Vincent
On Aug 7, 2008, at 6:37 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED] > wrote: > I'm using RT 3.8 and Mysql 5.0.51a on Fedora Core 9. > > I've been noticing some slowness using the interface. Most of the > time it is when updating tickets. Reviewing the slow query log I > found the following

[rt-users] RTx::Shredder performance improvement (by adding new index)

2008-08-07 Thread drewday
In the process of investigating the performance of using Shredder to delete tickets, I found an index that seems to have a considerable improvement on performance, even above the indexes that are suggested in the documentation. I simply added: CREATE INDEX SHREDDER_CGM3 ON CachedGroupMembers(Va

[rt-users] Slow Query Log

2008-08-07 Thread zbigniew
I'm using RT 3.8 and Mysql 5.0.51a on Fedora Core 9. I've been noticing some slowness using the interface. Most of the time it is when updating tickets. Reviewing the slow query log I found the following. Out of a total of 53133 log entries there where 14369 entries for SELECT count(main.id) F

Re: [rt-users] RT at a Glance HASH ref error during upgrade from 3.4 to 3.8

2008-08-07 Thread Ruslan Zakirov
Hm, interesting... Sounds like some problem with serialization. We use Storable module to serialize data, it worth try either upgrade or downgrade. Please don't forget to remember the current installed version, so we can bump dependencies if problem is in this module. Install new or older version

Re: [rt-users] RT at a Glance HASH ref error during upgrade from 3.4 to 3.8

2008-08-07 Thread Larry Han
Actually, I don't think that it is a database problem. When I do a mysqladmin drop rt3; and then I do rt-setup-database --action init, the RT at a glance page still shows the same error. So I think it may be a problem with my perl or the RT install. Any suggestions? __

Re: [rt-users] [error] Can't call method "crit"

2008-08-07 Thread Ruslan Zakirov
I see the following in one of your previous messages: [Thu Jul 31 23:19:04 2008] [crit]: Plugin Extension-QuickDelete not found in /opt/rt3/local/plugins (/var/www/rt-3.8.0/sbin/../lib/RT.pm:579) [Thu Jul 31 23:19:04 2008] [crit]: Can't locate Extension-QuickDelete.pm in RT tries to load a plugin

Re: [rt-users] Minor Edit to Interface/Email.pm

2008-08-07 Thread Kevin Falcone
You don't say what version you're running (probably 3.6.something) It would be helpful if you sent a patch (you can download a fresh copy of 3.6 from http://download.bestpractical.com ) and an explanation of what bug you were seeing and how to reproduce it to [EMAIL PROTECTED] This would let us

Re: [rt-users] Installation of RTFM 2.2.1 on RT 3.8.0 fails

2008-08-07 Thread Kevin Falcone
On Aug 7, 2008, at 2:21 PM, Michael Silver wrote: > Back in July, Cameron posted a message to the list regarding an > installation problem. (See > http://lists.bestpractical.com/pipermail/rt-users/2008-July/ > 052816.html > for his message.) As far as I can tell, there wasn't a response sent >

Re: [rt-users] RT at a Glance HASH ref error during upgrade from 3.4 to 3.8

2008-08-07 Thread Larry Han
Ok, so I followed all these steps but I still have the same error on the RT at a glance page. Can't use string ("BQYDAgQCAwQDAgoKTXkg") as a HASH ref while "strict refs" in use at /var/www/tickets01/share/html/Elements/MyRT line 76, line 505. Trying to change RT at a glance pref

Re: [rt-users] Installation of RTFM 2.2.1 on RT 3.8.0 fails

2008-08-07 Thread Michael Silver
Back in July, Cameron posted a message to the list regarding an installation problem. (See http://lists.bestpractical.com/pipermail/rt-users/2008-July/052816.html for his message.) As far as I can tell, there wasn't a response sent to the list, and I had a similar problem. I'm posting this in case

Re: [rt-users] Filter::SpamAssassin

2008-08-07 Thread Erik Aronesty
Sorry I forgot the extra "s" documentroot.com/SpamAssassin.pm - Erik On Thu, Aug 7, 2008 at 5:36 AM, Erik Aronesty <[EMAIL PROTECTED]> wrote: > I made a version of Filter::SpamAssassin that works with the > latest/greatest versions of both SpamAssassin and RT. > > http://www.documentroot.com/Sp

Re: [rt-users] RT at a Glance HASH ref error during upgrade from 3.4 to 3.8

2008-08-07 Thread Larry Han
>I think the following steps should make migration for you. > >NOTE FOR READERs: this is only correct for people migrating from 4.0 >to 4.1 and newer. > >1) when you do a mysqldump you don't need additional options, as mysql >4.0 has no --set-default-charset or --set-charset options, so use: > >

[rt-users] Minor Edit to Interface/Email.pm

2008-08-07 Thread Erik Aronesty
(I don't have the original so I can't do a diff, but basically the loop variable should (always) be my'ed to protect it from being altered. There was a problem with the MailFrom plugin setting $_ and then corrupting the loop varialbe!) CUT--- # Since this needs loading, no matter what

Re: [rt-users] [error] Can't call method "crit"

2008-08-07 Thread PF IT
-Original Message- From: Ruslan Zakirov <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] [error] Can't call method "crit" Date: Fri, 1 Aug 2008 04:42:45 +0400 By default no plugins are installed and desiable @Plugins option in your con

Re: [rt-users] RT-Users Digest, Vol 53, Issue 18

2008-08-07 Thread Curtis Bruneau
> Date: Thu, 07 Aug 2008 16:50:47 +0200 > From: Jean-Michel Barbet <[EMAIL PROTECTED]> > Subject: Re: [rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0 > To: d tbsky <[EMAIL PROTECTED]> > Cc: rt-users@lists.bestpractical.com > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; chars

Re: [rt-users] Install problem using a db server on a different host

2008-08-07 Thread Michael Silver
Hello, Thank you! That solved the problem. I don't know how I missed the --with-db-rt-host variable, but I removed everything I had done (except perl modules - I'm not that stupid!) and started with the configure statement again - this time using the above variable. Everything went tickety-boo. Th

Re: [rt-users] RT version 3.8.0 and RT-Authen-ExternalAuth-0.05

2008-08-07 Thread Tim Cutts
On 7 Aug 2008, at 10:45 am, [EMAIL PROTECTED] wrote: > I know Mike Peachy hasn't had any time to look at this, but is there > anyone who's got RT-Authen-ExternalAuth working with RT 3.8.x with > LDAP (Sun Directory Service)? > I wasn't sure if RT-Authen-ExternalAuth is either totally not >

Re: [rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0

2008-08-07 Thread d tbsky
hi: maybe your version of DBD::mysql is too old? you can try rt3.8.1rc2, the "make testdeps" will check DBD::mysql version. i got errors before upgrade my DBD::mysql, but i forgot the error message. 2008/8/7 Jean-Michel Barbet <[EMAIL PROTECTED]>: > d tbsky wrote: >> >> hi: >> your upgrade pro

[rt-users] Locking accounts on password failure

2008-08-07 Thread Justin Hayes
Has anyone implemented locking accounts after so many login attempts? I'm sure I can add it myself but if there's a solution out there already. I'm using 3.6.3 Cheers, Justin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Re: [rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0

2008-08-07 Thread Jean-Michel Barbet
d tbsky wrote: > hi: > your upgrade procedure is like what i did, which is wrong. > if you use mysql, you should run the mysql upgrade script first, > then run the rt upgrade script. or you will get empty "RT at glance" page. Thanks very much, So, trying to follow directions posted in thread : "R

Re: [rt-users] RT at a Glance HASH ref error during upgrade from 3.4 to 3.8

2008-08-07 Thread d tbsky
Hi: i think your mysql upgrade procedure is great. can you put it into document? i just read UPGRADING.mysql in rt 3.8.1rc2, it is the same as 3.8.0. so most people like me will run rt upgrade script first, then run mysql upgrade script. and get corrupt system. and you said binary copy is no

Re: [rt-users] RT version 3.8.0 and RT-Authen-ExternalAuth-0.05

2008-08-07 Thread justin
I know Mike Peachy hasn't had any time to look at this, but is there anyone who's got RT-Authen-ExternalAuth working with RT 3.8.x with LDAP (Sun Directory Service)? I wasn't sure if RT-Authen-ExternalAuth is either totally not working with 3.8.x, or working in some cases? After an upgrade fro

[rt-users] Filter::SpamAssassin

2008-08-07 Thread Erik Aronesty
I made a version of Filter::SpamAssassin that works with the latest/greatest versions of both SpamAssassin and RT. http://www.documentroot.com/SpamAssasin.pm I didn't want to muck about with fetchmail, procmail or anything else to get it to work, and the version that was out there didn't seem to