(Objective-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 Objective-C Library Downloads MAC OS X (Cocoa) Libs iOS Libs

#import <CkoGlobal.h>
#import <CkoSshTunnel.h>
#import <NSString.h>

CkoGlobal *chilkatGlob = [[CkoGlobal alloc] init];
BOOL success = [chilkatGlob UnlockBundle: @"Anything for 30-day trial."];
if (success != YES) {
    NSLog(@"%@",chilkatGlob.LastErrorText);
    return;
}

CkoSshTunnel *tunnel = [[CkoSshTunnel alloc] init];

NSString *sshHostname = @"sftp.example.com";
int sshPort = 22;

// Connect to an SSH server and establish the SSH tunnel:
success = [tunnel Connect: sshHostname port: [NSNumber numberWithInt: sshPort]];
if (success != YES) {
    NSLog(@"%@",tunnel.LastErrorText);
    return;
}

// Authenticate with the SSH server via a login/password
// or with a public key.  
// This example demonstrates SSH password authentication.
success = [tunnel AuthenticatePw: @"mySshLogin" password: @"mySshPassword"];
if (success != YES) {
    NSLog(@"%@",tunnel.LastErrorText);
    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.
tunnel.DestPort = [NSNumber numberWithInt:1433];
tunnel.DestHostname = @"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.
int listenPort = 3316;
success = [tunnel BeginAccepting: [NSNumber numberWithInt: listenPort]];
if (success != YES) {
    NSLog(@"%@",tunnel.LastErrorText);
    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:
BOOL waitForThreadExit = YES;
success = [tunnel StopAccepting: waitForThreadExit];
if (success != YES) {
    NSLog(@"%@",tunnel.LastErrorText);
    return;
}

// Close the SSH tunnel (would also kick any remaining connected clients).
success = [tunnel CloseTunnel: waitForThreadExit];
if (success != YES) {
    NSLog(@"%@",tunnel.LastErrorText);
    return;
}