Installation OpenCMS mit MySQL

[acky]

hi,
versuche verzweifelt openCMS 6.0 mit mysql zu installieren.
bleibe immer an der stelle (s. anhang) hängen - und erhalte folgende fehlermeldung.
hab auch nicht so viel ahnung von dieser materie.
tomcat läuft sicher - das setup openCMS bekomm ich ja auch immerhin zu starten.
wie ich mit mysql diesbzgl. umzugehen habe, ist eher kritisch ...

kann mir jemand tipps geben, was ich noch checken kann?!

danke,
acky


p.s.: hab von fast allen installationschritten openCMS und mysql screenshots gemacht - falls dies im detail zur hilfestellung von vorteil ist ...

Tables could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/opencms
-------------------------------------------
java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user 'opencms'@'localhost' (using password: NO)" 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: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(Unknown Source) 
-------------------------------------------
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(Unknown Source) 
-------------------------------------------

 

[chrisbo]

Hey Acky,

wahrscheinlich hast Du das Problem schon längst gelöst, aber für andere, die auf dieses Problem stoßen:

Es sieht so aus, als ob in mysql der Benutzer mit dem Namen "opencms" nicht existiert oder ein anderes Passwort als das von Dir angegebene "blank" hat.

Du hast 2 Möglichkeiten:

1. Du legst den Benutzer opencms an oder änderst das Passwort
2. Du benutzt im OpenCMS-Datenbank-Setup einen bestehenden Benutzer. Für eine Entwicklerdatenbank wirds der Nutzer "root" tun, in einer Prduktionsdatenbank ist natürlich ein eigener Nutzer notwendig.

Viel Erfolg!
Chris