RE: Problem Installing 4.05 (MySQL setup, error)
Michel Romy <[email protected]>
| Newsgroups | gmane.comp.cms.jahia.install |
|---|---|
| Message-ID | <[email protected]> |
Hi Christopher, MySQL 4.1 seems to have changed the way it counts the number of bytes in a primary key or in an index, and some of the primary keys defined in the mysql scripts are now too long for MySQL 4.1. This problem may also appear when migrating from MySQL 4.0 to MySQL 4.1 . Here is an entry in the FAQ that provide ALTER TABLE statements to change the size of some fields to prevent problem. The initialisation script has also been changed in the CVS and will be provided with the 4.0.6 version. In the meantime, you can replace the script provided with 4.0.5 with this one : http://cvspub.jahia.org/cgi-bin/cvsweb.cgi/~checkout~/jahia/var/db/Attic/mysql.script?rev=1.42.2.3;content-type=text%2Fplain;only_with_tag=JAHIA-4-0-BRANCH . MySQL driver has also been replaced for 4.0.6 as indeed it was producing errors during installation wizard. Michel >I spoke too soon. While this fixes the problem where a connection cannot be >established, the installation's MySQL scripts do not function properly. You >get an error: > >"Specified key was too long; max key length is 1000 bytes" or that >"jahia_db_text already exists" (note that in the latter, you can delete all >tables, go back a page so the scripts re-run and the "already exists" error >will not repeat. However, the former error is consistent.) > >Details: > >Mar 31, 2005 10:22:02 PM org.apache.coyote.http11.Http11Protocol init >INFO: Initializing Coyote HTTP/1.1 on http-8080 >Starting service Tomcat-Standalone >Apache Tomcat/4.1.31 >Mar 31, 2005 10:22:07 PM org.apache.struts.util.PropertyMessageResources ><init> >INFO: Initializing, config='org.apache.struts.util.LocalStrings', >returnNull=true >Mar 31, 2005 10:22:07 PM org.apache.struts.util.PropertyMessageResources ><init> >INFO: Initializing, config='org.apache.struts.action.ActionResources', >returnNull=true >Mar 31, 2005 10:22:09 PM org.apache.struts.util.PropertyMessageResources ><init> >INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', >returnNull=true > 0 [main] INFO - Initializing, >config='org.apache.struts.util.LocalStrings', returnNull=true > 0 [main] INFO - Initializing, >config='org.apache.struts.action.ActionResources', returnNull=true > 922 [main] INFO - Initializing, config='ApplicationResources', >returnNull=true > 1375 [main] INFO - Tiles definition factory loaded for module ''. > > > > > ____. > __/\ ______| |__/\. _______ > __ .____| | \ | +----+ \ > _______| /--| | | - \ _ | : - \_________ > \\______: :---| : : | : | \________> > |__\---\_____________:______: :____|____:_____\ > /_____| > > . . . s t a r t i n g j a h i a b u i l d 6 0 2 0 . . . > > > Copyright 2002-2004 - jahia http://www.jahia.org - all rights reserved > > > ************************************************************************** > * The contents of this file, or the files included with this file, are * > * subject to the current version of JAHIA Community Source License for * > * the Jahia Portal Server (the "License"); You may not use this file * > * except in compliance with the License. You may obtain a copy of the * > * License at http://www.jahia.org. See the License for the rights, * > * obligations and limitations governing use of the contents of the file. * > * The Original and Upgraded Code is the Jahia Portal Server. The * > * developer of the Original and Upgraded Code is JAHIA Ltd. JAHIA Ltd. * > * owns the copyrights in the portions it created. All Rights Reserved. * > ************************************************************************** > > > >Mar 31, 2005 10:22:22 PM org.apache.coyote.http11.Http11Protocol start >INFO: Starting Coyote HTTP/1.1 on http-8080 >Mar 31, 2005 10:22:22 PM org.apache.jk.common.ChannelSocket init >INFO: JK2: ajp13 listening on /0.0.0.0:8009 >Mar 31, 2005 10:22:22 PM org.apache.jk.server.JkMain start >INFO: Jk running ID=0 time=0/109 >config=E:\jahia\tomcat\.\conf\jk2.properties > 53923 [http-8080-Processor4] ERROR - Error while trying to execute query : >CREATE TABLE jahia_db_test (testfield varchar(255)); from script > E:\jahia\tomcat\webapps\jahia\WEB-INF\var\db\mysql.script > 70298 [http-8080-Processor4] ERROR - Error while trying to execute query : >CREATE TABLE jahia_grp_prop (id_jahia_grp mediumint(9) NOT NULL, >name_jahia_grp_prop varchar(255) BINARY NOT NULL,value_jahia_grp_prop >varchar(255),provider_jahia_grp_prop varchar(50) NOT NULL, grpkey_jahi >a_grp_prop varchar(50) NOT NULL, PRIMARY KEY >(id_jahia_grp,name_jahia_grp_prop,provider_jahia_grp_prop,grpkey_jahia_grp_p >rop)); from script >E:\jahia\tomcat\webapps\jahia\WEB-INF\var\db\mysql.script > > > >-----Original Message----- >From: Christopher Kelley [mailto:[email protected]] >Sent: Thursday, March 31, 2005 8:01 PM >To: [email protected] >Subject: RE: Problem Installing 4.05 (MySQL setup, error) > >Solved by removing the Jahia-included MySQL driver and replacing it with the >latest MySQL driver. > >-----Original Message----- >From: Christopher Kelley [mailto:[email protected]] >Sent: Thursday, March 31, 2005 7:38 PM >To: [email protected] >Subject: Problem Installing 4.05 (MySQL setup, error) > >When setting up Jahia using the included wizard, when configuring the MySQL >DB connection, I get this error (I used the default URL w/o luck, specified >the port w/o luck): > >Error while connecting to the database with >url=[jdbc:mysql://localhost:3306/jahia] user=[jahia] password=[XXXXXXX]: >Communication link failure: java.io.IOException, underlying cause: >Unexpected end of input stream ** BEGIN NESTED EXCEPTION ** >java.io.IOException MESSAGE: Unexpected end of input stream STACKTRACE: >java.io.IOException: Unexpected end of input stream at >com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1080) at >com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:619) at >com.mysql.jdbc.Connection.createNewIO(Connection.java:1532) at >com.mysql.jdbc.Connection.(Connection.java:486) at >com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:326) >at java.sql.DriverManager.getConnection(DriverManager.java:512) at >java.sql.DriverManager.getConnection(DriverManager.java:171) at >org.jahia.admin.database.DatabaseConnection.databaseOpen(DatabaseConnection. >java:240) at >org.jahia.admin.database.DatabaseConnection.databaseTest(DatabaseConnection. >java:113) at >org.jahia.bin.JahiaConfigurationWizard.testDBConnection(JahiaConfigurationWi >zard.java:1558) at >org.jahia.bin.JahiaConfigurationWizard.processAdvSettings(JahiaConfiguration >Wizard.java:890) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >Method) at >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 >) at >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl >.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at >org.jahia.utils.ActionHandler.call(ActionHandler.java:126) at >org.jahia.bin.JahiaConfigurationWizard.dispatcher(JahiaConfigurationWizard.j >ava:390) at >org.jahia.bin.JahiaConfigurationWizard.service(JahiaConfigurationWizard.java >:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application >FilterChain.java:200) at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh >ain.java:146) at >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja >va:209) at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok >eNext(StandardPipeline.java:596) at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) >at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja >va:144) at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok >eNext(StandardPipeline.java:596) at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) >at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at >org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) >at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133 >) at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok >eNext(StandardPipeline.java:596) at >org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. >java:118) at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok >eNext(StandardPipeline.java:594) at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116 >) at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok >eNext(StandardPipeline.java:594) at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) >at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java >:127) at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok >eNext(StandardPipeline.java:596) at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) >at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at >org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at >org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) >at >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne >ction(Http11Protocol.java:705) at >org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) >at >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav >a:683) at java.lang.Thread.run(Thread.java:534) ** END NESTED EXCEPTION * > >Ideas?