5 Replies Latest reply on Mar 7, 2008 8:53 AM by Scott Dickerson

    jBPM Console - login failed

    Tina Kleb Newbie

      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
          Sara Rodríguez Dorrego Novice

          Had you insert the correct data of users in JBPM_ID_USER, JBPM_ID_GROUP & JBPM_ID_MEMBERSHIP????

          • 2. Re: jBPM Console - login failed
            Tina Kleb Newbie

            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
              Anurag Paliwal Newbie

              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
                Sara Rodríguez Dorrego Novice

                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
                  Scott Dickerson Newbie

                  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