Lazarus Pascal

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. Lazarus Pascal

program ChilkatDemo;

// Demonstrates using the Chilkat Pascal wrapper via the C bridge DLL.
// Builds as a console application under Lazarus (FPC) or Delphi.

{$IFDEF FPC}
  {$MODE DELPHI}
{$ENDIF}
{$APPTYPE CONSOLE}

uses
  {$IFDEF UNIX}
  cthreads,
  {$ENDIF}
  SysUtils,
  CkDllLoader,
  Chilkat.SshTunnel;

// ---------------------------------------------------------------------------

procedure RunDemo;
var
  success: Boolean;
  tunnel: TSshTunnel;
  sshHostname: string;
  sshPort: Integer;
  listenPort: Integer;
  waitForThreadExit: Boolean;

begin
  success := False;

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

  success := False;

  tunnel := TSshTunnel.Create;

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

  //  Connect to an SSH server and establish the SSH tunnel:
  success := tunnel.Connect(sshHostname,sshPort);
  if (success <> True) then
    begin
      WriteLn(tunnel.LastErrorText);
      Exit;
    end;

  //  Authenticate with the SSH server via a login/password
  //  or with a public key.  
  //  This example demonstrates SSH password authentication.
  success := tunnel.AuthenticatePw('mySshLogin','mySshPassword');
  if (success <> True) then
    begin
      WriteLn(tunnel.LastErrorText);
      Exit;
    end;

  //  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.
  listenPort := 3316;
  success := tunnel.BeginAccepting(listenPort);
  if (success <> True) then
    begin
      WriteLn(tunnel.LastErrorText);
      Exit;
    end;

  //  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 := tunnel.StopAccepting(waitForThreadExit);
  if (success <> True) then
    begin
      WriteLn(tunnel.LastErrorText);
      Exit;
    end;

  //  Close the SSH tunnel (would also kick any remaining connected clients).
  success := tunnel.CloseTunnel(waitForThreadExit);
  if (success <> True) then
    begin
      WriteLn(tunnel.LastErrorText);
      Exit;
    end;


  tunnel.Free;

end;

// ---------------------------------------------------------------------------

begin

  try
    RunDemo;
  except
    on E: Exception do
      WriteLn('Unhandled exception: ', E.ClassName, ': ', E.Message);
  end;

  WriteLn;
  {$IFDEF MSWINDOWS}
  WriteLn('Press Enter to exit...');
  ReadLn;
  {$ENDIF}
end.