tags:

views:

99

answers:

1
Q: 

php - socks proxy

Hi,

For the past fifteen day I'm breaking my head to solve this issue. I have a PHP application which connects to a remote mysql server, but the application can't directly access the remote mysql server, it has to connect through a socks proxy. Please could anyone help me to solve this issue.

Thanks in advance.

A: 

I think you'll need to set up port forwarding through your SOCKS proxy. With this you open a local port (e.g. on 3306) which forwards connections to a remote host and port (databasehost:3306) through a SOCKS proxy. You run this in the background and make PHP connect to localhost:3306 (which will then be forwarded/tunneled to databasehost:3306)

schuilr  2010-08-31 16:46:39
How to do this? please could you help me?
Kaartz  2010-08-31 16:51:19
It would be a lot easier (and more secure) if you can set up a SSH connection to that machine and let SSH forward the port. Is that an option for you?
schuilr  2010-08-31 18:31:15
I have access to the mysql server, but I can't ssh into that server.
Kaartz  2010-08-31 19:19:50
Well I'm not really familiar with other tools than just plain old SSH to create (secure) tunnels but I guess you could try what is described here: http://blog.kagesenshi.org/2006/02/portforwarding-again-but-this-time.htmlI'm not sure who owns this proxy and over what kind of network you're doing this but be aware that your connection is not secure. Therefore it may be possible to intercept data including your mysql login credentials.
schuilr  2010-08-31 22:42:53

related questions

IDE suggestions: Eclipse IDE vs. Zend Studio ( confused )
MySQL/Apache Error in PHP MySQL query
Lightweight IDE for Linux
What PHP framework would you choose for a new application and why?
Why is my ternary expression not working?
How can I get at the matches when using preg_replace in PHP?
Mechanisms for tracking DB schema changes
Wordpress theme development offline tools
Using object property as default for method property
How can I get the authenticated user name under Apache using plain HTTP authentication and PHP?
Make XAMPP/Apache serve file outside of htdocs
How do you debug PHP scripts?
PHP Variables passed by value or by reference?
Best way to implement unit testing in PHP
Connect PHP to an AS/400
Best way to access Exchange using PHP?
PHP Session Security
How do I access a remote form in php?
What's the best way to generate a tag cloud from an array? (using h1 through h6 for sizing)
Apache/PHP: error_log per Virtual Host?
How do I track file downloads with apache/PHP
How would you access Object properties from within an object method?
Flat File Databases in PHP
Best way to allow plugins for a PHP application
Latest information on PHP upcoming releases