0 Replies Latest reply on Jun 2, 2014 5:28 PM by Tex Albuja

    How to configure jdbc-realm in jBPM 6.0.1

    Tex Albuja Newbie

      Please someone who have succeded integrate jBPM with jdbc-realm



      I'm trying to use my user and roles tables in jBPM 6. 

      I've configured my standalone.xml like this.

      <security-domain name="other" cache-type="default"> <authentication> <login-module code="UsersRoles" flag="required"> <module-option name="dsJndiName" value="java:jboss/datasources/autenticacionDS"/> <module-option name="principalsQuery" value="select password from usuario where nombreusuario=?"/> <module-option name="rolesQuery" value="select nombre, 'Roles' from rol r inner join rolusuario ru on ru.rolid= r.id inner join usuario u on ru.usuarioid = u.id where u.nombreusuario=?"/> </login-module> </authentication> </security-domain>

      I've added "user" role in order to log in to KIE Workbench.

      My log appears to look for users and roles in a properties file and a warning telling me that my options are invalid.

      Invalid or misspelled module option: rolesQuery Failed to load users/passwords/roles files: java.io.IOException: PBOX000072: Properties file users.properties/defaultUsers.properties not found

      My web.xml looks like

       <filter> <filter-name>UberFire Security Filter</filter-name> <filter-class>org.uberfire.security.server.UberFireSecurityFilter</filter-class> <init-param> <param-name>org.uberfire.cookie.id</param-name> <param-value>kie.ide.console</param-value> </init-param> <init-param> <param-name>org.uberfire.auth.scheme</param-name> <param-value>org.uberfire.security.server.auth.JACCAuthenticationScheme</param-value> </init-param> <init-param> <param-name>org.uberfire.auth.rememberme</param-name> <param-value>disabled</param-value> </init-param> <init-param> <param-name>org.uberfire.auth.force.url</param-name> <param-value>/org.kie.workbench.KIEWebapp/KIEWebapp.html</param-value> </init-param>

      I think I need to change something like org.uberfire.security.server.auth.JDBCAuthenticationScheme or something like it.