|
|
Posted by Gordon Burditt on 11/05/05 18:57
>Thanks for that information, you see I have a open table that does not
>require SSL, anyone from the net can add data to it, however.
You let ANYONE log directly into your MySQL server? Wow! How much
porn, pirated software, stolen music, and stolen credit card numbers
have been added to it?
>I run a query
>from that table and return values which I want to post into a secure table
>on mySQL
MySQL has no concept of a 'secure table', but you can restrict access
to one to specific users.
>the issue is that when I do my select statement and try to connect
>to the database under the same username it returns a blank webpage using
>SSL.
How did you connect to MySQL using SSL? Show code. You didn't even
TRY that, did you? You just used a https page, which has got nothing
to do with using a SSL connection to MySQL. You should also, at
least for debugging, generate error messages if you can't connect
to MySQL or a query fails. Even for production use, if connecting
to the database fails, you should tell your user that things are
broken and to try again later.
Remember, just because you sent a package of weapons-grade plutonium
from Browserville to WebServerCity using armed guards and a fighter
plane escort doesn't mean the guy at WebServerCity didn't forward
it to MySQLTown using some kid with a wagon.
>What Im probably asking how do I run a query to my MySQL database using SSL.
To connect to MySQL with SSL, you need PHP 4.3.0 or later, and the
MySQL client library installed with it must be 4.* or later. The
distributed client library with PHP 4 is MySQL 3.23: not recent
enough. The same applies to Windows binaries of PHP 5. Functions
to actually specify SSL parameters don't seem to be available until
PHP 5 with the 'mysqli' driver.
You also need a MySQL server *compiled with SSL*.
Gordon L. Burditt
Navigation:
[Reply to this message]
|