[rt-users] Question about Command By Mail - Something is not right :/

2008-03-19 Thread Greg Evans
Hi there, just a quick question regarding the 'command by mail' extension. I am working with someone offsite that is using a non-RT ticketing system and they currently send email to us for certain tickets. We are trying to ensure that all tickets go into our ticketing system so I am

Re: [rt-users] Question about Command By Mail - Something is not right :/

2008-03-19 Thread Greg Evans
Here is a bit more info from my /var/log/httpd/error_log [Tue Mar 18 17:33:30 2008] [error]: Couldn't create ticket from message with commands, fallback to standard mailgate. Error: Invalid value for status (/opt/rt3/local/lib/RT/Interface/Email/ Filter/TakeAction.pm:504) [Tue Mar 18

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Mathew
The vast amount of data could be due to spam. I set up a script which regularly (daily) searches for spam and the users automatically created by it. It then runs Shredder on the list I built. This is made easier by creating a spam only queue into which all incoming spam is placed.

[rt-users] zabbix RT

2008-03-19 Thread Toth Milan
Hi to all, i'm using Zabbix for a while now and i'm looking for some perl script which will be called from zabbix when trigger come true or false and place a ticket directly to queue. I'm runnig RT3 and Zabbix on the same machine. Thanks in advance. -- Toth Milan [EMAIL

Re: [rt-users] New install, weird layount (CSS?)

2008-03-19 Thread Drew Barnes
In RT_SiteConfig.pm you can change it back by using Set($WebDefaultStylesheet, '3.4-compat'); Chaim Rieger wrote: Grant Christensen wrote: I was comparing to: http://www.bestpractical.com/images/screenshots/rt/3.0/home.gif nope, thats the old one you is all good

Re: [rt-users] zabbix RT

2008-03-19 Thread Drew Barnes
There are some scrips and templates on the wiki that work with nagios messages. You could probbaly adapt them for Zabbix. http://wiki.bestpractical.com/view/AutoCloseOnNagiosRecoveryMessages http://wiki.bestpractical.com/view/SendNagiosAlert Toth Milan wrote: Hi to all, i'm

Re: [rt-users] zabbix RT

2008-03-19 Thread Charles Trevor
Toth Milan wrote: Hi to all, i'm using Zabbix for a while now and i'm looking for some perl script which will be called from zabbix when trigger come true or false and place a ticket directly to queue. I'm runnig RT3 and Zabbix on the same machine. Thanks in advance.

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Richard Ellis
Hi Ruslan, here's the two sets of results. Thanks Richard Ruslan Zakirov wrote: Ok, I have an idea how to fix that problem Here is new file for testing that will give me more info to find the best way to fixing this. We're really close. You can run it using: mysql -t -u root -ppassword

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Jesse Vincent
On Wed, Mar 19, 2008 at 04:22:46PM +, Richard Ellis wrote: Hi Ruslan, here's the two sets of results. FWIW, from your response to ruslan, it _does_ look like your hand-added group1 index was messing up the query planner. It's on GroupId, while we already had an index on GroupId,

Re: [rt-users] SOT: high performance web cache for RT

2008-03-19 Thread Joe Casadonte
On 3/6/2008 7:37 AM, Matthew Seaman wrote: Sven Sternberger wrote: I found a very interesting software project, which boost my RT test instance. http://varnish.projects.linpro.no/ due to the nature of cache systems it is not working with https traffic, but nevertheless It could be

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Richard Ellis
Hi Jesse, Thanks. To the best of my knowledge nobody has added any indexes to the database on anything except what RT patches apply on each upgrade. This DB was originally 3.0 and has been upgraded more times than I want to think about over the years to 3.6.6 now :) Richard Jesse Vincent

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Jesse Vincent
On Wed, Mar 19, 2008 at 04:38:12PM +, Richard Ellis wrote: Hi Jesse, Thanks. To the best of my knowledge nobody has added any indexes to the database on anything except what RT patches apply on each upgrade. This DB was originally 3.0 and has been upgraded more times than I want to

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Ruslan Zakirov
Jesse, I know that they both have index on CachedGroupMembers table that starts from 'MemberId' column. And it does mess up optimizer and doesn't matter if it's one column or multiple like in (MemberId, GroupId, Disabled) index (Jeff created such thing). We really need such index in the core on

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Jesse Vincent
On Wed, Mar 19, 2008 at 07:42:30PM +0300, Ruslan Zakirov wrote: Jesse, I know that they both have index on CachedGroupMembers table that starts from 'MemberId' column. And it does mess up optimizer and doesn't matter if it's one column or multiple like in (MemberId, GroupId, Disabled) index

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Ruslan Zakirov
Hey, Rechard, the latest results suggest me that we've saddled this beast :) at least that what explain says and I hope it's correct. You can check that query again and it should be fast. Wanna try? You can use SELECT SQL_NO_CACHE ... to make sure it's reproducible and is not cache hit. On

Re: [rt-users] SOT: high performance web cache for RT

2008-03-19 Thread Vivek Khera
On Mar 19, 2008, at 12:30 PM, Joe Casadonte wrote: Following up on a thread from a couple of weeks ago. I'm curious as to how something like Varnish can help with what is, essentially, dynamically-generated content? It won't, unless you have a public view that gives the same view to

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Ruslan Zakirov
Jeff, always Cc the list. Version of your mysql server? As far as I can see you suffer from mysql bug, output from your server is equal in both cases what is really wrong and mysql must use new index in those test queries I sent to the list. There are several options: 1) Delete any indexes on

Re: [rt-users] SOT: high performance web cache for RT

2008-03-19 Thread Jesse Vincent
how something like Varnish can help with what is, essentially, dynamically-generated content? It will also help for serving up the static content (image, style sheets), provided you've configured apache to serve those up outside of the mason code. However there is so little of this

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Richard Ellis
Hi Ruslan, You are a genius. Response time for the Query Builder is now back to 4 seconds which is good enough for me :0. Thanks to all your team for all the efforts to work out what was wrong. Thanks Richard Ruslan Zakirov wrote: Hey, Rechard, the latest results suggest me that we've

Re: [rt-users] RT 3.6.4 poor query performance

2008-03-19 Thread Jeff Voskamp
Ruslan Zakirov wrote: Jeff, always Cc the list. Version of your mysql server? As far as I can see you suffer from mysql bug, output from your server is equal in both cases what is really wrong and mysql must use new index in those test queries I sent to the list. There are several

[rt-users] RT 3.6.5 LDAP authentication and Active Directory

2008-03-19 Thread Kevin Sheen
Hi, I'm trying to get our rt install to authenticate with Active Directory. I've got the configuration from these two links into our RT_SiteConfig.pm: http://wiki.bestpractical.com/view/LDAP http://wiki.bestpractical.com/view/LdapSiteConfigSettingsForActiveDirectory At this point, I'm just

Re: [rt-users] RT 3.6.5 LDAP authentication and Active Directory

2008-03-19 Thread Kevin Sheen
I think I got it to work, changed LdapFilter to * rather than just commenting the line out. I knew we didn't have posixAccount in that attribute but didn't know I would actually need it enabled. sorry for the wasted bandwidth, Kevin At 02:19 PM 3/19/2008, Kevin Sheen wrote: Hi, I'm trying

[rt-users] Mysql problems with our RT system

2008-03-19 Thread Musolino, Peter
Did anyone ever figure this out? I am having the same problem. At first I had the regular password style: DBI connect('dbname=rt3;host=localhost','rt',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at

Re: [rt-users] SOT: high performance web cache for RT

2008-03-19 Thread Matthew Seaman
Joe Casadonte wrote: On 3/6/2008 7:37 AM, Matthew Seaman wrote: Sven Sternberger wrote: I found a very interesting software project, which boost my RT test instance. http://varnish.projects.linpro.no/ due to the nature of cache systems it is not working with https traffic, but