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

      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