-
30. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
wjm May 1, 2007 4:35 AM (in response to ygiriyap)You only need to use createSchema() once to setup the db. It automatically drops and recreates all tables each time you invoke it. I'm not sure what your code looks like, but you would likely want to comment that call and proceed with the assumption that the database now exists.
-
31. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
estaub May 1, 2007 8:02 AM (in response to ygiriyap)If you haven't already (it may be obvious), verify that it's really going to MySQL - if it were using the default in-memory HSQL db instead, it would explain why it's recreating the schema every time.
-Ed Staub -
32. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
hlq May 1, 2007 4:04 PM (in response to ygiriyap)The problem is I could not find where it call createSchema() when start up. :(
I am using MySql... and when it runs on one of our members' computer, it works fine and do not re-create the database. However when I run it on my PC or on the computers in Uni, it will call createSchema()... There should be something different in configuration, but I just can't tell... -
33. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
wadisnake Aug 17, 2007 6:12 PM (in response to ygiriyap)Hi,
I followed all steps but i still have a problem :
If i put any user/pass ==>Login failed => okay
If i put a correct login/pass =>error HTTP 403 (which means that i am not allowed to view this resource)
Any ideas ? using tomcat 5.5 with Mysql 5 and JBPM 3.2.1
Thanks in advance :) -
34. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
kukeltje Aug 18, 2007 8:01 AM (in response to ygiriyap)user is most likely not in the correct group.
-
35. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
wadisnake Aug 18, 2007 11:31 AM (in response to ygiriyap)"kukeltje" wrote:
user is most likely not in the correct group.
First of all, thank you for taking the time for responding ..
What do you mean by "not in the correct group" ? i tried users in different groups such as "admin","manager" etc...
Any more explanations please ?
Thanks again :) -
36. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
kukeltje Aug 18, 2007 12:18 PM (in response to ygiriyap)tip: participant
-
37. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
wadisnake Aug 18, 2007 12:38 PM (in response to ygiriyap)"kukeltje" wrote:
tip: participant
I'm sorry but i still can't figure out what you mean. a final hint please ?
thanks -
38. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
wadisnake Aug 18, 2007 12:54 PM (in response to ygiriyap)I finally figured it out. Working fine now ! And yes, the user wasn't in the correct group.
Thanks again kukeltje :) -
39. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
adityasri Aug 24, 2007 2:49 PM (in response to ygiriyap)Hi
Can you please tell me what is the fix for this issue. What did you do to put user in the correct group? -
40. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
kukeltje Aug 25, 2007 6:18 AM (in response to ygiriyap)I think he used sql
-
41. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
wadisnake Aug 26, 2007 11:52 AM (in response to ygiriyap)"adityasri" wrote:
Hi
Can you please tell me what is the fix for this issue. What did you do to put user in the correct group?
All you need is creating a role called "user", any user having this role can login successfully. -
42. Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
ronninlee May 29, 2008 4:30 AM (in response to ygiriyap)"mputz" wrote:
Please see below the necessary steps to get jBPM 3.2 working with Tomcat and MySQL.
Environment:
Tomcat 6.0.10
MySQL 5.0.15
jBPM 3.2.GA
1. in jbpm-jpdl-3.2.GA/deploy runant customize.console.for.tomcat
2. this builds a jbpm-console.war in jbpm-jpdl-3.2.GA/deploy/customized (almost) ready for deployment in TC
3. change the jbpm-console.war/WEB-INF/classes/hibernate.cfg.xml to reflect the following changes:<hibernate-configuration> <session-factory> <!-- hibernate dialect --> <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property> <!-- JDBC connection properties (begin) --> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpm32</property> <property name="hibernate.connection.username">jbossjbpm</property> <property name="hibernate.connection.password">jbossjbpm</property> <!-- JDBC connection properties (end) --> <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property> <!-- DataSource properties (begin) == <property name="hibernate.connection.datasource">java:/JbpmDS</property> == DataSource properties (end) --> <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property> ...
(Make sure to use the hibernate.connection.driver/url attributes to connect to the db and not the hibernate.connection.datasource property. Also set hibernate.transaction.factory_class to JDBCTransactionFactory instead of the JTATransactionFactory or CMTTransactionFactory which are already in this file.)
4. copy jboss-j2ee.jar (or maybe as well any jar that contains the default javax.transaction package) to jbpm-console.war/WEB-INF/lib. (Note: jboss-j2ee.jar can be found in a standard JBoss AS distribution)
5. Copy the jar containing the mysql jdbc driver to /$CATALINA_HOME/lib
6. Copy the adapted jbpm-console.war to /$CATALINA_HOME/webapps
Give it a try and start Tomcat. You should be able to start the jbpm web application, but for now you cannot successfully log in.
Next thing to do would be to properly configure your security realm. You could either go for the standard file based MemoryRealm and just add the jBPM specific users and roles to /$CATALINA_HOME/conf/tomcat-users.xml, OR...
Setup a JDBCRealm:
7. 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" userNameCol="NAME_" userCredCol="PASSWORD_" userRoleTable="JBPM_ID_MEMBERSHIP" roleNameCol="ROLE_" /> </Context>
8. Adapt the jBPM user tables to fit in the Tomcat Realm specification. If you have the standard tables (JBPM_ID_USER, JBPM_ID_GROUP, JBPM_ID_MEMBERSHIP) with the default entries already, be sure that the the columns NAME_ and ROLE_ in JBPM_ID_MEMBERSHIP are not NULL. If so you could use the following SQL to update this table:UPDATE jbpm_id_membership j, jbpm_id_user u SET j.NAME_ = u.NAME_ WHERE j.USER_ = u.ID_ UPDATE jbpm_id_membership j, jbpm_id_group g SET j.ROLE_ = g.NAME_ WHERE j.GROUP_ = g.ID_
Now you should be able to run jBPM default web app in Tomcat and login with the username/password from the db.
Thank you!