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
|