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