Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Issue while connecting to Phoenix via JDBC Client DB Visualizer

Issue while connecting to Phoenix via JDBC Client DB Visualizer

Explorer

I am trying to connect to Phoenix from remote windows machine via DB visualizer. I followed the steps from this Link. I am getting below errors while connecting . Connection to phoenix via sqlline was successful and i am using same url - ip-1************************om:2181:/hbase:s*************-dev@AEXAMPLE.COM:/pathto/keytab.keytab.

2018-06-22 12:31:34.918 INFO   973 [pool-5-thread-7 - S.flush] Found ticket for svc__________@EXAMPLE.COM to go to krbtgt/EXAMPLE.COM@EXAMPLE.COM expiring on Fri Jun 22 21:59:49 IST 2018
2018-06-22 12:31:34.920 INFO   973 [pool-5-thread-7 - S.flush] Entered Krb5Context.initSecContext with state=STATE_NEW
2018-06-22 12:31:34.920 INFO   973 [pool-5-thread-7 - S.flush] Found ticket for svc__________@EXAMPLE.COM to go to krbtgt/EXAMPLE.COM@EXAMPLE.COM expiring on Fri Jun 22 21:59:49 IST 2018
2018-06-22 12:31:34.920 INFO   973 [pool-5-thread-7 - S.flush] Service ticket not found in the subject
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush] >>> Credentials acquireServiceCreds: same realm
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush] Using builtin default etypes for default_tgs_enctypes
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush] default etypes for default_tgs_enctypes:
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush]  18
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush]  17
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush]  16
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush]  23
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush] .
2018-06-22 12:31:34.921 INFO   973 [pool-5-thread-7 - S.flush] >>> CksumType: sun.security.krb5.internal.crypto.RsaMd5CksumType
2018-06-22 12:31:34.922 INFO   973 [pool-5-thread-7 - S.flush] >>> EType: sun.security.krb5.internal.crypto.ArcFourHmacEType
2018-06-22 12:31:34.922 INFO   973 [pool-5-thread-7 - S.flush] getKDCFromDNS using UDP
2018-06-22 12:31:34.987 INFO   973 [pool-5-thread-7 - S.flush] >>> KrbKdcReq send: kdc=ausy-pdir-am02.EXAMPLE.COM. TCP:88, timeout=30000, number of retries =3, #bytes=1564
2018-06-22 12:31:35.181 INFO   973 [pool-5-thread-7 - S.flush] >>> KDCCommunication: kdc=ausy-pdir-am02.EXAMPLE.COM. TCP:88, timeout=30000,Attempt =1, #bytes=1564
2018-06-22 12:31:35.377 INFO   973 [pool-5-thread-7 - S.flush] >>>DEBUG: TCPClient reading 115 bytes
2018-06-22 12:31:35.377 INFO   973 [pool-5-thread-7 - S.flush] >>> KrbKdcReq send: #bytes read=115
2018-06-22 12:31:35.377 INFO   973 [pool-5-thread-7 - S.flush] >>> KdcAccessibility: remove ausy-pdir-am02.EXAMPLE.COM.:88
2018-06-22 12:31:35.377 INFO   973 [pool-5-thread-7 - S.flush] >>> KDCRep: init() encoding tag is 126 req type is 13
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] >>>KRBError:
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	 sTime is Fri Jun 22 12:31:35 IST 2018 1529650895000
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	 suSec is 392441
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	 error code is 7
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	 error Message is Server not found in Kerberos database
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	 sname is hbase/ip******19.example.com@EXAMPLE.COM
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	 msgType is 30
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] KrbException: Server not found in Kerberos database (7)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.KrbTgsRep.<init>(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.KrbTgsReq.getReply(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.KrbTgsReq.sendAndGetCreds(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.internal.CredentialsUtil.serviceCreds(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.internal.CredentialsUtil.acquireServiceCreds(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.Credentials.acquireServiceCreds(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.jgss.krb5.Krb5Context.initSecContext(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.jgss.GSSContextImpl.initSecContext(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.jgss.GSSContextImpl.initSecContext(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at com.sun.security.sasl.gsskerb.GssKrb5Client.evaluateChallenge(Unknown Source)
2018-06-22 12:31:35.378 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.security.HBaseSaslRpcClient.saslConnect(HBaseSaslRpcClient.java:181)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupSaslConnection(RpcClientImpl.java:617)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.access$700(RpcClientImpl.java:162)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection$2.run(RpcClientImpl.java:743)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection$2.run(RpcClientImpl.java:740)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at java.security.AccessController.doPrivileged(Native Method)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at javax.security.auth.Subject.doAs(Unknown Source)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1693)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupIOstreams(RpcClientImpl.java:740)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.writeRequest(RpcClientImpl.java:906)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.tracedWriteRequest(RpcClientImpl.java:873)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1242)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:226)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:331)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.protobuf.generated.MasterProtos$MasterService$BlockingStub.isMasterRunning(MasterProtos.java:58383)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$MasterServiceStubMaker.isMasterRunning(ConnectionManager.java:1712)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$StubMaker.makeStubNoRetries(ConnectionManager.java:1650)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$StubMaker.makeStub(ConnectionManager.java:1672)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$MasterServiceStubMaker.makeStub(ConnectionManager.java:1701)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getKeepAliveMasterService(ConnectionManager.java:1858)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.MasterCallable.prepare(MasterCallable.java:38)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:124)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.HBaseAdmin.executeCallable(HBaseAdmin.java:4131)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:555)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:547)
2018-06-22 12:31:35.379 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:577)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:979)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1369)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2116)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:828)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:338)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:326)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:324)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1326)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2279)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at java.lang.reflect.Method.invoke(Unknown Source)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at com.onseven.dbvis.g.B.D.?(Z:1548)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at com.onseven.dbvis.g.B.F$A.call(Z:1369)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at java.util.concurrent.FutureTask.run(Unknown Source)
2018-06-22 12:31:35.380 INFO   973 [pool-5-thread-7 - S.flush] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
2018-06-22 12:31:35.381 INFO   973 [pool-5-thread-7 - S.flush] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
2018-06-22 12:31:35.381 INFO   973 [pool-5-thread-7 - S.flush] 	at java.lang.Thread.run(Unknown Source)
2018-06-22 12:31:35.381 INFO   973 [pool-5-thread-7 - S.flush] Caused by: KrbException: Identifier doesn't match expected value (906)
2018-06-22 12:31:35.381 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.internal.KDCRep.init(Unknown Source)
2018-06-22 12:31:35.381 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.internal.TGSRep.init(Unknown Source)
2018-06-22 12:31:35.381 INFO   973 [pool-5-thread-7 - S.flush] 	at sun.security.krb5.internal.TGSRep.<init>(Unknown Source)
2018-06-22 12:31:35.381 INFO   973 [pool-5-thread-7 - S.flush] 	... 63 more
2018-06-22 12:31:35.381 INFO   973 [pool-5-thread-7 - S.flush] 18/06/22 12:31:35 WARN security.UserGroupInformation: PriviledgedActionException as:svc__________@EXAMPLE.COM (auth:KERBEROS) cause:javax.security.sasl.SaslException: GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Server not found in Kerberos database (7))]


1 REPLY 1
Highlighted

Re: Issue while connecting to Phoenix via JDBC Client DB Visualizer

Expert Contributor

"Server not found in Kerberos database". It is not able to resolve the service principal correctly.

--> Ensure your are using FQDN for zookeepers in connection string.

--> Ensure that local machine where you are running DBVisualzer is able to resolve(Forward/reverse) the ip/hostnames(FQDN) correctly for zookeepers, region servers and Hbase masters.

Don't have an account?
Coming from Hortonworks? Activate your account here