#!/fellow/monks.pl

I found this site which explained how you can authenticate Apache against a mySQL server. However, the problem I have with this example is that I still need to provide (on the webserver config) the username and password to connect to the database -- I don't want to do that.

What I'm trying to achieve, is for Apache to ask for a username and password (easy bit), but then to pass that username and password onto my perl code, which will then use the username and password within the DBI dsn connect string for access to the database.

I could go and write my own routine for this, but for the sake of security, I'd like to find a more elegant way of giving my users access to the database.

I'm not trying to be difficult. I'm thinking of security, and building the system to the point where the webserver is just a monkey, doing what it's told. It passes the request onto the database for execution, which is usually far behind at the backend, with no publically accessable address at all. Even if you manage to get onto the web server, you should not be able to get the username and password off any text file on the server -- that's what I'm trying to achieve.

Thank you kind monks..

#!/massyn.pl

Don't -- me without telling me why. If you asked a stupid question, I wouldn't down vote you.

In reply to Authenticating to mySQL through DBI on Apache? by Massyn

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.