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
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 ?
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
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).