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 Extension) 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 // The version number (9_5_0) should match version of the Chilkat extension used, omitting the micro-version number. // For example, if using Chilkat v9.5.0.48, then include as shown here: include("chilkat_9_5_0.php"); $chilkatGlob = new CkGlobal(); $success = $chilkatGlob->UnlockBundle('Anything for 30-day trial.'); if ($success != true) { print $chilkatGlob->lastErrorText() . "\n"; exit; } $tunnel = new CkSshTunnel(); $sshHostname = 'www.my-ssh-server.com'; $sshPort = 22; // Connect to an SSH server and establish the SSH tunnel: $success = $tunnel->Connect($sshHostname,$sshPort); if ($success != true) { 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 != true) { 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->put_DestPort(1433); $tunnel->put_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) { 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 = true; $success = $tunnel->StopAccepting($waitForThreadExit); if ($success != true) { print $tunnel->lastErrorText() . "\n"; exit; } // Close the SSH tunnel (would also kick any remaining connected clients). $success = $tunnel->CloseTunnel($waitForThreadExit); if ($success != true) { print $tunnel->lastErrorText() . "\n"; exit; } ?> |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.