[Talk-GB] Help with postgres

Lester Caine lester at lsces.co.uk
Wed Jul 10 08:24:36 UTC 2013


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 <lester at 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



More information about the Talk-GB mailing list