UniFi Dream Machine: list dhcp leases

tl;dr: /mnt/data/udapi-config/dnsmasq.lease

So I just went on an excursion trying to find all dhcp leases dhcpd on our new UDM had handed out.

Reason: anything behind unmanaged switches behind an AP serving as bridge will not show up in the clients overview in the controller, while being perfectly functional.

Following the official guide to validate static assignments doesn’t work for dream machines – and logging into the USG to run show dhcp leases will simply tell you that show isn’t a command found in its lingo. This is exacerbated by the fact that it’s actually impossible to log in to the UDM as a regular user (ie the user configured through the controller (after enabling advanced features and SSH authentication subsequently)), and you’ll have to login as root with your regular controller password as documented in the getting started guide.

On the brighter side, the controller will show static configurations in the clients dashboard, once you select the “All configured clients” filter.

cat /mnt/data/udapi-config/dnsmasq.lease

To show current dhcp leases.

Chris Guillebeau: The Art of Non‑Conformity

This was marked unread on my kindle, but upon reopening I realized I’d read it before (but apparently a ~decade ago), so I decided to re-read it, since it’s short 🙂

Still a good read – while it didn’t necessarily age well on the storytelling side, the overall narrative still feels pretty spot on. Certainly worth reading, inspiring, full of beautiful quotes.

Chris Guillebeau – The Art of Non-Conformity

Patrick Lencioni: The Advantage: Why Organizational Health Trumps Everything Else In Business

One of the books that resonate well with my own experience gained over the years, around the importance of clarity, cohesion, communication and psychological safety making organizations truly great.

Worth the read, but better starting with the “Checklist for Organizational Health (all the way at the end of the book) and then diving into the specific chapters to learn more.

Still has too many words compared to the core message 🙂

Patrick Lencioni – The Advantage

COVID-19: daily heatmap

Thanks to the awesome work of Daniel Probst, collecting per canton data and publishing it on https://github.com/daenuprobst/covid19-cases-switzerland, I was able to pull this quick heatmap together, showing latest (ie daily) confirmed cases of COVID-19 in Switzerland, updated constantly (whenever source data changes).

note: unreported cantonal data is backfilled from the previous day

(previous post on this topic: https://www.musings.ch/2020/03/13/covid-19-heatmap-schweiz/)

And since heatmaps over broad areas are not necessarily useful, here’s a map of cantons affected.

COVID-19: lagging indicator of protectionism/lockdowns

On 2020-03-15, when I checked IATA’s travel advisories, it totaled 17 matches for “Switzerland”. Today:

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      29

This includes 3 matches for the Switzerland section alone… but still.

Update: 2020-03-19

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      46

Update: 2020-03-20

curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      56

Update: 2020-03-21

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      57

Update: 2020-03-22

curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      70

Update: 2020-03-23

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      73

Update: 2020-03-24

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-03-25

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      66

Update: 2020-03-26

curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-03-27

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      64

Update: 2020-03-28

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-03-29

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-03-30

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-03-31

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-01

curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-02

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      64

Update: 2020-04-03

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      64

Update: 2020-04-04

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      63

Update: 2020-04-05

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-06

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-07

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-08

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-09

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      62

Update: 2020-04-10

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      60

Update: 2020-04-11

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-04-12

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-04-13

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      68

Update: 2020-04-14

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      68

Update: 2020-04-15

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      69

Update: 2020-04-16

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      68

Update: 2020-04-17

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      64

Update: 2020-04-18

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      64

Update: 2020-04-19

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      64

Update: 2020-04-20

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      64

Update: 2020-04-21

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      64

Update: 2020-04-22

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-23

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-24

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      65

Update: 2020-04-25

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      66

Update: 2020-04-26

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      66

Update: 2020-04-27

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      66

Update: 2020-04-28

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      66

Update: 2020-04-29

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-04-30

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-05-01

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Update: 2020-05-02

$ curl -s https://www.iatatravelcentre.com/international-travel-document-news/1580226297.htm | grep -o Switzerland | wc -l
      67

Schweiz: Kantonsmittelpunkte

Die Latitude und Longitude der Kantonsmittelpunkte der Schweiz, als .csv:

Aargau, 47.409703, 8.154694                       
Appenzell-Ausserrhoden, 47.366352, 9.36791        
Appenzell-Innerrhoden, 47.317264, 9.416754        
Basel-Landschaft, 47.45176, 7.702414              
Basel-Stadt, 47.564869, 7.615259                  
Bern, 46.823608, 7.636667                         
Fribourg, 46.718391, 7.074008                     
Geneva, 46.220528, 6.132935
Glarus, 46.981042, 9.065751
Graubünden, 46.656248, 9.628198
Jura, 47.350744, 7.156107
Luzern, 47.067763, 8.1102                         
Neuchatel, 46.995534, 6.780126                    
Nidwalden, 46.926755, 8.405302                    
Obwalden, 46.854527, 8.244317                     
Schaffhausen, 47.71357, 8.59167                   
Schwyz, 47.061787, 8.756585
Solothurn, 47.304135, 7.639388                    
St-Gallen, 47.2332, 9.274744                      
Thurgau, 47.568715, 9.091957                      
Ticino, 46.295617, 8.808924                       
Uri, 46.771849, 8.628586
Valais, 46.209567, 7.604659
Vaud, 46.570091, 6.657809
Zug, 47.157296, 8.537294
Zurich, 47.41275, 8.65508

Quellen: https://de.wikipedia.org/wiki/Mittelpunkt_der_Schweiz#Kantonsmittelpunkte und https://tools.wmflabs.org/

COVID-19: Heatmap Schweiz

Since I was playing with Google Maps API heatmaps recently, I thought I’d put together a quick heatmap showing confirmed COVID-19 cases in Switzerland.

COVID-19 cases per 100k inhabitants, in Switzerland, as of 2020-03-19.

Updated 19.03.2020 using https://www.bag.admin.ch/dam/bag/de/dokumente/mt/k-und-i/aktuelle-ausbrueche-pandemien/2019-nCoV/covid-19-lagebericht.pdf.download.pdf/COVID-19_Epidemiologische_Lage_Schweiz.pdf – now based on incidence of cases per 100k inhabitants.

Day to day developments:

2020-03-14:

COVID-19 heatmap Switzerland 2020-03-14

Updated 14.03.2020 using https://www.bag.admin.ch/dam/bag/de/dokumente/mt/k-und-i/aktuelle-ausbrueche-pandemien/2019-nCoV/covid-19-lagebericht.pdf.download.pdf/COVID-19_Epidemiologische_Lage_Schweiz.pdf

2020-03-13:

COVID-19 heatmap Switzerland 2020-03-13

Data source: https://www.bag.admin.ch/bag/de/home/krankheiten/ausbrueche-epidemien-pandemien/aktuelle-ausbrueche-epidemien/novel-cov/situation-schweiz-und-international.html#-1934206868

13.03.2020 – BR: Coronavirus (COVID-19) und Zeitmaschinen

Ich war ja schon immer ein grosser Anhänger der Zeitmaschinen Frage. Die Antwort wäre sicherlich, dass man, wenn man eine Zeitmaschine hätte, die arme Fledermaus davon bewahren würde, gefangen zu werden.

Aber leider wissen wir ja alle auch, dass, wenn jemand jemals eine Zeitmaschine erfinden würde, wir dies bereits wüssten, und die Frage somit hinfällig wäre 🙂