You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Jochen Kächelin <jk...@linux.amsjk.de> on 2002/11/17 04:38:57 UTC

[users@httpd] storing mysql-connection data

What is the most secure way to store mysql-username / mysql-password
data in xxx.inc.php files so that only one hosting-client can read
it with phps' file, include, require function?

-- 
Jochen Kaechelin


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Re: [users@httpd] storing mysql-connection data

Posted by Bob Ramsey <ro...@uiowa.edu>.
Make the file on the server readable only by whatever user apache runs as.

The permissions on the file would look something like this:

rw----------     apache    apache      mypasswords.php


This means that only the user called apache could read and write to the 
file, assuming that apache runs as the user called "apache."  I've seen it 
run as that or nobody.  For best security practices, it should run as a 
user:group that only does web serving, nothing more.

This means that if you need to modify the file you'll have to either login 
as apache or do an "su" to set the user to apache before modifying it.

I think that's the right way to do it anyway.

Bob


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Re: [users@httpd] storing mysql-connection data

Posted by Robert Andersson <ro...@profundis.nu>.
Tom Ray wrote:
> This would be more of a PHP or mySQL list question. Since mysql passes
> the information plain text and then encrypts the password to compare the
> encryption stored in the password field in the user table...

I could be wrong, but I'm pretty sure a MySQL client sends the password as
MD5 encrypted digest string which the server compares to enrypted password
in the user table.

Regards,
Robert Andersson


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Re: [users@httpd] storing mysql-connection data

Posted by Tom Ray <to...@blazestudios.com>.
This would be more of a PHP or mySQL list question. Since mysql passes 
the information plain text and then encrypts the password to compare the 
encryption stored in the password field in the user table...if you want 
secure you're going to need to pass the data over HTTPS

Jochen Kächelin wrote:

>What is the most secure way to store mysql-username / mysql-password
>data in xxx.inc.php files so that only one hosting-client can read
>it with phps' file, include, require function?
>
>  
>


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


RE: [users@httpd] storing mysql-connection data

Posted by Koen Vingerhoets <ko...@ubench.com>.
Place the inc in a locked dir.
That's to be done in MySQLAdmin :)

Met vriendelijke groet,

Koen Vingerhoets

***** UBench nv *****
http://www.ubench.com
____________________________________________
The information contained in this electronic mail message is privileged and
confidential,
and is intended only for use of the addressee. If you are not the intended
recipient, you
are hereby notified that any disclosure,reproduction, distribution or other
use of this
communication is strictly prohibited.

If you have received this communication in error, please notify the sender
by reply
transmission and delete the message without copying or disclosing it.


-----Original Message-----
From: Jochen Kächelin [mailto:jk@linux.amsjk.de]
Sent: 17 November 2002 04:39
To: users@httpd.apache.org
Subject: [users@httpd] storing mysql-connection data


What is the most secure way to store mysql-username / mysql-password
data in xxx.inc.php files so that only one hosting-client can read
it with phps' file, include, require function?

--
Jochen Kaechelin


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org





---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org