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 <[email protected]> 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. >
