
Allo, Do the stats graphs work? I tried running bin/mkStats.pl and it gave me the attached errors (from syslog, so there's a bit of extra stuff). Maybe MySQL/PostgreSQL differences? Thanks, Bryan

Hola Bryan, On Sat, Oct 19, 2002 at 12:42:27PM -0400, Bryan Fullerton wrote:
Allo,
Do the stats graphs work? I tried running bin/mkStats.pl and it gave me the attached errors (from syslog, so there's a bit of extra stuff). Maybe MySQL/PostgreSQL differences?
Stats graphs is working. Unfortunately just on MySQL. I fixed it (SQL-Query -=> CVS). Download: http://otrs.org/cgi-bin/cvsweb.cgi/~checkout~/otrs/bin/mkStats.pl?rev=1.10&c... And it will work.
Bryan
Adios ... Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson

On Mon, Oct 21, 2002 at 01:30:43PM +0200, Martin Edenhofer wrote:
Stats graphs is working. Unfortunately just on MySQL. I fixed it (SQL-Query -=> CVS).
Download: http://otrs.org/cgi-bin/cvsweb.cgi/~checkout~/otrs/bin/mkStats.pl?rev=1.10&c...
And it will work.
Oppps! Sorry. |-) But now: http://otrs.org/cgi-bin/cvsweb.cgi/~checkout~/otrs/bin/mkStats.pl?rev=1.11&c... Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 3:08pm up 37 days, 7:46, 6 users, load average: 0.02, 0.07, 0.03

On Monday, October 21, 2002, at 09:10 AM, Martin Edenhofer wrote:
http://otrs.org/cgi-bin/cvsweb.cgi/~checkout~/otrs/bin/ mkStats.pl?rev=1.11&content-type=text/plain
Hmm... no errors now, but the file is still empty. :(
%bin/mkStats.pl
mkStats.pl

Hi Bryan, On Mon, Oct 21, 2002 at 11:59:34AM -0400, Bryan Fullerton wrote:
Hmm... no errors now, but the file is still empty. :(
%bin/mkStats.pl mkStats.pl
- generate png pics [...] ->> creating stats for 2002/10 <<- writing /usr/local/opentrs/var/pics/stats/2002-10.gif %ls -l $HOME/var/pics/stats -rw-r--r-- 1 opentrs nogroup 0 Oct 21 11:56 2002-10.gif
Any ideas? Also, any idea why it's creating a .gif instead of a .png?
I'm not so familiar with the GD stuff. I tried to add a png check. Is this script (http://bogen.net/mkStats.pl) working?
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider

On Monday, October 21, 2002, at 12:35 PM, Martin Edenhofer wrote:
I'm not so familiar with the GD stuff. I tried to add a png check.
Is this script (http://bogen.net/mkStats.pl) working?
Yes! That works nicely. Though the vertical scale is a little compressed... http://samurai.com/2002-10.png Maybe I need more tickets. :) Bryan

Hi Bryan, On Mon, Oct 21, 2002 at 03:34:33PM -0400, Bryan Fullerton wrote:
[...] Yes! That works nicely. Though the vertical scale is a little compressed...
I worked a little bit on mkStats.pl. Now you have more options! ( http://otrs.org/cgi-bin/cvsweb.cgi/~checkout~/otrs/bin/mkStats.pl?rev=1.12&c... ) [...] usage: mkStats.pl -x <width>, -y <height>, -j <year>, -m <month>, -d <debug> [...] -=> Try: mkStats.pl -x 400
Maybe I need more tickets. :)
Oh ja. :)
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 11:38pm up 37 days, 16:16, 5 users, load average: 0.01, 0.02, 0.00
participants (2)
-
Bryan Fullerton
-
Martin Edenhofer