[opencms-dev] Re: installing under debian

[Christoph P. Kukulies]

On Wed, Apr 12, 2006 at 05:40:02PM +0200, Thomas März wrote:
> "Christoph P. Kukulies" <kuku at physik.rwth-aachen.de> writes:
> 
> > I'm installing OpenCms 6.2.0 under Debian Linux currently and got
> 
> Does this help?
> 
> http://article.gmane.org/gmane.comp.cms.opencms.devel/14091/match=skip+networking

As already said, this didn't help. I now got a bit further.
In /etc/hosts I changed the line 

127.0.0.1 localhost.localdomain localhost

into

127.0.0.1 localhost

because I recalled this being nonsense causing all kinds of trouble.

After restarting mysql and tomcat I now got a bit further and got the double error window
with an error on creating database: (Sorry for the longish line)

 	    	

Database could not be created!
Error executing SQL statement: CREATE DATABASE opencms DEFAULT CHARACTER SET utf8
-------------------------------------------
java.sql.SQLException: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) at com.mysql.jdbc.Statement.execute(Statement.java:529) at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:514) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:420) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:484) at org.opencms.setup.CmsSetupDb.createDatabase(CmsSetupDb.java:118) at org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(step_005f5_005fdatabase_005fcreation_jsp.java:271) 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:332) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) 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:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) 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)
-------------------------------------------
 
Creating tables ...
	   	

Tables could not be created!
Error connecting to database using: "jdbc:mysql://localhost:3306/opencms".
-------------------------------------------
java.sql.SQLException: Unknown database 'opencms' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1229) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558) at com.mysql.jdbc.Connection.(Connection.java:1485) at




Clueless on this also.

--
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de