Re: [rt-users] Multi-tenant

2012-12-13 Thread Dominic Hargreaves
On Wed, Dec 12, 2012 at 09:05:34AM -0800, Thomas Sibley wrote:
 On 12/12/2012 08:12 AM, CB wrote:
  Thanks. I understand that it's possible to have multiple queues. Is it
  possible to have a multi-tenant setup i.e. one RT install with each tenant
  having its own environment e.g. domain, users, admin rights etc. Each tenant
  can log in to its own domain and administer the system (for themselves
  without affecting anyone else). From what I can see there is one local
  config file for all of RT and it's not possible to specify multiple domains.
 
 Short answer: No.

Slightly longer answer: maybe, depending on definitions?

Whilst RT has a notion of a single domain, you are free to route emails
from other domains into the system (and have queues set up to respond
with those addresses). Together with the fine-grained permissions model,
and the subject tags on queues it may be possible to configure a single
RT instance which would meet the OP's requirements (although I guess
user admin would be the one sticking point, so it might be necessary
to arrange for a separate user provisioning add-on to support the
specific use cases).

 Why would you prefer a single monolithic RT instance rather than a
 handful of separate ones?

Efficiencies in administration overhead and hardware requirements
(depending on the relative volume of transactions, of course) are two
that spring to mind immediately.

-- 
Dominic Hargreaves, Systems Development and Support Section
IT Services, University of Oxford


signature.asc
Description: Digital signature

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Multi-tenant

2012-12-13 Thread Shuvam Misra
  Why would you prefer a single monolithic RT instance rather than a
  handful of separate ones?
 
 Efficiencies in administration overhead and hardware requirements
 (depending on the relative volume of transactions, of course) are two
 that spring to mind immediately.

Would tend to agree. In fact, I was quite taken aback by the earlier
question. If one needs to run half a dozen separate RT installations
(separate domains, separate user lists, etc) and the software allows
you to run all of them from a single database and on a single server
(i.e. multi-tenant support), will anyone want to set up separate servers
then? I would have thought the reverse question is the natural one.

Shuvam

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Multi-tenant

2012-12-13 Thread Christoph (Stucki) von Stuckrad
On Thu, 13 Dec 2012, Shuvam Misra wrote:

...
 (i.e. multi-tenant support), will anyone want to set up separate servers
 then? I would have thought the reverse question is the natural one.

Having read only the last thee mails and not much time now,
I only want to tell, we did exactly tht, we did split a
multi-tenant RT into (only!) two sepearte instances.

Here were some more inssues than simply multi-versus-sigle
group usage. But one of the reasons might be important.

The overall-rights-matrix on only-one-userbase makes it
difficult to wall in each of the groups, so they never
see or notice one of the others.  It *is* possible, but
error-prone, if the 'groups' try to administer their own
'set of queues'.  One wrong click or 'right' and information
leaks will happen.  In sigle-tenant-setups this stays
impossible and virtual hosts are relatively cheap.

Stucki

-- 
Christoph von Stuckrad  * * |nickname |Mail stu...@mi.fu-berlin.de \
Freie Universitaet Berlin   |/_*|'stucki' |Tel(Mo.,Mi.):+49 30 838-75 459|
Mathematik  Informatik EDV |\ *|if online|  (Di,Do,Fr):+49 30 77 39 6600|
Takustr. 9 / 14195 Berlin   * * |on IRCnet|Fax(home):   +49 30 77 39 6601/

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Multi-tenant

2012-12-13 Thread Shuvam Misra
 The overall-rights-matrix on only-one-userbase makes it
 difficult to wall in each of the groups, so they never
 see or notice one of the others.  It *is* possible, but
 error-prone, if the 'groups' try to administer their own
 'set of queues'.  One wrong click or 'right' and information
 leaks will happen.  In sigle-tenant-setups this stays
 impossible and virtual hosts are relatively cheap.

An application has to be designed to be multi-tenanted from the ground up
to avoid these dangers. I guess RT is not.

When we design multi-tenant apps, we get so paranoid that we add a
clientID column to each table, without exception. Don't want to mess
with leaks across these walls -- clients will disappear before we know
it.

Shuvam

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Error on Mark all messages as seen in ticket

2012-12-13 Thread k...@rice.edu
Hi RT community,

We figured out the problem -- a bad case of local modifications.
Sorry for the interruption.

Regards,
Ken

On Wed, Dec 12, 2012 at 05:41:56PM -0600, Susan K. McClure wrote:
 Hi,
 I am getting an error when trying to click on the link in a ticket to
 jump to the first unread message and mark all messages as seen
 
 This is testing on a newly upgraded system:
  - rt 3.8.13, w/ RT-FM, RT-IR, RT::Authn::ExternalAuth and others.
  - on rhel 6
  - Using  postgresql 9.2.2, nginx, and spawn-fcgi
  - We are also using the colorize status  code feature  as in
http://wiki.bestpractical.com/view/ShowStatusInColor
 
 When I click on the link in a ticket (ticket # 391377) The browser
 displays:
 An internal RT error has occurred.  Your administrator can find more
 details in RT's log files
 
 I see in the nginx error.log:
 
  2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
  DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer:
  Must specify 'Name' attribute
  LINE 1: SELECT  * FROM Principals WHERE id = 'Must specify ''Name'' ...
   ^ at
  /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 590.
  RT::Handle=HASH(0x69f1e60) couldn't execute the query 'SELECT  * FROM
  Principals WHERE id = ?' at
  /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 603
  DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH( while
  reading response header from upstream, client: 10.67.48.228, server:
  rt3.rice.edu, request: GET
  /Ticket/Display.html?id=391377MarkAsSeen=1Anchor=txn-10489494
  HTTP/1.1, upstream: fastcgi://unix:/opt/rt3/var/fastcgi.sock:,
  host: rt3.rice.edu, referrer:
  https://rt3.rice.edu/Ticket/Display.html?id=391377;
  2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
  0x69f1e60)', 'SELECT  * FROM Principals WHERE id = ?', 'Must specify
  \'Name\' attribute') called at
  /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1206

   DBIx::SearchBuilder::Record::_LoadFromSQL('RT::Principal=HASH(0x7092440)',
  'SELECT  * FROM Principals WHERE id = ?', 'Must specify \'Name\'
  attribute') called at
  /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1125

   DBIx::SearchBuilder::Record::LoadByCols('RT::Principal=HASH(0x7092440)',
  'id', 'Must specify \'Name\' attribute') ca while reading response
  header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
  request: GET
  /Ticket/Display.html?id=391377MarkAsSeen=1Anchor=txn-10489494
  HTTP/1.1, upstream: fastcgi://unix:/opt/rt3/var/fastcgi.sock:,
  host: rt3.rice.edu, referrer:
  https://rt3.rice.edu/Ticket/Display.html?id=391377;
  2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: lled
  at /usr/local/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120

   
  DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::Principal=HASH(0x7092440)',
  'id', 'Must specify \'Name\' attribute') called at
  /opt/rt3/lib/RT/Record.pm line 368
  RT::Record::LoadByCols('RT::Principal=HASH(0x7092440)', 'id',
  'Must specify \'Name\' attribute') called at
  /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1140

   DBIx::SearchBuilder::Record::LoadById('RT::Principal=HASH(0x7092440)', 
  'Must
  specify while reading response header from upstream, client:
  10.67.48.228, server: rt3.rice.edu, request: GET
  /Ticket/Display.html?id=391377MarkAsSeen=1Anchor=txn-10489494
  HTTP/1.1, upstream: fastcgi://unix:/opt/rt3/var/fastcgi.sock:,
  host: rt3.rice.edu, referrer:
  https://rt3.rice.edu/Ticket/Display.html?id=391377;
  2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
  \'Name\' attribute') called at
  /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
  DBIx::SearchBuilder::Record::Load('RT::Principal=HASH(0x7092440)',
  'Must specify \'Name\' attribute') called at /opt/rt3/lib/RT/Record.pm
  line 320
  RT::Record::Create('RT::Principal=HASH(0x7092440)',
  'PrincipalType', 'User', 'ObjectId', 0, 'Disabled', 0) called at
  /opt/rt3/lib/RT/Principal.pm line 110
  RT::Principal::Create('RT::Principal=HASH(0x7092440)',
  'PrincipalType', 'User', 'Disabled', 0, 'ObjectId', while reading
  response header from upstream, client: 10.67.48.228, server:
  rt3.rice.edu, request: GET
  /Ticket/Display.html?id=391377MarkAsSeen=1Anchor=txn-10489494
  HTTP/1.1, upstream: fastcgi://unix:/opt/rt3/var/fastcgi.sock:,
  host: rt3.rice.edu, referrer:
  https://rt3.rice.edu/Ticket/Display.html?id=391377;
  2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:  0)
  called at /opt/rt3/local/lib/RT/User_Local.pm line 86
  RT::Base::Create('RT::Attribute=HASH(0x72010b0)', 'ContentType',
  '', 'Creator', 402, 'ObjectId', 391377, 'LastUpdatedBy', 402, ...)
  called at /opt/rt3/lib/RT/Record.pm line 289
  RT::Record::Create('RT::Attribute=HASH(0x72010b0)', 'Name',
  'User-402-SeenUpTo', 'Content', '2012-12-04 

Re: [rt-users] Multi-tenant

2012-12-13 Thread Tim Cutts

On 13 Dec 2012, at 10:56, Shuvam Misra shuvam.mi...@merceworld.com wrote:

 The overall-rights-matrix on only-one-userbase makes it
 difficult to wall in each of the groups, so they never
 see or notice one of the others.  It *is* possible, but
 error-prone, if the 'groups' try to administer their own
 'set of queues'.  One wrong click or 'right' and information
 leaks will happen.  In sigle-tenant-setups this stays
 impossible and virtual hosts are relatively cheap.
 
 An application has to be designed to be multi-tenanted from the ground up
 to avoid these dangers. I guess RT is not.

Indeed; there are several places where this is obvious; the principal ones, in 
my view, being Scrips and Templates.  Both of these allow essentially arbitrary 
perl code.  RT's access control lists don't apply here - everything essentially 
happens as the RT::System user, so if a user has the ability to write Mason 
templates, or to write Scrips, they can automatically access anything in the 
database, even if the ACLs formally forbid it.

Even if you had the client id column, you'd still have security issues to do 
with arbitrary perl, since you can always find the appropriate database handle 
and just do things to the database willy nilly.

In order to make multi-tenant even remotely sensible, you'd have basically 
completely ban users from making custom scrips and templates.  And then, in my 
view, re-architect the way things work.  You'd probably need:

a)  Several RT::System style users for the different tenants (or possibly)
b)  Database level permissions using those users

Row-based authentication isn't available in MySQL, so you'd probably have to 
use something like Oracle, if you wanted it really bullet proof.

Personally, I'd do multi-tenant through virtualisation.  Still only one piece 
of hardware, but you're keeping the data more effectively segregated.  You 
could simplify and centralise your configuration through scripts, so you didn't 
have to configure each tenant by hand.

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. 

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Full text index with MySQL 5.6

2012-12-13 Thread Darin Perusich
On Wed, Dec 12, 2012 at 2:47 PM, Alex Vandiver ale...@bestpractical.comwrote:

  Is there a simple way to migrate from mySQL to postgres?

 Not currently.  There are community-created tools that attempt it, and
 we've been working with a few clients on a more robust solution; we
 expect that it will ship with RT 4.2.


I've used this tool with success, I also package it with request-tracker in
the OpenSuSE devel:languages:perl repo. There are also a number of
generic mysql to postgres tools available which I've used with success as
well, google will be your friend to find them.

http://wiki-archive.bestpractical.com/view/rt-mysql2pg

We're hiring! http://bestpractical.com/jobs


[rt-users] RT: session flush and $m-redirect

2012-12-13 Thread Len Jaffe
Given:
$session{errormessge} = 'You blew it!;
$m-redirect($homePage);

When my code performs  a redirect, the error message is not being saved for
use in the on the next page.

Is there a magic flush() method that I need to call prior to calling
redirect?

Thanks,
Len.
-- 
lenja...@jaffesystems.com   614-404-4214   www.lenjaffe.com
Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage
Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent
Calendars: Perlish and otherwise.
Greenbar http://www.greenbartraining.org/: Grubmaster: 2012-2009, Grub
Asst: 2008, Trained: 2007.

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT: session flush and $m-redirect

2012-12-13 Thread Ruslan Zakirov
On Thu, Dec 13, 2012 at 10:04 PM, Len Jaffe lenja...@jaffesystems.com wrote:

 Given:
 $session{errormessge} = 'You blew it!;
 $m-redirect($homePage);

 When my code performs  a redirect, the error message is not being saved for
 use in the on the next page.

 Is there a magic flush() method that I need to call prior to calling
 redirect?


You need MaybeRedirectForResults.



 Thanks,
 Len.
 --
 lenja...@jaffesystems.com   614-404-4214   www.lenjaffe.com
 Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage
 Perl Advent Planet - Advent Calendars: Perlish and otherwise.
 Greenbar: Grubmaster: 2012-2009, Grub Asst: 2008, Trained: 2007.



 
 We're hiring! http://bestpractical.com/jobs




-- 
Best regards, Ruslan.

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Template not working

2012-12-13 Thread Ruslan Zakirov
On Thu, Dec 13, 2012 at 11:08 AM, Alexander Kaptsanov
al...@qbsystems.biz wrote:
 Hi, all.

 Three months ago I created a global template and sqrip that send a message
 to the new owner when changing the owner of the ticket.

 A month ago it stopped working. I did not do any upgrades for the RT and the
 server.

 I removed the template and the sqrip and created new ones. They did not
 work.

 Removed again and created new ones, while the template was very simple -
 Just test. And it worked.

 All attempts to create a template in which there is a value of type
 {$Ticket-Subject} or similar (any variable type) - unsuccessful.

 Logs contains nothing - no errors.

With debug log level enabled RT is very chatty about which scrips it
tries for which txn.



 --
 Best regards,
 Alex
 e-mail: al...@qbsystems.biz


 
 We're hiring! http://bestpractical.com/jobs




-- 
Best regards, Ruslan.

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] have RT cc' all included

2012-12-13 Thread Tim Wiley

On 12/12/2012 08:15 PM, Tim Dunphy wrote:

Hello List,

Right now with our RT system,  the auto-replies generated only go back
to the sender and not the people cc'd.  Can this be changed so that the
auto-replies include anyone cc'd? If so, how can this be done?

Thanks
Tim


If I'm understanding what you're looking for, you'll just setup a new 
scrip (either globally or on the queue level) to notify CCs for certain 
transactions.


Something like:
On Create Notify Ccs with template Transaction
On Resolve Notify Ccs with template Status Change
etc...

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Full text index with MySQL 5.6

2012-12-13 Thread Thomas Sibley
On 12/13/2012 08:27 AM, Darin Perusich wrote:
 I've used this tool with success, I also package it with request-tracker
 in the OpenSuSE devel:languages:perl repo. There are also a number of
 generic mysql to postgres tools available which I've used with success
 as well, google will be your friend to find them.
 
 http://wiki-archive.bestpractical.com/view/rt-mysql2pg

Thanks for maintaining distribution packages of RT!  If you ever run
into issues or have questions about releases, find us in #rt on
irc.perl.org.

It'd be great if you could clearly mark rt-mysql2pg as community
contributed, since it's not an officially supported migration tool.  It
may appear as such since it's packaged with the rest of RT.

Thomas

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Multi-tenant

2012-12-13 Thread Shuvam Misra
 Personally, I'd do multi-tenant through virtualisation.  Still only
 one piece of hardware, but you're keeping the data more effectively
 segregated.  You could simplify and centralise your configuration through
 scripts, so you didn't have to configure each tenant by hand.

I too was wondering what would I do if I took a browser-based app like RT
and needed to run multi-tenant setups on a single physical server. One
option is of course virtualisation, but another could be just running an
Apache with multiple virtualhost setups. Can one install multiple copies
of RT in multiple directories, and make them connect to the same PG or
MySQL database server but use various different databases? So, in short,
we will have one Apache daemon listening on five different domains using
its VirtualHost feature, then redirecting accesses to five different
physical copies of RT running on five different port numbers and storing
their config files etc in five different directories. And at the
back-end, all five RT instances would talk to the same database server on
the same database port number, but would connect to five different
databases.

Will this work?

Shuvam

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Multi-tenant

2012-12-13 Thread Thomas Sibley
On 12/13/2012 10:42 AM, Shuvam Misra wrote:
 I too was wondering what would I do if I took a browser-based app like RT
 and needed to run multi-tenant setups on a single physical server. One
 option is of course virtualisation, but another could be just running an
 Apache with multiple virtualhost setups. Can one install multiple copies
 of RT in multiple directories, and make them connect to the same PG or
 MySQL database server but use various different databases? So, in short,
 we will have one Apache daemon listening on five different domains using
 its VirtualHost feature, then redirecting accesses to five different
 physical copies of RT running on five different port numbers and storing
 their config files etc in five different directories. And at the
 back-end, all five RT instances would talk to the same database server on
 the same database port number, but would connect to five different
 databases.
 
 Will this work?

Yup, works great.  That's essentially what we do.  You'll want a
mod_fcgid, mod_fastcgi, or reverse proxy deployment.  You can't use
mod_perl to run multiple copies of RT because of the global Perl
interpreter state.


We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Multi-tenant

2012-12-13 Thread Rainer Duffner

Am 13.12.2012 um 21:20 schrieb Thomas Sibley t...@bestpractical.com:

 On 12/13/2012 10:42 AM, Shuvam Misra wrote:
 I too was wondering what would I do if I took a browser-based app like RT
 and needed to run multi-tenant setups on a single physical server. One
 option is of course virtualisation, but another could be just running an
 Apache with multiple virtualhost setups. Can one install multiple copies
 of RT in multiple directories, and make them connect to the same PG or
 MySQL database server but use various different databases? So, in short,
 we will have one Apache daemon listening on five different domains using
 its VirtualHost feature, then redirecting accesses to five different
 physical copies of RT running on five different port numbers and storing
 their config files etc in five different directories. And at the
 back-end, all five RT instances would talk to the same database server on
 the same database port number, but would connect to five different
 databases.
 
 Will this work?
 
 Yup, works great.  That's essentially what we do.  You'll want a
 mod_fcgid, mod_fastcgi, or reverse proxy deployment.  You can't use
 mod_perl to run multiple copies of RT because of the global Perl
 interpreter state.



I think it would be possible, if you ran multiple instances of the whole Apache:

http://wiki.apache.org/httpd/RunningMultipleApacheInstances

(on various 127.0.0.x aliases) and then run yet-another apache with mod_proxy 
in front of them).

Would be interesting to know how well that actually scales - and how to limit 
the CPU consumption of each instance.



We're hiring! http://bestpractical.com/jobs


[rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Cj B
Hello all,

I updated to 4.0.8 from 4.0.5 today and now outgoing emails are failing
with the following error:
[Thu Dec 13 20:21:48 2012] [crit]: 
rt-4.0.8-9327-1355430107-278.6585-...@example.com: Could not send mail
with command `/opt/rt3/etc/msmtp_wrapper -oi -t`: program unexpectedly
closed pipe at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 467.

Stack:
  [/opt/rt4/sbin/../lib/RT/Interface/Email.pm:467]
  [/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/IO/Handle.pm:401]
  [/usr/lib/perl5/site_perl/5.8.8/MIME/Head.pm:535]
  [/usr/lib/perl5/site_perl/5.8.8/Mail/Internet.pm:112]
  [/usr/lib/perl5/site_perl/5.8.8/MIME/Entity.pm:1770]
  [/opt/rt4/sbin/../lib/RT/Interface/Email.pm:474]
  [/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:292]
  [/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:114]
  [/opt/rt4/sbin/../lib/RT/ScripAction.pm:232]
  [/opt/rt4/sbin/../lib/RT/Scrip.pm:475]
  [/opt/rt4/sbin/../lib/RT/Scrips.pm:188]
  [/opt/rt4/sbin/../lib/RT/Transaction.pm:201]
  [/opt/rt4/sbin/../lib/RT/Record.pm:1493]
  [/opt/rt4/sbin/../lib/RT/Ticket.pm:676]
  [/opt/rt4/sbin/../lib/RT/Interface/Email.pm:1548]
  [/opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway:61]
(/opt/rt4/sbin/../lib/RT/Interface/Email.pm:488)


Everything was working fine before the upgrade. I'm on mstmp version 1.4.16

Can anyone help out with this?
Thanks.

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Multi-tenant

2012-12-13 Thread Thomas Sibley
On 12/13/2012 12:26 PM, Rainer Duffner wrote:
 Yup, works great.  That's essentially what we do.  You'll want a 
 mod_fcgid, mod_fastcgi, or reverse proxy deployment.  You can't
 use mod_perl to run multiple copies of RT because of the global
 Perl interpreter state.
 
 I think it would be possible, if you ran multiple instances of the
 whole Apache:
 
 http://wiki.apache.org/httpd/RunningMultipleApacheInstances
 
 (on various 127.0.0.x aliases) and then run yet-another apache with
 mod_proxy in front of them).
 
 Would be interesting to know how well that actually scales - and how
 to limit the CPU consumption of each instance.

There's no benefit from mod_perl that isn't also had via one of the
FastCGI implementations or a lighter weight server (Starman, for
instance) behind an Apache reverse proxy.  And there *are* downsides to
mod_perl as well as having to run multiple Apache instances.  So,
possible, but not close to worth it.  :)

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Thomas Sibley
On 12/13/2012 12:43 PM, Cj B wrote:
 Hello all,
 
 I updated to 4.0.8 from 4.0.5 today and now outgoing emails are failing
 with the following error:
 [Thu Dec 13 20:21:48 2012] [crit]:
 rt-4.0.8-9327-1355430107-278.6585-...@example.com
 mailto:rt-4.0.8-9327-1355430107-278.6585-...@example.com: Could not
 send mail with command `/opt/rt3/etc/msmtp_wrapper -oi -t`: program
 unexpectedly closed pipe at /opt/rt4/sbin/../lib/RT/Interface/Email.pm
 line 467.

Web server config and Configuration - Tools - System Configuration
output, please.


We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Thomas Sibley
On 12/13/2012 01:14 PM, Cj B wrote:
 Web server config and Configuration - Tools - System Configuration
 output, pleas
 
 Here's the sys config.
 
 Thanks!

Please keep your replies to the list.

Your sys config suggests you're running mod_perl, but you didn't include
your web server config as requested.


We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Cj B
On Thu, Dec 13, 2012 at 1:22 PM, Thomas Sibley t...@bestpractical.comwrote:

 On 12/13/2012 01:14 PM, Cj B wrote:
  Web server config and Configuration - Tools - System Configuration
  output, pleas
 
  Here's the sys config.
 
  Thanks!

 Please keep your replies to the list.

 Your sys config suggests you're running mod_perl, but you didn't include
 your web server config as requested.


Sorry, but what server config do you want? The whole httpd.conf file?

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Thomas Sibley
On 12/13/2012 01:25 PM, Cj B wrote:
 Sorry, but what server config do you want? The whole httpd.conf file? 

Yep, or at least the part with the VirtualHost settings for RT.


We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Cj B
On Thu, Dec 13, 2012 at 1:25 PM, Cj B ch...@cjbonline.org wrote:



 Your sys config suggests you're running mod_perl, but you didn't include
 your web server config as requested.


 Sorry, but what server config do you want? The whole httpd.conf file?


Here's the rt.conf:
VirtualHost 192.168.0.30
ServerName rt.gourmettrading.local
   ### Optional apache logs for RT
   # ErrorLog /opt/rt4/var/log/apache2.error
   # TransferLog /opt/rt4/var/log/apache2.access
   # LogLevel debug

   AddDefaultCharset UTF-8

   DocumentRoot /opt/rt4/share/html
   Location /
   Order allow,deny
   Allow from all

   SetHandler perl-script
   PerlResponseHandler Plack::Handler::Apache2
   PerlSetVar psgi_app /opt/rt4/sbin/rt-server
   /Location
   Perl
   use Plack::Handler::Apache2;

 Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server);
   /Perl

/VirtualHost

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Ruslan Zakirov
On Fri, Dec 14, 2012 at 1:30 AM, Cj B ch...@cjbonline.org wrote:
 SetHandler perl-script

This line bites you, it should be SetHandler modperl.

-- 
Best regards, Ruslan.

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Cj B
On Thu, Dec 13, 2012 at 1:51 PM, Ruslan Zakirov r...@bestpractical.comwrote:

 On Fri, Dec 14, 2012 at 1:30 AM, Cj B ch...@cjbonline.org wrote:
  SetHandler perl-script

 This line bites you, it should be SetHandler modperl.

 --
 Best regards, Ruslan.


That fixed it! Thanks. I wonder how it's been working all these years!

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT 4.0.8 and msmtp

2012-12-13 Thread Thomas Sibley
On 12/13/2012 01:56 PM, Cj B wrote:
 That fixed it! Thanks. I wonder how it's been working all these years!

Behaviour changed from RT 3.8 to RT 4.0, and although there were still
problems with SetHandler perl-script under 3.8, sending mail was not
one of them.

We're hiring! http://bestpractical.com/jobs


[rt-users] RT4 adjust column width(s)?

2012-12-13 Thread Tony G Palomino

Hi all,

I'm looking for a way to manually specify a column width in search 
results.  I'm running RT 4.0.5 at the moment.


I have a search which displays fields in one long row (which is what I 
want).  I don't mind if most of the fields wrap text, but it hurts my 
eyeballs when a date field wraps such as:


2012-13-
11

Poked around the list archives and the wiki, but didn't see this 
addressed.  Any easy (or complicated) ways to force column widths?


Tony


--
tony.palom...@reed.edu
Director, Computer User Services
Reed College
503-788-6622


We're hiring! http://bestpractical.com/jobs


Re: [rt-users] RT4 adjust column width(s)?

2012-12-13 Thread Thomas Sibley
On 12/13/2012 04:44 PM, Tony G Palomino wrote:
 Hi all,
 
 I'm looking for a way to manually specify a column width in search
 results.  I'm running RT 4.0.5 at the moment.
 
 I have a search which displays fields in one long row (which is what I
 want).  I don't mind if most of the fields wrap text, but it hurts my
 eyeballs when a date field wraps such as:
 
 2012-13-
 11
 
 Poked around the list archives and the wiki, but didn't see this
 addressed.  Any easy (or complicated) ways to force column widths?

In your search Format, append /STYLE:width:12em to the column, like so:

'__id__','__Subject__','__Due__/STYLE:width:12em','__Owner__'

Obviously adjust 12em to the size you want.  Support may vary between
browsers for setting explicit widths on table cells.


We're hiring! http://bestpractical.com/jobs