[rt-users] rt 3.8.1: Graphical charts are not available. error

[Drew Barnes]

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 at 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