[rt-users] Make Starts field in Ticket Display updatedable like Last Content(Told)

2013-03-27 Thread Dave Wells
RT Version: 3.6.5

 

Hi,

 

I am trying to make the Starts date field updatable using a hyperlink
like the Last Content field to set the time value to now, this is in the
default Ticket Display screen Display.html.

 

I have updated the  rt3/share/html/Ticket/Elements/ShowDates file to
include the hyperlink

 

 

tr

td class=label date startsa href=% $RT::WebPath
%/Ticket/Display.html?id=% $Ticket-id
%Action=SetStarts|/lStarts//a:/td

td class=value date starts% $Ticket-StartsObj-AsString
%/td

  /tr

 

I have also updated the  rt3/share/html/Ticket/Display.html file to
allow the action to pass

 

 

if (defined $ARGS{'Action'}) {

if ($ARGS{'Action'} =~ /^(Steal|Kill|Take|SetTold|SetStarts)$/)
{

my $action = $1;

my ($res, $msg)=$TicketObj-$action();

push(@Actions, $msg);

}

}

 

The link is now a hyperlink and I can click it however the output is
Starts changed from Not set to Not set, I have done the same for the
Started field and it works fine as you would expect I'm not sure why the
SetStarts is not working as the SetTold and SetStarted are.

 

Any help would be greatly appreciated.

 

Regards

Dave

 


[rt-users] Add Priority Field to Update.html

2011-06-14 Thread Dave Wells
RT Version: 3.6

 

Hi all,

 

What I am trying to do is add a priority field to the Update.html so
users can change priority of a ticket on comment and replies.

 

I have had a go at getting this working but can't get the priority field
to update when the comment/reply is saved, I think I'm missing something
in Display.html.

 

Has anyone had any experience in this and can point me in the right
direction.

 

Many Thanks

Dax

 

 

 

 


[rt-users] Default Search Format per queue

2011-04-06 Thread Dave Wells
Hi, 

 

Simple question but couldn't find a definitive answer.

 

RT Version 3.6.5

 

Is it possible to have a different Results page per queue when using
QuickSearch to select the queue results? i.e. clicking on the queue name
in QuickSearch

 

I know that the user has a default Search format and there is a system
wide default search format but is there one per queue?

 

If the answer to this is no, is there anyway I can have something
displayed like the QuickSearch but with a modified list of saved
searches?  I don't want the results displayed on the homepage just the
option to run the saved search i.e. a list of saved searches.

 

Many Thanks

Dave

 

 


Re: [rt-users] Default Search Format per queue

2011-04-06 Thread Dave Wells
That is exactly what I thought but just wanted to check.

Many Thanks, will have a look at SavedSearches homepage element.

David Wells 

-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin
Falcone
Sent: 06 April 2011 15:28
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Default Search Format per queue

On Wed, Apr 06, 2011 at 11:04:27AM +0100, Dave Wells wrote:
Is it possible to have a different Results page per queue when
using QuickSearch to select the
queue results? i.e. clicking on the queue name in QuickSearch

Not without modifying code, it uses either the global or user specific
search format on that link.

I know that the user has a default Search format and there is a
system wide default search
format but is there one per queue?
 
 
 
If the answer to this is no, is there anyway I can have something
displayed like the
QuickSearch but with a modified list of saved searches?  I don't
want the results displayed on
the homepage just the option to run the saved search i.e. a list of
saved searches.

You might be able to backport the SavedSearches homepage element that I
wrote to be part of 4.0 to run on 3.6

-kevin



[rt-users] Issue with Calendar after install of 3.8.7

2009-12-21 Thread Dave Wells
Hi,

I am testing at present migrating my system from RT 3.6.5 to 3.8.7.

To fill you in on details I did this by:

1. Installing 3.8.7 on new RHEL 5 server

2. copying database from live system to Test system

3. running all the database and schema updates to test system.

4. migrating to ExternalAuth module to enable LDAP logons.

5. Moving across all local customizations of pages.


In the process of testing the new test server I have come across an issue with 
the Calendar module.

In the dates section of a ticket if I use the calendar link I get the following 
error:

Can't locate object method new via package DateTime at 
/usr/lib/perl5/site_perl/5.8.8/Calendar/Simple.pm line 87.

I have DateTime module installed and it is linked to the correct version of 
Perl.

   Wed Dec 16 14:58:26 2009: Module DateTime

   ·   installed into: /usr/lib/perl5/site_perl/5.8.8

   ·   LINKTYPE: dynamic

   ·   VERSION: 

   ·   EXE_FILES: 

Any help would be most appreciated

Thanks
Dax

___
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] Setting Time Worked as Mandatory Field

2009-09-24 Thread Dave Wells
Hi Guys,

I know this has been brought up a couple of times on the lists, but
can't find anything that seems to work for me.

What I am looking for is a way to stop tickets being resolved if there
is no time worked set.

I have seen a post where Richard Ellis stated that adding this to your
/path/to/rt3/local/html/Ticket/Update.html this would work exactly as I
would wish, however I am not entirely sure of how this file should be
formatted, I understand that the files in /local/ should append to those
in /share/:

if ($DefaultStatus eq 'resolved') {
 # if we are resolving a ticket and there has been no time
submitted,
 # do not allow the ticket to resolve.  must check that SubmitTicket
is
 # set, or we prevent the close page from loading and thus NO ticket
can
 # be resolved.
 if ((! defined($TicketObj-TimeWorked) or $TicketObj-TimeWorked ==

0) and
 $ARGS{'UpdateTimeWorked'} = 0 and
 exists $ARGS{'SubmitTicket'} ) {
 Abort(You cannot resolve a ticket with zero time worked. 
Please reselect the ticket and try again);
 }


When I add this file and insert the above text by itself, when I try and
update a ticket it mearly prints the above code out on the webpage,
obviously I am missing some tags or code.

If someone could enlighten me that would be great.

Many Thanks.

Dave

___
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] Allow client to see their requested tickets

2009-04-02 Thread Dave Wells
 
Thanks Roy,

That's exactly what i am looking for =)


-Original Message-
From: Raed El-Hames [mailto:r...@vialtus.com] 
Sent: 02 April 2009 14:18
To: Dave Wells
Subject: Re: [rt-users] Allow client to see their requested tickets

Dave;

The self service interface allows exactly that, Been running my rt for
so many years I forgot what were the default rights , but if you give
the global group Requestor the right to:
ShowTicket
ReplyToTicket
ModifyTicket (if you want them to be able to change ticket status) then
any unprivileged user with a password assigned can login to RT and be
presented with a list if their tickets which they can reply/modify
*
Roy

*

http://www.vialtus.com/

 

This email is subject to:

http://www.vialtus.com/disclaimer.html

 

 



Dave Wells wrote:
 Hi,

 We have a requirement to allow our clients to have access to our
 ticketing system.

 We only want to allow them to see tickets that they are the requester
 for.

 We would also like them to have the ability to reply within their
 tickets.

 Its highly important that they obviously cant see any tickets that
they
 are not the requester for.

 What would be the best way to go about this?

 Many Thanks
 Dave

 ___
 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
   


___
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] On Comment set to open

2009-01-07 Thread Dave Wells
Hi Guys,
 
Just a quick question, when our users comment on a ticket in a new
state, the ticket is automatically moved to an open state.
 
There are no scripts I can find that carry out this action, is this a
default action and if it is can it be changed?
 
Many Thanks
Dave 
___
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] On Comment set to open

2009-01-07 Thread Dave Wells
Hi Guys,
 
Just a quick question, when our users comment on a ticket in a new
state, the ticket is automatically moved to an open state.
 
There are no scripts I can find that carry out this action, is this a
default action and if it is can it be changed?
 
Many Thanks
Dave 

___
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] On Comment set to open

2009-01-07 Thread Dave Wells
Hi,

Nope this is purely a comment via the web interface. I have also removed
the default script mentioned.

The scripts I have set are as follows:

Scrips which apply to all queues

Send Notification of Ticket when a reply is received to a resolved
ticket 
On Reply to Resolved Ticket Notify AdminCcs with template
ReplyToResolved 

Send Notification of Ticket when a reply is received to a resolved
ticket 
On Reply to Resolved Ticket Notify Ccs with template ReplyToResolved 

Send Notification of Ticket when a reply is received to a resolved
ticket 
On Reply to Resolved Ticket Notify Owner with template ReplyToResolved 

On a Reply(correspondance) to a resolved ticket set the status back to
new 
On Reply to Resolved Ticket User Defined with template Blank 

For CC and BCC Field 
On Correspond Notify Other Recipients with template Correspondence 

for CC and BCC Field 
On Comment Notify Other Recipients with template Correspondence 

Queue Scrips

On Resolve Notify Requestors with template Resolved  

On Resolve Notify AdminCcs with template Resolved  
 
On Resolve Notify Owner with template Resolved  

On Correspond Notify Requestors with template Correspondence  

On Create Notify Owner with template Admin Comment  

On Create Notify Requestors, Ccs and AdminCcs with template Admin
Comment  

On Correspond Notify Owner with template Correspondence  
 
Thanks
Dave

-Original Message-
From: Stephen Turner [mailto:stur...@mit.edu] 
Sent: 07 January 2009 15:31
To: Dave Wells; RT users
Subject: Re: [rt-users] On Comment set to open

On Wed, 07 Jan 2009 10:03:35 -0500, Dave Wells
dave.we...@foreshore.net
wrote:

 Hi Guys,
 Just a quick question, when our users comment on a ticket in a new 
 state, the ticket is automatically moved to an open state.
 There are no scripts I can find that carry out this action, is this a 
 default action and if it is can it be changed?
 Many Thanks
 Dave


Do you mean comment or reply? There's a global scrip installed by
default that does this on reply:

On Correspond Open Tickets with template Blank

Steve

--
Stephen Turner
Senior Programmer/Analyst - SAIS
MIT IST


___
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] On Comment set to open

2009-01-07 Thread Dave Wells
Thanks very much for the info, makes sense now.

If I change html/Ticket/Update.html to set the status default to new, do
you think this would cause any issues? 

-Original Message-
From: Stephen Turner [mailto:stur...@mit.edu] 
Sent: 07 January 2009 15:56
To: Dave Wells; RT users
Subject: Re: [rt-users] On Comment set to open

On Wed, 07 Jan 2009 10:43:08 -0500, Dave Wells
dave.we...@foreshore.net
wrote:

 Hi,

 Nope this is purely a comment via the web interface. I have also 
 removed the default script mentioned.


This finally rang a bell - if you look at html/Ticket/Update.html you'll
see code that sets the status drop down default to 'open' if the ticket
status is 'new'. So when you submit a comment the status is updated.

Steve

--
Stephen Turner
Senior Programmer/Analyst - SAIS
MIT IST


___
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] Modify Rows per Box settings for all users

2008-10-29 Thread Dave Wells
Hi,
 
I have search through the archive and cannot seem to find an answer for
how to set a default rows per box setting to all users I want to set
it to 50 and not the default of 10.
 
I know you can do this individually for each user in the Customise RT
at a Glance section, however I have not given my users the ModifySelf
right and don't want to have to give them this right so they can do
this.
 
Is there anyway to set the rows per box setting globally?
 
Thanks
Dave
___
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] On Comment resolved ticket set back to new status

2008-10-10 Thread Dave Wells
Hi Violetta,

We have removed all global scripts on our queues a while ago.

Thanks
Dave 

-Original Message-
From: Violetta Wawryk [mailto:[EMAIL PROTECTED] 
Sent: 10 October 2008 12:15
To: Dave Wells
Cc: RT users
Subject: Re: [rt-users] On Comment resolved ticket set back to new
status

Hi Dave,

in my test-rt (3.6.1, which still has all the defaults configured) is a
global scrip that says:

On Correspond Open Tickets with template Blank

are you sure you haven't got it?

Regards
Violetta


 On all of our queues when a ticket is in a resolved state and a user 
 makes a comment on the ticket the status of the ticket is set back to 
 new.
  
 We have no defined scrips for the Queues or in Global configuration 
 that are set to do this. Is this a default action in RT if so is it 
 possible to change this?
  
 Thanks
 Dave
--
Vorstand/Board of Management:
Dr. Bernd Finkbeiner, Dr. Florian Geyer, Dr. Roland Niemeier, Dr. Arno
Steitz, Dr. Ingrid Zech Vorsitzender des Aufsichtsrats/ Chairman of the
Supervisory Board:
Prof. Dr. Hanns Ruder
Sitz/Registered Office: Tuebingen
Registergericht/Registration Court: Stuttgart Registernummer/Commercial
Register No.: HRB 382196 




___
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] On Comment resolved ticket set back to new status

2008-10-10 Thread Dave Wells
Its ok found the problem.

I was using the ReplyToResolved contribution on the RT wiki and it seems
to fire on a comment as well as a correspond.

I shall investigate.

Thx
Dave

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave
Wells
Sent: 10 October 2008 14:21
To: Violetta Wawryk; RT users
Subject: Re: [rt-users] On Comment resolved ticket set back to new
status

Hi Violetta,

We have removed all global scripts on our queues a while ago.

Thanks
Dave 

-Original Message-
From: Violetta Wawryk [mailto:[EMAIL PROTECTED]
Sent: 10 October 2008 12:15
To: Dave Wells
Cc: RT users
Subject: Re: [rt-users] On Comment resolved ticket set back to new
status

Hi Dave,

in my test-rt (3.6.1, which still has all the defaults configured) is a
global scrip that says:

On Correspond Open Tickets with template Blank

are you sure you haven't got it?

Regards
Violetta


 On all of our queues when a ticket is in a resolved state and a user 
 makes a comment on the ticket the status of the ticket is set back to 
 new.
  
 We have no defined scrips for the Queues or in Global configuration 
 that are set to do this. Is this a default action in RT if so is it 
 possible to change this?
  
 Thanks
 Dave
--
Vorstand/Board of Management:
Dr. Bernd Finkbeiner, Dr. Florian Geyer, Dr. Roland Niemeier, Dr. Arno
Steitz, Dr. Ingrid Zech Vorsitzender des Aufsichtsrats/ Chairman of the
Supervisory Board:
Prof. Dr. Hanns Ruder
Sitz/Registered Office: Tuebingen
Registergericht/Registration Court: Stuttgart Registernummer/Commercial
Register No.: HRB 382196 




___
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


___
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] On Comment resolved ticket set back to new status

2008-10-10 Thread Dave Wells
Hi Guys,
 
On all of our queues when a ticket is in a resolved state and a user
makes a comment on the ticket the status of the ticket is set back to
new.
 
We have no defined scrips for the Queues or in Global configuration that
are set to do this. Is this a default action in RT if so is it possible
to change this?
 
Thanks
Dave
___
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] Calling an external script from Scrip Actions

2008-10-07 Thread Dave Wells
Hi Guys,
 
This may be very simple,
 
Is it possible to call an external script located on the system from a
Custom scrip i.e. from the Custom action preparation code  or Custom
action cleanup code?
 
Thanks
 
Dave

___
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] Dynamic Signatures

2008-09-25 Thread Dave Wells
Hi Guys,
 
I am running RT 3.6.4 and I have a very simple question.

Is it possible to supply dynamic content in an users signature?

i.e. we want to be able to put a link to a website in the users
signature that will link to a page that creates a feedback response and
we want to be able to include the relevant ticket number in the
signature as in:

We value your opinion and we would like to hear about your experience
with our Support department.  Please click here to submit feedback
on this support ticket.
 
Where here would be something like
http://www.website.com/ticketfeedback?id=123456 (where 123456 would be
the number of the RT ticket)?

Any help would be greatly appreciated.


***
 

Any views expressed in this message are those of the individual sender, 
except where the sender states them to be the views of Foreshore Limited. 
This e-mail is intended only for the individual or entity to which it is 
addressed and contains information that is private and confidential. If 
you are not the intended recipient you are hereby notified that any 
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and 
advise us by return e-mail to [EMAIL PROTECTED] inline: 108092515421410301.gif___
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] Using rt-crontool to send Timed Notifications

2008-08-18 Thread Dave Wells
Hi,
 
We are using rt-crontool to send timed notifications based on different
criteria either to owners of tickets or queue groups after a period of
inactivity in some form.
 
The way we do this is to use RT::Action::RecordComment
http://wiki.bestpractical.com/view/RecordComment  as the action of
rt-crontool to add a comment to the ticket using a template and also
email the owner or queue group.
 
However I have been asked if there is any way that everything can run as
before with mails being sent to owner/queue group but without the
comment on the ticket being added. I have attempted using SendEmail or
Notify as the action for rt-crontool but it does not seem to work at
all.
 
Does anyone know where i am going wrong or is there a better way to do
this?
 
Thanks
Dave
 
 
 


***
 

Any views expressed in this message are those of the individual sender, 
except where the sender states them to be the views of Foreshore Limited. 
This e-mail is intended only for the individual or entity to which it is 
addressed and contains information that is private and confidential. If 
you are not the intended recipient you are hereby notified that any 
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and 
advise us by return e-mail to [EMAIL PROTECTED] inline: 108081808582501801.gif___
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] FW: Using rt-crontool to send Timed Notifications

2008-08-18 Thread Dave Wells
 



From: Dave Wells 
Sent: 18 August 2008 16:02
To: 'Jerrad Pierce'
Subject: RE: [rt-users] Using rt-crontool to send Timed Notifications


The issue is that we are looking to make our RT installation client
facing.
 
Therefore we do not really want comments about slow responses or actions
being left on the ticket.



From: Jerrad Pierce [mailto:[EMAIL PROTECTED] 
Sent: 18 August 2008 15:31
To: Dave Wells
Cc: RT users
Subject: Re: [rt-users] Using rt-crontool to send Timed Notifications






However I have been asked if there is any way that everything can run as
before with mails being sent to owner/queue group but without the
comment on the ticket being added. I have attempted using SendEmail or
Notify as the action for rt-crontool but it does not seem to work at
all.

This seems antithetical to the design of RT.
It's meant to log all transactions.
-- 
Cambridge Energy Alliance: Save money  the planet


***
 

Any views expressed in this message are those of the individual sender, 
except where the sender states them to be the views of Foreshore Limited. 
This e-mail is intended only for the individual or entity to which it is 
addressed and contains information that is private and confidential. If 
you are not the intended recipient you are hereby notified that any 
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and 
advise us by return e-mail to [EMAIL PROTECTED] inline: 108081816113601701.gif___
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] Using rt-crontool to send Timed Notifications

2008-08-18 Thread Dave Wells
Umm I didnt know that can you stop specific users or groups from seeing
comments. How do you do that? cause it sounds perfect.



From: Jerrad Pierce [mailto:[EMAIL PROTECTED] 
Sent: 18 August 2008 16:12
To: Dave Wells
Subject: Re: [rt-users] Using rt-crontool to send Timed Notifications


On Mon, Aug 18, 2008 at 11:01, Dave Wells [EMAIL PROTECTED]
wrote:






The issue is that we are looking to make our RT installation client
facing.
 
Therefore we do not really want comments about slow responses or actions
being left on the ticket.

Are you confusing comments and correspondence?
You can control access to comments with ACLs,
and the public should indeed never see comments.
-- 
Cambridge Energy Alliance: Save money  the planet


***
 

Any views expressed in this message are those of the individual sender, 
except where the sender states them to be the views of Foreshore Limited. 
This e-mail is intended only for the individual or entity to which it is 
addressed and contains information that is private and confidential. If 
you are not the intended recipient you are hereby notified that any 
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and 
advise us by return e-mail to [EMAIL PROTECTED] inline: 108081816135403001.gif___
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] FW: Using rt-crontool to send Timed Notifications

2008-08-18 Thread Dave Wells
It's obvious when its pointed out to you isn't it =)

Thanks for the help



From: Jerrad Pierce [mailto:[EMAIL PROTECTED] 
Sent: 18 August 2008 16:16
To: Dave Wells
Subject: Re: [rt-users] FW: Using rt-crontool to send Timed
Notifications







The issue is that we are looking to make our RT
installation client facing.
 
Therefore we do not really want comments about slow responses or
actions being left on the ticket.



Are you confusing comments and correspondence?
You can control access to comments with ACLs,
and the public should indeed never see comments.

Umm I didnt know that can you stop specific users or groups from seeing
comments. How do you do that? cause it sounds perfect.

The rights are CommentOn and ShowTicketComments

P.S. You're funky HTML formatted message makes for some awkward editing.
-- 
Cambridge Energy Alliance: Save money  the planet


***
 

Any views expressed in this message are those of the individual sender, 
except where the sender states them to be the views of Foreshore Limited. 
This e-mail is intended only for the individual or entity to which it is 
addressed and contains information that is private and confidential. If 
you are not the intended recipient you are hereby notified that any 
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and 
advise us by return e-mail to [EMAIL PROTECTED] inline: 108081816491702201.gif___
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] No Bounce message with a permission denied error

2007-08-28 Thread Dave Wells
Hi,

We recently began experiencing a strange issue, if an external user
replies to a ticket and he is not the requester, a watcher or associated
with the ticket in anyway he should get a permission denied bounce
message because we only allow replyToTicket from the Requester.

However recently the user is not getting this bounce message the content
is not added to the the ticket and the users does not know it has
bounced so it is like the email simply disappears.

I have included the rt debug output from when this mail arrives

[Thu Aug 23 10:02:14 2007] [debug]: Converting 'WINDOWS-1252' to 'utf-8'
for text/plain - RE: [foreshore.net #85556] [Comment] Test - do not
delete (/usr/local/rt3/lib/RT/I18N.pm:221)
[Thu Aug 23 10:02:14 2007] [debug]: Found a ticket ID. It's 85556
(/usr/local/rt3/lib/RT/Interface/Email.pm:477)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::CanonicalizeEmailAddress :
called with [EMAIL PROTECTED] by RT::CurrentUser
/usr/local/rt3/lib/RT/CurrentUser.pm 218
(/usr/local/rt3/local/lib/RT/User_Local.pm:326)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net [EMAIL PROTECTED] =
EmailAddress: , Name: , RealName:
(/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net [EMAIL PROTECTED]
=  EmailAddress: , Name: , RealName:
(/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net
[EMAIL PROTECTED] =  EmailAddress: ,
Name: , RealName:  (/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mail=smtp:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net mail=smtp:[EMAIL PROTECTED] =
EmailAddress: , Name: , RealName:
(/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mailRoutingAddress=smtp:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net
mailRoutingAddress=smtp:[EMAIL PROTECTED] =  EmailAddress: ,
Name: , RealName:  (/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mailAlternateAddress=smtp:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net
mailAlternateAddress=smtp:[EMAIL PROTECTED] =  EmailAddress:
, Name: , RealName:  (/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mail=SMTP:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net mail=SMTP:[EMAIL PROTECTED] =
EmailAddress: , Name: , RealName:
(/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mailRoutingAddress=SMTP:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net
mailRoutingAddress=SMTP:[EMAIL PROTECTED] =  EmailAddress: ,
Name: , RealName:  (/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mailAlternateAddress=SMTP:[EMAIL PROTECTED] by RT::User

[rt-users] No Bounce message with a permission denied error

2007-08-23 Thread Dave Wells
Hi,

We recently began experiencing a strange issue, if an external user
replies to a ticket and he is not the requester, a watcher or associated
with the ticket in anyway he should get a permission denied bounce
message because we only allow replyToTicket from the Requester.

However recently the user is not getting this bounce message the content
is not added to the the ticket and the users does not know it has
bounced so it is like the email simply disappears.

I have included the rt debug output from when this mail arrives

[Thu Aug 23 10:02:14 2007] [debug]: Converting 'WINDOWS-1252' to 'utf-8'
for text/plain - RE: [foreshore.net #85556] [Comment] Test - do not
delete (/usr/local/rt3/lib/RT/I18N.pm:221)
[Thu Aug 23 10:02:14 2007] [debug]: Found a ticket ID. It's 85556
(/usr/local/rt3/lib/RT/Interface/Email.pm:477)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::CanonicalizeEmailAddress :
called with [EMAIL PROTECTED] by RT::CurrentUser
/usr/local/rt3/lib/RT/CurrentUser.pm 218
(/usr/local/rt3/local/lib/RT/User_Local.pm:326)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net [EMAIL PROTECTED] =
EmailAddress: , Name: , RealName:
(/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net [EMAIL PROTECTED]
=  EmailAddress: , Name: , RealName:
(/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net
[EMAIL PROTECTED] =  EmailAddress: ,
Name: , RealName:  (/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mail=smtp:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net mail=smtp:[EMAIL PROTECTED] =
EmailAddress: , Name: , RealName:
(/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mailRoutingAddress=smtp:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net
mailRoutingAddress=smtp:[EMAIL PROTECTED] =  EmailAddress: ,
Name: , RealName:  (/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mailAlternateAddress=smtp:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net
mailAlternateAddress=smtp:[EMAIL PROTECTED] =  EmailAddress:
, Name: , RealName:  (/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mail=SMTP:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net mail=SMTP:[EMAIL PROTECTED] =
EmailAddress: , Name: , RealName:
(/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mailRoutingAddress=SMTP:[EMAIL PROTECTED] by RT::User
/usr/local/rt3/local/lib/RT/User_Local.pm 332
(/usr/local/rt3/local/lib/RT/User_Local.pm:508)
[Thu Aug 23 10:02:14 2007] [info]: RT::User::LookupExternalUserInfo :
dc=is,dc=foreshore,dc=net
mailRoutingAddress=SMTP:[EMAIL PROTECTED] =  EmailAddress: ,
Name: , RealName:  (/usr/local/rt3/local/lib/RT/User_Local.pm:563)
[Thu Aug 23 10:02:14 2007] [debug]: RT::User::LookupExternalUserInfo
called with baseDN dc=is,dc=foreshore,dc=net and filter
mailAlternateAddress=SMTP:[EMAIL PROTECTED] by RT::User

RE: [rt-users] [Rt-announce] RT 3.6.0 Released

2006-10-13 Thread Dave Wells
 Hi,

I have tried carrying out the steps below, it does not seem to fix my
issues a view source from my RT still shows:

HTML
HEAD
TITLERT at a glance/TITLE

link rel=shortcut icon href=/NoAuth/images//favicon.png
type=image/png
link rel=stylesheet href=/NoAuth/webrt.css type=text/css

I have removed the Set($WebDefaultStylesheet, '3.5-default'); from the
RT_Siteconfig.pm so that it is set by default by the RT_Config.pm,
However if I modify this between 3.5-default and 3.4-compat it makes
absolutely no difference to my web interface. Also the system
configuration tool shows that the $WebDefaultStylesheet variable is
being set correctly.

Is there anything else I can try?

Thanks
Dave


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Drew
Barnes
Sent: 16 June 2006 18:31
To: Steve Palm
Cc: rt-users@lists.bestpractical.com; Ruslan Zakirov
Subject: Re: [rt-users] [Rt-announce] RT 3.6.0 Released

1. Stop apache.
2. rm -rf  /path/to/rt/var/mason_data/obj/* 3. Start apache

Steve Palm wrote:

 On Jun 16, 2006, at 12:21 PM, Ruslan Zakirov wrote:
 1. Remove mason page.

  I'm sorry, I do not understand what you mean there.

 2. Also open source of any page in browser, it must contain something
 like:
 link rel=stylesheet href=/NoAuth/css/3.5-default/main.css 
 type=text/css media=all /
 link rel=stylesheet href=/NoAuth/css/print.css type=text/css 
 media=print /

  I do not have those, only:

  link rel=stylesheet href=/NoAuth/webrt.css type=text/css

  This may be related to the mason page you reference above, but I do 
 not know what/where to delete. Should the upgrade handle this?

  The main.css is several lines of @import statements when viewed in my

 browser.

  Steve

 -
 Steve Palm --- [EMAIL PROTECTED]
 Computer Systems Analyst/Programmer
 Slavic Gospel Association -- Loves Park, IL

 ___
 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


 We're hiring! Come hack Perl for Best Practical: 
 http://bestpractical.com/about/jobs.html

--
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

___
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


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html

___
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] [Rt-announce] RT 3.6.0 Released

2006-10-13 Thread Dave Wells
I have solved my problem I had some Local overlays in /rt3/local/html/.

Deleted these and it solved my problem.

Dave

-


Hi,

I have tried carrying out the steps below, it does not seem to fix my
issues a view source from my RT still shows:

HTML
HEAD
TITLERT at a glance/TITLE

link rel=shortcut icon href=/NoAuth/images//favicon.png
type=image/png
link rel=stylesheet href=/NoAuth/webrt.css type=text/css

I have removed the Set($WebDefaultStylesheet, '3.5-default'); from the
RT_Siteconfig.pm so that it is set by default by the RT_Config.pm,
However if I modify this between 3.5-default and 3.4-compat it makes
absolutely no difference to my web interface. Also the system
configuration tool shows that the $WebDefaultStylesheet variable is
being set correctly.

Is there anything else I can try?

Thanks
Dave


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Drew
Barnes
Sent: 16 June 2006 18:31
To: Steve Palm
Cc: rt-users@lists.bestpractical.com; Ruslan Zakirov
Subject: Re: [rt-users] [Rt-announce] RT 3.6.0 Released

1. Stop apache.
2. rm -rf  /path/to/rt/var/mason_data/obj/* 3. Start apache

Steve Palm wrote:

 On Jun 16, 2006, at 12:21 PM, Ruslan Zakirov wrote:
 1. Remove mason page.

  I'm sorry, I do not understand what you mean there.

 2. Also open source of any page in browser, it must contain something
 like:
 link rel=stylesheet href=/NoAuth/css/3.5-default/main.css 
 type=text/css media=all /
 link rel=stylesheet href=/NoAuth/css/print.css type=text/css 
 media=print /

  I do not have those, only:

  link rel=stylesheet href=/NoAuth/webrt.css type=text/css

  This may be related to the mason page you reference above, but I do 
 not know what/where to delete. Should the upgrade handle this?

  The main.css is several lines of @import statements when viewed in my

 browser.

  Steve

 -
 Steve Palm --- [EMAIL PROTECTED]
 Computer Systems Analyst/Programmer
 Slavic Gospel Association -- Loves Park, IL

 ___
 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


 We're hiring! Come hack Perl for Best Practical: 
 http://bestpractical.com/about/jobs.html

--
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

___
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


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html

___
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] Slow query results on search in content.

2006-05-24 Thread Dave Wells

Hi,

My users have been experiencing issues when they try and search on
content in all Tickets. The problems they experience are a very long
wait 30-40 mins for the results to appear or most often the page will
just hang and go to a blank page.

We have approx 45000 tickets in our database.

I have done a little experimenting with the kind of queries they have
been using as below:

 SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2  WHERE
((Transactions_1.ObjectType = 'RT::Ticket')) AND ((main.EffectiveId =
main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket'))
AND ( ( (Attachments_2.Content LIKE
'%catalog%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) );
+-+
| COUNT(DISTINCT main.id) |
+-+
| 244 |
+-+
1 row in set (3 min 57.46 sec)

As you can see the mysql query is appearing to take a lil under 4 mins
which is ok, however it does not seem to reflect this speed using the
web browser.

I also ran an Explain as below:

 explain SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2  WHERE
((Transactions_1.ObjectType = 'RT::Ticket')) AND ((main.EffectiveId =
main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket'))
AND ( ( (Attachments_2.Content LIKE
'%catalog%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) );
+++---+-+-+-
+---+-+
| table  | type   | possible_keys | key | key_len |
ref | rows  | Extra   |
+++---+-+-+-
+---+-+
| Attachments_2  | ALL| Attachments2  | NULL|NULL |
NULL| 67372 | Using where |
| Transactions_1 | eq_ref | PRIMARY,Transactions1 | PRIMARY |   4 |
Attachments_2.TransactionId | 1 | Using where |
| main   | eq_ref | PRIMARY   | PRIMARY |   4 |
Transactions_1.ObjectId | 1 | Using where |
+++---+-+-+-
+---+-+


I think the indeices look right but I am NO mysql guru so not entriley
sure.

I shall include the main RT conf options below:
Loaded perl modules
Perl v5.8.7 under linux
  Apache v1.27;
  Apache::Connection v1.00;
  Apache::Constants v1.09;
  Apache::DBI v0.9901;
  Apache::Request v1.33;
  Apache::Server v1.01;
  Apache::Session v1.6;
  Apache::Session::Generate::MD5 v2.1;
  Apache::Session::Lock::MySQL v1.00;
  Apache::Session::MySQL v1.01;
  Apache::Session::Serialize::Storable v1.00;
  Apache::Session::Store::DBI v1.02;
  Apache::Session::Store::MySQL v1.04;
  Apache::Status v2.03;
  Apache::Table v0.01;
  AutoLoader v5.60;
  B v1.09;
  base v2.07;
  Benchmark v1.07;
  bytes v1.02;
  Cache::Simple::TimedExpiry v0.23;
  Carp v1.04;
  CGI v3.10;
  CGI::Cookie v1.25;
  CGI::Util v1.5;
  Class::Container v0.12;
  Class::Data::Inheritable v0.02;
  Class::ReturnValue v0.53;
  constant v1.05;
  Cwd v3.05;
  Data::Dumper v2.121_04;
  DBD::mysql v3.0002_1;
  DBI v1.48;
  DBIx::SearchBuilder v1.32;
  DBIx::SearchBuilder::Unique v0.01;
  Devel::StackTrace v1.11;
  Devel::StackTraceFrame v0.6;
  Digest::base v1.00;
  Digest::MD5 v2.33;
  DynaLoader v1.05;
  Encode v2.10;
  Encode::Alias v2.03;
  Encode::Config v2.00;
  Encode::Encoding v2.02;
  Errno v1.0901;
  Exception::Class v1.21;
  Exception::Class::Base v1.2;
  Exporter v5.58;
  Exporter::Heavy v5.58;
  Fcntl v1.05;
  fields v2.03;
  File::Basename v2.73;
  File::Glob v1.04;
  File::Path v1.07;
  File::Spec v3.05;
  File::Spec::Unix v1.5;
  File::Temp v0.16;
  FileHandle v2.01;
  HTML::Entities v1.29;
  HTML::Mason v1.3101;
  HTML::Mason::ApacheHandler v1.69;
  HTML::Mason::Exception v1.1;
  HTML::Mason::Exception::Abort v1.1;
  HTML::Mason::Exception::Compilation v1.1;
  HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
  HTML::Mason::Exception::Compiler v1.1;
  HTML::Mason::Exception::Decline v1.1;
  HTML::Mason::Exception::Params v1.1;
  HTML::Mason::Exception::Syntax v1.1;
  HTML::Mason::Exception::System v1.1;
  HTML::Mason::Exception::TopLevelNotFound v1.1;
  HTML::Mason::Exception::VirtualMethod v1.1;
  HTML::Mason::Exceptions v1.43;
  HTML::Parser v3.45;
  HTML::Scrubber v0.08;
  I18N::LangTags v0.35;
  I18N::LangTags::Detect v1.03;
  integer v1.00;
  IO v1.21;
  IO::File v1.11;
  IO::Handle v1.24;
  IO::InnerFile v2.110;
  IO::Lines v2.110;
  IO::Scalar v2.110;
  IO::ScalarArray v2.110;
  IO::Seekable v1.09;
  IO::Wrap v2.110;
  IO::WrapTie v2.110;
  IPC::Open2 v1.01;
  IPC::Open3 v1.0106;
  lib v0.5565;
  List::Util v1.14;
  locale v1.00;