JBPM6.2 to retrieve Users and Role from Mysql DB

[abhijitkumar1903]

Hi,

I am using JBPM6.2 and connected it with MySQL DB. I am using Windows 8.

I need to login to KIE Workbench with user and their roles being fetched from MySQL DB. For this I brought changes in my Standaloe.*.xml files as below:

               <security-domain name="other" cache-type="default"> 

                    <authentication> 

                        <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required"> 

                            <module-option name="dsJndiName" value="java:jboss/datasources/jbpmDS"/> 

                            <module-option name="principalsQuery" value="select Password from jbpm.User where UserLogon=?"/> 

                            <module-option name="rolesQuery" value="select RoleName, 'Roles' from jbpm.UserRole where UserLogon=?"/> 

                        </login-module> 

                    </authentication> 

                </security-domain>

But still I am unable to achieve this. I followed this link and tried this How to modify jbpm-console to make it retrieve user and role list from database?

I also noticed that standalone file contains security-realm. Not sure whether even this is required to be changed.

Can any one help me out with this.

Regards & Thanks in Advance,

Abhijit

[abhijitkumar1903]

Any help much appreciated. As its very urgent

[abhijitkumar1903]

Does this forum really works, as I didnt see any response

Strange