X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Check Ssh Tunnel Status For Live Connection In Vba, Access 2010    
post Mar 16 2020, 01:45 PM

Posts: 1
Joined: 16-March 20

Hello. I am in need of finding a solution to the following problem: I am running a batch file to create a secure tunnel SSH in command line upon login via code. Once the tunnel is established, I want to check that connection. If that connection is "established" or live for that user, I want then to show a locked image icon that represents that user's live connection. Of course if it breaks for some reason, then it will show the opposite as unlocked or "not live" to throw an error message for the user to reconnect their tunnel session. I am wondering what the best practices are for interfacing with the CLI and maybe netstat to determine the status via the code. This will be on a network and should be scalable to set as many sessions as we like. The code has to identify the user (users are identified via login by user id's like abc001) and I am thinking the pc ipaddress and the port - meaning user 1 uses port 2021 tunnel established, user 2 uses port 2022 tunnel established, etc. they each have a separate session but the code is doing the same thing for each user on a different box to identify their live session. I have access front end that is portable and a mysql backend on a network. Thanks for any help on this.
Go to the top of the page
post Mar 16 2020, 02:41 PM

UtterAccess VIP
Posts: 2,393
Joined: 4-June 18
From: Somerset, UK

Crossposted at AWF together with an answer by @cheekybuddha

Colin (Mendip Data Systems)
Website, email
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    4th July 2020 - 09:02 PM