Keith Sharp wrote:
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.

Not helping :(
I used http://wiki.openstreetmap.org/wiki/PostGIS/Installation#openSUSE_11.2 to set up, and http://wiki.openstreetmap.org/wiki/Mapnik#Authentication_failure kicked in, but 'psql gis' gets me in and I can play with the data, just generate_tiles.py is giving the
FATAL:  Ident authentication failed for user "root" error

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

Reply via email to