(C) SSH Tunnel for Database Connection (such as ADO, ODBC, JDBC, etc.)

Demonstrates how to create an SSH tunneling client in a background thread of your application. This makes it possible to SSH tunnel database connections without the need for separate software (such as PuTTY) to be running.

Chilkat C/C++ Library Downloads
MS Visual C/C++ Linux/CentOS C/C++ Alpine Linux C/C++ MAC OS X C/C++	armhf/aarch64 C/C++ C++ Builder iOS C/C++ Android C/C++	Solaris C/C++ MinGW C/C++

#include <C_CkGlobal.h>
#include <C_CkSshTunnel.h>

void ChilkatSample(void)
    {
    HCkGlobal chilkatGlob;
    BOOL success;
    HCkSshTunnel tunnel;
    const char *sshHostname;
    int sshPort;
    int listenPort;
    BOOL waitForThreadExit;

    chilkatGlob = CkGlobal_Create();
    success = CkGlobal_UnlockBundle(chilkatGlob,"Anything for 30-day trial.");
    if (success != TRUE) {
        printf("%s\n",CkGlobal_lastErrorText(chilkatGlob));
        CkGlobal_Dispose(chilkatGlob);
        return;
    }

    tunnel = CkSshTunnel_Create();

    sshHostname = "www.my-ssh-server.com";
    sshPort = 22;

    //  Connect to an SSH server and establish the SSH tunnel:
    success = CkSshTunnel_Connect(tunnel,sshHostname,sshPort);
    if (success != TRUE) {
        printf("%s\n",CkSshTunnel_lastErrorText(tunnel));
        CkGlobal_Dispose(chilkatGlob);
        CkSshTunnel_Dispose(tunnel);
        return;
    }

    //  Authenticate with the SSH server via a login/password
    //  or with a public key.
    //  This example demonstrates SSH password authentication.
    success = CkSshTunnel_AuthenticatePw(tunnel,"mySshLogin","mySshPassword");
    if (success != TRUE) {
        printf("%s\n",CkSshTunnel_lastErrorText(tunnel));
        CkGlobal_Dispose(chilkatGlob);
        CkSshTunnel_Dispose(tunnel);
        return;
    }

    //  The destination host/port is the database server.
    //  The DestHostname may be the domain name or
    //  IP address (in dotted decimal notation) of the database
    //  server.
    CkSshTunnel_putDestPort(tunnel,1433);
    CkSshTunnel_putDestHostname(tunnel,"myDbServer.com");

    //  Start accepting connections in a background thread.
    //  The SSH tunnels are autonomously run in a background
    //  thread.  There is one background thread for accepting
    //  connections, and another for managing the tunnel pool.
    listenPort = 3316;
    success = CkSshTunnel_BeginAccepting(tunnel,listenPort);
    if (success != TRUE) {
        printf("%s\n",CkSshTunnel_lastErrorText(tunnel));
        CkGlobal_Dispose(chilkatGlob);
        CkSshTunnel_Dispose(tunnel);
        return;
    }

    //  At this point the app may connect to the database server through
    //  the SSH tunnel.  The database connection string would
    //  use "localhost" for the hostname and 3316 for the port.
    //  We're not going to show the database coding here,
    //  because it can vary depending on the API you're using
    //  (ADO, ODBC, OLE DB, etc. )

    //  This is where the application's database code would go...

    //  Stop the background listen/accept thread:
    waitForThreadExit = TRUE;
    success = CkSshTunnel_StopAccepting(tunnel,waitForThreadExit);
    if (success != TRUE) {
        printf("%s\n",CkSshTunnel_lastErrorText(tunnel));
        CkGlobal_Dispose(chilkatGlob);
        CkSshTunnel_Dispose(tunnel);
        return;
    }

    //  Close the SSH tunnel (would also kick any remaining connected clients).
    success = CkSshTunnel_CloseTunnel(tunnel,waitForThreadExit);
    if (success != TRUE) {
        printf("%s\n",CkSshTunnel_lastErrorText(tunnel));
        CkGlobal_Dispose(chilkatGlob);
        CkSshTunnel_Dispose(tunnel);
        return;
    }



    CkGlobal_Dispose(chilkatGlob);
    CkSshTunnel_Dispose(tunnel);

    }