[SignServer-develop] JDBC problem

[Jordi B. U. <jb...@ne...>]

Hi,

I am trying to install sign server on a freshly installed fedora box. I have followed the install procedure described on the web as close as possible but I am finding problems to deploy the signserver on the app server.

I have installed it on wildfly 10 and mariaDB.

What I am seeing is that there is a problem with the jdbc driver configuration. On the server.xml log I can see this:

2016-05-19 04:26:29,475 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 3) WFLYCTL0013: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("data-source" => "signserverds")
]) - failure description: {"WFLYCTL0180: Services with missing/unavailable dependencies" => [
    "org.wildfly.data-source.signserverds is missing [jboss.jdbc-driver.org_mariadb_jdbc_Driver]",
    "jboss.driver-demander.java:/SignServerDS is missing [jboss.jdbc-driver.org_mariadb_jdbc_Driver]"
]}
2016-05-19 04:26:29,482 INFO  [org.jboss.as.controller] (management-handler-thread - 3) WFLYCTL0183: Service status report
WFLYCTL0184:    New missing/unsatisfied dependencies:
      service jboss.data-source-config.signserverds (missing) dependents: [service org.wildfly.data-source.signserverds]
      service jboss.jdbc-driver.org_mariadb_jdbc_Driver (missing) dependents: [service jboss.driver-demander.java:/SignServerDS, service org.wildfly.data-source.signserverds]


I have created the module.xml file and moved the jar file.

mkdir -p /opt/wildfly-10.0.0.Final/modules/system/layers/base/org/mariadb/main/

cp -P /opt/mariadb-java-client-1.4.4.jar .
vi module.xml

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="org.mariadb">
  <resources>
    <resource-root path="mariadb-java-client-1.4.4.jar"/>
  </resources>
  <dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
  </dependencies>
</module>

I also have run on the jboss-cli the following commands:

/subsystem=datasources/jdbc-driver=com.mysql.jdbc.Driver:add(driver-name=com.mysql.jdbc.Driver,driver-module-name=com.mysql,driver-xa-datasource-class-name=com.mysql.jdbc.jdbc.jdbc2.optional.MysqlXADataSource)
:reload

data-source add --name=signserverds --driver-name="org.mariadb.jdbc.Driver" --connection-url="jdbc:mysql://127.0.0.1:3306/signserver" --jndi-name="java:/SignServerDS" --use-ccm=true --driver-class="org.mariadb.jdbc.Driver" --user-name="xxx" --password="xxx" --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;"

In the Web interface of wildfly I have not seen any reference to this connection.

What I am doing wrong?

Thanks in advance.

   Jordi
________________________________
Jordi Blasi Uribarri
Área I+D+i

jb...@ne...
Oficina Bilbao

[http://www.nextel.es/wp-content/uploads/Firma_Nextel_2015.png]