I have a web site and I am trying to communicate with a PostgreSQL database which is sitting on my personal server (CentOS 7).
I have taken the following steps
- forwarded the ssh port on my server (after disabling password authentication)
- generated the ssh keys and placed them onto the web server
- setup the SSH2.so library on the webserver
- created the php script to establish the connection
These all work fine and my script is capable of making the connection to the ssh server
<?php
ini_set('display_startup_errors',1);
ini_set('display_errors',1);
error_reporting(-1);
$connection = ssh2_connect('xxx.xx.xx.xx', 22);
if (ssh2_auth_pubkey_file($connection, 'usname',
'./ssh_key.pub',
'./ssh_key', 'psword')) {
echo "Public Key Authentication Successful
";
} else {
die('Public Key Authentication Failed');
}
?>
So all this works but I am struggling to connect to the database on the server I've made the connection to, is there a different way of connecting to the database that works with an ssh connection?