Enable ssl with letsencrypt

Let’s Encrypt is a free, automated, and open CA (Certificate Authority) and let’s make use of it to enable ssl access to web application serviced by nginx.

Compiling error installing lxml on ubuntu

A compiler error was observed during installing lxml on ubuntu the error looks something like: error: command ‘x86_64-linux-gnu-gcc’ failed with exit status 4, and it’s most likely caused by low memory.

Quickly share files with python SimpleHTTPServer

With python2 builtin SimpleHTTPServer (or http.server in python3), you can start an http service to easily and quickly share a directory with files, which is especially useful and convenient in LAN environments.

Nginx to share default http port

How to use nginx to proxy http request to default port (e.g. 80) to other processes running on different ports on the same server.

Expose localhost with pagekite.py

Pagekite.py is tool using reverse proxy to create a tunnel to your localhost which is then publicly accessible from outside your networks, and this is also known as localhost tunneling which is especially useful when you want to quickly test or access a local running web app behind NAT and firewall from outside of your networks and don’t want to go through the complicated processes such as: buying a cloud-based server like vps for dns configuration with public static ip, or deployment to cloud based instances like aws ec2, and etc.

Convert mysql to sqlite

A script to convert mysql to sqlite.

Insert into mysql with python dict

How to use python dict as data source for mysql insert-into statement.

Jenkins html publisher css issue

Noticed in latest jenkins build (e.g. 2.19.2), the css style of html report published by html-publisher-plugin is not working.

Python connect mysql with pymysql

PyMySQL is a pure-Python MySQL client library which allows you to easily connect to MySQL db and perform db operations in pythonic way.

How to reset mysql root password

How to reset mysql root password.