RT2 + stats package + fastcgi

RT Users
1

We’ve been running RT1 to date - but now we’d like to add in attachments via
the web gui.

So I’ve just started evaluating RT2 running on Mandrake 9.1 using fastcgi
(Mysql 4.0.11 and Apache 1.3.27 as supplied with Mandrake 9.1).

I seem to have satisfied all the perl module dependancies, I’ve got the Web
Gui up and running and I’ve ported across some RT1 tickets - so far so good.
I can log in and at first glance all the ported data seems to be ok.

So I thought I’d try adding in the stats package. I’ve loaded
Apache::GD::Graph.

And I’ve added the following to /etc/httpd/conf/commonhttpd.conf.

<Location /rt2/chart>
SetHandler perl-script
PerlHandler +Apache::GD::Graph

I can access the http://localhost/rt2/Statistics/ page ok, and view the
tables etc., but get no graphs.

Anyone know what I need to do to see the graphs?

cheers,

Ian

PS Apologies for the sig below - I have no control over it!

CONFIDENTIALITY AND DISCLAIMER NOTICE

This message and any attachment is confidential and is protected by
copyright. If you are not the intended recipient, please email the sender or
telephone +44 (0)1442 213440 and delete this message and any attachment from
your system. Dissemination and or copying of this email is prohibited if you
are not the intended recipient.

We believe, but do not warrant, that this email and any attachments are
virus free. You should take full responsibility for virus checking.

No responsibility is accepted by FUJIFILM Electronic Imaging Limited for
personal emails or emails unconnected with FUJIFILM Electronic Imaging
Limited’s business.

2

I can access the http://localhost/rt2/Statistics/ page ok, and view the
tables etc., but get no graphs.

Anyone know what I need to do to see the graphs?

Which version of the statistics package did You install? Where did You
download it?

Regards,
Harald Wagener

3

Harald,

I got it from Technologie-Zentrum Informatik und Informationstechnik - Universität Bremen.
Is there a later/alternate version?

cheers,

Ian

-----Original Message-----
From: Harald Wagener [mailto:hwagener@hamburg.fcb.com]
Sent: Tuesday, November 25, 2003 1:33 PM
To: Ian Gilmour
Cc: ‘rt-users@lists.fsck.com’
Subject: Re: [rt-users] RT2 + stats package + fastcgi

Am 25.11.2003 um 11:30 schrieb Ian Gilmour:

I can access the http://localhost/rt2/Statistics/ page ok,
and view the
tables etc., but get no graphs.

Anyone know what I need to do to see the graphs?

Which version of the statistics package did You install?
Where did You
download it?

Regards,
Harald Wagener

CONFIDENTIALITY AND DISCLAIMER NOTICE

This message and any attachment is confidential and is protected by
copyright. If you are not the intended recipient, please email the sender or
telephone +44 (0)1442 213440 and delete this message and any attachment from
your system. Dissemination and or copying of this email is prohibited if you
are not the intended recipient.

We believe, but do not warrant, that this email and any attachments are
virus free. You should take full responsibility for virus checking.

No responsibility is accepted by FUJIFILM Electronic Imaging Limited for
personal emails or emails unconnected with FUJIFILM Electronic Imaging
Limited’s business.

4

Ian Gilmour wrote:

So I’ve just started evaluating RT2 running on Mandrake 9.1 using fastcgi

Any reason you’re starting with another old version instead of RT3?
Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances

5

First, is GD working?

Try:
http://yourwebsite.com/rt2/chart?type=area&x_labels=[Wed%2019,Thu%2020,Fri%2
021,Mon%2024,Tue%2025]&data1=[0,0,0,0,0]&data2=[0,0,0,0,0]&data3=[0,0,0,0,0]

It will be a graph with one line but if it shows, then you at
least know if GD is working.

Also make sure the last bracket is part of the url. Looking at it here it
doesn’t seem to be part of the link and I have no idea how to fix it.-----Original Message-----
From: rt-users-bounces@lists.fsck.com
[mailto:rt-users-bounces@lists.fsck.com] On Behalf Of Ian Gilmour
Sent: Tuesday, November 25, 2003 5:31 AM
To: ‘rt-users@lists.fsck.com’
Subject: [rt-users] RT2 + stats package + fastcgi

We’ve been running RT1 to date - but now we’d like to add in attachments via
the web gui.

So I’ve just started evaluating RT2 running on Mandrake 9.1 using fastcgi
(Mysql 4.0.11 and Apache 1.3.27 as supplied with Mandrake 9.1).

I seem to have satisfied all the perl module dependancies, I’ve got the Web
Gui up and running and I’ve ported across some RT1 tickets - so far so good.
I can log in and at first glance all the ported data seems to be ok.

So I thought I’d try adding in the stats package. I’ve loaded
Apache::GD::Graph.

And I’ve added the following to /etc/httpd/conf/commonhttpd.conf.

<Location /rt2/chart>
SetHandler perl-script
PerlHandler +Apache::GD::Graph

I can access the http://localhost/rt2/Statistics/ page ok, and view the
tables etc., but get no graphs.

Anyone know what I need to do to see the graphs?

cheers,

Ian

PS Apologies for the sig below - I have no control over it!

CONFIDENTIALITY AND DISCLAIMER NOTICE

This message and any attachment is confidential and is protected by
copyright. If you are not the intended recipient, please email the sender or
telephone +44 (0)1442 213440 and delete this message and any attachment from
your system. Dissemination and or copying of this email is prohibited if you
are not the intended recipient.

We believe, but do not warrant, that this email and any attachments are
virus free. You should take full responsibility for virus checking.

No responsibility is accepted by FUJIFILM Electronic Imaging Limited for
personal emails or emails unconnected with FUJIFILM Electronic Imaging
Limited’s business.
rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

6

Only because it looked like I had to at least get the RT1 data into an RT2
database, even if I want to use RT3 (which I haven’t discounted yet).

The perl packages required look pretty similar for both.

I also thought I could get away from having to manually install a recent
version of Mysql (RT3 README says it requires version 4.0.13). RT2 only
requires version 3.23.38 or later (Mandrake 9.1 comes with 4.0.11) - so I
figured that saved me having to install Mysql from source (potentially
problematic - I’ve never done it), or binary (potentially unoptomised for my
system). I already have a working mysql on the system - why change it if it
ain’t broke.

Installing it also looked like a good way of checking the data transferred
across correctly after using the import script.

RT2 also seemed to fit our immediate requirement of supporting attachments.

What are the advantages in going to RT3 over RT2? (Links to comparisons
between the 2 gratefully accepted - web gui speed, minimum system
requirements [cpu speed, RAM], etc.)

What are the negatives in going to RT3?

I may go to RT3 eventually, but I thought I’d at least evaluate RT2 before
doing the extra work.

cheers,

Ian

-----Original Message-----
From: Phil Homewood [mailto:pdh@snapgear.com]
Sent: Tuesday, November 25, 2003 10:45 PM
To: ‘rt-users@lists.fsck.com’
Subject: Re: [rt-users] RT2 + stats package + fastcgi

Ian Gilmour wrote:

So I’ve just started evaluating RT2 running on Mandrake 9.1
using fastcgi

Any reason you’re starting with another old version instead of RT3?

Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

CONFIDENTIALITY AND DISCLAIMER NOTICE

This message and any attachment is confidential and is protected by
copyright. If you are not the intended recipient, please email the sender or
telephone +44 (0)1442 213440 and delete this message and any attachment from
your system. Dissemination and or copying of this email is prohibited if you
are not the intended recipient.

We believe, but do not warrant, that this email and any attachments are
virus free. You should take full responsibility for virus checking.

No responsibility is accepted by FUJIFILM Electronic Imaging Limited for
personal emails or emails unconnected with FUJIFILM Electronic Imaging
Limited’s business.

7

Running this gives the following in the browser…

could not find component for initial path ‘/chart’

Stack:
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:226]
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:166]
[/usr/lib/perl5/site_perl/5.8.0/Class/Container.pm:265]
[/usr/lib/perl5/site_perl/5.8.0/Class/Container.pm:343]
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Interp.pm:213]
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Interp.pm:207]
[/home/rt/rt2-installation/bin/mason_handler.fcgi:208]

which means?? - thanks in advance.

cheers,

Ian

-----Original Message-----
From: AJ [mailto:rt@musefoundry.com]
Sent: Wednesday, November 26, 2003 4:49 AM
To: ‘Ian Gilmour’; rt-users@lists.fsck.com
Subject: RE: [rt-users] RT2 + stats package + fastcgi

First, is GD working?

Try:
Fastest Web Hosting Services | Buy High Quality Hosting[Wed%2019,
Thu%2020,Fri%2
021,Mon%2024,Tue%2025]&data1=[0,0,0,0,0]&data2=[0,0,0,0,0]&dat
a3=[0,0,0,0,0]

It will be a graph with one line but if it shows,
then you at
least know if GD is working.

Also make sure the last bracket is part of the url. Looking
at it here it
doesn’t seem to be part of the link and I have no idea how to fix it.

-----Original Message-----
From: rt-users-bounces@lists.fsck.com
[mailto:rt-users-bounces@lists.fsck.com] On Behalf Of Ian Gilmour
Sent: Tuesday, November 25, 2003 5:31 AM
To: ‘rt-users@lists.fsck.com’
Subject: [rt-users] RT2 + stats package + fastcgi

We’ve been running RT1 to date - but now we’d like to add in
attachments via
the web gui.

So I’ve just started evaluating RT2 running on Mandrake 9.1
using fastcgi
(Mysql 4.0.11 and Apache 1.3.27 as supplied with Mandrake 9.1).

I seem to have satisfied all the perl module dependancies,
I’ve got the Web
Gui up and running and I’ve ported across some RT1 tickets -
so far so good.
I can log in and at first glance all the ported data seems to be ok.

So I thought I’d try adding in the stats package. I’ve loaded
Apache::GD::Graph.

And I’ve added the following to /etc/httpd/conf/commonhttpd.conf.

<Location /rt2/chart>
SetHandler perl-script
PerlHandler +Apache::GD::Graph

I can access the http://localhost/rt2/Statistics/ page ok,
and view the
tables etc., but get no graphs.

Anyone know what I need to do to see the graphs?

cheers,

Ian

PS Apologies for the sig below - I have no control over it!

CONFIDENTIALITY AND DISCLAIMER NOTICE

This message and any attachment is confidential and is protected by
copyright. If you are not the intended recipient, please
email the sender or
telephone +44 (0)1442 213440 and delete this message and any
attachment from
your system. Dissemination and or copying of this email is
prohibited if you
are not the intended recipient.

We believe, but do not warrant, that this email and any
attachments are
virus free. You should take full responsibility for virus checking.

No responsibility is accepted by FUJIFILM Electronic Imaging
Limited for
personal emails or emails unconnected with FUJIFILM Electronic Imaging
Limited’s business.

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

CONFIDENTIALITY AND DISCLAIMER NOTICE

This message and any attachment is confidential and is protected by
copyright. If you are not the intended recipient, please email the sender or
telephone +44 (0)1442 213440 and delete this message and any attachment from
your system. Dissemination and or copying of this email is prohibited if you
are not the intended recipient.

We believe, but do not warrant, that this email and any attachments are
virus free. You should take full responsibility for virus checking.

No responsibility is accepted by FUJIFILM Electronic Imaging Limited for
personal emails or emails unconnected with FUJIFILM Electronic Imaging
Limited’s business.