Menu ▾ ▴

EJBCA 6.0.4 External RA GUI on Jboss 7.1.1 Final/MySQL: Could not get database metada

Help
Baptiste Grenier
2014-03-24
2014-04-02
1 2 > >> (Page 1 of 2)

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-24

    Hello,
    I installed EJBCA on a VM in our private network and I am trying to install an external RA GUI on a separate publicly accessible VM and I have some strange errors refering to H2 dialect whereas I am using a MySQL database.

    On the RA server the ant externalra-gui-deploy is correctly creating the local MySQL messages database, (and the database table messages gets created into the message database by a deploy on the CA server), the RA standalone.xml is getting populated with the java:/ExternalRAGUIMessageDS MySQL datasource, but I can see the following errors in the logs on the RA server:

    15:03:06,448 INFO  [org.hibernate.ejb.Ejb3Configuration] (MSC service thread 1-4) HHH000204: Processing PersistenceUnitInfo [
        name: ExternalRAGUIMessageDS
        ...]
15:03:06,591 INFO  [org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator] (MSC service thread 1-4) HHH000130: Instantiating explicit con
nection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
15:03:06,634 INFO  [org.hibernate.dialect.Dialect] (MSC service thread 1-4) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
15:03:06,639 WARN  [org.hibernate.dialect.H2Dialect] (MSC service thread 1-4) HHH000431: Unable to determine H2 database version, certain features may not work
15:03:06,656 INFO  [org.hibernate.engine.transaction.internal.TransactionFactoryInitiator] (MSC service thread 1-4) HHH000268: Transaction strategy: org.hibern
ate.engine.transaction.internal.jdbc.JdbcTransactionFactory
15:03:06,661 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (MSC service thread 1-4) HHH000397: Using ASTQueryTranslatorFactory
15:03:06,704 INFO  [org.hibernate.validator.util.Version] (MSC service thread 1-4) Hibernate Validator 4.2.0.Final
15:03:06,985 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-4) HHH000228: Running hbm2ddl schema update
15:03:06,985 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-4) HHH000102: Fetching database metadata
15:03:06,999 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-4) HHH000319: Could not get database metadata: com.mysql.jdbc.exceptions.jdb
c4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_25]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_25]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_25]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [rt.jar:1.7.0_25]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)

    And there is the following apparently wrong persistence configuration:
    /opt/jboss/standalone/tmp/vfs/tempcb0fa690d1945e14/externalra-gui.war-e81291337ee3d90a/WEB-INF/classes/META-INF/persistence.xml

      <persistence-unit name="ExternalRAGUIMessageDS" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
      <non-jta-data-source>java:/ExternalRAGUIMessageDS</non-jta-data-source>
    <class>org.ejbca.extra.db.Message</class>            
    <properties>                                         
      <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
      <property name="hibernate.show-sql" value="true"/>
      <property name="hibernate.hbm2ddl.auto" value="update"/>
      <property name="cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/>
    </properties>
  </persistence-unit>

    Here is the externalra-gui.properties I am using:

    appserver.home=/opt/jboss
webserver.keystore.file=/opt/jboss/extra-keys/ssl-keystore.jks
webserver.keystore.password=XXXXXXXXXXXX
externalra-gui.datasource.jdbc-url=jdbc:mysql://127.0.0.1/messages
externalra-database.driver=com.mysql.jdbc.Driver
externalra-gui.datasource.username=ejbca
externalra-gui.datasource.password=XXXXXXXXXXXXXX
externalra-gui.keystore=/opt/jboss/extra-keys/externalra-gui.p12
externalra-gui.keystorepassword=XXXXXXXXXXXXXXXXXX
externalra-gui.issuerchain=/opt/jboss/extra-keys/externalra-gui.issuer.pem

    In order to deploy the RA server, I installed JBoss 7.1.1, configured the MySQL jdbc driver, then extracted the EJBCA zip, added the externalra-gui.properties, the jks/p12/pem and ran the externalra-gui-deploy target that was successful.

    What could be the reason of such a strange behaviour?
    Thanks for any help!

    Best,
    Baptiste

     

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-24

    I was also trying to configure externalRA-GUI but haven't get succeeded. I am using postgres database. when i run ant externalra-gui-deploy, it build the externalra-gui successfully but if you take a look into the database, there is no database schema is created.
    I post this issue few days back, but Tomas said, ExternalRA-GUI is working on his test setup without any error.

    11:21:42,454 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 48) HHH000388: Unsuccessful: create table message (uniqueId varchar(250) not null, createtime bigint not null, message clob, messageid varchar(255), modifytime bigint not null, status integer not null, type integer not null, primary key (uniqueId))
    11:21:42,454 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 48) ERROR: type "clob" does not exist
    Position: 91

     

  • Tomas Gustavsson

    Tomas Gustavsson - 2014-03-25

    Perhaps you have built with different settings and then not cleaned?

    If I have the following settings in externalra-gui.properties:

    externalra-gui.datasource.jdbc-url=jdbc:mysql://127.0.0.1/messages
    externalra-database.driver=org.mariadb.jdbc.Driver

    ant then do "ant clean externalra-gui".
    I have MySQL dialext in the war file (dist/externalra-gui/externalra-gui.war/WEB-INF/classes/META-INF/persistence.xml.

    Cheers,
    Tomas

     

    • Baptiste Grenier

      Baptiste Grenier - 2014-03-25

      Hi Tomas,
      It looks like I found a solution to my problem, in order to have the MySQL dialect in the persistence.xml of the war I had to add a conf/database.properties file with the following content:

      database.name=mysql

      Then with this the persistence.xml contains the MySQL dialect.

      Do you have such a configuration? In the external-ra documentation it is not mentionned that this is needed, only the externalta-gui.properties is mentionned.

      Best,
      Baptiste

       

      Last edit: Baptiste Grenier 2014-03-25

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-25

    Hi Sanaullah Ashraf,
    Yes it looks like it is almost the same problem, but with a different database.

    I previously said that the database was created by the externalra-gui-deploy task but this is not true, it was created before (trying to deploy with puppet, had a hard time troubleshooting this...)

    Could you check if the generated persistence.xml file is the same as mine?
    Do the log also include h2 dialect related statements?

     

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-25

    Hi Tomas,

    I have setup everything on a new machine but the schema doesn't created so I took my old 4.0.16 external-GUI Schema and restore it to 6.0.4 ExternaRA-GUI. database related errors removed but facelet rendering related errors are still there.

    BWEB000065: HTTP Status 500 - java.lang.Exception: javax.faces.FacesException: Problem in renderResponse: null

    JBWEB000309: type JBWEB000066: Exception report

    JBWEB000068: message java.lang.Exception: javax.faces.FacesException: Problem in renderResponse: null

    JBWEB000069: description JBWEB000145: The server encountered an internal error that prevented it from fulfilling this request.

     

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-25

    I have only warning in my logs

    03:52:55,762 WARN [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 23) HHH000431: Unable to determine H2 database version, certain features may not work

    03:52:55,876 WARN [org.hibernate.internal.SessionFactoryImpl] (ServerService Thread Pool -- 23) HHH000008: JTASessionContext being used with JDBCTransactionFactory; auto-flush will not operate correctly with getCurrentSession()

    Here is my persistence.xml

    <persistence-unit name="ExternalRAGUIMessageDS"         transaction-            type="RESOURCE_LOCAL">
                                                                        <provider>org.hibernate.ejb.HibernatePersistence</provider>
            <non-jta-data-source>java:/ExternalRAGUIMessageDS</non-    jta-data-source>
            <class>org.ejbca.extra.db.Message</class>
            <properties>
                    <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
                    <property name="hibernate.show-sql" value="true"/>
                    <property name="hibernate.hbm2ddl.auto" value="update"/>
                    <property name="cache.provider_class" value="org.hibernate.cache.NoCacheProvider"$
            </properties>
    </persistence-unit>

    but now my GUI is have these exceptions
    https://sourceforge.net/p/ejbca/discussion/123123/thread/b2fce6c4/

     

    Last edit: sanaullah ashraf 2014-03-25

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-25

    Sanaullah,
    Didn't you see my answer to thomas's post about the need for me of a database.properties?
    Could you try to add a conf/database.properties containing:

    database.name=postgres

    Then doing a ant externalra-gui-depoy should fix the persistence.xml.

    I am now working on the following error:

    13:37:53,413 SEVERE [javax.enterprise.resource.webcontainer.jsf.application] (MSC service thread 1-2) JSF1051: Service entry 'org.jboss.as.web.deployment.jsf.J
sfInjectionProvider' does not extend DiscoverableInjectionProvider.  Entry will be ignored.
(...)
13:40:09,343 ERROR [com.icesoft.faces.facelets.D2DFaceletViewHandler] (http--0.0.0.0-8080-1) Failed initializing facelet instance: java.lang.NoSuchMethodError:
 com.sun.facelets.compiler.Compiler.setTrimmingXmlDeclarations(Z)V
        at com.icesoft.faces.facelets.D2DFaceletViewHandler.initializeCompiler(D2DFaceletViewHandler.java:189) [icefaces.jar:]
        at com.icesoft.faces.facelets.D2DFaceletViewHandler.faceletInitialize(D2DFaceletViewHandler.java:100) [icefaces.jar:]
        at com.icesoft.faces.facelets.D2DFaceletViewHandler.renderResponse(D2DFaceletViewHandler.java:264) [icefaces.jar:]
        at com.icesoft.faces.application.D2DViewHandler.renderView(D2DViewHandler.java:159) [icefaces.jar:]
        at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHO
T]
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHOT]
        at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHOT]
        at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:19) [icefaces.jar:]
        at com.icesoft.faces.context.View$2$1.respond(View.java:48) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.servlet.ServletRequestResponse.respondWith(ServletRequestResponse.java:201) [icefaces.jar:]
        at com.icesoft.faces.context.View$2.serve(View.java:77) [icefaces.jar:]
        at com.icesoft.faces.context.View.servePage(View.java:149) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.core.MultiViewServer.service(MultiViewServer.java:67) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.common.ServerProxy.service(ServerProxy.java:11) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.servlet.MainSessionBoundServlet$4.service(MainSessionBoundServlet.java:149) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.common.standard.PathDispatcherServer.service(PathDispatcherServer.java:24) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.servlet.BasicAdaptingServlet.service(BasicAdaptingServlet.java:16) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:23) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.servlet.SessionDispatcher.service(SessionDispatcher.java:53) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:23) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.servlet.MainServlet.service(MainServlet.java:131) [icefaces.jar:]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397) [jbossweb-7.0.13.Final.jar:]
        at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final
]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
        at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]

13:40:09,362 ERROR [com.icesoft.faces.facelets.D2DFaceletViewHandler] (http--0.0.0.0-8080-1) Problem in renderResponse: null: java.lang.NullPointerException
        at com.icesoft.faces.facelets.D2DFaceletViewHandler.renderResponse(D2DFaceletViewHandler.java:268) [icefaces.jar:]
        at com.icesoft.faces.application.D2DViewHandler.renderView(D2DViewHandler.java:159) [icefaces.jar:]
        at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHO
T]
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHOT]
        at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHOT]
        at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:19) [icefaces.jar:]
        at com.icesoft.faces.context.View$2$1.respond(View.java:48) [icefaces.jar:]
        at com.icesoft.faces.webapp.http.servlet.ServletRequestResponse.respondWith(ServletRequestResponse.java:201) [icefaces.jar:]
        at com.icesoft.faces.context.View$2.serve(View.java:77) [icefaces.jar:]

    Perhpas another missing property?

    Best,
    Baptiste

     

    Last edit: Baptiste Grenier 2014-03-25

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-25

    i tried conf/database.properties database.name=postgres. it fix the persistence.xml issue and also create the schema.

    but now I have the same error which you are working on.

     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-25

    Hi Tomas,

    I saw the ejbca/dist/externalra-gui/server.xml file so I presume that JBoss has to be configured manually? AFAICT this is an exemple configuration for an old version of JBoss (5 ?), is the externalra gui known to work on JBoss 7.1.1? Would you mind sharing a standanlone.xml configuration example? (I tried to adapt the configuration by myself, https on the 8442 port seems to be working but I still get facelets/icefaces/ errors)
    Do we need to add some more .properties files?

    Best,
    Baptiste

     

  • Tomas Gustavsson

    Tomas Gustavsson - 2014-03-25

    Yes, I have tested it, twice even. I don't remember doing anything in particular. Of course https needs to be configured manually. Perhaps something with the datasource, but I don't think so.

    I have so many tests to do so I wiped that a long time ago, so I don't have a standalone.xml to share, sorry. Always check server.log when you encounter problems.

    Cheers,
    Tomas

    PrimeKey Solutions offers commercial EJBCA and SignServer support subscriptions and training courses. Please see www.primekey.se or contact info@primekey.se for more information.
    http://www.primekey.se/Services/Support/
    http://www.primekey.se/Services/Training/

     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-25

    Hi Tomas,
    Thoser errors are comming from the server.log... But they are pretty cryptic at least for me :)

    Using OpenJDK 6 and JBoss 5.1.0 GA I am able to get access to a web interface on the RA server, I will test with JBoss 7.1.1 and OpenJDK 6 to see if it works.

    Cheers,
    Baptiste

    PS: a note about the database.propeties on the externalra gui page might help some users/avoid useless posts.

     

  • Tomas Gustavsson

    Tomas Gustavsson - 2014-03-25

    I think it is a smalll bug though. So I created https://jira.primekey.se/browse/ECA-3486

     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-25

    Glad to see the bug.

    No more progressfor me with JBoss 7.1.1, I tried to edit the web.xml (setting org.jboss.jbossfaces.WAR_BUNDLES_JSF_IMPL to true) and jboss-classloading.xml (testing things from http://phytodata.wordpress.com/2010/10/21/demystifying-the-jboss5-jboss-classloading-xml-file/) from the modules/externalra-gui/resources/WEB-INF/ but without any success.

    For me it looks like that there is a conflict between the facelets classes interfaces/implementattions from the externalra-gui and the one embeddd withing jboss, but as I am not sure how to cleanly/quickly fix this, and if you don't have any hint on this I will go with JBoss 5.1 for the time being. :/

    % tree /opt/jboss/modules/com/sun/jsf-impl
/opt/jboss/modules/com/sun/jsf-impl
├── 1.2
│   ├── jsf-impl-1.2_15-jbossorg-2.jar
│   ├── jsf-impl-1.2_15-jbossorg-2.jar.index
│   └── module.xml
└── main
    ├── jsf-impl-2.1.7-jbossorg-2.jar
    ├── jsf-impl-2.1.7-jbossorg-2.jar.index
    └── module.xml

2 directories, 6 files

    # tree /opt/ejbca/modules/externalra-gui/resources/WEB-INF 
/opt/ejbca/modules/externalra-gui/resources/WEB-INF
├── classes
│   ├── Messages.properties
│   └── Messages_sv.properties
├── faces-config.xml
├── jboss-classloading.xml
├── lib
│   ├── backport-util-concurrent.jar
│   ├── commons-fileupload-1.2.1.jar
│   ├── commons-logging.jar
│   ├── icefaces-comps.jar
│   ├── icefaces-facelets.jar
│   ├── icefaces.jar
│   └── jsf-facelets.jar
├── tag
│   ├── box.xhtml
│   ├── ejbca.taglib.xml
│   ├── landingitem.xhtml
│   └── landing.xhtml
└── web.xml

3 directories, 16 files

    Does anyone else succeed in deploying the External RA GUI on JBoss 7.1.1? Do we have to replace the JSF implementation packed with the External RA GUI? Because without doing anything special it does not work...

    The logs seems to show the jsf mixes:

    18:13:12,027 INFO  [org.apache.catalina.core.StandardContext] (MSC service thread 1-1) The listener "com.sun.faces.config.ConfigureListener" is already configu
red for this context. The duplicate definition has been ignored.
18:13:12,032 INFO  [javax.enterprise.resource.webcontainer.jsf.config] (MSC service thread 1-1) Initializing Mojarra (1.2_15.jbossorg-1-20111019-SNAPSHOT) for 
context '/externalra-gui'
18:13:12,166 SEVERE [javax.enterprise.resource.webcontainer.jsf.application] (MSC service thread 1-1) JSF1051: Service entry 'org.jboss.as.web.deployment.jsf.J
sfInjectionProvider' does not extend DiscoverableInjectionProvider.  Entry will be ignored.
18:13:12,167 INFO  [javax.enterprise.resource.webcontainer.jsf.application] (MSC service thread 1-1) JSF1048: PostConstruct/PreDestroy annotations present.  Ma
nagedBeans methods marked with these annotations will have said annotations processed.
18:13:12,172 INFO  [com.icesoft.faces.application.D2DViewHandler] (MSC service thread 1-1) 
ICEsoft Technologies, Inc.
ICEfaces 1.8.2 
Build number: 7
Revision: 19321

18:13:12,207 INFO  [com.icesoft.faces.application.D2DViewHandler] (MSC service thread 1-1) ICEfaces JSP parser disabled. This is a Facelets-only configuration.
18:13:12,209 INFO  [com.icesoft.faces.application.ViewRootStateManagerImpl] (MSC service thread 1-1) ViewRootStateManagerImpl constructed with Delegate: com.su
n.faces.application.StateManagerImpl@2e774999
18:13:12,212 INFO  [com.icesoft.faces.application.D2DViewHandler] (MSC service thread 1-1) ICEfaces JSP parser disabled. This is a Facelets-only configuration.
18:13:12,454 INFO  [org.jboss.web] (MSC service thread 1-1) JBAS018210: Registering web context: /externalra-gui
18:13:15,514 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018565: Replaced deployment "externalra-gui.war" with deployment "externalra-gui.w
ar"
18:14:05,134 INFO  [com.icesoft.faces.webapp.http.servlet.MainServlet] (http--0.0.0.0-8080-1) Blocking Request Handler: "auto-detect"
18:14:05,143 INFO  [com.icesoft.faces.webapp.http.servlet.EnvironmentAdaptingServlet] (http--0.0.0.0-8080-1) Adapting to Thread Blocking environment
18:14:05,171 WARN  [com.icesoft.faces.webapp.http.servlet.MainServlet] (http--0.0.0.0-8080-1) Push Server not found - the Push Server must be deployed to suppo
rt multiple asynchronous applications.
18:14:05,172 INFO  [com.icesoft.faces.webapp.http.servlet.MainServlet] (http--0.0.0.0-8080-1) Adapting to Push environment.
18:14:05,181 INFO  [com.icesoft.faces.webapp.http.portlet.page.AssociatedPageViews] (http--0.0.0.0-8080-1) using com.icesoft.faces.webapp.http.portlet.page.NoO
pAssociatedPageViews

18:14:05,246 ERROR [com.icesoft.faces.facelets.D2DFaceletViewHandler] (http--0.0.0.0-8080-1) Failed initializing facelet instance: java.lang.NoSuchMethodError:
 com.sun.facelets.compiler.Compiler.setTrimmingXmlDeclarations(Z)V
        at com.icesoft.faces.facelets.D2DFaceletViewHandler.initializeCompiler(D2DFaceletViewHandler.java:189) [icefaces.jar:]
        at com.icesoft.faces.facelets.D2DFaceletViewHandler.faceletInitialize(D2DFaceletViewHandler.java:100) [icefaces.jar:]
        at com.icesoft.faces.facelets.D2DFaceletViewHandler.renderResponse(D2DFaceletViewHandler.java:264) [icefaces.jar:]
        at com.icesoft.faces.application.D2DViewHandler.renderView(D2DViewHandler.java:159) [icefaces.jar:]
        at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHO
T]
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHOT]
        at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139) [jsf-impl-1.2_15-jbossorg-2.jar:1.2_15.jbossorg-1-20111019-SNAPSHOT]
        at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:19) [icefaces.jar:]
        at com.icesoft.faces.context.View$2$1.respond(View.java:48) [icefaces.jar:]

    Thanks for any help.

    Best,
    Baptiste

     

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-26

    Hi Baptiste,

    Your ExternalRA-GUI is working with Jboss5? and on the other side EJBCA 6.0.4 version with jboss 6 or 7?

    Regards,
    Sanaullah

     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-26

    Hi Sanaullah,
    Yes the External RA GUI is currently working with JBoss 5.1, and the CA is running JBoss 7.1, both with ejbca CE 6.0.4.

    I still haven't configured encryption/signing of messages and https for the RA but I was able to get on the RA a certificate generated by the CA.

    To disable encryption/signing I did use the following properties in the externalra-gui.properties:

    externalra-gui.caservicecert=
externalra-gui.keystore=

    And I did configure the CA Worker like this:

    externalra-caservice.keystore.path=
externalra-caservice.signature.required=false
externalra-caservice.encryption.required=false
externalra-caservice.keystore.pwd=
externalra-caservice.raissuer=

    I will now look at signing/encrypting messages.

    Best,
    Baptiste

     

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-26

    Thanks Baptiste.

    I tried all the above configurations but I am getting a database error.

    14:39:24,447 WARN  [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (EJB default - 9) Destroying connection that is not valid, due to the following exception: org.postgresql.jdbc4.Jdbc4Connection@4789bdf3: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:364)
at org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)

    due to this when a certificate request comes to EJBCA it generate an error

    14:40:59,706 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 8) SQL Error: 0, SQLState: 22003

    14:40:59,706 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 8) Bad value for type long : <?xml version="1.0" encoding="UTF-8"?>
    <java version="1.6.0_30" class="java.beans.XMLDecoder">
    <boolean>true</boolean>
    <boolean>true</boolean>

     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-26

    Hi,
    I only tried with MySQL, can't say much...
    Did you re-try from scratch with a clean DB, files and so on? Is this error present on the RA or on the CA server? The log excerpt seems too short to understand when/where it fails, are you sure that your database is accessible using the information you provided to JBoss?

    You could try to test with a MySQL database to see how it goes...

    For the record I was eventually able to configure the RA server with signing and encryption and https. Will look at CRL publishing now.

     

    Last edit: Baptiste Grenier 2014-03-26

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-26

    The below error log is at CA side when a certificate request is send to CA from ExternalRA-GUI

    15:09:10,138 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) SQL Error: 0, SQLState: 22003
    15:09:10,138 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) Bad value for type long : <?xml version="1.0" encoding="UTF-8"?>
    <java version="1.6.0_30" class="java.beans.XMLDecoder">
    <boolean>true</boolean>
    <boolean>true</boolean> <string>MIAGCSqGSIb3DQEHA6CAMIACAQAxggFqMIIBZgIBADBOMEIxEDAOBgNVBAMMB0FkbWluQ0ExDjAMBgNVBAsMBUFkbWluMREwDwYDVQQKDAhVbmlwYWdvczELMAkGA1UEBhMCTVgCCCTAwJJ363QUMA0GCSqGSIb3DQEBAQUABIIBAHDFe+ZD3EwJMl3qDvukiKg61yQJlYdYnlUmUQXU/F7krnWXi2Nz6f3OM65drgWJQQOaS3Tx2KtOudRJmPqe5AHPnQhf3YXdtntYmq4Rqe22TLxsxGbP7A5Qgl9Z2GiUFb3dcQwctz1xiEG8TuoRNAtjNEuCPJ6zdASjhDXv19Wdo8tLk7x/DHb/u4KxKf8wQyqu3IlTRg15ZExFUhFJipIsxfOXa/G3hHMhzLQMEBc4s9/+vwG/w4gj40TPpe5MI/rD0uM8DIfBmVN0j8md/Q/PszLj0ea/fIn1ri7y6cmkxlU3jTlkjy/s71wpLzdWRl3Ft5ya4IFZftQEP8sSP7EwgAYJKoZIhvcNAQcBMB0GCWCGSAFlAwQBKgQQSJRSFZz54/ocBKzdmYmoGaCABIID6BXMjqUipujVK1wSUa37cTRGY2LwmGIDM57pIMJ0uRrnwkxDhZuWr9fRRK3xeu4vBp1drSJahI5+YRg6LCk+dF9u5/Xj9fSsBBgAy/xeO/W0L6lQrIwbmRx4ki0QV12rxe65vpe9V7cPVgxnqYTifOsJiDpfCCPMFa0jlykjiPx9YZ67Gdd1zGWedJzXE0qpLeSK0svcAe61Lub1hFHtSbssRgzr9QjR96a/8YmqYw7LHgtu3h8w+nXgkANxD9YwHYV7Fq4qRO9GAXlgTJL9Z87Nyk57I217BVk8A3KBzelAxMCAGUYsOA7mgOZUETLFovxsUaefQuqPMxgeKdsCx9W0tfB8YAnzjgzfKfjEap/NefD6sQxL0CLOntUCgfKG9UO5KotbgJ8moG0mwNx8FtfokynmEXa5gV0sRS8se7eA2EdoL/FDi3xfCNZeKsCAsOoKjg2DHZyjKrExwQ0F8tnihhaufyidhhFPrHpTolHy315wUYj7HYXEYHdoaWoVKTfgqIfcBJtB0UQk9e1xHf5/ITy5Awl4Di5BgO6b7MljZY7HVBewUtVqK085W9cVNRMoBuDJ9jRPk3qcGx4gU7rk9WUD31Bjk52440cGl8E0zIDsRhwp0fgGQcAovqgc7FexyuLMFmQvmE43JxwqGRGXwVN2FnjEMV5jqch11RxbFX4CmXlhZt5d7sJ+Nk+aoZh+8NAA3knfvDlNZ64Dh0sRCe++Pm3gNu7BnHrA/0U60u8zhxbuacYa0GXjMcdPKmfYYeoKZFcWBs+OA7lq46VHjhjHawbwF045Bx5AXSXQgYxA4ATWYVB/aLlAhkyElFl2DW29yvmXTQSjKo2fmFSgfapyTo5XkxtB4UooW25+G27Embylmyxd2cBpgd2OCreQq0h8pxLGabM94MHSejT2goxfoopCHebhLyTu7PYMafTUdyvxfaMac5e44z7HWgd4msd9auaxpSxM8mSeOW1g6FYGTKdENAdIScQG9wp5IuM8qE5rMTNHPrP8iSdjqj1x6RRKjrChCjKufXFv30QBrApTWBTS33cQENOjLVB1TCOmRJK/eqyjGZsJ8eMDRtcy+ORESOpUfnhL2fbpdeaBTi5+N9ICDXoDNMnTwcwlge2EIxuUsqnOlt1fZozgu1P92nt0pEoSKXWtK8QYcqoAp43eTRiq3yoDyNSETLXODlgGz138udTC4Xpcfiu1DTqanlsAq6VRWljdCVxqDIxpDIrFnvMghqQhlrLCXW33AzMECp+FfAeANapwM0Rv2Iad5lVgtEJxswyruTW0ELVkHuD7HkZ6Sr58Gp56rkvX+i4Sw4a52NgEggPo0mblvn9bSz3Mijc1YpeN+TDK+MzKDHX+MG3rJR/5gYBH2Epfu3bV8XjgD1OhKikG7CWPn2ezsN1M3qNr6rYMUqRNRH0dozkKhmzTgG6lncclIh1UAbjOWUDBQiWNSeazI82AqjQYu0GUtuMw8YFfFivRXK2qHZEfdZ5RYrWBwlqBDnwNv9JLeWYK4QWwpvMDSVXBHMOWXXUOF+wt76z20k8NOvw9RN7fEMpgtX0Mg4/mXe0B+qCyMChS/VDeKUJjqxM97DPGDlae2ov3nWO34FrGi1McjF9J0nFYOrF9P5zt7SbiZloBKZUeAP/gVuvIaRc3cAIX/mE9ogOroIBcddcJT504hlFJWugSA+3DgfRPncg/Lg69XJT7M8UOwn4L4Ial5cum1gyJ0iUItcp5YuxB9NiU/UqSD9a6s69E8MOLKPCTkbDazFiKQH5YVnsSme6bYq6eeHe4yNDkl21vllL+Y2WTz43nznTy9FhxAEkg85zLDShrCedwyA7Mm7suHcdXErzQisS5uxpOnD2QSmxvKX1g0uE93WklN9Ye5qtBfjNto7raPUUgYgmzYb3aIe5iHyEFoBE8TMAr+wJV8/BIEksDP9VeiYW8cOJgGseorYD0D1EW/7jfwAMIr13EiFnQZ2ZHR6qrqCLx08oXorIC/NYPRar82ZKe3LtggkxKKL1E5xzYlfilmM+P+1FDsq+fvU8M9caw7rOcPr6FE0eM0wrHPQJbugBEJgCfpzy0wuM7O9i7X/qWM0cgoxD4vmfFTt48ApAgvajPhZc2jMMZUclF24Ky2pxzFkycplMSmLh86dShfjfU2EArpGR5ouzl7j8cBecn6BvWJ07qaWf39nPUS2tC7SY3RO0ufyjnRGcLIDdw56IdaIeUtO2RFYK07HuIJ2c6Un2PAnTlbjbAh5mUkGnidLvbNgR2zNrFxfRdxTTuzYbv3sYGgpMkyGyp+rGPCOLwJ4p6rVXJXgu1Xf0kfm8EHe3U2r8A2eEpb2GMYUnJ7kDymhTowBvyb8oNJNJPWW0F1hU4OwggrYhIR915hr5Zqt96TV2rAaEk9iAFEE383NAt5vIWfVcDHKgIKkc4Y0XGytjoJFSFNmiJafMrqXjLr1B0+NfjTWNuZlOzAsTNX74s6ybsdhX1ZRbHgVeQBzaHuMWzBpvV9xwYcoMQ24HZ2bralQnBdmp9vwhpgp/09AGQra/eTBGPFI/cMj2TE5NWo+C4EH3fpdcCO6jY5MDIcLcROUpZP4CeZUBnc00GNDqgwqnPs4s1gWqRTiMHYX5BwxCLnWGPSHns+pY+dkq7FsMHe88Plsqp12Gg8+cGxgSCAbDZ86nzDWW/rxLL/0zlWSD/j7wF9wWcIFWDPjw5VtUxUHms69Zinf/Il2V39uxp0xa8K8cyEb/5cr2p9L1RZAs2e7KUSViIGoBT9eSe0t5kLSEvnWFSYfWUMB+xgQzuqYWDKCZhG9e0DjNRRp0X6Q7V42Gmfpjc56fTum0XgQlevKEvNFeOiJx1siNCKNMMWMN2Up9PNTC3XpLvNFPP2z+dHVxSuzyqkwci8ReXqC54rIU/3RhnllLBBF13VMiTlxzyhuqTTMIv+6pTJYV497ETx3l3i24nyTjsnUOaWWPcBt/CTAmnm4nnIW+OSo/JxLIMEsIEMOgtxuy8mBkTlhNnD798YG+svkkItfn62bw2KJgQlzSA/Aj0/42WDa4xx3qC+UFuG0En2GR/IFZ+/4UspN4OZbciOT2a6pWk8WpaTBhKM7wmsQ2Sx9vHtTihr+Veb2K64ff3jz/pY9ivqZFBqcHXDoAoX8B3VMwDW4t88yVorhirjjMIPYVZf7ouFMd7iuOiJMBy4KuVRZmlR9vAygIY/Ap/ftIq1OvykpVDGtK1rT9Mh3/L0EgfVzzdq2kAAAAAAAAAAAAA</string>
    </java>15:09:10,144 ERROR [org.jboss.as.ejb3.invocation] (EJB default - 1) JBAS014134: EJB Invocation failed on component ServiceSessionBean for method public abstract void org.ejbca.core.ejb.services.ServiceSessionLocal.executeServiceInNoTransaction(org.ejbca.core.model.services.IWorker,java.lang.String): javax.ejb.EJBException: javax.persistence.RollbackException: Transaction marked as rollbackOnly
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInNoTx(CMTTxInterceptor.java:191) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:237) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.notSupported(CMTTxInterceptor.java:299) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:212) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.ejbca.core.ejb.services.ServiceSessionLocal$$$view87.executeServiceInNoTransaction(Unknown Source) [ejbca-interface.jar:]
    at org.ejbca.core.ejb.services.ServiceSessionBean.timeoutHandler(ServiceSessionBean.java:489) [ejbca-ejb.jar:]
    at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) [:1.7.0_51]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
    at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
    at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:56) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:56) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [jboss-as-jpa-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:235) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.notSupported(CMTTxInterceptor.java:299) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:212) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.timerservice.TimedObjectInvokerImpl.callTimeout(TimedObjectInvokerImpl.java:101) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ejb3.timerservice.TimedObjectInvokerImpl.callTimeout(TimedObjectInvokerImpl.java:111) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ejb3.timerservice.task.TimerTask.callTimeout(TimerTask.java:157) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.as.ejb3.timerservice.task.TimerTask.run(TimerTask.java:132) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_51]
    at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_51]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
    at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
    at org.jboss.threads.JBossThread.run(JBossThread.java:122)
    Caused by: javax.persistence.RollbackException: Transaction marked as rollbackOnly
    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:72) [hibernate-entitymanager-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
    at org.ejbca.extra.db.MessageHome.closeEntityManager(MessageHome.java:61) [externalra-service.jar:]
    at org.ejbca.extra.db.MessageHome.getNextWaitingMessage(MessageHome.java:176) [externalra-service.jar:]
    at org.ejbca.extra.caservice.ExtRACAServiceWorker.processWaitingMessages(ExtRACAServiceWorker.java:215) [externalra-service.jar:]
    at org.ejbca.extra.caservice.ExtRACAServiceWorker.work(ExtRACAServiceWorker.java:98) [externalra-service.jar:]
    at org.ejbca.core.ejb.services.ServiceSessionBean.executeServiceInNoTransaction(ServiceSessionBean.java:623) [ejbca-ejb.jar:]
    at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source) [:1.7.0_51]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
    at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
    at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [jboss-as-jpa-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:235) [jboss-as-ejb3-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
    ... 70 more

     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-26

    (The RA does not send anything to the CA, the CA is polling the RA database)

    But is your CA working? Did you try with a clean setup, or is it with an update of an existing installation? Did you try with JBoss 7.1 instead of JBoss 7.2?

     

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-26

    You are right, CA is polling to RA. sorry for my english.
    MY CA is in production with backend as postgres database. I tried this on Jboss 6.1 and 6.2
    I am doing this on existing installation means ExternalRA-GUI is totally a new setup but the CA is previously installed

    so the only option which i think i can try is mysql.

     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-26

    You meant JBoss 7.1 and 7.2 I presume... I think that JBoss 6 is not supported, I saw a bug report about this.
    And the CA is also running EJBCA 6.0.4?
    You can also test with an empty database/against a clean CA to see if at least it works...

     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-26

    If you did update the installation perhaps some alter on the fields in the DB are missing/failed, you could check that the clean CA database schema is the same as your production one.

     

  • sanaullah ashraf

    sanaullah ashraf - 2014-03-26

    Jboss 6 bug was already fixed and CA is working on jboss6. my CA is running on 6.0.4

    Now I am going to setup a new clean test CA as well.

    did you add the datasource manually for RA worker? or its created automatically?

    data-source add --name=ramessage1ds --jta=false --driver-name="org.postgresql.Driver" --connection-url="jdbc:postgresql://127.0.0.1/messages" --jndi-name="java:/RAMessage1DS" --use-ccm=true --user-name="ejbca" --password="ejbca" --validate-on-match=true --background-validation=false --prepared-statements-cache-size=50 --share-prepared-statements=true --min-pool-size=5 --max-pool-size=150 --pool-prefill=true --transaction-isolation=TRANSACTION_READ_COMMITTED --check-valid-connection-sql="select 1"
     

  • Baptiste Grenier

    Baptiste Grenier - 2014-03-26

    The datasource was deployed automatically on JBoss 5, see /opt/jboss/server/default/deploy/externalragui-ds.xml.

     
1 2 > >> (Page 1 of 2)

Log in to post a comment.