Caught exception during boot: org.jboss.as.controller.persistence.ConfigurationPersistenceException: WFLYCTL0085: Failed to parse configuration

[murugeeeeesh]

I am getting the below issue when I deploy with mysql db with sample application. Thanks in advance

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:17:32:12,127 ERROR [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0055: Caught exception during boot: org.jboss.as.controller.persistence.ConfigurationPersistenceException: WFLYCTL0085: Failed to parse configuration
at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:143)
at org.jboss.as.server.ServerService.boot(ServerService.java:387)
at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:370)
at java.lang.Thread.run(Thread.java:748)
Caused by: javax.xml.stream.XMLStreamException: org.jboss.as.connector.util.ParserException: IJ010061: Unexpected element: datasource
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:650)
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:204)
at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:122)
at org.jboss.staxmapper.XMLExtendedStreamReaderImpl.handleAny(XMLExtendedStreamReaderImpl.java:69)
at org.jboss.as.server.parsing.StandaloneXml_5.parseServerProfile(StandaloneXml_5.java:610)
at org.jboss.as.server.parsing.StandaloneXml_5.readServerElement(StandaloneXml_5.java:243)
at org.jboss.as.server.parsing.StandaloneXml_5.readElement(StandaloneXml_5.java:142)
at org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:107)
at org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:49)
at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:122)
at org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:76)
at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:126)
... 3 more
Caused by: org.jboss.as.connector.util.ParserException: IJ010061: Unexpected element: datasource
at org.jboss.as.connector.subsystems.datasources.DsParser.parse(DsParser.java:193)
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:643)
... 14 more

17:32:12,131 FATAL [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0056: Server boot has failed in an unrecoverable manner; exiting. See previous messages for details.

1. '...'
2. '....'
3. '....'

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

[rsoika]

This looks like there is a typo in your standalone.xml file. I guess your wildfly server is not booting any more - is this right?
You may check the database configuration you added . You can also post this section so maybe I can help you to identify the wrong line. It must be in the area where you added the 'datasource' tag....

[rsoika]

It is always good to make a copy from the origin standalone.xml file before you modify it.

[subhashreebiswal]

jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE h2 sa sa ​ ​jdbc:postgresql://localhost:5432/keycloak-dev ​postgresql ​ ​postgres ​admin ​ ​ ​ org.postgresql.xa.PGXADataSource ​ org.h2.jdbcx.JdbcDataSource false auth classpath:${jboss.home.dir}/providers/* master 900 2592000 true true ${jboss.home.dir}/themes jpa basic default ${keycloak.jta.lookup.provider:jboss} ${keycloak.x509cert.lookup.provider:default} default

please give me solution

[rsoika]

@subhashreebiswal what's your question?

[subhashreebiswal]

thanks rsoika,my question was how to configure postgres db in keycloak?but i solved that.can you tell how to configure mysql db in keycloak?it will be helpful

[rsoika]

I think you should ask this question better to the keycloak community

[Manojrx]

@subhashreebiswal I am facing issue while connecting keycloak with postgres can u please guide me ..

[rsoika]

Are you trying to connect your Imixs-Workflow instance with Keycloak? Or is your question only related to keycloak?

[Manojrx]

Hi @rsoika Thanks for u r reply , So I have Asked to fix issue while connecting keycloak with postgress , actually I have Successfully Connected that .
It will be helpful for me if You tell How to connect Keycloak with postgress Using docker I am trying with Yaml .

[rsoika]

Do you want to connect the Imixs-Workflow engine with your keycloak server?

[rsoika]

@SUFFI986 can you describe your problem a little bit more in detail? Is it a problem within the Keycloak stack or do you have a problem with the Imixs-Workflow engine?

[rsoika]

@SUFFI986 if you like to post in short how you solved the problem this may help other uses caused with this problem.