Connectivity... how ?

The_Chancer

OK - connecting to a SQL database.. how ?

Use the following...

mysql_pconnect( $db_host, $db_user, $db_pass )

correct ?
Well, it works fine... BUT place yourself behind a proxy server and a firewall, now how do you do it ?

Any clues ?

jweissig

Hi,

If you can't connect to the database on the specific port than you can't use php to do it. Can you tell me a little more information about your setup. Why are you going through a proxy/firewall?

Justin

The_Chancer

Unfortunately, the site is for internal company use only, as the data held by the system I have written is "valuable". All of us connect to the net through the proxy server, and all of our internet is filtered through an outside source firewall (our ISP I believe...) so even using a direct command in windows command line of :

ping microsoft.com

comes back with an error...

Just wondered if there was a way of getting PHP/MySQL to connect through a proxy..

acidbox

what kind of error? Microsoft doesn't answer ping requests due to DoS attacks... try Yahoo.com instead.

wigz01

Can you add your site as an exception within IE to get around this?

tools > internet options > connections > LAN settings > advanced

The_Chancer

Straying a little from the point unfortuantely.

The site is based on its own server with M$ SQL server on it. However I am working (in company time) for myself and need to access my MySQL database on a different server. Exceptions won't work, as the traffic needs to go out from the server at work to the server holding my own personal work. Get me so far ?

If I am connecting through a normal IE window, I can use the net, and connect to the database through its PHPMyAdmin front, and do what I want to do. However when I use normal PHP to get there from my server I can't, as it cannot "see" the remote server I am needing to connect to.
This is because it needs to go through the proxy server. There is no other way out to the internet than via this route. No dial-up modem setup can be installed.

To answer acidbox, I get "Unknown host yahoo.com" for ANY AND ALL domains.

For Wigz01, when I am stting up remote workstations to use the site, I am already using the exceptions area so that they are not affected by internet / network outages due to the proxy server messing up.

So my question is still the same, is there a way of making PHP use a proxy server so that a MySQL connection can see the outside world ?