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, 17:39

chavenor1's gravatar image

chavenor1
11136
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, 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, 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, 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, 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, 06:21) yvecai

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

permanent link

answered 29 Jun, 18:06

chavenor1's gravatar image

chavenor1
11136
accept rate: 0%

Your answer
toggle preview

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

Question tags:

×178
×85
×53

question asked: 27 Jun, 17:39

question was seen: 374 times

last updated: 29 Jun, 18:06

powered by OSQA