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?
