Unable to pass authentication parameters using calcite for jdbc to gemfire.

[kashyap kotak <kc...@gmail.com>]

I have gemfire 9 on the server and I require a jdbc connection to it using
a third party database app (hosted on tomcat) which accepts only jdbc. I
added all the required jars in the tomcat lib folder and when I try to
connect, I get the following error:

org.apache.geode.security.AuthenticationRequiredException

Below is the model JSON file:
{
 version: '1.0'
 schemas: [
  {
   type: 'custom',
   name: 'TEST',
   factory: 'org.apache.calcite.adapter.geode.rel.GeodeSchemaFactory',
   operand: {
     locatorHost: 'locatorAddress',
     locatorPort: 'locatorPort',
     regions: 'sreHoldings',
     pdxSerializablePackagePath: 'org.apache.calcite.adapter.geode.domain.*'
     }
    }
   ]
 }



The driver name I am using in the database app is:
org.apache.calcite.jdbc.Driver

The url I am using is: jdbc:calcite:model=<modelFilePath>

The third party db app is hosted on tomcat which I can access just in case
the solution is to add the credentials in some tomcat internal file.

The same thing is being done in code using Spring and setting the
properties: security-client-auth-init=<custom auth package>
security-username=*******
security-password=*******

After searching too much on the web and not finding anything, I am mailing
to this in hope of finding a solution. Please
Help. Eagerly waiting for a reply.

Thanks,
Kashyap Chetan Kotak,
Mumbai, Maharashtra, India.

Re: Unable to pass authentication parameters using calcite for jdbc to gemfire.

[Andrei Sereda <an...@sereda.cc>]

Hi Kotak,

I think currently geode adapter doesn't support [client credentials](
https://geode.apache.org/docs/guide/16/managing/security/implementing_authentication.html#how-a-cache-client-sets-its-credential)
for authentication (aka `AuthInitialize`).

Please log a JIRA and I'd be happy to take a look at it.

Regards.

On Fri, Oct 26, 2018 at 11:31 AM kashyap kotak <kc...@gmail.com> wrote:

> I have gemfire 9 on the server and I require a jdbc connection to it using
> a third party database app (hosted on tomcat) which accepts only jdbc. I
> added all the required jars in the tomcat lib folder and when I try to
> connect, I get the following error:
>
> org.apache.geode.security.AuthenticationRequiredException
>
> Below is the model JSON file:
> {
>  version: '1.0'
>  schemas: [
>   {
>    type: 'custom',
>    name: 'TEST',
>    factory: 'org.apache.calcite.adapter.geode.rel.GeodeSchemaFactory',
>    operand: {
>      locatorHost: 'locatorAddress',
>      locatorPort: 'locatorPort',
>      regions: 'sreHoldings',
>      pdxSerializablePackagePath:
> 'org.apache.calcite.adapter.geode.domain.*'
>      }
>     }
>    ]
>  }
>
>
>
> The driver name I am using in the database app is:
> org.apache.calcite.jdbc.Driver
>
> The url I am using is: jdbc:calcite:model=<modelFilePath>
>
> The third party db app is hosted on tomcat which I can access just in case
> the solution is to add the credentials in some tomcat internal file.
>
> The same thing is being done in code using Spring and setting the
> properties: security-client-auth-init=<custom auth package>
> security-username=*******
> security-password=*******
>
> After searching too much on the web and not finding anything, I am mailing
> to this in hope of finding a solution. Please
> Help. Eagerly waiting for a reply.
>
> Thanks,
> Kashyap Chetan Kotak,
> Mumbai, Maharashtra, India.
>