<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.6.2">
</HEAD>
<BODY>
Hi Michael,<BR>
<BR>
My problem seems to have been solved when I set it at 17MB.<BR>
<BR>
Currently importing modules...<BR>
<BR>
Thank-you very much,<BR>
<BR>
Sincerely,<BR>
<BR>
Chintan Zaveri.<BR>
<BR>
On Tue, 2006-02-28 at 14:41 +0100, Michael Moossen wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Hi, Chintan!</FONT>
<FONT COLOR="#000000">I think this is a detail problem related to the definition of 16Mb, try to set</FONT>
<FONT COLOR="#000000">your db param to something bigger, ie. 17Mb...</FONT>
<FONT COLOR="#000000">Kind Regards,</FONT>
<FONT COLOR="#000000">Michael</FONT>
<FONT COLOR="#000000"> </FONT>
<FONT COLOR="#000000">-------------------</FONT>
<FONT COLOR="#000000">Michael Moossen</FONT>
<FONT COLOR="#000000"> </FONT>
<FONT COLOR="#000000">Alkacon Software GmbH - The OpenCms Experts</FONT>
<FONT COLOR="#000000"><A HREF="http://www.alkacon.com">http://www.alkacon.com</A> - <A HREF="http://www.opencms.org">http://www.opencms.org</A></FONT>
<FONT COLOR="#000000">Quoting Chintan Zaveri <<A HREF="mailto:smile@sis.net.in">smile@sis.net.in</A>>:</FONT>
<FONT COLOR="#000000">> Hello All,</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> I just joined this mailing list, since I am planning to use OpenCms and</FONT>
<FONT COLOR="#000000">> have been facing a few limitations due to my inadequate acquaintance</FONT>
<FONT COLOR="#000000">> with Java / MySQL / OpenCms.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Here is the first problem which I have faced while trying to install</FONT>
<FONT COLOR="#000000">> OpenCms on CentOS 4.2 with mySQL 4.0.25 and Tomcat 5.5.15. I am</FONT>
<FONT COLOR="#000000">> attaching a snapshot of the screen, alongwith.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Validating Database Server Configuration</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> MySQL system variable 'max_allowed_packet' is set to 16776192 Bytes.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Please, note that it will not be possible for OpenCms to handle files</FONT>
<FONT COLOR="#000000">> bigger than this value.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> The recommended value for running OpenCms is 16Mb, please change your</FONT>
<FONT COLOR="#000000">> MySQL configuration (in your mi.ini or my.cnf file).</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> To resolve this issue, I checked the /etc/my.cnf file which looks as</FONT>
<FONT COLOR="#000000">> below:</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> [mysqld]</FONT>
<FONT COLOR="#000000">> datadir=/var/lib/mysql</FONT>
<FONT COLOR="#000000">> socket=/var/lib/mysql/mysql.sock</FONT>
<FONT COLOR="#000000">> skip-locking</FONT>
<FONT COLOR="#000000">> query_cache_limit=1M</FONT>
<FONT COLOR="#000000">> query_cache_size=32M</FONT>
<FONT COLOR="#000000">> query_cache_type=1</FONT>
<FONT COLOR="#000000">> max_connections=500</FONT>
<FONT COLOR="#000000">> interactive_timeout=100</FONT>
<FONT COLOR="#000000">> wait_timeout=100</FONT>
<FONT COLOR="#000000">> connect_timeout=10</FONT>
<FONT COLOR="#000000">> thread_cache_size=128</FONT>
<FONT COLOR="#000000">> key_buffer=16M</FONT>
<FONT COLOR="#000000">> join_buffer=1M</FONT>
<FONT COLOR="#000000">> max_allowed_packet=16M</FONT>
<FONT COLOR="#000000">> table_cache=1024</FONT>
<FONT COLOR="#000000">> record_buffer=1M</FONT>
<FONT COLOR="#000000">> sort_buffer_size=2M</FONT>
<FONT COLOR="#000000">> read_buffer_size=2M</FONT>
<FONT COLOR="#000000">> max_connect_errors=10</FONT>
<FONT COLOR="#000000">> thread_concurrency=2</FONT>
<FONT COLOR="#000000">> myisam_sort_buffer_size=64M</FONT>
<FONT COLOR="#000000">> log-bin</FONT>
<FONT COLOR="#000000">> server-id=1</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> [mysql.server]</FONT>
<FONT COLOR="#000000">> user=mysql</FONT>
<FONT COLOR="#000000">> basedir=/var/lib</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> [safe_mysqld]</FONT>
<FONT COLOR="#000000">> err-log=/var/log/mysqld.log</FONT>
<FONT COLOR="#000000">> open_files_limit=8192</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> [mysqldump]</FONT>
<FONT COLOR="#000000">> quick</FONT>
<FONT COLOR="#000000">> max_allowed_packet=16M</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> [mysql]</FONT>
<FONT COLOR="#000000">> no-auto-rehash</FONT>
<FONT COLOR="#000000">> #safe-updates</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> [isamchk]</FONT>
<FONT COLOR="#000000">> key_buffer=64M</FONT>
<FONT COLOR="#000000">> sort_buffer=64M</FONT>
<FONT COLOR="#000000">> read_buffer=16M</FONT>
<FONT COLOR="#000000">> write_buffer=16M</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> [myisamchk]</FONT>
<FONT COLOR="#000000">> key_buffer=64M</FONT>
<FONT COLOR="#000000">> sort_buffer=64M</FONT>
<FONT COLOR="#000000">> read_buffer=16M</FONT>
<FONT COLOR="#000000">> write_buffer=16M</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> [mysqlhotcopy]</FONT>
<FONT COLOR="#000000">> interactive-timeout</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> I also checked the mySQL database:</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> mysql> use mysql;</FONT>
<FONT COLOR="#000000">> Database changed</FONT>
<FONT COLOR="#000000">> mysql> show variables like "max_allowed_packet";</FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> | Variable_name | Value |</FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> | max_allowed_packet | 16776192 |</FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> 1 row in set (0.00 sec)</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> mysql> show global variables like "max_allowed_packet";</FONT>
<FONT COLOR="#000000">> ERROR 2006: MySQL server has gone away</FONT>
<FONT COLOR="#000000">> No connection. Trying to reconnect...</FONT>
<FONT COLOR="#000000">> Connection id: 139</FONT>
<FONT COLOR="#000000">> Current database: mysql</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> | Variable_name | Value |</FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> | max_allowed_packet | 16776192 |</FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> 1 row in set (0.00 sec)</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> mysql> show session variables like "max_allowed_packet";</FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> | Variable_name | Value |</FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> | max_allowed_packet | 16776192 |</FONT>
<FONT COLOR="#000000">> +--------------------+----------+</FONT>
<FONT COLOR="#000000">> 1 row in set (0.00 sec)</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> mysql> show variables like "version";</FONT>
<FONT COLOR="#000000">> +---------------+---------------------+</FONT>
<FONT COLOR="#000000">> | Variable_name | Value |</FONT>
<FONT COLOR="#000000">> +---------------+---------------------+</FONT>
<FONT COLOR="#000000">> | version | 4.0.25-standard-log |</FONT>
<FONT COLOR="#000000">> +---------------+---------------------+</FONT>
<FONT COLOR="#000000">> 1 row in set (0.00 sec)</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Any ideas?</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Sincerely,</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Chintan Zaveri.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">----------------------------------------------------------------</FONT>
<FONT COLOR="#000000">This message was sent using IMP, the Internet Messaging Program.</FONT>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>