jBPM3.2.3 with Tomcat 6

[melgamal]

Daer

i have successfuly deploy jbpm3.2.3 on tomcat6 using the help of http://www.jboss.org/community/wiki/JbpmOnTomcat
but i cannt loged in with database users, I can only loged in if adding users to tomcat-users.xml. i configred realm for tomcat with right parameters it didnt throws any exceptions but also didnt loged in.
have any idea.

thanx

Mohamed

[kukeltje]

the rules you should follow is like configuring using a database for authentication like for any other webapp. So try that first.

[melgamal]

thanx 4 ur replay

I allready insert data in Identity tables like this:

INSERT INTO JBPM_ID_GROUP VALUES(1,'G','sales','organisation',NULL);
INSERT INTO JBPM_ID_GROUP VALUES(2,'G','hr','organisation',NULL);
INSERT INTO JBPM_ID_GROUP VALUES(3,'G','participant','security-role',NULL);
INSERT INTO JBPM_ID_GROUP VALUES(4,'G','manager','security-role',NULL);
INSERT INTO JBPM_ID_GROUP VALUES(5,'G','administrator','security-role',NULL);
INSERT INTO JBPM_ID_USER VALUES(1,'U','cookie monster','[e-mail]','cookie monster');
INSERT INTO JBPM_ID_USER VALUES(2,'U','ernie','[e-mail]','ernie');
INSERT INTO JBPM_ID_USER VALUES(3,'U','bert','[e-mail]','bert');
INSERT INTO JBPM_ID_USER VALUES(4,'U','grover','[e-mail]','grover');
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(1,'M',NULL,NULL,1,3);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(2,'M',NULL,NULL,2,3);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(3,'M',NULL,NULL,4,2);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(4,'M',NULL,NULL,4,3);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(5,'M',NULL,NULL,3,3);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(6,'M',NULL,NULL,3,2);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(7,'M',NULL,NULL,2,2);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(8,'M',NULL,NULL,2,4);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(9,'M',NULL,NULL,2,5);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(10,'M',NULL,'boss',2,1);
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(11,'M',NULL,NULL,1,1);

and also update data for oracl database using the following sql script:

update jbpm_id_membership j
set j.NAME_ = (SELECT u.NAME_ from jbpm_id_user u where j.USER_ = u.ID_)


update jbpm_id_membership j
set j.ROLE_ = (SELECT g.NAME_ from jbpm_id_group g where j.GROUP_ = g.ID_)

and define the realm as follow:

<Context>
 <Realm className="org.apache.catalina.realm.JDBCRealm"
 driverName="oracle.jdbc.driver.OracleDriver"
 connectionURL="jdbc:oracle:thin:@localhost:1521:orcl"
 connectionName="****"
 connectionPassword="*****"
 userTable="JBPM_ID_USER"
 userNameCol="NAME_"
 userCredCol="PASSWORD_"
 userRoleTable="JBPM_ID_MEMBERSHIP"
 roleNameCol="NAME_" />
</Context>

am I missing any thing else?