Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

MySQL Perl Password file

by JoeJaz (Monk)
on Mar 09, 2005 at 22:25 UTC ( [id://438079]=perlquestion: print w/replies, xml ) Need Help??

JoeJaz has asked for the wisdom of the Perl Monks concerning the following question:

HI, I am using Perl and CGI on a public server to access a MySQL database. I have my password and username for the MySQL database included at the top of each of my Perl scripts. The password file simply initializes two variables to my username and password. The include statements in my Perl scripts point to a file called something like security.pl in ~/ . However, I just discovered that, since the apache needs to have read access to that file, the file is forced to take read permissions for the apache user. Some other user on the system, if they know the name of my file, can create a Perl script which also includes my security.pl file and reads out the contents of the username and password variables. Obviously, this is not acceptable. Since MySQL / CGI websites are very common on the internet, there must be a way secure this security.pl file. I am wondering how most people store their MySQL username and passwords. Thank you for taking the time to read this. Have a nice day, Joe

Replies are listed 'Best First'.
Re: MySQL Perl Password file
by RazorbladeBidet (Friar) on Mar 09, 2005 at 22:56 UTC
    Others have asked similar questions.

    Try a Super Search using "password file database" or other combinations.

    Good luck!
    --------------
    It's sad that a family can be torn apart by such a such a simple thing as a pack of wild dogs
      Thanks for providing those links. They are very useful. I think I see one that will work for my case. Take care, Joe

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://438079]
Approved by Old_Gray_Bear
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (2)
As of 2024-04-25 07:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found