Connect 4.7 - Configure Data Sources Issue

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Connect 4.7 - Configure Data Sources Issue

edsalvador
Windows Server 2008
Wildfly 8.2.1
Connect 4.7
MySQL 5.1

I installed according to the CONNECT 4.7 instructions.
When I am in Wildfly console and attempt to ADD Datasources:
 - adminguidb_pool  - loads OK and the Test Connection is successful
However, none of the other datasources will load.
I receive the following Error:
Internal Server Error
{
    "outcome" => "failed",
    "failure-description" => "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid",
    "rolled-back" => true

I am using mysql-connector-java-5.1.10.jar and it is deployed.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect 4.7 - Configure Data Sources Issue

Minh
Administrator
Hi
Can you post yr server log?

Thanks,
Minh-Hai Nguyen
CONNECT Product Team Member
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect 4.7 - Configure Data Sources Issue

edsalvador
In reply to this post by edsalvador

2016-09-16 18:40:45,646 INFO  [org.jboss.modules] (main) JBoss Modules version 1.3.3.Final
2016-09-16 18:40:45,927 INFO  [org.jboss.msc] (main) JBoss MSC version 1.2.2.Final
2016-09-16 18:40:46,130 INFO  [org.jboss.as] (MSC service thread 1-3) JBAS015899: WildFly 8.2.1.Final "Tweek" starting
2016-09-16 18:40:46,177 DEBUG [org.jboss.as.config] (MSC service thread 1-3) Configured system properties:
        CLIENT_KEY_ALIAS = gateway
        awt.toolkit = sun.awt.windows.WToolkit
        file.encoding = Cp1252
        file.encoding.pkg = sun.io
        file.separator = \
        java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment
        java.awt.printerjob = sun.awt.windows.WPrinterJob
        java.class.path = C:\wildfly-8.2.1.Final\jboss-modules.jar
        java.class.version = 52.0
        java.endorsed.dirs = C:\JAVA\jre1.8\lib\endorsed
        java.ext.dirs = C:\JAVA\jre1.8\lib\ext;C:\Windows\Sun\Java\lib\ext
        java.home = C:\JAVA\jre1.8
        java.io.tmpdir = C:\Users\ADMINI~1\AppData\Local\Temp\
        java.library.path = C:\JAVA\jre1.8\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Java\jre1.8\bin;C:\Program Files\PostgreSQL\9.3\bin;;C:\wildfly-8.2.1.Final\bin;C:\Program Files\MySQL\MySQL Server 5.1\bin;.
        java.net.preferIPv4Stack = true
        java.runtime.name = Java(TM) SE Runtime Environment
        java.runtime.version = 1.8.0_91-b15
        java.specification.name = Java Platform API Specification
        java.specification.vendor = Oracle Corporation
        java.specification.version = 1.8
        java.util.logging.manager = org.jboss.logmanager.LogManager
        java.vendor = Oracle Corporation
        java.vendor.url = http://java.oracle.com/
        java.vendor.url.bug = http://bugreport.sun.com/bugreport/
        java.version = 1.8.0_91
        java.vm.info = mixed mode
        java.vm.name = Java HotSpot(TM) 64-Bit Server VM
        java.vm.specification.name = Java Virtual Machine Specification
        java.vm.specification.vendor = Oracle Corporation
        java.vm.specification.version = 1.8
        java.vm.vendor = Oracle Corporation
        java.vm.version = 25.91-b15
        javax.management.builder.initial = org.jboss.as.jmx.PluggableMBeanServerBuilder
        javax.net.ssl.keyStore = C:\wildfly-8.2.1.Final/modules/org/connectopensource/configuration/main/gateway.jks
        javax.net.ssl.keyStorePassword = ksc$6457
        javax.net.ssl.keyStoreType = JKS
        javax.net.ssl.trustStore = C:\wildfly-8.2.1.Final/modules/org/connectopensource/configuration/main/cacerts.jks
        javax.net.ssl.trustStorePassword = ksc$6457
        javax.net.ssl.trustStoreType = JKS
        javax.xml.datatype.DatatypeFactory = __redirected.__DatatypeFactory
        javax.xml.parsers.DocumentBuilderFactory = __redirected.__DocumentBuilderFactory
        javax.xml.parsers.SAXParserFactory = __redirected.__SAXParserFactory
        javax.xml.stream.XMLEventFactory = __redirected.__XMLEventFactory
        javax.xml.stream.XMLInputFactory = __redirected.__XMLInputFactory
        javax.xml.stream.XMLOutputFactory = __redirected.__XMLOutputFactory
        javax.xml.transform.TransformerFactory = __redirected.__TransformerFactory
        javax.xml.validation.SchemaFactory:http://www.w3.org/2001/XMLSchema = __redirected.__SchemaFactory
        javax.xml.xpath.XPathFactory:http://java.sun.com/jaxp/xpath/dom = __redirected.__XPathFactory
        jboss.home.dir = C:\wildfly-8.2.1.Final
        jboss.host.name = win-8s13cir5eae
        jboss.modules.dir = C:\wildfly-8.2.1.Final\modules
        jboss.modules.system.pkgs = org.jboss.byteman
        jboss.node.name = win-8s13cir5eae
        jboss.qualified.host.name = win-8s13cir5eae
        jboss.server.base.dir = C:\wildfly-8.2.1.Final\standalone
        jboss.server.config.dir = C:\wildfly-8.2.1.Final\standalone\configuration
        jboss.server.data.dir = C:\wildfly-8.2.1.Final\standalone\data
        jboss.server.deploy.dir = C:\wildfly-8.2.1.Final\standalone\data\content
        jboss.server.log.dir = C:\wildfly-8.2.1.Final\standalone\log
        jboss.server.name = win-8s13cir5eae
        jboss.server.persist.config = true
        jboss.server.temp.dir = C:\wildfly-8.2.1.Final\standalone\tmp
        line.separator =

        logging.configuration = file:C:\wildfly-8.2.1.Final\standalone\configuration/logging.properties
        module.path = C:\wildfly-8.2.1.Final\modules
        nhinc.properties.dir = C:\wildfly-8.2.1.Final/modules/system/layers/base/org/connectopensource/configuration/main
        org.jboss.boot.log.file = C:\wildfly-8.2.1.Final\standalone\log\server.log
        org.jboss.resolver.warning = true
        org.xml.sax.driver = __redirected.__XMLReaderFactory
        os.arch = amd64
        os.name = Windows Server 2008 R2
        os.version = 6.1
        path.separator = ;
        program.name = standalone.bat
        sun.arch.data.model = 64
        sun.boot.class.path = C:\JAVA\jre1.8\lib\resources.jar;C:\JAVA\jre1.8\lib\rt.jar;C:\JAVA\jre1.8\lib\sunrsasign.jar;C:\JAVA\jre1.8\lib\jsse.jar;C:\JAVA\jre1.8\lib\jce.jar;C:\JAVA\jre1.8\lib\charsets.jar;C:\JAVA\jre1.8\lib\jfr.jar;C:\JAVA\jre1.8\classes
        sun.boot.library.path = C:\JAVA\jre1.8\bin
        sun.cpu.endian = little
        sun.cpu.isalist = amd64
        sun.desktop = windows
        sun.io.unicode.encoding = UnicodeLittle
        sun.java.command = C:\wildfly-8.2.1.Final\jboss-modules.jar -mp C:\wildfly-8.2.1.Final\modules -jaxpmodule javax.xml.jaxp-provider org.jboss.as.standalone -Djboss.home.dir=C:\wildfly-8.2.1.Final
        sun.java.launcher = SUN_STANDARD
        sun.jnu.encoding = Cp1252
        sun.management.compiler = HotSpot 64-Bit Tiered Compilers
        sun.os.patch.level = Service Pack 1
        sun.stderr.encoding = cp437
        sun.stdout.encoding = cp437
        user.country = US
        user.dir = C:\wildfly-8.2.1.Final\bin
        user.home = C:\Users\Administrator
        user.language = en
        user.name = Administrator
        user.script =
        user.timezone = America/Chicago
        user.variant =
2016-09-16 18:40:46,177 DEBUG [org.jboss.as.config] (MSC service thread 1-3) VM Arguments: -Dprogram.name=standalone.bat -Xms64M -Xmx512M -XX:MaxPermSize=256M -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Dnhinc.properties.dir=C:\wildfly-8.2.1.Final/modules/system/layers/base/org/connectopensource/configuration/main -Djavax.net.ssl.keyStore=C:\wildfly-8.2.1.Final/modules/org/connectopensource/configuration/main/gateway.jks -Djavax.net.ssl.keyStorePassword=ksc$6457 -Djavax.net.ssl.keyStoreType=JKS -Djavax.net.ssl.trustStore=C:\wildfly-8.2.1.Final/modules/org/connectopensource/configuration/main/cacerts.jks -Djavax.net.ssl.trustStorePassword=ksc$6457 -Djavax.net.ssl.trustStoreType=JKS -DCLIENT_KEY_ALIAS=gateway -Dorg.jboss.boot.log.file=C:\wildfly-8.2.1.Final\standalone\log\server.log -Dlogging.configuration=file:C:\wildfly-8.2.1.Final\standalone\configuration/logging.properties
2016-09-16 18:40:48,610 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)
2016-09-16 18:40:48,735 INFO  [org.xnio] (MSC service thread 1-3) XNIO version 3.3.0.Final
2016-09-16 18:40:48,766 INFO  [org.xnio.nio] (MSC service thread 1-3) XNIO NIO Implementation Version 3.3.0.Final
2016-09-16 18:40:48,797 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
2016-09-16 18:40:48,860 INFO  [org.wildfly.extension.io] (ServerService Thread Pool -- 31) WFLYIO001: Worker 'default' has auto-configured to 4 core threads with 32 task threads based on your 2 available processors
2016-09-16 18:40:49,577 INFO  [org.jboss.remoting] (MSC service thread 1-3) JBoss Remoting version 4.0.7.Final
2016-09-16 18:40:49,593 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 45) JBAS013171: Activating Security Subsystem
2016-09-16 18:40:49,609 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 47) JBAS017502: Undertow 1.1.8.Final starting
2016-09-16 18:40:49,796 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) JBAS017502: Undertow 1.1.8.Final starting
2016-09-16 18:40:49,811 WARN  [org.jboss.as.txn] (ServerService Thread Pool -- 46) JBAS010153: Node identifier property is set to the default value. Please make sure it is unique.
2016-09-16 18:40:49,811 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension
2016-09-16 18:40:49,811 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 40) JBAS011800: Activating Naming Subsystem
2016-09-16 18:40:49,843 INFO  [org.jboss.as.jsf] (ServerService Thread Pool -- 38) JBAS012615: Activated the following JSF Implementations: [main]
2016-09-16 18:40:49,874 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 32) JBAS010280: Activating Infinispan subsystem.
2016-09-16 18:40:49,921 INFO  [org.jboss.as.connector.logging] (MSC service thread 1-3) JBAS010408: Starting JCA Subsystem (IronJacamar 1.1.9.Final)
2016-09-16 18:40:50,482 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) JBAS010417: Started Driver service with driver-name = h2
2016-09-16 18:40:51,059 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 47) JBAS017527: Creating file handler for path C:\wildfly-8.2.1.Final/welcome-content
2016-09-16 18:40:51,449 INFO  [org.jboss.as.naming] (MSC service thread 1-1) JBAS011802: Starting Naming Service
2016-09-16 18:40:51,481 INFO  [org.jboss.as.security] (MSC service thread 1-3) JBAS013170: Current PicketBox version=4.0.21.Final
2016-09-16 18:40:51,496 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-2) JBAS015400: Bound mail session [java:jboss/mail/Default]
2016-09-16 18:40:51,559 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-2) JBAS015012: Started FileSystemDeploymentService for directory C:\wildfly-8.2.1.Final\standalone\deployments
2016-09-16 18:40:51,637 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "mysql-connector-java-5.1.10.jar" (runtime-name: "mysql-connector-java-5.1.10.jar")
2016-09-16 18:40:51,746 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) JBAS017525: Started server default-server.
2016-09-16 18:40:52,042 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) JBAS017531: Host default-host starting
2016-09-16 18:40:52,229 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-3) JBAS017519: Undertow HTTP listener default listening on /127.0.0.1:8080
2016-09-16 18:40:52,229 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) JBAS017519: Undertow HTTPS listener https listening on /127.0.0.1:8181
2016-09-16 18:40:52,385 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
2016-09-16 18:40:53,072 INFO  [org.jboss.ws.common.management] (MSC service thread 1-3) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.3.2.Final
2016-09-16 18:40:53,134 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
2016-09-16 18:40:53,243 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) JBAS010417: Started Driver service with driver-name = mysql-connector-java-5.1.10.jar
2016-09-16 18:40:53,524 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "mysql-connector-java-5.1.10.jar" (runtime-name : "mysql-connector-java-5.1.10.jar")
2016-09-16 18:40:53,758 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management
2016-09-16 18:40:53,789 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
2016-09-16 18:40:53,821 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015874: WildFly 8.2.1.Final "Tweek" started in 8455ms - Started 227 of 286 services (96 services are lazy, passive or on-demand)
2016-09-16 18:42:57,779 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Bound data source [java:/jdbc/auditrepo_datasource]
2016-09-16 18:42:58,653 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (XNIO-1 task-5) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:347) [ironjacamar-jdbc-1.1.9.Final.jar:1.1.9.Final]
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:354) [ironjacamar-jdbc-1.1.9.Final.jar:1.1.9.Final]
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:288) [ironjacamar-jdbc-1.1.9.Final.jar:1.1.9.Final]
        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:1166) [ironjacamar-core-impl-1.1.9.Final.jar:1.1.9.Final]
        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:446) [ironjacamar-core-impl-1.1.9.Final.jar:1.1.9.Final]
        at org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:764) [ironjacamar-core-impl-1.1.9.Final.jar:1.1.9.Final]
        at org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:91) [ironjacamar-core-impl-1.1.9.Final.jar:1.1.9.Final]
        at org.jboss.as.connector.subsystems.common.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:206) [wildfly-connector-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.connector.subsystems.common.pool.PoolOperations$1.execute(PoolOperations.java:87) [wildfly-connector-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:660) [wildfly-controller-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:501) [wildfly-controller-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.controller.AbstractOperationContext.completeStepInternal(AbstractOperationContext.java:298) [wildfly-controller-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:293) [wildfly-controller-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:276) [wildfly-controller-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:150) [wildfly-controller-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.domain.http.server.DomainApiHandler.handleRequest(DomainApiHandler.java:170)
        at org.jboss.as.domain.http.server.security.SubjectDoAsHandler$1.run(SubjectDoAsHandler.java:72)
        at org.jboss.as.domain.http.server.security.SubjectDoAsHandler$1.run(SubjectDoAsHandler.java:68)
        at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0_91]
        at javax.security.auth.Subject.doAs(Unknown Source) [rt.jar:1.8.0_91]
        at org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:94) [wildfly-controller-8.2.1.Final.jar:8.2.1.Final]
        at org.jboss.as.domain.http.server.security.SubjectDoAsHandler.handleRequest(SubjectDoAsHandler.java:68)
        at org.jboss.as.domain.http.server.security.SubjectDoAsHandler.handleRequest(SubjectDoAsHandler.java:63)
        at io.undertow.server.handlers.BlockingHandler.handleRequest(BlockingHandler.java:56)
        at org.jboss.as.domain.http.server.DomainApiCheckHandler.handleRequest(DomainApiCheckHandler.java:83)
        at io.undertow.security.handlers.AuthenticationCallHandler.handleRequest(AuthenticationCallHandler.java:52)
        at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)
        at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:761)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.8.0_91]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.8.0_91]
        at java.lang.Thread.run(Unknown Source) [rt.jar:1.8.0_91]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'auditrepo\n'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_91]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) [rt.jar:1.8.0_91]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) [rt.jar:1.8.0_91]
        at java.lang.reflect.Constructor.newInstance(Unknown Source) [rt.jar:1.8.0_91]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_91]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) [rt.jar:1.8.0_91]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) [rt.jar:1.8.0_91]
        at java.lang.reflect.Constructor.newInstance(Unknown Source) [rt.jar:1.8.0_91]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:322) [ironjacamar-jdbc-1.1.9.Final.jar:1.1.9.Final]
        ... 30 more

2016-09-16 18:42:58,684 ERROR [org.jboss.as.controller.management-operation] (XNIO-1 task-5) JBAS014613: Operation ("test-connection-in-pool") failed - address: ([
    ("subsystem" => "datasources"),
    ("data-source" => "auditrepo_pool")
]) - failure description: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid"
2016-09-16 18:42:58,981 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010409: Unbound data source [java:/jdbc/auditrepo_datasource]
2016-09-16 18:43:30,461 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010409: Unbound data source [java:jboss/datasources/ExampleDS]
2016-09-16 18:43:30,477 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010418: Stopped Driver service with driver-name = mysql-connector-java-5.1.10.jar
2016-09-16 18:43:30,493 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-3) JBAS017532: Host default-host stopping
2016-09-16 18:43:30,508 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) JBAS010418: Stopped Driver service with driver-name = h2
2016-09-16 18:43:30,539 INFO  [org.hibernate.validator.internal.util.Version] (MSC service thread 1-4) HV000001: Hibernate Validator 5.1.3.Final
2016-09-16 18:43:30,539 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) JBAS017521: Undertow HTTP listener default suspending
2016-09-16 18:43:30,680 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-3) JBAS017521: Undertow HTTPS listener https suspending
2016-09-16 18:43:30,711 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-3) JBAS017520: Undertow HTTPS listener https stopped, was bound to /127.0.0.1:8181
2016-09-16 18:43:30,758 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) JBAS017520: Undertow HTTP listener default stopped, was bound to /127.0.0.1:8080
2016-09-16 18:43:30,836 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015877: Stopped deployment mysql-connector-java-5.1.10.jar (runtime-name: mysql-connector-java-5.1.10.jar) in 397ms
2016-09-16 18:43:30,836 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) JBAS017506: Undertow 1.1.8.Final stopping
2016-09-16 18:43:31,054 INFO  [org.jboss.as] (MSC service thread 1-1) JBAS015950: WildFly 8.2.1.Final "Tweek" stopped in 589ms
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect 4.7 - Configure Data Sources Issue

Minh
Administrator
Hi,

According to the log, it seems it can't communicate to audit repo "Unknown database 'auditrepo\n' ". Can you verify if that database exist in mysql and name in standalone.xml?  If possible, can you also post your standalone.xml (<wildfly_location>/standalone/configuration)?  

We currently doing survey and see how we can make CONNECT become better product.  If possible, can you provide the following questions:
1. How do you hear about CONNECT?  Which version are you currently use?  
2. Which organization do you support?

Thanks,
Minh-Hai Nguyen
CONNECT Product Team Member
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect 4.7 - Configure Data Sources Issue

edsalvador
The datasource databases are in MySQL: Here is a copy of standalone.xml: standalone.xml
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect 4.7 - Configure Data Sources Issue

Tabassum
Administrator
In reply to this post by edsalvador
Hi,
Looking at your standalone.xml, it seems that all of your datasource names have an extra linefeed character ('auditrepo\n'), can you please remove that and try again
Thanks
Tabassum
(CONNECT Product Team Member)
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect 4.7 - Configure Data Sources Issue

Minh
Administrator
In reply to this post by edsalvador
I saw your datasource has "\n" at the end of <connection-url>jdbc:mysql://localhost:3306/auditrepo\n</connection-url> .  Please correct those(auditrepo and asyncmsgs) in standalone.xml.  

Thanks
Minh-Hai Nguyen
CONNECT Product Team Member
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connect 4.7 - Configure Data Sources Issue

edsalvador
When I was doing "cut & paste" it was adding the extra line feed.
I successfully Added and Enabled all data sources.

Thanks for your help!
Loading...