[rt-users] Logo error even after apache restart Mason cache cleaned

2007-10-23 Thread David ROBERT
Hello,

I have a problem with logo customization. I followed this instructions 
(http://wiki.bestpractical.com/view/ChangeLogo) and paid much attention to the 
latest mails about logos (after each  every changes I use a cleanmason.sh that 
makes a apache stop / clean cache / apache start)

But when access the login page I get this :


error:  Error during compilation of /opt/rt3/local/html/Elements/Logo:
Bareword RT::LogoLinkURL not allowed while strict subs in use at 
/opt/rt3/local/html/Elements/Logo line 49.

 
context:  ...   
45:  %# those contributions and any derivatives thereof. 
46:  %#  
47:  %# END BPS TAGGED BLOCK }}} 
48:  div id=logo 
49:  a href=%RT::LogoLinkURL%img src=%$RT::WebImagesURL%/bplogo.gif 
alt=%loc(Best Practical Solutions, LLC corporate logo)% width=177 
height=33 //a 
50:  % if ($show_name) { 
51:  div class=rtname% loc(RT for [_1], $RT::rtname) %/div 
52:  % } 
53:  /div 
...  

The problem seems to be onlyfor RT::variables in the href=
If I put plain text in there, it's ok
If I put any other RT variables (just a copy  paste of the following 
%$RT::WebImagesURL% or any other properly defined and substituted variables 
for instance) I get an error.
But all other RT variables are properly substituted in the line. I only have a 
problem with the href.

I tried to google around for bareword and strict subs but did not grasp 
where to look for or what would be the effect of remove such a strict subs 
command wherever it may be.

I don't mind coding the URL in plain text in my local Logo file but it would be 
better if this variable could work properly.

Any idea ?

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] RE: can we create our own scrip action in request tracker?

2007-10-23 Thread Krishna Prasad
I don't know writing the scrip.

 

Actually I want to create scrip for Auto-reply to requestor and Cc's

 

Please anyone send me the scrip for Auto-reply to requestor and Cc's.

 

 

With Regards, 

Krishna Prasad 

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Logo error even after apache restart Mason cachecleaned

2007-10-23 Thread David ROBERT
missing $

Shame on me. Not even able to do a copy/paste properly

You can flame me all you want and I deserve it :-(
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Making a field mandatory for ticket resolution.

2007-10-23 Thread Drew Barnes
My boss wanted the same from me.  As a sledgehammer fix, I set it so
that any action taken on a ticket defaults to 10 min by editing
local/html/Ticket/Update.html

I'm sure there would be a way to add something to the UI (i.e. a
javascript snippet) but I've been pulled off onto other projects for the
moment.


Huw Selley wrote:
 Hi,

 My apologies if this belongs on rt-devel.

 I am currently using RT 3.6.3 in production and have had a request from
 management to force users to update the 'Time Worked' field when resolving a
 ticket.

 I could not spot anywhere in the UI to make a built-in field mandatory so I
 guess I need to write a scrip to do this.
 My questions are:

 1) Can I do this from the UI?
 2) If not can someone point me in the right direction, I am happy to write a
 scrip that runs OnResolve and checks that there is a value in the timeworked
 field but I am unsure how to warn the user that they have not filled in a
 value (or does RT take care of that for me?)

 Thanks in advance

 Huw



 s2s company email disclaimer: 
 http://www.s2s.ltd.uk/datasheets/email_disclaimer.pdf
 s2s company registration number : 3952958
 s2s VAT registration number : GB763132055
 Business premises   : Ground Floor, Overline House, Crawley, West 
 Sussex, RH10 1JA
 Registered address  : 29 High Street, Crawley, West Sussex, RH10 
 1BQ
 Place of registration   : England

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

 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

 If you sign up for a new RT support contract before December 31, we'll take
 up to 20 percent off the price. This sale won't last long, so get in touch 
 today. 
 Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


 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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Making a field mandatory for ticket resolution.

2007-10-23 Thread Jacob Helwig
It sounds like http://wiki.bestpractical.com/view/MandatorySubject could
be modified to do the checks that Huw is looking for.  Unfortunately, my
JavaScript-fu is weak, so I wouldn't be able to quickly/easily suggest a
way to do the needed modifications, but it sounds like it would be able
to provide a base/starting point.

-- 
Jacob Helwig
PC Technician
Busch's Help Desk
Desk: x35221
Direct: 734-214-8221

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Drew
Barnes
Sent: Tuesday, October 23, 2007 8:30 AM
To: Huw Selley
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Making a field mandatory for ticket resolution.

My boss wanted the same from me.  As a sledgehammer fix, I set it so
that any action taken on a ticket defaults to 10 min by editing
local/html/Ticket/Update.html

I'm sure there would be a way to add something to the UI (i.e. a
javascript snippet) but I've been pulled off onto other projects for the
moment.


Huw Selley wrote:
 Hi,

 My apologies if this belongs on rt-devel.

 I am currently using RT 3.6.3 in production and have had a request
from
 management to force users to update the 'Time Worked' field when
resolving a
 ticket.

 I could not spot anywhere in the UI to make a built-in field mandatory
so I
 guess I need to write a scrip to do this.
 My questions are:

 1) Can I do this from the UI?
 2) If not can someone point me in the right direction, I am happy to
write a
 scrip that runs OnResolve and checks that there is a value in the
timeworked
 field but I am unsure how to warn the user that they have not filled
in a
 value (or does RT take care of that for me?)

 Thanks in advance

 Huw



 s2s company email disclaimer:
http://www.s2s.ltd.uk/datasheets/email_disclaimer.pdf
 s2s company registration number : 3952958
 s2s VAT registration number : GB763132055
 Business premises   : Ground Floor, Overline House,
Crawley, West Sussex, RH10 1JA
 Registered address  : 29 High Street, Crawley, West
Sussex, RH10 1BQ
 Place of registration   : England

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

 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

 If you sign up for a new RT support contract before December 31, we'll
take
 up to 20 percent off the price. This sale won't last long, so get in
touch today. 
 Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


 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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll
take
up to 20 percent off the price. This sale won't last long, so get in
touch today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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: ***SPAM*** (K2) [rt-users] Making a field mandatory for ticket resolution.

2007-10-23 Thread Benjamin Weser
Have a look at http://wiki.bestpractical.com/view/MandatorySubject . I
just added it today to our RT. It works great for the subject and it
shouldn't be too hard to add it to other built-in fields like timeworked
too (there's a short description on the page).

Huw Selley wrote:
 Hi,

 My apologies if this belongs on rt-devel.

 I am currently using RT 3.6.3 in production and have had a request from
 management to force users to update the 'Time Worked' field when resolving a
 ticket.

 I could not spot anywhere in the UI to make a built-in field mandatory so I
 guess I need to write a scrip to do this.
 My questions are:

 1) Can I do this from the UI?
 2) If not can someone point me in the right direction, I am happy to write a
 scrip that runs OnResolve and checks that there is a value in the timeworked
 field but I am unsure how to warn the user that they have not filled in a
 value (or does RT take care of that for me?)

 Thanks in advance

 Huw



 s2s company email disclaimer: 
 http://www.s2s.ltd.uk/datasheets/email_disclaimer.pdf
 s2s company registration number : 3952958
 s2s VAT registration number : GB763132055
 Business premises   : Ground Floor, Overline House, Crawley, West 
 Sussex, RH10 1JA
 Registered address  : 29 High Street, Crawley, West Sussex, RH10 
 1BQ
 Place of registration   : England

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

 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

 If you sign up for a new RT support contract before December 31, we'll take
 up to 20 percent off the price. This sale won't last long, so get in touch 
 today. 
 Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


 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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Making a field mandatory for ticket resolution.

2007-10-23 Thread Huw Selley
On 23/10/07 1:41, Benjamin Weser [EMAIL PROTECTED] wrote:

 Have a look at http://wiki.bestpractical.com/view/MandatorySubject . I
 just added it today to our RT. It works great for the subject and it
 shouldn't be too hard to add it to other built-in fields like timeworked
 too (there's a short description on the page).

Ahhh I didn't spot that when I looked earlier, looks like it will do the job
perfectly :)

Many thanks.

Huw



s2s company email disclaimer: 
http://www.s2s.ltd.uk/datasheets/email_disclaimer.pdf
s2s company registration number : 3952958
s2s VAT registration number : GB763132055
Business premises   : Ground Floor, Overline House, Crawley, West 
Sussex, RH10 1JA
Registered address  : 29 High Street, Crawley, West Sussex, RH10 1BQ
Place of registration   : England

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Strange custom field performance issue after upgrading to RT 3.6.4

2007-10-23 Thread Matthew Goheen
We are in the process of upgrading our RT installation from 3.4.2 (to 3.6.4).
As part of the upgrade, we were planning to restructure RT to allow additional
groups within our lab use RT (previously we just used it within our own group).
Part of that plan involved moving from having multiple queues for our group to
using just a single queue and using a custom field to store what was previously
the queue name.  I performed that change with no problem -- however, performance
on SOME queries that include custom fields is so slow that it is unusable.

Here is the system background:
RT 3.6.4
RHEL 5 (with all updates through last week)
Postgres 8.1.9-1.el5
Apache 2.2.3.7.el5
mod_perl 2.0.2-6.3.el5
SearchBuilder 1.49

The system has only about 7000 tickets and about 100 or so users (only about 10
have rights to RT).

The following query takes something like 165 seconds and returns three records:

SELECT DISTINCT main.* FROM Tickets main JOIN ObjectCustomFields 
ObjectCustomFields_1  
ON ( ObjectCustomFields_1.ObjectId = '0' ) OR ( ObjectCustomFields_1.ObjectId = 
main.Queue ) 
JOIN CustomFields CustomFields_2  ON ( CustomFields_2.id = 
ObjectCustomFields_1.CustomField ) 
JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3  ON ( 
ObjectCustomFieldValues_3.ObjectId = main.id ) 
AND ( ObjectCustomFieldValues_3.Disabled = '0' ) 
AND ( ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket' ) 
AND ( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id )  
WHERE (CustomFields_2.Name = 'Category') AND (main.Status != 'deleted') AND 
(main.Owner = '368' 
AND  ( main.Status = 'new' OR main.Status = 'open' OR main.Status = 'stalled' ) 
 
AND main.Queue = '5' AND  ( ObjectCustomFieldValues_3.Content = 'General' ) ) 
AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)  
ORDER BY main.id ASC

Here is the Postgres explain plan output:

QUERY PLAN  

  
--
 Unique  (cost=17.16..17.23 rows=1 width=620) (actual 
time=165267.134..165267.161 rows=3 loops=1)
   -  Sort  (cost=17.16..17.17 rows=1 width=620) (actual 
time=165267.127..165267.133 rows=3 loops=1)
 Sort Key: main.id, main.effectiveid, main.queue, main.type, 
main.issuestatement, main.resolution, main.owner, main.subject, 
main.initialpriority, main.finalpriority, main.priority, main.timeestimated, 
main.timeworked, main.status, main.timeleft, main.told, main.starts, 
main.started, main.due, main.resolved, main.lastupdatedby, main.lastupdated, 
main.creator, main.created, main.disabled
 -  Nested Loop  (cost=5.02..17.15 rows=1 width=620) (actual 
time=32924.858..165266.929 rows=3 loops=1)
   Join Filter: (((outer.objectid = 0) OR (outer.objectid = 
inner.queue)) AND (outer.objectid = inner.id))
   -  Nested Loop  (cost=0.00..8.09 rows=1 width=8) (actual 
time=0.124..555.995 rows=53712 loops=1)
 -  Nested Loop  (cost=0.00..2.07 rows=1 width=12) (actual 
time=0.032..0.180 rows=9 loops=1)
   Join Filter: (outer.id = inner.customfield)
   -  Seq Scan on customfields customfields_2  
(cost=0.00..1.02 rows=1 width=4) (actual time=0.018..0.036 rows=1 loops=1)
 Filter: ((name)::text = 'Category'::text)
   -  Seq Scan on objectcustomfields 
objectcustomfields_1  (cost=0.00..1.02 rows=2 width=8) (actual 
time=0.005..0.063 rows=17 loops=1)
 -  Index Scan using objectcustomfieldvalues2 on 
objectcustomfieldvalues objectcustomfieldvalues_3  (cost=0.00..6.00 rows=1 
width=8) (actual time=0.044..35.073 rows=5968 loops=9)
   Index Cond: ((objectcustomfieldvalues_3.customfield 
= outer.id) AND ((objectcustomfieldvalues_3.objecttype)::text = 
'RT::Ticket'::text))
   Filter: ((disabled = 0) AND ((content)::text = 
'General'::text))
   -  Bitmap Heap Scan on tickets main  (cost=5.02..9.05 rows=1 
width=620) (actual time=3.002..3.052 rows=3 loops=53712)
 Recheck Cond: ((owner = 368) AND (queue = 5))
 Filter: (((status)::text  'deleted'::text) AND 
(((status)::text = 'new'::text) OR ((status)::text = 'open'::text) OR 
((status)::text = 'stalled'::text)) AND ((type)::text = 'ticket'::text) AND 
(effectiveid = id))
 -  BitmapAnd  (cost=5.02..5.02 rows=1 width=0) (actual 
time=2.513..2.513 rows=0 loops=53712)
   -  Bitmap Index Scan on tickets2  (cost=0.00..2.39 
rows=110 width=0) (actual time=0.148..0.148 rows=910 loops=53712)
 Index Cond: (owner = 368)
   -  Bitmap Index Scan on tickets1  (cost=0.00..2.39 
rows=110 width=0) (actual time=2.325..2.325 rows=19050 

Re: [rt-users] Strange custom field performance issue after upgrading to RT 3.6.4

2007-10-23 Thread Jesse Vincent


On Oct 23, 2007, at 8:59 AM, Matthew Goheen wrote:

We are in the process of upgrading our RT installation from 3.4.2  
(to 3.6.4).
As part of the upgrade, we were planning to restructure RT to allow  
additional
groups within our lab use RT (previously we just used it within our  
own group).
Part of that plan involved moving from having multiple queues for  
our group to
using just a single queue and using a custom field to store what  
was previously
the queue name.  I performed that change with no problem --  
however, performance

on SOME queries that include cust



Have you done a FULL VACUUM ANALYZE recently? It looks like the  
statistics engine is...confused. That's the best way to reset it.



om fields is so slow that it is unusable.

Here is the system background:
RT 3.6.4
RHEL 5 (with all updates through last week)
Postgres 8.1.9-1.el5
Apache 2.2.3.7.el5
mod_perl 2.0.2-6.3.el5
SearchBuilder 1.49

The system has only about 7000 tickets and about 100 or so users  
(only about 10

have rights to RT).

The following query takes something like 165 seconds and returns  
three records:


SELECT DISTINCT main.* FROM Tickets main JOIN ObjectCustomFields  
ObjectCustomFields_1
ON ( ObjectCustomFields_1.ObjectId = '0' ) OR  
( ObjectCustomFields_1.ObjectId = main.Queue )
JOIN CustomFields CustomFields_2  ON ( CustomFields_2.id =  
ObjectCustomFields_1.CustomField )
JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3  ON  
( ObjectCustomFieldValues_3.ObjectId = main.id )

AND ( ObjectCustomFieldValues_3.Disabled = '0' )
AND ( ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket' )
AND ( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id )
WHERE (CustomFields_2.Name = 'Category') AND (main.Status !=  
'deleted') AND (main.Owner = '368'
AND  ( main.Status = 'new' OR main.Status = 'open' OR main.Status =  
'stalled' )
AND main.Queue = '5' AND  ( ObjectCustomFieldValues_3.Content =  
'General' ) )

AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)
ORDER BY main.id ASC

Here is the Postgres explain plan output:

QUERY PLAN
--
 Unique  (cost=17.16..17.23 rows=1 width=620) (actual  
time=165267.134..165267.161 rows=3 loops=1)
   -  Sort  (cost=17.16..17.17 rows=1 width=620) (actual  
time=165267.127..165267.133 rows=3 loops=1)
 Sort Key: main.id, main.effectiveid, main.queue,  
main.type, main.issuestatement, main.resolution, main.owner,  
main.subject, main.initialpriority, main.finalpriority,  
main.priority, main.timeestimated, main.timeworked, main.status,  
main.timeleft, main.told, main.starts, main.started, main.due,  
main.resolved, main.lastupdatedby, main.lastupdated, main.creator,  
main.created, main.disabled
 -  Nested Loop  (cost=5.02..17.15 rows=1 width=620)  
(actual time=32924.858..165266.929 rows=3 loops=1)
   Join Filter: (((outer.objectid = 0) OR  
(outer.objectid = inner.queue)) AND (outer.objectid =  
inner.id))
   -  Nested Loop  (cost=0.00..8.09 rows=1 width=8)  
(actual time=0.124..555.995 rows=53712 loops=1)
 -  Nested Loop  (cost=0.00..2.07 rows=1  
width=12) (actual time=0.032..0.180 rows=9 loops=1)
   Join Filter: (outer.id =  
inner.customfield)
   -  Seq Scan on customfields  
customfields_2  (cost=0.00..1.02 rows=1 width=4) (actual  
time=0.018..0.036 rows=1 loops=1)
 Filter: ((name)::text =  
'Category'::text)
   -  Seq Scan on objectcustomfields  
objectcustomfields_1  (cost=0.00..1.02 rows=2 width=8) (actual  
time=0.005..0.063 rows=17 loops=1)
 -  Index Scan using objectcustomfieldvalues2  
on objectcustomfieldvalues objectcustomfieldvalues_3   
(cost=0.00..6.00 rows=1 width=8) (actual time=0.044..35.073  
rows=5968 loops=9)
   Index Cond:  
((objectcustomfieldvalues_3.customfield = outer.id) AND  
((objectcustomfieldvalues_3.objecttype)::text = 'RT::Ticket'::text))
   Filter: ((disabled = 0) AND  
((content)::text = 'General'::text))
   -  Bitmap Heap Scan on tickets main   
(cost=5.02..9.05 rows=1 width=620) (actual time=3.002..3.052 rows=3  
loops=53712)

 Recheck Cond: ((owner = 368) AND (queue = 5))
 Filter: (((status)::text  'deleted'::text)  
AND (((status)::text = 'new'::text) OR ((status)::text =  
'open'::text) OR ((status)::text = 'stalled'::text)) AND  
((type)::text = 'ticket'::text) AND (effectiveid = id))
 -  BitmapAnd  (cost=5.02..5.02 rows=1  
width=0) (actual time=2.513..2.513 rows=0 loops=53712)
   -  Bitmap Index Scan on tickets2   
(cost=0.00..2.39 rows=110 width=0) (actual time=0.148..0.148  
rows=910 loops=53712)

 Index Cond: (owner = 368)
   -  Bitmap Index Scan on tickets1   
(cost=0.00..2.39 

[rt-users] RT 3.6.3 default queue setting and quick ticket creation

2007-10-23 Thread o . nash

We are fairly new users of RT and have not tried much customization yet.
The 2 default queues General and External are all we use.

2 things bothering me:-
1) the default queue setting can't find it.
2) 'Quick ticket creation' OR 'new ticket'

These are related since we just have 2 queues.
but when we use either of the methods 1) or 2) above to created a ticket 
they alwas default into the External queue.


How do we change this?

I have seen a web pages about a patch to do this, is this really 
necessary?


thanks
Oliver


--
Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:[EMAIL PROTECTED]
PHONE:+35321 4902972

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



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] Problem with RT::Logger

2007-10-23 Thread Lamers, Dan
I have solved this problem by adding the following line to my
CurrentUser_Local.pm

 

Package RT::Interface::Web;

 

I still don't understand why it worked before without the added line?
Perhaps this is related to the 3.6.4 to 3.6.5 upgrade?

 

Hopefully this will help anyone else who runs into similar issues running
CurrentUser_Local.pm ldap overlay.

 

Dan

 

   _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lamers, Dan
Sent: Monday, October 22, 2007 3:38 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Problem with RT::Logger

 

I had a working RT system up until this morning when it appears that
RT::Logger stopped functioning.  Last week I upgraded from 3.6.4 to 3.6.5
and everything appeared to work fine.  I shutdown the system for the weekend
and this morning I'm receiving a 500 Internal Server Error when trying to
logon.  

 

My apache2/errorlog entry is:
  Can't call method debug on an undefined value at
/opt/rt3/local/lib/RT/CurrentUser_Local.pm line 59

 

The relevant perl line is

  $RT::Logger-debug( CreateFromExternalUserInfo: entered with args: ,
@lookupargs, \n);

 

 

If I comment this line from the program, it proceeds to fail on the next
RT::Logger statement including RT::Logger-info calls.  If I comment out all
of the RT::Logger calls from this program, the system appears to function
normally.  

 

Any help would be greatly appreciated!

 

Thanks,

Dan



DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you. 





DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee.  Access to this
message by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful.  Please immediately contact the sender if you have received this
message in error. Thank you. 


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] LimitCustomField

2007-10-23 Thread Wes Young
Hi all,

I'm working on some code for RTIR and dealing heavily with CF's.

I'm trying to build the following package:



package RT::Search::TicketHistoryByAddress;

use strict;
use base qw(RT::Search::Generic);

use constant QUEUE  = 'Incidents';
use constant CF = 'ARS_IP';
use constant LIMIT  = 7;

sub Prepare  {
my $self = shift;

my $address = $self-Argument();

$self-TicketsObj-LimitQueue(VALUE = QUEUE());
$self-TicketsObj-LimitCustomField(
CUSTOMFIELD = CF(),
OPERATOR= 'LIKE',
VALUE   = $address,
);

return(1);
}

1;



I'm trying to test it with the rt-cron tool (it's just easier that way).
When given the command:

$ bin/rt-crontool --search RT::Search::TicketHistoryByAddress
--search-arg 128.205.xxx.xxx --action RT::Action::EscalatePriority
--action-arg 99 --verbose

I get the following error:

[Tue Oct 23 13:18:42 2007] [crit]: RT::CustomField::Queue Unimplemented
in RT::Tickets. (/opt/rt3/lib/RT/Tickets_Overlay.pm line 2470)
(/opt/rt3/lib/RT.pm:342)
RT::CustomField::Queue Unimplemented in RT::Tickets.
(/opt/rt3/lib/RT/Tickets_Overlay.pm line 2470) 

I've used various flavors of this code, and anytime I try to call
LimitCustomField, I get this error...

I've been looking everywhere (including the RT Essentials book) for
something to explain this. I've been poking around Tickets.pm,
Tickets_Overlay.pm, etc... Just wanted to see if I was missing something
dumb before I started down a black hole

Currently using RT v3.7.13 on Perl 5.8.8
-- 
Wes Young
Network Security Analyst
University at Buffalo
 ---
| my OpenID:| http://tinyurl.com/2zu2d3 |
 ---

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] RT 3.6.5 Changes at Approval mechanism?

2007-10-23 Thread Ham MI-ID, Torsten Brumm
Hi RT Users, Bestpractical,

After successfuly migration to RT 3.6.5 (from 3.6.3) we figured out,
that the Approval function (create a approval) must be changed.

Until our migration we created approval tickets in this way (from wiki)

OnCreate - CreateTicket - Template: Approval

Approval Template:

===Create-Ticket: SYSTEM
Subject: Approval for ticket: {$Tickets{TOP}-Id} -
{$Tickets{TOP}-Subject}
Depended-On-By: TOP
Refers-To: {$Tickets{'TOP'}-Id()}
Queue: APPROVAL-KN.DE.CR.GENERAL 
Type: approval
Requestor: {$Tickets{'TOP'}-RequestorAddresses()}
AdminCC: {
   my $group_name  = 'APPROVAL-KN.DE.CR.GENERAL';
   my $groups  = RT::Groups-new( $RT::SystemUser );

   $groups-LimitToUserDefinedGroups();
   $groups-Limit(
 'FIELD'= 'Name',
 'OPERATOR' = '=',
 'VALUE'= $group_name );
   $groups-First-Id;
}
Content-Type: text/plain
Content: Your approval is requested for the ticket
{$Tickets{TOP}-Id}: {$Tickets{TOP}-Subject}

{$Transaction-Content('TOP')}
ENDOFCONTENT

--

This worked well until we migrated.

Now we get the following error (from rt3.log):

Subject: Approval for system change: {$Tickets{TOP}-Id} -
{$Tickets{TOP}-Subject}
Depended-On-By: TOP
Refers-To: {$Tickets{'TOP'}-Id()}
Queue: APPROVAL-KN.DE.CR.SYSTEM
Type: approval
Requestor: {$Tickets{'TOP'}-RequestorAddresses()}
AdminCC: {
   my $group_name  = 'APPROVAL-KN.DE.CR.SYSTEM';
   my $groups  = RT::Groups-new( $RT::SystemUser );

   $groups-LimitToUserDefinedGroups();
   $groups-Limit(
 'FIELD'= 'Name',
 'OPERATOR' = '=',
 'VALUE'= $group_name );
   $groups-First-Id;
}
Content-Type: text/plain
Content: Your approval is requested for the ticket
{$Tickets{TOP}-Id}: {$Tickets{TOP}-Subject}

{$Transaction-Content('TOP')}
ENDOFCONTENT (/opt/rt3/lib/RT/Action/CreateTickets.pm:881)
[Tue Oct 23 15:32:57 2007] [debug]: Workflow: yielding
Subject: Approval for system change: 833392 - TEST
Depended-On-By: TOP
Refers-To: 833392
Queue: APPROVAL-KN.DE.CR.SYSTEM
Type: approval
Requestor: [EMAIL PROTECTED]
AdminCC: 3342710
Content-Type: text/plain
Content: Your approval is requested for the ticket 833392: TEST

Can't call method Content on an undefined value at template line 21.

Stack:
  [template:21]
  [/opt/rt3/lib/RT/Action/CreateTickets.pm:895]
  [/opt/rt3/lib/RT/Action/CreateTickets.pm:594]
  [/opt/rt3/lib/RT/Action/CreateTickets.pm:531]
  [/opt/rt3/lib/RT/ScripAction_Overlay.pm:242]
  [/opt/rt3/local/lib/RT/Scrip_Overlay.pm:522]
  [/opt/rt3/lib/RT/Scrips_Overlay.pm:195]
  [/opt/rt3/lib/RT/Transaction_Overlay.pm:181]
  [/opt/rt3/lib/RT/Record.pm:1461]
  [/opt/rt3/lib/RT/Ticket_Overlay.pm:746]
  [/opt/rt3/lib/RT/Interface/Web.pm:461]
  [/opt/rt3/local/html/Ticket/Display.html:71]
  [/opt/rt3/local/html/Ticket/Create.html:353]
  [/opt/rt3/share/html/autohandler:291]

ENDOFCONTENT (/opt/rt3/lib/RT/Action/CreateTickets.pm:897)
[Tue Oct 23 15:32:57 2007] [error]: Ticket creation failed: Can't call
method Content on an undefined value at template line 21.

Stack:
  [template:21]
  [/opt/rt3/lib/RT/Action/CreateTickets.pm:895]
  [/opt/rt3/lib/RT/Action/CreateTickets.pm:594]
  [/opt/rt3/lib/RT/Action/CreateTickets.pm:531]
  [/opt/rt3/lib/RT/ScripAction_Overlay.pm:242]
  [/opt/rt3/local/lib/RT/Scrip_Overlay.pm:522]
  [/opt/rt3/lib/RT/Scrips_Overlay.pm:195]
  [/opt/rt3/lib/RT/Transaction_Overlay.pm:181]
  [/opt/rt3/lib/RT/Record.pm:1461]
  [/opt/rt3/lib/RT/Ticket_Overlay.pm:746]
  [/opt/rt3/lib/RT/Interface/Web.pm:461]
  [/opt/rt3/local/html/Ticket/Display.html:71]
  [/opt/rt3/local/html/Ticket/Create.html:353]
  [/opt/rt3/share/html/autohandler:291]
(/opt/rt3/lib/RT/Action/CreateTickets.pm:900)

--end

Is this a know error? Or are there some changes? This is a real NO GO
Situation to switch back.

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Strange custom field performance issue after upgrading to RT 3.6.4

2007-10-23 Thread Matthew Goheen
 Have you done a FULL VACUUM ANALYZE recently? It looks like the  
 statistics engine is...confused. That's the best way to reset it.

I didn't think that would help as the data was just imported a week ago, and
almost nothing has been done to the database since.

However, this morning I tried upgrading to the latest Postgres (8.2.5) and
that totally fixed the problem.  I will try going back to the old database
just to ensure that the FULL VACUUM ANALYZE will NOT fix it, but at this
point I'm fairly certain there must have been some sort of database issue
in the Postgres that ships with RHEL5.

I'll send a follow-up with the final result of that test.

- Matt

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Strange custom field performance issue after upgrading to RT 3.6.4

2007-10-23 Thread Matthew Goheen
Well, I take that back -- I guess I should have tried the vacuum full analyze
first, as that ALSO fixed the problem in the original (RHEL5 Postgres) database.

I guess I'll go back to the old database version.

I don't know why the NEW Postgres could import the data just fine and work
well whereas the old version had problems...

- Matt

 -Original Message-
 From: Matthew Goheen [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, October 23, 2007 11:48 AM
 To: 'Jesse Vincent'
 Cc: 'rt-users@lists.bestpractical.com'
 Subject: RE: [rt-users] Strange custom field performance 
 issue after upgrading to RT 3.6.4
 
  Have you done a FULL VACUUM ANALYZE recently? It looks like the  
  statistics engine is...confused. That's the best way to reset it.
 
 I didn't think that would help as the data was just imported a week ago, and
 almost nothing has been done to the database since.
 
 However, this morning I tried upgrading to the latest Postgres (8.2.5) and
 that totally fixed the problem.  I will try going back to the old database
 just to ensure that the FULL VACUUM ANALYZE will NOT fix it, but at this
 point I'm fairly certain there must have been some sort of database issue
 in the Postgres that ships with RHEL5.
 
 I'll send a follow-up with the final result of that test.
 
   - Matt

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Two questions regarding an upgrade installation

2007-10-23 Thread Erik Anderson
All - we've been running on an install of rt-3.2.0 for several years
now and I've decided it's time to upgrade.  I have two questions so
far:

1. I've installed rt-3.6.5 on a different server and have initialized
the db.  I can get to the login page of RT and can login with the
default root user and password.  However, when I click on any of the
links in RT, I'm sent back to the login screen.

After logging in, I can see that RT sets a cookie as well as inserting
a matching row into the sessions table. My DB is mysql-5.0.42, and I'm
running on apache-2.0.58/mod_perl2

2. After resolving the above issue, what's the best way to bring my
old rt database over. Ideally, I'd like to run a mysqldump of the old
database and import it into the new server.  At that point, I'd
imagine I'd need to run some sort of db schema update script, correct?
 I didn't see anything obvious in the wiki about this.

Thank you
-Erik

-- 
Erik Anderson
http://andersonfam.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Two questions regarding an upgrade installation

2007-10-23 Thread Patterson, Craig
Check out the README that is included with the rt tar.  

Basically you need to...
1.  cd into the directory that you unpacked the rtX.X.X.tar into(not the
folder you installed rt into).  

2. ls the etc/upgrade folder.  

3.  For each folder higher than your current version
  {rt-home}/sbin/rt-setup-database --action schema --datadir
etc/upgrade/[version] --dba rt --dba-password *

  {rt-home}/sbin/rt-setup-database --action acl  --datadir
etc/upgrade/[version] --dba rt --dba-password *

  {rt-home}/sbin/rt-setup-database --action insert --datadir
etc/upgrade/[version] --dba rt --dba-password **

Depending on what variables to set in your RT_SiteConfig, you'll have to
set different options in the above commands.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erik
Anderson
Sent: Tuesday, October 23, 2007 12:42 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Two questions regarding an upgrade installation

All - we've been running on an install of rt-3.2.0 for several years
now and I've decided it's time to upgrade.  I have two questions so
far:

1. I've installed rt-3.6.5 on a different server and have initialized
the db.  I can get to the login page of RT and can login with the
default root user and password.  However, when I click on any of the
links in RT, I'm sent back to the login screen.

After logging in, I can see that RT sets a cookie as well as inserting
a matching row into the sessions table. My DB is mysql-5.0.42, and I'm
running on apache-2.0.58/mod_perl2

2. After resolving the above issue, what's the best way to bring my
old rt database over. Ideally, I'd like to run a mysqldump of the old
database and import it into the new server.  At that point, I'd
imagine I'd need to run some sort of db schema update script, correct?
 I didn't see anything obvious in the wiki about this.

Thank you
-Erik

-- 
Erik Anderson
http://andersonfam.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll
take
up to 20 percent off the price. This sale won't last long, so get in
touch today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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 tickets resolved and tickets unowned list problem

2007-10-23 Thread Kenneth Crocker

DSA,


	We have RT 3.4.5 and have set or privileges to not allow just any 
privileged user to see tickets they have no relation to and do not have 
this problem. The modification of your code seems a bit of over kill 
when the result you seem to be looking for can be accomplished with more 
specific allocation of rights. What do you have for your global and 
queue rights for systems groups, roles, groups, and users? Perhaps we 
can simplify this.



Kenn
LBNL

On 10/22/2007 1:53 AM, dsa sadf wrote:

Hi everyone,

I am using RT 3.4.5, running on a CentOS box. I was trying to restrict 
some privileged users from seeing tickets on queues they weren't allowed 
to. I managed to do that but in the process caused the 'Top 10 Resolved 
tickets' and 'Top 10 Unowned tickets' lists to display inaccurate 
tickets. For example, the 'Top 10 Resolved tickets' list shows some 
unowned and new tickets and the 'Top 10 Unowned tickets' list shows some 
resolved tickets.


I had added the following code to my 'MyRequests' file in order to 
restrict queue access for that user:


my $Queues = RT::Queues-new($session{'CurrentUser'});
$Queues-UnLimit();
my $myQueues = ;
while (my $queue = $Queues-Next) {
   next unless ($queue-CurrentUserHasRight('ShowTicket'));
   $myQueues .=  OR Queue = ' . $queue-Name . ';
}
$myQueues =~ s/^ OR //g;


my $Query = Owner = 'Nobody' AND $myQueues AND ( Status = 'new' OR 
Status = 'open');


and for the 'MyResolved' file, the same code except for the last line 
which reads:


my $Query = Owner = 'Nobody' AND $myQueues AND ( Status = 'resolved);


Could anyone help me identify what the problem could be?


Regards,

Raj

__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.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

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



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] Two questions regarding an upgrade installation

2007-10-23 Thread Erik Anderson
Thanks Craig - that worked perfectly.  I should have looked around a
bit more before posting.

Anyway - does anyone have any clue as to my login session problem?

-erik

On 10/23/07, Patterson, Craig [EMAIL PROTECTED] wrote:
 Check out the README that is included with the rt tar.

 Basically you need to...
 1.  cd into the directory that you unpacked the rtX.X.X.tar into(not the
 folder you installed rt into).

 2. ls the etc/upgrade folder.

 3.  For each folder higher than your current version
   {rt-home}/sbin/rt-setup-database --action schema --datadir
 etc/upgrade/[version] --dba rt --dba-password *

   {rt-home}/sbin/rt-setup-database --action acl  --datadir
 etc/upgrade/[version] --dba rt --dba-password *

   {rt-home}/sbin/rt-setup-database --action insert --datadir
 etc/upgrade/[version] --dba rt --dba-password **

 Depending on what variables to set in your RT_SiteConfig, you'll have to
 set different options in the above commands.


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Erik
 Anderson
 Sent: Tuesday, October 23, 2007 12:42 PM
 To: rt-users@lists.bestpractical.com
 Subject: [rt-users] Two questions regarding an upgrade installation

 All - we've been running on an install of rt-3.2.0 for several years
 now and I've decided it's time to upgrade.  I have two questions so
 far:

 1. I've installed rt-3.6.5 on a different server and have initialized
 the db.  I can get to the login page of RT and can login with the
 default root user and password.  However, when I click on any of the
 links in RT, I'm sent back to the login screen.

 After logging in, I can see that RT sets a cookie as well as inserting
 a matching row into the sessions table. My DB is mysql-5.0.42, and I'm
 running on apache-2.0.58/mod_perl2

 2. After resolving the above issue, what's the best way to bring my
 old rt database over. Ideally, I'd like to run a mysqldump of the old
 database and import it into the new server.  At that point, I'd
 imagine I'd need to run some sort of db schema update script, correct?
  I didn't see anything obvious in the wiki about this.

 Thank you
 -Erik

 --
 Erik Anderson
 http://andersonfam.org
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

 If you sign up for a new RT support contract before December 31, we'll
 take
 up to 20 percent off the price. This sale won't last long, so get in
 touch today.
 Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


 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



-- 
Erik Anderson
http://andersonfam.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Two questions regarding an upgrade installation

2007-10-23 Thread Erik Anderson
On 10/23/07, Erik Anderson [EMAIL PROTECTED] wrote:
 Thanks Craig - that worked perfectly.  I should have looked around a
 bit more before posting.

 Anyway - does anyone have any clue as to my login session problem?

This has been resolved - there was a little snippet at the bottom of
one of the wiki pages:

---
A table structure issue: take a look at the sessions table in the RT
database. There should be a column named a_session. This column must
have the type longblob not longtext. Also note that if there are
any records in the table, the entire table should be emptied (either
before or after making the change), otherwise the problem will
persist.
---

I changed the a_session column type to LONGBLOB and the problem went away.

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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 3.6.3 default queue setting and quick ticket creation

2007-10-23 Thread o . nash

To suggest one answer to my own question 2)
Dane Rapaport in a previous post gave this:
His version was slightly different prob using an older version of RT.
I did similar kludge!! ;)
make backup copy of Queues_Overlay.pm in lib/RT
edit around line 80
  # By default, order by name
  $self-OrderBy( ALIAS = 'main',
  FIELD = 'Name',
  ORDER = 'DES');
Change order to DES as above and restart apache.

--


On Tue, 23 Oct 2007, [EMAIL PROTECTED] wrote:


We are fairly new users of RT and have not tried much customization yet.
The 2 default queues General and External are all we use.

2 things bothering me:-
1) the default queue setting can't find it.
2) 'Quick ticket creation' OR 'new ticket'

These are related since we just have 2 queues.
but when we use either of the methods 1) or 2) above to created a ticket they 
alwas default into the External queue.


How do we change this?

I have seen a web pages about a patch to do this, is this really necessary?

thanks
Oliver


--
Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:[EMAIL PROTECTED]
PHONE:+35321 4902972

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today.Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



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




--
Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:[EMAIL PROTECTED]
PHONE:+35321 4902972

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



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] Rt-mailgate server error weirdness

2007-10-23 Thread Paul
Hi There

I'm relatively new to RT but so far it's proven to be a very useful tool! I
am having a slight problem after setting it up on a new server/upgrading to
RT 3.6, specifically where my Exim setup tries to deliver messages to RT
queues.

My current setup details:

Debian etch
Apache 2
Mysql 5.0.32
Exim 4
RT 3.6

The frontend is 100 % operational, and outbound RT responses are sent
succesfully. But I'm struggling to find an answer for what happens below.
The following is an extract of my exim log file:

2007-10-23 22:24:46 1IjryT-0003tY-4j == |/usr/local/rt3/bin/rt-mailgate
--queue Administration --action correspond --url http://localhost/ 
[EMAIL PROTECTED] R=rt_correspond T=address_pipe defer (0): Child process of
address_pipe transport returned 75 (could mean temporary error) from
command: /usr/local/rt3/bin/rt-mailgate

This led me to try and run the command being used manually, but the output
as you can see below isn't really a direct error and confusing me :P



rt-server:/home/paul# cat ./mail.msg | /usr/local/rt3/bin/rt-mailgate
--queue Administration --action correspond --url http://localhost/
RT server error.

The RT server which handled your email did not behave as expected. It
said:

%# BEGIN BPS TAGGED BLOCK {{{
%#
%# COPYRIGHT:
%#
%# This software is Copyright (c) 1996-2007 Best Practical Solutions, LLC
%#  [EMAIL PROTECTED]
%#
%# (Except where explicitly superseded by other copyright notices)
%#
%#
%# LICENSE:
%#
%# This work is made available to you under the terms of Version 2 of
%# the GNU General Public License. A copy of that license should have
%# been provided with this software, but in any event can be snarfed
%# from www.gnu.org.
%#
%# This work is distributed in the hope that it will be useful, but
%# WITHOUT ANY WARRANTY; without even the implied warranty of
%# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
%# General Public License for more details.
%#
%# You should have received a copy of the GNU General Public License
%# along with this program; if not, write to the Free Software
%# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
%# 02110-1301 or visit their web page on the internet at
%# http://www.gnu.org/copyleft/gpl.html.
%#
%#
%# CONTRIBUTION SUBMISSION POLICY:
%#
%# (The following paragraph is not intended to limit the rights granted
%# to you to modify and distribute this software under the terms of
%# the GNU General Public License and is only of importance to you if
%# you choose to contribute your changes and enhancements to the
%# community by submitting them to Best Practical Solutions, LLC.)
%#
%# By intentionally submitting any modifications, corrections or
%# derivatives to this work, or any other work intended for use with
%# Request Tracker, to Best Practical Solutions, LLC, you confirm that
%# you are the copyright holder for those contributions and you grant
%# Best Practical Solutions,  LLC a nonexclusive, worldwide, irrevocable,
%# royalty-free, perpetual, license to use, copy, create derivative
%# works based on those contributions, and sublicense and distribute
%# those contributions and any derivatives thereof.
%#
%# END BPS TAGGED BLOCK }}}
%flags
inherit = undef # inhibit UTF8 conversion done in /autohandler
/%flags
%ARGS
$queue = 1
$action = correspond
$ticket = undef
/%ARGS
%init
$m-comp('/Elements/Callback', _CallbackName = 'Pre', %ARGS);
use RT::Interface::Email ();# It's an exporter, but we don't care
$r-content_type('text/plain; charset=utf-8');
$m-error_format('text');
my ( $status, $error, $Ticket ) = RT::Interface::Email::Gateway( \%ARGS );
if ( $status == 1 ) {
  $m-out('ok');
  if ( $Ticket-Id ) {
$m-out( 'Ticket: '  . ($Ticket-Id || '') );
$m-out( 'Queue: '   . ($Ticket-QueueObj-Name || '') );
$m-out( 'Owner: '   . ($Ticket-OwnerObj-Name || '') );
$m-out( 'Status: '  . ($Ticket-Status || '') );
$m-out( 'Subject: ' . ($Ticket-Subject|| '') );
$m-out(
  'Requestor: ' . ($Ticket-Requestors-MemberEmailAddressesAsString ||
'') );
  }
}
else {
  $RT::Logger-error( Could not record email:  . $error );
  if ( $status == -75 ) {
$m-out( temporary failure -  . $error );
  }
  else {
$m-out( 'not ok - ' . $error );
  }
}
$m-abort();
/%init

rt-server:/home/paul#




As you can see there's no real error to look for. I've been googling
forever trying to find a answer, but every case i've looked at least has
some kind of proper error to more or less identify the issue.
/usr/local/rt3/bin/rt-mailgate  has execute permissions, and the shebang's
are also correct (#!/usr/bin/perl -w).

I hope someone can point me in the right direction :)

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. 

[rt-users] Can't locate object method tmp_recycling

2007-10-23 Thread Duane Hill

I'm setting up RT v3.6.4 on FreeBSD 6.2 using Postfix v2.4.6 as the
MTA. MIME-tools-5.423 is installed as well. I attempted to send a
message to the email address I have aliased per the instructions in
the README file. However, I am getting the following as an error:

RT server error.  The RT server which handled your email did not behave
as expected. It said:  Can't locate object method tmp_recycling via
package MIME::Parser at /usr/local/rt3/lib/RT/EmailParser.pm line
618.  Stack:   [/usr/local/rt3/lib/RT/EmailParser.pm:618]
[/usr/local/rt3/lib/RT/EmailParser.pm:227]
[/usr/local/rt3/lib/RT/EmailParser.pm:179]
[/usr/local/rt3/lib/RT/EmailParser.pm:139]
[/usr/local/rt3/lib/RT/Interface/Email.pm:549]
[/usr/local/rt3/share/html/REST/1.0/NoAuth/mail-gateway:61])

Can someone shed some light on what may be going on?

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Can't locate object method tmp_recycling

2007-10-23 Thread Ruslan Zakirov
either upgrade to RT 3.6.5 or downgrade MIME::Entity to version 5.420

On 10/24/07, Duane Hill [EMAIL PROTECTED] wrote:

 I'm setting up RT v3.6.4 on FreeBSD 6.2 using Postfix v2.4.6 as the
 MTA. MIME-tools-5.423 is installed as well. I attempted to send a
 message to the email address I have aliased per the instructions in
 the README file. However, I am getting the following as an error:

 RT server error.  The RT server which handled your email did not behave
 as expected. It said:  Can't locate object method tmp_recycling via
 package MIME::Parser at /usr/local/rt3/lib/RT/EmailParser.pm line
 618.  Stack:   [/usr/local/rt3/lib/RT/EmailParser.pm:618]
 [/usr/local/rt3/lib/RT/EmailParser.pm:227]
 [/usr/local/rt3/lib/RT/EmailParser.pm:179]
 [/usr/local/rt3/lib/RT/EmailParser.pm:139]
 [/usr/local/rt3/lib/RT/Interface/Email.pm:549]
 [/usr/local/rt3/share/html/REST/1.0/NoAuth/mail-gateway:61])

 Can someone shed some light on what may be going on?

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

 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

 If you sign up for a new RT support contract before December 31, we'll take
 up to 20 percent off the price. This sale won't last long, so get in touch 
 today.
 Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


 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



-- 
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Can't locate object method tmp_recycling

2007-10-23 Thread Duane Hill
On Wed, 24 Oct 2007 04:11:17 +0400
Ruslan Zakirov [EMAIL PROTECTED] confabulated:

 either upgrade to RT 3.6.5 or downgrade MIME::Entity to version 5.420

Thanks for the response. I've sent message to the port maintainer for
FreeBSD and an awaiting a response.

I did find references to a patch that went out sometime in 2004.
However. that is included in the 3.6.4 install. So, something must have
changed between.

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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] Customizing Appearance of RT :(

2007-10-23 Thread Matt Westfall
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I have edited the heck out of the files in

/opt/rt3/share/html/NoAuth/css/3.5-default

But can't get the css style changes to take.

Any advice?

Thanks,
Matt
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)

iD8DBQFHHr4gb/8X6V5MpAURAqoSAKCrfnSebRejN89rMwyG8+z3xAeXJgCeOQa1
roYMIwLS6KitUFKrj8Y/wXQ=
=B70M
-END PGP SIGNATURE-
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


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