<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Here is the text, it consists of two parts, can you handle it?<br>
<br>
<pre class="moz-signature" cols="72">Willem van Loenen
</pre>
<p style="margin-bottom: 4px;">Database could not be created!</p>
Error executing SQL statement: CREATE DATABASE opencms<br>
-------------------------------------------<br>
java.sql.SQLException: General error message from server: "Can't create
database 'opencms'; database exists" at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at
com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) at
com.mysql.jdbc.Connection.execSQL(Connection.java:2244) at
com.mysql.jdbc.Connection.execSQL(Connection.java:2192) at
com.mysql.jdbc.Statement.execute(Statement.java:906) at
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:454) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:363) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:426) at
org.opencms.setup.CmsSetupDb.createDatabase(CmsSetupDb.java:117) 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(Unknown Source)<br>
<br>
<p style="margin-bottom: 4px;">Tables could not be created!</p>
Error connecting to database using:
"jdbc:mysql://localhost:3306/opencms".<br>
-------------------------------------------<br>
java.sql.SQLException: Invalid authorization specification message from
server: "Access denied for user 'admin'@'localhost' (using password:
YES)" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906) at
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2520) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:817) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1782) at
com.mysql.jdbc.Connection.(Connection.java:450) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(Unknown Source) at
java.sql.DriverManager.getConnection(Unknown Source) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:266) 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(Unknown Source)
<br>
-------------------------------------------<br>
Error parsing database setup SQL script in line: ) ENGINE = MYISAM
CHARACTER SET utf8;<br>
-------------------------------------------<br>
java.lang.NullPointerException
at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:456)
at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:363) at
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:426) at
org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:142) 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(Unknown Source)
<pre class="moz-signature" cols="72">
</pre>
<br>
<br>
Joe Desbonnet schreef:
<blockquote cite="mid1cef3e95050716073476f93840@mail.gmail.com"
 type="cite">
  <pre wrap="">Can you post the text of the error?
Thanks,
Joe.

On 7/16/05, Willem <a class="moz-txt-link-rfc2396E" href="mailto:willem.vl@hccnet.nl"><willem.vl@hccnet.nl></a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Hello,
I am installing OpenCms 5.0 server and have a problem I can't solve by
my self.

I am working on windowsXP plaform
The following software is succesfully installed.
--Java 2SDK version 1.4.2_08
--Tomcat 5.59 server
-- Mysql 4.1
-- unpacking the opencms.war file

After that, I moved the opencms map to ..\webapps\root
and started in my browser: <a class="moz-txt-link-freetext" href="http://localhost:8080/opencms/setup/index.jsp">http://localhost:8080/opencms/setup/index.jsp</a>
For the firts time I did create a database 'opencms' but could not
create the tables

Now when I am running the setup again the database and tables are giving
errors.

What should I do? I hope somebody can help me?

Willem van Loenen



_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
<a class="moz-txt-link-freetext" href="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</a>

    </pre>
  </blockquote>
  <pre wrap=""><!---->

_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
<a class="moz-txt-link-freetext" href="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</a>



  </pre>
</blockquote>
</body>
</html>