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