[opencms-dev] Error setting up new 6.2.0 opencms - max_allowed_packet variable

[Heiko Dotzauer]

Hello,

using mysql 3.23.58 I get an error proceeding with  step 4 of the setup
Process (see messages below). I set the 'max_allowed_packet'  to 16M in my
my.cnf file. Maybe the problem occurs from the select statement (SELECT
@@max_allowed_packet)?

any help is appreciated!


error-messages:

  OpenCms was not able to detect the value of your 'max_allowed_packet'
variable.

Please, note that it will not be possible for OpenCms to handle files bigger
than this value.

The recommended value for running OpenCms is 16Mb, please change your MySQL
configuration (in your mi.ini or my.cnf file).
     

Error while checking the server configuration!
Error executing SQL statement: SELECT @@max_allowed_packet;
-------------------------------------------
java.sql.SQLException: General error message from server: "Unknown system
variable 'max_allowed_packet'" at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at
com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) at
com.mysql.jdbc.Connection.execSQL(Connection.java:2244) at
com.mysql.jdbc.Connection.execSQL(Connection.java:2192) at
com.mysql.jdbc.Statement.executeQuery(Statement.java:1163) at
org.opencms.setup.CmsSetupDb.checkVariables(CmsSetupDb.java:295) at
org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp._jspService(org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp:75)
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: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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:744) at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:674)
at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:866)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------

-- 
GMX Produkte empfehlen und ganz einfach Geld verdienen!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner