Posts for March, 2011

SSH Tunneling – Easy Secure Proxy

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

PermitTunnel yes

Configure Windows client

Disable Remote Access for MySQL

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.


MySQL Backup and Restore

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

How to Setup Key Based Authentication in SSH

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.
Read More