search

BenioffOceanInitiative / ws-docker

Ships for Whales Docker server software setup
MIT License
0 stars 0 forks source link

point tile service to cluster db #6

Closed bbest closed 1 year ago

bbest commented 1 year ago

Update configuration to point to new cluster db here:

https://github.com/BenioffOceanInitiative/ws-docker/blob/20f040d8897c9a954e4f9c308ad564a085adcabc/docker-compose.yml#L63-L70

OLD

https://tile.whalesafe.com/

image
bbest commented 1 year ago

SSH via Google Cloud compute VM instances as ben@instance-1:

docker ps
CONTAINER ID   IMAGE                           COMMAND                  CREATED         STATUS                   PORTS                                                                                                                             NAMES
aca0001a1aa4   caddy:latest                    "caddy run --config …"   12 months ago   Up 12 months             0.0.0.0:80->80/tcp, :::80->80/tcp, 0.0.0.0:443->443/tcp, :::443->443/tcp, 2019/tcp                                                caddy
394bd25b30f4   ws-docker-rstudio               "/init"                  12 months ago   Up 12 months             0.0.0.0:3838->3838/tcp, :::3838->3838/tcp, 0.0.0.0:8787->8787/tcp, :::8787->8787/tcp, 0.0.0.0:8888->8888/tcp, :::8888->8888/tcp   rstudio
e42b8277bd18   eeacms/varnish                  "/docker-entrypoint.…"   12 months ago   Up 12 months (healthy)   0.0.0.0:6081->6081/tcp, :::6081->6081/tcp, 6085/tcp                                                                               tilecache
bd7359a106d3   pramsey/pg_tileserv:latest      "/app/pg_tileserv --…"   12 months ago   Up 12 months             0.0.0.0:7800->7800/tcp, :::7800->7800/tcp                                                                                         tileserv
ba50e8a459fc   pramsey/pg_featureserv:latest   "./pg_featureserv"       12 months ago   Up 12 months             0.0.0.0:9000->9000/tcp, :::9000->9000/tcp                                                                                         featureserv
cea60d5c4f29   postgis/postgis:latest          "docker-entrypoint.s…"   12 months ago   Up 12 months (healthy)   0.0.0.0:5432->5432/tcp, :::5432->5432/tcp 
cd /home/ben/ws-docker
vi docker-compose.yml

https://github.com/BenioffOceanInitiative/ws-docker/blob/d2e9ed1de1fe595803742accacb3b3c667746a6b/docker-compose.yml#L66

docker-compose restart

Error 503 Backend fetch failed

https://tile.whalesafe.com/

Error 503 Backend fetch failed
Backend fetch failed

Guru Meditation:
XID: 3

Varnish cache server

Error: Tools for managing Python virtual environments are not installed.

docker-compose up -d
Step 11/18 : RUN R -q -e 'reticulate::py_install(c("pandas", "pyarrow", "google-cloud-bigquery", "tzlocal", "pandas-gbq", "pyarrow", "sqlalchemy", "psycopg2-binary", "python-dateutil", "oauth2client", "google-auth-httplib2", "google-auth-oauthlib", "google-api-python-client"))'
 ---> Running in 3efef0f6628c
> reticulate::py_install(c("pandas", "pyarrow", "google-cloud-bigquery", "tzlocal", "pandas-gbq", "pyarrow", "sqlalchemy", "psycopg2-binary", "python-dateutil", "oauth2client", "google-auth-httplib2", "google-auth-oauthlib", "google-api-python-client"))
Error: Tools for managing Python virtual environments are not installed.

Install venv with:
$ sudo apt-get install python3-venv

Execution halted
ERROR: Service 'rstudio' failed to build: The command '/bin/sh -c R -q -e 'reticulate::py_install(c("pandas", "pyarrow", "google-cloud-bigquery", "tzlocal", "pandas-gbq", "pyarrow", "sqlalchemy", "psycopg2-binary", "python-dateutil", "oauth2client", "google-auth-httplib2", "google-auth-oauthlib", "google-api-python-client"))'' returned a non-zero code: 1

So added directive to install py_env:

https://github.com/BenioffOceanInitiative/ws-docker/blob/1bbcf5889c47c83e78b0a4fb8ba810e0aef54d26/rstudio-shiny/Dockerfile#L11

docker-compose up -d

SUCCESS!

https://tile.whalesafe.com/ image

bbest commented 1 year ago

tile layers

zones

https://tile.whalesafe.com/north_america.zones.html

image

rgns_h3

NOTE: This multi-resolution layer (more detailed hexagons at finer zoom levels) are best served via https://file.whalesafe.com/hex_tiles/{x}/(y}/{z}.pbf. Here they quickly hit limit when rendering all at once.

https://tile.whalesafe.com/north_america.rgns_h3.html

image