[jboss-user] [JBoss jBPM] - How to config jbpm-console for mysql and jboss correct!!!

[inxaoc]

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! 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4119776#4119776

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4119776