1 Reply Latest reply on Sep 13, 2007 1:04 PM by kosulin

    Problem logging in

    kosulin

      I can't log in to the jbpm console. The message shown is "Login failed. Invalid user name or password".
      I use Sybase 15, JBoss 4.2.1, jbpm 3.2.1.GA web app and jbpm-enterprise.jar combined into my ear.

      here is excerpt from my Sybase script:
      2> set identity_insert JBPM_ID_GROUP on
      3>
      4> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(1,'G','admin','security-role',NULL)
      5> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(2,'G','user','security-role',NULL)
      6> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(3,'G','manager','security-role',NULL)
      7> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(4,'G','developer','security-role',NULL)
      8> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(5,'G','QA','security-role',NULL)
      9> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(6,'G','analyst','security-role',NULL)
      10> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(7,'G','wsc','organisation',NULL)
      11> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(8,'G','client','organisation',NULL)
      12> INSERT INTO JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_,PARENT_) VALUES(9,'G','wsc_cp','organisation',7)
      13>
      14> set identity_insert JBPM_ID_GROUP off
      15> set identity_insert JBPM_ID_USER on
      16>
      17> INSERT INTO JBPM_ID_USER (ID_,CLASS_,NAME_,EMAIL_,PASSWORD_) VALUES(1,'U','kosulin','kosulin@wsc.com','password')
      18>
      19> set identity_insert JBPM_ID_USER off
      20> set identity_insert JBPM_ID_MEMBERSHIP on
      21>
      22> INSERT INTO JBPM_ID_MEMBERSHIP (ID_,CLASS_,NAME_,ROLE_,USER_,GROUP_) VALUES(1,'M','kosulin','admin',1,1)
      23> INSERT INTO JBPM_ID_MEMBERSHIP (ID_,CLASS_,NAME_,ROLE_,USER_,GROUP_) VALUES(2,'M','kosulin','user',1,2)
      24> INSERT INTO JBPM_ID_MEMBERSHIP (ID_,CLASS_,NAME_,ROLE_,USER_,GROUP_) VALUES(3,'M','kosulin','developer',1,4)
      25> INSERT INTO JBPM_ID_MEMBERSHIP (ID_,CLASS_,NAME_,ROLE_,USER_,GROUP_) VALUES(5,'M','kosulin','wsc_cp',1,9)
      26>
      27> set identity_insert JBPM_ID_MEMBERSHIP off

      There are no Exceptions thrown (I have the Exception breakpoint set up in Eclipse, and there are no helpful DUBUG level messages in the log). As I understand, there is some error reported by gravel, but I have no idea what is gravel, and can't find sources either.

      I use security domain java:/jaas/jbpm; I tested SQL from my login-config.xml for jbpm application policy, it is fine and returns proper password and roles.
      I have security roles 'user' and 'admin' set in web.xml, use FORM based authentication, enable security constrains for /sa/* for 'user'

      May be, I have to change something in access.properties? I found no docs for this file.

      Any thought welcome.

      Thanks,
      Vlad