Greetings,

Really need ideas and feedback for my thinking below.

I have a problem where various people around me insist that Perl must be able to take an encrypted username and password and authenticate encrypted to our database.

Currently I have DBI/DBD::Oracle installed on Solaris boxes talking with Oracle 11g on Red Hat both of which are inside our firewall.

I am considering proposing I put our files containing database usernames and passwords in directories and files only accessible by the owner (500 for directories and 400 for files to prevent accidental modification).

I have been maintaining that the Perl process will read the files (encrypted or not) and generate username and password in memory in unencrypted form. Furthermore the unencrypted username and password are sent across our network in the clear.

Bottom line: is anyone aware of a way to use some form of encrypted authentication? Data encryption would be an awesome bonus. Does this require modules from CPAN other than DBI/DBD::Oracle?

Much thanks for the help,

Jim

In reply to How to Encrypt Authentication and Data to DB? by jimw54321

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.