2 Replies Latest reply on Jul 11, 2009 7:03 AM by Mohamed Elgamal

    jBPM3.2.3 with Tomcat 6

    Mohamed Elgamal Newbie

      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

        • 1. Re: jBPM3.2.3 with Tomcat 6
          Ronald van Kuijk Master

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

          • 2. Re: jBPM3.2.3 with Tomcat 6
            Mohamed Elgamal Newbie

            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','cookie.monster@sesamestreet.tv','cookie monster');
            INSERT INTO JBPM_ID_USER VALUES(2,'U','ernie','ernie@sesamestreet.tv','ernie');
            INSERT INTO JBPM_ID_USER VALUES(3,'U','bert','bert@sesamestreet.tv','bert');
            INSERT INTO JBPM_ID_USER VALUES(4,'U','grover','grover@sesamestreet.tv','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?