My next question is something like that, yes.
Currently, I'm using a MySQL database, within the context of a Ruby on
Rails app - however, the main issue that I've been struggling with is
how to store Twitter credentials in a secure manner that's still
usable. They need to be in plaintext(or something I can change into
plaintext), because there doesn't seem to be a way to communicate with
the Twitter API securely - which means storing them hashed is out of
the question.
Storing only the Base64 encoding was an option, but isn't any more
secure than storing plaintexts - anything encrypted can be decrypted.
As far as I'm aware, there aren't any SQL Injection
vulnerabilities(not doing any direct variable interpolation; the
framework apparently handles escaping when you use built-ins), and my
MySQL server only allows connections from certain trusted areas -
meaning your average outside attacker wouldn't be able to get access
without having access to the box first.
With that being said, I'm stuck - at the moment, because it's only on
my development system, I'm storing things plaintext - but I know that
if/when I deploy the app, if anyone other than myself decides to use
it I will need something much more secure than that.
If you've got any suggestions, please let me know!
Luke
On Jul 18, 3:43 pm, "Ed Finkler" <
funkat...@gmail.com> wrote:
> On Fri, Jul 18, 2008 at 3:14 PM, girasquid <
hybrid.ba...@gmail.com> wrote:
>
> > Yes - storing the data into a cookie, hashed or otherwise, doesn't
> > strike me as the best idea - but I'm not quite sure as to what would
> > be a better approach.
>
> > Do you know of one?
>
> Depends on how much responsibility you want to take on. If you're
> releasing source code for others to host, then you really don't have
> any. If you want to host this service yourself, you need to be
> prepared to take on the role of being steward for your user's private
> information, which is a significant responsibility. If you are
> confident in your ability to do so, then storing the data server-side
> in a secure manner is a decent option.
>
> If your next question is "how do I store the data securely," I can
> suggest some books and courses you could look into.
>
> --