Rt 3.8.1: Graphical charts are not available. error

Hi folks,

I hope this is the right list to submit my quesstion. Sorry in advance
if it isn’t.

I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie)
the output of ticket searches
I get the error “Graphical charts are not available”.

I looked in the archives and saw the following “Re: Hierarchy View in
3.8” by Helmuth Ramirez.
Following this thread I did the following:

  • installed graphviz from http://www.graphviz.org/ using
    yum install ‘graphviz*’

    I got the error: yum install graphviz-php.i386 <-- missing dependency
    graphviz = 2.16-1.el5 is
    needed by package graphviz-php

    So I then -

  • downloaded the source from http://www.graphviz.org/ and installed it.

  • “yum install webdot” and did a

    perl -MCPAN -e ‘install GraphViz’

  • ran the command “dot -c” in an xterm.

rebooted the system and still no luck.

I see the following in the apache2.access log file but nothing looks
like a glaring reason why
it won’t graph:

xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/Search/Chart.html?Order=ASC%7CASC%7CASC%7CASC&Query=Queue+%3D+%27Problems%27&Rows=50&OrderBy=id%7C%7C%7C&Format=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27&ChartStyle=bar&PrimaryGroupBy=Status
HTTP/1.1” 200 13787
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/NoAuth/css/web2/main-squished.css HTTP/1.1” 200 21842
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/css/print.css HTTP/1.1” 200 443
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/util.js
HTTP/1.1” 200 6190
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/titlebox-state.js HTTP/1.1” 200 928
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/ahah.js
HTTP/1.1” 200 1032
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/prototype/prototype.js HTTP/1.1” 200 124137
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls
HTTP/1.1” 200 2655
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/effects.js HTTP/1.1” 200 38986
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/controls.js HTTP/1.1” 200 34927
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/RichText/fckeditor.js HTTP/1.1” 200 8983
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/webrtfm.css HTTP/1.1” 200 513
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/css/calendar.css HTTP/1.1” 200 746

There doesn’t seem like there needs to be an entry for this in the
RT_SiteConfig.pm file in order
to get this to work but I could be missing the bleeding obvious.

All suggestions welcome!

thanks.

janet

AFAIK GraphViz is only used to show relationship charts for dependencies, linked tickets, etc. Instead GD is used for displaying charts based on ticket search results (GD::Graph) Am I wrong? I assume Graphs based on ticket search results was working before the upgrade. Try adding this to your RT_SiteConfig:

Set($DisableGD, 0);

or

Set($DisableGD, undef);

If that doesn’t work after an apache restart, there are other things to try. Also if someone out there knows, does --enable-gd during RT configure simply set the DisableGD value in RT_Config to undef or 1?

Elias-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Janet Houser
Sent: Friday, October 24, 2008 10:20 AM
To: RT-Users@lists.bestpractical.com
Subject: [rt-users] rt 3.8.1: Graphical charts are not available. error

Hi folks,

I hope this is the right list to submit my quesstion. Sorry in advance
if it isn’t.

I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie)
the output of ticket searches
I get the error “Graphical charts are not available”.

I looked in the archives and saw the following “Re: Hierarchy View in
3.8” by Helmuth Ramirez.
Following this thread I did the following:

  • installed graphviz from http://www.graphviz.org/ using
    yum install ‘graphviz*’

    I got the error: yum install graphviz-php.i386 <-- missing dependency
    graphviz = 2.16-1.el5 is
    needed by package graphviz-php

    So I then -

  • downloaded the source from http://www.graphviz.org/ and installed it.

  • “yum install webdot” and did a

    perl -MCPAN -e ‘install GraphViz’

  • ran the command “dot -c” in an xterm.

rebooted the system and still no luck.

I see the following in the apache2.access log file but nothing looks
like a glaring reason why
it won’t graph:

xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/Search/Chart.html?Order=ASC%7CASC%7CASC%7CASC&Query=Queue+%3D+%27Problems%27&Rows=50&OrderBy=id%7C%7C%7C&Format=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27&ChartStyle=bar&PrimaryGroupBy=Status
HTTP/1.1” 200 13787
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/NoAuth/css/web2/main-squished.css HTTP/1.1” 200 21842
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/css/print.css HTTP/1.1” 200 443
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/util.js
HTTP/1.1” 200 6190
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/titlebox-state.js HTTP/1.1” 200 928
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/ahah.js
HTTP/1.1” 200 1032
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/prototype/prototype.js HTTP/1.1” 200 124137
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls
HTTP/1.1” 200 2655
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/effects.js HTTP/1.1” 200 38986
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/controls.js HTTP/1.1” 200 34927
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/RichText/fckeditor.js HTTP/1.1” 200 8983
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/webrtfm.css HTTP/1.1” 200 513
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/css/calendar.css HTTP/1.1” 200 746

There doesn’t seem like there needs to be an entry for this in the
RT_SiteConfig.pm file in order
to get this to work but I could be missing the bleeding obvious.

All suggestions welcome!

thanks.

janet

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

I would try reinstalling GD::Graph from CPAN (forcing if necessary).
Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade?

Janet Houser wrote:

Hi folks,

I hope this is the right list to submit my quesstion. Sorry in advance
if it isn’t.

I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie)
the output of ticket searches
I get the error “Graphical charts are not available”.

I looked in the archives and saw the following “Re: Hierarchy View in
3.8” by Helmuth Ramirez.
Following this thread I did the following:

  • installed graphviz from http://www.graphviz.org/ using
    yum install ‘graphviz*’

    I got the error: yum install graphviz-php.i386 <-- missing dependency
    graphviz = 2.16-1.el5 is
    needed by package graphviz-php

    So I then -

  • downloaded the source from http://www.graphviz.org/ and installed it.

  • “yum install webdot” and did a

    perl -MCPAN -e ‘install GraphViz’

  • ran the command “dot -c” in an xterm.

rebooted the system and still no luck.

I see the following in the apache2.access log file but nothing looks
like a glaring reason why
it won’t graph:

xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/Search/Chart.html?Order=ASC%7CASC%7CASC%7CASC&Query=Queue+%3D+%27Problems%27&Rows=50&OrderBy=id%7C%7C%7C&Format=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27&ChartStyle=bar&PrimaryGroupBy=Status
HTTP/1.1” 200 13787
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/NoAuth/css/web2/main-squished.css HTTP/1.1” 200 21842
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/css/print.css HTTP/1.1” 200 443
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/util.js
HTTP/1.1” 200 6190
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/titlebox-state.js HTTP/1.1” 200 928
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/ahah.js
HTTP/1.1” 200 1032
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/prototype/prototype.js HTTP/1.1” 200 124137
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls
HTTP/1.1” 200 2655
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/effects.js HTTP/1.1” 200 38986
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/controls.js HTTP/1.1” 200 34927
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/RichText/fckeditor.js HTTP/1.1” 200 8983
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/webrtfm.css HTTP/1.1” 200 513
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/css/calendar.css HTTP/1.1” 200 746

There doesn’t seem like there needs to be an entry for this in the
RT_SiteConfig.pm file in order
to get this to work but I could be missing the bleeding obvious.

All suggestions welcome!

thanks.

janet


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

It appears ‘–enable-gd’ or ‘–with-gd’ in configure simply turns on the testing for whether GD is installed and working, if so it will either set DisableGD to 1 or undef depending on the test. Janet, I’m betting DisableGD set to undef is what will make the magic happen.-----Original Message-----
From: Eli Altman
Sent: Friday, October 24, 2008 10:51 AM
To: ‘Janet Houser’; RT-Users@lists.bestpractical.com
Subject: RE: [rt-users] rt 3.8.1: Graphical charts are not available. error

AFAIK GraphViz is only used to show relationship charts for dependencies, linked tickets, etc. Instead GD is used for displaying charts based on ticket search results (GD::Graph) Am I wrong? I assume Graphs based on ticket search results was working before the upgrade. Try adding this to your RT_SiteConfig:

Set($DisableGD, 0);

or

Set($DisableGD, undef);

If that doesn’t work after an apache restart, there are other things to try. Also if someone out there knows, does --enable-gd during RT configure simply set the DisableGD value in RT_Config to undef or 1?

Elias

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Janet Houser
Sent: Friday, October 24, 2008 10:20 AM
To: RT-Users@lists.bestpractical.com
Subject: [rt-users] rt 3.8.1: Graphical charts are not available. error

Hi folks,

I hope this is the right list to submit my quesstion. Sorry in advance
if it isn’t.

I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie)
the output of ticket searches
I get the error “Graphical charts are not available”.

I looked in the archives and saw the following “Re: Hierarchy View in
3.8” by Helmuth Ramirez.
Following this thread I did the following:

  • installed graphviz from http://www.graphviz.org/ using
    yum install ‘graphviz*’

    I got the error: yum install graphviz-php.i386 <-- missing dependency
    graphviz = 2.16-1.el5 is
    needed by package graphviz-php

    So I then -

  • downloaded the source from http://www.graphviz.org/ and installed it.

  • “yum install webdot” and did a

    perl -MCPAN -e ‘install GraphViz’

  • ran the command “dot -c” in an xterm.

rebooted the system and still no luck.

I see the following in the apache2.access log file but nothing looks
like a glaring reason why
it won’t graph:

xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/Search/Chart.html?Order=ASC%7CASC%7CASC%7CASC&Query=Queue+%3D+%27Problems%27&Rows=50&OrderBy=id%7C%7C%7C&Format=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27&ChartStyle=bar&PrimaryGroupBy=Status
HTTP/1.1” 200 13787
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/NoAuth/css/web2/main-squished.css HTTP/1.1” 200 21842
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/css/print.css HTTP/1.1” 200 443
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/util.js
HTTP/1.1” 200 6190
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/titlebox-state.js HTTP/1.1” 200 928
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/ahah.js
HTTP/1.1” 200 1032
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/prototype/prototype.js HTTP/1.1” 200 124137
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls
HTTP/1.1” 200 2655
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/effects.js HTTP/1.1” 200 38986
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/controls.js HTTP/1.1” 200 34927
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/RichText/fckeditor.js HTTP/1.1” 200 8983
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/webrtfm.css HTTP/1.1” 200 513
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/css/calendar.css HTTP/1.1” 200 746

There doesn’t seem like there needs to be an entry for this in the
RT_SiteConfig.pm file in order
to get this to work but I could be missing the bleeding obvious.

All suggestions welcome!

thanks.

janet

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Janet, if after the SiteConfig mod you get “You’ve enabled GD, but we couldn’t load the module: xxx” then you need to reinstall GD::Graph as Drew suggested.From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Drew Barnes
Sent: Friday, October 24, 2008 10:59 AM
To: Janet Houser
Cc: RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error

I would try reinstalling GD::Graph from CPAN (forcing if necessary).
Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade?

Janet Houser wrote:

Hi folks,

I hope this is the right list to submit my quesstion. Sorry in advance
if it isn’t.

I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie)
the output of ticket searches
I get the error “Graphical charts are not available”.

I looked in the archives and saw the following “Re: Hierarchy View in
3.8” by Helmuth Ramirez.
Following this thread I did the following:

  • installed graphviz from http://www.graphviz.org/ using
    yum install ‘graphviz*’

    I got the error: yum install graphviz-php.i386 <-- missing dependency
    graphviz = 2.16-1.el5 is
    needed by package graphviz-php

    So I then -

  • downloaded the source from http://www.graphviz.org/ and installed it.

  • “yum install webdot” and did a

    perl -MCPAN -e ‘install GraphViz’

  • ran the command “dot -c” in an xterm.

rebooted the system and still no luck.

I see the following in the apache2.access log file but nothing looks
like a glaring reason why
it won’t graph:

xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/Search/Chart.html?Order=ASC%7CASC%7CASC%7CASC&Query=Queue+%3D+%27Problems%27&Rows=50&OrderBy=id%7C%7C%7C&Format=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27&ChartStyle=bar&PrimaryGroupBy=Status
HTTP/1.1” 200 13787
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/NoAuth/css/web2/main-squished.css HTTP/1.1” 200 21842
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/css/print.css HTTP/1.1” 200 443
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/util.js
HTTP/1.1” 200 6190
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/titlebox-state.js HTTP/1.1” 200 928
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/ahah.js
HTTP/1.1” 200 1032
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/prototype/prototype.js HTTP/1.1” 200 124137
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls
HTTP/1.1” 200 2655
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/effects.js HTTP/1.1” 200 38986
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/controls.js HTTP/1.1” 200 34927
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/RichText/fckeditor.js HTTP/1.1” 200 8983
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/webrtfm.css HTTP/1.1” 200 513
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/css/calendar.css HTTP/1.1” 200 746

There doesn’t seem like there needs to be an entry for this in the
RT_SiteConfig.pm file in order
to get this to work but I could be missing the bleeding obvious.

All suggestions welcome!

thanks.

janet


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Hi Eli,

Thanks.

I didn’t modify my new SiteConfig file for graphing. Did I miss
something? In my previous verion (3.6.5) I didn’t have to
add anything special for bar and pie graphs to work, so I assumed I
didn’t need any new graphing mods in my 3.8.1 Site config file.

j

It won’t hurt anything to set the DisableGD to undef anywhere in the SiteConfig (except the last line)… it can only help. Give it a shot, restart apache and tell me how it goes.From: Janet Houser [mailto:jhouser@cfa.harvard.edu]
Sent: Friday, October 24, 2008 11:27 AM
To: Eli Altman
Cc: Drew Barnes; RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error

Hi Eli,

Thanks.

I didn’t modify my new SiteConfig file for graphing. Did I miss
something? In my previous verion (3.6.5) I didn’t have to
add anything special for bar and pie graphs to work, so I assumed I
didn’t need any new graphing mods in my 3.8.1 Site config file.

j

Janet, if after the SiteConfig mod you get “You’ve enabled GD, but we couldn’t load the module: xxx” then you need to reinstall GD::Graph as Drew suggested.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Drew Barnes
Sent: Friday, October 24, 2008 10:59 AM
To: Janet Houser
Cc: RT-Users@lists.bestpractical.com
Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error

I would try reinstalling GD::Graph from CPAN (forcing if necessary).
Perhaps the RT upgrade was coincidental to a redhat perl rpm upgrade?

Janet Houser wrote:

Hi folks,

I hope this is the right list to submit my quesstion. Sorry in advance
if it isn’t.

I upgraded to rt 3.8.1 last month and when I try to plot (bar or pie)
the output of ticket searches
I get the error “Graphical charts are not available”.

I looked in the archives and saw the following “Re: Hierarchy View in
3.8” by Helmuth Ramirez.
Following this thread I did the following:

  • installed graphviz from http://www.graphviz.org/ using
    yum install ‘graphviz*’

    I got the error: yum install graphviz-php.i386 <-- missing dependency
    graphviz = 2.16-1.el5 is
    needed by package graphviz-php

    So I then -

  • downloaded the source from http://www.graphviz.org/ and installed it.

  • “yum install webdot” and did a

    perl -MCPAN -e ‘install GraphViz’

  • ran the command “dot -c” in an xterm.

rebooted the system and still no luck.

I see the following in the apache2.access log file but nothing looks
like a glaring reason why
it won’t graph:

xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/Search/Chart.html?Order=ASC%7CASC%7CASC%7CASC&Query=Queue+%3D+%27Problems%27&Rows=50&OrderBy=id%7C%7C%7C&Format=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27&ChartStyle=bar&PrimaryGroupBy=Status
HTTP/1.1” 200 13787
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:01 -0400] “GET
/NoAuth/css/web2/main-squished.css HTTP/1.1” 200 21842
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/css/print.css HTTP/1.1” 200 443
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/util.js
HTTP/1.1” 200 6190
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/titlebox-state.js HTTP/1.1” 200 928
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET /NoAuth/js/ahah.js
HTTP/1.1” 200 1032
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:02 -0400] “GET
/NoAuth/js/prototype/prototype.js HTTP/1.1” 200 124137
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/scriptaculous.js?load=effects,controls
HTTP/1.1” 200 2655
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/effects.js HTTP/1.1” 200 38986
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:03 -0400] “GET
/NoAuth/js/scriptaculous/controls.js HTTP/1.1” 200 34927
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/RichText/fckeditor.js HTTP/1.1” 200 8983
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/webrtfm.css HTTP/1.1” 200 513
xxx.xxx.xxx.xxx - - [23/Oct/2008:13:22:04 -0400] “GET
/NoAuth/css/calendar.css HTTP/1.1” 200 746

There doesn’t seem like there needs to be an entry for this in the
RT_SiteConfig.pm file in order
to get this to work but I could be missing the bleeding obvious.

All suggestions welcome!

thanks.

janet


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Hi Eli,

I put an entry “Set($DisableGD, undef);” and restarted httpd. The good
news is that the error went away. The
bad is that it still doesn’t plot. That’s weird.

j

Eli Altman wrote:

|# I put an entry “Set($DisableGD, undef);” and restarted httpd. The good
|# news is that the error went away. The
|# bad is that it still doesn’t plot. That’s weird.

Check your apache error log. I put up a fresh copy of 3.8.1 (src,
not emerged) on a gentoo 2.6.25 box before I update our main instance.

I get this in my error_log when trying to graph something in RT. I have
not pursued any further at this point because of other projects.

[Fri Oct 24 11:59:09 2008] [notice] Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8h PHP/5.2.6-pl7-gentoo mod_perl/2.0.3-dev Perl/v5.8.8 configured – resuming normal operations
*** glibc detected *** /usr/sbin/apache2: double free or corruption (out): 0x0a841360 ***
======= Backtrace: =========
/lib/libc.so.6[0xb7c86a00]
/lib/libc.so.6(cfree+0x89)[0xb7c886f9]
/usr/lib/libgd.so.2(gdFree+0x1d)[0xb6d0c3fd]
/usr/lib/perl5/vendor_perl/5.8.8/i686-linux/auto/GD/GD.so(XS_GD__Image_png+0xde)[0xb6eeea0e]
/usr/lib/libperl.so.1(Perl_pp_entersub+0x3cf)[0xb713e8af]
/usr/lib/libperl.so.1(Perl_runops_standard+0x25)[0xb713d0d5]
/usr/lib/libperl.so.1[0xb70e8250]
/usr/lib/libperl.so.1(Perl_call_sv+0x629)[0xb70e8f49]
/usr/lib/apache2/modules/mod_perl.so(modperl_callback+0x377)[0xb71dbb83]
/usr/lib/apache2/modules/mod_perl.so(modperl_callback_run_handlers+0x472)[0xb71dc325]
/usr/lib/apache2/modules/mod_perl.so(modperl_callback_per_dir+0x5d)[0xb71dc7bc]
/usr/lib/apache2/modules/mod_perl.so[0xb71d77f5]
/usr/lib/apache2/modules/mod_perl.so(modperl_response_handler_cgi+0x17f)[0xb71d7a92]
/usr/sbin/apache2(ap_run_handler+0x57)[0x80788f7]
/usr/sbin/apache2(ap_invoke_handler+0x67)[0x807ba07]
/usr/sbin/apache2(ap_process_request+0x178)[0x8086898]
/usr/sbin/apache2[0x8083afe]
/usr/sbin/apache2(ap_run_process_connection+0x57)[0x807f8a7]
/usr/sbin/apache2[0x808ae2d]
/usr/sbin/apache2[0x808b106]
/usr/sbin/apache2(ap_mpm_run+0x438)[0x808b608]
/usr/sbin/apache2(main+0x848)[0x80663c8]
/lib/libc.so.6(__libc_start_main+0xdc)[0xb7c36fdc]
/usr/sbin/apache2(apr_dso_error+0x41)[0x80655e1]
======= Memory map: ========
08048000-08097000 r-xp 00000000 08:03 631511 /usr/sbin/apache2
08097000-08098000 r–p 0004e000 08:03 631511 /usr/sbin/apache2
08098000-0809a000 rw-p 0004f000 08:03 631511 /usr/sbin/apache2
[etc, etc]
[Fri Oct 24 12:48:53 2008] [notice] child pid 5640 exit signal Aborted (6)

            Tim Rosmus <trosmus@nwnexus.net>
               Postmaster / USENET / DNS
            Northwest Nexus Inc. / NetOS Inc.

A solution for the lists, have a good weekend Janet.From: Janet Houser [mailto:jhouser@cfa.harvard.edu]
Sent: Friday, October 24, 2008 2:10 PM
To: Eli Altman
Subject: Re: [rt-users] rt 3.8.1: Graphical charts are not available. error

Hi Eli,