[jboss-user] [JBoss jBPM] - Re: logging jboss web console problem

[rodosa]

Yes, my problem was that I hadn't the correct information in my jbpm database. So the it doesn't adjust with the SQL sentence of web of login-config.xml: 


  | <module-option name="rolesQuery">
  |              SELECT g.NAME_ ,'Roles' 
  |              FROM JBPM_ID_USER u,
  |                   JBPM_ID_MEMBERSHIP m,
  |                   JBPM_ID_GROUP g
  |              WHERE g.TYPE_='security-role'
  |                AND m.GROUP_ = g.ID_
  |                AND m.USER_ = u.ID_
  |                AND u.NAME_=?
  |            </module-option>
  | 

I inserted the following information in my DB, so I could access to my DB with the users that I inserted:


  | 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 at sample.domain','user');
  | INSERT INTO JBPM_ID_USER VALUES (2,'U','manager','manager at sample.domain','manager');
  | INSERT INTO JBPM_ID_USER VALUES (3,'U','admin','admin at sample.domain','admin');
  | INSERT INTO JBPM_ID_USER VALUES (4,'U','shipper','shipper at 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);
  | 
  | 

So, you can access at jbpm-console with the users:admin,user,shipper,manager.

I hope it helps you!

Regards

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134051#4134051

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4134051