trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Birdsall <dave.birds...@esgyn.com>
Subject RE: What port to use for jdbcT4?
Date Wed, 02 Dec 2015 00:45:51 GMT
Hi Arvind,

Thanks for the tips. The trafci.sh on edev03 works.

I then did an sqstop, changed dcs-site.xml (just the dcs.master and
dcs.server ports; I found that changing the dcs.zookeeper ports caused
dcsstart to fail). Then I did an sqstart.

I then tried trafci.sh on edev03 (with the new port) and it works.

And then I tried trafci from Windows with the new port. And that works.

So I think your diagnosis is correct; it is a port blocking problem.

Thanks again,

Dave



-----Original Message-----
From: Arvind Narain [mailto:narain.arvind@gmail.com]
Sent: Tuesday, December 1, 2015 3:20 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: What port to use for jdbcT4?

Sorry for the delay Dave. You can get the port info from dcscheck also.
Could you test from edev3 itself (trafci.sh -h localhost:46372 - u xx -p
yy). Most probably some ports are blocked. Could u touch dcs-site.xml and
change dcs ports to be in the range 45000 - 46000 ?

-----Original Message-----
From: "Dave Birdsall" <dave.birdsall@esgyn.com>
Sent: ‎12/‎1/‎2015 2:47 PM
To: "dev@trafodion.incubator.apache.org"
<dev@trafodion.incubator.apache.org>
Subject: RE: What port to use for jdbcT4?

Hi,



I’m still struggling with this.



I found a dcs-site.xml file in $MY_SQROOT/sql/local_hadoop/dcs-2.0.0/conf.
Looking in that file, I guessed that the port for dcs.master.port was the
one to use. In my case, 46372. So I tried that.



I then installed Trafci as the instructions suggest.



Firing up Trafci on the laptop, though, I get the following result:





Welcome to Apache Trafodion Command Interface

Copyright (c) 2015 Apache Software Foundation



Host Name/IP Address: edev03.esgyn.local

User Name: usr

Password:





*** ERROR[29113] error while opening socket. Cause: Connection timed out:
connect



Host Name/IP Address: edev03.esgyn.local:46372



*** ERROR[29113] error while opening socket. Cause: Connection timed out:
connect



Host Name/IP Address:



I checked on the server side. Dcscheck does show a DcsMaster, DcsServer and
Mxosrvr running.

So, I’m guessing something is incorrect on my configuration on the laptop
side.



Any suggestions?



Thanks,



Dave



*From:* Dave Birdsall [mailto:dave.birdsall@esgyn.com]
*Sent:* Tuesday, December 1, 2015 10:58 AM
*To:* 'dev@trafodion.incubator.apache.org' <
dev@trafodion.incubator.apache.org>
*Subject:* What port to use for jdbcT4?



Hi,



I’m trying to set up trafci on my Windows laptop to communicate to a
Trafodion instance on a workstation.



The workstation instance uses install_local_hadoop with a non-default port
range (46200).



One of the things I need to do to configure the JDBC Type 4 driver on my
laptop is to edit the t4jdbc.properties file. I need to set the port number
for it.



I’m guessing the port number is some function of the port range (46200 +
??).



How do I determine what port number to use?



Thanks,



Dave

Mime
View raw message