RT Statistics Package

Rich_West2 · February 21, 2002, 4:37am

Hrmm… a thought just hit me. I’m running with mod_fastcgi… that might
prevent the graphics from being displayed.

But, still, I would be curious to know if the steps I took should have
been sufficient, and if the the error I listed indicated something other
than the limitation due to the mod_fastcgi install…

Thanks!
-Rich

Rich West wrote:

Simon_Cozens · February 19, 2002, 2:04pm

Attached is a simple statistics package for RT. I’m planning on releasing
further versions with more complex data available in the future, but I
think this is cool enough to release for now. Simply drop it into your
RT HTML tree, and go to http://rt/Statistics/

For shiny shiny graphs, you’ll need the Apache::GD::Graph module installed
as $rturl/graph but if you don’t want that, just dike out all the lines which
refer to “$url”. (This will make the time-to-resolve scatter graph a bit
useless, though.)

Thanks to Oxford University Computing Services for letting me develop and
distribute this.

The Blit is a nice terminal, but it runs emacs.

stats.tar.gz (3.15 KB)

Simon_Woodward1 · February 19, 2002, 2:44pm

Attached is a simple statistics package for RT. I’m planning on releasing
further versions with more complex data available in the future, but I
think this is cool enough to release for now. Simply drop it into your
RT HTML tree, and go to http://rt/Statistics/

Cool, looks nice, great potential

For shiny shiny graphs, you’ll need the Apache::GD::Graph module installed
as $rturl/graph

how ?

Matthew_D_Stock · February 19, 2002, 2:53pm

Simon Woodward writes:

For shiny shiny graphs, you’ll need the Apache::GD::Graph module installed
as $rturl/graph

how ?

I think I’m having similar problems. Following the directions related to
this module, I added an entry to my apache config like:

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

(It looks like your scripts are looking for chart, not graph)

I’m getting errors about the URL in the script not existing (broken link).
What am I missing?
Thanks,
-Matt

Simon_Cozens · February 19, 2002, 3:00pm

Matthew D. Stock:

<Location /usr/local/rt2/WebRT/chart>

Shouldn’t this be the local part of the URL, not the way it looks on
the filesystem? For instance, if RT is found at http://www.foo.com/rt/
then this should be

Wouldn’t you love to fill out that report? “Company asset #423423
was lost while fighting the forces of evil.”
– Chris Adams in the scary.devil.monastery

Matthew_D_Stock · February 19, 2002, 2:58pm

Simon Cozens writes:

Shouldn’t this be the local part of the URL, not the way it looks on
the filesystem? For instance, if RT is found at http://www.foo.com/rt/
then this should be

<Location /rt/chart>

I actually tried it both ways, and didn’t get it to work. Let me try a
different variation though…
-Matt

Simon_Woodward1 · February 19, 2002, 2:59pm

I think I’m having similar problems. Following the directions related
to this module, I added an entry to my apache config like:

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

(It looks like your scripts are looking for chart, not graph)

Yeah, pretty much getting the same thing:

[Tue Feb 19 14:56:53 2002] [error] [Mason] File does not exist:
/usr/local/rt2/WebRT/html//chart

And I have:

<VirtualHost ###.###.###.###>
ServerAdmin webmaster@onyx.net
DocumentRoot /usr/local/rt2/WebRT/html
ServerName ###.###.###
PerlModule Apache::DBI
PerlRequire /usr/local/rt2/bin/webmux.pl
SetHandler perl-script
<Directory /usr/local/rt2/stats>
SetHandler cgi-script
DirectoryIndex index.cgi

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

PerlHandler RT::Mason
Options ExecCGI FollowSymLinks
ErrorLog /usr/local/apache/logs/ticket.error.log
CustomLog /usr/local/apache/logs/ticket.access.log common

Simon_Woodward1 · February 19, 2002, 3:03pm

Shouldn’t this be the local part of the URL, not the way it looks on
the filesystem? For instance, if RT is found at http://www.foo.com/rt/
then this should be

<Location /rt/chart>

doh … That helped !

Now I’m getting

[Tue Feb 19 15:02:34 2002] [error] Undefined subroutine
&Apache::GD::Graph::handler called.

But it is installed.

Harald_Wagener · February 19, 2002, 3:06pm

“Matthew D. Stock” wrote:

Simon Woodward writes:

For shiny shiny graphs, you’ll need the Apache::GD::Graph module installed
as $rturl/graph

how ?

I tried the obvious and made a link from
/usr/lib/perl5//site_perl/5.6.0/Apache/GD/Graph.pm tp $rturl/chart .

It seems to work, although it complains about a malformed query url:

error in file: /opt/rt2/WebRT/html//chart
line 87: unknown section <%20>
context: …
83:
84: Most more complicated things depend on knowing the
GD::Graph interface.
85:
86: Firstly, B<make sure you are not using any spaces!> If you
want to pass a space in
87: a parameter in a URL-encoded string, use C<%20>, in a form
use a C<+>.
88:
89: Make sure to use C<cache=0> or C<PerlSetVar CacheSize 0>
when debugging,
90: otherwise you will spend hours being very confused.
91:
…

code stack:
/opt/rt2/WebRT/html//chart:87
/usr/lib/perl5/site_perl/5.6.0/HTML/Mason/Interp.pm:374
/usr/lib/perl5/site_perl/5.6.0/HTML/Mason/Request.pm:116

Of course, the space are correctly escaped.

Still confused,
Harald
Harald Wagener | Systemadministrator
FCB/Wilkens GmbH | Tel.:+49-40-2881-1252
An der Alster 42 | Fax.:+49-40-2881-1263
20099 Hamburg | http://www.fcb-wilkens.com

Matthew_D_Stock · February 19, 2002, 3:07pm

Simon Woodward writes:

Shouldn’t this be the local part of the URL, not the way it looks on
the filesystem? For instance, if RT is found at http://www.foo.com/rt/
then this should be

<Location /rt/chart>

doh … That helped !

Same here. I thought that was the first thing I tried, but apparently
not. The graphs look nice!
-Matt

Simon_Cozens · February 19, 2002, 3:11pm

Harald Wagener:

I tried the obvious and made a link from
/usr/lib/perl5//site_perl/5.6.0/Apache/GD/Graph.pm tp $rturl/chart .

I wouldn’t call that obvious. Please read “perldoc Apache::GD::Graph”.

I would have more respect for Ruby if its docs were not in ALL YOUR BASE
format.
- Dennis Taylor

Simon_Woodward1 · February 19, 2002, 3:25pm

Same here. I thought that was the first thing I tried, but apparently
not. The graphs look nice!

I wanna see, I wanna see … (still not working)

<VirtualHost ###.###.###.###>
ServerAdmin webmaster@onyx.net
DocumentRoot /usr/local/rt2/WebRT/html
ServerName ###.###.###
PerlModule Apache::DBI
PerlRequire /usr/local/rt2/bin/webmux.pl
SetHandler perl-script
<Directory /usr/local/rt2/stats>
SetHandler cgi-script
DirectoryIndex index.cgi

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

PerlHandler RT::Mason
Options ExecCGI FollowSymLinks
ErrorLog /usr/local/apache/logs/ticket.error.log
CustomLog /usr/local/apache/logs/ticket.access.log common

[Tue Feb 19 15:10:12 2002] [error] Undefined subroutine
&Apache::GD::Graph::handler called.

Tips/thoughts/comments/suggestions/ideas ?

Harald_Wagener · February 19, 2002, 3:51pm

Simon Cozens wrote:

Harald Wagener:

I tried the obvious and made a link from
/usr/lib/perl5//site_perl/5.6.0/Apache/GD/Graph.pm tp $rturl/chart .

I wouldn’t call that obvious. Please read “perldoc Apache::GD::Graph”.

It doesn’t work, either. (-;

Sorry, I just forgot the irony tags (-;, but it almost works. Now I need
to findout where https://oucs.ox.ac.uk/ is referenced…
ahh, there it goes.

Regards,
Harald

Harald Wagener | Systemadministrator
FCB/Wilkens GmbH | Tel.:+49-40-2881-1252
An der Alster 42 | Fax.:+49-40-2881-1263
20099 Hamburg | http://www.fcb-wilkens.com

Marcus_Ramberg · February 19, 2002, 4:10pm

Attached is a simple statistics package for RT. I’m planning on releasing
further versions with more complex data available in the future, but I
think this is cool enough to release for now. Simply drop it into your
RT HTML tree, and go to http://rt/Statistics/

For shiny shiny graphs, you’ll need the Apache::GD::Graph module installed
as $rturl/graph but if you don’t want that, just dike out all the lines which
refer to “$url”. (This will make the time-to-resolve scatter graph a bit
useless, though.)

Thanks to Oxford University Computing Services for letting me develop and
distribute this.

Very nice package, it looks great here, including the graphs.
Now I only have to put on the menu bar, and I can impress the suits

Just had to say how much I love this

Marcus

This e-mail has been protected by Song Networks’ virus-scan service:
http://www.securemail.no

Mitchell_Wright · February 19, 2002, 4:27pm

I am really intrigued to see this, but do not have a working installation
running at the moment.

Would anyone be so kind as to share some screen shots?

Thanks in advance,

MitchellOn 2/19/02 11:10 AM, “Marcus Ramberg” marcus.ramberg@songsolutions.no wrote:

On 19-02-02 15:04, “Simon Cozens” rt@netthink.co.uk wrote:

Attached is a simple statistics package for RT. I’m planning on releasing
further versions with more complex data available in the future, but I
think this is cool enough to release for now. Simply drop it into your
RT HTML tree, and go to http://rt/Statistics/

For shiny shiny graphs, you’ll need the Apache::GD::Graph module installed
as $rturl/graph but if you don’t want that, just dike out all the lines which
refer to “$url”. (This will make the time-to-resolve scatter graph a bit
useless, though.)

Thanks to Oxford University Computing Services for letting me develop and
distribute this.

Very nice package, it looks great here, including the graphs.
Now I only have to put on the menu bar, and I can impress the suits

Just had to say how much I love this

Marcus

–
This e-mail has been protected by Song Networks’ virus-scan service:
http://www.securemail.no

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

RT2_Troubles · February 19, 2002, 8:13pm

Me too!!

[Tue Feb 19 12:10:23 2002] [error] Undefined subroutine
&Apache::GD::Graph::handler called.

So if you find a solution… I’m all over it… :)On February 19, 2002 07:25 am, you wrote:

Same here. I thought that was the first thing I tried, but apparently
not. The graphs look nice!

I wanna see, I wanna see … (still not working)

<VirtualHost ###.###.###.###>
ServerAdmin webmaster@onyx.net
DocumentRoot /usr/local/rt2/WebRT/html
ServerName ###.###.###
PerlModule Apache::DBI
PerlRequire /usr/local/rt2/bin/webmux.pl
SetHandler perl-script
<Directory /usr/local/rt2/stats>
SetHandler cgi-script
DirectoryIndex index.cgi

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

PerlHandler RT::Mason
Options ExecCGI FollowSymLinks
ErrorLog /usr/local/apache/logs/ticket.error.log
CustomLog /usr/local/apache/logs/ticket.access.log common

[Tue Feb 19 15:10:12 2002] [error] Undefined subroutine
&Apache::GD::Graph::handler called.

Tips/thoughts/comments/suggestions/ideas ?

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

matt_carter · February 20, 2002, 12:08am

Hi there,

I don’t suppose there is a publically visible example or some screenshots
to look at on a URL somewhere?

–mattOn Tue, 19 Feb 2002, Simon Cozens wrote:

Attached is a simple statistics package for RT. I’m planning on releasing
further versions with more complex data available in the future, but I
think this is cool enough to release for now. Simply drop it into your
RT HTML tree, and go to http://rt/Statistics/

For shiny shiny graphs, you’ll need the Apache::GD::Graph module installed
as $rturl/graph but if you don’t want that, just dike out all the lines which
refer to “$url”. (This will make the time-to-resolve scatter graph a bit
useless, though.)

Thanks to Oxford University Computing Services for letting me develop and
distribute this.

–
The Blit is a nice terminal, but it runs emacs.

Simon_Woodward1 · February 20, 2002, 9:51am

Me too!!

[Tue Feb 19 12:10:23 2002] [error] Undefined subroutine
&Apache::GD::Graph::handler called.
So if you find a solution… I’m all over it…

None yet, but trying …

Trying hard, as I hope the suits are gonna like it, and it will stop em
bugging me for pretty graphs and stats …

Actually from what I have seen so far, the only thing I may suggest for
any future development is a totals column at the bottom to show the
averages / info right across the period you have chosen as well as on a
per day basis.

Simon

Michael_Bielicki · February 20, 2002, 10:06am

How can I make that zstuff run if I am not using mod_perl but fastcgi ?On Wed, 2002-02-20 at 09:51, Simon Woodward wrote:

Me too!!

[Tue Feb 19 12:10:23 2002] [error] Undefined subroutine
&Apache::GD::Graph::handler called.
So if you find a solution… I’m all over it…

None yet, but trying …

Trying hard, as I hope the suits are gonna like it, and it will stop em
bugging me for pretty graphs and stats …

Actually from what I have seen so far, the only thing I may suggest for
any future development is a totals column at the bottom to show the
averages / info right across the period you have chosen as well as on a
per day basis.

Simon

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

signature.asc (232 Bytes)

Rich_West2 · February 21, 2002, 4:28am

Just as an FYI, the call to your site is located on line 91 of
CallsMultiqueue.html.

I hate to be another person emailing you about this, but hopefully this
is an easy one that you have already hashed out. The installation was
rather easy, except I do not get the graphs at all (Apache::GD::Graph
and others are installed).

I tried, as some have suggested, linking
/usr/lib/perl5/site_perl/<perl_version>/Apache/GD/Graph.pm as
/WebRT/html/chart, and I get the following error:

Error during compilation of /usr/rt2/WebRT/html//chart:
unknown section <%20> (line 87)

HTML::Mason::Interp::__ANON__('Error during compilation of /usr/rt2/WebRT/html//chart:^Junknown ...') called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Interp.pm line 418
HTML::Mason::Interp::_compilation_error('HTML::Mason::Interp=HASH(0x8b1ea54)', '/usr/rt2/WebRT/html//chart', 'unknown section <%20> (line 87)^J') called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Interp.pm line 374
HTML::Mason::Interp::load('HTML::Mason::Interp=HASH(0x8b1ea54)', '//chart') called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 116
eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 116
HTML::Mason::Request::exec('HTML::Mason::Request=HASH(0x8f3dc38)', '//chart', 'x_labels', '[Thu 14,Fri 15,Mon 18,Tue 19,Wed 20]', 'data1', '[0,0,0,0,0]', 'data2', '[0,0,0,0,0]', ...) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Interp.pm line 243
HTML::Mason::Interp::exec('HTML::Mason::Interp=HASH(0x8b1ea54)', '//chart', 'x_labels', '[Thu 14,Fri 15,Mon 18,Tue 19,Wed 20]', 'data1', '[0,0,0,0,0]', 'data2', '[0,0,0,0,0]', ...) called at /usr/rt2/bin/mason_handler.fcgi line 199
eval {...} called at /usr/rt2/bin/mason_handler.fcgi line 198

Not sure what step I missed here… any help would be much appreciated!

-Rich

Simon Cozens wrote: