I believe that so far we've missed the OP's point.

The database is on a different server than the webserver, behind a(nother) firewall.

Authenticating users from infromation stored in the database has been done before with modules to make it fairly trivial - once an initial connection is opened from Apache to the db in order to submit the requests. It is the opening of this initial connection that the poster is concerned about. he wants the intiial db connection somehow done without the id,password being stored on the webserver.

And the only ways I see around this are:

• to have an entry for every user in the table that defines who can connect to mySQL and what they can do in mySQL, as well as possibly another table handling the same stuff for the webserver. But this implies a separate process for setting up these users. OR
• That the ID,password for db connection is stored in an encrypted file (eg using gpg) and the Apache startup process requires you to enter a passphrase at startup, after which the id,passwd are held by processes in RAM and used as needed. (The Agent thing for OpenSSL that stores users keys in RAM for use by other processes might be worth looking at in thgis regard.) But, even after you figure out how to do this, this may be a cure worse than the disease.

--Bob Niederman, http://bob-n.com

---

---

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! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

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:
	&		&
	<		&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.