Setting up a transparent proxy for a database

Question

Currently my setup is as follows :-

Database client/library <---------------------> Database

I'd like to have the following :-

Database client/library <---> Proxy <-------------> Database

I'm the admin on a linux machine and im able to write iptable rules, use 3rd party software such as transproxy if required etc.

I'm looking to be able to intercept the requests before sending it to the database and intercepting the responses before sending it back to the database client/library.

Thanks.

What database are you using? What do you want to do to the requests? — sciurus, Apr 26 '13 at 03:16
MySQL -- Id like to take in requests and make the same requests over SSL from the proxy. — , Apr 26 '13 at 04:02

score 0 · Answer 1 · answered Apr 26 '13 at 23:00

It looks like running

$ socat tcp-listen:$port,fork,reuse tcp-connect:$db_host:$port

on proxy box will do what you need. Add option "-v" to display/redirect/debug passing traffic. Socat is available in all major Linux distros, FreeBSD and also as Windows port. "man socat" will bring you some RTFMing for a whole evening about rich ability of this swiss army knife of proxying.

Setting up a transparent proxy for a database

1 Answers1