Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(PHP ActiveX) 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.
<?php // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Global') $chilkatGlob = new COM("Chilkat.Global"); $success = $chilkatGlob->UnlockBundle('Anything for 30-day trial.'); if ($success != 1) { print $chilkatGlob->LastErrorText . "\n"; exit; } // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.SshTunnel') $tunnel = new COM("Chilkat.SshTunnel"); $sshHostname = 'sftp.example.com'; $sshPort = 22; // Connect to an SSH server and establish the SSH tunnel: $success = $tunnel->Connect($sshHostname,$sshPort); if ($success != 1) { print $tunnel->LastErrorText . "\n"; exit; } // 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 != 1) { print $tunnel->LastErrorText . "\n"; exit; } // 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 != 1) { print $tunnel->LastErrorText . "\n"; exit; } // 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 = 1; $success = $tunnel->StopAccepting($waitForThreadExit); if ($success != 1) { print $tunnel->LastErrorText . "\n"; exit; } // Close the SSH tunnel (would also kick any remaining connected clients). $success = $tunnel->CloseTunnel($waitForThreadExit); if ($success != 1) { print $tunnel->LastErrorText . "\n"; exit; } ?> |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.