Welcome Guest, Not a member yet? Register   Sign In
SSH2 Tunnel with external MySql Connection

i need an external MySQL connection over ssh tunnel.

I have two servers. On server 1 ssh2 as php-module is installed.
On server 2 is the db i want to connect to.

My code on server 1 is:
PHP Code:
$connection ssh2_connect('www.server2.de''22');
       if (ssh2_auth_password($connection'user','pass')) {
           echo "Authentication Successful!\n";
       } else {
           die('Authentication Failed...');

       $tunnel ssh2_tunnel($connection''3308); 
Authentication Successful!
$tunnel is stream!

And now i want to connect to the external Db on server 2 with this options:
$db['dbold']['hostname'] = "";
$db['dbold']['port']     = 3308;
$db['dbold']['username'] = "xxxx";
$db['dbold']['password'] = "xxxx";
$db['dbold']['database'] = "migration";
$db['dbold']['dbdriver'] = 'mysqli';
$db['dbold']['dbprefix'] = '';
$db['dbold']['pconnect'] = TRUE;
$db['dbold']['db_debug'] = TRUE;
$db['dbold']['cache_on'] = FALSE;
$db['dbold']['cachedir'] = '';
$db['dbold']['char_set'] = 'utf8';
$db['dbold']['dbcollat'] = 'utf8_general_ci';
$db['dbold']['swap_pre'] = '';
$db['dbold']['autoinit'] = FALSE;
$db['dbold']['stricton'] = FALSE;

But this doesn't work.
CI says:
A Database Error Occurred
Unable to connect to your database server using the provided settings.
Filename: core/Loader.php
Line Number: 353

Does somebody has any idea?

(This post was last modified: 06-27-2017, 09:50 PM by skunkbad.)

i use auto ssh. Keeps the connection up permanently too, which is a bonus.

Theme © iAndrew 2016 - Forum software by © MyBB