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