Using OpenSSL and MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I need to get some data from a user via a secure form and then store it in a  
secure fashion in a MySQL database, as well as having the site admins able  
to retrieve that information securely through a browser.

I have an SSL certificate but I'm not sure how to use it.  The OpenSSL  
functions section in the PHP documentation isn't helping at all.

Does anyone know where I can find some reasonably straightforward examples  
or tutorials that might help me?

For once neither Google nor Google Groups is being particularly useful.


Re: Using OpenSSL and MySQL

This could help you:
I have no guarantees etc, because i never use SSL.

Re: Using OpenSSL and MySQL

Drakazz wrote:
Quoted text here. Click to load it

Thanks for that, but it's a guide for using OpenSSL from the command line to  
access MySQL, I really need to be able to do it from PHP.  

Re: Using OpenSSL and MySQL

Very sorry,

use MYSQL_CLIENT_SSL for configuring the connection.

As the documents:

resource mysql_connect ( [string server [, string username [, string
password [, bool new_link [, int client_flags]]]]] )

So you'd do something like this:
Not sure if it'll work as there are no examples, but have a go!
Good Luck!

Re: Using OpenSSL and MySQL

Drakazz wrote:
Quoted text here. Click to load it

Thanks, I really appreciate it, there's not much info out there (at least  
that I can find!).  

Site Timeline