Hi,
+-From: "Benjamin L. May" <bl...@columbia.edu> --
|_Date: Tue, 1 May 2012 11:29:57 -0400 (EDT) ____
|
|I am attempting to do the following:
|My local hostname is nine.cpmc.columbia.edu
|The MySQL server to which I am attempting to connect is on
|gem.cumc.columbia.edu
|I am attempting to SSH through an intermediary server
|cait.cumc.columbia.edu.
|Here is my code snippet:
...
|
| String user = "blm14";
| //String host = "cait.cumc.columbia.edu";
| String rhost = "nine.cpmc.columbia.edu";
| String host = "cait.cumc.columbia.edu";
| int sshPort = 22, lport = 6666, rport = 3306;
| Session session = jsch.getSession(user, host, sshPort);
| session.setConfig(config);
| session.setHost(host);
| session.setPassword("<redacted>");
| session.connect();
| int assigned_port = session.setPortForwardingL(lport, rhost,
|rport);
| Class.forName("com.mysql.jdbc.Driver").newInstance();
| mysql = DriverManager.getConnection
| ("jdbc:mysql://gem.cumc.columbia.edu:" + lport +
| "/hiccc_clinicaltrials","blm14","<redacted>");
It seems to me that "rhost" should be "gem.cumc.columbia.edu", according to
your scenario. And also, you should refer to "127.0.0.1:"+assigned_port ;
int assigned_port = session.setPortForwardingL(0, rhost, rport);
Class.forName("com.mysql.jdbc.Driver").newInstance();
mysql = DriverManager.getConnection("jdbc:mysql://127.0.0.1:" +
assigned_port +
"/hiccc_clinicaltrials",
"blm14","<redacted>");
Sincerely,
--
Atsuhiko Yamanaka
JCraft,Inc.
1-14-20 HONCHO AOBA-KU,
SENDAI, MIYAGI 980-0014 Japan.
Tel +81-22-723-2150
Skype callto://jcraft/
Twitter: http://twitter.com/ymnk
Facebook: http://facebook.com/aymnk
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
JSch-users mailing list
JSch-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jsch-users
