weeheavy

🗺️ OSM - self host the entire planet 🌎 in ~30 minutes 🚀

TL;DR

mkdir osm
wget -O osm/planet.mbtiles https://hidrive.ionos.com/api/sharelink/download?id=SYEgScrRe
podman run -ti --rm -p 9000:9000 --name sms -v $(pwd)/osm/:/data/ registry.gitlab.com/markuman/sms:latest
firefox http://localhost:9000

If you're like me you have a dir like ~/Workspace/Github where all your git repos live. I often find myself making a change in a repo, getting side tracked and ending up in another repo, or off doing something else all together. After a while I end up with several repos with modifications. This script helps me pick up where I left off by checking the status of all my repos, instead of having to check each one individually.

Usage:

git-status [directory]

This will run git status on each repo under the directory specified. If called with no directory provided it will default to the current directory.

	# libssl1.1, the only missing mongodb dependency.
	# I prefer enable oldstable in case this get backport security patches
	echo "deb http://deb.debian.org/debian bullseye main" \| sudo tee /etc/apt/sources.list.d/oldstable-bullseye.list

	# MongoDB 4.4, [end of life Feb 2024](https://www.mongodb.com/support-policy/lifecycles)
	curl -fsSL https://pgp.mongodb.com/server-4.4.asc \| sudo gpg -o /usr/share/keyrings/mongodb-server-4.4.gpg --dearmor
	echo "deb [ signed-by=/usr/share/keyrings/mongodb-server-4.4.gpg ] http://repo.mongodb.org/apt/debian buster/mongodb-org/4.4 main" \| sudo tee /etc/apt/sources.list.d/mongodb-org-4.4.list
	sudo apt-get update && sudo apt-get install mongodb-org-server -y

	# Unifi

	# this requires that MySQL is accessed through TCP/IP, not the unix socket.

	# run tcpdump for 30 seconds capturing traffic on port 3306
	timeout 30 tcpdump -s 65535 -x -nn -q -tttt -i any port 3306 > mysql.tcp.txt

	# run pt-query-digest on collected file
	pt-query-digest --type tcpdump mysql.tcp.txt >pt.out