I want to connect to my remote Mysql server through port forwarding. Unfortunately Hostso.com my hosting provider don’t have php_ssh2 installed on the server so I have to work through phpseclib library. So far I am able to do:
Connect to server using Net_SSH2
$ssh = new Net_SSH2(‘xx.xxx.xx.xx’);
if (!$ssh->login(‘user’, ‘password’)) {
exit(‘Login Failed’);
}
If I do
echo $ssh->exec(‘ls -la’);it fetches directory listing telling we are connected successfully.
if I run
echo $ssh->exec(‘echo “select * from table where company_id=\“15\”;” | mysql’);It triggers:
stdin: is not a tty ERROR 1045 (28000): Access denied for user ‘user’@‘localhost’ (using password: NO)
If I do
echo $ssh->exec(‘ssh -f -L 3307:localhost:3306 root@xx.xxx.xxx.xxx sleep 60 >> logfile’);It run forever and then resulting in no response error from the server.
Please help me to resolve this issue or else I am thinking to switch to HostMonster.com or Waxspace.com or Dollar2host.com … Please I need your support. I am in trouble.