Re: [rt-users] Temporary directory for uploaded file when creating a ticket

2011-08-10 Thread Luca Villani
In data giovedì 4 agosto 2011 17:15:38, hai scritto:


  Depending on your version of RT, it uses HTML::Mason's cgi_object,
  which is often CGI.pm, and that should respect TMPDIR
 
 We had upgrade yesterday to RT 4.0.1, this is the relevand section in
 apache config:
 
 Location /
 Order allow,deny
 Allow from all
 SetEnv TMPDIR /www/COMMON/tmp
 SetHandler perl-script
 PerlResponseHandler Plack::Handler::Apache2
 PerlSetVar psgi_app /opt/rt/rt-4.0.1/sbin/rt-server
 /Location
 
 Perl
 use Plack::Handler::Apache2;
 Plack::Handler::Apache2-preload(/opt/rt/rt-4.0.1/sbin/rt-server);
 /Perl
 
 
 SetEnv appears also at virtualhost definition, with no results.

No one can give us a feedback about this?

As far as RT store web loaded ticket attachments in /var/tmp, there is no 
chance to clusterize an installation: it is ok to use a NFS shared directory 
for tmpdir so all webserver in cluster can find attach even in case the 
balancer move the connection from one server to other, but it is not 
acceptable to mount the entire /var/tmp from a filer...


-- 
Luca Villani -  Register.It S.p.A. - Dada Group

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani

RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA  September 26  27, 2011
*  San Francisco, CA, USA  October 18  19, 2011
*  Washington DC, USA  October 31  November 1, 2011
*  Melbourne VIC, Australia  November 28  29, 2011
*  Barcelona, Spain  November 28  29, 2011


[rt-users] Broken mime type text/html inline e-mail visualization

2011-08-05 Thread Luca Villani
Hi.


After upgrade from RT 3.6.6 to RT 4.0.1 all HTML e-mail are not visualized 
inline in webinterface.

In out RT_SiteConfig.pm there are

Set( $PreferRichText, 1);
Set( $TrustHTMLAttachments, 1);


Are there some other directives to use?


-- 
Luca Villani -  Register.It S.p.A. - Dada Group

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani


2011 Training: http://bestpractical.com/services/training.html


Re: [rt-users] Broken mime type text/html inline e-mail visualization

2011-08-05 Thread Luca Villani
In data venerdì 5 agosto 2011 17:03:17, Thomas Sibley ha scritto:


 There are answers in the list archives and maybe the wiki for how to
 modify ScrubHTML to allow tables inline, although that code has changed
 a little from 3.8 → 4.0.

Ok, with a modified

local/html/Elements/ScrubHTML

visualization is useful.

Thank you very much.


Now I'm waiting some hints for our others questions, TMPDIR and inline images 
visualizazione... ;-)



-- 
Luca Villani -  Register.It S.p.A. - Dada Group

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani


2011 Training: http://bestpractical.com/services/training.html

[rt-users] Temporary directory for uploaded file when creating a ticket

2011-08-04 Thread Luca Villani
Hi.


In our instalaltion, when we create a ticket via webinterface with an attached 
file, it is stored in /var/tmp/

In order to clusterize RT we mut change this directory to a nfs mounted share, 
but we have found no configuration keyword for tmpdir handling.

We have try to modify the TMPDIR variable for apache, but it doesn't work for 
RT installation.

Is there any method to change this behaviour?


-- 
Luca Villani -  Register.It S.p.A. - Dada Group

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani


2011 Training: http://bestpractical.com/services/training.html


Re: [rt-users] Temporary directory for uploaded file when creating a ticket

2011-08-04 Thread Luca Villani
In data giovedì 4 agosto 2011 16:54:01, Kevin Falcone ha scritto:



 Depending on your version of RT, it uses HTML::Mason's cgi_object,
 which is often CGI.pm, and that should respect TMPDIR

We had upgrade yesterday to RT 4.0.1, this is the relevand section in apache 
config:

Location /
Order allow,deny
Allow from all
SetEnv TMPDIR /www/COMMON/tmp
SetHandler perl-script
PerlResponseHandler Plack::Handler::Apache2
PerlSetVar psgi_app /opt/rt/rt-4.0.1/sbin/rt-server
/Location

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


SetEnv appears also at virtualhost definition, with no results.



-- 
Luca Villani -  Register.It S.p.A. - Dada Group

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani


2011 Training: http://bestpractical.com/services/training.html


[rt-users] Broken images visualization after upgrade 3.6.6 - 4.0.1

2011-08-04 Thread Luca Villani
Hi.


We have upgrade our installation from 3.6.6 to 4.0.1, and now all images will 
not be show inline in the webinterface: only the text Message body not shown 
because it is not plain text. and a link to download the image.

In our config there is

Set( $ShowTransactionImages, 1);

and

Set( $MaxInlineBody, 12000);

but for my user this value is set to 0.

Any hint?



-- 
Luca Villani -  Register.It S.p.A. - Dada Group

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani


2011 Training: http://bestpractical.com/services/training.html


[rt-users] SAML authentication for rt

2011-03-28 Thread Luca Villani
Hi.


First, I'm afraid my english is very poor, sorry... :-(


We're using RT with LDAP authentication, and we're exploring the
possibility to use our SAML Identity Provider as authentication backend.

Before installing a dedicate SP and auth_memcookie, are there some sort
of native SAML authentication for RT?



-- 
Luca Villani -  Register.It S.p.A. - Dada Group

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani


Re: [rt-users] Broken tickets display

2009-08-18 Thread Luca Villani
Kevin Falcone ha scritto:


 We're experiencing a strange behaviour on both our RT installation: when
 someone reply (or comment) to a ticket (both via e-mail or via
 webinterface) with a response containing some characters like

  ª

 (useful in Italian language) then ticket visualization is broken for
 this ticket: we can only see workflow until the response, but not
 response itself and the following workflow.
 
 Just a guess, but check your version of Text-Quoted, old versions had
 a tendency to coredump on some characters.  You can try coming up to
 2.05

First, I'm terribly sorry for delay in my response, I was in summer 
holidays (sailing in North Adriatic Sea). :-( :-( :-(



Our version of Text::Quoted is 2.02:

support01 ~ # equery list Text-Quoted
[ Searching for package 'Text-Quoted' in all categories among: ]
  * installed packages
[I--] [  ] dev-perl/Text-Quoted-2.02 (0)
support01 ~ #

As far as this is an high traffic cluster (about 3.000 tickets per week, 
it's dedicated to our worldwide CRM), we can't simply upgrade a perl 
module, we must plan this operation.

I can do this in a few days, next I will report...



-- 
Luca Villani -  Dada.Net S.p.A.

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani
___
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] Broken tickets display

2009-07-21 Thread Luca Villani
Hi.



First, I'm afraid my English is very poor, sorry... :-|



We're experiencing a strange behaviour on both our RT installation: when
someone reply (or comment) to a ticket (both via e-mail or via
webinterface) with a response containing some characters like

ª

(useful in Italian language) then ticket visualization is broken for
this ticket: we can only see workflow until the response, but not
response itself and the following workflow.

All workflow is stored in db, and broken visualization only affect the
ticket with these characters.

If we change these character directly on database, a correct
visualization is restored.



We'd searching on internet, but we find nothing: if your response is
RTFM, pleas tell us what FM we must R... ;-)




Some informations:

- platform is Gentoo Linux for ADM64
- all servers (webservers and database) are fully UTF-8
- webserver is Apache, RDBMS is Mysql Enterprise, MTA is Postix
- RT version is 3.6.7
- RT email input encoding is utf-8 iso-8859-1 us-ascii
- Mysql version is 5.0.46 Enterprise
- Mysql charset is binary
- Apache version is 2.2.9
- Apache default charset is UTF-8



Can someone help us?



-- 
Luca Villani -  Dada.Net S.p.A.

Tel: +39 055 20021517   Mobile: +39 335 8753086
ICQ: 76272621   Skype: luca.villani
___
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] Still lots of Spam hitting RT after filtering via Procmail/Spamassasin/Rules Du Jour

2007-05-11 Thread Luca Villani
Alle 17:03, giovedì 10 maggio 2007, Pedro Santa ha scritto:


 My RT instance still receives lots of SPAM even with procmail
 filtering, with Spamassasin updated with rules du jour script.

I think an MTA level configuration for using some block lists can help you.

Like this, for our postfix+postgrey mailservers:


smtpd_sender_restrictions =
check_sender_access hash:/etc/postfix/sender_access_rejected,
hash:/etc/postfix/access,
permit_mynetworks,
reject_invalid_hostname,
reject_non_fqdn_sender,
reject_non_fqdn_recipient,
reject_non_fqdn_hostname,
reject_invalid_hostname,
reject_unknown_sender_domain,
reject_unknown_recipient_domain,
reject_unauth_pipelining,
reject_unauth_destination,
check_recipient_maps,
reject_rbl_client relays.ordb.org,
reject_rbl_client list.dsbl.org,
reject_rbl_client sbl-xbl.spamhaus.org,
reject_rbl_client combined.njabl.org,
reject_rbl_client bl.spamcop.net,
reject_rbl_client dnsbl.sorbs.net,
check_policy_service inet:127.0.0.1:10030,
permit_mx_backup



-- 
Luca VillaniMobile Team, Dada S.p.A.
Tel: +39 055 2267220Mob: +39 335 8753086
ICQ: 76272621   Skype: luca.villani
GPG key fingerprint: 7FC9 E2FE 0BEE 9DF8 1719  8761 1B79 82CC F0B5 B7CF
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] RT 4

2007-05-09 Thread Luca Villani
Alle 19:31, martedì 8 maggio 2007, [EMAIL PROTECTED] ha scritto:


 I also want to be able to setup the MTA configuration from within the
 GUI.

I think this is not a good idea: in an heavy duty environment, MTAs simply are 
on different servers then webinterface.
Also MTAs configuration is a totally separated job, MTAs can get information 
from a big plethora of sources: AD/LDAP, SASL, DB, local files...

In a small environment with low traffic and only one poor lerned sysadm, MTA 
configuration from webinterface should be a good start point, but it can be 
optional and not mandatory, otherwise RT will not be a good choice for large 
installation.



-- 
Luca VillaniMobile Team, Dada S.p.A.
Tel: +39 055 2267220Mob: +39 335 8753086
ICQ: 76272621   Skype: luca.villani
GPG key fingerprint: 7FC9 E2FE 0BEE 9DF8 1719  8761 1B79 82CC F0B5 B7CF
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] RT and mysql replication

2007-05-08 Thread Luca Villani
Alle 18:26, venerdì 4 maggio 2007, Kenneth Marshall ha scritto:


 Since RT uses DBI to access the underlying database, you should be able
 to use DBIx::DBCluster to send your writes to the master DB and read from
 the slave(s).

Do you know something on the net using DBIx::DBCluster for an RT patch?

Or are you suggest me to patch the code?



-- 
Luca VillaniMobile Team, Dada S.p.A.
Tel: +39 055 2267220Mob: +39 335 8753086
ICQ: 76272621   Skype: luca.villani
GPG key fingerprint: 7FC9 E2FE 0BEE 9DF8 1719  8761 1B79 82CC F0B5 B7CF
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] RT and mysql replication

2007-05-04 Thread Luca Villani
Hi.


I'd googled about this quesitons, but I'd find no useful information.
You can simply tell me RTFM, but please link the FM I must R... ;-)

Is there an RT support for mysql replication, a single master/many slave 
databases simple clustering method described in this page?

http://dev.mysql.com/doc/refman/5.0/en/replication.html



-- 
Luca VillaniMobile Team, Dada S.p.A.
Tel: +39 055 2267220Mob: +39 335 8753086
ICQ: 76272621   Skype: luca.villani
GPG key fingerprint: 7FC9 E2FE 0BEE 9DF8 1719  8761 1B79 82CC F0B5 B7CF
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] RT and mysql replication

2007-05-04 Thread Luca Villani
Alle 17:30, venerdì 4 maggio 2007, Kenneth Marshall ha scritto:


 I know that this does not help your situation, but pgpool will allow
 you to perform select queries to a slave postgresql DB and updates to
 the master DB. There may be a similar proxy available for MySQL that
 would allow you to scale your DB load better.

Generally speaking, we prefer to put no wrapper/proxy on our architecture, due 
to high load of our systems.

Do you have a link for a mysql proxy acting like this?



-- 
Luca VillaniMobile Team, Dada S.p.A.
Tel: +39 055 2267220Mob: +39 335 8753086
ICQ: 76272621   Skype: luca.villani
GPG key fingerprint: 7FC9 E2FE 0BEE 9DF8 1719  8761 1B79 82CC F0B5 B7CF
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] RT 4

2007-05-02 Thread Luca Villani
Alle 19:54, martedì 1 maggio 2007, Jesse Vincent ha scritto:


 If, for the sake of argument, Best Practical were to rewrite RT, what
 would you want to see in the new product?

- native and official LDAP/AD support;
- mysql replication cluster support.



-- 
Luca VillaniMobile Team, Dada S.p.A.
Tel: +39 055 2267220Mob: +39 335 8753086
ICQ: 76272621   Skype: luca.villani
GPG key fingerprint: 7FC9 E2FE 0BEE 9DF8 1719  8761 1B79 82CC F0B5 B7CF
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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