soucis de deploiment driver PostGreSql

Version imprimable

Bonjour

Je rencontre un soucis de deploiement du driver PostgreSql sur mon JBOSS JBAS010441:

Mon log

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
 
13:07:56,325 INFO  [org.jboss.modules] (main) JBoss Modules version 1.3.7.Final-redhat-1
13:07:57,271 INFO  [org.jboss.msc] (main) JBoss MSC version 1.1.5.Final-redhat-1
13:07:57,403 INFO  [org.jboss.as] (MSC service thread 1-2) JBAS015899: JBoss EAP 6.4.6.GA (AS 7.5.6.Final-redhat-SNAPSHOT) démarre
13:07:57,410 DEBUG [org.jboss.as.config] (MSC service thread 1-2) Propriétés de système configurées :
	[Standalone] = 
	awt.toolkit = sun.awt.X11.XToolkit
	file.encoding = UTF-8
	file.encoding.pkg = sun.io
	file.separator = /
	java.awt.graphicsenv = sun.awt.X11GraphicsEnvironment
	java.awt.headless = true
	java.awt.printerjob = sun.print.PSPrinterJob
	java.class.path = /usr/local/lib/jboss-eap-6.4/jboss-modules.jar
	java.class.version = 52.0
	java.endorsed.dirs = /usr/java/jdk1.8.0_77/jre/lib/endorsed
	java.ext.dirs = /usr/java/jdk1.8.0_77/jre/lib/ext:/usr/java/packages/lib/ext
	java.home = /usr/java/jdk1.8.0_77/jre
	java.io.tmpdir = /tmp
	java.library.path = /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
	java.net.preferIPv4Stack = true
	java.runtime.name = Java(TM) SE Runtime Environment
	java.runtime.version = 1.8.0_77-b03
	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_77
	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.77-b03
	javax.management.builder.initial = org.jboss.as.jmx.PluggableMBeanServerBuilder
	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 = /usr/local/lib/jboss-eap-6.4
	jboss.host.name = localhost
	jboss.modules.dir = /usr/local/lib/jboss-eap-6.4/modules
	jboss.modules.policy-permissions = true
	jboss.modules.system.pkgs = org.jboss.byteman
	jboss.node.name = localhost
	jboss.qualified.host.name = localhost.localdomain
	jboss.server.base.dir = /usr/local/lib/jboss-eap-6.4/standalone
	jboss.server.config.dir = /usr/local/lib/jboss-eap-6.4/standalone/configuration
	jboss.server.data.dir = /usr/local/lib/jboss-eap-6.4/standalone/data
	jboss.server.deploy.dir = /usr/local/lib/jboss-eap-6.4/standalone/data/content
	jboss.server.log.dir = /usr/local/lib/jboss-eap-6.4/standalone/log
	jboss.server.name = localhost
	jboss.server.persist.config = true
	jboss.server.temp.dir = /usr/local/lib/jboss-eap-6.4/standalone/tmp
	line.separator = 
 
	logging.configuration = file:/usr/local/lib/jboss-eap-6.4/standalone/configuration/logging.properties
	module.path = /usr/local/lib/jboss-eap-6.4/modules
	org.jboss.boot.log.file = /usr/local/lib/jboss-eap-6.4/standalone/log/server.log
	org.jboss.resolver.warning = true
	org.xml.sax.driver = __redirected.__XMLReaderFactory
	os.arch = amd64
	os.name = Linux
	os.version = 3.10.0-327.10.1.el7.x86_64
	path.separator = :
	sun.arch.data.model = 64
	sun.boot.class.path = /usr/java/jdk1.8.0_77/jre/lib/resources.jar:/usr/java/jdk1.8.0_77/jre/lib/rt.jar:/usr/java/jdk1.8.0_77/jre/lib/sunrsasign.jar:/usr/java/jdk1.8.0_77/jre/lib/jsse.jar:/usr/java/jdk1.8.0_77/jre/lib/jce.jar:/usr/java/jdk1.8.0_77/jre/lib/charsets.jar:/usr/java/jdk1.8.0_77/jre/lib/jfr.jar:/usr/java/jdk1.8.0_77/jre/classes
	sun.boot.library.path = /usr/java/jdk1.8.0_77/jre/lib/amd64
	sun.cpu.endian = little
	sun.cpu.isalist = 
	sun.io.unicode.encoding = UnicodeLittle
	sun.java.command = /usr/local/lib/jboss-eap-6.4/jboss-modules.jar -mp /usr/local/lib/jboss-eap-6.4/modules -jaxpmodule javax.xml.jaxp-provider org.jboss.as.standalone -Djboss.home.dir=/usr/local/lib/jboss-eap-6.4 -Djboss.server.base.dir=/usr/local/lib/jboss-eap-6.4/standalone --debug 8787
	sun.java.launcher = SUN_STANDARD
	sun.jnu.encoding = UTF-8
	sun.management.compiler = HotSpot 64-Bit Tiered Compilers
	sun.os.patch.level = unknown
	user.country = FR
	user.dir = /usr/local/lib/jboss-eap-6.4/bin
	user.home = /root
	user.language = fr
	user.name = root
	user.timezone = Europe/Paris
13:07:57,412 DEBUG [org.jboss.as.config] (MSC service thread 1-2) Arguments MV : -D[Standalone] -XX:+UseCompressedOops -verbose:gc -Xloggc:/usr/local/lib/jboss-eap-6.4/standalone/log/gc.log -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=5 -XX:GCLogFileSize=3M -XX:-TraceClassUnloading -Xms1303m -Xmx1303m -XX:MaxPermSize=512m -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true -Djboss.modules.policy-permissions=true -agentlib:jdwp=transport=dt_socket,address=8787,server=y,suspend=n -Dorg.jboss.boot.log.file=/usr/local/lib/jboss-eap-6.4/standalone/log/server.log -Dlogging.configuration=file:/usr/local/lib/jboss-eap-6.4/standalone/configuration/logging.properties 
13:08:01,240 INFO  [org.xnio] (MSC service thread 1-2) XNIO Version 3.0.15.GA-redhat-1
13:08:01,247 INFO  [org.xnio.nio] (MSC service thread 1-2) XNIO NIO Implementation Version 3.0.15.GA-redhat-1
13:08:01,295 INFO  [org.jboss.remoting] (MSC service thread 1-2) JBoss Remoting version 3.3.7.Final-redhat-1
13:08:01,299 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Création d'un service de gestion http à l'aide de socket-binding (management-http)
13:08:01,486 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activation du sous-système Infinispan
13:08:01,545 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 39) JBAS011800: Démarrage du sous-système de nommage
13:08:01,596 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013371: Activation du sous-système de sécurité
13:08:01,597 WARN  [org.jboss.as.txn] (ServerService Thread Pool -- 46) JBAS010153: Propriété d'identificateur de noeud définie à la valeur par défaut. Veillez à ce que cette valeur soit bien unique.
13:08:01,630 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activation de l'extension WebServices
13:08:01,675 INFO  [org.jboss.as.jsf] (ServerService Thread Pool -- 37) JBAS012615: A activé les implémentations JSF suivantes : [main, 1.2]
13:08:01,845 INFO  [org.jboss.as.security] (MSC service thread 1-2) JBAS013370: Version PicketBox actuelle=4.1.2.Final-redhat-1
13:08:02,048 INFO  [org.jboss.as.naming] (MSC service thread 1-2) JBAS011802: Démarrage du service de nommage
13:08:02,161 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Déploiement du pilote compatible JDCB class org.h2.Driver (version 1.3)
13:08:02,164 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-2) JBAS015400: Session Mail liée [java:jboss/mail/Default]
13:08:02,233 INFO  [org.jboss.as.connector.logging] (MSC service thread 1-2) JBAS010408: Démarrage du sous-système JCA (IronJacamar 1.0.35.Final-redhat-1)
13:08:02,294 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 27) JBAS014612: L'opération ("add") a échoué - adresse : ([
    ("subsystem" => "datasources"),
    ("jdbc-driver" => "postgresql")
]) - description de l'échec : "JBAS010441: N'a pas pu charger le module pour le pilote [org.postgresql]"
13:08:02,901 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-1) JBWEB003001: Coyote HTTP/1.1 initializing on : http-/0.0.0.0:8080
13:08:02,965 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-1) JBWEB003000: Coyote HTTP/1.1 starting on: http-/0.0.0.0:8080
13:08:03,230 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Source de données liée [java:jboss/datasources/ExampleDS]
13:08:05,109 INFO  [org.jboss.ws.common.management] (MSC service thread 1-1) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.3.6.Final-redhat-1
13:08:05,171 INFO  [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Écoute sur 0.0.0.0:9999
13:08:05,173 INFO  [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Écoute sur 0.0.0.0:4447
13:08:05,182 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: FileSystemDeploymentService démarré pour le répertoire /usr/local/lib/jboss-eap-6.4/standalone/deployments
13:08:05,424 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015961: L'interface de gestion http écoute sur http://0.0.0.0:9990/management
13:08:05,426 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: La console d'administration écoute sur http://0.0.0.0:9990
13:08:05,427 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss EAP 6.4.6.GA (AS 7.5.6.Final-redhat-SNAPSHOT) a démarré en 11107ms - 152 sur 191 services ont démarré (57 services sont passifs ou à la demande)

Mon standalone.xml

Code:

1
2
3
4
 
<driver name="postgresql" module="org.postgresql">
                        <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
                    </driver>

Mon contenu de modules/system/layers/base/org/postgresql/main

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
<module xmlns="urn:jboss:module:1.1" name="org.postgreql">
 
    <properties>
        <property name="jboss.api" value="unsupported"/>
    </properties>
 
    <resources>
        <resource-root path="postgresql-9.4-1208.jdbc42.jar"/>
        <!-- Insert resources here -->
    </resources>
    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
        <module name="javax.servlet.api" optional="true"/>
    </dependencies>
</module>

le jar postgresql-9.4-1208.jdbc42.jar se trouve dans le meme répertoire

Ou est mon erreur ?
Merci d'avance

Phil

Re

J'ai ajouté le driver en tant que module grace au CLI, désormais j'ai le message

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
Message
 
 
 
 
 Sun Apr 03 19:40:31 GMT+200 2016
Failed to enable jasperserver.war.
 
Unexpected HTTP response: 500
 
Request
{
    "address" => [("deployment" => "jasperserver.war")],
    "operation" => "deploy"
}
 
Response
 
Internal Server Error
{
    "outcome" => "failed",
    "failure-description" => {"JBAS014671: Les services ont échoué" => {
        "jboss.data-source.java:/jdbc/foodmart" => "org.jboss.msc.service.StartException in service jboss.data-source.java:/jdbc/foodmart: JBAS010433: Erreur lors du déploiement du java:/jdbc/foodmart
    Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010432: Impossible de démarrer le ds car il génère plus d'un cf",
        "jboss.data-source.java:/jdbc/jasperserver" => "org.jboss.msc.service.StartException in service jboss.data-source.java:/jdbc/jasperserver: JBAS010433: Erreur lors du déploiement du java:/jdbc/jasperserver
    Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010432: Impossible de démarrer le ds car il génère plus d'un cf",
        "jboss.data-source.java:/jdbc/sugarcrm" => "org.jboss.msc.service.StartException in service jboss.data-source.java:/jdbc/sugarcrm: JBAS010433: Erreur lors du déploiement du java:/jdbc/sugarcrm
    Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010432: Impossible de démarrer le ds car il génère plus d'un cf"
    }},
    "rolled-back" => true
}

04/04/2016, 07h56
ehsavoie

N'y a t il pas un t en trop dans tes noms (surtout pour le jar du driver) car moi j'installe posgresql :)
04/04/2016, 11h12
OButterlin

Citation:

Envoyé par ehsavoie

N'y a t il pas un t en trop dans tes noms (surtout pour le jar du driver) car moi j'installe posgresql :)

Tu dois fatiguer, postgresql existe mais la version sans "t", même notre meilleur ami google ne le trouve pas :mrgreen:
04/04/2016, 11h18
ehsavoie
Nan je suis en vacances ;)
Sinon la partie
Code:

1 2 3 <properties> <property name="jboss.api" value="unsupported"/> </properties>
ne sert à rien

Peut on avoir la configuration de la datasource ? Est elle configurée avec jta=true ? Et si oui y a t il une bonne raison ?

Bonjour

J'ai installé le driver via le CLI, mais dans le WAR généré j'ai

META_INF/context.xml

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
 
<Context path="/jasperserver" reloadable="false">
 
    <!-- maxActive: Maximum number of dB connections in pool. Make sure you
         configure your mysqld max_connections large enough to handle
         all of your db connections. Set to 0 for no limit.
    -->
    <!-- maxIdle: Maximum number of idle dB connections to retain in pool.
         Set to -1 for no limit.  See also the DBCP documentation on this
         and the minEvictableIdleTimeMillis configuration parameter.
     -->
    <!-- maxWait: Maximum time to wait for a dB connection to become available
         in ms, in this example 10 seconds. An Exception is thrown if
         this timeout is exceeded.  Set to -1 to wait indefinitely.
    -->
 
    <!-- Additional properties to consider. Settings for specifying a      -->
    <!-- validation query to help with reconnect/timeout errors.           -->
    <!-- Exact syntax may vary with database type (this tested on mysql.   -->
    <!--                                                                   -->
    <!--   validationQuery="select 1"                                      -->
    <!--   testOnBorrow="true"                                             -->
    <!--   (and add this to url property): &amp;autoReconnectForPools=true -->
 
 
 
    <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="postgres" password="postgres"
        driverClassName="org.postgresql.Driver"
        accessToUnderlyingConnectionAllowed = "true"
        validationQuery="SELECT 1"
        testOnBorrow="true"
        url="jdbc:postgresql://192.168.1.5:5432/jasperserver"
        factory="${tomcatBasicDatasourceFactory}"
         />
 
    <Resource name="jdbc/sugarcrm" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="postgres" password="postgres"
        driverClassName="org.postgresql.Driver"
        accessToUnderlyingConnectionAllowed = "true"
        validationQuery="SELECT 1"
        testOnBorrow="true"
        url="jdbc:postgresql://192.168.1.5:5432/sugarcrm"
        factory="${tomcatBasicDatasourceFactory}"/>
 
    <Resource name="jdbc/foodmart" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="postgres" password="postgres"
        driverClassName="org.postgresql.Driver"
        accessToUnderlyingConnectionAllowed = "true"
        validationQuery="SELECT 1"
        testOnBorrow="true"
        url="jdbc:postgresql://192.168.1.5:5432/foodmart"
        factory="${tomcatBasicDatasourceFactory}"/>
 
    <!-- Comment this line to enable session persistence across Tomcat restarts -->
    <Manager pathname="" />
</Context>

Ce qui me semble BON

Mais Egalemennt foodmartDS-jdbc.xml

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
 
<?xml version='1.0' encoding='UTF-8'?>
<jdbc-data-source xmlns="http://www.bea.com/ns/weblogic/90" xmlns:sec="http://www.bea.com/ns/weblogic/90/security" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wls="http://www.bea.com/ns/weblogic/90/security/wls" xsi:schemaLocation="http://www.bea.com/ns/weblogic/920 http://www.bea.com/ns/weblogic/920.xsd">
  <name>FoodmartDataBase</name>
  <jdbc-driver-params>
    <url>jdbc:mysql://localhost:3306/foodmart</url>
    <driver-name>com.mysql.jdbc.Driver</driver-name>
    <properties>
      <property>
        <name>user</name>
        <value>root</value>
      </property>
    </properties>
    <password-encrypted>password</password-encrypted>
  </jdbc-driver-params>
  <jdbc-connection-pool-params>
    <test-table-name>SQL SELECT 1</test-table-name>
  </jdbc-connection-pool-params>
  <jdbc-data-source-params>
    <jndi-name>FoodmartDataBase</jndi-name>
    <global-transactions-protocol>OnePhaseCommit</global-transactions-protocol>
  </jdbc-data-source-params>
</jdbc-data-source>

idem pour le fichier sugarcrmDS-jdbc.xml

06/04/2016, 08h18
tchize_

je ne pense pas que le context.xml soit une manière supportée de définir tes datasources dans jboss. Comme tu le vois, celles que tu as définies dans ton ds.xml ne génèrent pas d'erreur, seules celles dans ton context.xml en génèrent. Je te conseille de te limiter au ds.xml ou mieux au standalone.xml pour définir tes datasources.
06/04/2016, 20h05
ehsavoie

Oui c'est du spécifique tomcat et j'ai un doute sur le support de variables dans les déclarations (pour la factory)