成蹊笔记

Latest — Jun 22, 2022

install docker via snap

install docker sudo snap install docker add permision for normal user Create and join the docker group. $ sudo addgroup --system docker $ sudo adduser $USER docker $ newgrp docker You will also need to disable and re-enable the docker snap if you added the group while it was running. $ sudo snap disable

More issues

remove a file from git history

It is straight forward to remove a file from the current commit or HEAD but if you want remove entirely from the repository’s history then you need to run couple of commands. It took some trial and error for me to find something that worked for me * Find out

Install AdGuard Home on Oracle Cloud

add the following address into the first place of bootstrap dns: # DNS setting -> bootstrap DNS server 169.254.169.254

MySql server on Docker

Start up mysql server with remote root access: docker run - name=mysql \ -e MYSQL_ROOT_HOST=% \ -e MYSQL_ROOT_PASSWORD =xxxx \ -p 3306:3306 \ -v /home/data/mysql:/var/lib/mysql \ -d mysql/mysql-server

SqlAlchemy tips

Regex search on Postgres # (all the codes are in flask-SqlAlchemy syntax) Book.query.filter(Book.name.op('~')('AUD$')).first()

DNS related

lookup record under mac nslookup google.com dscacheutil -q host -a name google.com Clear mac(big sur) dns cache sudo dscacheutil -flushcache; sudo killall -HUP mDNSResponder clear ios dns cache enter airplane mode for 15 seconds clear chrome dns cache chrome://net-internals/#dns clear safari dns cache (doesn’t

[转] using Portainer on Qnap

QNAP supports containers using its own Container Station, which is great to get some containers up and running fairly quick, but … That is why some people, like me, want to use another Docker GUI for managing the containers, one is Portainer. Using the Container Station, Portainer is quite simple to

修改 systemd service 的环境变量

修改 systemd service 的环境变量，可以通过 sudo systemctl status <service_name> 来找到 service file path. 然后修改环境变量： [Service] Environment=PATH=:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin: reload config 和重启 service sudo systemctl daemon-reload sudo systemctl restart

管理 https 证书：Certbot

今天在 github 看到一个 project 用 certbot 来管理证书，试用了下感觉还蛮简单的。主要有： * 开始的时候提供一个简版 nginx，安装完 certbot 会自动修改 nginx conf * 自动生成 /etc/cron.d/certbot，在 root 下面自动运行。 ps: Ubuntu Minimal 版本不带 cron，所以要额外 sudo apt install cron 安装全过程： 1. Install nginx: sudo apt update sudo apt install -y nginx certbot python3-certbot-nginx 2. Put

关闭 Ubuntu 20.04 Minimal 的 iptable 防火墙

在 Oracle Cloud 安装了 mysql DB，从其他机器怎么都连接不上去。查了很久，一点点的确认下面几个层次的问题： * mysql bind address：不是 127.0.0.1 * mysql user：不能指定 localhost * Ubuntu Firewalls：关闭 iptables * Oracle Cloud subnet security rules：开放内网 ip 端口最复杂的是 iptables，机器安装后就已经一大串规则，我手动添加了开放 3306 端口后并没有效果。搞到我查了很久，以为哪里还有一层防火墙。可以通过下面命令来清空所有规则： sudo iptables -F # 或者这个命令清空所有 groups iptables-save | awk '