Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-5378

We are looking for a solution to connect to our Apache phoenix cluster from a node.js external IP.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 4.7.0
    • 4.7.0
    • None
    • Patch

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            Zayati Ahmed
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified