5 Replies Latest reply on Jun 18, 2008 5:31 PM by echoi1975

    logging jboss web console problem

    rodosa

      Hello!!

      I can't login in the jbpm web console. The login failed and the error is the following.
      I'm using MySQL. I have to change anything in the jbpm-console.war???

      Thanks

      19:46:56,440 ERROR [STDERR] 09-ene-2008 19:46:56 com.sun.faces.lifecycle.ELResol
      verInitPhaseListener populateFacesELResolverForJsp
      INFO: JSF1027: [null] The ELResolvers for JSF were not registered with the JSP c
      ontainer.
      19:46:56,659 ERROR [STDERR] 09-ene-2008 19:46:56 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/gravel-14.jar!/META-INF/gravel
      -compat.taglib.xml
      19:46:56,659 ERROR [STDERR] 09-ene-2008 19:46:56 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jsf-facelets.jar!/META-INF/jsf
      -ui.taglib.xml
      19:46:56,690 ERROR [STDERR] 09-ene-2008 19:46:56 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/gravel-14.jar!/META-INF/gravel
      -data.taglib.xml
      19:46:57,002 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jbpm4jsf-14.jar!/META-INF/core
      .taglib.xml
      19:46:57,034 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jsf-facelets.jar!/META-INF/jsf
      -core.taglib.xml
      19:46:57,049 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jbpm4jsf-14.jar!/META-INF/tfl-
      compat.taglib.xml
      19:46:57,049 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jbpm4jsf-14.jar!/META-INF/tf.t
      aglib.xml
      19:46:57,065 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/gravel-14.jar!/META-INF/gravel
      -simple.taglib.xml
      19:46:57,080 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/gravel-14.jar!/META-INF/gravel
      -action.taglib.xml
      19:46:57,080 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jbpm4jsf-14.jar!/META-INF/tfl.
      taglib.xml
      19:46:57,096 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jbpm4jsf-14.jar!/META-INF/iden
      tity.taglib.xml
      19:46:57,112 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jsf-facelets.jar!/META-INF/jst
      l-core.taglib.xml
      19:46:57,112 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/gravel-14.jar!/META-INF/gravel
      -nav.taglib.xml
      19:46:57,112 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jsf-facelets.jar!/META-INF/jsf
      -html.taglib.xml
      19:46:57,127 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jsf-facelets.jar!/META-INF/jst
      l-fn.taglib.xml
      19:46:57,127 ERROR [STDERR] 09-ene-2008 19:46:57 com.sun.facelets.compiler.TagLi
      braryConfig loadImplicit
      INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
      mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/jbpm4jsf-14.jar!/META-INF/tf-c
      ompat.taglib.xml
      


        • 1. Re: logging jboss web console problem
          rodosa

           

          19:46:56,440 ERROR [STDERR] 09-ene-2008 19:46:56 com.sun.faces.lifecycle.ELResol
          verInitPhaseListener populateFacesELResolverForJsp
          INFO: JSF1027: [null] The ELResolvers for JSF were not registered with the JSP c
          ontainer.
          19:46:56,659 ERROR [STDERR] 09-ene-2008 19:46:56 com.sun.facelets.compiler.TagLi
          braryConfig loadImplicit
          INFO: Added Library from: jar:file:/C:/jbpm/jbpm-jpdl-3.2.2/server/server/jbpm/t
          mp/deploy/tmp4741jbpm-console-exp.war/WEB-INF/lib/gravel-14.jar!/META-INF/gravel
          -compat.taglib.xml
          

          This could be not exactly an error? This could be an information???

          I don't have enter in the web console because the application tells me that the user and password are incorrect!!

          I'm using MySQL and I have data in JBPM_ID_USER, JBPM_ID_GROUP & JBPM_ID_MEMBERSHIP. I added this, to login-config.xml file:

           <application-policy name = "jbpm">
           <authentication>
           <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
           flag="required">
           <module-option name="dsJndiName">java:/JbpmDS</module-option>
           <module-option name="principalsQuery">
           SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_=?
           </module-option>
           <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>
           </login-module>
           </authentication>
           </application-policy>
          
          <application-policy name = "MySqlDbRealm">
           <authentication>
           <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
           <module-option name = "principal">xxx</module-option>
           <module-option name = "userName">xxx</module-option>
           <module-option name ="password">xxx</module-option>
           <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=JbpmDS</module-option>
           </login-module>
           </authentication>
          </application-policy>
          


          But it doesn't work. It seems as if jbpm doesn't connect with my MySQL DB.

          • 2. Re: logging jboss web console problem
            rodosa

            It's solucionated. I have an error in the data of JBPM_ID_MEMBERSHIP & 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>
            


            • 3. Re: logging jboss web console problem
              b_

              Hi,

              Did you manage to solve this problem?

              • 4. 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@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);
                
                


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

                I hope it helps you!

                Regards

                • 5. Re: logging jboss web console problem
                  echoi1975

                  wow, thanks for this tidbit, i was wondering why the other tables were blank when i was dbl checkign the queires that one of the xml files was using in the db valditaion block.