Support Questions
Find answers, ask questions, and share your expertise

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

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.