5 Replies Latest reply on Jan 16, 2008 1:19 PM by Ronald van Kuijk

    How to config jbpm-console for mysql and jboss correct!!!

    Vitaly Xaoc Newbie

      If you download starter-kit-3.2.2 you will get jbpm-console.war example in deploy folder. it works good if you run it as standalone app with start.bat but if you will try to migrate this app to real jboss server and try use Mysql (instead of Hipersonik) it will work awry! I've made this instructions (http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnTomcat)/
      In this article is described how to use Tomcat:

      3.1 Create a file jbpm-console.xml in /$CATALINA_HOME/conf/Catalina/localhost similar to
      
      <Context>
      <Realm className="org.apache.catalina.realm.JDBCRealm"
       driverName="com.mysql.jdbc.Driver"
       connectionURL="jdbc:mysql://localhost:3306/jbpm32"
       connectionName="jbossjbpm"
       connectionPassword="jbossjbpm"
       userTable="JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g"
       userNameCol="g.TYPE_ = 'security-role' AND m.GROUP_ = g.ID_ AND m.USER_ = u.ID_ AND u.NAME_"
       userCredCol="DISTINCT u.PASSWORD_"
       userRoleTable="JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g"
       roleNameCol="g.NAME_" />
      </Context>
      

      But how to config security for jboss (I should config it in login-config.xml?) and what query I should use to get different meanings for authorization, like in the mentioned piece of code?
      Does anybody have working example of jbpm-console.war?????

      Please share your experience in using mysql and jboss for jbpm!