Re: [rt-users] Permission Denied Error - Ticket creation using mail

2009-09-16 Thread Baskaraganesan Natarajan
Hi,

I found that my sendmail configuration was wrong. When I get this corrected in 
my sendmail.cf file, I got rid of this error.  But getting a different error 
this time (Log below).  Searching thru, I see the following line in 
http://mail.python.org/pipermail/mailman-users/2000-June/005182.html. Any help 
from here...

Sendmail won't deliver to a setuid program unless the directory where the
process resides is writable only by the owner.  That means no group write
or `other' write priviledges.  Mailman requires that the `s' bit be set
for the group.


Changed 
Mprog,  P=/etc/smrsh/
To 
Mprog,  P=/usr/sbin/smrsh

Log
===
Sep 16 12:15:01 localhost sendmail[15363]: n8G6j0O6015363: from=root, size=0, 
class=0, nrcpts=1, relay=r...@localhost
Sep 16 12:15:13 localhost sendmail[15365]: n8G6jAvi015365: from=root, size=11, 
class=0, nrcpts=1, msgid=200909160645.n8g6javi015...@localhost.localdomain, 
relay=r...@localhost
Sep 16 12:15:13 localhost sendmail[15366]: n8G6jDAd015366: 
from=r...@localhost.localdomain, size=300, class=0, nrcpts=1, 
msgid=200909160645.n8g6javi015...@localhost.localdomain, proto=ESMTP, 
daemon=MTA, relay=localhost.localdomain [127.0.0.1]
Sep 16 12:15:13 localhost sendmail[15365]: n8G6jAvi015365: to=helpdesk, 
ctladdr=root (0/0), delay=00:00:03, xdelay=00:00:00, mailer=relay, pri=30011, 
relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (n8G6jDAd015366 Message 
accepted for delivery)
Sep 16 12:15:13 localhost sendmail[15367]: n8G6jDAd015366: to=|rt-mailgate 
--queue 'CI new' --action correspond, ctladdr=helpd...@localhost.localdomain 
(8/0), delay=00:00:00, xdelay=00:00:00, mailer=prog, pri=30543, dsn=5.3.0, 
stat=unknown mailer error 1
Sep 16 12:15:13 localhost sendmail[15367]: n8G6jDAd015366: n8G6jDAd015367: DSN: 
unknown mailer error 1
Sep 16 12:15:13 localhost sendmail[15367]: n8G6jDAd015367: 
to=r...@localhost.localdomain, delay=00:00:00, xdelay=00:00:00, mailer=local, 
pri=31567, dsn=2.0.0, stat=Sent

Thanks,
Baskar N

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Tuesday, September 15, 2009 10:21 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Permission Denied Error - Ticket creation using mail

On Tue, Sep 15, 2009 at 01:20:07PM +0530, Baskaraganesan Natarajan wrote:
Retrying...
[r...@localhost log]# ls -ltr /etc/ | grep smr

drwxrwxrwx  2 root root4096 2009-08-28 18:11 smrsh

Sep 15 10:38:34 localhost sendmail[8712]: n8EA3n3F006454: Warning: program 
 /etc/smrsh/ unsafe:
World writable directory

Read the error messages, you can't have a world writable /etc/smrsh

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

DISCLAIMER:
---

The contents of this e-mail and any attachment(s) are confidential and intended 
for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its affiliates. 
Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the 
opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is 
strictly prohibited. If you have 
received this email in error please delete it and notify the sender 
immediately. Before opening any mail and 
attachments please check them for viruses and defect.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-09-16 Thread Justin Hayes
Thanks a lot for the info and advise Aaron. Don't suppose you kept the  
scripts you used to dump the attachments and load them back in did you?


I'm going to talk to my sysadmins and see if they are using that  
default-character-set option in the backup dump. If they aren't I'll  
get them to do me a new dump with that option on and see if it works  
that time.


Cheers,

Justin

On 15 Sep 2009, at 23:36, Aaron Guise wrote:

I had similar problems when moving upto 3.8.1.  The previous  
sysadmin responsible for RT had failed to upgrade the DB properly  
when going from 3.6.5 to 3.8.0 some time back.  All our attachments  
went screwy too when I tried to upgrade to 3.8.1.


In the end what I did is dump the database before upgrade in case I  
need to go back.  Dumped all attachment records to disk via perl,  
ran the RT upgrade scripts and then updated the attachments table  
from the ones I had dumped out earlier.


This then made all the attachments become working again.  RT itself  
also seemed to get a performance boost !YAY!.  And the two ALTER  
entries in the upgrade script I found as well, Prior to running the  
upgrade I removed the ones that weren't binary columns e.g.  
VARBINARY so removing the lines which mentioned something like  
LONGBLOB.


When you use mysqldump to backup the database you just need to make  
sure to place this --opt --default-character-set=binary in the  
commandline arguments.   That will mean it exports in binary mode to  
avoid corruption.


Regards,
Aaron Guise
  07 838 7793
027 212 6638
aa...@guise.net.nz




On Wed, Sep 16, 2009 at 7:54 AM, Justin Hayes justin.ha...@orbisuk.com 
 wrote:

Hi guys,

I'm just testing an upgrade from 3.6.3 to 3.8.4. I ran the rt-setup- 
database fine:


/opt/rt_support.openbet.com/sbin/rt-setup-database -dba rt_support -- 
prompt-for-dba-password --action upgrade


Then created the schema upgrade script:

perl /opt/rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl  
*blah* *blah* *password*  upgrade.sql
Use of uninitialized value in join or string at /opt/ 
rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl line 261.

.Tickets.status has type VARCHAR however mapping is missing.
Use of uninitialized value in join or string at /opt/ 
rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl line 261.

.Users.BlockImg has type CHAR however mapping is missing.
-- ** NOTICE: No database changes have been made. **
-- Please review the generated SQL, ensure you have a full backup of  
your database 
-- and apply it to your database using a command like:

-- mysql -u rt_support -p rt_support  queries.sql;

cat upgrade.sql
ALTER DATABASE rt_support DEFAULT CHARACTER SET utf8;
ALTER TABLE ACL
   DEFAULT CHARACTER SET utf8,
   MODIFY RightName VARBINARY(25) NOT NULL,
   MODIFY PrincipalType VARBINARY(25) NOT NULL,
   MODIFY ObjectType VARBINARY(25) NOT NULL;
ALTER TABLE ACL
   MODIFY RightName VARCHAR(25) CHARACTER SET ascii NOT NULL,
   MODIFY PrincipalType VARCHAR(25) CHARACTER SET ascii NOT NULL,
   MODIFY ObjectType VARCHAR(25) CHARACTER SET ascii NOT NULL;
ALTER TABLE Attachments
   DEFAULT CHARACTER SET utf8,
   MODIFY Subject VARBINARY(255) NULL DEFAULT NULL,
   MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL,
   MODIFY Filename VARBINARY(255) NULL DEFAULT NULL,
   MODIFY Headers LONGBLOB NULL DEFAULT NULL,
   MODIFY MessageId VARBINARY(160) NULL DEFAULT NULL,
   MODIFY Content LONGBLOB NULL DEFAULT NULL,
   MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT NULL;
ALTER TABLE Attachments
   MODIFY Subject VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL,
   MODIFY ContentType VARCHAR(80) CHARACTER SET ascii NULL DEFAULT  
NULL,

   MODIFY Filename VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL,
   MODIFY Headers LONGTEXT CHARACTER SET utf8 NULL DEFAULT NULL,
   MODIFY MessageId VARCHAR(160) CHARACTER SET ascii NULL DEFAULT  
NULL,
   MODIFY ContentEncoding VARCHAR(80) CHARACTER SET ascii NULL  
DEFAULT NULL;

.
.
.


Now that looks a bit odd as there are 2 ALTERS per table and the  
second seems to reverse some bits of the first?


Anyway I ran that into my DB. Now when I go into a ticket with an  
image attached and click on it no image is returned, which is a bit  
worrying.


I'm wondering if it was a problem with the upgrade, or the original  
db dump provided by my IT systems guys. Perhaps the DB wasn't dumped  
using binary character set? How could I check that and how should  
the IT guys have dumped the DB to make sure it was in binary?


Any thoughts?

Justin

-
Justin Hayes
Orbis Support Manager
justin.ha...@orbisuk.com





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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com





Re: [rt-users] 3.8.4 create user error

2009-09-16 Thread Raed El-Hames
Thanks Kevin it was indeed the wrong version of  
RT-Extension-MergeUsers, installed 0.03_02 and it works fine.

Regards;
Roy


Kevin Falcone wrote:
 On Tue, Sep 15, 2009 at 04:53:21PM +0100, Raed El-Hames wrote:
   
 Hi There;

 (Perl v5.8.8 under linux ,mod_perl2 
 v2.03,Apache2,DBIx::SearchBuilder v1.56)

 Started playing with 3.8.4 , fresh out of the box, new install , added 
 plugins :
 RT-Extension-MergeUsers
 RT-Extension-ServiceUpdates
 RT-Extension-SLA
 RTx-RightsMatrix
 

 You don't list version numbers, which means this is hard to diagnose
 from your error.  If you're not running MergeUsers 0.03_02 I would
 expect all kinds of problems interacting with 3.8

 -kevin

   
 - created first user, given it the super user permissions
 - logged in as this new user, trying to create another user I am getting 
 the below error when click on Create (from the Tab in User/index.html 
 and not the form).
 - the same happens if I try as root.

 Anybody else seen this, I am guessing its one of the extensions that 
 caused it, but which one?




 error:   Can't call method Disabled on an undefined value at 
 /opt/rt3/bin/../lib/RT/User_Overlay.pm line 1165.
 context: 
 ... 
 1161:  =cut
 1162: 
 1163:  sub Disabled {
 1164:  my $self = shift;
 1165:  return $self-PrincipalObj-Disabled(@_);
 1166:  }
 1167: 
 1168:  =head2 PrincipalObj
 1169: 
 ... 
 code stack:  /opt/rt3/bin/../lib/RT/User_Overlay.pm:1165
 /opt/rt3/share/html/Admin/Users/Modify.html:385
 /opt/rt3/share/html/Admin/autohandler:49
 /opt/rt3/share/html/autohandler:311


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

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com

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

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
   
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Permission Denied Error - Ticket creation using mail

2009-09-16 Thread Baskaraganesan Natarajan
Hi Kevin,

I found that my sendmail configuration was wrong. When I get this corrected in 
my sendmail.cf file, I got rid of this error.  But getting a different error 
this time (Log below).  Searching thru, I see the following line in 
http://mail.python.org/pipermail/mailman-users/2000-June/005182.html. Any help 
from here...

Sendmail won't deliver to a setuid program unless the directory where the
process resides is writable only by the owner.  That means no group write
or `other' write priviledges.  Mailman requires that the `s' bit be set
for the group.


Changed 
Mprog,  P=/etc/smrsh/
To 
Mprog,  P=/usr/sbin/smrsh

Log
===
Sep 16 12:15:01 localhost sendmail[15363]: n8G6j0O6015363: from=root, size=0, 
class=0, nrcpts=1, relay=r...@localhost
Sep 16 12:15:13 localhost sendmail[15365]: n8G6jAvi015365: from=root, size=11, 
class=0, nrcpts=1, msgid=200909160645.n8g6javi015...@localhost.localdomain, 
relay=r...@localhost
Sep 16 12:15:13 localhost sendmail[15366]: n8G6jDAd015366: 
from=r...@localhost.localdomain, size=300, class=0, nrcpts=1, 
msgid=200909160645.n8g6javi015...@localhost.localdomain, proto=ESMTP, 
daemon=MTA, relay=localhost.localdomain [127.0.0.1]
Sep 16 12:15:13 localhost sendmail[15365]: n8G6jAvi015365: to=helpdesk, 
ctladdr=root (0/0), delay=00:00:03, xdelay=00:00:00, mailer=relay, pri=30011, 
relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (n8G6jDAd015366 Message 
accepted for delivery)
Sep 16 12:15:13 localhost sendmail[15367]: n8G6jDAd015366: to=|rt-mailgate 
--queue 'CI new' --action correspond, ctladdr=helpd...@localhost.localdomain 
(8/0), delay=00:00:00, xdelay=00:00:00, mailer=prog, pri=30543, dsn=5.3.0, 
stat=unknown mailer error 1
Sep 16 12:15:13 localhost sendmail[15367]: n8G6jDAd015366: n8G6jDAd015367: DSN: 
unknown mailer error 1
Sep 16 12:15:13 localhost sendmail[15367]: n8G6jDAd015367: 
to=r...@localhost.localdomain, delay=00:00:00, xdelay=00:00:00, mailer=local, 
pri=31567, dsn=2.0.0, stat=Sent

Thanks,
Baskar N

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Tuesday, September 15, 2009 10:21 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Permission Denied Error - Ticket creation using mail

On Tue, Sep 15, 2009 at 01:20:07PM +0530, Baskaraganesan Natarajan wrote:
Retrying...
[r...@localhost log]# ls -ltr /etc/ | grep smr

drwxrwxrwx  2 root root4096 2009-08-28 18:11 smrsh

Sep 15 10:38:34 localhost sendmail[8712]: n8EA3n3F006454: Warning: program 
 /etc/smrsh/ unsafe:
World writable directory

Read the error messages, you can't have a world writable /etc/smrsh

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

DISCLAIMER:
---

The contents of this e-mail and any attachment(s) are confidential and intended 
for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its affiliates. 
Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the 
opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is 
strictly prohibited. If you have 
received this email in error please delete it and notify the sender 
immediately. Before opening any mail and 
attachments please check them for viruses and defect.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Show ticket history question

2009-09-16 Thread Joe Kirby
Is there a way to allow the show ticket/show comment attributes to  
include showing the queue?

We have situations where we do not want to give away the See Queue  
attribute but also allow the users/requestors to see all that is going  
on with their tickets. Right now it shows a queue in which they were  
allowed to see/enter a ticket however when it got moved to a lower  
level queue for resolution they only see that the queue was changed  
from something to blank.

It seems that the edit for displaying queues could be removed from the  
show history module.

Is this possible?

Thanks

Joe

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] [rt-user] PATCH: RT.pm.in for MasonComponentRoot

2009-09-16 Thread Lander, Scott
It is a problem with Mason and links, I think.   Easiest fix is to not use a 
link, and either reconfigure with prefix /opt/opt.CORE/rt-3.8/rhel5 or, move 
the rt3.8 directory to /usr/site/rt-3.8

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Susan McClure
Sent: Tuesday, September 15, 2009 8:28 PM
To: rt-users@lists.bestpractical.com
Cc: smccl...@rice.edu
Subject: Re: [rt-users] [rt-user] PATCH: RT.pm.in for MasonComponentRoot

Was this ever resolved or determined to be a bug?

I am experiencing the same thing, installing RT 3.8.4, but when I edit my 
lib/RT.pm file to make the Mason components absolute paths, I still have the 
error:


[Tue Sep 15 19:17:32 2009] [info] Server: Apache/2.2.3, Interface:
mod_ssl/2.2.3, Library: OpenSSL/0.9.8e-fips-rhel5 [Tue Sep 15 19:17:32 2009] 
[notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations [Tue 
Sep 15 19:17:32 2009] [info] Server built: Jul 15 2009 09:02:25 [Tue Sep 15 
19:17:32 2009] [debug] prefork.c(991): AcceptMutex: sysvsem
(default: sysvsem)
[Wed Sep 16 00:17:50 2009] [warning]: [Mason] Cannot resolve file to
component: /usr/site/rt-3.8/share/html/index.html (is file outside component 
root?) at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 852.
(/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm:852)
=

I configured with:

 ./configure --prefix=/usr/site/rt-3.8 --with-db-type=Pg --with-db-dba=postgres 
--with-db-database=rt38 --with-web-user=cwis --with-web-group=cwis 
--with-web-handler=modperl2 --with-apachectl=/usr/sbin --enable-gd 
--enable-graphviz --enable-gpg 

prefix /usr/site/rt-3.8 resolves to absolute path:
/opt/opt.CORE/rt-3.8/rhel5

So I changed my lib/RT.pm to have:
   lib/RT.pm  ..
...
 # END BPS TAGGED BLOCK }}}

 use strict;
 use warnings;
 package RT;

 use File::Spec ();
 use Cwd ();
 use vars qw($Config $System $SystemUser $Nobody $Handle $Logger
 $_INSTALL_MODE);

 our $VERSION = '3.8.4';

 #our $BasePath = '/usr/site/rt-3.8/';
 our $BasePath = '/opt/opt.CORE/rt-3.8/rhel5/'; our $EtcPath = 'etc';
 our $BinPath = 'bin'; our $SbinPath = 'sbin'; our $VarPath = 'var';

 our $LocalPath = 'local';
 our $LocalEtcPath = 'local/etc';
 our $LocalLibPath   =   'local/lib';
 our $LocalLexiconPath = 'local/po';
 our $LocalPluginPath = $LocalPath./plugins;

 # $MasonComponentRoot is where your rt instance keeps its mason html
 files #our $MasonComponentRoot = 'share/html'; our
 $MasonComponentRoot = '/opt/opt.CORE/rt-3.8/rhel5/share/html';

 # $MasonLocalComponentRoot is where your rt instance keeps its
 site-local # mason html files.
 #our $MasonLocalComponentRoot = 'local/html'; our
 $MasonLocalComponentRoot = '/opt/opt.CORE/rt-3.8/rhel5/local/html';

 # $MasonDataDir Where mason keeps its datafiles #our $MasonDataDir =
 'var/mason_data'; our $MasonDataDir =
 '/opt/opt.CORE/rt-3.8/rhel5/var/mason_data';

 # RT needs to put session data (for preserving state between
 connections # via the web interface) #our $MasonSessionDir =
 'var/session_data'; our $MasonSessionDir =
 '/opt/opt.CORE/rt-3.8/rhel5/var/session_data';

 unless (  File::Spec-file_name_is_absolute($EtcPath) ) {

 # if BasePath exists and is absolute, we won't infer it from
 $INC{'RT.pm'}.
 # otherwise RT.pm will make src dir(where we configure RT) be the
 BasePath # instead of the --prefix one
 unless ( -d $BasePath 
 File::Spec-file_name_is_absolute($BasePath) )
my $pm_path = ( File::Spec-splitpath( $INC{'RT.pm'} ) )[1];

# need rel2abs here is to make sure path is absolute, since
 $INC{'RT.pm'}
# is not always absolute
 $BasePath =
   File::Spec-rel2abs(
 File::Spec-catdir( $pm_path, File::Spec-updir ) );
 }

 $BasePath = Cwd::realpath( $BasePath );

 for my $path ( qw/EtcPath BinPath SbinPath VarPath LocalPath
 LocalEtcPath
 LocalLibPath LocalLexiconPath LocalPluginPath
 MasonComponentRootMasonLocalComponentRoot MasonDataDir
 MasonSessionDir/ ) {
 no strict 'refs';
 # just change relative ones
 $$path = File::Spec-catfile( $BasePath, $$path )
   unless File::Spec-file_name_is_absolute( $$path );
 }
 }


 =head1 NAME

 RT - Request Tracker

 =head1 SYNOPSIS

 A fully featured request tracker package

 =head1 DESCRIPTION

 =head2 INITIALIZATION
 :
===

===   perl  version =
 r...@rt2:/usr/site/rt-3.8/lib /usr/bin/perl -V Summary of my perl5
 (revision 5 version 8 subversion 8) configuration:
   Platform:
 osname=linux, osvers=2.6.18-128.1.10.el5,
 archname=x86_64-linux-thread-multi
 uname='linux ls20-bc2-13.build.redhat.com 2.6.18-128.1.10.el5 #1
 smp wed apr 29 13:53:08 edt 2009 x86_64 x86_64 x86_64 gnulinux '

Re: [rt-users] Perl version

2009-09-16 Thread Dominic Hargreaves
On Tue, Sep 15, 2009 at 11:47:53AM -0400, Jesse Vincent wrote:
 On Tue, Sep 15, 2009 at 08:46:15AM -0700, Ken Crocker wrote:
  To list,
  
  Does anyone know what the latest viable Perl versio we can use for RT 
  3.8.x is? We trying to get grid of a bunch of perl versions here and I 
  want to ensure we are using the latest for RT. Thanks.
 
 5.8.9 or 5.10.1 should be fine. 5.10.0  should be avoided.

Could you give any more information on this? I ask because we're
supporting users running RT 3.6 in Debian stable with Perl 5.10.0,
as well as RT 3.6 in Debian oldstable with Perl 5.8.8,
and I'm curious as to what possible problems we might be in for
(though we've seen none).

Here at work we're also running RT 3.8 with perl 5.8.8 and haven't
seen any problems.

Cheers,
Dominic.

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Perl version

2009-09-16 Thread Jesse Vincent

 Could you give any more information on this? I ask because we're
 supporting users running RT 3.6 in Debian stable with Perl 5.10.0,
 as well as RT 3.6 in Debian oldstable with Perl 5.8.8,
 and I'm curious as to what possible problems we might be in for
 (though we've seen none).
 
 Here at work we're also running RT 3.8 with perl 5.8.8 and haven't
 seen any problems.

He did ask about 'latest' versions ;)  Anything 5.8.3 or newer should
work just fine. 5.8.3-5.8.9 are all great. 

5.10.0 shipped with...many bugs and inconsitencies. When last I looked,
debian's 5.10.0 is somewhat patched up for the worst of these. I
wouldn't worry about running RT on Debian 5.10.0. But if you're
sourcebuilding a new perl for RT, my recommendation would be to skip
vanilla 5.10.0.

 
 Cheers,
 Dominic.
 
 -- 
 Dominic Hargreaves, Systems Development and Support Team
 Computing Services, University of Oxford
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
 

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] How to access a CustomField from Ticket/Tabs

2009-09-16 Thread Brumm, Torsten / Kuehne + Nagel / Ham MI-ID
Hi RT Gurus,
is there any way to access the content of a CustomField from 
Ticket/Elements/Tabs ?

I try to create a new button called Reinstate which will set back the status 
to last know status (stored in a CF).

Something like this:

$actions-{'AC'} = { path = 
Ticket/Display.html?Status={CustomFieldValue('OldStat')}id= . $id,
 title = loc('Reinstate') };

Not sure if this is possible.

Any ideas or solutions as workaround?

Greetings

Torsten

Kuehne + Nagel (AG  Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), 
Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, 
Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer 
Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 
812773878, Persoenlich haftende Gesellschaft: Kuehne  Nagel A.G., Sitz: 
Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne



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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Change in translation file (ES.PO)

2009-09-16 Thread Carlos M. Martinez - CERT.uy

Hello again,

here I am answering myself, just in case it helps others.

The problem was that since I have both RT and RT-FM installed, there are 
two es.po files in the directory tree, and while I was modifying RT's 
es.po, the segment I was translating (Quick search) was also present 
in RT-FM's es.po and this was the one that was taking precedence.


Once I changed the Quick search segment in RT-FM's es.po my changes 
were reflected in RT and RT-FM.


Now I am working on an es.po file for RT-IR and converting many 
segments from RT-FM's es.po to use UTF-8 characters. If there is any 
interest in this, let me know.


Thanks!

Carlos

On 15/09/2009 10:23 a.m., Carlos M. Martinez - CERT.uy wrote:

Hello all,

I am trying to make some changes to the file es.po in order to adapt 
it to our organization's specific terminology, plus some conversion 
work in order to use HTML entities instead of UTF-8 Spanish accented 
characters.


Although I am able to make the changes to es.po, I am at a loss as to 
what to do next. The changes aren't showing and neither restarting 
Apache (as suggested on an earlier post) nor clearing Mason's cache 
are helping. I suppose I am missing a step, but I don't know which one 
and I haven't been able to find more information.


Any help would be greatly appreciated.

Once it works, I will happily contribute my es.po file to anyone that 
might find it useful.


Best regards

Carlos Martinez
CERT.uy (http://www.cert.uy)



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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] SOLVED: How to access a CustomField from Ticket/Tabs

2009-09-16 Thread Brumm, Torsten / Kuehne + Nagel / Ham MI-ID
OK, sometime the vacuum in my head is preventing me from thinking.

Thanks to Scott Lander for Support.

Solution: 
my $path = 'Ticket/Display.html?Status=';
my $CFStat=$Ticket-FirstCustomFieldValue('Saved_Status');
$actions-{'ZZZ-Clone8'} = {
title = loc('[Reinstate]'),
path = $path . $CFStat . 'id=' . $Ticket-id,
   };

Torsten
-Ursprüngliche Nachricht-
Von: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Brumm,Torsten 
/ Kuehne + Nagel / Ham MI-ID
Gesendet: Mittwoch, 16. September 2009 15:22
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] How to access a CustomField from Ticket/Tabs

Hi RT Gurus,
is there any way to access the content of a CustomField from 
Ticket/Elements/Tabs ?

I try to create a new button called Reinstate which will set back the status 
to last know status (stored in a CF).

Something like this:

$actions-{'AC'} = { path = 
Ticket/Display.html?Status={CustomFieldValue('OldStat')}id= . $id,
 title = loc('Reinstate') };

Not sure if this is possible.

Any ideas or solutions as workaround?

Greetings

Torsten

Kuehne + Nagel (AG  Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), 
Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, 
Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer 
Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 
812773878, Persoenlich haftende Gesellschaft: Kuehne  Nagel A.G., Sitz: 
Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne



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

Community help: http://wiki.bestpractical.com Commercial support: 
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Correct format for any messages through the mail gateway at default?

2009-09-16 Thread bouncy...@gmail.com
I was able to get past my prior apache problems by manually symlinking the perl 
module for modperl from modules available to modules active. However the main 
problem is that I am. not at all sure for the exact default syntax for mail and 
what to expect. Most of the examples are in the format of using an on machine 
default email account. I already have fetchmail and postfix setup to do basic 
work from gmail accounts however fetchmail is passing unformatted re-written 
email addresses from that account. i.e. ticketb...@gmail.com [not actual]. how 
would I have to change the setup in the web configs to accept this and what 
format would it have to take.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] A Configuration question

2009-09-16 Thread Ken Crocker
To List,

I have my install configuration set to:

--with-GD=yes \
--with-GRAPHVIZ=yes \

Along with all the other stuff.

My question is, if I have the --with-GRAPHVIZ=yes set up,

do I ALSO need to have --enable-graphviz ?

Thaks.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] RT Query question

2009-09-16 Thread Ken Crocker
To List,

Whenever I create a query and want to include the Requestor(s), I always 
get the email address, ie. kfcroc...@lbl.gov. What I want is the name 
only, KFCrocker. In the advanced section, I see this code 
__Requestors__. What can I change that to to just get the requestors name?

Thanks.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] A Configuration question

2009-09-16 Thread Ken Crocker
Scott,

Hmm. When I compared the 3.8.4 configure list in README with the one I 
have for my current 3.6.4 version, I didn't see those options so I added 
them. ALso, it seemed to me that the instructions indicated that I 
needed those options specified. What did you specify and what 
extensions/plugins were installed at your location?

Thanks.

Kenn
LBNL

On 9/16/2009 9:41 AM, Lander, Scott wrote:
 Hmmm - I believe if you leave both of those options off, and, in fact, almost 
 all other options off  - it will do exactly the right thing!   IE, 
 ./configure --prefix blah then grpahviz will be enabled correctly...


 -Original Message-
 From: rt-users-boun...@lists.bestpractical.com 
 [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Ken Crocker
 Sent: Wednesday, September 16, 2009 12:39 PM
 To: rt Users
 Subject: [rt-users] A Configuration question

 To List,

 I have my install configuration set to:

 --with-GD=yes \
 --with-GRAPHVIZ=yes \

 Along with all the other stuff.

 My question is, if I have the --with-GRAPHVIZ=yes set up,

 do I ALSO need to have --enable-graphviz ?

 Thaks.

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

 Community help: http://wiki.bestpractical.com Commercial support: 
 sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com
 
 This e-mail message is intended only for the personal use of the recipient(s) 
 named above. If you are not an intended recipient, you may not review, copy 
 or distribute this message. If you have received this communication in error, 
 please notify the Hearst Service Center (cad...@hearstsc.com) immediately by 
 email and delete the original message.
 

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

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] A Configuration question

2009-09-16 Thread Kevin Falcone
On Wed, Sep 16, 2009 at 09:38:42AM -0700, Ken Crocker wrote:
 To List,
 
 I have my install configuration set to:
 
 --with-GD=yes \
 --with-GRAPHVIZ=yes \

GD and GRAPHVIZ are lowercased (just try running your command)

configure: WARNING: unrecognized options: --with-GRAPHVIZ

 Along with all the other stuff.
 
 My question is, if I have the --with-GRAPHVIZ=yes set up,
 
 do I ALSO need to have --enable-graphviz ?

You only need one to enable it, if you look at
./configure --help
--enable-graphviz is the documented one

As long as you install GraphViz RT will attempt to use it (unless
you've set DisableGraphViz).  The configure option is mostly useful
for adding GraphViz.pm to the deps list.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] A Configuration question

2009-09-16 Thread Ken Crocker

Kevin,

So, if I set my rt-configuration to:
   --prefix=/opt/rt3 \
   --enable-gd \
   --enable-graphviz \

That will work. How do I also add RT Matrix, ExternalAuth, 
CommandByMail, Calendar,  and Shredder? The same way?


Kenn
LBNL


On 9/16/2009 9:55 AM, Kevin Falcone wrote:

On Wed, Sep 16, 2009 at 09:38:42AM -0700, Ken Crocker wrote:
  

To List,

I have my install configuration set to:

--with-GD=yes \
--with-GRAPHVIZ=yes \



GD and GRAPHVIZ are lowercased (just try running your command)

configure: WARNING: unrecognized options: --with-GRAPHVIZ

  

Along with all the other stuff.

My question is, if I have the --with-GRAPHVIZ=yes set up,

do I ALSO need to have --enable-graphviz ?



You only need one to enable it, if you look at
./configure --help
--enable-graphviz is the documented one

As long as you install GraphViz RT will attempt to use it (unless
you've set DisableGraphViz).  The configure option is mostly useful
for adding GraphViz.pm to the deps list.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] RT and Subversion

2009-09-16 Thread Ben
Can any one help me on this?
 
Thanks,
 
Ben

--- On Tue, 9/15/09, Ben uy...@yahoo.com wrote:


From: Ben uy...@yahoo.com
Subject: RT and Subversion
To: RT Users rt-users@lists.bestpractical.com
Date: Tuesday, September 15, 2009, 11:27 AM







Hi, All,

I have a quick question. I use RT and subversion and scmbug. 
I have created several queues undr RT, also several projects under one repos in 
subversion.
My question is: how can I let the ticket owner can make changes to one projects 
in subversion?
for example, I have queueA, queueB, queueC, under subversion repos, I have 
projectA, projectB, projectC.  User A have a ticket in queueA, then he can 
check in to projectA, userB has a ticket in queueB, then he can check in to 
projectB.
 
Thanks!
 
Ben



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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] RT and Subversion

2009-09-16 Thread Tom Lahti
I do this with subversion hooks that call the RT REST API and some custom
fields.  The programmer puts Ticket: 123 as the first line of the comment at
commit.  The hooks validate the ticket data using REST API before allowing the
commit, and they also post information about the commit back to the ticket.

My hooks are written in ruby and use the rt-client library from rubyforge
(which I am the author of).


Ben wrote:
 Can any one help me on this?
  
 Thanks,
  
 Ben
 
 --- On *Tue, 9/15/09, Ben /uy...@yahoo.com/* wrote:
 
 
 From: Ben uy...@yahoo.com
 Subject: RT and Subversion
 To: RT Users rt-users@lists.bestpractical.com
 Date: Tuesday, September 15, 2009, 11:27 AM
 
 Hi, All,
 
 I have a quick question. I use RT and subversion and scmbug.
 I have created several queues undr RT, also several projects under
 one repos in subversion.
 My question is: how can I let the ticket owner can make changes to
 one projects in subversion?
 for example, I have queueA, queueB, queueC, under subversion repos,
 I have projectA, projectB, projectC.  User A have a ticket in
 queueA, then he can check in to projectA, userB has a ticket in
 queueB, then he can check in to projectB.
  
 Thanks!
  
 Ben
 
 
 
 
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com


-- 
-- 
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] A Configuration question

2009-09-16 Thread Kevin Falcone
On Wed, Sep 16, 2009 at 11:39:56AM -0700, Ken Crocker wrote:
Kevin,
 
So, if I set my rt-configuration to:
--prefix=/opt/rt3 \
--enable-gd \
--enable-graphviz \
 
That will work. How do I also add RT Matrix, ExternalAuth, 
 CommandByMail, Calendar,
and Shredder? The same way?

Kenn

Shredder is included in 3.8, you do nothing.
Everything else you list is an external extension you installed by
hand on your old RT.  You download them, read their READMEs and
install them.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Shredder question

2009-09-16 Thread Ken Crocker
To list,

I haven't used Shredder before so I have a question: when it removes a 
deleted ticket, will it also remove the OBJECTCUSTOMFIELDVALUES records 
as well?

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] RT and Subversion

2009-09-16 Thread Ben
thanks, Tom
 
I used scmbug to hook subversion with RT, is there a way to complete task with 
scmbug?
 
also Tom, does your way need a lot work to do?
 
 
Regards,
 
Ben

--- On Wed, 9/16/09, Tom Lahti t...@bitstatement.net wrote:


From: Tom Lahti t...@bitstatement.net
Subject: Re: [rt-users] RT and Subversion
To: Ben uy...@yahoo.com
Cc: RT Users rt-users@lists.bestpractical.com
Date: Wednesday, September 16, 2009, 1:51 PM


I do this with subversion hooks that call the RT REST API and some custom
fields.  The programmer puts Ticket: 123 as the first line of the comment at
commit.  The hooks validate the ticket data using REST API before allowing the
commit, and they also post information about the commit back to the ticket.

My hooks are written in ruby and use the rt-client library from rubyforge
(which I am the author of).


Ben wrote:
 Can any one help me on this?
  
 Thanks,
  
 Ben
 
 --- On *Tue, 9/15/09, Ben /uy...@yahoo.com/* wrote:
 
 
     From: Ben uy...@yahoo.com
     Subject: RT and Subversion
     To: RT Users rt-users@lists.bestpractical.com
     Date: Tuesday, September 15, 2009, 11:27 AM
 
     Hi, All,
 
     I have a quick question. I use RT and subversion and scmbug.
     I have created several queues undr RT, also several projects under
     one repos in subversion.
     My question is: how can I let the ticket owner can make changes to
     one projects in subversion?
     for example, I have queueA, queueB, queueC, under subversion repos,
     I have projectA, projectB, projectC.  User A have a ticket in
     queueA, then he can check in to projectA, userB has a ticket in
     queueB, then he can check in to projectB.
      
     Thanks!
      
     Ben
 
 
 
 
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com


-- 
-- 
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- 



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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] RT and Subversion

2009-09-16 Thread Kevin Falcone
On Wed, Sep 16, 2009 at 01:01:47PM -0700, Ben wrote:
thanks, Tom
 
I used scmbug to hook subversion with RT, is there a way to complete task 
 with scmbug?
 
also Tom, does your way need a lot work to do?

http://search.cpan.org/dist/RT-Integration-SVN/ 
lets you close tickets with svn commit messages

-kevin

Regards,
 
Ben
 
--- On Wed, 9/16/09, Tom Lahti t...@bitstatement.net wrote:
 
  From: Tom Lahti t...@bitstatement.net
  Subject: Re: [rt-users] RT and Subversion
  To: Ben uy...@yahoo.com
  Cc: RT Users rt-users@lists.bestpractical.com
  Date: Wednesday, September 16, 2009, 1:51 PM
 
  I do this with subversion hooks that call the RT REST API and some custom
  fields.  The programmer puts Ticket: 123 as the first line of the 
 comment at
  commit.  The hooks validate the ticket data using REST API before 
 allowing the
  commit, and they also post information about the commit back to the 
 ticket.
 
  My hooks are written in ruby and use the rt-client library from rubyforge
  (which I am the author of).
 
  Ben wrote:
   Can any one help me on this?
  
   Thanks,
  
   Ben
  
   --- On *Tue, 9/15/09, Ben /[1]uy...@yahoo.com/* wrote:
  
  
   From: Ben [2]uy...@yahoo.com
   Subject: RT and Subversion
   To: RT Users [3]rt-us...@lists.bestpractical.com
   Date: Tuesday, September 15, 2009, 11:27 AM
  
   Hi, All,
  
   I have a quick question. I use RT and subversion and scmbug.
   I have created several queues undr RT, also several projects under
   one repos in subversion.
   My question is: how can I let the ticket owner can make changes to
   one projects in subversion?
   for example, I have queueA, queueB, queueC, under subversion repos,
   I have projectA, projectB, projectC.  User A have a ticket in
   queueA, then he can check in to projectA, userB has a ticket in
   queueB, then he can check in to projectB.
  
   Thanks!
  
   Ben
  
  
  
  
   
 
  
   ___
   [4]http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
  
   Community help: [5]http://wiki.bestpractical.com
   Commercial support: [6]sa...@bestpractical.com
  
  
   Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
   Buy a copy at [7]http://rtbook.bestpractical.com
 
  --
  -- 
 Tom Lahti
 BIT Statement LLC
 
 (425)251-0833 x 117
 [8]http://www.bitstatement.net/
  -- 
 
 References
 
Visible links
1. http://us.mc369.mail.yahoo.com/mc/compose?to=uy...@yahoo.com
2. http://us.mc369.mail.yahoo.com/mc/compose?to=uy...@yahoo.com
3. 
 http://us.mc369.mail.yahoo.com/mc/compose?to=rt-us...@lists.bestpractical.com
4. http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
5. http://wiki.bestpractical.com/
6. http://us.mc369.mail.yahoo.com/mc/compose?to=sa...@bestpractical.com
7. http://rtbook.bestpractical.com/
8. http://www.bitstatement.net/

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Add a backup email account as Bcc - avoid multiple emails

2009-09-16 Thread Jerome Durand
Hi,

I'm an RT beginner but would really like to improve... I bought the book 
;) I installed RT3.8.4 with mysql.

My goal is that all messages sent to RT are also going to a second 
mailbox that would be used in case of a disaster on RT.

I have an alias that is used by customers to open ticket that goes in 2 
mailboxes (one polled by RT and other that is sleeping waiting for the 
disaster...)

I want RT to Bcc the backup mailbox for every correspondance. I simply 
added 'Bcc: backup-em...@company.com' in my correspondence template. And 
that more or less works (the template called by 'on correspond notifiy 
requestor and ccs')

I also have the 'on correpond notify other recipients' in case I add 
manually people...

My problem is that the system sends 2 emails:
   - one for requestor and the Bcc backup email address
   - one for the people cced (that I need to tick everytime)

Why does the system do that? Can't it send a single email and avoid the 
need to tick every person I want to cc? Is this due to my Bcc hack? How 
could I get all people in the same email (Bcc, cced, manally added other 
recipients and reuestor)?

Can anyone help me on that?

Sorry again if the answer is obvious or clearly available on some well 
known forum. Feel free to redirect me to the good place where there are 
all these kind of tips for beginners.

Thanks a lot!




-- 
-
Jerome Durand

Responsable des services aux usagers
Services operations  support manager

 Réseau National de Télécommunications
  pour la Technologie, l'Enseignement et la Recherche

Tel:+33 (0) 1 53 94 20 40  |  GIP RENATER
Fax:+33 (0) 1 53 94 20 41  |  c/o ENSAM
E-mail: jdur...@renater.fr |  151 Boulevard de l'Hôpital
http://www.renater.fr  |  75013 PARIS
--

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] {Disarmed} Re: RT and Subversion

2009-09-16 Thread Tom Lahti
Ben wrote:
 thanks, Tom
  
 I used scmbug to hook subversion with RT, is there a way to complete
 task with scmbug?
  
 also Tom, does your way need a lot work to do?
  
  
 Regards,
  
 Ben

I don't know anything about scmbug so I can't provide any advice there.  My
subversion hooks are very custom.  In addition to integrating RT with
subversion, it also pulls binaries from subversion at commit (if the
production approved custom field is set) and injects them into our
production deployment control system.

Unfortunately my custom hooks are company proprietary and I don't have
permission to share them, but in essence they use svnlook to get information
about the subversion transaction and the rt command line to get and post
information to/from the ticket.  In the pre-commit hook there's just
conditional logic to do things like: make sure the ticket exists, make sure
its in the right queue, make sure the owner of the ticket is the person doing
the commit, etc.  The post-commit hook is used to record the commit log
message into the ticket, take a diff and attach it to the ticket, list the
files that were changed in the commit in a reply, record the revision number
committed into the ticket, etc.  Documentation galore :)

-- 
-- 
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] RT and Subversion

2009-09-16 Thread Tom Lahti
 http://search.cpan.org/dist/RT-Integration-SVN/ 
 lets you close tickets with svn commit messages

That should be easy enough in a custom post-commit hook, too.  Just parse the
commands out of the subversion log message fetched with 'svnlook' and do the
corresponding thing with the rt command line or the REST API.

-- 
-- 
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Add a backup email account as Bcc - avoid multiple emails

2009-09-16 Thread Kevin Falcone
On Wed, Sep 16, 2009 at 10:13:43PM +0200, Jerome Durand wrote:
 
 My problem is that the system sends 2 emails:
- one for requestor and the Bcc backup email address
- one for the people cced (that I need to tick everytime)

These are separate Scrips.

On Correspond Notify Requestors and CCs notifies Requestors and
permanent CCs of the tickets

On Correspond Notify Other Recipients notifies Other Recipients
(including one-time-ccs)

Either add those people as a CC of your ticket or change your scrips

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] RT and Subversion

2009-09-16 Thread Kevin Falcone
On Wed, Sep 16, 2009 at 01:28:48PM -0700, Tom Lahti wrote:
  http://search.cpan.org/dist/RT-Integration-SVN/ 
  lets you close tickets with svn commit messages
 
 That should be easy enough in a custom post-commit hook, too.  Just parse the
 commands out of the subversion log message fetched with 'svnlook' and do the
 corresponding thing with the rt command line or the REST API.

You've just described how it works

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Add a backup email account as Bcc - avoid multiple emails

2009-09-16 Thread Jerome Durand
Thank you Kevin,

Now I understand the permanent ccs concept But I would have expected 
that when a requestor cc some folks, they are automatically registered 
as permanent ccs.

Isn't there a default scrip for that? Looks like there isn't (??) Any 
hint welcome to update my 'on create autoreply to requestor... and add 
ccs are permanent ccs!

Thanks

Jerome


Kevin Falcone a écrit :
 On Wed, Sep 16, 2009 at 10:13:43PM +0200, Jerome Durand wrote:
 My problem is that the system sends 2 emails:
- one for requestor and the Bcc backup email address
- one for the people cced (that I need to tick everytime)
 
 These are separate Scrips.
 
 On Correspond Notify Requestors and CCs notifies Requestors and
 permanent CCs of the tickets
 
 On Correspond Notify Other Recipients notifies Other Recipients
 (including one-time-ccs)
 
 Either add those people as a CC of your ticket or change your scrips
 
 -kevin
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com

-- 
-
Jerome Durand

Responsable des services aux usagers
Services operations  support manager

 Réseau National de Télécommunications
  pour la Technologie, l'Enseignement et la Recherche

Tel:+33 (0) 1 53 94 20 40  |  GIP RENATER
Fax:+33 (0) 1 53 94 20 41  |  c/o ENSAM
E-mail: jdur...@renater.fr |  151 Boulevard de l'Hôpital
http://www.renater.fr  |  75013 PARIS
--

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-09-16 Thread Aaron Guise
I'll have a look, I'm sure they are here somewhere.   Might take a day
though.

*Regards,
Aaron Guise
  07 838 7793
027 212 6638
aa...@guise.net.nz*




On Wed, Sep 16, 2009 at 9:20 PM, Justin Hayes justin.ha...@orbisuk.comwrote:

 Thanks a lot for the info and advise Aaron. Don't suppose you kept the
 scripts you used to dump the attachments and load them back in did you?
 I'm going to talk to my sysadmins and see if they are using that
 default-character-set option in the backup dump. If they aren't I'll get
 them to do me a new dump with that option on and see if it works that time.

 Cheers,

 Justin

 On 15 Sep 2009, at 23:36, Aaron Guise wrote:

 I had similar problems when moving upto 3.8.1.  The previous sysadmin
 responsible for RT had failed to upgrade the DB properly when going from
 3.6.5 to 3.8.0 some time back.  All our attachments went screwy too when I
 tried to upgrade to 3.8.1.

 In the end what I did is dump the database before upgrade in case I need to
 go back.  Dumped all attachment records to disk via perl, ran the RT upgrade
 scripts and then updated the attachments table from the ones I had dumped
 out earlier.

 This then made all the attachments become working again.  RT itself also
 seemed to get a performance boost !YAY!.  And the two ALTER entries in the
 upgrade script I found as well, Prior to running the upgrade I removed the
 ones that weren't binary columns e.g. VARBINARY so removing the lines which
 mentioned something like LONGBLOB.

 When you use mysqldump to backup the database you just need to make sure to
 place this --opt --default-character-set=binary in the commandline
 arguments.   That will mean it exports in binary mode to avoid corruption.

 *Regards,
 Aaron Guise
   07 838 7793
 027 212 6638
 aa...@guise.net.nz*




 On Wed, Sep 16, 2009 at 7:54 AM, Justin Hayes justin.ha...@orbisuk.comwrote:

 Hi guys,

 I'm just testing an upgrade from 3.6.3 to 3.8.4. I ran the
 rt-setup-database fine:

 /opt/rt_support.openbet.com/sbin/rt-setup-database -dba rt_support
 --prompt-for-dba-password --action upgrade


 Then created the schema upgrade script:

 perl /opt/rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl*blah* 
 *blah* *password*  upgrade.sql
 Use of uninitialized value in join or string at /opt/
 rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl line 261.
 .Tickets.status has type VARCHAR however mapping is missing.
 Use of uninitialized value in join or string at /opt/
 rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl line 261.
 .Users.BlockImg has type CHAR however mapping is missing.
 -- ** NOTICE: No database changes have been made. **
 -- Please review the generated SQL, ensure you have a full backup of your
 database
 -- and apply it to your database using a command like:
 -- mysql -u rt_support -p rt_support  queries.sql;

 cat upgrade.sql
 ALTER DATABASE rt_support DEFAULT CHARACTER SET utf8;
 ALTER TABLE ACL
DEFAULT CHARACTER SET utf8,
MODIFY RightName VARBINARY(25) NOT NULL,
MODIFY PrincipalType VARBINARY(25) NOT NULL,
MODIFY ObjectType VARBINARY(25) NOT NULL;
 ALTER TABLE ACL
MODIFY RightName VARCHAR(25) CHARACTER SET ascii NOT NULL,
MODIFY PrincipalType VARCHAR(25) CHARACTER SET ascii NOT NULL,
MODIFY ObjectType VARCHAR(25) CHARACTER SET ascii NOT NULL;
 ALTER TABLE Attachments
DEFAULT CHARACTER SET utf8,
MODIFY Subject VARBINARY(255) NULL DEFAULT NULL,
MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL,
MODIFY Filename VARBINARY(255) NULL DEFAULT NULL,
MODIFY Headers LONGBLOB NULL DEFAULT NULL,
MODIFY MessageId VARBINARY(160) NULL DEFAULT NULL,
MODIFY Content LONGBLOB NULL DEFAULT NULL,
MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT NULL;
 ALTER TABLE Attachments
MODIFY Subject VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL,
MODIFY ContentType VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL,
MODIFY Filename VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL,
MODIFY Headers LONGTEXT CHARACTER SET utf8 NULL DEFAULT NULL,
MODIFY MessageId VARCHAR(160) CHARACTER SET ascii NULL DEFAULT NULL,
MODIFY ContentEncoding VARCHAR(80) CHARACTER SET ascii NULL DEFAULT
 NULL;

 .

 .

 .



 Now that looks a bit odd as there are 2 ALTERS per table and the second
 seems to reverse some bits of the first?

 Anyway I ran that into my DB. Now when I go into a ticket with an image
 attached and click on it no image is returned, which is a bit worrying.

 I'm wondering if it was a problem with the upgrade, or the original db
 dump provided by my IT systems guys. Perhaps the DB wasn't dumped using
 binary character set? How could I check that and how should the IT guys have
 dumped the DB to make sure it was in binary?

 Any thoughts?

 Justin

 -
 Justin Hayes
 Orbis Support Manager
 justin.ha...@orbisuk.com





 ___
 

Re: [rt-users] Add a backup email account as Bcc - avoid multiple emails

2009-09-16 Thread Jerrad Pierce
On Wed, Sep 16, 2009 at 16:57, Jerome Durand jdur...@renater.fr wrote:
 Thank you Kevin,

 Now I understand the permanent ccs concept But I would have expected
 that when a requestor cc some folks, they are automatically registered
 as permanent ccs.

The form clearly says (in the native English version at least) One-time cc

We handle this sort of message backup with a global scrip rather than
template hacking...

  On transaction
  TransactionCreate
  Send Email
  Backup Template... which is just the default transaction template
(our actual transaction template is customized) with the hard-coded
bcc to the secondary address.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Add a backup email account as Bcc - avoid multiple emails

2009-09-16 Thread Kevin Falcone
On Wed, Sep 16, 2009 at 10:57:09PM +0200, Jerome Durand wrote:
 Now I understand the permanent ccs concept But I would have expected 
 that when a requestor cc some folks, they are automatically registered 
 as permanent ccs.

There is a config option for that on ticket creation 

 Isn't there a default scrip for that? Looks like there isn't (??) Any 
 hint welcome to update my 'on create autoreply to requestor... and add 
 ccs are permanent ccs!

Adding CCs as people reply to RT is documented on the wiki, but
won't become a core feature.

-kevin

 Kevin Falcone a écrit :
  On Wed, Sep 16, 2009 at 10:13:43PM +0200, Jerome Durand wrote:
  My problem is that the system sends 2 emails:
 - one for requestor and the Bcc backup email address
 - one for the people cced (that I need to tick everytime)
  
  These are separate Scrips.
  
  On Correspond Notify Requestors and CCs notifies Requestors and
  permanent CCs of the tickets
  
  On Correspond Notify Other Recipients notifies Other Recipients
  (including one-time-ccs)
  
  Either add those people as a CC of your ticket or change your scrips
  
  -kevin
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-09-16 Thread Justin Hayes
Thanks Aaron. I've always wondered why file attachments are stored in  
the db at all. I'd have thought those would have been better placed  
out in the filesystem.


Cheers,

Justin

Sent from my iPhone

On 16 Sep 2009, at 21:59, Aaron Guise aa...@guise.net.nz wrote:

I'll have a look, I'm sure they are here somewhere.   Might take a  
day though.


Regards,
Aaron Guise
  07 838 7793
027 212 6638
aa...@guise.net.nz




On Wed, Sep 16, 2009 at 9:20 PM, Justin Hayes justin.ha...@orbisuk.com 
 wrote:
Thanks a lot for the info and advise Aaron. Don't suppose you kept  
the scripts you used to dump the attachments and load them back in  
did you?


I'm going to talk to my sysadmins and see if they are using that  
default-character-set option in the backup dump. If they aren't I'll  
get them to do me a new dump with that option on and see if it works  
that time.


Cheers,

Justin

On 15 Sep 2009, at 23:36, Aaron Guise wrote:

I had similar problems when moving upto 3.8.1.  The previous  
sysadmin responsible for RT had failed to upgrade the DB properly  
when going from 3.6.5 to 3.8.0 some time back.  All our attachments  
went screwy too when I tried to upgrade to 3.8.1.


In the end what I did is dump the database before upgrade in case I  
need to go back.  Dumped all attachment records to disk via perl,  
ran the RT upgrade scripts and then updated the attachments table  
from the ones I had dumped out earlier.


This then made all the attachments become working again.  RT itself  
also seemed to get a performance boost !YAY!.  And the two ALTER  
entries in the upgrade script I found as well, Prior to running the  
upgrade I removed the ones that weren't binary columns e.g.  
VARBINARY so removing the lines which mentioned something like  
LONGBLOB.


When you use mysqldump to backup the database you just need to make  
sure to place this --opt --default-character-set=binary in the  
commandline arguments.   That will mean it exports in binary mode  
to avoid corruption.


Regards,
Aaron Guise
  07 838 7793
027 212 6638
aa...@guise.net.nz




On Wed, Sep 16, 2009 at 7:54 AM, Justin Hayes justin.ha...@orbisuk.com 
 wrote:

Hi guys,

I'm just testing an upgrade from 3.6.3 to 3.8.4. I ran the rt-setup- 
database fine:


/opt/rt_support.openbet.com/sbin/rt-setup-database -dba rt_support  
--prompt-for-dba-password --action upgrade


Then created the schema upgrade script:

perl /opt/rt_support.openbet.com/etc/upgrade/upgrade-mysql- 
schema.pl *blah* *blah* *password*  upgrade.sql
Use of uninitialized value in join or string at /opt/ 
rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl line 261.

.Tickets.status has type VARCHAR however mapping is missing.
Use of uninitialized value in join or string at /opt/ 
rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl line 261.

.Users.BlockImg has type CHAR however mapping is missing.
-- ** NOTICE: No database changes have been made. **
-- Please review the generated SQL, ensure you have a full backup  
of your database 
-- and apply it to your database using a command like:

-- mysql -u rt_support -p rt_support  queries.sql;

cat upgrade.sql
ALTER DATABASE rt_support DEFAULT CHARACTER SET utf8;
ALTER TABLE ACL
   DEFAULT CHARACTER SET utf8,
   MODIFY RightName VARBINARY(25) NOT NULL,
   MODIFY PrincipalType VARBINARY(25) NOT NULL,
   MODIFY ObjectType VARBINARY(25) NOT NULL;
ALTER TABLE ACL
   MODIFY RightName VARCHAR(25) CHARACTER SET ascii NOT NULL,
   MODIFY PrincipalType VARCHAR(25) CHARACTER SET ascii NOT NULL,
   MODIFY ObjectType VARCHAR(25) CHARACTER SET ascii NOT NULL;
ALTER TABLE Attachments
   DEFAULT CHARACTER SET utf8,
   MODIFY Subject VARBINARY(255) NULL DEFAULT NULL,
   MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL,
   MODIFY Filename VARBINARY(255) NULL DEFAULT NULL,
   MODIFY Headers LONGBLOB NULL DEFAULT NULL,
   MODIFY MessageId VARBINARY(160) NULL DEFAULT NULL,
   MODIFY Content LONGBLOB NULL DEFAULT NULL,
   MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT NULL;
ALTER TABLE Attachments
   MODIFY Subject VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL,
   MODIFY ContentType VARCHAR(80) CHARACTER SET ascii NULL DEFAULT  
NULL,

   MODIFY Filename VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL,
   MODIFY Headers LONGTEXT CHARACTER SET utf8 NULL DEFAULT NULL,
   MODIFY MessageId VARCHAR(160) CHARACTER SET ascii NULL DEFAULT  
NULL,
   MODIFY ContentEncoding VARCHAR(80) CHARACTER SET ascii NULL  
DEFAULT NULL;

.
.
.


Now that looks a bit odd as there are 2 ALTERS per table and the  
second seems to reverse some bits of the first?


Anyway I ran that into my DB. Now when I go into a ticket with an  
image attached and click on it no image is returned, which is a bit  
worrying.


I'm wondering if it was a problem with the upgrade, or the original  
db dump provided by my IT systems guys. Perhaps the DB wasn't  
dumped using binary character set? How could I check that and how  
should the IT guys have dumped the DB to 

[rt-users] RT web request timeout

2009-09-16 Thread Venkateswaran, Subbaraman
Can someone suggest a way we could set a time out for web request to RT?
The main problem is that we do not want to allow external applications
accessing RT over http beyond a certain specific time. Due to these long
running process, RT crawls and eventually runs extremely slow.

What we are thinking is to set a time limit for the Mason Web Handler
and kill the process if it exceeds a n seconds. The FastCGIServer
appConnTimeout and idle-timeout does help with this requirement but they
kind of kill abruptly. We want to kill the process gracefully by doing a
proper handler cleanrequests.

Appreciate your help here.

Thanks
Subba Venkateswaran 
AT - App Eng - SEG
609 282 7015


THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE PRIVILEGED, 
CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM DISCLOSURE. If the reader 
of this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, copying or use of this message and any attachment 
is strictly prohibited. If you have received this message in error, please 
notify us immediately by replying to the message and permanently delete it from 
your computer and destroy any printout thereof.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-09-16 Thread Tom Lahti
Justin Hayes wrote:
 Thanks Aaron. I've always wondered why file attachments are stored in
 the db at all. I'd have thought those would have been better placed out
 in the filesystem. 

Egads! What if the storage database is not local to the web server?  How will
you perform comprehensive backups?  What if your RT has a million attachments,
or more?  Not to mention the performance hit of using a filesystem as a
database, especially with high concurrency at the HTTP level.

I have a custom database application designed specifically to store PDFs in
the database.  It has 30 million documents in it, the database storage is over
4TB.  The web-based front-end for it is efficient enough to saturate a
100MBit/sec Internet connection with a single Core-2 duo web server.  When I
tested this against our old filesystem version of the application, it
outperformed the filesystem by more than 100%.  Backup is done by dumping the
database in chunks in a rotating schedule.  Scalability can be accomplished
with simple replication to additional read-only SQL servers and using a SQL
relay to dispatch SQL commands in a load-balancing fashion.

-- 
-- 
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Upgrade from 3.6.3 to 3.8.4 - image attachments missing/corrupt

2009-09-16 Thread Aaron Guise
I fully agree Tom,  SQL Servers totally own the filesystem equivalent in
this regard.  Our attachments table is huge and it would be rather difficult
to keep a track of them all and ensure every last one is backed up without
the MySQL storage system :-)

*Regards,
Aaron Guise
  07 838 7793
027 212 6638
aa...@guise.net.nz*




On Thu, Sep 17, 2009 at 11:00 AM, Tom Lahti t...@bitstatement.net wrote:

 Justin Hayes wrote:
  Thanks Aaron. I've always wondered why file attachments are stored in
  the db at all. I'd have thought those would have been better placed out
  in the filesystem.

 Egads! What if the storage database is not local to the web server?  How
 will
 you perform comprehensive backups?  What if your RT has a million
 attachments,
 or more?  Not to mention the performance hit of using a filesystem as a
 database, especially with high concurrency at the HTTP level.

 I have a custom database application designed specifically to store PDFs in
 the database.  It has 30 million documents in it, the database storage is
 over
 4TB.  The web-based front-end for it is efficient enough to saturate a
 100MBit/sec Internet connection with a single Core-2 duo web server.  When
 I
 tested this against our old filesystem version of the application, it
 outperformed the filesystem by more than 100%.  Backup is done by dumping
 the
 database in chunks in a rotating schedule.  Scalability can be accomplished
 with simple replication to additional read-only SQL servers and using a SQL
 relay to dispatch SQL commands in a load-balancing fashion.

 --
 -- 
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
 -- 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Error make initialize-database

2009-09-16 Thread borngunners

I have gone through the suggested steps successfully, but had an error when I 
enter the following command:



r...@helpdesk:/opt/rt3# make initialize-database


This is the error that I got:

make: *** No rule to make target `initialize-database'.? Stop.


Can someone guide me in resolving this issue.



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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

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

2009-09-16 Thread Lander, Scott
When you run make initialize-database, you should be in the directory you are 
installing from, not to./opt/rt3 is (probably) your to directory


From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of 
borngunn...@aol.com
Sent: Wednesday, September 16, 2009 9:18 PM
To: RT-Users@lists.bestpractical.com
Subject: [rt-users] Error make initialize-database

I have gone through the suggested steps successfully, but had an error when I 
enter the following command:

r...@helpdesk:/opt/rt3mailto:r...@helpdesk:/opt/rt3# make initialize-database
This is the error that I got:
make: *** No rule to make target `initialize-database'.  Stop.
Can someone guide me in resolving this issue.

Thanks,

This e-mail message is intended only for the personal use of the recipient(s) 
named above. If you are not an intended recipient, you may not review, copy or 
distribute this message. If you have received this communication in error, 
please notify the Hearst Service Center (cad...@hearstsc.com) immediately by 
email and delete the original message.

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com