[NUUG fiksgatami] [patch] Get graph drawing working for fiksgatami.no

[Matthew Somerville]

Hi Petter,

The scripts do work fine here. On our servers, the user that the site is 
run by has a .pgpass file set up so that it can access the database 
without a password when using psql - this seems a possible solution for 
you too? If you're going to do something like the below, it would seem 
more sensible to change the whole script to Perl rather than a hybrid; 
it could then have less temporary file usage etc. too.

 > BTW: I saw you published info on a Nokia app for Fixmystreet.  Where
 > can I reach the author, to see if I can get it adjusted for my N810?

I'll pass on your request :) Just heard from him out of the blue a few 
days ago.

ATB,
Matthew

On 24/03/2011 07:48, Petter Reinholdtsen wrote:
> The script to generate the graph linked in from the admin page do not
> work on fiksgatami.no.  The reason is that the psql call is rejected
> by the access control in postgresql.  To avoid this, I rewrote the
> script to connect to postgresql using Perl and make sure the same
> mechanism used by the CGI scripts are also used by the graph drawing
> script.  I also adjusted the start date and removed the temporary
> files.
>
> Please verify and commit this patch.