Re: [PHP-DB] Connect to MySQL through Proxy?

2001-08-06 Thread David Viner

Thanks all.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Connect to MySQL through Proxy?

2001-08-04 Thread John Lim

Hi,

The adodb database library has a wrapper to send queries using http.

See http://php.weblogs.com/adodb_csv

Regards, John

Stephane Felix [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Or write a mysql-http pipe... that shouldn't be very hard
 write a php script that would echo all data on the source side, and a php
 script that would fopen the url of the source server, and put everything
 into the database.

 Stéphane





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Connect to MySQL through Proxy?

2001-08-03 Thread Stephane Felix

Or write a mysql-http pipe... that shouldn't be very hard
write a php script that would echo all data on the source side, and a php
script that would fopen the url of the source server, and put everything
into the database.

Stéphane



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Connect to MySQL through Proxy?

2001-08-03 Thread Andreas D. Landmark

At 03.08.2001 13:36, David Viner wrote:
Does anyone know if it is possible to make a MySQL connection (using
mysql_connect or mysql_pconnect) through a proxy server? I need to be able
to synchronise from one server on an internal network through to one on the
web - doing it when a proxy is not involved is dead easy, but...

Thanks in advance for any tips/ideas on this.

This is strictly a MySQL issue and not a php issue, but to avoid being a 
oneliner,
I'm pretty sure that you can't do what you're hoping to do...

Proxyservers deal with http requests (usually 1.0 and 1.1), mysql uses it's 
own protocol
and has no means to communicate over http...

Get your sysadm to open or map some ports for you so you can use mysql 
native, otherwise
you'd have to do a dump and then import that on the other server, which 
would not be a
2-way sync...


-- 
Andreas D Landmark / noXtension
Real Time, adj.:
 Here and now, as opposed to fake time, which only occurs there
and then.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]