Logo GNT
Actualités Tests & Guides Bons Plans
GTA 6 iPhone 17 Copilot Switch 2 Temu ChatGPT Tesla
OVH Cloud OVH Cloud
Entraide Développement Développement Langage Java [debutant] jdbc et opencms sur tomcat linux

[debutant] jdbc et opencms sur tomcat linux

1 réponse
Avatar
HelloMan
bonjour

j'ai besoin de votre aide pour l'installation de opencms sur un poste linux

caractéristiques du système:

* Mandrake linux 10.2, toutes updates faites
* Apache Tomcat/5.5.9 installé à partir du .tgz, lancé, OK fonctionne sur le
port 8080 pas de problème, page d'accueil tomcat dans /usr/local/tomcat
* jdk-1_5_0_02-linux-i586.bin, OK pas de problème dans /usr:local/java
* MySQL-4.1.11-1mdk fonctionne OK pour des tas d'autres services en php.
* mysql-connector-java-3.1.8a.tar.gz dont le fichier extrait
mysql-connector-java-3.1.8.bin.jar a été copié
vers /usr/local/java/lib/jdbc.jar
* Variables d'environnement de /etc/profile:
(...)
export JAVA_HOME="/usr/local/java"
export TOMCAT_HOME="/usr/local/tomcat"
export CATALINA_HOME="/usr/local/tomcat"
export
CLASSPATH="/usr/local/java/lib/tools.jar:/usr/local/java/lib/jdbc.jar"
(...)


voilà, au moment du setup de opencms, il m'est impossible de passer l'étape
de création de la base de données; à chaque fois, sur la page suivante:

http://localhost:8080/opencms/setup/database/mysql_41/step_4_database_setup.jsp

je selectionne une base de données en mysql 4.1.x, je lui donne les
login/passwd avec droits de création de nouvelles bases de données, l'url
du serveur(en l'occurence 'localhost, port 3306)
la chaine de connection à la bdd est jdbc:mysql://localhost:3306/
et là, cela plante à chaque fois; j'ai DEUX messages d'erreur à la création
de la base de données et à la création des tables.

CREATING DATABASE:
Database could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/
-------------------------------------------
java.sql.SQLException: Unable to connect to any hosts due to exception:
java.net.ConnectException: Connection refused ** BEGIN NESTED EXCEPTION **
java.net.ConnectException MESSAGE: Connection refused STACKTRACE:
java.net.ConnectException: Connection refused at
java.net.PlainSocketImpl.socketConnect(Native Method) at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:364) at
java.net.Socket.connect(Socket.java:507) at
java.net.Socket.connect(Socket.java:457) at java.net.Socket
(Socket.java:365) at java.net.Socket.(Socket.java:178) at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:124)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:225) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1779) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:106)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1847) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:106)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------
Error parsing database setup SQL script in line: CREATE DATABASE
${database};
-------------------------------------------
java.lang.NullPointerException at
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:407) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:331) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:266) at
org.opencms.setup.CmsSetupDb.createDatabase(CmsSetupDb.java:160) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:276)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------

et
CREATING TABLES

Tables could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/opencms
-------------------------------------------
java.sql.SQLException: Unable to connect to any hosts due to exception:
java.net.ConnectException: Connection refused ** BEGIN NESTED EXCEPTION **
java.net.ConnectException MESSAGE: Connection refused STACKTRACE:
java.net.ConnectException: Connection refused at
java.net.PlainSocketImpl.socketConnect(Native Method) at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:364) at
java.net.Socket.connect(Socket.java:507) at
java.net.Socket.connect(Socket.java:457) at java.net.Socket
(Socket.java:365) at java.net.Socket.(Socket.java:178) at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:124)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:225) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1779) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:340)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1847) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:340)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------
Error parsing database setup SQL script in line: ) ENGINE = MYISAM CHARACTER
SET utf8;
-------------------------------------------
java.lang.NullPointerException at
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:407) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:331) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:266) at
org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:183) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:350)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------



merci de votre secours
Signaler un problème avec ce contenu

1 réponse

Supprimer
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire

Veuillez sélectionner un problème

Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Avatar
joos
Hi, I think I have the answer to your problem:

There is an error in the manual. Before createing the opencms database
and tables, the user "opencms" has to be created:

1. make sure you use the root user

2. Go to your mysql shell, log in as root user and do teh follwing:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'opencms'@'localhost' IDENTIFIED
BY '' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.08 sec)

This creates the user opencms.

The creation of your tables should work now.
Good luck,
Cheers -

Joos




HelloMan schrieb:
bonjour

j'ai besoin de votre aide pour l'installation de opencms sur un poste lin ux

caractéristiques du système:

* Mandrake linux 10.2, toutes updates faites
* Apache Tomcat/5.5.9 installé à partir du .tgz, lancé, OK fonction ne sur le
port 8080 pas de problème, page d'accueil tomcat dans /usr/local/tomcat
* jdk-1_5_0_02-linux-i586.bin, OK pas de problème dans /usr:local/java
* MySQL-4.1.11-1mdk fonctionne OK pour des tas d'autres services en php.
* mysql-connector-java-3.1.8a.tar.gz dont le fichier extrait
mysql-connector-java-3.1.8.bin.jar a été copié
vers /usr/local/java/lib/jdbc.jar
* Variables d'environnement de /etc/profile:
(...)
export JAVA_HOME="/usr/local/java"
export TOMCAT_HOME="/usr/local/tomcat"
export CATALINA_HOME="/usr/local/tomcat"
export
CLASSPATH="/usr/local/java/lib/tools.jar:/usr/local/java/lib/jdbc.jar"
(...)


voilà, au moment du setup de opencms, il m'est impossible de passer l' étape
de création de la base de données; à chaque fois, sur la page suiva nte:

http://localhost:8080/opencms/setup/database/mysql_41/step_4_database_set up.jsp

je selectionne une base de données en mysql 4.1.x, je lui donne les
login/passwd avec droits de création de nouvelles bases de données, l 'url
du serveur(en l'occurence 'localhost, port 3306)
la chaine de connection à la bdd est jdbc:mysql://localhost:3306/
et là, cela plante à chaque fois; j'ai DEUX messages d'erreur à la création
de la base de données et à la création des tables.

CREATING DATABASE:
Database could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/
-------------------------------------------
java.sql.SQLException: Unable to connect to any hosts due to exception:
java.net.ConnectException: Connection refused ** BEGIN NESTED EXCEPTION **
java.net.ConnectException MESSAGE: Connection refused STACKTRACE:
java.net.ConnectException: Connection refused at
java.net.PlainSocketImpl.socketConnect(Native Method) at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:364) at
java.net.Socket.connect(Socket.java:507) at
java.net.Socket.connect(Socket.java:457) at java.net.Socket
(Socket.java:365) at java.net.Socket.(Socket.java:178) at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:1 24)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:225) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1779) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService (org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:106)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.jav a:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:29 1)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat ionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte rChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve .java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve .java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j ava:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14 8)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo nnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint. java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowe rWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool. java:684)
at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1847) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService (org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:106)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.jav a:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:29 1)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat ionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte rChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve .java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve .java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j ava:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14 8)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo nnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint. java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowe rWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool. java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------
Error parsing database setup SQL script in line: CREATE DATABASE
${database};
-------------------------------------------
java.lang.NullPointerException at
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:407) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:331) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:266) at
org.opencms.setup.CmsSetupDb.createDatabase(CmsSetupDb.java:160) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService (org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:276)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.jav a:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:29 1)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat ionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte rChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve .java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve .java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j ava:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14 8)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo nnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint. java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowe rWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool. java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------

et
CREATING TABLES

Tables could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/opencms
-------------------------------------------
java.sql.SQLException: Unable to connect to any hosts due to exception:
java.net.ConnectException: Connection refused ** BEGIN NESTED EXCEPTION **
java.net.ConnectException MESSAGE: Connection refused STACKTRACE:
java.net.ConnectException: Connection refused at
java.net.PlainSocketImpl.socketConnect(Native Method) at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:364) at
java.net.Socket.connect(Socket.java:507) at
java.net.Socket.connect(Socket.java:457) at java.net.Socket
(Socket.java:365) at java.net.Socket.(Socket.java:178) at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:1 24)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:225) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1779) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService (org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:340)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.jav a:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:29 1)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat ionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte rChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve .java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve .java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j ava:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14 8)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo nnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint. java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowe rWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool. java:684)
at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1847) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService (org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:340)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.jav a:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:29 1)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat ionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte rChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve .java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve .java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j ava:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14 8)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo nnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint. java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowe rWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool. java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------
Error parsing database setup SQL script in line: ) ENGINE = MYISAM CHAR ACTER
SET utf8;
-------------------------------------------
java.lang.NullPointerException at
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:407) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:331) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:266) at
org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:183) at
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService (org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:350)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.jav a:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:29 1)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat ionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte rChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve .java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve .java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j ava:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14 8)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo nnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint. java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowe rWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool. java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------



merci de votre secours