Need help to serve my own tiles

kimented · September 6, 2021, 7:23pm

Hello!
I need tiles for a web-app, and I was thinking that it would be a good idea to have my own tile server
I followed the switch2osm recipe for Debian11, but I had some trouble.

First, the python script ~/src/openstreetmap-carto/scripts/get-external-data.py returned an error. After some search I’ve found that it’s a problem on the naturalearth server, but it seems that they already have this problem last year… Then, I cannot download the file ne_110m_admin_0_boundary_lines_land.zip from their server, and I didn’t found it elsewhere.

Despite this, I decided to continue the recipe, and when It tried to download a tile from my server I got a 404 error (http://my-ip/hot/0/0/0.png). What I can see in my syslog tells me that the zip file is needed, because the renderer cannot found some shapes.


Sep  6 16:06:13 bullseye systemd[1]: apache2.service: Succeeded.
Sep  6 16:06:13 bullseye systemd[1]: Stopped The Apache HTTP Server.
Sep  6 16:06:13 bullseye systemd[1]: apache2.service: Consumed 1.056s CPU time.
Sep  6 16:06:13 bullseye systemd[1]: Starting The Apache HTTP Server...
Sep  6 16:06:14 bullseye apachectl[11018]: [Mon Sep 06 16:06:14.079479 2021] [tile:warn] [pid 11018] Could not determine host name of server to configure tile-json request. Using localhost instead
Sep  6 16:06:14 bullseye apachectl[11018]: [Mon Sep 06 16:06:14.079660 2021] [tile:notice] [pid 11018] Loading tile config s2o at /hot/ for zooms 0 - 20 from tile directory /var/lib/mod_tile with extension .png and mime type image/png
Sep  6 16:06:14 bullseye systemd[1]: Started The Apache HTTP Server.
Sep  6 16:06:20 bullseye renderd[10955]: renderd[10955]: An error occurred while loading the map layer 's2o': Postgis Plugin: ERREUR:  la relation « ne_110m_admin_0_boundary_lines_land » n'existe pas
Sep  6 16:06:20 bullseye renderd[10955]: LINE 1: SELECT ST_SRID("way") AS srid FROM ne_110m_admin_0_boundary_...
Sep  6 16:06:20 bullseye renderd[10955]:                                            ^
Sep  6 16:06:20 bullseye renderd[10955]: in executeQuery Full sql was: 'SELECT ST_SRID("way") AS srid FROM ne_110m_admin_0_boundary_lines_land WHERE "way" IS NOT NULL LIMIT 1;'
Sep  6 16:06:20 bullseye renderd[10955]:   encountered during parsing of layer 'necountries' in Layer at line 32611 of '/home/kimented/src/openstreetmap-carto/mapnik.xml'
Sep  6 16:06:20 bullseye renderd[10955]: An error occurred while loading the map layer 's2o': Postgis Plugin: ERREUR:  la relation « ne_110m_admin_0_boundary_lines_land » n'existe pas#012LINE 1: SELECT ST_SRID("way") AS srid FROM ne_110m_admin_0_boundary_...#012                                           ^#012in executeQuery Full sql was: 'SELECT ST_SRID("way") AS srid FROM ne_110m_admin_0_boundary_lines_land WHERE "way" IS NOT NULL LIMIT 1;'#012  encountered during parsing of layer 'necountries' in Layer at line 32611 of '/home/kimented/src/openstreetmap-carto/mapnik.xml'
Sep  6 16:06:20 bullseye renderd[10955]: renderd[10955]: An error occurred while loading the map layer 's2o': Postgis Plugin: ERREUR:  la relation « ne_110m_admin_0_boundary_lines_land » n'existe pas
Sep  6 16:06:20 bullseye renderd[10955]: LINE 1: SELECT ST_SRID("way") AS srid FROM ne_110m_admin_0_boundary_...
Sep  6 16:06:20 bullseye renderd[10955]:                                            ^
Sep  6 16:06:20 bullseye renderd[10955]: in executeQuery Full sql was: 'SELECT ST_SRID("way") AS srid FROM ne_110m_admin_0_boundary_lines_land WHERE "way" IS NOT NULL LIMIT 1;'
Sep  6 16:06:20 bullseye renderd[10955]:   encountered during parsing of layer 'necountries' in Layer at line 32611 of '/home/kimented/src/openstreetmap-carto/mapnik.xml'
Sep  6 16:06:20 bullseye renderd[10955]: An error occurred while loading the map layer 's2o': Postgis Plugin: ERREUR:  la relation « ne_110m_admin_0_boundary_lines_land » n'existe pas#012LINE 1: SELECT ST_SRID("way") AS srid FROM ne_110m_admin_0_boundary_...#012                                           ^#012in executeQuery Full sql was: 'SELECT ST_SRID("way") AS srid FROM ne_110m_admin_0_boundary_lines_land WHERE "way" IS NOT NULL LIMIT 1;'#012  encountered during parsing of layer 'necountries' in Layer at line 32611 of '/home/kimented/src/openstreetmap-carto/mapnik.xml'
Sep  6 16:08:09 bullseye renderd[10955]: renderd[10955]: DEBUG: Got incoming connection, fd 9, number 1
Sep  6 16:08:09 bullseye renderd[10955]: renderd[10955]: DEBUG: Got incoming request with protocol version 2
Sep  6 16:08:09 bullseye renderd[10955]: DEBUG: Got incoming connection, fd 9, number 1
Sep  6 16:08:09 bullseye renderd[10955]: renderd[10955]: DEBUG: Got command RenderPrio fd(9) xml(s2o), z(0), x(0), y(0), mime(image/png), options()
Sep  6 16:08:09 bullseye renderd[10955]: renderd[10955]: Received request for map layer 's2o' which failed to load
Sep  6 16:08:09 bullseye renderd[10955]: renderd[10955]: DEBUG: Sending render cmd(4 s2o 0/0/0) with protocol version 2 to fd 9
Sep  6 16:08:09 bullseye renderd[10955]: renderd[10955]: DEBUG: Failed to read cmd on fd 9
Sep  6 16:08:09 bullseye renderd[10955]: renderd[10955]: DEBUG: Connection 0, fd 9 closed, now 0 left
Sep  6 16:08:09 bullseye renderd[10955]: DEBUG: Got incoming request with protocol version 2
Sep  6 16:08:09 bullseye renderd[10955]: DEBUG: Got command RenderPrio fd(9) xml(s2o), z(0), x(0), y(0), mime(image/png), options()
Sep  6 16:08:09 bullseye renderd[10955]: Received request for map layer 's2o' which failed to load
Sep  6 16:08:09 bullseye renderd[10955]: DEBUG: Sending render cmd(4 s2o 0/0/0) with protocol version 2 to fd 9
Sep  6 16:08:09 bullseye renderd[10955]: DEBUG: Failed to read cmd on fd 9
Sep  6 16:08:09 bullseye renderd[10955]: DEBUG: Connection 0, fd 9 closed, now 0 left

What can I do to solve this?

SomeoneElse · September 6, 2021, 8:32pm

I can’t guarantee that it’s everything that you need, but https://map.atownsend.org.uk/tmp/ne_110m_admin_0_boundary_lines_land.tar is the contents of the relevant directory from a (quite old) Debian server. It predates the latest changes to OSM Carto, so may not be exactly what you need.

If that doesn’t work, you’ll have to wait for Natural Earth to sort things out at their end.

Edit:

This issue: https://github.com/nvkelso/natural-earth-vector/issues/581#issuecomment-913988101 contains some URLs that might be useful. If you want to edit the download location directly, your copy of https://github.com/gravitystorm/openstreetmap-carto/blob/master/external-data.yml is the file to edit. I’ve not linked to the URLs directly here as things have a tendency to change on the Natural Earth side.

kimented · September 7, 2021, 2:35pm

Thank you!
I used the file from your first link. I repackaged the four files into a zip file, uploaded it on my web server and modified the external-data.yml file accordingly. And it works