a customer asked me to set up an automatic backup system in which a machine transfer some important data (.sql dumps) via FTP. He doesn't want SFTP, only FTP.
So I ended up doing three things:
- I used FTPS protocol with TLS disabling SSLv2 & SSLv3
- I encrypted .sql dumps with gpg before transferring them
- I blacklisted every ip but the one of the backup machine so only that machine can connect to the ftps server
Now the transfer should be secure, even if not using SFTP. Before submitting my work, I would like to ask your opinion:
Are there other useful tips to be even more secure? Is this method enough secure for transferring sensitive data (excluding SFTP which is NOT an option)? I use "curl" to do the FTPS transfer and vsftpd for FTPS server.
Thanks
DrO