My Notes
Books
Recently updated
Cloudflare
version: "3.9" services: tunnel: container_name: cloudflared-tunnel image: cloudflare/cloudflared restart: unless-stopped command: tunnel run environment: - TUNNEL_TOKEN=token................
Your URLS
version: '3.1' services: yourls: image: yourls restart: always ports: - 8080:80 volumes: - /home/sysadmin/yourls:/var/www/html environment: YOURLS_DB_PASS: dbpwd YOURLS_SITE: https://192.168.20.40:8080/ YOURLS_USER: osgadmin YOURLS_PASS: yourlspwd mysql:…
Paperless: ProtonMail Bridge
Source code: shenxn/protonmail-bridge-docker: ProtonMail IMAP/SMTP Bridge Docker container (github.com) Change to the Paperless docker directory sudo docker compose down sudo docker run --rm -it…
Changing VM disk size
Change the size in XoA. Run lsblk to check it is there. Boot to GParted and resize partition. Then sudo lvextend -l +100%FREE /dev/mapper/ubuntu--vg-ubuntu--lv…
Connecting Ubuntu Desktop 22.04 to a Meraki VPN
Add repository for installing network-manager-l2tp sudo add-apt-repository ppa:nm-l2tp/network-manager-l2tp sudo apt-get update Install network-manager-l2tp sudo apt-get install network-manager-l2tp sudo apt-get install network-manager-l2tp-gnome Configure the network…
Cisco Switch commands
Assign IP enable configure terminal interface vlan <No> ip address <IP> <Mask> no shutdown exit Remove IP enable configure terminal interface vlan <No> no…
Troubleshooting Docker
Check Environment Variables Inside the Container: sudo docker exec -it container-name env Review Logs: sudo docker logs container-name sudo docker-compose up -d && sudo…
Things learnt from Cheat Sheets
See examples here: Cheatsheets.xlsx
SumIf across multiple worksheets
How to SUMIF across multiple worksheet: sum-if-multiple-sheets.xlsx
Assigning a value based on how often that entry occurs
We are needing the Fee column to be auto populated as follows i.e. the First child in the family gets charged Fee1, 2nd Fee2…
Useful software & Services (free commercial and OpenSource)
Network Tools Tools & Utilities Programming CAD, Graphics & Modeling Video Editing Audio Other Services Free Assets Icons Pixybay: Images & Video Unsplace: Beautiful,…