Re: Connecting to remote db securely

OK, then I'll throw this back to the list - any other ideas how I can get to their data without compromising their DB? I thought maybe about asking them to set up a separate DB with just the table I need, and sync it to those table in their main db, but it has to be a solution that involves the least amount of work on their end or it won't happen. Thanks, -Lisi At 01:27 AM 11/25/02 -0800, Rasmus Lerdorf wrote:

Yup, only MySQL 4.0.x has SSL support. I suppose you could try to set up some sort of tunnel, but it might not be the most reliable thing in the world. On Mon, 25 Nov 2002, Lisi wrote: I checked with phpinfo() and this is what I got: PHP Version 4.2.2 mysql - Client API version 3.23.51 Is there any secure way to connect using these versions? I am on a virtual host so there's not much I can do about upgrading. Also, does it matter which versions the server I am connecting to are running? -Lisi At 12:22 AM 11/25/02 -0800, Rasmus Lerdorf wrote:

See php.net/mysql_connect The client_flags argument is the one you want, so you will need PHP 4.3 for it and MySQL 4.0.x. -Rasmus On Mon, 25 Nov 2002, Lisi wrote:

I didn't realize that, is this discussed in Paul DuBois' book? Or,

can you

point me to the function(s) on the mysql website I need to look at? Thanks, -Lisi At 12:09 AM 11/25/02 -0800, Rasmus Lerdorf wrote:

Which DB? MySQL supports encrypted connections. On Mon, 25 Nov 2002, Lisi wrote:

I am writing a content management section for a site that will use

as part

of the front page three small sub-sections from another site's home

page

(with their permission, of course). They are worried about giving us the password to their database,

where the

information is stored, because we are on a different server and

they are

afraid someone could steal the password since it's being passed un-encrypted by our web server when we try to retrieve the info. Is this something to worry about? Is there a way around this? They suggested using IFrames to display the static information from

their page,

but this doesn't work with Netscape - at least version 4.7. Any other ideas? TIA, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php