[OSM-dev] Permission denied errors connecting to postgres from Mapnik

Nick Black nickblack1 at gmail.com
Thu Mar 8 10:27:51 GMT 2007


Hi Nick,

   Can you connect to postgres using psql:

# psql freemap -U nick -W -h localhost -p 5432

If you get the same error connecting from the psql client, its
probably a problem with pg_hba.conf.  Mine is set like:


# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

local   all         all                          trust

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5

So any machines on my local network can connect with an md5 encrypted
password.  You set the password for the user at account creation time
using:

create user foo with encrypted password 'blah'.








On 3/7/07, Nick Whitelegg <nick at hogweed.org> wrote:
> Hello Artem and everyone,
>
> Sorry... yet another problem :-( I'm now trying to connect to the postgis
> database from Mapnik.
>
> The postgresql user "nick" doesn't have a password and the postgresql server
> is running on port 5432. I could add all the OSM records in to the database
> successfully. In the mapnik xml file I have layers such as:
>
>  <Layer name="roads" status="on">
>     <StyleName>roads-casing</StyleName>
>     <StyleName>roads</StyleName>
>     <StyleName>secondary</StyleName>
>     <StyleName>primary</StyleName>
>     <StyleName>trunk</StyleName>
>     <StyleName>motorway</StyleName>
>     <Datasource>
>       <Parameter name="type">postgis</Parameter>
>       <Parameter name="host">localhost</Parameter>
>       <Parameter name="port">5432</Parameter>
>       <Parameter name="user">nick</Parameter>
>       <Parameter name="dbname">freemap</Parameter>
>       <Parameter name="table">(select
> way,highway,railway,landuse,"natural",man_made,waterway,tourism,learning,amenity,place,name,char_length(name)
> as length from planet_osm where waterway IS NULL and leisure IS NULL and
> landuse IS NULL) as roads</Parameter>
>     </Datasource>
>    </Layer>
>
> Running this from mapnik gives me an access denied error:
>
> connection to host=localhost port=5432 dbname=freemap user=nick password=
> connect_timeout=4 failed
> FATAL:  password authentication failed for user "nick"
>
> I guess I must have missed something out. Any pointers here?
> Changing "localhost" for "free-map.org.uk" is even worse.. it reports that it
> can't detect a database server running.
>
> Thanks,
> Nick
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>


-- 
Nick Black
--------------------------------
http://www.blacksworld.net




More information about the dev mailing list