[PHOENIX-5378] We are looking for a solution to connect to our Apache phoenix cluster from a node.js external IP.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.7.0
• Fix Version/s: 4.7.0
• Labels: Phoenix nodejs zookeeper
• Flags: Patch
• Assignee: Unassigned
• Reporter: Ahmed
• Created: 27/Jun/19 10:16
• Updated: 27/Jun/19 10:16

Description

We are able to connect internally to Apache Phoenix using node.js from the internal cluster that contains more than 30 Virtual machines. We are now trying to connect from my local node.js backend to Apache Phoenix and extract the data.

We did the following:

• Imported the configuration files "Hbase-site.xml" and "core-site.xml" and "hdfs-site.xml" from the server,

• We added a line to read those files like the following:

jinst.setupClasspath([

'/usr/local/HBase/lib/phoenix-4.7.0.2.6.4.0-91-client.jar',

'./hdp'

])

}

• Changed the internal IP address to the external IP address of the Zookeeper server like the following: url: 'jdbc:phoenix:<external_IP>:2181:/hbase-unsecure'

We start the node.js backend, the connection with the main Zookeeer has been established ,but it is enable to establish connection with some of the one of the nodes with the following error:
2019-06-26 13:09:06,153 INFO [hconnection-0xea4a92b-shared--pool1-t1] client.RpcRetryingCaller: Call exception, tries=10, retries=35, started=166981 ms ago, cancelled=false, msg=10000 millis timeout while waiting for channel to be ready for connect. ch : java.nio.channels.SocketChannel[connection-pending remote=namenode/10.0.0.4:16020] row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=namenode,16020,1560527811592, seqNum=0