Securing MySQL traffic with stunnel

To encrypt a connection between a mysql client and a mysql server, run two instances of stunnel, one on client site and other on MySQL remote site

Here’s steps how to do it

# wget http://www.stunnel.org/download/stunnel/src/stunnel-4.27.tar.gz
# rpmbuild -ta stunnel-4.27.tar.gz
# rpm -ivh /usr/src/redhat/RPMS/stunnel-4.27-1.i386.rpm

Create stunnel.pem cert on server site

# openssl genrsa -out privkey.pem 2048
# openssl req -new -x509 -key privkey.pem -out cacert.pem -days 1095
# cat privkey.pem cacert.pem >> /etc/stunnel/stunnel.pem

Set the proper permissions on the resulting private key:

# chmod 0400 /etc/stunnel/stunnel.pem

Set the proper ownership of the stunnel chroot dir

# chown nobody:nobody /var/run/stunnel

centos 5 point to point tunneling PPTP VPN

Pernah terpikir buat ngeremote pc di kantor(dengan private ip) dari rumah dengan koneksi isp yg kita pakai?   salah satunya dengapn cara tunneling/vpn. kali yg jadi korban kita distro centos 5 dengan kernel 2.6.18-92.1.13.el5. gimana cara installnya?

pertama install yum repository nya

# rpm -Uvh http://pptpclient.sourceforge.net/yum/stable/fc6/pptp-release-current.noarch.rpm

lanjut dengan install pptpnya

# yum --enablerepo=pptp-stable install pptp