Closed

Perl/MySQL Secure Database with multi user access

I need a VERY secure yet simple database where I (as the Admin) can FTP files to a newly created directory and then log into the Admin Area and create a user name and password for that directory so when a user clicks a URL they are prompted for a user name and password that I have assigned and they will have access to files in ONLY that directory.

I do NOT want the Admin Area to have any type of upload capabilities at all. I wiill be uploading PDF's via FTP outside the program to keep people from being able to hack and upload their own files. Only FTP so nothing should be chmod higher than 644 if possible since it is all Read Only on the end user,

I prefer Perl so IF it gets hacked I can see who it is based on FTP user name.

I mention this Hacking because PHP runs under apache and if someone hits it there is no way to tell which script has been compromised.

I am open to ideas but this must be very very simple to use on the user end... Click link, type user name and password and click any file in that directory to download. NO options to change log in names or password. Admin area is simple click Add New User, they it would prompt for user name and password and directory name to protect.. Once a user is added the Admin will have the option of changing the password or delete the user. That's it!!

NO 3rd Party scripts. Must be own code to help make more secure.

To clarify what I need and how the database and access will work:

The Admin (me) will log in and create a user and password and when this happens it should make a new directory on the SSL (HTTPS) main root directory in the httpsdocs folder (Plesk). Then I will FTP into that folder using the main account FTP and upload files into that directory. There will be maybe as many as 250-500 users at some point, all with different user names and password but NO ONE other than me will be uploading files and this will ALL be done via the main account FTP so I do not need any other FTP or upload application in the program.

The URL will be placed on the website something like domain.com/clientfiles then when end user clicks on link a box asking for user name and password and depending on that info it will take them to the proper folder so they can click on any file and download within their own directory.. NO uploading only downloading. When I upload files I need the file name to show as a link so they can save on local PC.

We can use apache/htaccess for the password authentication that is strong enough for this project.

Skills: MySQL, Perl

See more: secure files, protect database, mysql script php pdf, mysql read files, access delete, mysql php download upload, prompt upload, ftp add user, perl download script, perl change file, upload file multi, php file upload multi, hack apache, secure admin, mysql create database user, script download files ftp, php multi file download, hack ftp, hack mysql database download, link ftp access database, password protect php database, ftp mysql, mysql download upload, multi option, simple user access php

About the Employer:
( 1 review ) OKC, United States

Project ID: #4464670

12 freelancers are bidding on average $266 for this job

cmax4u

Greetings, Can write perl script that will creates a new user and password, creates appropriate user dir, saves apache/htaccess info into appropriate .htaccess At the script finish you will have username, password More

$126 USD in 3 days
(98 Reviews)
6.4
Mindon

Hello, Check the PMB please, Thanks,

$550 USD in 5 days
(73 Reviews)
6.3
srinichal

I can deliver the script in perl as I am an expert in the same

$315 USD in 8 days
(37 Reviews)
6.2
vctheguru

I have experience doing similar works. Please see private message for more details.

$262 USD in 5 days
(27 Reviews)
5.6
linuxsupport

I am a Linux and Perl expert, I have 12 years of experience, I have done many such projects for the companies I worked with. I am very advance user of Perl, I can write optimized and secure code. I will develop all More

$262 USD in 5 days
(15 Reviews)
4.5
luckie

i got few question on the ftp, hope you can answer to private message, thanks

$165 USD in 5 days
(22 Reviews)
4.4
tcrnicki

I have made a few similar solutions and all in Perl so I fully understand what you want to be done. But I must mention I see a few potential issues and have a also suggestion. All this in the personal message.

$199 USD in 4 days
(3 Reviews)
3.9
denep

Apache provides basic authentication capabilities using HTTP Basic Auth through mod_auth. Is that enough for your purposes or do you require a more complex solution? It seems to me using Apache's own authentication cap More

$165 USD in 7 days
(9 Reviews)
3.3
kskulkarni

Hello, I can do this well in PERL or PHP either. Apache running the scripts won't be a problem. Besides, even if we use PERL, apache will be running the scripts; just like in case of PHP. I assure you a secure, cus More

$440 USD in 5 days
(2 Reviews)
3.1
listmystuff

Hi I have ten+ years expertise with Perl/Mysql in a commercial environment. I understand the requirements and will be able to provi what you are after. Regards Rob Salmon

$154 USD in 3 days
(4 Reviews)
3.0
tsalmark

Hello. I have a 20 some odd years experience with linux systems administration in various web hosting environments and about the same developing many perl based system administration and web applications. See my PM for More

$99 USD in 4 days
(1 Review)
2.8
kiocjw

Interesting Project.

$220 USD in 3 days
(0 Reviews)
0.0
sujanon2it

Kia ora! [url removed, login to view] are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$386 USD in 14 days
(0 Reviews)
0.0