Re: [rt-users] Running multiple instance of RT in debian
On Sat, May 15, 2010 at 11:04:08AM +0530, Praveen C wrote: Hi All Is there any way that I can run two instance of RT in Debian I need seperate database and access for each RT. just install two RT in two different directories, then esasiest way is to configure those RT as fastcgi apps in apache. see also http://wiki.bestpractical.com/view/MultipleInstances Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Migration from MySQL to PostgreSQL - Pg datatypes for blobs?
Hi Emmanuel,
thanks for your reply.
On Sat, May 15, 2010 at 07:23:01AM +0200, Emmanuel Lacour wrote:
With Pg, this content is handled specifically, see _EncodeLOB in
lib/RT/Record.pm.
(see also mysql2Pg page on RTwiki).
I saw Base64 encoding in script on wiki page and also elsewhere, but
considered that as workaround to store binary data into Pg text
type-field.
Are you sure, that _EncodeLOB is used only for Pg?
Running grep in lib/RT (git 3.8-trunk):
z...@bobek:/data/soft/rt/rt/lib/RT$ find . -name I18N -prune -o -type f -print
|xargs fgrep Pg
./Handle.pm:elsif ( $db_type eq 'Pg' ) {
./Handle.pm:elsif ( $db_type eq 'Pg' ) {
./Interface/Web/Session.pm:Pg= 'Apache::Session::Postgres',
./Interface/Web/Handler.pm:unless ( RT-Config-Get('DatabaseType') =~
/(?:mysql|Pg)/ ) {
./Report/Tickets.pm:elsif ( $db_type eq 'Pg' ) {
./Report/Tickets.pm:# Pg 8.3 requires explicit casting
./Report/Tickets.pm:$func .= '::text' if $db_type eq 'Pg';
./Installer.pm: } qw/mysql Pg SQLite Oracle/
./Installer.pm:Pg = 'PostgreSQL',#loc
./Test.pm:# Pg doesn't like if you issue a DROP DATABASE while still
connected
I'm not sure.
I think, that Pg cluster initialized to ASCII can handle binary data in
the text data-type, but initialized to UTF-8 not. The correct solution
should be to change types for fields holding binary data to data-type
bytea. Maybe I'm simply not yet understanding the whole thing.
also, are-you sure that you're mysql DB is using utf-8. If not, you
should first convert it or convert on the fly in your script.
I hope yes. National characters are displayed fine in the web interface
and mails. The Content field causing problem is MySQL LONGBLOB type. It
can contain binary data.
BTW: I did with old data following in bash script:
make_database()
{
local pref=$1; shift
local db=$1; shift
local user=$1; shift
local pass=$1; shift
mysql -e CREATE DATABASE $db CHARACTER SET binary;
ssh z...@aslan.i.cz cat $aslan_db_dir/$db.sql.gz | zcat | mysql
--default-character-set=binary $db
mysql -e GRANT ALL ON $db.* TO '$user'@'$RT_DB_HOST' IDENTIFIED BY
'$pass'; $db
export RT_DB_NAME=$db
export RT_DB_USER=$user
export RT_DB_PASSWORD=$pass
mysql $db unaccent.sql
mysql $db update-duplic-emailaddress.sql
mysql $db update-duplic-name.sql
{ echo 3.2.2; echo 3.7.87; echo y; } \
| $RT_SETUP_DATABASE --datadir $SCHEMA_PATH --action=upgrade
$UPGRADE_MYSQL_SCHEMA $db /tmp/queries
mysql $db /tmp/queries
{ echo 3.7.87; echo; echo y; } \
| $RT_SETUP_DATABASE --datadir $SCHEMA_PATH --action=upgrade
mysql $db emailaddress-testing.sql
mig_$db $pref
}
Regards
--
Zito
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] apache2 fail to start
I have done all the steps in goin live with my RT, but I am having a little problem starting apache2.. In the instructions I am to copy and paste the virtual host settings in httpd.conf file after making a copy of the original one. Other instructions stated that I should have that configured in /etc/apache2/site-enabled/000-default. I have done both procedure and I am not successfull. After I remove the changes that I made in both files back to its original, apache2 successfully restart. I am not sure what I am doing wrong, but apache2 is the hold up for me to go live now. I am using ubuntu 9.04 distro and RT 3.8.8 Please help A little synopsis of what I have is below: VirtualHost * ServerName rt.example.com DocumentRoot /opt/rt3/share/html AddDefaultCharset UTF-8 PerlModule Apache::DBI PerlRequire /opt/rt3/bin/webmux.pl Location / SetHandler perl-script PerlHandler RT::Mason /Location /VirtualHost Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Filtering out unneeded info from ticket
Hi Chris,
I just created an extension that is doing what you want.
You can check it out at github:
http://github.com/cloos/rt-extension-briefhistory
Chris
Am 13.05.2010 19:28, schrieb Chris Hall:
Thanks Raed and Torsten, I took a little bit of both. I ended up
editing Ticket/Elements/ShowHistory with:
} else {
$Transactions = $Ticket-Transactions;
if ($r-uri =~ /History\.html/) {
} else {
$Transactions-Limit(FIELD = 'Type', VALUE = 'Correspond');
$Transactions-Limit(FIELD = 'Type', VALUE = 'Comment');
$Transactions-Limit(FIELD = 'Type', VALUE = 'Create');
}
}
so that the full history would be shown if the history link was
clicked, as alluded to in Torsten's link. (I couldn't seem to get the
Callbacks working for some reason.. maybe I just needed to restart
apache?) so with this code, only the added comments are shown unless
you are looking from the history link, in which case everything is
shown.. seems to work pretty well. I'll keep looking later though, as
I'd rather get the callbacks working instead. Thanks for the help guys.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] XML::RSS/XML::Parser (rt 3.8.8 install)
I've run into a problem while trying to do an install of RT 3.8.8 CentOS 5.x guest in a Linux-Vserver host. Perl 5.10.1 added from the tarball as a /usr/local/ install. Everything goes mostly smooth until trying to satisfy the Mason requirements. I'm still looking but here is where I'm at right now. Well actually as of yesterday but I've been practicing Insanity (trying the same thing, the same way, and expecting the results to be different.) XML::RSS requires XML::Parser and the install using cpan or 'perl Makefile.PL; make; etc.' throws an error. ... t/parament.t .. 1/12 error in processing external entity reference at line 8, column 0, byte 173: !ENTITY more SYSTEM t/ext2.ent ] ^ fooHappy, happy barjoy;, joy;/bar at /root/.cpan/build/XML-Parser-2.36-l2oxbX/blib/lib/XML/Parser.pm line 187 t/parament.t .. Dubious, test returned 255 (wstat 65280, 0xff00) Failed 11/12 subtests ... Test Summary Report --- t/decl.t(Wstat: 2304 Tests: 1 Failed: 0) Non-zero exit status: 9 Parse errors: Bad plan. You planned 30 tests but ran 1. t/parament.t(Wstat: 65280 Tests: 1 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 12 tests but ran 1. Files=14, Tests=90, 1 wallclock secs ( 0.10 usr 0.03 sys + 0.71 cusr 0.15 csys = 0.99 CPU) Result: FAIL Failed 2/14 test programs. 0/90 subtests failed. make: *** [test_dynamic] Error 255 MSERGEANT/XML-Parser-2.36.tar.gz /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports MSERGEANT/XML-Parser-2.36.tar.gz Running make install make test had returned bad status, won't install without force Should I force or is there something I'm not seeing/doing? TIA, Rod -- Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] new in RT need help
Hi, I am new in RT , I Have install RT in ubuntu. I need help for to configure incoming mail. I need good user documents to start this also. Can any one help me please ABU From: borngunn...@aol.com Sent: Saturday, May 15, 2010 12:45 PM To: Subject: [rt-users] apache2 fail to start I have done all the steps in goin live with my RT, but I am having a little problem starting apache2.. In the instructions I am to copy and paste the virtual host settings in httpd.conf file after making a copy of the original one. Other instructions stated that I should have that configured in /etc/apache2/site-enabled/000-default. I have done both procedure and I am not successfull. After I remove the changes that I made in both files back to its original, apache2 successfully restart. I am not sure what I am doing wrong, but apache2 is the hold up for me to go live now. I am using ubuntu 9.04 distro and RT 3.8.8 Please help A little synopsis of what I have is below: VirtualHost * ServerName rt.example.com DocumentRoot /opt/rt3/share/html AddDefaultCharset UTF-8 PerlModule Apache::DBI PerlRequire /opt/rt3/bin/webmux.pl Location / SetHandler perl-script PerlHandler RT::Mason /Location /VirtualHost Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.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] XML::RSS/XML::Parser (rt 3.8.8 install)
On Sat, May 15, 2010 at 06:08:01PM -0700, Roderick A. Anderson wrote: XML::RSS requires XML::Parser and the install using cpan or 'perl Makefile.PL; make; etc.' throws an error. Test Summary Report --- t/decl.t(Wstat: 2304 Tests: 1 Failed: 0) Non-zero exit status: 9 Parse errors: Bad plan. You planned 30 tests but ran 1. t/parament.t(Wstat: 65280 Tests: 1 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 12 tests but ran 1. Looks like the regression in libexpat introduced when fixing CVE-2009-3560. A better fix was released later that didn't have this problem. See the thread at http://lists.debian.org/debian-devel/2009/12/msg00674.html HTH, -- Niko Tyni nt...@debian.org Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
