Avatar of A A
A A
 asked on

unable to ftp to database

Hello experts

I have EC2 instance in AWs which act as VSFTPd (VPN) and Database as RDS I am able to upload files from ftp client File zilla to local partitionon ftp server   (home directory user) but is not inject into the database Rds . waiting for your kind advice regarding where could be issue and how to verify
LinuxFTPDatabasesAWSAWS RDS

Avatar of undefined
Last Comment
Kent Olsen

8/22/2022 - Mon
Kent Olsen

It sounds like it could be any of several things.  

The "root" folder in your FTP connection is your home, not allowing you to get to the database folders.
The FTP user doesn't have permissions to write to the database folders.
etc.

Start by examine the current folder after connecting and see if you can move to the database folder(s).

David Favor

1) I have EC2 instance in AWs which act as VSFTPd (VPN) and Database as RDS...

This will require some sort of glue (code) on your end as...

SFTP != RDS

Likely some sort code is required to somehow inject or transform some file into RDS.

So either SFTP is working or not... with no relationship to RDS...

2) I am able to upload files from ftp client File zilla to local partitionon ftp server   (home directory user)...

This means you'll root ssh into your instance, check your log files, diagnose + fix the SFTP problem

3) but is not inject into the database Rds . waiting for your kind advice regarding where could be issue and how to verify.

RDS == SQL

SFTP != RDS/SQL

First fix your SFTP problem.

Then you'll debug your RDS problem exactly the same...

Create a root ssh session, debug log files, fix problem with whatever code you're using to transform SFTP data files into RDS data... whatever this transformation process might mean...
Yujin Boby

You can't upload files to RDS. If you have a database backup, you need to restore it to RDS database. When you create RDS, you get a username and password. You need to connect to RDS using this user and pasword, then restore the backup.

How to restore depends on database type. Do you know what database server you run on RDS, if it MySQL or PostgreSQL ?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
A A

ASKER
HI Kent

   when connected as username1  I see / and uploads only
I find when I am connected to Ftp as username 1  it gives symbol  / and then Folder mapped inside FTP users  under name of every user and uploads
/ uploads so there is FTP root and inside it username1 and upload so  when connected as username1  I see / and uploads only
and as username2  I see / uploads  which is created inside FTP users then username2 then uploads
YUjin
Datbase is  MY SQL

David

I have ftp (vsftpd) and my ftp is working for uploading local files and Rds is my sql but file upoaded under ftp accounts is not uploaded to my sql  
ASKER CERTIFIED SOLUTION
Yujin Boby

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Kent Olsen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.