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?
