[rules-users] Drools Govnor DB configuration

[Jaroslaw Kijanowski]

Pardeep.Ruhil at lntinfotech.com wrote:
> 
> Hi,
> Thanks Jarek for your reply.
> Still I have one doubt in my mind, how can I see the data for a newly 
> registered user (i.e name & permission )
> created through Drools Guvnor  administrator functionality.  Where 
> should I find the new user data(i.e. name  & permission assigned) , so that
> I can write synch service to synch data from Drools Guvnor table to 
> OFBiz table.

I don't know where/how Jackrabbit persists the data in a DB. Moreover 
I'm not sure if you should rely on this data (format, location where 
it's stored). But that's just my opinion ;)
> 
> Please help me to through out from this problem.
> 
> Thanks & Regards
> 
> Pardeep Ruhil
> L&T Infotech Ltd
> Mumbai
> Ph: +919820283884
> 
> 
> Pardeep.Ruhil at lntinfotech.com wrote:
>  >
>  > Hi,
>  > I am using Apache OFBiz and had successfully integrated Drools Guvnor
>  > war file with OFBiz.
>  > By default Drools Guvnor supports Embedded derby, but in OFBiz i am
>  > using MYSql , so i changed
>  > the default embedded derby to MySql using repository.xml file by the
>  > following code.
>  >
>  >                 <PersistenceManager
>  > 
> class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager"> 
> 
>  >
>  >                   <param name="url"
>  > value="jdbc:mysql://localhost:3306/drools"/>
>  >                   <param name="user" value="root" />
>  >                   <param name="password" value="Newuser123" />
>  >                   <param name="schema" value="mysql"/>
>  >                   <param name="schemaObjectPrefix" value="${wsp.name}_"/>
>  >                 </PersistenceManager>
>  >
>  > Using this I successfully integrated Drools guvnor with same database as
>  > I am using for OFBiz(MySql).
>  >
>  > Now I have created a new user in Drools guvnor to create permission for
>  > that user, but I am not able to see
>  > where that username is stored in the database and in which entity or
>  > table of MySql.
>  >
>  > Also if i want to use the users available in OFBiz MySql database
>  >  entity say 'Userlogin' where i am storing all the list of userlogins,
>  > how can
>  > I retrieve the same and use this table data in drools Guvnor.
> 
> This can be done via JAAS - you just need to configure it to use a
> particular table in mysql for retrieving user logins/passwords.
> Keep in mind that this is just for authentication (to login).
> Here's a list of all available login modules:
> http://www.jboss.org/community/wiki/LoginModule
> http://www.jboss.org/community/wiki/DatabaseServerLoginModule
> 
>  > Also when
>  > I make a new user in Drools Govnor through
>  > administrator, my data of new user should go to  table 'UserLogin'.
> 
> AFAICT that's not possible and you need to synch your Guvnor user list
> with the OFBiz user list by yourself.
> 
> Cheers,
>  Jarek
>  >
>  > Please help me how this can be achieved in Drools Guvnor.
>  >
>  > Thanks & Regards
>  >
>  > Pardeep Ruhil
>  > L&T Infotech Ltd
>  > Mumbai
>  > Ph: +919820283884
>  > *
>  > Larsen & Toubro Infotech Ltd.*_
>  > __www.Lntinfotech.com_ <http://www.lntinfotech.com/>
>  >
>  > This Document is classified as:
>  >
>  > L&T Infotech Proprietary   L&T Infotech Confidential   L&T Infotech
>  > Internal Use Only   L&T Infotech General Business  
>  >
>  > This Email may contain confidential or privileged information for the
>  > intended recipient (s) If you are not the intended recipient, please do
>  > not use or disseminate the information, notify the sender and delete it
>  > from your system.
> 
> ______________________________________________________________________
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> http://lists.jboss.org/mailman/listinfo/rules-users