I run renderd manualy in putty,
so I´m logged in as renderaccount, start renderd with
renderd -f -c /usr/local/etc/renderd.conf
when I access over http to apache http://ip/hot/0/0/0.png
I get following output in renderd:
Mapnik LOG> 2020-02-27 13:41:12: warning: unable to find face-name ‘HanaMinB Regular’ in FontSet ‘fontset-2’
Mapnik LOG> 2020-02-27 13:41:12: warning: unable to find face-name ‘unifont Medium’ in FontSet ‘fontset-2’
renderd[18016]: An error occurred while loading the map layer ‘ajt’: Postgis Plugin: ERROR: permission denied for relation plan et_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 822 of ‘/home/renderaccount/src/openstreetmap-carto/ mapnik.xml’
renderd[18016]: An error occurred while loading the map layer ‘ajt’: Postgis Plugin: ERROR: permission denied for relation plan et_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 822 of ‘/home/renderaccount/src/openstreetmap-carto/ mapnik.xml’
renderd[18016]: DEBUG: Got incoming connection, fd 8, number 1
renderd[18016]: DEBUG: Got incoming request with protocol version 2
renderd[18016]: DEBUG: Got command RenderPrio fd(8) xml(ajt), z(0), x(0), y(0), mime(image/png), options()
renderd[18016]: Received request for map layer ‘ajt’ which failed to load
renderd[18016]: DEBUG: Sending render cmd(4 ajt 0/0/0) with protocol version 2 to fd 8
renderd[18016]: DEBUG: Connection 0, fd 8 closed, now 0 left
===================================================================================================
EDIT:
Now setting als background-service:
ps -ef | grep -i renderd
rendera+ 17048 1 0 13:30 ? 00:00:00 /usr/local/bin/renderd -c /usr/local/etc/renderd.conf
grep RUNASUSER= /etc/init.d/renderd
RUNASUSER=renderaccount
After that, I get no error.log error, but no tile picture!
systemctl status renderd shows
An error occurred while loading the map layer ‘ajt’: Postgis Plugin: ERROR: permission denied for relation planet_osm_polyg
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 822 of '/home/renderaccount/src/openstreetmap-ca
Now it seems, that I have also problems with accessing database:
osm2pgsql -d gis --create --slim -G --hstore --tag-transform-script ~/src/openstreetmap-carto/openstreetmap-carto.lua -C 2500 --number-processes 1 -S ~/src/openstreetmap-carto/openstreetmap-carto.style ~/data/azerbaijan-latest.osm.pbf
osm2pgsql version 1.2.0 (1.2.0-265-gb686bf2) (64 bit id space)
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=2500MB, maxblocks=40000*65536, allocation method=11
Mid: pgsql, cache=2500
Setting up table: planet_osm_nodes
SQL command failed: ERROR: must be owner of relation planet_osm_nodes
Full query: DROP TABLE IF EXISTS planet_osm_nodes CASCADE
node cache: stored: 0(0.00%), storage efficiency: 0.00% (dense blocks: 0, sparse nodes: 0), hit rate: 0.00%
Osm2pgsql failed due to ERROR: Executing SQL
Greets
Byte