Link to home
Create AccountLog in
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
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

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

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...
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 ?
Avatar of A A
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
Avatar of Yujin Boby
Yujin Boby
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account