question Re: SQuirrel client allows any user to connect on phoenix jdbc in Archives of Support Questions (Read Only)

SQuirrel client allows any user to connect on phoenix jdbc

jtasipit — Tue, 04 Jul 2017 11:46:56 GMT

Hello guys,

SQuirrel client allows phoenix jdbc connection using any user and password, but for security reasons, this behaviour is misleading. Is there a way to just disable the login prompt on squirrel? Or is there other authentication we can use to connect to phoenix?

Re: SQuirrel client allows any user to connect on phoenix jdbc

sandyy006 — Thu, 06 Jul 2017 01:38:42 GMT

@John Ross Tasipit

You can enable kerberos and hbase Acl's to have the access control and let the authorised users to connect to phoenix.

Re: SQuirrel client allows any user to connect on phoenix jdbc

jtasipit — Thu, 06 Jul 2017 11:44:42 GMT

I see but is it a normal behaviour for squirrel to let any user/password access phoenix?

Re: SQuirrel client allows any user to connect on phoenix jdbc

asinghal — Wed, 26 Jul 2017 16:34:00 GMT

you can't authenticate using username and password in Phoenix/HBase/HDFS, the only way is to go through kerberos authentication.