4 Replies Latest reply on Dec 17, 2008 7:16 AM by mr.sathya

    JBPM-3.3.0 login issues

    mr.sathya

      Hi All..

      Good Morning..

      while accessing the jbpm console i am facing login problems.In the prev.versions there are some identity tables like jbpm-id-user,jbim-id-group etc,But i couldnt find those tables in the JBpm 3.3.0 script.i am using oracle Xe.Pls point me to those scripts locations or provide me any documentation how to acheive this...

      sorry for my english..I couldnt find any scripts in the wiki.may be my search is not proper.Pls help me in this...
      i found same question in the forum.but i coudnt find proper solution for this.

      Pls as a beginner i am seeking ur help...

      Thanking in advance...

      Regards,
      Sathya

        • 1. Re: JBPM-3.3.0 login issues
          janvandeklok

          They are missing in the 3.3.0 version.
          I took them from the 3.2.3 version:

          create table JBPM_ID_GROUP (ID_ number(19,0) not null, CLASS_ char(1 char) not null, NAME_ varchar2(255 char), TYPE_ varchar2(255 char), PARENT_ number(19,0), primary key (ID_));
          create table JBPM_ID_MEMBERSHIP (ID_ number(19,0) not null, CLASS_ char(1 char) not null, NAME_ varchar2(255 char), ROLE_ varchar2(255 char), USER_ number(19,0), GROUP_ number(19,0), primary key (ID_));
          create table JBPM_ID_PERMISSIONS (ENTITY_ number(19,0) not null, CLASS_ varchar2(255 char), NAME_ varchar2(255 char), ACTION_ varchar2(255 char));
          create table JBPM_ID_USER (ID_ number(19,0) not null, CLASS_ char(1 char) not null, NAME_ varchar2(255 char), EMAIL_ varchar2(255 char), PASSWORD_ varchar2(255 char), primary key (ID_));
          create table JBPM_JOB (ID_ number(19,0) not null, CLASS_ char(1 char) not null, VERSION_ number(10,0) not null, DUEDATE_ timestamp, PROCESSINSTANCE_ number(19,0), TOKEN_ number(19,0), TASKINSTANCE_ number(19,0), ISSUSPENDED_ number(1,0), ISEXCLUSIVE_ number(1,0), LOCKOWNER_ varchar2(255 char), LOCKTIME_ timestamp, EXCEPTION_ varchar2(4000 char), RETRIES_ number(10,0), NAME_ varchar2(255 char), REPEAT_ varchar2(255 char), TRANSITIONNAME_ varchar2(255 char), ACTION_ number(19,0), GRAPHELEMENTTYPE_ varchar2(255 char), GRAPHELEMENT_ number(19,0), NODE_ number(19,0), primary key (ID_));

          You can populate them with this data for a starter:

          INSERT INTO JBPM_ID_USER VALUES(1,'U','user','user@sample.domain','user'); INSERT INTO JBPM_ID_USER VALUES(2,'U','manager','manager@sample.domain','manager'); INSERT INTO JBPM_ID_USER VALUES(3,'U','admin','admin@sample.domain','admin'); INSERT INTO JBPM_ID_USER VALUES(4,'U','shipper','shipper@sample.domain','shipper'); INSERT INTO JBPM_ID_GROUP VALUES(1,'G','sales','organisation',NULL); INSERT INTO JBPM_ID_GROUP VALUES(2,'G','manager','security-role',NULL); INSERT INTO JBPM_ID_GROUP VALUES(3,'G','hr','organisation',NULL); INSERT INTO JBPM_ID_GROUP VALUES(4,'G','admin','security-role',NULL); INSERT INTO JBPM_ID_GROUP VALUES(5,'G','user','security-role',NULL); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(1,'M',NULL,NULL,2,2); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(2,'M',NULL,NULL,2,4); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(3,'M',NULL,NULL,3,4); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(4,'M',NULL,NULL,2,5); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(5,'M',NULL,NULL,1,5); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(6,'M',NULL,NULL,4,3); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(7,'M',NULL,NULL,4,5); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(8,'M',NULL,NULL,3,5); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(9,'M',NULL,NULL,3,3); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(10,'M',NULL,NULL,2,3); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(11,'M',NULL,'boss',2,1); INSERT INTO JBPM_ID_MEMBERSHIP VALUES(12,'M',NULL,NULL,1,1);


          It worked for me!!

          Jan

          • 2. Re: JBPM-3.3.0 login issues
            kukeltje

            is the job table also missing?

            • 3. Re: JBPM-3.3.0 login issues
              mr.sathya

              Thanks Janvandeklok..it is working for me..

              I can able to login to jbpm-console with the user table data.

              But i cant able to login into gwt-console.is gwt-console is using diffrent tables?whether i have ti edit any other files for this.

              while logging into the gwt-console.it is showing following error box.

              Authentication failed.
              Not found
              The requested URL /gwt-console-server/rs/user/roles was not found on this server
              


              Pls provide me solution for this...



              Thanking advance...

              Regards,
              Sathya

              • 4. Re: JBPM-3.3.0 login issues
                mr.sathya

                Hi All...

                Pls help me to solve this problem...


                Thanking in advance..

                Regards,
                Sathya