[OSM-dev] Mapnik/Postgres: Permissions Issue with contour layer
Nick Whitelegg
Nick.Whitelegg at solent.ac.uk
Tue Nov 9 22:47:16 GMT 2010
Hi,
I'm having difficulty rendering a Mapnik contour layer on a custom Mapnik tile server setup that I'm wanting to use for Freemap (this is on the SUCS website - thanks to Chris Jones!)
I've asked Chris, but in case it's a tricky issue I thought I'd ask here as well.
Basically OSM for the UK has been loaded into a database called 'gis'. I've also imported SRTM contour data, using the standard approach documented in the wiki, into a database called 'nickw' which I have full rights over (unlike the 'gis' database). I've granted SELECT privileges to the 'gis' user into this 'nickw' database but am getting the following error :
Nov 9 22:03:04 tilesrv renderd[13669]: An error occurred while loading the map layer 'openfootmap': PSQL error:#012ERROR: permission denied for relation geometry_columns#012Full sql was: 'SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='contours''#012 (encountered during parsing of layer 'srtm_10')
It seems that the 'gis' user cannot access the 'nickw' database for some reason.
Is it maybe something as simple as having to restart the pgsql daemon?
Incidentally I can render the contours successfully if I import into my own database on my own machine.
Any pointers on this? The relevant section of the XML is as follows:
<Layer name="srtm_10" status="on" srs="+proj=latlong +datum=WGS84">
<StyleName>contours10</StyleName>
<StyleName>contours-text10</StyleName>
<Datasource>
<Parameter name="type">postgis</Parameter>
<Parameter name="host">localhost</Parameter>
<Parameter name="port">5432</Parameter>
<Parameter name="user">gis</Parameter>
<Parameter name="password">[gis's password]</Parameter>
<Parameter name="dbname">nickw</Parameter>
<Parameter name="estimate_extent">false</Parameter>
<Parameter name="table">(select way,height from contours WHERE height::integer % 10 = 0 AND height::integer % 50 != 0 AND height::integer % 100 != 0) as "contours-10"</Parameter>
<Parameter name="extent">-180,-89.99,180,89.99</Parameter>
</Datasource>
</Layer>
Thanks,
Nick
More information about the dev
mailing list