note 94246 added to class.pdo
| From: | prometheus at osu1 dot php dot net | Date: | Sun, 25 Oct 2009 07:37:13 +0000 |
| Subject: | note 94246 added to class.pdo | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-162041@lists.php.net to get a copy of this message | ||
Magaloman: Sorry for that but I say this is not a solution, nor a half parted. If someone accessed
the code (with code injection for example), all DB connect informations can walk into his hand,
it
s a simply var_dump() call. If we want to nobody know our DB connection info, its
more secure if we use ODBC connection aliases, without any workarounds or hacks. You just need to
pass an alias identifier then ODBC opens the connection in a bit securest way. To keep our passwords
in our hand is a main point of security - but we cannot keeping all of that.
- protect the site from XSS and injections, use strip_tags() and PDO::quote, with GPC off.
- protect our users password, use salted MD5 hashes.
- protect our DB connections, use ODBC aliases.
This is near to maximum, keep in mind that we cannot protect the DB communication, all others are
protectable.
So I said that to protect from XSS and from other types of injections is more important then where
we place out our DB connections - but if we choose to place out these informations I suppose that
use a real solution.
For example: I have a secret file and I create a folder-maze for hide that. Our mother or
grandma maybe loose within, but our brother know how to use the "find file"
function... this is equls to create an INI file for DB connect infos which can accessable by opening
a JSON file in a secret place which stores the path to INI, then I create a class to encapsulate
that JSON file path, then I create a function that hides that class, then I store that
functions name in a variable and called by that... its not a way, its a joke,
just our work going to hardest - then kiddie call
var_dump($myUberSecretDatabaseConnectionInformationArray)... :)
----
Server IP: 92.48.74.199
Probable Submitter: 89.132.188.252
----
Manual Page -- http://www.php.net/manual/en/class.pdo.php
Edit -- https://master.php.net/note/edit/94246
Del: integrated -- https://master.php.net/note/delete/94246/integrated
Del: useless -- https://master.php.net/note/delete/94246/useless
Del: bad code -- https://master.php.net/note/delete/94246/bad+code
Del: spam -- https://master.php.net/note/delete/94246/spam
Del: non-english -- https://master.php.net/note/delete/94246/non-english
Del: in docs -- https://master.php.net/note/delete/94246/in+docs
Del: other reasons-- https://master.php.net/note/delete/94246
Reject -- https://master.php.net/note/reject/94246
Search -- https://master.php.net/manage/user-notes.php