Re: [rt-users] New install rt-mailgate problem

2010-04-14 Thread Agnislav Onufrijchuk
Ian Pellew пишет: FreeBSD_8 RT 387 at a glance works fine, BUT rt-mailgate fails with the likes of:- [Tue Apr 13 17:29:13 2010] [error] [client 192.168.56.202] File does not exist: /usr/local/www/apache22/data/REST But my RT is at /usr/local/Rt/rt-3.8.7/share/html My vhost uses ports 8001:-

Re: [rt-users] New install rt-mailgate problem

2010-04-14 Thread Agnislav Onufrijchuk
You're welcome! BTW, please add --- Cc: rt-users@lists.bestpractical.com --- to correspondence to let other subscribers know the results/flow. Ian Pellew wrote: Thanks Agnislav Just the nudge I needed. I get in these loops where nothing works out of stupidity. It seems you haven't set port

[rt-users] Newbie Question

2010-04-14 Thread Brian Lawson
I've been looking at RT for a week. I just got this job and am taking over for someone who suddenly quit. I know PERL and am getting to know LINUX...I come from a UNIX background so that helps. Here's my situation: Our company has a group of customer service reps and my boss would rather

[rt-users] DisGrouMem index

2010-04-14 Thread Raed El-Hames
Hi; rt-3.8.7 mysql 5.1 Is the index DisGrouMem (GroupId,MemberId,Disabled) required for 3.8 When I did: select * from CachedGroupMembers where Disabled = 1; I got back 232 rows out of 5594612 Which in my opinion makes that index useless ? Ist required , can I drop it?? Regards; Roy

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Jesse Vincent
On Wed, Apr 14, 2010 at 02:17:10PM +0100, Raed El-Hames wrote: Hi; rt-3.8.7 mysql 5.1 Is the index DisGrouMem (GroupId,MemberId,Disabled) required for 3.8 When I did: select * from CachedGroupMembers where Disabled = 1; I got back 232 rows out of 5594612 Which in my opinion

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Kenneth Marshall
If you do not have an index, won't you need to do a sequential scan of the full table each time. With 6m entries, it could take a while. Cheers, Ken On Wed, Apr 14, 2010 at 02:17:10PM +0100, Raed El-Hames wrote: Hi; rt-3.8.7 mysql 5.1 Is the index DisGrouMem (GroupId,MemberId,Disabled)

[rt-users] Newbie log question

2010-04-14 Thread Ian Pellew
I have a fresh instalation. I look at the http_error.log and I see lines like:- [Wed Apr 14 10:28:54 2010] [info]:  rt-3.8.7-941-1271240934-272.2-...@f8:8001 #2/83 - Scrip 3  On Create Autoreply To Requestors  (/usr/local/Rt/rt-3.8.7/bin/../lib/RT/Action/SendEmail.pm:300) This must be saying

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Raed El-Hames
Jesse; Ah - In my database I do also have index GrouMem (GroupId,MemberId) on CachedGroupMembers Your reply prompted me to have a look at the source code and it seems for one reason or another I may have created this index myself based on the Oracle schema some time in the past few years.

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Kenneth Marshall
Roy, The schema that came with RT 3.8.5 has the DisGrouMem index on CachedGroupMembers and not the GrouMem index. I would drop that latter index. Regards, Ken On Wed, Apr 14, 2010 at 02:54:01PM +0100, Raed El-Hames wrote: Jesse; Ah - In my database I do also have index GrouMem

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Ian Pellew
From my experience with compound indexes (Informix), the optimiser will use the leading component of the compound, thereafter, it would force a scan of the table. The column 'disabled' is in the compound, and very likely not be the first component and hence, a forced a scan. Drop the index and

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Ruslan Zakirov
Hello Raed, In theory mysql can use the 3 element index and avoid looking at the table. If you have query that looks into X columns and all those X columns are part of an index then mysql doesn't touch table at all and completes query right from the index. For this particular tamble more than

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Raed El-Hames
Thanks to everyone reply .. I should have done a bit more research first , I had another index combining (GroupId,MemberId) that must have been added by me/some one in my organisation, and I wrongly assumed that RT created both indexes making the DisGrouMem (GroupId,MemberId,Disabled) useless.

[rt-users] template emails for custom fields

2010-04-14 Thread psminusaxl
Hi guys, I got a template that sends out an email everytime a ticket is created. It works fine as is, it has the company information and standard greeting and even the ticket number and subject of the ticket. Here's the delima though: I got a queue, say Support and under support I've created

[rt-users] homepage refresh interval under preferences

2010-04-14 Thread psminusaxl
Hi guys, I've tried setting the homepage refresh interval under preferences and save it at 2 minutes or any other value, but it does work. Odd thing is in the Main Page the Refresh option to set refresh interval works! I have tried setting the default value in RT_SiteConfig.pm to no avail and I

Re: [rt-users] template emails for custom fields

2010-04-14 Thread Raed El-Hames
Hi; You can include something like: {my $subq = $Ticket-FirstCustomFieldValue('sub queues')} In the body of the template; any where you wish 2 lines below the header lines Regards; Roy psminusaxl wrote: Hi guys, I got a template that sends out an email everytime a ticket is created.

[rt-users] problem with attached files not sent

2010-04-14 Thread Julien Rampon
Hi, Here's my problem ! First, I'm using RT 3.8.1, perl 5.8.8 and mysql 5.0.32 on a debian (etch). I use the web interface to reply to my customers tickets and I have to attach files to my replies. So I attach files with the choose file and then Add more files buttons. When I update the

Re: [rt-users] template emails for custom fields

2010-04-14 Thread psminusaxl
Thanks Roy for responding! I actually *just* figured it out. The thing that constantly threw me off is that all the thread support i've read always included that additiona ('sub queues'). I have multiple queue and I wanted to make sure that the right queue gets placed in the template. As it

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread Kevin Falcone
On Wed, Apr 14, 2010 at 08:43:32AM -0700, psminusaxl wrote: I've tried setting the homepage refresh interval under preferences and save it at 2 minutes or any other value, but it does work. Odd thing is in the Main Page the Refresh option to set refresh interval works! I have

Re: [rt-users] Dashboard by owner

2010-04-14 Thread Tyler Eaves
Ok, that helps some I guess. Sounds like I will need to create a search for each person/status though,which I'm trying to avoid. On Apr 14, 2010, at 12:18 PM, Kenneth Crocker wrote: Tyler, Well, setting up a dashboard is pretty simple, but it will do you no good if you do not know how to

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread psminusaxl
Thanks for the response Kevin, Then how does one make it so that the preference trumps the front page? From my understanding the front page refresh has to be set everytime you sign in. So it will always make the preference setting worthless. The preference setting is convient because it

Re: [rt-users] Dashboard by owner

2010-04-14 Thread Kevin Falcone
On Tue, Apr 13, 2010 at 04:52:36PM -0400, Tyler Eaves wrote: Got a request here... I'd like a dashboard I can put on the at a glance page that will show the new / open / stalled tickets per user, in the same style as the per-queue list that's there by default. I'm on 3.8.7. I assume you've

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread Kevin Falcone
On Wed, Apr 14, 2010 at 09:24:33AM -0700, psminusaxl wrote: Thanks for the response Kevin, Then how does one make it so that the preference trumps the front page? From my understanding the front page refresh has to be set everytime you sign in. So it will always make the

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread psminusaxl
Hi Kevin, Sorry the version of RT we are running is RT v3.8.4, so if the preference settings is suppose to win the next time I sign in. Then its not working. I go to preference and the settings appear to be what I've set it before 2 minutes. But at the front page it set as Do not refresh, which

Re: [rt-users] Dashboard by owner

2010-04-14 Thread Tyler Eaves
Nope, thanks, that's exactly what I was looking for! On Apr 14, 2010, at 12:33 PM, Kevin Falcone wrote: On Tue, Apr 13, 2010 at 04:52:36PM -0400, Tyler Eaves wrote: Got a request here... I'd like a dashboard I can put on the at a glance page that will show the new / open / stalled tickets

Re: [rt-users] problem with attached files not sent

2010-04-14 Thread Fritz , Jürgen
Hi, to which mail-server do you send your mails? Are there any spam-filter on the way? Did you check the mail-server-logs? Juergen -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Julien Rampon

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread psminusaxl
I went ahead and remove the front page refresh option just to take that out of the picture. And it appears the preference refresh still doesn't work. Any clues? Thanks! On Wed, Apr 14, 2010 at 9:35 AM, Kevin Falcone falc...@bestpractical.comwrote: On Wed, Apr 14, 2010 at 09:24:33AM -0700,

Re: [rt-users] problem with attached files not sent

2010-04-14 Thread Julien Rampon
Hi Juergen, The problem is worse than just a spam-filter, as some of the files are randomly omitted when uploading with the web interface : for example, if we attach five files, the interface shows perhaps 3 (in the outgoing mail) and the customer receives only these 3. However, if the customer

Re: [rt-users] problem with attached files not sent

2010-04-14 Thread Mathieu Longtin
Don't know if it's related, but there some issue with selecting the proper txt and html pair as the message body when sending emails. It will often pick up an attached text file as the body of the message, and then attach the body separately. -- Mathieu Longtin 1-514-803-8977 On Wed, Apr 14,

Re: [rt-users] Newbie Question

2010-04-14 Thread Michael Graziano
Hi Brian, On Mar 24, 2010, at 5:46 PM, Brian Lawson wrote: Here’s my situation: Our company has a group of customer service reps and my boss would rather have them share a login username and password as a group and then have a mandatory custom field for their real name and their email

[rt-users] Problem configuring RT Timezone

2010-04-14 Thread Kim Covil
Hi, I am having a bizarre problem configuring the Timezone I want RT to display in the Web UI. It doesn't seem to be related to the other issues I have seen in the archives or wiki. The system hosting RT has its timezone set to UTC. I want RT to display the BST timezone for Europe/London

Re: [rt-users] Newbie Question

2010-04-14 Thread Mauricio Tavares
On Wed, Apr 14, 2010 at 1:56 PM, Michael Graziano michael.grazi...@premierheart.com wrote: Hi Brian, On Mar 24, 2010, at 5:46 PM, Brian Lawson wrote: He wants RT to use the email address entered as the one used for any correspondence, not the address for the username. I'm not sure I follow.

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread Kevin Falcone
On Wed, Apr 14, 2010 at 09:57:04AM -0700, psminusaxl wrote: I went ahead and remove the front page refresh option just to take that out of the picture. And it appears the preference refresh still doesn't work. Any clues? Thanks! Unfortunately, all I can offer is that it just worked

Re: [rt-users] Problem configuring RT Timezone

2010-04-14 Thread Ruslan Zakirov
Hello, Is it mod_perl? I suspect it's issue when perl's ENV is untied from system's. On Wed, Apr 14, 2010 at 10:07 PM, Kim Covil cov...@lmax.com wrote: Hi, I am having a bizarre problem configuring the Timezone I want RT to display in the Web UI. It doesn't seem to be related to the other

[rt-users] Use a calendar item as custom field

2010-04-14 Thread Max McGrath
Hi all- Using RT 3.8.7 on Ubuntu 9.10. Looking do have a Need By custom field for certain queues. Instead of having a user type out a date, is there anyway to use a calendar item, so they could click it and a calendar would pop up giving them clicking abilities to choose a date? Just curious..

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread psminusaxl
Anybody else can chime in? I think if I can determine where and how the home page interval gets triggered I can better pin point the problem. Right now i'm clueless the process flow of how that gets triggered. thanks in advance psminusaxl On Wed, Apr 14, 2010 at 11:18 AM, Kevin Falcone

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread Kenneth Marshall
It works for me on version 3.8.5. Cheers, Ken On Wed, Apr 14, 2010 at 02:30:21PM -0700, psminusaxl wrote: Anybody else can chime in? I think if I can determine where and how the home page interval gets triggered I can better pin point the problem. Right now i'm clueless the process flow of

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread psminusaxl
Thanks Ken for the feedback. :) I will opt for upgrading if there is no other way around. On Wed, Apr 14, 2010 at 2:35 PM, Kenneth Marshall k...@rice.edu wrote: It works for me on version 3.8.5. Cheers, Ken On Wed, Apr 14, 2010 at 02:30:21PM -0700, psminusaxl wrote: Anybody else can

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread William Graboyes
Works for me 3.8.4 Bill On Wed, Apr 14, 2010 at 15:16, psminusaxl psminus...@gmail.com wrote: Thanks Ken for the feedback. :) I will opt for upgrading if there is no other way around. On Wed, Apr 14, 2010 at 2:35 PM, Kenneth Marshall k...@rice.edu wrote: It works for me on version

Re: [rt-users] homepage refresh interval under preferences

2010-04-14 Thread psminusaxl
Thanks Bill...then its something funky with my setup. :( On Wed, Apr 14, 2010 at 3:22 PM, William Graboyes william.grabo...@theportalgrp.com wrote: Works for me 3.8.4 Bill On Wed, Apr 14, 2010 at 15:16, psminusaxl psminus...@gmail.com wrote: Thanks Ken for the feedback. :) I will

[rt-users] NTLM-based Single Sign-On doesn't work - RT continues to present login screen

2010-04-14 Thread Gladkovich, Sergey
Hi, I have a working instance of RT 3.8.7 running under Apache 2.2.3 on RHEL 5.4. The instance has been set up to authenticate users against Active Directory via RT::Authen::ExternalAuth LDAP. The LDAP authentication works fine (i.e. users log in with their AD credentials, and new users get