This content has been marked as final.
Show 5 replies
-
1. Re: jBPM Console - login failed
rodosa Jan 11, 2008 6:51 AM (in response to pebbels)Had you insert the correct data of users in JBPM_ID_USER, JBPM_ID_GROUP & JBPM_ID_MEMBERSHIP????
-
2. Re: jBPM Console - login failed
pebbels Jan 11, 2008 7:39 AM (in response to pebbels)I inserted user in the table JBPM_ID_USER but nothing into JBPM_ID_GROUP & JBPM_ID_MEMBERSHIP.
Where to get the correct input / scripts?
Thx Tina -
3. Re: jBPM Console - login failed
anuragpaliwal Jan 11, 2008 8:02 AM (in response to pebbels)Assuming you have downloaded jbpm-jpdl-suite-3.2.2 ,
Browse following location :
jbpm-jpdl-suite-3.2.2\jbpm-jpdl-3.2.2\server\server\jbpm\data\hypersonic -
4. Re: jBPM Console - login failed
rodosa Jan 11, 2008 8:04 AM (in response to pebbels)You should also insert data in the JBPM_ID_GROUP & JBPM_ID_MEMBERSHIP. For example,
INSERT INTO JBPM_ID_GROUP VALUES (1,'G','sales','organisation',NULL); INSERT INTO JBPM_ID_GROUP VALUES (2,'G','admin','security-role',NULL); INSERT INTO JBPM_ID_GROUP VALUES (3,'G','user','security-role',NULL); INSERT INTO JBPM_ID_GROUP VALUES (4,'G','hr','organisation',NULL); INSERT INTO JBPM_ID_GROUP VALUES (5,'G','manager','security-role',NULL); 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_MEMBERSHIP VALUES (1,'M',NULL,NULL,2,4); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (2,'M',NULL,NULL,3,4); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (3,'M',NULL,NULL,4,4); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (4,'M',NULL,NULL,4,3); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (5,'M',NULL,NULL,1,3); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (6,'M',NULL,NULL,2,3); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (7,'M',NULL,NULL,3,3); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (8,'M',NULL,NULL,3,2); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (9,'M',NULL,NULL,2,2); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (10,'M',NULL,NULL,2,5); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (11,'M',NULL,'boss',2,1); INSERT INTO JBPM_ID_MEMBERSHIP VALUES (12,'M',NULL,NULL,1,1);
This is a part of an script that is located in the data directory of Jboss server... -
5. Re: jBPM Console - login failed
sdickerson.perse Mar 7, 2008 8:53 AM (in response to pebbels)I had to tweak the sql above a little bit for MS SQLServer. This worked for me.
SET IDENTITY_INSERT JBPM_ID_GROUP ON; INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (1,'G','sales','organisation',NULL); INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (2,'G','admin','security-role',NULL); INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (3,'G','user','security-role',NULL); INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (4,'G','hr','organisation',NULL); INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (5,'G','manager','security-role',NULL); SET IDENTITY_INSERT JBPM_ID_GROUP OFF; SET IDENTITY_INSERT JBPM_ID_USER ON; INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES (1,'U','user','user@sample.domain','user'); INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES (2,'U','manager','manager@sample.domain','manager'); INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES (3,'U','admin','admin@sample.domain','admin'); INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES (4,'U','shipper','shipper@sample.domain','shipper'); SET IDENTITY_INSERT JBPM_ID_USER OFF; SET IDENTITY_INSERT JBPM_ID_MEMBERSHIP ON; INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (1,'M',NULL,NULL,2,4); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (2,'M',NULL,NULL,3,4); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (3,'M',NULL,NULL,4,4); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (4,'M',NULL,NULL,4,3); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (5,'M',NULL,NULL,1,3); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (6,'M',NULL,NULL,2,3); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (7,'M',NULL,NULL,3,3); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (8,'M',NULL,NULL,3,2); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (9,'M',NULL,NULL,2,2); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (10,'M',NULL,NULL,2,5); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (11,'M',NULL,'boss',2,1); INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (12,'M',NULL,NULL,1,1); SET IDENTITY_INSERT JBPM_ID_MEMBERSHIP OFF;
Scott