[rt-users] Trying to set an attachment via command line interface

2008-11-28 Thread Alberto Villanueva
Dear All,

 

I am trying to set an attachment (plain text) from a ticket. I am using the
rt command line interface.

 

Thanks for any hint.

 

God bless

 

ALBERTO VILLANUEVA VAL 

Consultor



Altran

ParqueEmpresarial Las Mercedes, Edificio 1 
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57

 http://www.altran.es www.altran.es

 

 

image001.jpg___
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] Trying to get an attachment via command line interface rt show ticket/attachment ...

2008-11-28 Thread Tobias Heinz
Dear All,

I am trying to retrieve an attachment (application/pdf binary file) from
a ticket. I am using the rt command line interface.

When opening the attachment from the web the file (PDF) is fine.

rt show ticket/59134/attachments/365295/content

rt show ticket/59134/attachments/365295/content  /tmp/test.pdf

It gives me a file that is approx. 30% larger than the file itself. When
looking at the file, the clear-text part appears to be fine. The pdf
viewer tells me:
File corrupt or graphics can not be rendered.

I have transferred the file via scp to a windows machine - same there.
Tried to use different pdf viewers on unix - all abended with errors.
Clicking the file using Download test.pf on the web rt in ticket 59134
frontend gives me a perfect error-free pdf ..

Does the cli use any kind of encoding? How can I decode/transform the file?

Thanks for any hint  -

God bless

Tobias Heinz

-- 
Hochleistungsprodukt zum Bestpreis - die Allianz 24 Versicherung. Gleich
hier abschließen:

https://www.allianz24.de/tarifrechner/kfz-versicherung.html?referer=AZDEvtnr_zn=70vtnr=1295814





smime.p7s
Description: S/MIME Cryptographic Signature
___
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] I installed RT from RPM can I install RTFM?

2008-11-28 Thread Phil Labonte
Hello,

I am using RT 3.6.5 and I installed it from RPM.

I want to install RTFM but the documentation describes the install from
source.

Is it possible to install RTFM if RT from installed from RPM?
___
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] I installed RT from RPM can I install RTFM?

2008-11-28 Thread Phil Labonte
I need to re-phrase my question.

If I download and install RTFM does it matter that my RT install was from
RPM?

On Fri, Nov 28, 2008 at 10:29 AM, Phil Labonte [EMAIL PROTECTED]wrote:

 Hello,

 I am using RT 3.6.5 and I installed it from RPM.

 I want to install RTFM but the documentation describes the install from
 source.

 Is it possible to install RTFM if RT from installed from RPM?

___
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] Gnupg interaction with speedycgi in RT 3.8.1

2008-11-28 Thread Jesse Vincent
 I should probably mention that I'm the one to blame for keeping SpeedyCGI
 alive in this context. The project has been inactive since 2003, and I've
 patched the Debian speedy-cgi-perl package for the Perl 5.10 and Apache 2.2
 transitions.
 
 I still like the way it gives persistent perl script speedups with
 minimal or no web server configuration.

If someone with at least minimal interest in RT is keeping SpeedyCGI
running, I'm willing to keep shipping it ;)

For now, I've applied the patch to trunk (r17044)  as it makes sense ;)

Thanks!

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

-- 


pgpQuZDJvB3rI.pgp
Description: PGP signature
___
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] Implementing SSL MySQL Backend

2008-11-28 Thread Jesse Vincent



On Wed 19.Nov'08 at 15:02:56 -0500, Guy Dickinson wrote:
 Greetings, RT Users:
 Some internal systems changes have prompted me to migrate my database
 backend from its present location on the same server as the RT web
 frontend to a separate database server elsewhere. To comply with our
 security standards, the database traffic should be encrypted, so I
 implemented MySQL's builtin SSL encryption for the database traffic.
 
 I took inspiration for the implementation from a rt-users mailing list
 post by Mike Friedman
 (http://lists.bestpractical.com/pipermail/rt-users/2007-April/045347.html).
  In patch syntax, the precise change I made to RT::Handle was


So, isn't there an environment variable one can set to have DBD::mysql
pick this up?
 
 I am currently using RT 3.6.7 and will likely upgrade to RT 3.8.x in the
 relatively near future. Will that upgrade--or future ones--provide a
 'sanctioned' facility to implement SSL mySQL encryption, and will my
 current hack in Handle.pm result in unintended consequences elsewhere in
 RT when I upgrade?

Your hack looks pretty reasonable. I'd like to hear some feedback on
whether there's a cleaner way to do this before canonizing it in the
core ;)


 
 Thanks!
 Guy
 
 -- 
 --
 Guy Dickinson, Network Security Analyst
 NYU ITS Technology Security Services
 [EMAIL PROTECTED]
 (212) 998-3052
 ___
 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
 

-- 


pgprxrloIgigI.pgp
Description: PGP signature
___
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] Implementing SSL MySQL Backend

2008-11-28 Thread Guy Dickinson
Jesse Vincent wrote:

 I took inspiration for the implementation from a rt-users mailing list
 post by Mike Friedman
 (http://lists.bestpractical.com/pipermail/rt-users/2007-April/045347.html).
  In patch syntax, the precise change I made to RT::Handle was
 
 
 So, isn't there an environment variable one can set to have DBD::mysql
 pick this up?

To my knowledge, there are two ways to get DBD::mysql to issue the
appropriate C calls to initiate an SSL-encrypted connection:

1) Define the relevant parameters in the DSN, a la:

my $dsn =
DBI:mysql:database=$database;host=$hostname;port=$port;mysql_ssl_ca_file
=/etc/mysqlcerts/ca.pem;

my $dbh = DBI-connect($dsn, $user, $password);

and so on...

2) Define the SSL CA file in the [client] portion of /etc/my.cnf and
then explicitly tell DBI::mysql to read the config file. From the
DBD::mysql documentation
(http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm):

***

By default MySQL's C client library doesn't use any config files unlike
the client programs (mysql, mysqladmin, ...) that do, but outside of the
C client library. Thus you need to explicitly request reading a config
file, as in

$dsn = DBI:mysql:test;mysql_read_default_file=/home/joe/my.cnf;
$dbh = DBI-connect($dsn, $user, $password)

***


Cheers,
Guy
___
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