phoenix namespace 权限问题处理

phoenix namespace 权限问题处理

   时间：20170401

   创建过程：首先在phoenix 中（admin 用户）

 jdbc:phoenix:> CREATE SCHEMA lighthouse;  //说明：SCHEMA 默认对应namespace 是大写的

                                       // 分配权限，由于phoenix 需要到hbase 分配（admin）

grant'lighthouse','CRW','@LIGHTHOUSE'

 

   现象：上面以lighthouse 用户 登陆hbase shell 是可以的登陆的，而以该用户使用phoenix 客户端不能登陆，出错信息如下：

su - lighthouse

-bash-4.1$ sqlline.py

Setting property:[incremental, false]

Setting property:[isolation, TRANSACTION_READ_COMMITTED]

issuing: !connectjdbc:phoenix: none none org.apache.phoenix.jdbc.PhoenixDriver

Connecting to jdbc:phoenix:

SLF4J: Class path containsmultiple SLF4J bindings.

SLF4J: Found binding in[jar:file:/httx/run/phoenix-4.8.0-cdh5.8.0/phoenix-4.8.0-cdh5.8.0-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in[jar:file:/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/jars/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Seehttp://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is oftype [org.slf4j.impl.Log4jLoggerFactory]

17/04/04 18:11:48 WARNutil.NativeCodeLoader: Unable to load native-hadoop library for yourplatform... using builtin-java classes where applicable

17/04/04 18:11:49 WARNipc.CoprocessorRpcChannel: Call failed on IOException

org.apache.hadoop.hbase.security.AccessDeniedException:org.apache.hadoop.hbase.security.AccessDeniedException: Insufficientpermissions (user=lighthouse, scope=default:SYSTEM.CATALOG,params=[table=default:SYSTEM.CATALOG],action=EXEC)

        atorg.apache.hadoop.hbase.security.access.AccessController.requirePermission(AccessController.java:447)

        atorg.apache.hadoop.hbase.security.access.AccessController.preEndpointInvocation(AccessController.java:2184)

        atorg.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$67.call(RegionCoprocessorHost.java:1628)

 

处理方法：grant 'lighthouse','X','@default'

 

参考资料：https://community.hortonworks.com/questions/64005/phoenix-security-and-initial-system-table-creation.html