Secure MySQL database import and update process

Færdiggjort Opslået 5 år siden Betalt ved levering
Færdiggjort Betalt ved levering

I have a web server that hosts a MySQL database.

On a regular basis (possibly several times a day), I need to update this db with hundreds of records. However, I need the update process to be VERY difficult and/or very secure. Not sure if this makes sense, but I'm thinking something like this:

1) I FTP into the server using SSH and drop a pre-formatted CSV file in a specified directory.

2) the server has a CRON job running that scans for a new upload every 30 seconds or so.

3) The CSV is imported into the db.

4) A results text file report is left in place of the CSV.

I need to know that the database was not tampered with between actions. There needs to be some sort of verification process that checks the db before import, verifies that it matches the previous report, then imports the new CSV and produces a new verification ID.

I'm sure you can easily build me a nice import panel, but that's not what I want. I want VERY limited access. Part of the security of our process will be in the difficulty of actually accessing and writing to the db.

Right now, I can make a CSV, connect to the server with SFTP, drop the CSV in a directory. The rest is up to you.

Attached is a sample CSV file. It includes 3 columns - a bitcoin public key, a Coin ID, and the date of production. This is all the DB will contain, for now - it may be improved later with additional fields, but this is it for today.

So, every day, I generate a new batch of the bitcoin keys, and need to securely update the DB. I do NOT want the DB to be publicly accessible, and i do NOT want any records to change. This is a record of all the addresses I've generated, and it will not change. I will ADD to it, but the data will never be modified.

I can't give you live access to the server. You will have to setup your own test environment that we can use to demo the process. Then, you'll provide install instructions and copy of code to make it work.

Please let me know if you have any questions.

Programmering af database Linux MySQL PHP Software Arkitektur

Projekt ID: #17861322

Om projektet

14 bud Remote projekt Aktiv 5 år siden

Tildelt til:

web4x4

Hello! Let's work. I have experience in implementing similar tasks. I will make it with PHP and PDO. I'm new here (but not a beginner in my profession), so I'm ready to perform inexpensively, but at the same tim Flere

$120 USD in 3 dage
(89 bedømmelser)
6.4

14 freelancere byder i gennemsnit $257 timen for dette job

osmanbsd

I can do that for you in Perl. I will write a script which will process your file check if rows are valid and then insert into DB. Will checksum the mysql table and write checksum in a file Before execution it wi Flere

$333 USD in 3 dage
(144 bedømmelser)
7.4
ITPyramid85

hello,how are you. i read your bid carefully. i am C#, .Net expert and have full experience for 7 years. C#, .Net is my top skill and my interested skill. I can provide most quality and high fast. if you want to su Flere

$155 USD in 3 dage
(31 bedømmelser)
6.9
microwebtechs

reply please

$94 USD på 1 dag
(257 bedømmelser)
6.7
rehmatclick

Hi, Am Muhammad Ghaffar I have great experience in Database management and make more secure I have read you project details and I believe its very serious project and important for you I would like to work on this task Flere

$100 USD in 3 dage
(158 bedømmelser)
6.7
DaniilSpasov

Dear Sir. I am interested in your job. I am a web developer from Russia who is specialized in Word press,P H P,MEAN,React and so on.I’m applying for your project spec offer for remote working WordPress Developer to Flere

$155 USD in 3 dage
(16 bedømmelser)
6.0
manojmalviya93

As per your requirement, I have expertise in MySQL Database Migration. I can help you in that I have 5 years of experience in this domain and I have done this type of projects much time for my local and remote client.s Flere

$155 USD in 3 dage
(60 bedømmelser)
5.8
cma93

Hi, I'm an experienced web developer. I'm interested in your task and would like to do it. I don't need to ask anything else, your instructions are clear enough for me. I may ask something while working on it. I'm avai Flere

$250 USD in 3 dage
(31 bedømmelser)
5.3
barrima

Hi, how about a bash script that runs every X (30?) seconds that would verify the db hasn't been tampered, check fo the existence of the CSV file, import it and then create the report file. If you would like, I c Flere

$200 USD på 1 dag
(37 bedømmelser)
4.9
parmarnaharsingh

Hi, I have understand what you actully need i will help you out in this i have a very good experience in website development and design. having good skill in php skill php, html, css, mysqli, wordpress and also gr Flere

$222 USD in 3 dage
(57 bedømmelser)
5.3
wearefreelancer8

xReady To Help 24x7 MotionGraphics, Video Editor & FullStack Developer Thanks for taking the time to review my proposal! I’ve looked over my notes regarding your graphic design needs, and have created a proposal fo Flere

$100 USD in 10 dage
(3 bedømmelser)
2.3
huai99

Hi, I am a professional software engineer based in Singapore. I understand what you need and could provide you with the code and setup instructions. Just let me understand the structure of the report and I can find wa Flere

$1400 USD in 10 dage
(2 bedømmelser)
1.6