RT 3.4.2 installation woes

Hi all,

So, I’m going slightly nuts trying to deploy RT 3.4.2 in a virgin Debian
Woody environment. Having installed PostgreSQL 7.4, built my own Perl
5.8.6 and mod_perl 1.29 DSO and satisified all the Perl dependencies via
the CPAN shell, as well as configured up Apache, I appear to be
tantalisingly close to a working installation. Oh, and I installed RT as
well (including the database setup). :wink:

What I have now is something I can log into as ‘root’ with the default
password and click around a bit in. However, many links (e.g.
Tickets) result in content my browser (Firefox) wants to download rather
than display, presumably because it still looks a lot like Mason code as
opposed to renderable HTML. Other links, such as "Configuration -> Users"
do kinda work.

Something akin to Mason does indeed appear to be parsing the raw files and
producing content, because if I comment out, say, "PerlHandler RT::Mason"
in httpd.conf, I get plain code in my browser (i.e. no download dialog).

Does this ring any bells for anyone? Have I missed something small, yet
vital? I’ll keep plugging away, but any clues would be appreciated.

Thanks in advance,

Adrian Close email: adrian.close@hitwise.com
Hitwise phone: +61 3 8530 2446
Level 7, 580 St Kilda Road fax: +61 3 9529 8907
Melbourne, VIC, 3004, Australia web: http://www.hitwise.com/

> Hi all, > > So, I'm going slightly nuts trying to deploy RT 3.4.2 in a virgin Debian > Woody environment. Having installed PostgreSQL 7.4, built my own Perl > 5.8.6 and mod_perl 1.29 DSO and satisified all the Perl dependencies via > the CPAN shell, as well as configured up Apache, I appear to be > tantalisingly close to a working installation. Oh, and I installed RT as > well (including the database setup). ;)

Well done! I am still stuck getting all the modules installed.

What I have now is something I can log into as ‘root’ with the default
password and click around a bit in. However, many links (e.g.
Tickets) result in content my browser (Firefox) wants to download rather
than display, presumably because it still looks a lot like Mason code as
opposed to renderable HTML. Other links, such as "Configuration -> Users"
do kinda work.

Something akin to Mason does indeed appear to be parsing the raw files and
producing content, because if I comment out, say, "PerlHandler RT::Mason"
in httpd.conf, I get plain code in my browser (i.e. no download dialog).

Does this ring any bells for anyone? Have I missed something small, yet
vital? I’ll keep plugging away, but any clues would be appreciated.

No real advice though, sorry.

Kind Regards,

Gavin Henry.
Managing Director.

T +44 (0) 1224 279484
M +44 (0) 7930 323266
F +44 (0) 1224 742001
E ghenry@suretecsystems.com

Open Source. Open Solutions™.

http://www.suretecsystems.com/

Hello Adrian,On Tue, 2005-05-24 at 08:45, Adrian Close wrote:

Hi all,

So, I’m going slightly nuts trying to deploy RT 3.4.2 in a virgin Debian
Woody environment. Having installed PostgreSQL 7.4, built my own Perl
5.8.6 and mod_perl 1.29 DSO and satisified all the Perl dependencies via
the CPAN shell, as well as configured up Apache, I appear to be
tantalisingly close to a working installation. Oh, and I installed RT as
well (including the database setup). :wink:

What I have now is something I can log into as ‘root’ with the default
password and click around a bit in. However, many links (e.g.
Tickets) result in content my browser (Firefox) wants to download rather
than display, presumably because it still looks a lot like Mason code as
opposed to renderable HTML. Other links, such as "Configuration -> Users"
do kinda work.

Something akin to Mason does indeed appear to be parsing the raw files and
producing content, because if I comment out, say, "PerlHandler RT::Mason"
in httpd.conf, I get plain code in my browser (i.e. no download dialog).

Does this ring any bells for anyone? Have I missed something small, yet
vital? I’ll keep plugging away, but any clues would be appreciated.

Yes, this does ring a bell for me. This exact issue happened to me on
3.0.6 with Apache 1.3/Mod Perl under RedHat. I think I had to do
something funky with Apache. Would it be possible for you to post the
relevant sections of your httpd.conf while I try to dig out my notes?

  • Ken.

This email has passed through an IE Internet MailWall gateway
and has been screened for known viruses, potential viruses and
malicious code.

IE Internet.com MailWall (http://ieinternet.com/mailwall/)

Adrian Close wrote:

Hi all,

So, I’m going slightly nuts trying to deploy RT 3.4.2 in a virgin Debian
Woody environment. Having installed PostgreSQL 7.4, built my own Perl
5.8.6 and mod_perl 1.29 DSO and satisified all the Perl dependencies via
the CPAN shell, as well as configured up Apache, I appear to be
tantalisingly close to a working installation. Oh, and I installed RT
as well (including the database setup). :wink:

What I have now is something I can log into as ‘root’ with the default
password and click around a bit in. However, many links (e.g. Tickets)
result in content my browser (Firefox) wants to download rather than
display, presumably because it still looks a lot like Mason code as
opposed to renderable HTML. Other links, such as “Configuration ->
Users” do kinda work.
Please, look in your httpd error log. Is there seg faults in the log?

Well done! I am still stuck getting all the modules installed.

I had some trouble with ‘make fixdeps’ (things apparently not getting
unpacked correctly), but installing with the CPAN shell (‘perl -MCPAN -e
shell’ -> ‘install ::’) worked fine.

In other news, the niggly feeling I had about my mod_perl setup got to me
and I switched to FastCGI. Now I have more functionality (I can play with
tickets, add users and do searches), but still have the same trouble with
"left navigation" links like “Tickets”, “Tools” and “Preferences”.

Does that ring any more bells with anyone? :wink:

I don’t have any segfaults in my Apache log - Apache seems quite happy.
I do have the following database error, which occurs when I go to create a
new user:

[Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server “/opt/rt3/bin/mason_handler.fcgi” stderr: DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: “”
[Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x953083c) couldn’t
execute the query ‘SELECT * FROM Principals WHERE LOWER(PrincipalType) = ? AND
(ObjectId IS NULL OR ObjectId = ‘’)’ at /usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 494.

Postgres doesn’t like this query at all if I run it from the monitor -
complains about the question mark. I’m not sure what to subsitute…

Thanks,

Adrian Close email: adrian.close@hitwise.com
Hitwise phone: +61 3 8530 2446
Level 7, 580 St Kilda Road fax: +61 3 9529 8907
Melbourne, VIC, 3004, Australia web: http://www.hitwise.com/

I don’t have any segfaults in my Apache log - Apache seems quite happy.
I do have the following database error, which occurs when I go to create a
new user:

[Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server “/opt/rt3/bin/mason_handler.fcgi” stderr: DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: “”
[Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x953083c) couldn’t
execute the query ‘SELECT * FROM Principals WHERE LOWER(PrincipalType) = ? AND
(ObjectId IS NULL OR ObjectId = ‘’)’ at /usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 494.

This is an known issue in DBIx::SearchBuilder involving searching for
null fields under Postgres; in fact, we checked in a fix for it just
this afternoon and are currently trying to ensure that we have fully
fixed the problem.

–dave
Code Monkey, Best Practical Solutions

David Glasser | glasser@mit.edu | http://www.davidglasser.net/

I don’t have any segfaults in my Apache log - Apache seems quite happy.
I do have the following database error, which occurs when I go to create a
new user:

[Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server “/opt/rt3/bin/mason_handler.fcgi” stderr: DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: “”
[Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x953083c) couldn’t
execute the query ‘SELECT * FROM Principals WHERE LOWER(PrincipalType) = ? AND
(ObjectId IS NULL OR ObjectId = ‘’)’ at /usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 494.

This is an known issue in DBIx::SearchBuilder involving searching for
null fields under Postgres; in fact, we checked in a fix for it just
this afternoon and are currently trying to ensure that we have fully
fixed the problem.

And, to recap the workaround, if you haven’t already manually
downgraded your DBD::Pg from 1.4x to 1.32, do so, and try again.

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me

And, to recap the workaround, if you haven’t already manually
downgraded your DBD::Pg from 1.4x to 1.32, do so, and try again.

And like magic, everything works. Thanks for spelling out the workaround,
or I would have been waiting for a new release. It wasn’t obvious to me
that the DBD::Pg thing fixed my weird apparently Mason problems. Blah.

RT3 is looking like a serious improvement over the RT2 setup I had in a
past life (which was pretty good in itself) - thanks to all concerned for
the hard work.

Adrian Close email: adrian.close@hitwise.com
Hitwise phone: +61 3 8530 2446
Level 7, 580 St Kilda Road fax: +61 3 9529 8907
Melbourne, VIC, 3004, Australia web: http://www.hitwise.com/

And, to recap the workaround, if you haven’t already manually
downgraded your DBD::Pg from 1.4x to 1.32, do so, and try again.

And like magic, everything works. Thanks for spelling out the workaround,
or I would have been waiting for a new release. It wasn’t obvious to me
that the DBD::Pg thing fixed my weird apparently Mason problems. Blah.

What version did you have? 1.40 was seriously broken. 1.41 has been
good to me.

Jesse

And, to recap the workaround, if you haven’t already manually
downgraded your DBD::Pg from 1.4x to 1.32, do so, and try again.

And like magic, everything works. Thanks for spelling out the workaround,
or I would have been waiting for a new release. It wasn’t obvious to me
that the DBD::Pg thing fixed my weird apparently Mason problems. Blah.

What version did you have? 1.40 was seriously broken. 1.41 has been
good to me.

ISTR someone saying that they were even having trouble with 1.41,
actually; don’t remember who, though. Glad to be of service, Adrian.

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me