NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

First Time Install - permission denied for relation planet_osm_polygon

0

First time install and I'm getting the error below when I try to run rendered as render account.

My test box is smaller so I imported each US state one by one. Not sure if this has an effect or not. 

Mapnik LOG> 2019-06-27 16:21:41: warning: unable to find face-name 'unifont Medium' in FontSet 'fontset-2'
renderd[22208]: An error occurred while loading the map layer 'ajt': Postgis Plugin: ERROR:  permission denied for relation planet_osm_polygon
in executeQuery Full sql was: 'SELECT ST_SRID("way") AS srid FROM planet_osm_polygon WHERE "way" IS NOT NULL LIMIT 1;'
  encountered during parsing of layer 'landcover-low-zoom' in Layer at line 755 of '/home/renderaccount/src/openstreetmap-carto/mapnik.xml'
renderd[22208]: An error occurred while loading the map layer 'ajt': Postgis Plugin: ERROR:  permission denied for relation planet_osm_polygon
in executeQuery Full sql was: 'SELECT ST_SRID("way") AS srid FROM planet_osm_polygon WHERE "way" IS NOT NULL LIMIT 1;'
  encountered during parsing of layer 'landcover-low-zoom' in Layer at line 755 of '/home/renderaccount/src/openstreetmap-carto/mapnik.xml'

asked 27 Jun '19, 17:39

chavenor1's gravatar image

chavenor1
11●4●4●6
accept rate: 0%

"permission denied for relation planet_osm_polygon" implies that the accounts used for part of the installation didn't match the account used for another part. I'm guessing that you're following https://switch2osm.org/manually-building-a-tile-server-18-04-lts/ , perhaps recheck what accoun you used for each part of that? Maybe you did some things as root and therefore can't access them as a non-root user?

(27 Jun '19, 20:25) SomeoneElse ♦

What account should be used through that guide? Not sure it's clear if I should be root or renderaccount. Should I delete and re-install? Is rendered run by root or render account?

(27 Jun '19, 20:36) chavenor1

From memory, everything to be done as root has a "sudo" at the front, such as "sudo apt-get install ...". If you type in the commands as written, everything will work.

As written, the guide uses a Linux user account called "renderaccount" to run things like renderd from. The postgres side of things is handled at "ALTER TABLE geometry_columns OWNER TO renderaccount;" and the Linux system side at "sudo useradd -m renderaccount".

(27 Jun '19, 21:02) SomeoneElse ♦
1

I'm usually logged in as root is that a problem? Or should I make renderaccount part of the sudo group? What account root or renderaccount or Postgres should this command be run at?

osm2pgsql -d gis --create --slim -G --hstore --tag-transform-script ~/src/openstreetmap-carto/openstreetmap-carto.lua -C 1000 --number-processes 1 -S ~/src/openstreetmap-carto/openstreetmap-carto.style ~/data/delaware-latest.osm.pbf

(27 Jun '19, 21:09) chavenor1

You have a Postgres user issue, not a Linux user one: they are separate things. Running 'psql -l' will tell us who owns your gis database.

(29 Jun '19, 06:21) yvecai
One Answer:
active answersoldest answersnewest answerspopular answers
0

Re-loading the .osm.pbf files into the PostGIS DB while using the renderaccount fixed the issue.

permanent link

answered 29 Jun '19, 18:06

chavenor1's gravatar image

chavenor1
11●4●4●6
accept rate: 0%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Question tags:

×202
×105
×61

question asked: 27 Jun '19, 17:39

question was seen: 4,478 times

last updated: 29 Jun '19, 18:06

Related questions

Tiles are missing all features with sample_leaflet.html at any zoom? First Time Installer

How does tilesAtHome (t@h) work?

Logging traces and updating the map

Can't see an object in edit mode?

Fixing a subway stop

Problems with a boundary

How can I draw attention of other OSM users to unnamed and missing streets in a city?

Generating a political world map with osm data.

Added austria. When will I see the change ?

How do I delete a GPS trace?

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum