question Re: Renewing Phoenix Connection Using Kerberos Tomcat in Archives of Support Questions (Read Only)

Renewing Phoenix Connection Using Kerberos Tomcat

koundinya_ravul — Tue, 03 Apr 2018 19:32:16 GMT

Hi All,

I am using apache phoenix to query data from hbase. I am using keytab mechanism to connect to phoenix. When i Create phoenix connection pool everything works well for the 24hrs period which is the ticket_lifetime of kerberos token and the connections fail after 24hrs. I have tried to create a new Connection pool object for every 2 hrs and destroy the old connection pool once active connections expired on previous data source. But this also fails. The only way it gets renewed is after restarting tomcat.

I have followed similar approach to refresh hadoop configuration. I am trying to access hdfs file system and i got same issue after 24hrs this issue has been fixed if i recreate the new hadoop configuration after every 2hrs and kill the old configuration. I looked for about 2 days but not able to figure out why the connection pool is taking old kerberos token even though i create a new connection pool object .
Can any one let me know what can be done to renew the phoenix connection on kerberos cluster ?

Re: Renewing Phoenix Connection Using Kerberos Tomcat

schhabra1 — Thu, 05 Apr 2018 13:42:28 GMT

Hi @Koundinya Ravulapati,

I could think of two ways.

- Renewal of ticket via code i.e running background thread to renew ticket.

You can refer below mentioned link-

https://github.com/joshelser/phoenix-kerberos/blob/master/src/main/java/com/github/joshelser/PhoenixWithRenewal.java

- Running kinit in cron job and using ticket from cache.

Thanks

Shubham

Re: Renewing Phoenix Connection Using Kerberos Tomcat

schhabra1 — Thu, 19 Apr 2018 19:42:40 GMT

@Koundinya Ravulapati,If above information helped you, Could you please accept answer?

Re: Renewing Phoenix Connection Using Kerberos Tomcat

koundinya_ravul — Sat, 21 Apr 2018 07:57:41 GMT

Thanks @schhabra the solution worked for me. Thanks for the help