Other articles

1. Ubuntu cloud image dhcp problem in proxmox

   When I create new qemu vm in proxmox, I prefer clone from a template becase this way is faster. The template comes from vm which I have booted once and made some modification. My pve is running on a n3350 mini pc, the performance is miserable when building a new …

   read more

2. Ubuntu cloud image NFS server problem

   I am using Ubuntu cloud image, version 20.04, in proxmox. But it seems the kernel in this image lack some kernel modules which are needed by the nfs-kernel-server package. To solve it, you can compile the kernel by yourself, or insmod to check, or use this script to download …

   read more

3. bootstrap ansible on windows 10

   • to be updated, I don't have time recently, I am reading libp2p source code and documentation lately.

   • set network connection profile, more at here

   • enable smb v2/v3 protocol, more at here
   • disable firewall, more at here, or you can only allow 445 port income from certain hosts. powershell Set-NetConnectionProfile …

   read more

4. SQL tips

   Last update: 2021-10-08

   Here are some tips that I hope somebody told me earlier:

   1. select from multiple tables implicitly means cross join, simple "join" also means cross join. The following two SQL queries both return cross join of Parts and Suppliers.

   select * from Parts, Suppliers
   select * from Parts join Suppliers …

   read more

5. Block ads using DNS on OpenWRT

   Recently I switched to OpenWRT as my gateway to the Internet. It has been a great pleasure. Stock firmware of routers just sucks. With OpenWRT, I can ssh into it, install packages, a nice web interface, the configuration makes sense, super smooth and quick, ad blocking, VPN, so on and …

   read more

6. How to install openwrt on redmi ac2100

   Redmi ac2100 is a pretty good router for home use, except that its rom is a "highly customized" openwrt which restrictions are too strict and I remember that several years ago xiaomi added some nasty "functionalities" into their router devices which can inject javascript int web pages users browse and …

   read more

7. What to do when ssh hangs in terminal

   I use ssh a lot. And I met this situation nearly every day: after waking laptop from sleep, I found that I didn't exit ssh connection before I close laptop lid, the ssh connection now hangs there.

   I know this escape sequence(~.) before, but sometimes I found it not working …

   read more

8. How to install ansible on ubuntu 20.04 server

   I am assuming your geo location is in China. Just copy-and-paste the following code into a bash script and execute it. It should work without any problem on a fresh installed ubuntu 20.04 server.

   #!/usr/bin/env bash
   
   apt install python3-pip
   
   pip config set global.index-url https://mirrors.aliyun …

   read more

9. How to get rid of "remote host key identification changed" for good

   First of all, this is violating security rules, but anyway, you can do it.

   Modify ~/.ssh/config like this:

   Host raspberrypi
           HostName localhost
           UserKnownHostsFile=/dev/null
           StrictHostKeyChecking=no
   

   When experimenting with vms and if you are destroying and re-build vms frequently, you might see this warning messages a lot, so …

   read more

Page 1 / 2 » ⇉