Hi, am trying to onboard an application with MySQL database collector. I am getting an sql exception saying driver not found. Referred the "Steps for configuring database driver for MySQL database" section unable to find the path mentioned in that section (For Wildfly :- /tmp/repackaged/aveksa.ear/APP-INF/lib). I am running Version 7.0.0.93958 with Wildfly v8.2.
Can anyone please specify where to place the .jar file for MySQL collector to work?
I have a document on how to do this- let me get that posted here and i'll share the link.
There are really 2 ways, the first is to use the process outlined in this document:
https://community.rsa.com/docs/DOC-57984
The idea here is that you're doing the equivalent action that you used to take in JBOSS 4.
Alternatively, it's also possible to follow the instructions on page 148 of the 7.0 installation guide to modify/customize the aveksa.ear file, which will also do what you want (you can put the jdbc jar file in there for deployment).
Hi Daniel,@
Thank you for your inputs. I have followed your document and has performed the below iwth mySQL jar "mysql-connector-java-5.1.39-bin.jar"
module.xml:
/home/oracle/wildfly/standalone/configuration/aveksa-standalone-full.xml:
After restarting the L&G services getting the below error. (Attached the stdout.log file for reference)
rsavia7:/home/oracle/wildfly/standalone/log # cat stdout.log
JAVA_OPTS already set in environment; overriding default settings with values: -Xmx1024m -XX:MaxPermSize=256M -Dcom.sun.net.ssl.enableECC=false -Djava.awt.headless=true -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/home/oracle
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /home/oracle/wildfly
JAVA: /etc/alternatives/java_sdk_1.7.0/bin/java
JAVA_OPTS: -server -Xmx1024m -XX:MaxPermSize=256M -Dcom.sun.net.ssl.enableECC=false -Djava.awt.headless=true -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/home/oracle
=========================================================================
23:20:25,736 INFO [org.jboss.modules] (main) JBoss Modules version 1.3.3.Final
23:20:26,735 INFO [org.jboss.msc] (main) JBoss MSC version 1.2.2.Final
23:20:27,108 INFO [org.jboss.as] (MSC service thread 1-2) JBAS015899: WildFly 8.2.0.Final "Tweek" starting
23:20:28,475 ERROR [org.jboss.as.server] (Controller Boot Thread) JBAS015956: Caught exception during boot: org.jboss.as.controller.persistence.ConfigurationPersistenceException: JBAS014676: Failed to parse configuration
at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:112) [wildfly-controller-8.2.0.Final.jar:8.2.0.Final]
at org.jboss.as.server.ServerService.boot(ServerService.java:331) [wildfly-server-8.2.0.Final.jar:8.2.0.Final]
at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:259) [wildfly-controller-8.2.0.Final.jar:8.2.0.Final]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]
Caused by: javax.xml.stream.XMLStreamException: org.jboss.as.connector.util.ParserException: IJ010061: Unexpected element: driver
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:637)
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:193)
at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:110) [staxmapper-1.1.0.Final.jar:1.1.0.Final]
at org.jboss.staxmapper.XMLExtendedStreamReaderImpl.handleAny(XMLExtendedStreamReaderImpl.java:69) [staxmapper-1.1.0.Final.jar:1.1.0.Final]
at org.jboss.as.server.parsing.StandaloneXml.parseServerProfile(StandaloneXml.java:1131) [wildfly-server-8.2.0.Final.jar:8.2.0.Final]
at org.jboss.as.server.parsing.StandaloneXml.readServerElement_1_4(StandaloneXml.java:458) [wildfly-server-8.2.0.Final.jar:8.2.0.Final]
at org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:145) [wildfly-server-8.2.0.Final.jar:8.2.0.Final]
at org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:107) [wildfly-server-8.2.0.Final.jar:8.2.0.Final]
at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:110) [staxmapper-1.1.0.Final.jar:1.1.0.Final]
at org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:69) [staxmapper-1.1.0.Final.jar:1.1.0.Final]
at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:104) [wildfly-controller-8.2.0.Final.jar:8.2.0.Final]
... 3 more
Caused by: org.jboss.as.connector.util.ParserException: IJ010061: Unexpected element: driver
at org.jboss.as.connector.subsystems.datasources.DsParser.parseDriver(DsParser.java:313)
at org.jboss.as.connector.subsystems.datasources.DsParser.parseDataSources(DsParser.java:214)
at org.jboss.as.connector.subsystems.datasources.DsParser.parse(DsParser.java:173)
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:628)
... 13 more
23:20:28,488 FATAL [org.jboss.as.server] (Controller Boot Thread) JBAS015957: Server boot has failed in an unrecoverable manner; exiting. See previous messages for details.
23:20:28,518 INFO [org.jboss.as] (MSC service thread 1-1) JBAS015950: WildFly 8.2.0.Final "Tweek" stopped in 5ms
If you look close at your aveksa-standalone.xml file... it looks like you didn't close out your new <driver> tag.
Oops I am so sorry. Corrected and it worked. Thanks a ton
If you look close at your aveksa-standalone.xml file... it looks like you didn't close out your new <driver> tag.