When I did this, many years ago, I used something like:
createuser -S -D -R apache
echo "GRANT ALL ON SCHEMA PUBLIC TO apache;" | psql gis
echo "grant all on geometry_columns to apache;" | psql gis
echo "grant all on spatial_ref_sys to apache;" | psql gis
I'm using apache as the user ID here as that's what Mapnik was running as.
This is taken from: http://www.passback.org.uk/maps/fedora.shtml.
Keith.
--
Keith Sharp
Passback Consultancy
keith.sh...@passback.co.uk
http://www.passback.co.uk
On 10 Jul 2013, at 08:43, Lester Caine <les...@lsces.co.uk> wrote:
> I've been working through all the disjointed installation guides in order to
> set up mapnik to run my own server, but while I'm fairly happy that
> everything is now in place, generate_tiles.py is giving me an authentication
> error. I had some fun at various points, and I'm installing onto an SUSE12.3
> server which is running text only, so I'm using ssh access to give me the
> command line, which may be part of my problem since I'm logged in as 'root'.
>
> I seem to have a 'gis' database fully populated, and I can access it via the
> user 'root', but not via the user 'gisuser' which is what I thought should be
> used, and which has worked in all the previous steps running osm2pgsql.
>
> Can anybody kick me in the right direction to fix this? I've got osrm routing
> running on the machine so something has set up properly.
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk
> Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
>
> _______________________________________________
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-gb
_______________________________________________
Talk-GB mailing list
Talk-GB@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-gb
