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

[Michael Moossen]

Dear Heiko!

This message should only be a warning, you should be able to continue the setup,
isn't?
but, do you really want to use mysql 3.2?? ;)

Kind Regards,
Michael
 
-------------------
Michael Moossen
 
Alkacon Software GmbH  - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org




Quoting Heiko Dotzauer <heiko.dotzauer at gmx.de>:

> 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
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.