Re: [Dev] [DAS] Zoookeeper connection error when HBase datasource is added

2015-07-03 Thread Udara Liyanage
Hi Gokul,

Thanks that worked for me.

On Fri, Jul 3, 2015 at 2:52 PM, Gokul Balakrishnan  wrote:

> Hi Udara,
>
> The issue is that the datasource is attempting to connect to a zookeeper
> instance at localhost, at port 2818 which of course doesn't exist. Can you
> try setting the"hbase.zookeeper.quorum" and
> "hbase.zookeeper.property.clientPort" properties as well in the datasource
> config?
>
>  
> 
> hbase.master
> 10.100.7.80:16000
> 
> 
> hbase.zookeeper.quorum
> {zookeeper_node}
> 
> 
> hbase.zookeeper.property.clientPort
> {zookeeper_port, e.g. 2181}
> 
>  
>
> Thanks,
>
>
>
> On 3 July 2015 at 14:28, Udara Liyanage  wrote:
>
>> Hi,
>>
>> I get the below error when I added the following data source
>> to repository/conf/datasources/analytics-datasources.xml. Hbase is running
>> on 10.100.7.80
>>  
>> WSO2_ANALYTICS_RS_DB_HBASE
>> The datasource used for analytics file
>> system
>> 
>> jdbc/WSO2HBaseDB
>> 
>> 
>> 
>> 
>> hbase.master
>> 10.100.7.80:16000
>> 
>> 
>> 
>> 
>>
>>
>> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client
>> environment:zookeeper.version=3.4.5-1392090, built on 09/30/2012 17:52 GMT
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client environment:host.name=localhost
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client
>> environment:java.version=1.7.0_75 {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client environment:java.vendor=Oracle
>> Corporation {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client
>> environment:java.home=/usr/lib/jvm/jdk1.7.0_75/jre
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client
>> environment:java.class.path=/usr/lib/jvm/jdk1.7.0_75//lib/tools.jar:/tmp/wso2das-3.0.0-SNAPSHOT/bin/org.wso2.carbon.bootstrap-4.4.0.jar:/tmp/wso2das-3.0.0-SNAPSHOT/bin/tcpmon-1.0.jar:/tmp/wso2das-3.0.0-SNAPSHOT/bin/tomcat-juli-7.0.59.jar:/tmp/wso2das-3.0.0-SNAPSHOT/lib/commons-lang-2.6.0.wso2v1.jar
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client
>> environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client
>> environment:java.io.tmpdir=/tmp/wso2das-3.0.0-SNAPSHOT/tmp
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client environment:java.compiler=
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client environment:os.name=Linux
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client environment:os.arch=amd64
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client
>> environment:os.version=3.13.0-53-generic {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client environment:user.name=root
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client environment:user.home=/root
>> {org.apache.zookeeper.ZooKeeper}
>> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Client
>> environment:user.dir=/tmp/wso2das-3.0.0-SNAPSHOT
>> {org.apache.zookeeper.ZooKeeper}
>> *TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
>> {org.apache.zookeeper.ZooKeeper} -  Initiating client connection,
>> connectString=localhost:2181 sessionTimeout=18
>> watcher=hconnection-0x43fb37ae0x0, quorum=localhost:2181, baseZNode=/hbase
>> {org.apache.zookeeper.ZooKeeper}*
>> *TID: [-1] [] [2015-07-03 14:19:22,291]  INFO
>> {org.apache.zookeeper.ClientCnxn} -  Opening socket connection to server
>> localhost/127.0.0.1:2181 . Will not attempt to
>> authenticate using SASL (unknown error) {org.apache.zookeeper.ClientCnxn}*
>> *TID: [-1] [] [2015-07-03 14:19:22,296]  WARN
>> {org.apache.zookeeper.ClientCnxn} -  Session 0x0 for server null,
>> unexpected error, closing socket connection and attempting reconnect
>> {org.apache.zookeeper.C

Re: [Dev] [DAS] Zoookeeper connection error when HBase datasource is added

2015-07-03 Thread Gokul Balakrishnan
Hi Udara,

The issue is that the datasource is attempting to connect to a zookeeper
instance at localhost, at port 2818 which of course doesn't exist. Can you
try setting the"hbase.zookeeper.quorum" and
"hbase.zookeeper.property.clientPort" properties as well in the datasource
config?

 

hbase.master
10.100.7.80:16000


hbase.zookeeper.quorum
{zookeeper_node}


hbase.zookeeper.property.clientPort
{zookeeper_port, e.g. 2181}

 

Thanks,



On 3 July 2015 at 14:28, Udara Liyanage  wrote:

> Hi,
>
> I get the below error when I added the following data source
> to repository/conf/datasources/analytics-datasources.xml. Hbase is running
> on 10.100.7.80
>  
> WSO2_ANALYTICS_RS_DB_HBASE
> The datasource used for analytics file
> system
> 
> jdbc/WSO2HBaseDB
> 
> 
> 
> 
> hbase.master
> 10.100.7.80:16000
> 
> 
> 
> 
>
>
> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client
> environment:zookeeper.version=3.4.5-1392090, built on 09/30/2012 17:52 GMT
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client environment:host.name=localhost
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client
> environment:java.version=1.7.0_75 {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client environment:java.vendor=Oracle
> Corporation {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,276]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client
> environment:java.home=/usr/lib/jvm/jdk1.7.0_75/jre
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client
> environment:java.class.path=/usr/lib/jvm/jdk1.7.0_75//lib/tools.jar:/tmp/wso2das-3.0.0-SNAPSHOT/bin/org.wso2.carbon.bootstrap-4.4.0.jar:/tmp/wso2das-3.0.0-SNAPSHOT/bin/tcpmon-1.0.jar:/tmp/wso2das-3.0.0-SNAPSHOT/bin/tomcat-juli-7.0.59.jar:/tmp/wso2das-3.0.0-SNAPSHOT/lib/commons-lang-2.6.0.wso2v1.jar
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client
> environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client
> environment:java.io.tmpdir=/tmp/wso2das-3.0.0-SNAPSHOT/tmp
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client environment:java.compiler=
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client environment:os.name=Linux
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client environment:os.arch=amd64
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client
> environment:os.version=3.13.0-53-generic {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client environment:user.name=root
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client environment:user.home=/root
> {org.apache.zookeeper.ZooKeeper}
> TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Client
> environment:user.dir=/tmp/wso2das-3.0.0-SNAPSHOT
> {org.apache.zookeeper.ZooKeeper}
> *TID: [-1] [] [2015-07-03 14:19:22,277]  INFO
> {org.apache.zookeeper.ZooKeeper} -  Initiating client connection,
> connectString=localhost:2181 sessionTimeout=18
> watcher=hconnection-0x43fb37ae0x0, quorum=localhost:2181, baseZNode=/hbase
> {org.apache.zookeeper.ZooKeeper}*
> *TID: [-1] [] [2015-07-03 14:19:22,291]  INFO
> {org.apache.zookeeper.ClientCnxn} -  Opening socket connection to server
> localhost/127.0.0.1:2181 . Will not attempt to
> authenticate using SASL (unknown error) {org.apache.zookeeper.ClientCnxn}*
> *TID: [-1] [] [2015-07-03 14:19:22,296]  WARN
> {org.apache.zookeeper.ClientCnxn} -  Session 0x0 for server null,
> unexpected error, closing socket connection and attempting reconnect
> {org.apache.zookeeper.ClientCnxn}*
> *java.net.ConnectException: Connection refused*
> *at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)*
> *at
> sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:739)*
> *at
>