Zig

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

const std = @import("std");
const chilkat = @import("chilkat");

pub fn main(init: std.process.Init) !void {
    const alloc = init.arena.allocator();

    var success: bool = false;

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

    success = false;

    const tunnel = try chilkat.SshTunnel.init();
    defer tunnel.deinit();

    const ssh_hostname = "sftp.example.com";
    const ssh_port = 22;

    // Connect to an SSH server and establish the SSH tunnel:
    tunnel.connect(ssh_hostname, ssh_port) catch {
        std.debug.print("{s}\n", .{try tunnel.getLastErrorText(alloc)});
        return;
    };

    // Authenticate with the SSH server via a login/password
    // or with a public key.
    // This example demonstrates SSH password authentication.
    tunnel.authenticatePw("mySshLogin", "mySshPassword") catch {
        std.debug.print("{s}\n", .{try tunnel.getLastErrorText(alloc)});
        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.setDestPort(1433);
    tunnel.setDestHostname("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.
    const listen_port = 3316;
    tunnel.beginAccepting(listen_port) catch {
        std.debug.print("{s}\n", .{try tunnel.getLastErrorText(alloc)});
        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:
    const wait_for_thread_exit = true;
    tunnel.stopAccepting(wait_for_thread_exit) catch {
        std.debug.print("{s}\n", .{try tunnel.getLastErrorText(alloc)});
        return;
    };

    // Close the SSH tunnel (would also kick any remaining connected clients).
    tunnel.closeTunnel(wait_for_thread_exit) catch {
        std.debug.print("{s}\n", .{try tunnel.getLastErrorText(alloc)});
        return;
    };
}