Dart

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

See more SSH Tunnel Examples

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. Dart

import 'package:chilkat/chilkat.dart';

void main() {
  // This example assumes the Chilkat API to have been previously unlocked.
  // See Global Unlock Sample for sample code.

  final tunnel = CkSshTunnel();

  final sshHostname = 'sftp.example.com';
  final sshPort = 22;

  // Connect to an SSH server and establish the SSH tunnel:
  try {
    tunnel.connect(sshHostname, sshPort);
  } on ChilkatException catch (e) {
    print(e.lastErrorText);
    return;
  }

  // Authenticate with the SSH server via a login/password
  // or with a public key.  
  // This example demonstrates SSH password authentication.
  try {
    tunnel.authenticatePw('mySshLogin', 'mySshPassword');
  } on ChilkatException catch (e) {
    print(e.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 = 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.
  final listenPort = 3316;
  try {
    tunnel.beginAccepting(listenPort);
  } on ChilkatException catch (e) {
    print(e.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:
  final waitForThreadExit = true;
  try {
    tunnel.stopAccepting(waitForThreadExit);
  } on ChilkatException catch (e) {
    print(e.lastErrorText);
    return;
  }

  // Close the SSH tunnel (would also kick any remaining connected clients).
  try {
    tunnel.closeTunnel(waitForThreadExit);
  } on ChilkatException catch (e) {
    print(e.lastErrorText);
    return;
  }
}