SQL authentication engine

[Margusja <ma...@roo.ee>]

Hi

I am looking solution where I can authenticate users from SQL in example 
from Oracle RDB befeore user can make requests to HBase. As much I read 
Knox documentation the main engine to keep users datais LDAP.
Does Knox provides any possibilities to authenticate from SQL?

-- 
Best regards, Margus Roo
skype: margusja
phone: +372 51 48 780
web: http://margus.roo.ee

Re: SQL authentication engine

[larry mccay <lm...@apache.org>]

The datasource configuration itself may be an issue that we can't quite
handle already.

We would need to do some work to the ShiroDeploymentContributor to know
whether a topology is calling for JDBCRealm vs KnoxLdapRealm and add the
appropriate datasource to the resulting web.xml.

Please file a jira for this effort - feel free to provide a patch that does
this or continue discussion in the jira to see whether you want to take it
on.
I think it is work worth doing.


On Mon, Nov 3, 2014 at 9:13 PM, larry mccay <la...@gmail.com> wrote:

> Hi Margus -
>
> There is a possibility that you would be able to configure the Shiro
> authentication provider that we use for LDAP to use the Shiro JDBCRealm
> instead of a LDAP variation.
>
> You would have to dig into the Shiro docs for JDBCRealm configuration and
> then configure the Shiro provider in the topology with the ini config that
> would go in shiro.ini.
>
> Please do let us know how you make out - it would be great if you could
> contribute back a topology example for templates - that uses JDBC!
>
> HTH,
>
> --larry
>
> On Mon, Nov 3, 2014 at 1:44 AM, Margusja <ma...@roo.ee> wrote:
>
>> Hi
>>
>> I am looking solution where I can authenticate users from SQL in example
>> from Oracle RDB befeore user can make requests to HBase. As much I read
>> Knox documentation the main engine to keep users datais LDAP.
>> Does Knox provides any possibilities to authenticate from SQL?
>>
>> --
>> Best regards, Margus Roo
>> skype: margusja
>> phone: +372 51 48 780
>> web: http://margus.roo.ee
>>
>>
>

Re: SQL authentication engine

[larry mccay <la...@gmail.com>]

Hi Margus -

There is a possibility that you would be able to configure the Shiro
authentication provider that we use for LDAP to use the Shiro JDBCRealm
instead of a LDAP variation.

You would have to dig into the Shiro docs for JDBCRealm configuration and
then configure the Shiro provider in the topology with the ini config that
would go in shiro.ini.

Please do let us know how you make out - it would be great if you could
contribute back a topology example for templates - that uses JDBC!

HTH,

--larry

On Mon, Nov 3, 2014 at 1:44 AM, Margusja <ma...@roo.ee> wrote:

> Hi
>
> I am looking solution where I can authenticate users from SQL in example
> from Oracle RDB befeore user can make requests to HBase. As much I read
> Knox documentation the main engine to keep users datais LDAP.
> Does Knox provides any possibilities to authenticate from SQL?
>
> --
> Best regards, Margus Roo
> skype: margusja
> phone: +372 51 48 780
> web: http://margus.roo.ee
>
>