2 Replies Latest reply on Jul 21, 2015 4:03 AM by abhijit gupta

    JBPM6.2 to retrieve Users and Role from Mysql DB

    abhijit gupta Newbie



      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"> 


                              <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=?"/> 




      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,