Skip to content

Latest commit

 

History

History
79 lines (61 loc) · 1.91 KB

README.md

File metadata and controls

79 lines (61 loc) · 1.91 KB
Raw

Weather station

This is (almost) all of the code required to setup and run the weather station website at meteo.fiobbio.com.

Old: The main set of applications are now containerized and running using the Docker container engine. The long term goal is to have everything running inside a container, and to able to build the whole environment from this Git repository. Even better, use a k8s-like platform to manage all containers.

Update: All applications are not containerized and running in a kubernetes cluster! For simplicity the cluster is a local minikube instance created with the driver none (bare-metal).

Hardware

  • Davis Vantage Pro2
  • Vaisala WXT520
  • Cheap chinese webcam

Software

Base:

  • Ubuntu
  • Docker
  • minikube

Apps:

  • weewx
  • nginx
  • rclone -- automated backups to Backblaze B2
  • Prometheus / Grafana

Repository content

  • Websites front end
  • Automation bash scripts to run periodic actions, e.g. webcam snapshots generation and post-processing.
  • other misc configuration files

SSL Certificate

certbot certonly -d meteo.fiobbio.com --logs-dir /tmp --config-dir ~/secrets/letsencrypt --work-dir /tmp

Self-notes on SQLite

Config Update

$ sqlite3 .../wview-conf.sdb

select name,value from config where name="STATION_HOST";
STATION_HOST|ser2net-fiobbio1.default.svc.cluster.local

Or using wviewconfig in a container:

$ docker run -it --rm -v .../wview-conf.sdb:/etc/wview/wview-conf.sdb pullme/x86_64-wview:5.21.7
# wviewconfig

Removing bad database entries

Bad entries are normally caused by no record. That cause temperature (outTemp) to show as "-17.8 C" -- i.e. "0 F".

Show where there is no record for outTemp with:

select *, datetime (DATETIME(dateTime, 'unixepoch', 'localtime')), outTemp from archive where outTemp is null;

Delete:

delete from archive where outTemp is null;