UtterAccess.com
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    
 
   
DKoehne
post Mar 16 2020, 01:45 PM
Post#1



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
 
isladogs
post Mar 16 2020, 02:41 PM
Post#2


UtterAccess VIP
Posts: 2,242
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    2nd April 2020 - 09:23 PM