[ 
https://issues.apache.org/jira/browse/PHOENIX-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Rogozhnikov updated PHOENIX-2302:
---------------------------------------
    Description: 
I have secure hbase cluster. The sqlline tool was configured, as heir 
described: 
http://bigdatanoob.blogspot.de/2013/09/connect-phoenix-to-secure-hbase-cluster.html
I can establish connection on Linux system without problems, but not on MacOS. 

$ /usr/local/phoenix/bin/sqlline.py hmaster
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:hmaster none none 
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:hmaster
15/10/02 17:29:23 WARN util.NativeCodeLoader: Unable to load native-hadoop 
library for your platform... using builtin-java classes where applicable
Debug is  true storeKey false useTicketCache false useKeyTab true doNotPrompt 
false ticketCache is null isInitiator true KeyTab is service.keytab 
refreshKrb5Config is false principal is user/hmas...@example.com tryFirstPass 
is false useFirstPass is false storePass is false clearPass is false
principal is user/hmas...@example.com
Will use keytab
Commit Succeeded 
 ....
        at 
org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
        at 
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:889)
        at 
org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1223)
        at 
org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:113)
        at 
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1937)
        at 
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:751)
        at 
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186)
        at 
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:319)
        at 
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:311)
        at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
        at 
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:309)
        at 
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1421)
        at 
org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1927)
        at 
org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1896)
        at 
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
        at 
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1896)
        at 
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:180)
        at 
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:132)
        at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:151)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
        at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
        at sqlline.Commands.connect(Commands.java:1064)
        at sqlline.Commands.connect(Commands.java:996)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at 
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
        at sqlline.SqlLine.dispatch(SqlLine.java:804)
        at sqlline.SqlLine.initArgs(SqlLine.java:588)
        at sqlline.SqlLine.begin(SqlLine.java:656)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed 
after attempts=35, exceptions:
....
 at 
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:147)
        at 
org.apache.hadoop.hbase.client.HBaseAdmin.executeCallable(HBaseAdmin.java:3917)
        at 
org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:441)
        at 
org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:463)
        at 
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:823)
        ... 31 more
Caused by: org.apache.hadoop.hbase.MasterNotRunningException: 
com.google.protobuf.ServiceException: 
org.apache.hadoop.hbase.exceptions.ConnectionClosingException:
....

 Call id=34, waitTime=45
        at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$StubMaker.makeStub(ConnectionManager.java:1533)
        at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$MasterServiceStubMaker.makeStub(ConnectionManager.java:1553)
        at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getKeepAliveMasterService(ConnectionManager.java:1704)
        at 
org.apache.hadoop.hbase.client.MasterCallable.prepare(MasterCallable.java:38)
        at 
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:124)
        ... 35 more
Caused by: com.google.protobuf.ServiceException: 
org.apache.hadoop.hbase.exceptions.ConnectionClosingException: 



Has somebody an idea, what is the problem?


  was:
I have secure hbase cluster. The sqlline tool was configured, as heir 
described: 
http://bigdatanoob.blogspot.de/2013/09/connect-phoenix-to-secure-hbase-cluster.html
I can establish connection on Linux system without problems, but not on MacOS. 
No errors in logs, no response and it's hangs...

$ /usr/local/phoenix/bin/sqlline.py hmaster
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:hmaster none none 
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:hmaster
15/10/02 17:29:23 WARN util.NativeCodeLoader: Unable to load native-hadoop 
library for your platform... using builtin-java classes where applicable
Debug is  true storeKey false useTicketCache false useKeyTab true doNotPrompt 
false ticketCache is null isInitiator true KeyTab is service.keytab 
refreshKrb5Config is false principal is user/hmas...@example.com tryFirstPass 
is false useFirstPass is false storePass is false clearPass is false
principal is user/hmas...@example.com
Will use keytab
Commit Succeeded 

Has somebody an idea, what is the problem?



> Can't connect to secure hbase cluster on MacOS
> ----------------------------------------------
>
>                 Key: PHOENIX-2302
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2302
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.5.0, 4.5.1
>            Reporter: Roman Rogozhnikov
>
> I have secure hbase cluster. The sqlline tool was configured, as heir 
> described: 
> http://bigdatanoob.blogspot.de/2013/09/connect-phoenix-to-secure-hbase-cluster.html
> I can establish connection on Linux system without problems, but not on 
> MacOS. 
> $ /usr/local/phoenix/bin/sqlline.py hmaster
> Setting property: [isolation, TRANSACTION_READ_COMMITTED]
> issuing: !connect jdbc:phoenix:hmaster none none 
> org.apache.phoenix.jdbc.PhoenixDriver
> Connecting to jdbc:phoenix:hmaster
> 15/10/02 17:29:23 WARN util.NativeCodeLoader: Unable to load native-hadoop 
> library for your platform... using builtin-java classes where applicable
> Debug is  true storeKey false useTicketCache false useKeyTab true doNotPrompt 
> false ticketCache is null isInitiator true KeyTab is service.keytab 
> refreshKrb5Config is false principal is user/hmas...@example.com tryFirstPass 
> is false useFirstPass is false storePass is false clearPass is false
> principal is user/hmas...@example.com
> Will use keytab
> Commit Succeeded 
>  ....
>         at 
> org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:889)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1223)
>         at 
> org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:113)
>         at 
> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1937)
>         at 
> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:751)
>         at 
> org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186)
>         at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:319)
>         at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:311)
>         at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>         at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:309)
>         at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1421)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1927)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1896)
>         at 
> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1896)
>         at 
> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:180)
>         at 
> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:132)
>         at 
> org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:151)
>         at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
>         at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
>         at sqlline.Commands.connect(Commands.java:1064)
>         at sqlline.Commands.connect(Commands.java:996)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>         at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:497)
>         at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
>         at sqlline.SqlLine.dispatch(SqlLine.java:804)
>         at sqlline.SqlLine.initArgs(SqlLine.java:588)
>         at sqlline.SqlLine.begin(SqlLine.java:656)
>         at sqlline.SqlLine.start(SqlLine.java:398)
>         at sqlline.SqlLine.main(SqlLine.java:292)
> Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed 
> after attempts=35, exceptions:
> ....
>  at 
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:147)
>         at 
> org.apache.hadoop.hbase.client.HBaseAdmin.executeCallable(HBaseAdmin.java:3917)
>         at 
> org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:441)
>         at 
> org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:463)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:823)
>         ... 31 more
> Caused by: org.apache.hadoop.hbase.MasterNotRunningException: 
> com.google.protobuf.ServiceException: 
> org.apache.hadoop.hbase.exceptions.ConnectionClosingException:
> ....
>  Call id=34, waitTime=45
>         at 
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$StubMaker.makeStub(ConnectionManager.java:1533)
>         at 
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$MasterServiceStubMaker.makeStub(ConnectionManager.java:1553)
>         at 
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getKeepAliveMasterService(ConnectionManager.java:1704)
>         at 
> org.apache.hadoop.hbase.client.MasterCallable.prepare(MasterCallable.java:38)
>         at 
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:124)
>         ... 35 more
> Caused by: com.google.protobuf.ServiceException: 
> org.apache.hadoop.hbase.exceptions.ConnectionClosingException: 
> Has somebody an idea, what is the problem?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to