Open range ports via ufw or iptables
For UFW
SMTP setting for Drupal, Django, and WordPress
Drupal, Django, and WordPress are using localhost as SMTP server by default. But there is a way to use another SMTP server to send email.
Correct way to move kvm vm
I have a problem to do live migration between two host computers via virt manager. It is a permission issue but I don’t have time to fig it out. It is not a big deal. It is ok to move KVM vms offline.
MariaDB/Mysql Timezone
By default, mysql timezone value is system. It causes Python application error. After changed timezone to UTC, problem is solved.
Using docker and zfs to create limited size mysql database
Idea: Docker is run mysql server. Mysql data is stored on zfs volume and set the quota by zfs utility. Assume zpool name is zpool-mysql and mount point is /mysqldata
Mysql quota for database using zfs on CentOS 7
Assume we have done Move mysql data folder to ZFS on CentOS 7.
Follow steps to create mysql database (run as root). (database files locate at /mysqldata)
移民信息
Visa Bulletin 绿卡进度: https://travel.state.gov/content/visas/en/law-and-policy/bulletin.html
Add static route on Mac OSX and Windows
Add static route on windows is very easy. Run command prompt as Administrator.
KVM access guest from outside host on CentOS
For default virbr0, it provides a way to help guest to access host (VM<–>host). But the guest cannot be accessed from outside host. But we can use the following commands to enable it temporally.
# iptables -D FORWARD -o virbr0 -j REJECT --reject-with icmp-port-unreachable
# iptables -D FORWARD -i virbr0 -j REJECT --reject-with icmp-port-unreachable
How to edit KVM VM profile which is created by virt-manager and add port-forwarding function?
Virt-manager hides some functions such as port-forwarding. We can edit the VM profile form terminal.