Hello Jinhang,
thanks for your reply.
Until now I've never used or configured this file (tajo-site.xml).
So I have looked up here
(http://tajo.apache.org/docs/0.8.0/configuration/cluster_setup.html) what it's
all about.
So I used the following content and renamed the file tajo-site.xml.template
into tajo-site.xml.
<property>
<name>tajo.rootdir</name>
<value>hdfs://hostname:port/tajo</value>
</property>
<property>
<name>tajo.master.umbilical-rpc.address</name>
<value>hostname:26001</value>
</property>
<property>
<name>tajo.master.client-rpc.address</name>
<value>192.168.43.249:26002</value>
</property>
<property>
<name>tajo.catalog.client-rpc.address</name>
<value>hostname:26005</value>
</property>
I don't understand for this moment what settings or IP addresses should I
modify.
I do not understand it if and where I have to use localhost or the IP address
of your Mac.
Can you explain to me precisely which entry has what function?
Then I certainly understand what and how I need to change this entry.
I’ve tried following values for the name tajo.master.client-rpc.address
<value>localhost:26002</value> and <value>192.168.43.249:26002</value>. Both
doesn’t work because following exception:
christians-mbp:bin chris$ bash tsql
2014-08-13 21:38:01.219 java[18274:1903] Unable to load realm info from
SCDynamicStore
Exception in thread "main" com.google.protobuf.ServiceException: Giving up
after tries=2
at
org.apache.tajo.rpc.ServerCallable.withRetries(ServerCallable.java:102)
at
org.apache.tajo.client.TajoClient.getCurrentDatabase(TajoClient.java:206)
at org.apache.tajo.cli.TajoCli.<init>(TajoCli.java:229)
at org.apache.tajo.cli.TajoCli.main(TajoCli.java:633)
Caused by: java.io.IOException: Connect error to /192.168.43.249:26002 cause
java.net.ConnectException: Connection refused: /192.168.43.249:26002
at org.apache.tajo.rpc.NettyClientBase.init(NettyClientBase.java:68)
at
org.apache.tajo.rpc.BlockingRpcClient.<init>(BlockingRpcClient.java:81)
at
org.apache.tajo.rpc.RpcConnectionPool.makeConnection(RpcConnectionPool.java:66)
at
org.apache.tajo.rpc.RpcConnectionPool.getConnection(RpcConnectionPool.java:78)
at
org.apache.tajo.rpc.ServerCallable.withRetries(ServerCallable.java:93)
... 3 more
Caused by: java.net.ConnectException: Connection refused: /192.168.43.249:26002
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at
sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:739)
at
org.jboss.netty.channel.socket.nio.NioClientBoss.connect(NioClientBoss.java:150)
at
org.jboss.netty.channel.socket.nio.NioClientBoss.processSelectedKeys(NioClientBoss.java:105)
at
org.jboss.netty.channel.socket.nio.NioClientBoss.process(NioClientBoss.java:79)
at
org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:312)
at
org.jboss.netty.channel.socket.nio.NioClientBoss.run(NioClientBoss.java:42)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
OR
christians-mbp:bin chris$ bash tsql
2014-08-13 21:44:21.246 java[19242:1903] Unable to load realm info from
SCDynamicStore
Exception in thread "main" com.google.protobuf.ServiceException: Giving up
after tries=2
at
org.apache.tajo.rpc.ServerCallable.withRetries(ServerCallable.java:102)
at
org.apache.tajo.client.TajoClient.getCurrentDatabase(TajoClient.java:206)
at org.apache.tajo.cli.TajoCli.<init>(TajoCli.java:229)
at org.apache.tajo.cli.TajoCli.main(TajoCli.java:633)
Caused by: java.io.IOException: Connect error to localhost/127.0.0.1:26002
cause java.net.ConnectException: Connection refused: localhost/127.0.0.1:26002
at org.apache.tajo.rpc.NettyClientBase.init(NettyClientBase.java:68)
at
org.apache.tajo.rpc.BlockingRpcClient.<init>(BlockingRpcClient.java:81)
at
org.apache.tajo.rpc.RpcConnectionPool.makeConnection(RpcConnectionPool.java:66)
at
org.apache.tajo.rpc.RpcConnectionPool.getConnection(RpcConnectionPool.java:78)
at
org.apache.tajo.rpc.ServerCallable.withRetries(ServerCallable.java:93)
... 3 more
Caused by: java.net.ConnectException: Connection refused:
localhost/127.0.0.1:26002
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at
sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:739)
at
org.jboss.netty.channel.socket.nio.NioClientBoss.connect(NioClientBoss.java:150)
at
org.jboss.netty.channel.socket.nio.NioClientBoss.processSelectedKeys(NioClientBoss.java:105)
at
org.jboss.netty.channel.socket.nio.NioClientBoss.process(NioClientBoss.java:79)
at
org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:312)
at
org.jboss.netty.channel.socket.nio.NioClientBoss.run(NioClientBoss.java:42)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Thanks for your help.
Best regards,
Chris
Am 13.08.2014 um 20:45 schrieb Jinhang Choi <[email protected]>:
> Dear Christian,
>
>
> Would you mind to share your configuration (tajo-site.xml)?
>
> More specifically, the value of tajo.master.*-rpc.address: I suspect that
> hostname setup can be just 127.0.0.1 (or localhost).
>
> If my presumption is exactly your case, then change it to MacBook's ip
> address, such as 192.168.43.249.
>
> God bless you :)
>
>
> Sincerely,
> ----------------------------------------------
> Jinhang Choi, CTO.
> Linewalks Inc. Seoul 137-860, Korea
> Office: +82 70 7702 3043
> FAX: +82 2 2055 0612
>
>
> -----Original Message-----
> From: "Jose Alvarez Muguerza"<[email protected]>
> To: "[email protected]"<[email protected]>;
> Cc:
> Sent: 2014-08-13 (수) 23:07:27
> Subject: Re: Connect via JDBC to Tajo over Network
>
>
> Hi Christian, why don't you try with virtualized nodes (not Virtual machines)
> instead of a mix of devices?? I would suggest something like
> Docker(https://github.com/josealvarezmuguerza/docker-ubuntu-hadoop) or Mesos.
>
> hope it helps
> regards
>
>
> On Wed, Aug 13, 2014 at 11:00 AM, Hyunsik Choi <[email protected]> wrote:
> Hi Chris,
>
> You may use the same code in three environments, which are MacBook,
> Galaxy S2, and Lenovo. Now, I cannot find any clue of the problem from
> your description.
>
> The versions of all JVM were same?
>
> Warm regards,
> Hyunsik
>
> On Tue, Aug 12, 2014 at 8:25 PM, Christian Schwabe
> <[email protected]> wrote:
> > Hello guys,
> >
> > I have a problem that can be difficult to explain, but I'll try it.
> > To my configuration: I use Tajo in version 0.9.0-SNAPSHOT
> >
> > In my testing environment I use the following hardware:
> > -MacBook Pro (OSX 10.9.4)
> > -Samsung Galaxy S2 (GT-I9000)
> > -Lenovo T430 (Windows 7 x64)
> >
> > My idea is to make the Lenovo laptop a database connection using JDBC to my
> > MacBook.
> > As a hotspot serves my Samsung Galaxy S2.
> >
> > I am therefore confident that the connection between the laptops are
> > successfully connected because I see on the Lenovo Laptop the Web Interface
> > of Tajo under http://xxx.xxx.xxx.xxx:26080/ and /ping to my MacBook is
> > already possible.
> >
> > But now when I start the database connection on my Lenovo, I get the
> > following exception:
> > java.sql.SQLException: Invalid JDBC URI:
> > jdbc:tajo://192.168.43.249:26002/testing
> > at org.apache.tajo.jdbc.TajoConnection.<init>(TajoConnection.java:97)
> > at org.apache.tajo.jdbc.TajoDriver.connect(TajoDriver.java:55)
> >
> > I sincerely hope that this declaration is complete and understandable.
> >
> > If I use the connection string ("jdbc: tajo: //127.0.0.1:26002/testing") the
> > JDBC database connection start on my MacBook everything works fine.
> >
> > Does anyone have any ideas what could be the problem?
> >
> > Best regards,
> > Chris
>
>
>
> --
>
> Jose Alvarez Muguerza | Architect
> GLOBANT | AR: +54 11 4109 1700 ext. 15895 | US: +1 877 215 5230 ext. 15895 |
>
>
>
>
>
>
>
>
> Please consider the environment before printing this email
