[rt-users] problem with upgrade rt 3.6.7-3.8.1rc4

2008-08-15 Thread Alexander Kubatkin
Hello.

My RT-3.6.7 working fine under FreeBSD 7-STABLE x86_64 with:
1. Apache 2.2.8
2. mod_perl2-2.0.3_3,3
3. MySQL 5.0.51-log
4. all p5 and other packages from lastest FreeBSD ports
current database 2 years old and have size ~500MB and attachments have 112888 
elements


but i can't upgrade to 3.8.x, below a result from trying to upgrade to 3.8.1rc4:

/usr/local/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password 
--action upgrade
In order to create or update your RT database, this script needs to connect to 
your  mysql instance on 127.0.0.1 as root
Please specify that user's database password below. If the user has no database 
password, just press return.

Password:
Working with:
Type:   mysql
Host:   127.0.0.1
Name:   rt3
User:   rt_user
DBA:root
Enter RT version you're upgrading from: 3.6.7

Going to apply following upgrades:
* 3.7.1
* 3.7.3
* 3.7.10
* 3.7.15
* 3.7.19
* 3.7.81
* 3.7.82
* 3.7.85
* 3.7.86
* 3.7.87
* 3.8.0
* 3.8.1

Enter RT version if you want to stop upgrade at some point,
  or leave it blank if you want apply above upgrades:

HI THERE IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 3.7.1
[Thu Aug 14 17:33:29 2008] [warning]: DBD::mysql::db selectrow_array failed: 
MySQL server has gone away at /usr/local/rt3/sbin/../lib/RT/Handle.pm line 
257, STDIN line 4. (/usr/local/rt3/sbin/../lib/RT/Handle.pm:257)
[Thu Aug 14 17:33:29 2008] [crit]: DBD::mysql::db selectrow_array failed: MySQL 
server has gone away at /usr/local/rt3/sbin/../lib/RT/Handle.pm line 
257, STDIN line 4. (/usr/local/rt3/sbin/../lib/RT.pm:377)
DBD::mysql::db selectrow_array failed: MySQL server has gone away at 
/usr/local/rt3/sbin/../lib/RT/Handle.pm line 257, STDIN line 4.
--

Need some help to upgrade.

Thanks


-- 
Alexander Kubatkin
___
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] problem with upgrade rt 3.6.7-3.8.1rc4

2008-08-15 Thread Jesse Vincent

On Aug 15, 2008, at 8:02 AM, Alexander Kubatkin wrote:

 Hello.

 My RT-3.6.7 working fine under FreeBSD 7-STABLE x86_64 with:
 1. Apache 2.2.8
 2. mod_perl2-2.0.3_3,3
 3. MySQL 5.0.51-log
 4. all p5 and other packages from lastest FreeBSD ports
 current database 2 years old and have size ~500MB and attachments  
 have 112888 elements


Alexander, can you tell us if anything shows up in the mysql error  
logs? Also, what version of DBD::mysql do you have installed?

___
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] problem with upgrade rt 3.6.7-3.8.1rc4

2008-08-15 Thread Alexander Kubatkin
В сообщении от Пятница 15 августа 2008 вы написали:
 On Aug 15, 2008, at 8:02 AM, Alexander Kubatkin wrote:
  Hello.
 
  My RT-3.6.7 working fine under FreeBSD 7-STABLE x86_64 with:
  1. Apache 2.2.8
  2. mod_perl2-2.0.3_3,3
  3. MySQL 5.0.51-log
  4. all p5 and other packages from lastest FreeBSD ports
  current database 2 years old and have size ~500MB and attachments
  have 112888 elements

 Alexander, can you tell us if anything shows up in the mysql error
 logs? 

no special errors, only regular not critical errors such us:

080814 16:48:05  mysqld started
080814 16:48:06  InnoDB: Started; log sequence number 0 2672904431
080814 16:48:06 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.51a-log'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: 
mysql-server-5.0.51a
080814 17:07:40 [Warning] Aborted connection 6 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 17:24:19 [Warning] Aborted connection 18 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 17:24:20 [Warning] Aborted connection 3 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 17:24:21 [Warning] Aborted connection 19 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 17:24:22 [Warning] Aborted connection 15 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 17:49:56 [Warning] Aborted connection 2 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 18:07:08 [Warning] Aborted connection 1 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 18:12:33 [Warning] Aborted connection 83 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 18:12:34 [Warning] Aborted connection 23 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 18:12:35 [Warning] Aborted connection 21 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 18:12:36 [Warning] Aborted connection 20 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 18:19:33 [Warning] Aborted connection 86 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 19:00:46 [Warning] Aborted connection 84 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:06:08 [Warning] Aborted connection 82 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:06:25 [Warning] Aborted connection 90 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:14:26 [Warning] Aborted connection 85 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:16:40 [Warning] Aborted connection 71 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:16:40 [Warning] Aborted connection 22 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:16:40 [Warning] Aborted connection 87 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:18:29 [Warning] Aborted connection 250 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:18:29 [Warning] Aborted connection 249 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:18:29 [Warning] Aborted connection 247 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:18:29 [Warning] Aborted connection 248 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:21:15 [Warning] Aborted connection 251 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080814 22:25:08 [Warning] Aborted connection 255 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
080815  2:07:09 [Warning] Aborted connection 252 to db: 'rt3' user: 'rt_user' 
host: 'localhost' (Got an error reading communication packets)
---
i'm trying to upgrade between 21 and 22 (+/-)hours.

 Also, what version of DBD::mysql do you have installed? 

#pkg_info | grep -i dbd
p5-DBD-mysql50-4.006 MySQL 5.0 driver for the Perl5 Database Interface (DBI)
p5-DBI-1.60.4   The perl5 Database Interface.  Required for DBD::* modules



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

Community help: http://wiki.bestpractical.com

[rt-users] Default status' for queue lists.

2008-08-15 Thread Curtis Bruneau
In the Quick Search queue listing on RT at a Glance is there a way to 
change the default status' that is searched? It individually shows 
new/open/stalled and the queue link itself has all three.. I would like 
to exclude stalled from the main link. I know I could achieve this 
editing files but just wondering if there was a configuration way. Our 
3.4 excluded stalled ( i don't know if this is custom or not, I didn't 
originally set it up ).

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


[rt-users] make initialize-database error

2008-08-15 Thread Chaim Rieger
innodb is not disabled


In order to create or update your RT database, this script needs to 
connect to your  mysql instance on localhost as root
Please specify that user's database password below. If the user has no 
database
password, just press return.

Password:
Working with:
Type:   mysql
Host:   localhost
Name:   rt3
User:   user
DBA:user
Couldn't finish 'create' step.

ERROR: RT requires that MySQL InnoDB table support be enabled.
Remove the 'skip-innodb' line from your my.cnf file, restart MySQL, and 
try again.


make: *** [initialize-database] Error 255



my.cnf is as follows

# Example MySQL config file for large systems.
#
# This is for a large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the --help option.

# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port= 3306
socket  = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the enable-named-pipe option) will render mysqld useless!
#
#skip-networking

# Disable Federated by default
skip-federated

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id   = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#the syntax is:
#
#CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port,
#MASTER_USER=user, MASTER_PASSWORD=password ;
#
#where you replace host, user, password by quoted strings and
#port by the master's port number (3306 by default).
#
#Example:
#
#CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#start replication for the first time (even unsuccessfully, for example
#if you mistyped the password in master-password and the slave fails to
#connect), the slave will create a master.info file, and any later
#change in this file to the variables' values below will be ignored and
#overridden by the content of the master.info file, unless you shutdown
#the slave server, delete master.info and restart the slaver server.
#For that reason, you may want to leave the lines below untouched
#(commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id   = 2
#
# The replication master for this slave - required
#master-host =   hostname
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user =   username
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   password
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port =  port
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 64M
#bdb_max_lock = 10

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 256M

Re: [rt-users] make initialize-database error

2008-08-15 Thread Jerrad Pierce
Was your MySQL maybe *built* without InnoDB?

P.S. Why aren't the rt lists configured for reply-to list?
-- 
Cambridge Energy Alliance: Save money  the planet
___
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] make initialize-database error

2008-08-15 Thread Chaim Rieger
Jerrad Pierce wrote:
 Was your MySQL maybe *built* without InnoDB?
 
 -- 
 Cambridge Energy Alliance: Save money  the planet

i installed the binary,

if it was built without innodb support it wouldnt start up with the 
current my.cnf
-- 
--
Chaim Rieger
___
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] make initialize-database error

2008-08-15 Thread Jerrad Pierce

 i installed the binary,

 if it was built without innodb support it wouldnt start up with the
 current my.cnf

I wasn't sure. Not all applications are as finicky as Apache, and are more
lax in their
acceptance of input i.e; not blowing up because you specify irrelevant
options

-- 
Cambridge Energy Alliance: Save money  the planet
___
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 at Glance and upgrade from 3.2.1 to 3.8.0

2008-08-15 Thread Ruslan Zakirov
1) try 3.8.1rc5
2) do you upgrade mysql as well?

On Tue, Aug 12, 2008 at 10:55 AM, Jean-Michel Barbet
[EMAIL PROTECTED] wrote:
 Jean-Michel Barbet wrote:

 The problem with accents is fixed.

 Sorry, I spoke too soon. I still have a problem with the column
 Content of the Attachements table.

 In RT 3.2.1/MySQL4.0 this column is longtext

 The mysql upgrade scripts does this :

 ALTER TABLE Attachments MODIFY Content LONGBLOB NULL DEFAULT NULL;

 which results in corrupted accents

 If I change back to LONGTEXT, it is OK.

 = What should I do ? Is is important that the type of this column
is LONGBLOB in RT 3.8.0 and if yes, how do I convert from RT 3.2.1
without corrupting the accents ?

 Thanks and sorry to bring new issues.

 JM



 --
 
 Jean-michel BARBET| Tel: +33 (0)2 51 85 84 86
 Laboratoire SUBATECH Nantes France| Fax: +33 (0)2 51 85 84 79
 CNRS-IN2P3/Ecole des Mines/Universite | E-Mail: [EMAIL PROTECTED]
 
 ___
 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] customizing rt, question

2008-08-15 Thread Tim Cutts

On 15 Aug 2008, at 4:53 pm, Chaim Rieger wrote:

 we (the company i work for) is thinking about allowing web access to  
 the
 world for our rt. we have multiple instances of it in house, and use  
 it
 extensively. however prior to rolling it out, they would like to see a
 plain login page with nothing but Login/Username/Passwd, no  
 versions, no
 links, no logos.

 is this doable ?

Yes.


 would we have to purchase support in order to remove the logo ?

No, but you do need some expertise in understanding HTML::Mason in  
order to override the default page with a copy of your own which does  
what you require.  One of the nicest things about RT is that such  
customisations are easy to do in a clean way.  See BestPractical's  
wiki for examples and more information.

Tim


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE. 
___
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] Hierarchy View in 3.8

2008-08-15 Thread Helmuth Ramirez
Hi everyone,
This may seem like a dumb question, BUT...how do I get the hierarchy
view of my tickets (child/parent/depends on, etc)?  I tried reading
through the manual but I couldn't find it (unless I overlooked it).

Thank you!!
Helmuth
___
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] Hierarchy View in 3.8

2008-08-15 Thread Jerrad Pierce
Click the links tab for a ticket, and then the Graph anchor in the upper
right corner.

-- 
Cambridge Energy Alliance: Save money  the planet
___
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] Hierarchy View in 3.8

2008-08-15 Thread scott smith
Helmuth Ramirez wrote:
 Thanks Jerrad,
 
 I think I either don’t have it or I’m doing something wrong.  Here is a 
 screenshot of my Links tab
 

You need to install graphviz

-scott
___
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] Rt3.8 package for debian

2008-08-15 Thread Andrew Ruthven
Hi Johan,

The packages that Emmanuel Lacour have built only include the required
dependencies for Etch (they're already present for Lenny).

I've built some RT 3.8.1rc5 packages which I've been using on Lenny.
I've back-ported them to Etch, but haven't tested them on Etch.  Feel
free to try using them (you'll need Emmanuel's repo as well for Etch).
Please let me know if there are any issues.

The lines for your apt sources.list file are:

deb http://debian.etc.gen.nz etch rt

or

deb http://debian.etc.gen.nz lenny rt

Cheers!

On Thu, 2008-08-14 at 13:17 +0300, johan baarman wrote:
 Hi,
 
 I'm about to try out the new rt3.8 on debian etch and saw that
 Emmanuel Lacour already built a package for it. Can I install rt3.8
 directly by that package or is it only for the dependencies?
 
 On 1 Aug 2008, at 8:52 am, Emmanuel Lacour wrote:
 
  As I already said here, I made needed packages for etch here:
 
  http://rt.easter-eggs.org/debian/
 
  this can help you ;)
 
  _
 
 
 Br, Johan
 ___
 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
 
-- 
Andrew Ruthven
Wellington, New Zealand
At home: [EMAIL PROTECTED]   |  This space intentionally
 |left blank.


signature.asc
Description: This is a digitally signed message part
___
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] upgrade from 3.6.6 pgsql to 3.8.1rc5

2008-08-15 Thread Miles Scruggs
I just did an upgrade, everything seems to be working fine, just for  
kicks I tried to create a ticket and I get this error:


Can't call method HasRight on an undefined value at /opt/6sq-rt/ 
bin/../lib/RT/User_Overlay.pm line 1209.



Trace begun at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Exceptions.pm  
line 129
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method  
HasRight on an undefined value at /opt/6sq-rt/bin/../lib/RT/ 
User_Overlay.pm line 1209.^J') called at /opt/6sq-rt/bin/../lib/RT/ 
User_Overlay.pm line 1209
RT::User::HasRight('RT::CurrentUser=HASH(0x9fdb868)', 'Right',  
'SeeQueue', 'Object', 'RT::Queue=HASH(0xaa64eb4)') called at /opt/6sq- 
rt/bin/../lib/RT/Queue_Overlay.pm line 1183
RT::Queue::HasRight('RT::Queue=HASH(0xaa64eb4)', 'Principal',  
'RT::CurrentUser=HASH(0x9fdb868)', 'Right', 'SeeQueue') called at /opt/ 
6sq-rt/bin/../lib/RT/Queue_Overlay.pm line 1148
RT::Queue::CurrentUserHasRight('RT::Queue=HASH(0xaa64eb4)',  
'SeeQueue') called at /opt/6sq-rt/bin/../lib/RT/Queue_Overlay.pm line  
1124
RT::Queue::_Value('RT::Queue=HASH(0xaa64eb4)', 'Disabled') called at / 
usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 424
DBIx::SearchBuilder::Record::__ANON__('RT::Queue=HASH(0xaa64eb4)')  
called at /opt/6sq-rt/bin/../lib/RT/Ticket_Overlay.pm line 288
RT::Ticket::Create('RT::Ticket=HASH(0xaa64218)', 'TimeEstimated', '',  
'Status', 'new', 'Queue', 'help', 'AdminCc', '', 'MIMEObj',  
'MIME::Entity=HASH(0xaa645b4)', 'Type', 'ticket', 'InitialPriority',  
0, 'Starts', undef, 'TimeWorked', '', 'Requestor',  
'[EMAIL PROTECTED]', 'Cc', '', 'Subject', 'test', 'FinalPriority',  
0, 'TimeLeft', '', 'Owner', 10, 'Due', undef) called at /opt/6sq-rt/ 
bin/../lib/RT/Interface/Web.pm line 530
HTML::Mason::Commands::CreateTicket('Attachments', undef,  
'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', 'Queue',  
'help', 'AdminCc', '', 'Requestors', '[EMAIL PROTECTED]',  
'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '',  
'id', 'new', 'TimeEstimated-TimeUnits', 'minutes', 'Cc', '',  
'Subject', 'test', 'FinalPriority', 0, 'new-RefersTo', '', 'TimeLeft',  
'', 'TimeLeft-TimeUnits', 'minutes', 'RefersTo-new', '', 'Owner', 10,  
'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '',  
'Content', 'another test ticket on newly upgraded system.',  
'TimeWorked-TimeUnits', 'minutes', 'Due', '') called at /opt/6sq-rt/ 
share/html/Ticket/Display.html line 117
HTML::Mason::Commands::__ANON__('TimeEstimated', '', 'Status', 'new',  
'new-DependsOn', '', 'Queue', 'help', 'AdminCc', '', 'Requestors', '[EMAIL PROTECTED] 
', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '',  
'id', 'new', 'TimeEstimated-TimeUnits', 'minutes', 'Cc', '',  
'Subject', 'test', 'FinalPriority', 0, 'new-RefersTo', '', 'RefersTo- 
new', '', 'TimeLeft-TimeUnits', 'minutes', 'TimeLeft', '', 'DependsOn- 
new', '', 'Owner', 10, 'new-MemberOf', '', 'MemberOf-new', '',  
'Content', 'another test ticket on newly upgraded system.', 'Due', '',  
'TimeWorked-TimeUnits', 'minutes') called at /usr/lib/perl5/site_perl/ 
5.8.8/HTML/Mason/Component.pm line 135
HTML 
::Mason 
::Component::run('HTML::Mason::Component::FileBased=HASH(0xaa61f80)',  
'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', 'Queue',  
'help', 'AdminCc', '', 'Requestors', '[EMAIL PROTECTED]',  
'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '',  
'id', 'new', 'TimeEstimated-TimeUnits', 'minutes', 'Cc', '',  
'Subject', 'test', 'FinalPriority', 0, 'new-RefersTo', '', 'RefersTo- 
new', '', 'TimeLeft-TimeUnits', 'minutes', 'TimeLeft', '', 'DependsOn- 
new', '', 'Owner', 10, 'new-MemberOf', '', 'MemberOf-new', '',  
'Content', 'another test ticket on newly upgraded system.', 'Due', '',  
'TimeWorked-TimeUnits', 'minutes') called at /usr/lib/perl5/site_perl/ 
5.8.8/HTML/Mason/Request.pm line 1278
eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm  
line 1268
HTML::Mason::Request::comp(undef, undef, 'TimeEstimated', '',  
'Status', 'new', 'new-DependsOn', '', 'Queue', 'help', 'AdminCc', '',  
'Requestors', '[EMAIL PROTECTED]', 'InitialPriority', 0, 'Starts',  
'', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'TimeEstimated- 
TimeUnits', 'minutes', 'Cc', '', 'Subject', 'test', 'FinalPriority',  
0, 'new-RefersTo', '', 'RefersTo-new', '', 'TimeLeft-TimeUnits',  
'minutes', 'TimeLeft', '', 'DependsOn-new', '', 'Owner', 10, 'new- 
MemberOf', '', 'MemberOf-new', '', 'Content', 'another test ticket on  
newly upgraded system.', 'Due', '', 'TimeWorked-TimeUnits', 'minutes')  
called at /opt/6sq-rt/share/html/Ticket/Create.html line 398
HTML::Mason::Commands::__ANON__('TimeEstimated', '', 'Status', 'new',  
'new-DependsOn', '', 'Queue', 'help', 'AdminCc', '', 'Requestors', '[EMAIL PROTECTED] 
', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '',  
'id', 'new', 'TimeEstimated-TimeUnits', 'minutes', 'Cc', '',  
'Subject', 'test', 'FinalPriority', 0, 'new-RefersTo', 

Re: [rt-users] Hierarchy View in 3.8

2008-08-15 Thread Helmuth Ramirez
Hi Scott,
I installed graphviz...but now I don't know what to do :(.  I tried searching 
the wiki and the archives but couldn't find anything on how to configure.
 
Thanks for your help



From: scott smith [mailto:[EMAIL PROTECTED]
Sent: Fri 8/15/2008 6:21 PM
To: Helmuth Ramirez
Cc: Jerrad Pierce; RT Users
Subject: Re: [rt-users] Hierarchy View in 3.8



Helmuth Ramirez wrote:
 Thanks Jerrad,

 I think I either don't have it or I'm doing something wrong.  Here is a
 screenshot of my Links tab


You need to install graphviz

-scott


___
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] Hierarchy View in 3.8

2008-08-15 Thread scott smith
Helmuth Ramirez wrote:
 Hi Scott,
 I installed graphviz...but now I don't know what to do :(.  I tried 
 searching the wiki and the archives but couldn't find anything on how to 
 configure.
  

You should be able to just do another `make install' and start using it, 
assuming you have fulfilled all dependencies (check again with `make 
testdeps')

-scott
___
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] Hierarchy View in 3.8

2008-08-15 Thread Helmuth Ramirez
ok, I ran the testdeps, everything was found.  I then did a `make install'.  I 
received the friendly `Congratulations. RT is now installed.' message.  I 
restarted web server, still no option for graph.
 
Thanks Scott.



From: scott smith [mailto:[EMAIL PROTECTED]
Sent: Fri 8/15/2008 9:07 PM
To: Helmuth Ramirez
Cc: Jerrad Pierce; RT Users
Subject: Re: [rt-users] Hierarchy View in 3.8



Helmuth Ramirez wrote:
 Hi Scott,
 I installed graphviz...but now I don't know what to do :(.  I tried
 searching the wiki and the archives but couldn't find anything on how to
 configure.
 

You should be able to just do another `make install' and start using it,
assuming you have fulfilled all dependencies (check again with `make
testdeps')

-scott


___
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] Hierarchy View in 3.8

2008-08-15 Thread scott smith
Helmuth Ramirez wrote:
 ok, I ran the testdeps, everything was found.  I then did a `make 
 install'.  I received the friendly `Congratulations. RT is now 
 installed.' message.  I restarted web server, still no option for graph.

Hmm, have you tried clearing the object cache and logging out  back in?

-scott
___
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] Hierarchy View in 3.8

2008-08-15 Thread Helmuth Ramirez
ok, cleared cache by rm -rf /path/to/rt/var/mason_data/obj
 
restarted httpd (just for good measure)
 
logged in, still don't have the option on the Links tab.  I installed Graphviz 
via yum, not sure if that makes a difference or not.
 
Thanks



From: scott smith [mailto:[EMAIL PROTECTED]
Sent: Fri 8/15/2008 9:23 PM
To: Helmuth Ramirez
Cc: Jerrad Pierce; RT Users
Subject: Re: [rt-users] Hierarchy View in 3.8



Helmuth Ramirez wrote:
 ok, I ran the testdeps, everything was found.  I then did a `make
 install'.  I received the friendly `Congratulations. RT is now
 installed.' message.  I restarted web server, still no option for graph.

Hmm, have you tried clearing the object cache and logging out  back in?

-scott


___
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] Hierarchy View in 3.8

2008-08-15 Thread Helmuth Ramirez
More details
 
I tried doing a configure with
 
./configure --with-web-user=apache --with-web-group=apache --with-modperl2 
--with-mysql --enable-graphviz --enable-gd 
 
added the graphviz and gd to my original line.  Once that was done it showed 
missing dependencies.  Ran fixdeps and got everything except one 
thing...Graphviz!  Now I'm really stuck.  I installed Graphviz via yum but it 
seems the the testdeps script doesn't know its there??  If I rerun the make 
install would it 'see' it then?
 
Sorry about the potentially elementary questions, but getting this feature to 
work is something we've been waiting for.
 
Cheers!



From: [EMAIL PROTECTED] on behalf of Helmuth Ramirez
Sent: Fri 8/15/2008 9:33 PM
To: scott smith
Cc: RT Users
Subject: Re: [rt-users] Hierarchy View in 3.8


ok, cleared cache by rm -rf /path/to/rt/var/mason_data/obj
 
restarted httpd (just for good measure)
 
logged in, still don't have the option on the Links tab.  I installed Graphviz 
via yum, not sure if that makes a difference or not.
 
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] Hierarchy View in 3.8

2008-08-15 Thread Helmuth Ramirez
Ok, I spoke a wee bit too soon.
 
I have the graph option, but when I go to graph something I don't get the 
pretty chart.  I get this in my log
 
Error: Layout was not done.  Missing layout plugins?

I guess its just a little something I'm missing?



From: [EMAIL PROTECTED] on behalf of Helmuth Ramirez
Sent: Fri 8/15/2008 9:59 PM
To: scott smith
Cc: RT Users
Subject: Re: [rt-users] Hierarchy View in 3.8


Ok, I got it!
 
I had installed GraphViz via yum, BUT I was missing 'perl-GraphViz'.  Once I 
installed that I got the Graph option!
 
Thanks to Scott and Jerrad for your help and patience!
 
Have a great weekend.
___
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