[rt-users] GPG how to for RT 3.8.0

[Yvo van Doorn]

Unless I am blind, I have completely overlooked on how to use the gpg
feature in 3.8.0. How do I create and use keys for queues and/or
users?

Anyone have a simple how to on the use of GnuPG and keys in RT 3.8.0?
___
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: Assistance with a wget query

[Ben Robson]

My sincere apologies for wasting everyone's time.  It was a permissions
problem on the custom field.

 

Doh!

 

Thanks to everyone who thought about it for a moment.

 

BenR

 

 

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ben
Robson
Sent: Thursday, 17 July 2008 2:01 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Assistance with a wget query

 

Hi all,

 

I'm hoping someone can provide some insight/thoughts on an issue I am
having with a wget request for a page from RT.

 

If I do the following from the web browser I get exactly what I'd
expect, including all of the CustomField requested data:

 

http://rtserver.internal/AssetTracker/Search/Results.html?user=rtusernam
e&pass=rtpassword&Order=ASC&Query=Type = 'AssetType' AND Status !=
'retired'  AND 'CF.{CustomValue1}' > '0' AND Name LIKE
'AssetName'&Rows=&OrderBy=id&Format='__Name__/TITLE:Asset Name',
'__Description__/TITLE:Description', '__CustomField.{CustomerValue1}__',
'__CustomField.{CustomValue2}__'

 

However if I do the same from a command line using wget, as follows, I
get everything the same, except the table cells that previously
contained CustomValue1 and CustomValue2 are now empty.  I proved this
doing the same query using Links (Linux CLI browser) as well and get the
same outcome as wget.

 

Does anyone have any insight why the query, with formatting, works as a
bookmarkable query in a web browser but not from the commandline?

 

Thanks heaps for this.

BenR

   The information contained in this communication is intended solely
for the use of the individual or entity to whom it is addressed and
others authorised to receive it.  It may contain confidential or legally
privileged information.  If you are not the intended recipient you are
hereby notified that any disclosure, copying, distribution or taking any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful.  If you have received this communication
in error, please notify us immediately by responding to this email and
then delete it, and any associated attachments, from your system.  Thank
you. 

 

 

___
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] Assistance with a wget query

[Ben Robson]

Hi all,

 

I'm hoping someone can provide some insight/thoughts on an issue I am
having with a wget request for a page from RT.

 

If I do the following from the web browser I get exactly what I'd
expect, including all of the CustomField requested data:

 

http://rtserver.internal/AssetTracker/Search/Results.html?user=rtusernam
e&pass=rtpassword&Order=ASC&Query=Type = 'AssetType' AND Status !=
'retired'  AND 'CF.{CustomValue1}' > '0' AND Name LIKE
'AssetName'&Rows=&OrderBy=id&Format='__Name__/TITLE:Asset Name',
'__Description__/TITLE:Description', '__CustomField.{CustomerValue1}__',
'__CustomField.{CustomValue2}__'

 

However if I do the same from a command line using wget, as follows, I
get everything the same, except the table cells that previously
contained CustomValue1 and CustomValue2 are now empty.  I proved this
doing the same query using Links (Linux CLI browser) as well and get the
same outcome as wget.

 

Does anyone have any insight why the query, with formatting, works as a
bookmarkable query in a web browser but not from the commandline?

 

Thanks heaps for this.

BenR

___
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] Performance Issues after 3.8.0 upgrade -- PostgreSQL delays

[Jessie Bryan]

Update-

Ok, after several hours of logging, what I see most common in the slow
query (1s) log is:

LOG:  duration: 3151.786 ms  statement: EXECUTE   [PREPARE:
SELECT  * FROM Groups WHERE LOWER(Domain) = LOWER($1) AND LOWER(Type)
= LOWER($2)]

Several hundred of these queries in the slow query log data.
___
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] Asset tracker / Inventory management add-ons?

[Jed Lane]

Hi all,

 

I was wondering if anyone's familiar with any such add-ons for RT or even
had some experience setting one up?

 

I've come across this:

http://wiki.bestpractical.com/view/AssetTracker

Unfortunately it looks like a relatively dead project nowadays.

 

Still, I wouldn't mind have a crack at installing it!

Would it be possible to combine this with the latest major release of RT or
is too old?

 

I'm yet to actually install RT.

I was hoping to test it out on Fedora, Ubuntu, or similar in a VM.

 

Hmm, I wonder if there's any pre-rolled RT VM's?!  :-)

I guess that defeats the purpose of getting a more intimate understanding of
RT and it supporting apps etc.

 

Cheers,

Jed

___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Fernando Frota Machado de Morais]

I think my experience will not help anyone, but it's from all the others, so I 
think it can be usefull:

I had the same problem in my production RT server. But I did a brand new 
installation of RT 3.8 in my personal computer, then I removed completely the 
database and restored a copy from the production server. I had no problems 
during the execution of the script, but I had problems when I was executing 
the "sql.queries" at the line

#ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET ascii 
NOT NULL DEFAULT NULL

So, I comented the line and continue to run the script. Things are working 
well. 

Im my production server, I was not able to generate the "sql.queries" file, 
but, despite of that, things are working fine. I had to run mannually all the 
update scripts since 3.6.5, but it's ok, probably documentation will be 
updated for 3.8.1.

RT production server ir running
 mysql-server-5.0.45-6.fc7 and 
 perl-DBD-MySQL-3.0008-1.fc7 (DBD::mysql v3.0008)

My working computer is running
 mysql-server-5.0.51a-1.fc9 and
 perl-DBD-MySQL-4.005-8.fc9

but testdeps and fixdeps executed fine at both computers.

Em Wednesday 16 July 2008 16:13:24 [EMAIL PROTECTED] escreveu:
> Ruslan, thanks for sharing this.
>
>
> James Moseley
>
>
>
>
>
>  "Ruslan Zakirov"
>  <[EMAIL PROTECTED]
>  l.com> To
>  Sent by:  [EMAIL PROTECTED]
>  [EMAIL PROTECTED]  cc
>  ail.com   rt-users@lists.bestpractical.com
>Subject
>Re: [rt-users] Upgrading to 3.8.0:
>  07/16/2008 01:09  schema.mysql,column_info selection
>  PMproblem
>
>
>
>
>
>
>
>
>
>
> Let's make it clear:
> * you still must upgrade DB using files in etc/upgrade/x.x.x/
> * however in 3.8.0 you can do it using one command:
>
> rt-setup-database --dba root --prompt-for-dba-password --action upgrade
>
> it will ask for the old version (for example you can enter 3.6.7) and
> will apply all steps up to the installed version (in this case it's
> 3.8.0)
>
> * then you do mysql schema changes using the script
> * these schema changes are required for all mysql versions greater
> than mysql 4.1.0
>
> * people installing for the first time will get new DB schema as there
> are two different schema files for mysql in etc/, so they don't need
> to do all these steps
> * people upgrading mysql server from 4.0 to 4.1 and newer should use
> the script two
>
> * I tested this script several times, but only on my dev PC, so it's
> VERY recommended to backup and make tests
>
> Clear?
>
> On Wed, Jul 16, 2008 at 8:03 PM,  <[EMAIL PROTECTED]> wrote:
> > Interesting.  We're running 5.0.27 and the script worked just fine.
> > However, I ran all the schema/acl/insert upgrade commands using all the
> > 5.7.xx directories in etc/upgrade.
> >
> > Still waiting to hear from Ruslan to confirm 100% that you don't need to
> > run all these commands and you need only run the schema.mysql-4.0-4.1.pl
> > script.
> >
> > Additionally, not entirely sure, but it sounds like he acknowledges there
> > is a problem with the script.
> >
> >
> > James Moseley
> >
> >
> >
> >
> >
> > "Ryan Hardester"
> > <[EMAIL PROTECTED]
> > i.tracy.ca.us> To
> >   "Ruslan Zakirov"
> > 07/16/2008 10:41  <[EMAIL PROTECTED]>,
> > AM<[EMAIL PROTECTED]>
> >cc
> >   
> >   Subject
> >   RE: [rt-users] Upgrading to 3.8.0:
> >   schema.mysql,column_info selection
> >   problem
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I am getting the same column_info failed error message when running the
> > script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
> > the DB server since we are not running RT and the DB on the same
> > machine.
> >
> > --Ryan
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan
> > Zakirov
> > Sent: Wednesday, July 16, 2008 6:57 AM
> > To: [EMAIL PROTECTED]
> > Cc: rt-users@lists.bestpractical.com
> > Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info
> > selection problem
> >
> > In 3.8.0 it's one step :)
> >
> > However, we've done changes to mysql DB that require additional
> > upgrade steps for mysql, and this step fails.
> >
> > On Wed, Jul 16, 2008 at 5:24 PM,  <[EMAIL PROTECTED]> wrote:

Re: [rt-users] RT 3.8.0 rich text color problems

[jmoseley]

Looking through the RT_Config.pm file, I've set this in my site config
file:

Set($PreferRichText, 1);

However, colored text still does not display in emails sent by RT nor in
the ticket display view - only while creating text while commenting,
replying, etc.  Bold and italicized email displays, but not color.

No big deal, just thought I'd pass this along.


James Moseley




   
 James 
 Moseley/BTV/PEGAS 
 US To 
   rt-users@lists.bestpractical.com
 07/16/2008 03:18   cc 
 PM
   Subject 
   RT 3.8.0 rich text color problems   
   
   
   
   
   
   



When replying or commenting on a ticket, I can see the text color, if color
is selected.  When viewing the source, I can also see the span tags.

But after updating the ticket, the span tags disappear and thus the color
does too when displaying the ticket.

Am I missing something in the configuration or do I need to make some
changes to the theme files?


James Moseley



___
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 3.8 comments

[Bill Davis]

Thanks Ruslan ... items 1 & 3 turned out to be in the same set of
Callbacks originally from the University of Kent, which worked just
fine when I moved it to 3.8 from 3.6.5.  Item 2: I've opened a ticket. 


You made my day ... :o)
Bill Davis

Ruslan Zakirov wrote:

  On Thu, Jul 17, 2008 at 12:37 AM, Bill Davis <[EMAIL PROTECTED]> wrote:
  
  
Have just upgraded RT 3.6.5 to RT 3.8 and am quite impressed overall ...
kudos to all involved in its development :o) ...

... however there are a few minor things I'd like to modify:

1. Inevitably a certain amount of spam leaks through the spam filters
and creates tickets ... currently on each one that isn't obvious spam
from the title, I have to view it, select "Basics", select status
"deleted", & then click "Save Changes" ... a 3 step process. What I'd
like to do is add a "Delete" choice to the "Open --- Comment --- Reply
--- Resolve --- Star (bookmark)" bar in the upper right of the Ticket
History screen, so that one click would change the ticket status to
"deleted".  I had modified 3.6.5 to do this in accordance with someone's
contribution (whose or where I don't recall) ... but I doubt that mod
would still fit 3.8.

  
  If it's correct mod based on a callback then it still should work with 3.8.0.


  
  
2. I'd like to be able to set the default refresh interval for a least
the "At A Glance" page (in user preferences would be nice, but I'd be
happy with a RT_SiteConfig alternative.  RT defaults to "Do not refresh"
(in my opinion a poor choice), requiring this to be reset at every login.

  
  create a feature request on rt3.fsck.com

  
  
3. I'd previously configured 3.6.5 so that certain high priorities
displayed the priority number in different color,  I'd like to do the
same in 3.8 but haven't been able to locate what or where to modify (I'm
Perl ignorant ... or know just enough to be dangerous :o) ).

  
  Again if it's callbacks based mod than it still should work.

  
  
Any pointers or suggestions regarding any of these are greatly
appreciated ...

Bill Davis
___
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

Re: [rt-users] database upgrade problem

[Ruslan Zakirov]

you should read this:
http://dev.mysql.com/doc/refman/5.0/en/full-table.html

On Thu, Jul 17, 2008 at 1:21 AM, Raphael <[EMAIL PROTECTED]> wrote:
> hi all,
>
> tried to upgrade the database with the following command (from version 3.6.6
> to 3.8.0):
>
> rt-setup-database --dba root --prompt-for-dba-password --action upgrade
>
> it worked but then it stopped with this error:
>
> Processing 3.7.1
> Processing 3.7.3
> Now populating database schema.
> Processing 3.7.10
> Processing 3.7.15
> Processing 3.7.19
> Processing 3.7.81
> Now populating database schema.
> [Wed Jul 16 21:16:12 2008] [crit]: DBD::mysql::st execute failed: The table
> '#sql-41f5_43' is full at /opt/rt3/sbin/../lib/RT/Handle.pm line 463.
> (/opt/rt3/sbin/../lib/RT.pm:375)
> DBD::mysql::st execute failed: The table '#sql-41f5_43' is full at
> /opt/rt3/sbin/../lib/RT/Handle.pm line 463.
>
> can anyone help me with this?
>
> thanx,
> raphael
>
> ___
> 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
>



-- 
Best regards, Ruslan.
___
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 3.8.0 web2 CSS wierdness.

[Jesse Vincent]

On Jul 16, 2008, at 6:21 PM, Jeff Voskamp wrote:

> Jesse Vincent wrote:
>>
>> On Jul 16, 2008, at 5:36 PM, Jeff Voskamp wrote:
>>
>>> There's some nice new options for Search/Build.html (such as all  
>>> the Queue* stuff, but the label field is a bit narrow.
>>> Attached is a patch that allows me to see the tail end of such  
>>> options as "QueueAdminCC EmailAddress"  rather than just a list of  
>>> "QueueAdminC".
>>>
>> So, the problem with making things that wide in the default view is  
>> that on many browsers and screens, the query view gets cut off:/

>>
> Then the contents of the fields need to be shorter, or ragged left,  
> or something.

Patches are certainly welcome, as are entirely new themes. We've spent  
a good few developer days trying to improve the style and layout of  
just that section of the page and make it work reasonably well on  
Firefox 2 and 3, Safari, Opera and IE 6 and 7. I'm not likely to spend  
any more time on it in the near future unless it's for someone who's  
paying us or holding my family hostage.


>  the 3.4 and 3.5 skins don't specify a width so things are still  
> getting pushed around.
>

Yep. We didn't change how those themes render...well, anything for 3.8.

> Jeff

Jesse

___
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 3.8.0 web2 CSS wierdness.

[Jeff Voskamp]

Jesse Vincent wrote:
>
> On Jul 16, 2008, at 5:36 PM, Jeff Voskamp wrote:
>
>> There's some nice new options for Search/Build.html (such as all the 
>> Queue* stuff, but the label field is a bit narrow.
>> Attached is a patch that allows me to see the tail end of such 
>> options as "QueueAdminCC EmailAddress"  rather than just a list of 
>> "QueueAdminC".
>>
> So, the problem with making things that wide in the default view is 
> that on many browsers and screens, the query view gets cut off:/
Then the contents of the fields need to be shorter, or ragged left, or 
something.  the 3.4 and 3.5 skins don't specify a width so things are 
still getting pushed around.

Jeff
___
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] Performance Issues after 3.8.0 upgrade -- PostgreSQL delays

[Jessie Bryan]

On Wed, Jul 16, 2008 at 12:45 PM, Jesse Vincent <[EMAIL PROTECTED]> wrote:

> Are you doing automated vacuum analyzes? Do you have Postgres' slow query
> log on? If so, what does it report?

AFAICT, postgresql.conf show me that autovacuum is on:

autovacuum = on
autovacuum_naptime = 300

I don't see anything about slow query logs (is that set via
log_min_duration_statement ?)
If I need to set log_min_duration_statement, any recommendation value?
___
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] 3.8.0 and backwards compatability

[Jesse Vincent]

On Jul 16, 2008, at 5:56 PM, Micah Gersten wrote:

> I'm wondering if the 3.8.0 DB schema is backwards compatible with  
> 3.6.0.
> Does anyone know?
>
It is. some types have been tweaked, but they should all work fine  
with a 3.6.0 instance. The only "real" changes are added data.

-j

> -- 
>
>
> Thank you,
> Micah Gersten
> onShore Networks
> Internal Developer
> http://www.onshore.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

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.8.0 web2 CSS wierdness.

[Jesse Vincent]

On Jul 16, 2008, at 5:36 PM, Jeff Voskamp wrote:

> There's some nice new options for Search/Build.html (such as all the  
> Queue* stuff, but the label field is a bit narrow.
> Attached is a patch that allows me to see the tail end of such  
> options as "QueueAdminCC EmailAddress"  rather than just a list of  
> "QueueAdminC".
>
So, the problem with making things that wide in the default view is  
that on many browsers and screens, the query view gets cut off:/


> Jeff Voskamp
> *** ticket-search.css 2008-07-15 14:33:34.0 -0400
> --- /usr/local/rt/html/NoAuth/css/web2/ticket-search.css  2008-07-16  
> 17:30:22.0 -0400
> ***
> *** 60,70 
>  #comp-Search-Build #pick-criteria td.label {
>  font: message-box;
>  padding-right: 0.5em;
> ! width: 11em;
>  }
>
>  #comp-Search-Build #pick-criteria td.label * {
> !  width: 8.5em;
>  }
>
>  #comp-Search-Build #pick-criteria td.label select {
> --- 60,70 
>  #comp-Search-Build #pick-criteria td.label {
>  font: message-box;
>  padding-right: 0.5em;
> ! width: 18em;
>  }
>
>  #comp-Search-Build #pick-criteria td.label * {
> !  width: 15.5em;
>  }
>
>  #comp-Search-Build #pick-criteria td.label select {
> ___
> 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] 3.8.0 and backwards compatability

[Micah Gersten]

I'm wondering if the 3.8.0 DB schema is backwards compatible with 3.6.0.
Does anyone know?

-- 


Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.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] rt 3.8.0 web2 CSS wierdness.

[Jeff Voskamp]

There's some nice new options for Search/Build.html (such as all the 
Queue* stuff, but the label field is a bit narrow.
Attached is a patch that allows me to see the tail end of such options 
as "QueueAdminCC EmailAddress"  rather than just a list of "QueueAdminC".


Jeff Voskamp
*** ticket-search.css   2008-07-15 14:33:34.0 -0400
--- /usr/local/rt/html/NoAuth/css/web2/ticket-search.css2008-07-16 
17:30:22.0 -0400
***
*** 60,70 
  #comp-Search-Build #pick-criteria td.label {
  font: message-box;
  padding-right: 0.5em;
! width: 11em;
  }
  
  #comp-Search-Build #pick-criteria td.label * {
!  width: 8.5em;
  }
  
  #comp-Search-Build #pick-criteria td.label select {
--- 60,70 
  #comp-Search-Build #pick-criteria td.label {
  font: message-box;
  padding-right: 0.5em;
! width: 18em;
  }
  
  #comp-Search-Build #pick-criteria td.label * {
!  width: 15.5em;
  }
  
  #comp-Search-Build #pick-criteria td.label select {
___
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] database upgrade problem

[Raphael]

hi all,

tried to upgrade the database with the following command (from version 
3.6.6 to 3.8.0):


rt-setup-database --dba root --prompt-for-dba-password --action upgrade

it worked but then it stopped with this error:

Processing 3.7.1
Processing 3.7.3
Now populating database schema.
Processing 3.7.10
Processing 3.7.15
Processing 3.7.19
Processing 3.7.81
Now populating database schema.
[Wed Jul 16 21:16:12 2008] [crit]: DBD::mysql::st execute failed: The 
table '#sql-41f5_43' is full at /opt/rt3/sbin/../lib/RT/Handle.pm line 
463. (/opt/rt3/sbin/../lib/RT.pm:375)
DBD::mysql::st execute failed: The table '#sql-41f5_43' is full at 
/opt/rt3/sbin/../lib/RT/Handle.pm line 463.


can anyone help me with this?

thanx,
raphael
___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Scott T. Hildreth]

On Wed, 2008-07-16 at 11:53 -0500, Scott T. Hildreth wrote:
> Well I ran all the etc/upgrade/3.7.* upgrades and then created the 
> query script with schema.mysql-4.0-4.1.pl and I get this error,
> 
> ERROR 1067 (42000) at line 36: Invalid default value for 'LookupType'


  I looked at the sql,

  ALTER TABLE CustomFields MODIFY LookupType VARBINARY(255) NOT NULL DEFAULT 
NULL;

  ...I guess it doesn't like "NOT NULL" defaulting to ...well NULL. :-)

  There were 5 of these, so I removed the "DEFAULT NULL" and all was well. 

>grep "NOT NULL DEFAULT NULL" sql.queries
 
ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET ascii NOT 
NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARBINARY(255) NOT NULL 
DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARCHAR(255) CHARACTER 
SET ascii NOT NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY ObjectType VARBINARY(64) NOT NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY ObjectType VARCHAR(64) CHARACTER SET ascii NOT 
NULL DEFAULT NULL;

 



> 
> I am using Server version: 5.0.51a.
> 
> I am confused as well, if you are already on mysql > 4.0 do you need
> to run the queries created by schema.mysql-4.0-4.1.pl?  I think the 
> answer is probably yes, since the char set is changed to utf8.
> 
> 
> On Wed, 2008-07-16 at 11:03 -0500, [EMAIL PROTECTED] wrote:
> > Interesting.  We're running 5.0.27 and the script worked just fine.
> > However, I ran all the schema/acl/insert upgrade commands using all the
> > 5.7.xx directories in etc/upgrade.
> > 
> > Still waiting to hear from Ruslan to confirm 100% that you don't need to
> > run all these commands and you need only run the schema.mysql-4.0-4.1.pl
> > script.
> > 
> > Additionally, not entirely sure, but it sounds like he acknowledges there
> > is a problem with the script.
> > 
> > 
> > James Moseley
> > 
> > 
> > 
> > 
> >
> >  "Ryan Hardester"  
> >  <[EMAIL PROTECTED] 
> >  i.tracy.ca.us> To 
> >"Ruslan Zakirov"
> >  07/16/2008 10:41  <[EMAIL PROTECTED]>,
> >  AM<[EMAIL PROTECTED]> 
> > cc 
> >  
> >Subject 
> >RE: [rt-users] Upgrading to 3.8.0:  
> >schema.mysql,column_info selection  
> >problem 
> >
> >
> >
> >
> >
> >
> > 
> > 
> > 
> > 
> > I am getting the same column_info failed error message when running the
> > script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
> > the DB server since we are not running RT and the DB on the same
> > machine.
> > 
> > --Ryan
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan
> > Zakirov
> > Sent: Wednesday, July 16, 2008 6:57 AM
> > To: [EMAIL PROTECTED]
> > Cc: rt-users@lists.bestpractical.com
> > Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info
> > selection problem
> > 
> > In 3.8.0 it's one step :)
> > 
> > However, we've done changes to mysql DB that require additional
> > upgrade steps for mysql, and this step fails.
> > 
> > On Wed, Jul 16, 2008 at 5:24 PM,  <[EMAIL PROTECTED]> wrote:
> > > Did you follow these steps first?
> > >
> > > You may also need to update RT's database.  To find out, type:
> > >
> > >   ls etc/upgrade
> > >
> > > For each item in that directory whose name is greater than
> > > your previously installed RT version, run:
> > >
> > >   /opt/rt3/sbin/rt-setup-database --action schema \
> > >   --datadir etc/upgrade/
> > >   /opt/rt3/sbin/rt-setup-database --action acl \
> > >   --datadir etc/upgrade/
> > >   /opt/rt3/sbin/rt-setup-database --action insert \
> > >--datadir etc/upgrade/
> > >
> > >
> > > There are 10 3.7.xx directories that you'll need to go through.
> > >
> > >
> > > James Moseley
> > >
> > >
> > >
> > >
> > >
> > > "web master"
> > > <[EMAIL PR

Re: [rt-users] RT 3.8 comments

[Ruslan Zakirov]

On Thu, Jul 17, 2008 at 12:37 AM, Bill Davis <[EMAIL PROTECTED]> wrote:
> Have just upgraded RT 3.6.5 to RT 3.8 and am quite impressed overall ...
> kudos to all involved in its development :o) ...
>
> ... however there are a few minor things I'd like to modify:
>
> 1. Inevitably a certain amount of spam leaks through the spam filters
> and creates tickets ... currently on each one that isn't obvious spam
> from the title, I have to view it, select "Basics", select status
> "deleted", & then click "Save Changes" ... a 3 step process. What I'd
> like to do is add a "Delete" choice to the "Open --- Comment --- Reply
> --- Resolve --- Star (bookmark)" bar in the upper right of the Ticket
> History screen, so that one click would change the ticket status to
> "deleted".  I had modified 3.6.5 to do this in accordance with someone's
> contribution (whose or where I don't recall) ... but I doubt that mod
> would still fit 3.8.
If it's correct mod based on a callback then it still should work with 3.8.0.


> 2. I'd like to be able to set the default refresh interval for a least
> the "At A Glance" page (in user preferences would be nice, but I'd be
> happy with a RT_SiteConfig alternative.  RT defaults to "Do not refresh"
> (in my opinion a poor choice), requiring this to be reset at every login.
create a feature request on rt3.fsck.com

>
> 3. I'd previously configured 3.6.5 so that certain high priorities
> displayed the priority number in different color,  I'd like to do the
> same in 3.8 but haven't been able to locate what or where to modify (I'm
> Perl ignorant ... or know just enough to be dangerous :o) ).
Again if it's callbacks based mod than it still should work.

>
> Any pointers or suggestions regarding any of these are greatly
> appreciated ...
>
> Bill Davis
> ___
> 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
>



-- 
Best regards, Ruslan.
___
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] Simple Search function

[Kevin Falcone]

On Jul 16, 2008, at 4:07 PM, Jake Zack wrote:

> OK...I lied.
>
> Well, not below...but initially.
>
> The RT 8.0 search function does work properly...UNLESS...as  
> below...there are numbers involved.
>
> I created ticket subject 'one two three four five six', and a search  
> of:
>
> one six
>
> Finds it.
>
> But if the search string contains numbers, it fails.

The Simple search assumes that any number is a Ticket ID and builds  
the query
based on that

-kevin

>
> That a bug, or intentional for some reason I don't understand? :)
>
> On 16-Jul-08, at 3:59 PM, Jake Zack wrote:
>
>> Yep, installed rt 8.0 today.
>>
>> I have a ticket called:
>>
>> AGM 2007 Member pre-registration login page
>>
>> When I search for "AGM", it works.  When I search for "2007", it  
>> works.
>>
>> When I search for:
>>
>> AGM 2007
>>
>> it fails.
>>
>> 'AGM 2007' works.
>>
>> I want to be able to parse my search query string, and check both  
>> (or all) of the arguments I've supplied it.
>>
>> Searching for:
>>
>> AGM Member
>>
>> ...should return this ticket in it's search results, much like the  
>> behaviour of rt3.fsck.com.
>>
>> On 16-Jul-08, at 3:44 PM, Jesse Vincent wrote:
>>
>>>
>>> On Jul 16, 2008, at 3:31 PM, Jake Zack wrote:
>>>
 In fact, this function I describe below *IS* built into the new  
 RT somewhere...or Best Practical developed it for themselves..

>>> We don't have any special code in there for this. Have you tested  
>>> 3.8.0 locally?
>>>
 Their website at rt3.fsck.com DOES handle searches the way I'd  
 like them to be handled.

 A search for:

 anti anxiety

 ...finds:

 10208  antisocial-personality-disorder-anxiety new Pushmi  
  
 Nobody 0
20 hours ago20 hours ago0
 10211  anti-depressents-for-anxietynew Pushmi  Nobody  0
15 hours ago15 hours ago0

 So there is some method to have it handle searches in a better way.

 Anyone?

 On 16-Jul-08, at 2:14 PM, Jake Zack wrote:

> What modifications would need to be made to make the Simple  
> Search function accept more than one word?
>
> It can do two words when the search terms are put in single  
> quotes...but the string has to match exactly a string in the  
> Subject.
>
> If the ticket subject is "barack obama beat hillary clinton"...a  
> search for:
>
> barack obama
>
> ...yields no results...but...
>
> 'barack obama'
>
> ...does yield results.
>
> I can't seem to find a way to make it accept a search phrase  
> such as:
>
> barack hillary
>
> and yield a result.
>
> And yes, I know the advanced search feature can be used...but  
> I'm told that that is too cumbersome for the average user.
>
> Any help would be appreciated.
>
> Thanks.

 ___
 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

___
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] RT 3.8 comments

[Bill Davis]

Have just upgraded RT 3.6.5 to RT 3.8 and am quite impressed overall ... 
kudos to all involved in its development :o) ...

... however there are a few minor things I'd like to modify:

1. Inevitably a certain amount of spam leaks through the spam filters 
and creates tickets ... currently on each one that isn't obvious spam 
from the title, I have to view it, select "Basics", select status 
"deleted", & then click "Save Changes" ... a 3 step process. What I'd 
like to do is add a "Delete" choice to the "Open --- Comment --- Reply 
--- Resolve --- Star (bookmark)" bar in the upper right of the Ticket 
History screen, so that one click would change the ticket status to 
"deleted".  I had modified 3.6.5 to do this in accordance with someone's 
contribution (whose or where I don't recall) ... but I doubt that mod 
would still fit 3.8.

2. I'd like to be able to set the default refresh interval for a least 
the "At A Glance" page (in user preferences would be nice, but I'd be 
happy with a RT_SiteConfig alternative.  RT defaults to "Do not refresh" 
(in my opinion a poor choice), requiring this to be reset at every login.

3. I'd previously configured 3.6.5 so that certain high priorities 
displayed the priority number in different color,  I'd like to do the 
same in 3.8 but haven't been able to locate what or where to modify (I'm 
Perl ignorant ... or know just enough to be dangerous :o) ).

Any pointers or suggestions regarding any of these are greatly 
appreciated ...

Bill Davis
___
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] RT 3.8.0 rich text color problems

[jmoseley]

When replying or commenting on a ticket, I can see the text color, if color
is selected.  When viewing the source, I can also see the span tags.

But after updating the ticket, the span tags disappear and thus the color
does too when displaying the ticket.

Am I missing something in the configuration or do I need to make some
changes to the theme files?


James Moseley


___
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] Simple Search function

[Jake Zack]

OK...I lied.

Well, not below...but initially.

The RT 8.0 search function does work properly...UNLESS...as  
below...there are numbers involved.


I created ticket subject 'one two three four five six', and a search of:

one six

Finds it.

But if the search string contains numbers, it fails.

That a bug, or intentional for some reason I don't understand? :)

On 16-Jul-08, at 3:59 PM, Jake Zack wrote:


Yep, installed rt 8.0 today.

I have a ticket called:

AGM 2007 Member pre-registration login page

When I search for "AGM", it works.  When I search for "2007", it  
works.


When I search for:

AGM 2007

it fails.

'AGM 2007' works.

I want to be able to parse my search query string, and check both  
(or all) of the arguments I've supplied it.


Searching for:

AGM Member

...should return this ticket in it's search results, much like the  
behaviour of rt3.fsck.com.


On 16-Jul-08, at 3:44 PM, Jesse Vincent wrote:



On Jul 16, 2008, at 3:31 PM, Jake Zack wrote:

In fact, this function I describe below *IS* built into the new  
RT somewhere...or Best Practical developed it for themselves..


We don't have any special code in there for this. Have you tested  
3.8.0 locally?


Their website at rt3.fsck.com DOES handle searches the way I'd  
like them to be handled.


A search for:

anti anxiety

...finds:

10208 	antisocial-personality-disorder-anxiety 	new 	Pushmi 	 
Nobody 	0

20 hours ago20 hours ago0
10211   anti-depressents-for-anxietynew Pushmi  Nobody  0
15 hours ago15 hours ago0

So there is some method to have it handle searches in a better way.

Anyone?

On 16-Jul-08, at 2:14 PM, Jake Zack wrote:

What modifications would need to be made to make the Simple  
Search function accept more than one word?


It can do two words when the search terms are put in single  
quotes...but the string has to match exactly a string in the  
Subject.


If the ticket subject is "barack obama beat hillary clinton"...a  
search for:


barack obama

...yields no results...but...

'barack obama'

...does yield results.

I can't seem to find a way to make it accept a search phrase  
such as:


barack hillary

and yield a result.

And yes, I know the advanced search feature can be used...but  
I'm told that that is too cumbersome for the average user.


Any help would be appreciated.

Thanks.


___
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

Re: [rt-users] Simple Search function

[Jake Zack]

Yep, installed rt 8.0 today.

I have a ticket called:

AGM 2007 Member pre-registration login page

When I search for "AGM", it works.  When I search for "2007", it works.

When I search for:

AGM 2007

it fails.

'AGM 2007' works.

I want to be able to parse my search query string, and check both (or  
all) of the arguments I've supplied it.


Searching for:

AGM Member

...should return this ticket in it's search results, much like the  
behaviour of rt3.fsck.com.


On 16-Jul-08, at 3:44 PM, Jesse Vincent wrote:



On Jul 16, 2008, at 3:31 PM, Jake Zack wrote:

In fact, this function I describe below *IS* built into the new RT  
somewhere...or Best Practical developed it for themselves..


We don't have any special code in there for this. Have you tested  
3.8.0 locally?


Their website at rt3.fsck.com DOES handle searches the way I'd  
like them to be handled.


A search for:

anti anxiety

...finds:

10208 	antisocial-personality-disorder-anxiety 	new 	Pushmi 	 
Nobody 	0

20 hours ago20 hours ago0
10211   anti-depressents-for-anxietynew Pushmi  Nobody  0
15 hours ago15 hours ago0

So there is some method to have it handle searches in a better way.

Anyone?

On 16-Jul-08, at 2:14 PM, Jake Zack wrote:

What modifications would need to be made to make the Simple  
Search function accept more than one word?


It can do two words when the search terms are put in single  
quotes...but the string has to match exactly a string in the  
Subject.


If the ticket subject is "barack obama beat hillary clinton"...a  
search for:


barack obama

...yields no results...but...

'barack obama'

...does yield results.

I can't seem to find a way to make it accept a search phrase such  
as:


barack hillary

and yield a result.

And yes, I know the advanced search feature can be used...but I'm  
told that that is too cumbersome for the average user.


Any help would be appreciated.

Thanks.


___
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

Re: [rt-users] Performance Issues after 3.8.0 upgrade -- PostgreSQL delays

[Jesse Vincent]

On Jul 16, 2008, at 2:00 PM, Jessie Bryan wrote:

> Hello everyone,
>
> We recently upgraded from 3.6.6 to 3.8.0 and after the upgrade, we
> immediately noticed delays loading pages within RT-3.8.0 website.
> Currently, the web interface is hosted on a Gentoo Linux system
> running apache2-2.8 with modperl 2.0.3 (portage) and Postfix MTA.
> RT3.8 was built from source.
> The database server is on a separate Gentoo Linux system running
> Postgresql-8.1.11 (portage). We have roughly 6 concurrent users at any
> time using RT.
> The database server shows us the process postmaster running at 85-95%
> CPU  (5min avg load is around 3.88 - 4.5) during RT web clicks.
> Being relatively naive to postgres performance tuning, I'm not sure if
> this post is relevant to this list or not.
>
>

Are you doing automated vacuum analyzes? Do you have Postgres' slow  
query log on? If so, what does it report?


> Additional Server Details:
>
> tickets web/postfix has about 1GB RAM and is only running
> Postfix/Apache. The system load is always under 1, about 0.10 average
> RT-3.8.0 uses the following build options:
>
> #!/bin/bash
> ./configure   --with-bin-owner=root  --with-libs-owner=root
> --with-libs-group=bin  \
> --with-db-type=Pg --with-db-host=copper.example.org
> --with-db-port=5432  \
> --with-db-rt-host=tickets.example.org
> --with-db-dba=  --with-db-database=rt3 \
> --with-db-rt-user=rt --with-db-rt-pass=** \
> --with-web-user=apache --with-web-group=apache --with-rt- 
> group=rt \
> --enable-graphviz --enable-gd --enable-gpg
>
>
> postgres "copper" server has 1GB RAM and is only running Postgres for
> our RT3 installation. Prior to the RT-3.8 upgrade the server load
> around 0.15
>
> Here's our postgresql.conf:
>
> max_connections = 100
> shared_buffers = 1000
> lc_messages = 'C'
> lc_monetary = 'C'
> lc_numeric = 'C'
> lc_time = 'C'
> stats_start_collector = true
> stats_row_level = true
> listen_addresses = '*'
> shared_buffers = 48000
> max_prepared_transactions = 64
> work_mem = 4096
> maintenance_work_mem = 32767
> max_stack_depth = 7168
> fsync = off
> effective_cache_size = 4000
> autovacuum = on
> autovacuum_naptime = 300
> lc_messages = 'en_US'
> lc_monetary = 'en_US'
> lc_numeric = 'en_US'
> lc_time = 'en_US'
>
> Here's a 'vmstat 1' from "copper" / postresql box:
>
> copper /var/log# vmstat 1
> procs ---memory-- ---swap-- -io --system--  
> cpu
> r  b   swpd   free   buff  cache   si   sobibo   incs us  
> sy id wa
> 0  0  41080  50316  19004 70414400 1 01 1   
> 4  1 95  0
> 0  0  41080  50316  19004 70414400 0 0  14559   
> 0  0 100  0
> 0  0  41080  50316  19004 70414400 0 0  10518   
> 0  0 100  0
> 1  0  41080  50316  19004 70421200 0 0  617   540   
> 5  2 93  0
> 2  0  41080  50316  19012 70420400 0  1228  367   330 57  
> 13 30  1
> 1  0  41080  50316  19012 70420400 0 0  490   750 64  
> 11 25  0
> 1  0  41080  49944  19012 70434000 0 0  387   711 69  
> 10 21  0
> 1  0  41080  49944  19012 70434000 0 0  213   230 23  
> 15 62  0
> 1  0  41080  49944  19012 70434000 0 0  211   217 25  
> 15 59  0
> 1  0  41080  49944  19020 70433200 0   584  253   259 25  
> 17 58  0
> 0  0  41080  49884  19020 7044000060 0  205   219 24  
> 16 58  2
> 1  0  41080  49824  19020 7044000048 0  211   222 19  
> 22 58  0
> 1  0  41080  49764  19020 7044680072 0  197   198 28  
> 13 58  1
> 0  0  41080  49704  19020 7046040056 0  217   228 18  
> 16 66  0
> 0  0  41080  49704  19028 70459600 0   112  11346   
> 0  0 100  0
> 0  0  41080  49704  19028 70459600 0 0  10422   
> 0  0 100  0
> 0  0  41080  49704  19028 70459600 0 0  10520   
> 0  0 100  0
>
> copper log /var/log#
>
>
>
> We have a 2nd pair of identical servers running a copy of the
> Postgresql RT-3.6.6 database (for testing purposes) and do not see
> these slow downs (same hardware,software).
>
> Does anyone have any suggestions where to tackle this? Is  
> downgrading an option?
>
> Thanks everyone,
>
> -Jessie
> ___
> 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

Re: [rt-users] Simple Search function

[Jesse Vincent]

On Jul 16, 2008, at 3:31 PM, Jake Zack wrote:

In fact, this function I describe below *IS* built into the new RT  
somewhere...or Best Practical developed it for themselves..


We don't have any special code in there for this. Have you tested  
3.8.0 locally?


Their website at rt3.fsck.com DOES handle searches the way I'd like  
them to be handled.


A search for:

anti anxiety

...finds:

10208   antisocial-personality-disorder-anxiety new Pushmi  Nobody  0
20 hours ago20 hours ago0
10211   anti-depressents-for-anxietynew Pushmi  Nobody  0
15 hours ago15 hours ago0

So there is some method to have it handle searches in a better way.

Anyone?

On 16-Jul-08, at 2:14 PM, Jake Zack wrote:

What modifications would need to be made to make the Simple Search  
function accept more than one word?


It can do two words when the search terms are put in single  
quotes...but the string has to match exactly a string in the Subject.


If the ticket subject is "barack obama beat hillary clinton"...a  
search for:


barack obama

...yields no results...but...

'barack obama'

...does yield results.

I can't seem to find a way to make it accept a search phrase such as:

barack hillary

and yield a result.

And yes, I know the advanced search feature can be used...but I'm  
told that that is too cumbersome for the average user.


Any help would be appreciated.

Thanks.


___
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

Re: [rt-users] Simple Search function

[Jake Zack]

In fact, this function I describe below *IS* built into the new RT  
somewhere...or Best Practical developed it for themselves..


Their website at rt3.fsck.com DOES handle searches the way I'd like  
them to be handled.


A search for:

anti anxiety

...finds:

10208   antisocial-personality-disorder-anxiety new Pushmi  Nobody  0
20 hours ago20 hours ago0
10211   anti-depressents-for-anxietynew Pushmi  Nobody  0
15 hours ago15 hours ago0

So there is some method to have it handle searches in a better way.

Anyone?

On 16-Jul-08, at 2:14 PM, Jake Zack wrote:

What modifications would need to be made to make the Simple Search  
function accept more than one word?


It can do two words when the search terms are put in single  
quotes...but the string has to match exactly a string in the Subject.


If the ticket subject is "barack obama beat hillary clinton"...a  
search for:


barack obama

...yields no results...but...

'barack obama'

...does yield results.

I can't seem to find a way to make it accept a search phrase such as:

barack hillary

and yield a result.

And yes, I know the advanced search feature can be used...but I'm  
told that that is too cumbersome for the average user.


Any help would be appreciated.

Thanks.


___
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] Service Updates

[Ryan Hardester]

Is there a way to get Service Updates extension to work in 3.8?

It installs, but when I go to enter an item I get: 

"Undefined subroutine &HTML::Mason::Commands::Error called at
/opt/rt3/share/html/ServiceUpdate/Edit/dhandler line 20."

This is a fresh 3.8, with the extension installed via cpan.

--Ryan
___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[jmoseley]

Ruslan, thanks for sharing this.


James Moseley




   
 "Ruslan Zakirov"  
 <[EMAIL PROTECTED] 
 l.com> To 
 Sent by:  [EMAIL PROTECTED]   
 [EMAIL PROTECTED]  cc 
 ail.com   rt-users@lists.bestpractical.com
   Subject 
   Re: [rt-users] Upgrading to 3.8.0:  
 07/16/2008 01:09  schema.mysql,column_info selection  
 PMproblem 
   
   
   
   
   
   




Let's make it clear:
* you still must upgrade DB using files in etc/upgrade/x.x.x/
* however in 3.8.0 you can do it using one command:

rt-setup-database --dba root --prompt-for-dba-password --action upgrade

it will ask for the old version (for example you can enter 3.6.7) and
will apply all steps up to the installed version (in this case it's
3.8.0)

* then you do mysql schema changes using the script
* these schema changes are required for all mysql versions greater
than mysql 4.1.0

* people installing for the first time will get new DB schema as there
are two different schema files for mysql in etc/, so they don't need
to do all these steps
* people upgrading mysql server from 4.0 to 4.1 and newer should use
the script two

* I tested this script several times, but only on my dev PC, so it's
VERY recommended to backup and make tests

Clear?

On Wed, Jul 16, 2008 at 8:03 PM,  <[EMAIL PROTECTED]> wrote:
> Interesting.  We're running 5.0.27 and the script worked just fine.
> However, I ran all the schema/acl/insert upgrade commands using all the
> 5.7.xx directories in etc/upgrade.
>
> Still waiting to hear from Ruslan to confirm 100% that you don't need to
> run all these commands and you need only run the schema.mysql-4.0-4.1.pl
> script.
>
> Additionally, not entirely sure, but it sounds like he acknowledges there
> is a problem with the script.
>
>
> James Moseley
>
>
>
>
>
> "Ryan Hardester"
> <[EMAIL PROTECTED]
> i.tracy.ca.us> To
>   "Ruslan Zakirov"
> 07/16/2008 10:41  <[EMAIL PROTECTED]>,
> AM<[EMAIL PROTECTED]>
>cc
>   
>   Subject
>   RE: [rt-users] Upgrading to 3.8.0:
>   schema.mysql,column_info selection
>   problem
>
>
>
>
>
>
>
>
>
>
> I am getting the same column_info failed error message when running the
> script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
> the DB server since we are not running RT and the DB on the same
> machine.
>
> --Ryan
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan
> Zakirov
> Sent: Wednesday, July 16, 2008 6:57 AM
> To: [EMAIL PROTECTED]
> Cc: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info
> selection problem
>
> In 3.8.0 it's one step :)
>
> However, we've done changes to mysql DB that require additional
> upgrade steps for mysql, and this step fails.
>
> On Wed, Jul 16, 2008 at 5:24 PM,  <[EMAIL PROTECTED]> wrote:
>> Did you follow these steps first?
>>
>> You may also need to update RT's database.  To find out, type:
>>
>>   ls etc/upgrade
>>
>> For each item in that directory whose name is greater than
>> your previously installed RT version, run:
>>
>>   /opt/rt3/sbin/rt-setup-database --action schema \
>>   --datadir etc/upgrade/
>>   /opt/rt3/sbin/rt-setup-database --action acl \
>>   --datadir etc/upgrade/
>>   /opt/rt3/sbin/rt-setup-database --action insert \
>>--datadir etc/upgrade/
>>
>>
>> There are 10 3.7.xx directories that you'll need to go through.
>>
>>
>> James Moseley
>>
>>
>>
>>
>>
>> "web master"
>> <[EMAIL PROTECTED]
>> ra.com>
> To
>> Sent by:

[rt-users] question about email respose

[Richard Harold]

Is it possible to have the email response with a greeting of "Good
morning", or "Good afternoon" depending on the time of day? I understand
it is going to be some perl modding of some kind.

 

Thanks in advance

 

 


_DISCLAIMER:

This message is intended only for the use of the person(s) ("the intended 
recipient(s)") to whom it is addressed. 

It may contain information which is privileged, proprietary and/or confidential 
within the meaning of applicable law. 

If you are not the intended recipient, be advised that you have received this 
email in error and that any use, dissemination, forwarding, printing or copying 
of this message (including any attachments) is strictly prohibited. 

If you have received this message in error, please contact the sender of this 
message as soon as possible. 

The views or opinions expressed in this message are those of the author and may 
not necessarily be the views held by Maxima Holdings plc.
Maxima Holdings plc. Cotswold Court, Lansdown Road, Cheltenham, Glos, GL50 2JA. 
Registered in England. 5043538. VAT Number - 728778184

This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
_
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] Simple Search function

[Jake Zack]

What modifications would need to be made to make the Simple Search  
function accept more than one word?

It can do two words when the search terms are put in single  
quotes...but the string has to match exactly a string in the Subject.

If the ticket subject is "barack obama beat hillary clinton"...a  
search for:

barack obama

...yields no results...but...

'barack obama'

...does yield results.

I can't seem to find a way to make it accept a search phrase such as:

barack hillary

and yield a result.

And yes, I know the advanced search feature can be used...but I'm  
told that that is too cumbersome for the average user.

Any help would be appreciated.

Thanks.

___
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] 3.8.0 Install

[Jesse Vincent]

On Jul 16, 2008, at 2:08 PM, Curtis Bruneau wrote:

>Is there a way to explicitly turn off the standalone server during
> install/compile? the previous versions didn't force it.

There is not. We've made it a core RT dependency.  The additional  
dependencies are relatively light-weight and pure perl and we felt  
they were an adequate tradeoff for the significant debugging and setup  
benefits.

(The web based configuration tool itself wasn't quite ready to  
announce as part of 3.8.0, but once you have installed RT 3.8.0, if  
you run standalone_httpd without a working database, RT will guide you  
through configuration and database provisioning. I'm hoping we'll see  
that as 'officially recommended' for 3.8.1. But it depends on the  
standalone server.)
___
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] 3.8.0 Install

[Curtis Bruneau]

Is there a way to explicitly turn off the standalone server during 
install/compile? the previous versions didn't force it. I'm trying to 
stay away from the extra perl modules as I don't believe I'll be using 
it at all. I've tried various configure switches but it doesn't appear 
to be possible. If this is ignorable that would be fine too..

./configure --with-web-handler=modperl2 --with-db-type=mysql --enable-gd

STANDALONE missing dependencies:
Net::Server::PreFork...MISSING
HTTP::Server::Simple >= 0.34...MISSING
HTTP::Server::Simple::Mason >= 0.09...MISSING
Net::Server...MISSING

Any suggestions would be great..

Curtis
___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Kris Boutilier]

Your local version of DBD::mysql is out of date. The relevant notes from my 
rt3.8 upgrade on Debian Etch are below. Hope that helps.

Kris Boutilier
Information Services Coordinator
Sunshine Coast Regional District

-

'column_info failed: column_info doesn't support column selection' means 
DBD::mysql is probably out of date, so check installed version of DBD::mysql

# perl -MCPAN -e 'print CPAN::Shell->r '

Package namespace installedlatest  in CPAN file
...
DBD::mysql   3.0008 4.007  CAPTTOFU/DBD-mysql-4.007.tar.gz
...

What does Debian provide as a package and are we up to date?

rt38:/# apt-cache search DBD::mysql
libdbd-mysql-perl - A Perl5 database interface to the MySQL database

rt38:/# apt-get install libdbd-mysql-perl
Reading package lists... Done
Building dependency tree... Done
libdbd-mysql-perl is already the newest version.

Hmmm http://packages.debian.org tells us that 4.007-1 is available in 
Testing. Can we easily install the package from Testing on this Stable machine?

[don't bother trying this route, it fails miserably...] rt38:/usr/src# wget 
http://http.us.debian.org/debian/pool/main/libd/libdbd-mysql-perl/libdbd-mysql-perl_4.007-1_amd64.deb

[clip]

... So, no. How about installing from sources, via CPAN?

rt38:/usr/src# wget 
http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.007.tar.gz

{clip}

12:12:57 (444.49 KB/s) - `DBD-mysql-4.007.tar.gz' saved [123516/123516]

rt38:/usr/src# tar -xvzf DBD-mysql-4.007.tar.gz

rt38:/usr/src/DBD-mysql-4.007# perl Makefile.PL

H... it needs access to the mysql_client binary to build, so:

rt38:/# apt-get install libmysqlclient15-dev

rt38:/usr/src/DBD-mysql-4.007# perl Makefile.PL
rt38:/usr/src/DBD-mysql-4.007# make
rt38:/usr/src/DBD-mysql-4.007# make install

And, try again:

rt38:/usr/src/rt-3.8.0rc3# perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root '' 
> sql.queries
rt3.Groups.Instance has type VARCHAR however mapping is missing.

Odd message, but everything seems to work now.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of web master
Sent: Wednesday, July 16, 2008 3:00 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection 
problem

Hi there
I am having schema.mysql-4.0-4.1.pl problems upgrading to version 3.8.0 from 
3.6.6.
make upgrade worked well.

{clip}

[EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  > 
sql.queries

but

DBD::mysql::db column_info failed: column_info doesn't support column selection 
at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
DBD::mysql::db column_info failed: column_info doesn't support column selection 
at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.

{clip}
___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Ruslan Zakirov]

Let's make it clear:
* you still must upgrade DB using files in etc/upgrade/x.x.x/
* however in 3.8.0 you can do it using one command:

rt-setup-database --dba root --prompt-for-dba-password --action upgrade

it will ask for the old version (for example you can enter 3.6.7) and
will apply all steps up to the installed version (in this case it's
3.8.0)

* then you do mysql schema changes using the script
* these schema changes are required for all mysql versions greater
than mysql 4.1.0

* people installing for the first time will get new DB schema as there
are two different schema files for mysql in etc/, so they don't need
to do all these steps
* people upgrading mysql server from 4.0 to 4.1 and newer should use
the script two

* I tested this script several times, but only on my dev PC, so it's
VERY recommended to backup and make tests

Clear?

On Wed, Jul 16, 2008 at 8:03 PM,  <[EMAIL PROTECTED]> wrote:
> Interesting.  We're running 5.0.27 and the script worked just fine.
> However, I ran all the schema/acl/insert upgrade commands using all the
> 5.7.xx directories in etc/upgrade.
>
> Still waiting to hear from Ruslan to confirm 100% that you don't need to
> run all these commands and you need only run the schema.mysql-4.0-4.1.pl
> script.
>
> Additionally, not entirely sure, but it sounds like he acknowledges there
> is a problem with the script.
>
>
> James Moseley
>
>
>
>
>
> "Ryan Hardester"
> <[EMAIL PROTECTED]
> i.tracy.ca.us> To
>   "Ruslan Zakirov"
> 07/16/2008 10:41  <[EMAIL PROTECTED]>,
> AM<[EMAIL PROTECTED]>
>cc
>   
>   Subject
>   RE: [rt-users] Upgrading to 3.8.0:
>   schema.mysql,column_info selection
>   problem
>
>
>
>
>
>
>
>
>
>
> I am getting the same column_info failed error message when running the
> script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
> the DB server since we are not running RT and the DB on the same
> machine.
>
> --Ryan
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan
> Zakirov
> Sent: Wednesday, July 16, 2008 6:57 AM
> To: [EMAIL PROTECTED]
> Cc: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info
> selection problem
>
> In 3.8.0 it's one step :)
>
> However, we've done changes to mysql DB that require additional
> upgrade steps for mysql, and this step fails.
>
> On Wed, Jul 16, 2008 at 5:24 PM,  <[EMAIL PROTECTED]> wrote:
>> Did you follow these steps first?
>>
>> You may also need to update RT's database.  To find out, type:
>>
>>   ls etc/upgrade
>>
>> For each item in that directory whose name is greater than
>> your previously installed RT version, run:
>>
>>   /opt/rt3/sbin/rt-setup-database --action schema \
>>   --datadir etc/upgrade/
>>   /opt/rt3/sbin/rt-setup-database --action acl \
>>   --datadir etc/upgrade/
>>   /opt/rt3/sbin/rt-setup-database --action insert \
>>--datadir etc/upgrade/
>>
>>
>> There are 10 3.7.xx directories that you'll need to go through.
>>
>>
>> James Moseley
>>
>>
>>
>>
>>
>> "web master"
>> <[EMAIL PROTECTED]
>> ra.com>
> To
>> Sent by:  rt-users@lists.bestpractical.com
>> rt-users-bounces@
> cc
>> lists.bestpractic
>> al.com
> Subject
>>   [rt-users] Upgrading to 3.8.0:
>>   schema.mysql, column_info
>> 07/16/2008 05:00  selection problem
>> AM
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hi there
>> I am having schema.mysql-4.0-4.1.pl problems upgrading to version
>> 3.8.0 from 3.6.6.
>> make upgrade worked well.
>>
>> As in point 4) of UPGRADING.mysql
>>
>> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl  > sql.queries
>>
>> but
>>
>> usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password
>>
>> Ok, then I inserted the info needed
>>
>> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  >
> sql.queries
>>
>> but
>>
>> DBD::mysql::db column_info failed: column_info doesn't support column
>> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
>> DBD::mysql::db column_info failed: column_info doesn't support column
>> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
>>
>> RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need
>> to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in
>> 3.6.6 tarball), it seems to suggest so.
>>
>> Can

[rt-users] Performance Issues after 3.8.0 upgrade -- PostgreSQL delays

[Jessie Bryan]

Hello everyone,

We recently upgraded from 3.6.6 to 3.8.0 and after the upgrade, we
immediately noticed delays loading pages within RT-3.8.0 website.
Currently, the web interface is hosted on a Gentoo Linux system
running apache2-2.8 with modperl 2.0.3 (portage) and Postfix MTA.
RT3.8 was built from source.
The database server is on a separate Gentoo Linux system running
Postgresql-8.1.11 (portage). We have roughly 6 concurrent users at any
time using RT.
The database server shows us the process postmaster running at 85-95%
CPU  (5min avg load is around 3.88 - 4.5) during RT web clicks.
Being relatively naive to postgres performance tuning, I'm not sure if
this post is relevant to this list or not.


Additional Server Details:

tickets web/postfix has about 1GB RAM and is only running
Postfix/Apache. The system load is always under 1, about 0.10 average
RT-3.8.0 uses the following build options:

#!/bin/bash
./configure   --with-bin-owner=root  --with-libs-owner=root
--with-libs-group=bin  \
 --with-db-type=Pg --with-db-host=copper.example.org
--with-db-port=5432  \
 --with-db-rt-host=tickets.example.org
--with-db-dba=  --with-db-database=rt3 \
 --with-db-rt-user=rt --with-db-rt-pass=** \
 --with-web-user=apache --with-web-group=apache --with-rt-group=rt \
 --enable-graphviz --enable-gd --enable-gpg


postgres "copper" server has 1GB RAM and is only running Postgres for
our RT3 installation. Prior to the RT-3.8 upgrade the server load
around 0.15

Here's our postgresql.conf:

max_connections = 100
shared_buffers = 1000
lc_messages = 'C'
lc_monetary = 'C'
lc_numeric = 'C'
lc_time = 'C'
stats_start_collector = true
stats_row_level = true
listen_addresses = '*'
shared_buffers = 48000
max_prepared_transactions = 64
work_mem = 4096
maintenance_work_mem = 32767
max_stack_depth = 7168
fsync = off
effective_cache_size = 4000
autovacuum = on
autovacuum_naptime = 300
lc_messages = 'en_US'
lc_monetary = 'en_US'
lc_numeric = 'en_US'
lc_time = 'en_US'

Here's a 'vmstat 1' from "copper" / postresql box:

copper /var/log# vmstat 1
procs ---memory-- ---swap-- -io --system-- cpu
 r  b   swpd   free   buff  cache   si   sobibo   incs us sy id wa
 0  0  41080  50316  19004 70414400 1 01 1  4  1 95  0
 0  0  41080  50316  19004 70414400 0 0  14559  0  0 100  0
 0  0  41080  50316  19004 70414400 0 0  10518  0  0 100  0
 1  0  41080  50316  19004 70421200 0 0  617   540  5  2 93  0
 2  0  41080  50316  19012 70420400 0  1228  367   330 57 13 30  1
 1  0  41080  50316  19012 70420400 0 0  490   750 64 11 25  0
 1  0  41080  49944  19012 70434000 0 0  387   711 69 10 21  0
 1  0  41080  49944  19012 70434000 0 0  213   230 23 15 62  0
 1  0  41080  49944  19012 70434000 0 0  211   217 25 15 59  0
 1  0  41080  49944  19020 70433200 0   584  253   259 25 17 58  0
 0  0  41080  49884  19020 7044000060 0  205   219 24 16 58  2
 1  0  41080  49824  19020 7044000048 0  211   222 19 22 58  0
 1  0  41080  49764  19020 7044680072 0  197   198 28 13 58  1
 0  0  41080  49704  19020 7046040056 0  217   228 18 16 66  0
 0  0  41080  49704  19028 70459600 0   112  11346  0  0 100  0
 0  0  41080  49704  19028 70459600 0 0  10422  0  0 100  0
 0  0  41080  49704  19028 70459600 0 0  10520  0  0 100  0

copper log /var/log#



We have a 2nd pair of identical servers running a copy of the
Postgresql RT-3.6.6 database (for testing purposes) and do not see
these slow downs (same hardware,software).

Does anyone have any suggestions where to tackle this? Is downgrading an option?

Thanks everyone,

-Jessie
___
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] RT-Authen-ExternalAuth

[Michael James]

Hi, I'm installing an instance of RT in a non-standard local directory 
(/opt/csr/). The wiki indicates that when I run "perl Makefile.PL", it will 
prompt me for the path to my RT instance, but... it doesn't. So, how can I 
specify the RT directory? You can see below - I want /opt/rt3 to be /opt/csr 
instead.

hostnew:~/RT-Authen-ExternalAuth-0.05 # perl Makefile.PL
Cannot determine perl version info from lib/RT/Authen/ExternalAuth.pm
Cannot determine author info from lib/RT/Authen/ExternalAuth.pm
Cannot determine license info from lib/RT/Authen/ExternalAuth.pm
Using RT configuration from /opt/rt3/lib/RT.pm:
./etc   => /opt/rt3/local/etc/Authen-ExternalAuth
./html  => /opt/rt3/share/html
./lib   => /opt/rt3/local/lib
Cannot determine perl version info from lib/RT/Authen/ExternalAuth.pm
Checking if your kit is complete...
Looks good
Writing Makefile for RT::Authen::ExternalAuth



The information in this message may be proprietary and/or confidential, and 
protected from disclosure. If the reader of this message is not the intended 
recipient, or an employee or agent responsible for delivering this message to 
the intended recipient, you are hereby notified that any dissemination, 
distribution or copying of this communication is strictly prohibited. If you 
have received this communication in error, please notify Stonebridge Bank 
immediately by replying to this message and deleting it from your computer.
___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Scott T. Hildreth]

Well I ran all the etc/upgrade/3.7.* upgrades and then created the 
query script with schema.mysql-4.0-4.1.pl and I get this error,

ERROR 1067 (42000) at line 36: Invalid default value for 'LookupType'

I am using Server version: 5.0.51a.

I am confused as well, if you are already on mysql > 4.0 do you need
to run the queries created by schema.mysql-4.0-4.1.pl?  I think the 
answer is probably yes, since the char set is changed to utf8.


On Wed, 2008-07-16 at 11:03 -0500, [EMAIL PROTECTED] wrote:
> Interesting.  We're running 5.0.27 and the script worked just fine.
> However, I ran all the schema/acl/insert upgrade commands using all the
> 5.7.xx directories in etc/upgrade.
> 
> Still waiting to hear from Ruslan to confirm 100% that you don't need to
> run all these commands and you need only run the schema.mysql-4.0-4.1.pl
> script.
> 
> Additionally, not entirely sure, but it sounds like he acknowledges there
> is a problem with the script.
> 
> 
> James Moseley
> 
> 
> 
> 
>
>  "Ryan Hardester"  
>  <[EMAIL PROTECTED] 
>  i.tracy.ca.us> To 
>"Ruslan Zakirov"
>  07/16/2008 10:41  <[EMAIL PROTECTED]>,
>  AM<[EMAIL PROTECTED]> 
> cc 
>  
>Subject 
>RE: [rt-users] Upgrading to 3.8.0:  
>schema.mysql,column_info selection  
>problem 
>
>
>
>
>
>
> 
> 
> 
> 
> I am getting the same column_info failed error message when running the
> script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
> the DB server since we are not running RT and the DB on the same
> machine.
> 
> --Ryan
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan
> Zakirov
> Sent: Wednesday, July 16, 2008 6:57 AM
> To: [EMAIL PROTECTED]
> Cc: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info
> selection problem
> 
> In 3.8.0 it's one step :)
> 
> However, we've done changes to mysql DB that require additional
> upgrade steps for mysql, and this step fails.
> 
> On Wed, Jul 16, 2008 at 5:24 PM,  <[EMAIL PROTECTED]> wrote:
> > Did you follow these steps first?
> >
> > You may also need to update RT's database.  To find out, type:
> >
> >   ls etc/upgrade
> >
> > For each item in that directory whose name is greater than
> > your previously installed RT version, run:
> >
> >   /opt/rt3/sbin/rt-setup-database --action schema \
> >   --datadir etc/upgrade/
> >   /opt/rt3/sbin/rt-setup-database --action acl \
> >   --datadir etc/upgrade/
> >   /opt/rt3/sbin/rt-setup-database --action insert \
> >--datadir etc/upgrade/
> >
> >
> > There are 10 3.7.xx directories that you'll need to go through.
> >
> >
> > James Moseley
> >
> >
> >
> >
> >
> > "web master"
> > <[EMAIL PROTECTED]
> > ra.com>
> To
> > Sent by:  rt-users@lists.bestpractical.com
> > rt-users-bounces@
> cc
> > lists.bestpractic
> > al.com
> Subject
> >   [rt-users] Upgrading to 3.8.0:
> >   schema.mysql, column_info
> > 07/16/2008 05:00  selection problem
> > AM
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Hi there
> > I am having schema.mysql-4.0-4.1.pl problems upgrading to version
> > 3.8.0 from 3.6.6.
> > make upgrade worked well.
> >
> > As in point 4) of UPGRADING.mysql
> >
> > [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl  > sql.queries
> >
> > but
> >
> > usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password
> >
> > Ok, then I inserted the info needed
> >
> > [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  >
> sql.queries
> >
> > but
> >
> > DBD::mysql::db column_info failed: column_info doesn't support column
> > selection

Re: [rt-users] Problems logging in after initial install

[Mark E. Walker]

Hi Jake,

I think your apache config needs help.  The only reason you'll get the "you're 
almost there" page is if mason isn't running in the directory your index.html 
file exists in.

If you have RT installed under your document root, you'll have to tell apache 
that mason handles files in that directory.  Something like this should work.  
This would be in your  in httpd.conf

   
   AddDefaultCharset UTF-8
   SetHandler perl-script
   PerlHandler RT::Mason
   

You're really close...keep trying.

mw

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jake
Sent: Wednesday, July 16, 2008 7:04 AM
To: RT-Users@lists.bestpractical.com
Subject: [rt-users] Problems logging in after initial install

I've been fiting for days with the install and I finally seem to have 
everything running on the server side with no errors, and yet I can't login...

When I go to www.mywebaddress.com/rt I get the 
message stating "You're almost there" and telling me that I need to configure 
the site to use mod_perl, fastcgi, etc...  when I go to 
www.mywebaddress.com/rt/install/index.htm
 it asks me to login, but everything I try is invalid...

It's getting to the point where I just want to scrap the whole project :(

Where exactly do I tell it that I want to use mod_perl?

Sorry if this seems like a dumb question...I've been using linux for less than 
a month, so I'm still wet behind the ears...

Jake

--
You know you've been playing Nethack too much when you look both ways down the 
corridor, start to sweat... then realize you're looking at your e-mail address.

if it weren't for fog, the world would have a very sucky framerate

before there was eve there was evil...and her name was lilith

tact is for people who aren't witty enough to be sarcastic

The level of intelligence in the world remains constant while the population 
continues to increase
___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[jmoseley]

Interesting.  We're running 5.0.27 and the script worked just fine.
However, I ran all the schema/acl/insert upgrade commands using all the
5.7.xx directories in etc/upgrade.

Still waiting to hear from Ruslan to confirm 100% that you don't need to
run all these commands and you need only run the schema.mysql-4.0-4.1.pl
script.

Additionally, not entirely sure, but it sounds like he acknowledges there
is a problem with the script.


James Moseley




   
 "Ryan Hardester"  
 <[EMAIL PROTECTED] 
 i.tracy.ca.us> To 
   "Ruslan Zakirov"
 07/16/2008 10:41  <[EMAIL PROTECTED]>,
 AM<[EMAIL PROTECTED]> 
cc 
 
   Subject 
   RE: [rt-users] Upgrading to 3.8.0:  
   schema.mysql,column_info selection  
   problem 
   
   
   
   
   
   




I am getting the same column_info failed error message when running the
script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
the DB server since we are not running RT and the DB on the same
machine.

--Ryan

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 6:57 AM
To: [EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info
selection problem

In 3.8.0 it's one step :)

However, we've done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.

On Wed, Jul 16, 2008 at 5:24 PM,  <[EMAIL PROTECTED]> wrote:
> Did you follow these steps first?
>
> You may also need to update RT's database.  To find out, type:
>
>   ls etc/upgrade
>
> For each item in that directory whose name is greater than
> your previously installed RT version, run:
>
>   /opt/rt3/sbin/rt-setup-database --action schema \
>   --datadir etc/upgrade/
>   /opt/rt3/sbin/rt-setup-database --action acl \
>   --datadir etc/upgrade/
>   /opt/rt3/sbin/rt-setup-database --action insert \
>--datadir etc/upgrade/
>
>
> There are 10 3.7.xx directories that you'll need to go through.
>
>
> James Moseley
>
>
>
>
>
> "web master"
> <[EMAIL PROTECTED]
> ra.com>
To
> Sent by:  rt-users@lists.bestpractical.com
> rt-users-bounces@
cc
> lists.bestpractic
> al.com
Subject
>   [rt-users] Upgrading to 3.8.0:
>   schema.mysql, column_info
> 07/16/2008 05:00  selection problem
> AM
>
>
>
>
>
>
>
>
>
> Hi there
> I am having schema.mysql-4.0-4.1.pl problems upgrading to version
> 3.8.0 from 3.6.6.
> make upgrade worked well.
>
> As in point 4) of UPGRADING.mysql
>
> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl  > sql.queries
>
> but
>
> usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password
>
> Ok, then I inserted the info needed
>
> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  >
sql.queries
>
> but
>
> DBD::mysql::db column_info failed: column_info doesn't support column
> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
> DBD::mysql::db column_info failed: column_info doesn't support column
> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
>
> RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need
> to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in
> 3.6.6 tarball), it seems to suggest so.
>
> Can anybody please help?
> Cheers
> ___
> 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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[jmoseley]

So, if you are upgrading from 3.6.x to 3.8.0, you don't need to follow the
step below?

> You may also need to update RT's database.  To find out, type:
>
>   ls etc/upgrade

Also, which step that you refer to below fails?  Fails for everyone?


James Moseley




   
 "Ruslan Zakirov"  
 <[EMAIL PROTECTED] 
 l.com> To 
 Sent by:  [EMAIL PROTECTED]   
 [EMAIL PROTECTED]  cc 
 ail.com   rt-users@lists.bestpractical.com
   Subject 
   Re: [rt-users] Upgrading to 3.8.0:  
 07/16/2008 08:56  schema.mysql, column_info selection 
 AMproblem 
   
   
   
   
   
   




In 3.8.0 it's one step :)

However, we've done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.





___
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 stopped working after latest yum updates

[Mark E. Walker]

Hi Kobus,

I had the same problem about two weeks ago.  Unfortunately, I never did find 
out EXACTLY what the problem was, however, an upgrade to 3.8 fixed it.  
Testdeps and fixdeps didn't help me, everything was there.

My upgrade consisted of backing up the database, blowing away the site, and 
doing the upgrade install as per the README.

Now the Upgrade install did the required testdeps/fixdeps, and that may have 
done something after blowing away the site.  I'm not sure.

During my testing I found out the following:  If I removed the perlhandler 
directive in the apache config, the site came up, but it was the "you're almost 
there" page.  Putting it back in brought up the download again.  I had no 
errors anywhere in any log files.

My guess is that mason is crashing somewhere and the resulting zero length file 
returned to the browser doesn't have any mime type so it tries to download a 
file.  Unfortunately, fixing that is beyond my current level with RT/Perl and 
Mason.

I know this may not have helped much, and I apologize, but maybe it will 
provide a little more info to get you or the community on the way.

Let us know what you eventually do to fix this.  I think it's going to be a 
recurring theme with the perl/myself update.

mw


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Barnes
Sent: Wednesday, July 16, 2008 9:02 AM
To: Kobus Bensch; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT stopped working after latest yum updates

Sounds like the perl/mysql update will require some perl module
updates.  make fixdeps may do you some good.


Kobus Bensch wrote:
>
> There was 215 updates including perl and mysql. I will post the full
> log here in a bit.
>
> Kobus
>
> Quoting Drew Barnes <[EMAIL PROTECTED]>:
>
> > What did yum update?
> >
> >
> > Kobus Bensch wrote:
> >>
> >> Hi all
> >>
> >> I use RT 3.6.5 on Centos5. Last night I performed a rather large
> >> yum update and since then rt stopped working. When I go to the rt
> >> webpage it comes up with a windows asking if I want to download a
> >> file.
> >>
> >> Can anybody help with this please.
> >>
> >> Let em know if you need more info
> >>
> >> Kobus
> >>
> >>
> >>
> 
> >>
> >> ___
> >> 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
> 
> >
> > --
> > Drew Barnes
> > Applications Analyst
> > Network Resources Department
> > Raymond Walters College
> > University of Cincinnati
>
>

--
Drew Barnes
Applications Analyst
Network Resources Department
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
___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Ryan Hardester]

I am getting the same column_info failed error message when running the
script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
the DB server since we are not running RT and the DB on the same
machine. 

--Ryan

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ruslan
Zakirov
Sent: Wednesday, July 16, 2008 6:57 AM
To: [EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info
selection problem

In 3.8.0 it's one step :)

However, we've done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.

On Wed, Jul 16, 2008 at 5:24 PM,  <[EMAIL PROTECTED]> wrote:
> Did you follow these steps first?
>
> You may also need to update RT's database.  To find out, type:
>
>   ls etc/upgrade
>
> For each item in that directory whose name is greater than
> your previously installed RT version, run:
>
>   /opt/rt3/sbin/rt-setup-database --action schema \
>   --datadir etc/upgrade/
>   /opt/rt3/sbin/rt-setup-database --action acl \
>   --datadir etc/upgrade/
>   /opt/rt3/sbin/rt-setup-database --action insert \
>--datadir etc/upgrade/
>
>
> There are 10 3.7.xx directories that you'll need to go through.
>
>
> James Moseley
>
>
>
>
>
> "web master"
> <[EMAIL PROTECTED]
> ra.com>
To
> Sent by:  rt-users@lists.bestpractical.com
> rt-users-bounces@
cc
> lists.bestpractic
> al.com
Subject
>   [rt-users] Upgrading to 3.8.0:
>   schema.mysql, column_info
> 07/16/2008 05:00  selection problem
> AM
>
>
>
>
>
>
>
>
>
> Hi there
> I am having schema.mysql-4.0-4.1.pl problems upgrading to version
> 3.8.0 from 3.6.6.
> make upgrade worked well.
>
> As in point 4) of UPGRADING.mysql
>
> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl  > sql.queries
>
> but
>
> usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password
>
> Ok, then I inserted the info needed
>
> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  >
sql.queries
>
> but
>
> DBD::mysql::db column_info failed: column_info doesn't support column
> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
> DBD::mysql::db column_info failed: column_info doesn't support column
> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
>
> RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need
> to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in
> 3.6.6 tarball), it seems to suggest so.
>
> Can anybody please help?
> Cheers
> ___
> 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
>



-- 
Best regards, Ruslan.
___
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] Create user when manually creating new ticket?

[Simon Detheridge]

Hello,

I'd like my support guys to be able to handle incoming phone calls, as  
well as incoming emails. RT works really well for incoming emails, but  
it's harder to set up a ticket with the right parameters when it's  
started from a phone call.

I'd like Support to be able to be able to either locate, or create a  
new user when creating a ticket from a phone call, and have this user  
assigned as a requestor. -- It saves having duplicate "phone",  
"email", "address" custom fields assigned to each ticket, which is  
what I'm having to do otherwise.

Is there a way to do this? Maybe a plugin?

Thanks,
Simon

-- 
Simon Detheridge
CTO, Widgit Software
26 Queen Street, Cubbington. CV32 7NA
Tel: +44 (0)1926 883488
Fax: +44 (0)1926 885293







CONFIDENTIALITY NOTICE:
This email and any attachments are for the exclusive and confidential use of 
the intended recipient.  If you are not the intended recipient, please do not 
read, distribute or take action in reliance upon this message. If you have 
received this in error, please notify us immediately by return email and 
promptly delete this message and its attachments from your computer system.

Logotron is a limited company registered in England, number 04113866. The 
registered office is Logotron Ltd, Denny Lodge Business Park, Chittering, 
Cambridge, CB25 9PH.
___
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-3.8.0 installation issue under Solaris 10

[Alan Cheng]

Indeed those files don't exist.  I will have to dig further...

[/opt/rt3/etc]$ ls -l
total 72
-r   1 root root  90 Jul 16 09:26 acl.Informix
-r--r-   1 root apache 34202 Jul 16 09:33 RT_Config.pm
-rw-r-   1 root apache   632 Jul 16 08:45 RT_SiteConfig.pm

Thanks,

Alan

[EMAIL PROTECTED] wrote:
> Did you verify the contents of /opt/rt3/etc?  The script output indicates
> that the schema and acl files in that directory don't exist, which means
> the preceding operation failed:
>
> ./install-sh -c -m 0755 -d /opt/rt3/etc
> cd etc && ./install-sh -c -m 0644 acl.Informix acl.Pg acl.Oracle
> acl.mysql acl.Sybase schema.Informix schema.Pg schema.Oracle
> schema.mysql schema.mysql-4.1 schema.Sybase schema.SQLite initialdata
> /opt/rt3/etc/
>
>
> James Moseley
>
>
> ___
> 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

Re: [rt-users] RT stopped working after latest yum updates

[Drew Barnes]

Sounds like the perl/mysql update will require some perl module 
updates.  make fixdeps may do you some good.


Kobus Bensch wrote:
>
> There was 215 updates including perl and mysql. I will post the full 
> log here in a bit.
>
> Kobus
>
> Quoting Drew Barnes <[EMAIL PROTECTED]>:
>
> > What did yum update?
> >
> >
> > Kobus Bensch wrote:
> >>
> >> Hi all
> >>
> >> I use RT 3.6.5 on Centos5. Last night I performed a rather large 
> >> yum update and since then rt stopped working. When I go to the rt 
> >> webpage it comes up with a windows asking if I want to download a 
> >> file.
> >>
> >> Can anybody help with this please.
> >>
> >> Let em know if you need more info
> >>
> >> Kobus
> >>
> >>
> >> 
> 
> >>
> >> ___
> >> 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 
> 
> >
> > --
> > Drew Barnes
> > Applications Analyst
> > Network Resources Department
> > Raymond Walters College
> > University of Cincinnati
>
>

-- 
Drew Barnes
Applications Analyst
Network Resources Department
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

Re: [rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Ruslan Zakirov]

In 3.8.0 it's one step :)

However, we've done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.

On Wed, Jul 16, 2008 at 5:24 PM,  <[EMAIL PROTECTED]> wrote:
> Did you follow these steps first?
>
> You may also need to update RT's database.  To find out, type:
>
>   ls etc/upgrade
>
> For each item in that directory whose name is greater than
> your previously installed RT version, run:
>
>   /opt/rt3/sbin/rt-setup-database --action schema \
>   --datadir etc/upgrade/
>   /opt/rt3/sbin/rt-setup-database --action acl \
>   --datadir etc/upgrade/
>   /opt/rt3/sbin/rt-setup-database --action insert \
>--datadir etc/upgrade/
>
>
> There are 10 3.7.xx directories that you'll need to go through.
>
>
> James Moseley
>
>
>
>
>
> "web master"
> <[EMAIL PROTECTED]
> ra.com>To
> Sent by:  rt-users@lists.bestpractical.com
> rt-users-bounces@  cc
> lists.bestpractic
> al.comSubject
>   [rt-users] Upgrading to 3.8.0:
>   schema.mysql, column_info
> 07/16/2008 05:00  selection problem
> AM
>
>
>
>
>
>
>
>
>
> Hi there
> I am having schema.mysql-4.0-4.1.pl problems upgrading to version
> 3.8.0 from 3.6.6.
> make upgrade worked well.
>
> As in point 4) of UPGRADING.mysql
>
> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl  > sql.queries
>
> but
>
> usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password
>
> Ok, then I inserted the info needed
>
> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  > 
> sql.queries
>
> but
>
> DBD::mysql::db column_info failed: column_info doesn't support column
> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
> DBD::mysql::db column_info failed: column_info doesn't support column
> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
>
> RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need
> to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in
> 3.6.6 tarball), it seems to suggest so.
>
> Can anybody please help?
> Cheers
> ___
> 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
>



-- 
Best regards, Ruslan.
___
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-3.8.0 installation issue under Solaris 10

[jmoseley]

Did you verify the contents of /opt/rt3/etc?  The script output indicates
that the schema and acl files in that directory don't exist, which means
the preceding operation failed:

./install-sh -c -m 0755 -d /opt/rt3/etc
cd etc && ./install-sh -c -m 0644 acl.Informix acl.Pg acl.Oracle
acl.mysql acl.Sybase schema.Informix schema.Pg schema.Oracle
schema.mysql schema.mysql-4.1 schema.Sybase schema.SQLite initialdata
/opt/rt3/etc/


James Moseley


___
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 stopped working after latest yum updates

[Drew Barnes]

What did yum update?


Kobus Bensch wrote:
>
> Hi all
>
> I use RT 3.6.5 on Centos5. Last night I performed a rather large yum 
> update and since then rt stopped working. When I go to the rt webpage 
> it comes up with a windows asking if I want to download a file.
>
> Can anybody help with this please.
>
> Let em know if you need more info
>
> Kobus
>
>
> 
>
> ___
> 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

-- 
Drew Barnes
Applications Analyst
Network Resources Department
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

Re: [rt-users] RT-3.8.0 installation issue under Solaris 10

[Alan Cheng]

Hi Joop,

Thank you very much for the tip.  I thought it may have something to do 
with the incompatibility with Soalris make (/usr/ccs/bin/make).  The 
companion CD would install the GNU make.  With the latest version of 
Solaris 10, most GNU packages have been installed in "/usr/sfw/bin".

I downloaded GNU make package from Sunfreeware and re-ran make install.  
Surprisingly it discovered a Fast CGI module being outdated.  This 
wasn't discovered by Solaris make (strange...)

At the end of this.  The same problem still persists.  I copied the 
install-sh script to several directories and this is what I got:


All dependencies have been found.
./install-sh -c -m 0755 -o root -g apache -d /opt/rt3/etc
./install-sh -c -m 0440 -o root -g apache  etc/RT_Config.pm 
/opt/rt3/etc/RT_Config.pm
[ -f /opt/rt3/etc/RT_SiteConfig.pm ] || ./install-sh -c -m 0640 -o root 
-g apache etc/RT_SiteConfig.pm /opt/rt3/etc/RT_SiteConfig.pm
Installed configuration. About to install RT in  /opt/rt3
./install-sh -c -m 0755 -d /opt/rt3/var/log
./install-sh -c -m 0770 -d /opt/rt3/var/mason_data
./install-sh -c -m 0770 -d /opt/rt3/var/mason_data/cache
./install-sh -c -m 0770 -d /opt/rt3/var/mason_data/etc
./install-sh -c -m 0770 -d /opt/rt3/var/mason_data/obj
./install-sh -c -m 0770 -d /opt/rt3/var/session_data
./install-sh -c -m 0755 -d /opt/rt3/share/html
./install-sh -c -m 0755 -d /opt/rt3/local/html
./install-sh -c -m 0755 -d /opt/rt3/local/etc
./install-sh -c -m 0755 -d /opt/rt3/local/lib
./install-sh -c -m 0755 -d /opt/rt3/local/plugins
./install-sh -c -m 0755 -d /opt/rt3/local/po
[ -d /opt/rt3/lib ] || ./install-sh -c -m 0755 -d /opt/rt3/lib
cd lib && find . -type d -name .svn -prune -o -type d -exec ./install-sh 
-c -m 0755 -d /opt/rt3/lib/{} \;
cd lib && find . -type d -name .svn -prune -o -type f -exec ./install-sh 
-c -m 0644 {} /opt/rt3/lib/{} \;
./install-sh -c -m 0755 -d /opt/rt3/etc
cd etc && ./install-sh -c -m 0644 acl.Informix acl.Pg acl.Oracle 
acl.mysql acl.Sybase schema.Informix schema.Pg schema.Oracle 
schema.mysql schema.mysql-4.1 schema.Sybase schema.SQLite initialdata 
/opt/rt3/etc/
./install-sh -c -m 0755 -d /opt/rt3/bin
cd bin && ./install-sh -c -o root -g apache -m 0755 webmux.pl 
rt-mailgate rt rt-crontool standalone_httpd mason_handler.scgi 
mason_handler.fcgi mason_handler.svc /opt/rt3/bin/
./install-sh -c -m 0755 -d /opt/rt3/sbin
cd sbin && ./install-sh -c -o root -g apache -m 0755 rt-dump-database 
rt-setup-database rt-email-digest rt-email-dashboards 
rt-email-group-admin rt-server rt-test-dependencies rt-clean-sessions 
rt-shredder  /opt/rt3/sbin/
[ -d /opt/rt3/share/html ] || ./install-sh -c -m 0755 -d /opt/rt3/share/html
cd share/html && find . -type d -name .svn -prune -o -type d -exec 
./install-sh -c -m 0755 -d /opt/rt3/share/html/{} \;
cd share/html && find . -type d -name .svn -prune -o -type f -exec 
./install-sh -c -m 0644 {} /opt/rt3/share/html/{} \;
cd local/html && find . -type d -name .svn -prune -o -type d -exec 
./install-sh -c -m 0755 -d /opt/rt3/local/html/{} \;
/bin/sh: local/html: does not exist
make: [local-install] Error 1 (ignored)
cd local/html && find . -type d -name .svn -prune -o -type f -exec 
./install-sh -c -m 0644 {} /opt/rt3/local/html/{} \;
/bin/sh: local/html: does not exist
make: [local-install] Error 1 (ignored)
cd local/po && find . -type d -name .svn -prune -o -type d -exec 
./install-sh -c -m 0755 -d /opt/rt3/local/po/{} \;
/bin/sh: local/po: does not exist
make: [local-install] Error 1 (ignored)
cd local/po && find . -type d -name .svn -prune -o -type f -exec 
./install-sh -c -m 0644 {} /opt/rt3/local/po/{} \;
/bin/sh: local/po: does not exist
make: [local-install] Error 1 (ignored)
cd local/etc && find . -type d -name .svn -prune -o -type d -exec 
./install-sh -c -m 0755 -d /opt/rt3/local/etc/{} \;
/bin/sh: local/etc: does not exist
make: [local-install] Error 1 (ignored)
cd local/etc && find . -type d -name .svn -prune -o -type f -exec 
./install-sh -c -m 0644 {} /opt/rt3/local/etc/{} \;
/bin/sh: local/etc: does not exist
make: [local-install] Error 1 (ignored)
# RT 3.0.0 - RT 3.0.2 would accidentally create a file instead of a dir
[ -f /opt/rt3/share/doc ] && rm /opt/rt3/share/doc
make: [doc-install] Error 1 (ignored)
[ -d /opt/rt3/share/doc ] || ./install-sh -c -m 0755 -d /opt/rt3/share/doc
./install-sh -c -m 0644 ./README /opt/rt3/share/doc/
# Make the libraries readable
chmod 0755 /opt/rt3
chown -R root /opt/rt3/lib
chgrp -R bin /opt/rt3/lib
chmod -R  u+rwX,go-w,go+rX  /opt/rt3/lib
chmod 0755 /opt/rt3/bin
chmod 0755 /opt/rt3/bin
chmod 0755 /opt/rt3/etc
cd /opt/rt3/etc && chmod 0400 acl.Informix acl.Pg acl.Oracle acl.mysql 
acl.Sybase schema.Informix schema.Pg schema.Oracle schema.mysql 
schema.mysql-4.1 schema.Sybase schema.SQLite initialdata
chmod: WARNING: can't access acl.Pg
chmod: WARNING: can't access acl.Oracle
chmod: WARNING: can't access acl.mysql
chmod: WARNING: can't access acl.Sybase
chmod: WARNING: can't access schema.Informix
chmod: WARNIN

Re: [rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[jmoseley]

Did you follow these steps first?

You may also need to update RT's database.  To find out, type:

   ls etc/upgrade

 For each item in that directory whose name is greater than
 your previously installed RT version, run:

   /opt/rt3/sbin/rt-setup-database --action schema \
   --datadir etc/upgrade/
   /opt/rt3/sbin/rt-setup-database --action acl \
   --datadir etc/upgrade/
   /opt/rt3/sbin/rt-setup-database --action insert \
--datadir etc/upgrade/


There are 10 3.7.xx directories that you'll need to go through.


James Moseley




   
 "web master"  
 <[EMAIL PROTECTED] 
 ra.com>To 
 Sent by:  rt-users@lists.bestpractical.com
 rt-users-bounces@  cc 
 lists.bestpractic 
 al.comSubject 
   [rt-users] Upgrading to 3.8.0:  
   schema.mysql, column_info   
 07/16/2008 05:00  selection problem   
 AM
   
   
   
   
   




Hi there
I am having schema.mysql-4.0-4.1.pl problems upgrading to version
3.8.0 from 3.6.6.
make upgrade worked well.

As in point 4) of UPGRADING.mysql

[EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl  > sql.queries

but

usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password

Ok, then I inserted the info needed

[EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  > 
sql.queries

but

DBD::mysql::db column_info failed: column_info doesn't support column
selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
DBD::mysql::db column_info failed: column_info doesn't support column
selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.

RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need
to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in
3.6.6 tarball), it seems to suggest so.

Can anybody please help?
Cheers
___
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] RT stopped working after latest yum updates

[Kobus Bensch]

  Hi all

  I use RT 3.6.5 on Centos5. Last night I performed a rather large  
yum update and since then rt stopped working. When I go to the rt  
webpage it comes up with a windows asking if I want to download a file.


  Can anybody help with this please.

  Let em know if you need more info

  Kobus

___
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-3.8.0 installation issue under Solaris 10

[Joop]

Alan Cheng wrote:
> Hello all,
>
> I am trying to install RT-3.8.0 under Solaris 10 (SPARC) and can't seem 
> to get it to work.  The error seems to suggest the "install-sh" script 
> is not found in etc (and several other subdirectories).  I tried to copy 
> the install-sh script into those directories.  The installation went 
> further but that didn't resolve the problem.
>
> Has anyone been able to install RT-3.8.0 under Solaris?  Any suggestions 
> are very appreciated.
>   
Last time I did installs on Solaris, quite a while back, I installed the 
companian cd and then made sure its install path came first in my PATH var.
Something like:
export PATH=/opt/sfw/bin:$PATH

Hope this helps you and maybe also Philip,

Joop


___
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] RT-3.8.0 installation issue under Solaris 10

[Alan Cheng]

Hello all,

I am trying to install RT-3.8.0 under Solaris 10 (SPARC) and can't seem 
to get it to work.  The error seems to suggest the "install-sh" script 
is not found in etc (and several other subdirectories).  I tried to copy 
the install-sh script into those directories.  The installation went 
further but that didn't resolve the problem.

Has anyone been able to install RT-3.8.0 under Solaris?  Any suggestions 
are very appreciated.


 make install output -
All dependencies have been found.
./install-sh -c -m 0755 -o root -g apache -d /opt/rt3/etc
./install-sh -c -m 0440 -o root -g apache  etc/RT_Config.pm 
/opt/rt3/etc/RT_Config.pm
[ -f /opt/rt3/etc/RT_SiteConfig.pm ] || ./install-sh -c -m 0640 -o root 
-g apache etc/RT_SiteConfig.pm /opt/rt3/etc/RT_SiteConfig.pm
Installed configuration. About to install RT in  /opt/rt3
./install-sh -c -m 0755 -d /opt/rt3/var/log
./install-sh -c -m 0770 -d /opt/rt3/var/mason_data
./install-sh -c -m 0770 -d /opt/rt3/var/mason_data/cache
./install-sh -c -m 0770 -d /opt/rt3/var/mason_data/etc
./install-sh -c -m 0770 -d /opt/rt3/var/mason_data/obj
./install-sh -c -m 0770 -d /opt/rt3/var/session_data
./install-sh -c -m 0755 -d /opt/rt3/share/html
./install-sh -c -m 0755 -d /opt/rt3/local/html
./install-sh -c -m 0755 -d /opt/rt3/local/etc
./install-sh -c -m 0755 -d /opt/rt3/local/lib
./install-sh -c -m 0755 -d /opt/rt3/local/plugins
./install-sh -c -m 0755 -d /opt/rt3/local/po
[ -d /opt/rt3/lib ] || ./install-sh -c -m 0755 -d /opt/rt3/lib
cd lib && find . -type d -name .svn -prune -o -type d -exec ./install-sh 
-c -m 0755 -d /opt/rt3/lib/{} \;
cd lib && find . -type d -name .svn -prune -o -type f -exec ./install-sh 
-c -m 0644 {} /opt/rt3/lib/{} \;
./install-sh -c -m 0755 -d /opt/rt3/etc
cd etc && ./install-sh -c -m 0644 acl.Informix  acl.Pg  acl.Oracle  
acl.mysql  acl.Sybase  schema.Informix  schema.Pg  schema.Oracle  
schema.mysql  schema.mysql-4.1  schema.Sybase  schema.SQLite  
initialdata /opt/rt3/etc/
sh: ./install-sh: not found
*** Error code 1
make: Fatal error: Command failed for target `etc-install'





Thanks,

Alan
___
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] New install of RT 3.8.0 - Another Logo Issue

[brokenshadows]

I'm having the same issue.  I get that error when I try to go to
http://www.mywebaddress.com/rt/install/index.htm  When I go to
www.mywebaddress.com/rt I get the "You're almost there" message telling me I
need to configure my server to use mod_perl, fastcgi, etc...

this thing is giving me a headache...


Wayne Richardson wrote:
> 
> When I attempt to access the logo directly at
> http://localhost/rt/NoAuth/images/bplogo.gif, I get this error:
> Can't locate object method "header_out" via package
> "Apache2::RequestRec" at /opt/rt3/share/html/dhandler line 53.
> 
> Line 53 it is refering to:
> $r->header_out( Status => '404 File not found' );
> 
> Mind you, this is a *brand* new OS installation, installed from
> source, perl modules installed, etc.  If I add PerlModule
> Apache2::compat into my apache2 config, it actually displays a
> "proper" 404, but is
> 

-- 
View this message in context: 
http://www.nabble.com/New-install-of-RT-3.8.0---Another-Logo-Issue-tp1846p18486616.html
Sent from the Request Tracker - User mailing list archive at Nabble.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] Problems logging in after initial install

[Jake]

I've been fiting for days with the install and I finally seem to have
everything running on the server side with no errors, and yet I can't
login...

When I go to www.mywebaddress.com/rt I get the message stating "You're
almost there" and telling me that I need to configure the site to use
mod_perl, fastcgi, etc...  when I go to
www.mywebaddress.com/rt/install/index.htm it asks me to login, but
everything I try is invalid...

It's getting to the point where I just want to scrap the whole project :(

Where exactly do I tell it that I want to use mod_perl?

Sorry if this seems like a dumb question...I've been using linux for less
than a month, so I'm still wet behind the ears...

Jake

-- 
You know you've been playing Nethack too much when you look both ways down
the corridor, start to sweat... then realize you're looking at your e-mail
address.

if it weren't for fog, the world would have a very sucky framerate

before there was eve there was evil...and her name was lilith

tact is for people who aren't witty enough to be sarcastic

The level of intelligence in the world remains constant while the population
continues to increase
___
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] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[web master]

Hi there
I am having schema.mysql-4.0-4.1.pl problems upgrading to version
3.8.0 from 3.6.6.
make upgrade worked well.

As in point 4) of UPGRADING.mysql

[EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl  > sql.queries

but

usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password

Ok, then I inserted the info needed

[EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  > 
sql.queries

but

DBD::mysql::db column_info failed: column_info doesn't support column
selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
DBD::mysql::db column_info failed: column_info doesn't support column
selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.

RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need
to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in
3.6.6 tarball), it seems to suggest so.

Can anybody please help?
Cheers
___
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