oh, ok. Where does one override these, do you know? Somewhere in shiro.ini, perhaps?
On 19 October 2013 12:54, Jeroen van der Wal <[email protected]> wrote: > There's no need to reverse-engineer the Shiro datamodel, JdbcRealm [1] uses > four queries which can easily be overridden: > > DEFAULT_AUTHENTICATION_QUERY = "select password from users where username > = ?"; > DEFAULT_SALTED_AUTHENTICATION_QUERY = "select password, password_salt > from users where username = ?"; > DEFAULT_USER_ROLES_QUERY = "select role_name from user_roles where > username = ?"; > DEFAULT_PERMISSIONS_QUERY = "select permission from roles_permissions > where role_name = ?"; > > > [1] > > https://svn.apache.org/repos/asf/shiro/trunk/core/src/main/java/org/apache/shiro/realm/jdbc/JdbcRealm.java > > > On Sat, Oct 19, 2013 at 1:39 PM, james agada <[email protected]> wrote: > > > Ok. Let's see how it goes. > > > > Sent from my iPhone > > > > > On Oct 19, 2013, at 12:28 PM, Dan Haywood < > [email protected]> > > wrote: > > > > > > For help with configuring Shiro to run against a JDBC realm, I suggest > > you > > > go to the shiro users mailing list. Isis just uses the shiro.ini file > > "as > > > is", so whatever is configured there should be honoured by Isis. > > > > > > Once you've got Shiro using a JDBC realm, ie reading from database > > tables, > > > then you can "reverse engineer" these into Isis entities, such that you > > > could allow an user using an Isis app to set up users. > > > > > > You could either: > > > - have a single app that has its own user administration functionality, > > eg > > > accessible only to an administrator, or > > > - you could have two apps, one being used by regular users, and the > other > > > used by administrators to setup the perms for the first. > > > > > > Hope that makes sense. > > > > > > Dan > > > > > > > > > > > >> On 18 October 2013 20:17, james agada <[email protected]> wrote: > > >> > > >> I guess I need help. I can build a custom shire jdbcRealm class. I > have > > >> identified where the isis shiro ldaprealm class is located. So I > assume > > I > > >> will put the jdbcrealm there. Next I suppose is to configure shiro.ini > > to > > >> use the jdbcRealm. This should work except that I will need to > configure > > >> the database. Where will I do that in the isis framework? or in shiro > > >> framework itself? Assuming I get these configs correct, is that all > > there > > >> is to it? Are there any specific requirements for isis in the realm or > > will > > >> it work with the default jdbcrealm class? > > >> > > >> > > >>> On Fri, Oct 18, 2013 at 12:57 PM, Okwui <[email protected]> > wrote: > > >>> > > >>> I will try and see how it goes. > > >>> > > >>> Sent from my iPad > > >>> > > >>>>> On Oct 18, 2013, at 12:26 PM, Jeroen van der Wal < > > [email protected]> > > >>>> wrote: > > >>>> > > >>>> We haven't gone that route yet but it should be possible. > > >>>> > > >>>> FYI we've configured Shiro to use Microsoft Active Directory for > > >>>> authentication and authorization. > > >>>> > > >>>> Cheers, > > >>>> > > >>>> Jeroen > > >>>> > > >>>> > > >>>>> On Fri, Oct 18, 2013 at 1:15 PM, Okwui <[email protected]> > wrote: > > >>>>> > > >>>>> The default isis shiro setup uses the shiro.ini file. From the > shiro > > >>>>> documentation, I can also use a jdbc realm so that the information > is > > >>>>> stored in a database. Is this possible in isis? Can I point shiro > to > > >> use > > >>>>> the isis objectstore? > > >>>>> > > >>>>> Sent from my iPad > > >> > > >
