Secure FTP

[KJ4AJP]

I may not be using the proper search terms, but I haven't found any recent info on this. My webhost will be requiring FTPS starting next month. I'm not sure if Cumulus will support this, I'm currently v1.9.2 build 1024, I saw a message saying v1.9.1 did not support FTPS. I also saw a year 2010 message saying most ISPs would eventually require secure FTP connections, so I'm hoping the ability has been implemented in Cumulus and I'm just too dense to know what boxes to check in Configuration>Internet Settings.

Thanks for any info and guidance!
--
Roger

[mcrossley]

Cumulus does not currently support sftp, you will have to set up an external script(s) in order to use that protocol and get Cumulus to call them at the real time and web update intervals via the external programs settings.

[duke]

Not wishing to further increase Steve's work load. But, would it be out of the question for Cumulus to support SFTP in the future?

[steve]

See http://wiki.sandaysoft.com/a/SFTP for instructions on how to set it up to work with Cumulus.

[KJ4AJP]

Thanks Steve! I know "secure ftp" didn't return any results in the wiki, I thought I also tried "sftp" but I guess I didn't.

I'll give it a go and make a sheepish return if I flub it up...
--
Roger

[steve]

Note that there are (at least) two different secure FTP protocols, SFTP (SSH FTP) and FTPS (FTP over SSL). I believe WinSCP supports both, but you'll need to make sure you're using the correct one for your server.

[KJ4AJP]

WinSCP is installed and connecting via FTPS to my webhost. I haven't created the batch file yet, not really sure how/where that's done but I'm searching the forum using WinSCP as the search term. Of course if someone wants to jump in...

One thing that I'm trying to figure out and haven't got to is, if WinSCP is going to be doing the transfer, are the current "Web Site" settings in Cumulus deleted and the settings in External Programs used instead?
--
Roger

[steve]

if WinSCP is going to be doing the transfer, are the current "Web Site" settings in Cumulus deleted

Remove the ftp host name, then it knows it's not supposed to be doing the ftp, but will process all the files.

[yv1hx]

Dear KJ4AJP:

Our server uses SFTP since a while ago, so we take advantage of the "external programs" features available in Cumulus (Thanks Steve! ) to upload our data and web pages, here is a example of our scripts:

Realtime script: (filename: Realtime_Upload.txt)

Code: Select all

option batch abort
option confirm off
option transfer binary
option include "*.zip; */"
open youruser:yourpassword@your.secure.server
# change local folder
lcd "C:\Cumulus\"
# change remote folder
cd /yourremotefolder
put "realtime.txt" realtime.txt
exit

Web pages script: (filename: Webpages_Upload.txt)

Code: Select all

option batch abort
option confirm off
option transfer binary
option include "*.zip; */"
open youruser:yourpassword@your.secure.server
# change local folder
lcd "C:\Cumulus\web\"
# change remote folder
cd /yourremotefolder
put "index.htm" index.html
put "record.htm" record.html
put "thismonth.htm" thismonth.html
put "thisyear.htm" thisyear.html
put "today.htm" today.html
put "trends.htm" trends.html
put "yesterday.htm" yesterday.html
put "mobile.html" mobile.html
# change local folder
lcd "C:\Cumulus\web\images"
# change remote folder
cd /yourremotefolder/images
put "*.bmp"
put "*.png"
exit

Midnight script: (filename: SFTP_Midnight_Upload.bat)

Code: Select all

@echo off
title Automatic backup.
REM backups important all files in alternate unit
copy c:\cumulus\data\*.* G:\Cumulus_Data
copy c:\cumulus\web\*.htm G:\Cumulus_Data\web
copy c:\cumulus\*.ini G:\Cumulus_Data\
copy c:\cumulus\*.bat G:\Cumulus_Data\
copy c:\Cumulus\*.txt G:\Cumulus_Data\
REM Compress all data files for uploading to web server
C:\Cumulus\7za.exe u c:\cumulus\data\2012.zip c:\cumulus\data\*12log.txt
REM calls SFTP client to upload files
call C:\Cumulus\WinSCP.com "/script=SFTP_Midnight_Upload.bat"  "exit"

Midnight script: (filename: SFTP_Midnight_Upload.txt)

Code: Select all

option batch abort
option confirm off
option transfer binary
option include "*.zip; */"
open youruser:yourpassword@your.secure.server
# change local folder
lcd "C:\Cumulus\data\"
# change remote folder
cd /yourremotefolder
# sync all local files with remote, only upload changed files
synchronize remote "C:\Cumulus\data\"
option include "*.txt; */"
# uploads 'dayfile.txt'
put "C:\Cumulus\data\dayfile.txt"
exit

You also need to configure the "External programs" section in the Internet config page:

image.PNG

Just my 2 cents.