RE: VBA Scripting Issue with Session Logging - Access Denied on Log File (But Log Is Created!)
Hi Martin,
I am using the .NET assembly with VBA example and it works!
BUT, my client I am coding this for is unable to upload files like I can, so I am trying to figure out why their PC setup is not the same as mine.
This is an Excel application with VBA programming, and as said, it is working for me!
They can use WinSCP GUI application ok for connecting to the host server and doing file transfers, so that probably is ok.
But got the bright idea to log the session (your VBA example does not show this!!)...and added the log file path+name to session properties...and that did put lots of logging info into my log file...
HOWEVER...the process fails to complete correctly, and it seems the logging tries to re-open the log file but it is already open, causing Access Denied (my guess anyway)...
Here is relevant part of log file...took out confidential info...email me if you want the whole thing...suggest trying it...as it failed when added to VBA code that otherwise is working...
VBA code added to your VBA example: ...variable holds the log path...
...log path is ok as it is writing log info to the log file...but then errors out...WHY???
log repeats this for a bit...then session is broken...
ALSO, would like to know how VBA can handle error check:
I am trying to figure out if my client's PC SFTP session opens ok and it does not do file upload as expected, etc. ...I have added progress messages into the script to try and debug code which I am not sharing with client, but is running on their machine (challenge)...but regardless, fails on my PC that works except after adding WinSCP session logging...which almost works, but has the access denied error during processing...that is in your camp I believe...let me know if you get it working on your side without that error.
Thanks!
Mark
mark@markfreeman.info
Chicago
I am using the .NET assembly with VBA example and it works!
BUT, my client I am coding this for is unable to upload files like I can, so I am trying to figure out why their PC setup is not the same as mine.
This is an Excel application with VBA programming, and as said, it is working for me!
They can use WinSCP GUI application ok for connecting to the host server and doing file transfers, so that probably is ok.
But got the bright idea to log the session (your VBA example does not show this!!)...and added the log file path+name to session properties...and that did put lots of logging info into my log file...
HOWEVER...the process fails to complete correctly, and it seems the logging tries to re-open the log file but it is already open, causing Access Denied (my guess anyway)...
Here is relevant part of log file...took out confidential info...email me if you want the whole thing...suggest trying it...as it failed when added to VBA code that otherwise is working...
VBA code added to your VBA example: ...variable holds the log path...
...log path is ok as it is writing log info to the log file...but then errors out...WHY???
'Enable session logging 'rEF: https://winscp.net/eng/docs/logging 'REF: https://winscp.net/eng/docs/library_session#sessionlogpath If SFTP_Session_Log_Path <> "" Then mySession.SessionLogPath = SFTP_Session_Log_Path mySession.DebugLogPath = SFTP_Session_Log_Path Else 'default to no logging mySession.SessionLogPath = "" mySession.DebugLogPath = "" End If
[2024-06-21 13:26:18.381] [0001] Output: [winscp> open "sftp://<login>:<host>:2222" -hostkey="ssh-rsa 4096 <fingerprint>" -privatekey="H:\3-CLIENTS\<path>client_4096.ppk" -timeout=15] [2024-06-21 13:26:18.381] [0001] Output: [Error occurred during logging. It's been turned off.] [2024-06-21 13:26:18.381] [0001] Output: [Can't open log file 'H:\3-CLIENTS\<log path>'. ] [2024-06-21 13:26:18.381] [0001] Output: [System Error. Code: 5. ] [2024-06-21 13:26:18.381] [0001] Output: [Access is denied] [2024-06-21 13:26:18.381] [0001] Output: [Searching for host...] [2024-06-21 13:26:18.381] [0001] Output: [Connecting to host...] [2024-06-21 13:26:18.381] [0001] Output: [Authenticating...] [2024-06-21 13:26:18.381] [0001] Output: [Using username "<user id>".] [2024-06-21 13:26:18.381] [0001] Output: [Authenticating with public key "<public key>".] [2024-06-21 13:26:18.442] [0001] Waiting for log update and dispatching events for 100 [2024-06-21 13:26:18.551] [0001] Waiting for log update and dispatching events for 200 [2024-06-21 13:26:18.756] [0001] Waiting for log update and dispatching events for 400 [2024-06-21 13:26:19.165] [0001] Waiting for log update and dispatching events for 800
ALSO, would like to know how VBA can handle error check:
transferResult.Check
I am trying to figure out if my client's PC SFTP session opens ok and it does not do file upload as expected, etc. ...I have added progress messages into the script to try and debug code which I am not sharing with client, but is running on their machine (challenge)...but regardless, fails on my PC that works except after adding WinSCP session logging...which almost works, but has the access denied error during processing...that is in your camp I believe...let me know if you get it working on your side without that error.
Thanks!
Mark
mark@markfreeman.info
Chicago
