Posts for March, 2011
March 20, 2011 Posted in Networking
While I was trying to setup OpenVPN as a proxy, I found that SSH tunneling is a much easier and more convenient solution. The configuration only takes a few minutes, and the client side can be configured to use the proxy or not on a program-by-program basis.
Add the following line in /etc/ssh/sshd_config
Configure Windows client
March 19, 2011 Posted in MySQL
I’m seeing messages like below in mysql error log on my new server:
110318 10:48:02 [Warning] IP address ‘x.x.x.x’ could not be resolved: no reverse address mapping.
I don’t need to access mysql remotely, it should be disabled for either performance or security. This can be changed by adding “skip-networking” in my.cnf, mysql will not listen on a TCP/IP port at all.
March 12, 2011 Posted in MySQL
Backup single database
# mysqldump -u root -p db_name | gzip > sql.gz
# gunzip < sql.gz | mysql -u root -p db_name
March 8, 2011 Posted in Security
This is for Windows client, please refer to this page for FreeBSD workstation.
Key Based Authentication, step by step
1. Download PuTTYgen (on Windows), generate private/public key pair.