5 Replies Latest reply on Mar 7, 2008 8:53 AM by sdickerson.perse

jBPM Console - login failed

pebbels Jan 11, 2008 6:44 AM

Hi @all,

after I changed the database to MySQL as explained in http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpMysqlAsDefaultDS
and modified hibernate.cfg.xml of jbpm-console\WEB-INF\classes as follows:
hibernate.dialect - org.hibernate.dialect.MySQLDialect
hibernate.connection.datasource - java:/DefaultDS

I am not able to use the manager, user etc to log in into the jbpm console but getting the error:
Login failed. Invalid user name or password.
but they inserted into the database...

Has somebody an idea?

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????
Actions
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
Actions
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
Actions

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

Go to original post