Hi Heiner!
Thank you for the advice! Shortly after e-mailing the distribution group, I
fiddled around with my hostnames.
One thing that I changed was the String rhost to be “127.0.0.1” instead
of “webdev02”. This seemed to have done the trick.
I appreciate the great and prompt response,
Hector Rios
*From:* Heiner Westphal westp...@verit.de
*Sent:* January 15, 2013 5:08 PM
*To:* Hector Rios labeledlo...@gmail.com
*CC:* jsch-users@lists.sourceforge.net
*Subject:* Re: [JSch-users] Jsch Databases
Hello Hector,
the long waits sounds to me like a firewall dropping the packages.
The java code looks ok, AFAICS.
There are some obstacles to circumvent in the setup outside of jsch/ssh (I
assume the webserver is running linux):
- mysqld must allow tcp connections
check with e.g.
sudo netstat -nlp | grep 3306
- should give s.t. like
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1234/mysqld
or
sudo lsof -i:3306|grep LISTEN
- should return something similar to
mysqld 1234 mysql 10u IPv4 4649 0t0 TCP *:mysql (LISTEN)
- no firewall on web1.fisherdigital.org should block port 3306
try
sudo iptables --list
to see the firewall rules.
On windows use
netstat -n|find 3306
to see if mysql listens on a tcp port (maybe mysql does it always on
windows, I'm not sure).
Best regards,
Heiner
Am 15.01.2013 23:27, schrieb Hector Rios:
Hello! I have been playing around with Jsch to establish an SSH
connection to my remote server. I have followed numerous tutorials but
seem to be banging my head against the wall.
I am using Eclipse Juno Windows 7 64-bit.
I am trying to connect to my web server, and access MySQL through an
SSH tunnel. The MySQL application lives in the web-server.
Web Server: web1.fisherdigital.org
Web Server Port Used for SSH: 22
MySQL Port in the web-server: 3306 (default mysql port)
My IP: 173.X.X.X
My machine name is: webdev02
My Code looks as follows:
Connection conn = null;
JSch jsc = new JSch();
java.util.Properties config = new java.util.Properties();
config.put(**StrictHostKeyChecking, no);
String user = sshUserName;
String rhost =webdev02;
String host = web1.fisherdigital.org;
int sshPort = 22, lport = 2122, rport = 3306;
Session session = jsc.getSession(user, host, sshPort);
session.setConfig(config); session.setHost(host);
session.setPassword(**sshUserPassword);
session.connect();
int assigned_port = session.setPortForwardingL(**lport,
rhost, rport);
Class.forName(com.mysql.jdbc.**Driver).newInstance();
System.out.println(Attempting to connect);
conn = DriverManager.getConnection(**jdbc:mysql://
127.0.0.1: +
assigned_port + /schemaName, dbUser, dbUserPassword);
System.out.println(CONNECTED!**);
conn.close();
System.exit(1);
The issue is that whenever I use DriverManager.getConnection, it
outputs Attempting to connect then hangs.
Any pointers would be appreciated.
- Elm
--**--**
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_**122512http://p.sf.net/sfu/learnmore_122512
__**_
JSch-users mailing list
JSch-users@lists.sourceforge.**net JSch-users@lists.sourceforge.net
https://lists.sourceforge.net/**lists/listinfo/jsch-usershttps://lists.sourceforge.net/lists/listinfo/jsch-users
--
Dipl.Inform.
Heiner Westphal
Senior Software Engineer
verit Informationssysteme GmbH
Europaallee 10
67657 Kaiserslautern
E-Mail: heiner.westp...@verit.de
Telefon: +49 631 520 840 00
Telefax: +49 631 520 840 01
Web: http://www.verit.de/
Registergericht: Amtsgericht Kaiserslautern
Registernummer: HRB 3751
Geschäftsleitung: Claudia Könnecke, Torsten Stolpmann
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
JSch-users mailing list
JSch-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jsch-users
