OMG!
Thank you Martin, it's working now!
Thank you Martin, it's working now!
- yoku
Post a reply
Topic review
- martin
Did you try using an absolute path to the log file?
Also redirect even WinSCP output to your batch file log:
/log=C:\backup\AICBackup.log
Also redirect even WinSCP output to your batch file log:
"c:\backup\WinSCP\winscp.com" /command ... >>%logfile% 2>&1
- Guest
Also I tried to add
-certificate switch in open command, but always got an error msg like Unknown switch 'certificate'.
- yoku
Hi Martin,
Thanks a lot, it's a good starting point. At first, config was read out from registry. Now I exported settings to .ini and moved into WinSCP folder.
Also I exported pub hostkey with
The shown key is the same as the GUI shows before first connect e.g: https://winscp.net/eng/data/media/screenshots/unknown_hostkey.png
But scheduled task still doesn't work :( No log records for
I'll keep checking for the issue. Thanks
Thanks a lot, it's a good starting point. At first, config was read out from registry. Now I exported settings to .ini and moved into WinSCP folder.
. 2017-05-09 13:01:22.093 Configuration: c:\backup\WinSCP\WinSCP.ini
Also I exported pub hostkey with
ssh-keyXXXgen -l -f /etc/ssh/ssh_host_rsa_key.pub and put it in the command:
"c:\backup\WinSCP\winscp.com" /command "open sftp://root:root@server/ -hostkey=""ssh-rsa 2048 1g:f3:e2:bc:35:ff:19:2f:a6:6f:d1:82:e6:af:1c:9c""" "put c:\AIC_Backup\Archive\AIC_Backup.7z /data1/backup/AIC/AIC_Backup.7z" "exit" "/log=AICBackup.log" "/loglevel=1"
The shown key is the same as the GUI shows before first connect e.g: https://winscp.net/eng/data/media/screenshots/unknown_hostkey.png
But scheduled task still doesn't work :( No log records for
winscp command, just from .bat (>>%logfile% 2>&1). In attachment I uploaded the log when I run it with clicking on backup.bat. Do you see maybe anything wrong in it?
I'll keep checking for the issue. Thanks
- martin
If the batch file does not even execute WinSCP, it's not WinSCP question/problem.
If the actual problem is, that WinSCP is executed, but does not work, see
My script works fine when executed manually, but fails or hangs when run by Windows Scheduler, SSIS or other automation service. What am I doing wrong?
You are for sure missing the
https://winscp.net/eng/docs/scripting#hostkey
If the actual problem is, that WinSCP is executed, but does not work, see
My script works fine when executed manually, but fails or hangs when run by Windows Scheduler, SSIS or other automation service. What am I doing wrong?
You are for sure missing the
-hostkey switch, what is covered in the FAQ above and also here:
https://winscp.net/eng/docs/scripting#hostkey
- yoku
+ info:
If I try to run it from Task Scheduler, it runs but doesn't execute the
If I try to run it from Task Scheduler, it runs but doesn't execute the
winscp command. So it's working only if I double click on backup.bat.
- yoku
Scheduled upload doesn't work from .bat file, Win 2012 R2
Hi,
I have a .bat file with something like this:
Working cool, if I run it manually, but unfortunately scheduled task doesn't upload it. Archive is done, just WinSCP upload is not working. There is no log records for uploading (only if I run it by hand). Can anybody help me? Thanks
I have a .bat file with something like this:
@echo off
title Backup
SET logfile=C:\backup\Backup.log
echo ------------------------START Backup------------------------ >>%logfile% 2>&1
date /T >>%logfile% 2>&1
time /T >>%logfile% 2>&1
if not exist "C:\Backup" mkdir C:\Backup
if not exist "C:\Backup\Archive" mkdir C:\Backup\Archive
echo -----copy----- >>%logfile% 2>&1
xcopy C:\\design\* C:\Backup\design\* /y /s
del /F /Q c:\AIC_Backup\Archive\*
"c:\backup\7-Zip\7z" a -r C:\Backup\Archive\Backup.7z C:\AIC_Backup\*
echo errorlevel: %ERRORLEVEL%
IF %ERRORLEVEL% == 0 GOTO OK
echo.
echo !!! ERROR There was a problem during zip procedure. ErrorLevel = %ERRORLEVEL%
echo.
GOTO end
:OK
echo ------------------------Archive Done------------------------ >>%logfile% 2>&1
echo ------------------------Start Uploading------------------------ >>%logfile% 2>&1
"c:\Program Files (x86)\WinSCP\winscp.com" /command "open sftp://root:root@server/" "put c:\Backup\Archive\Backup.7z /data1/backup/Backup.7z" "exit" "/log=Backup.log" "/loglevel=1"
echo ------------------------Uploading Done------------------------ >>%logfile% 2>&1
:end
echo ------------------------Backup Done------------------------ >>%logfile% 2>&1
Working cool, if I run it manually, but unfortunately scheduled task doesn't upload it. Archive is done, just WinSCP upload is not working. There is no log records for uploading (only if I run it by hand). Can anybody help me? Thanks