Re: [SignServer-develop] JDBC problem

[Marcus L. <mar...@pr...>]

ons 2016-05-18 klockan 15:08 +0000 skrev Jordi Blasi Uribarri:
> Hi,
Hi Jordi!

> 
>  
> 
> 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
> 
>  
> 
> 
> 
> 
> 
>   
> 
>     
> 
>   
> 
>   
> 
>     
> 
>     
> 
>   
> 
> 
> 
>  
> 
> 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;"
Did you do a :reload (or restart the application server) after issuing
the "data-source add" command?
//Marcus
>  
> 
> In the Web interface of wildfly I have not seen any reference to this connection.
> 

> 
>  
> 
> What I am doing wrong?
> 
>  
> 
> Thanks in advance.
> 
>  
> 
>    Jordi
> 

> 
> 
> 
<span class="-x-evo-quoted"><span class="-x-evo-quote-character">> </span></span>Documento sin título> 
> 
> Jordi Blasi Uribarri
> 
> Área I+D+i
> 
> 
> jb...@ne...
> 
> Oficina Bilbao
> 
> 




> ------------------------------------------------------------------------------
> Mobile security can be enabling, not merely restricting. Employees who
> bring their own devices (BYOD) to work are irked by the imposition of MDM
> restrictions. Mobile Device Manager Plus allows you to control only the
> apps on BYO-devices by containerizing them, leaving personal data untouched!
> 
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
> _______________________________________________
> SignServer-develop mailing list
> 
Sig...@li...> 
https://lists.sourceforge.net/lists/listinfo/signserver-develop>