Well, now, do I continue to post here or start another thread
Oh. I'll post here....
OK, so now I have found the Wiki for SFTP ……
SFTP
Many ISPs now only support Secure FTP due to the open, unsecure nature of standard FTP.
As Cumulus does not currently support Secure FTP an external application must be used
WINSCP can be used
…which I had already found as being one of the few out there (well, free ones, that is) that support SFTP and cater for automated file updates.
I had actually been using the dialogue which kept crashing randomly and the guy who wrote it has still been unable to determine why, despite me using four alternative debug versions and providing horrendous size logs.
I also used the bat/script approach using the “keepuptodate” command with a "filemask", (because I didn’t realise at the time that there was a single file command) which, unfortunately, synchs the whole directory and sub-directories first time, despite the fact that it shouldn’t. That hasn't been resolved either.
So then I discovered AutoVer and have been using that. It is a great little program and does all that I need. However, that crashes occasionally too. Worse, if it only is unable to connect for some reason it stops and doesn't retry.
So, now I have basically gone full circle and am trying to SFTP from Cumulus by invoking WinSCP. All I want to do is transmit the realtime.txt file (oh, and just create the Toolbox php file, not transmit it, so that I can get an email when sensor contact is lost).
The following script works well
option batch abort
option confirm off
open User:pass@server
put "localpath\realtime.txt" /remotepath
exit
change User:pass@server to your username, password and server name combination
change localpath\realtime.txt to the local path on your PC
change /remotepath to the remote path on the web server (as seen when you SFTP to the web site)
Save the commands in a text file, let's use the filename "C:\Cumulus\sftp-cmds.txt" as an example.
Well, my WinSCP is in its own sub-directory off the c: drive so I set something up like this in upreally.txt in the WinSCP folder…
# Automatically abort script on errors
option batch abort
# Disable overwrite confirmations that conflict with the previous
option confirm off
# Connect using a password
open sftp://userid:
password@ftp4.bravehost.com
# Change remote directory
cd /
# Change local directory
lcd c:\cumulus
# put file
put realtime.txt
# Exit WinSCP
Exit
And then…
Now create a batch file with the following contents:
winscp.com /script=c:\cumulus\sftp-cmds.txt
Save this batch file, let's use the file name "C:\cumulus\sftp.bat" as an example.
I created one called upreally.bat that looks like this…
echo off
winscp.com /script=c:\WinSCP\upreally.txt
After creating the batch file, configure Cumulus to call it at each web update interval (using the 'external program' settings on the Internet Settings screen). For this example, the external program would be set to "c:\cumulus\sftp.bat".
If you don't supply an ftp host name to Cumulus, it will create the updated web files locally but not attempt to ftp them itself.
So… as my bat and script files work from the command prompt, when I am in the WinSCP folder, I attempted the above.
However, it is a bit unclear…
First…. There are three “external program” settings. Which one do I use?
I tried each of the first two, using c:\WinSCP\upreally.bat and neither of them caused the realtime.txt file to be (S)FTP’d.
Second.. “ If you don't supply an ftp host name to Cumulus”… supplying it still didn’t cause the realtime.txt file to be (S)FTP’d
Am I missing something? Are there any other settings?
