<!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>
Hello All,<BR>
<BR>
I just joined this mailing list, since I am planning to use OpenCms and have been facing a few limitations due to my inadequate acquaintance with Java / MySQL / OpenCms.<BR>
<BR>
Here is the first problem which I have faced while trying to install OpenCms on CentOS 4.2 with mySQL 4.0.25 and Tomcat 5.5.15. I am attaching a snapshot of the screen, alongwith.<BR>
<BR>
<B>Validating Database Server Configuration</B><BR>
<BR>
MySQL system variable <TT>'max_allowed_packet'</TT> is set to 16776192 Bytes.<BR>
<BR>
Please, note that it will not be possible for OpenCms to handle files bigger than this value.<BR>
<BR>
<B>The recommended value for running OpenCms is 16Mb, please change your MySQL configuration (in your </B><B><TT>mi.ini</TT></B><B> or </B><B><TT>my.cnf</TT></B><B> file).</B><BR>
<BR>
To resolve this issue, I checked the /etc/my.cnf file which looks as below:<BR>
<BR>
[mysqld]<BR>
datadir=/var/lib/mysql<BR>
socket=/var/lib/mysql/mysql.sock<BR>
skip-locking<BR>
query_cache_limit=1M<BR>
query_cache_size=32M<BR>
query_cache_type=1<BR>
max_connections=500<BR>
interactive_timeout=100<BR>
wait_timeout=100<BR>
connect_timeout=10<BR>
thread_cache_size=128<BR>
key_buffer=16M<BR>
join_buffer=1M<BR>
max_allowed_packet=16M<BR>
table_cache=1024<BR>
record_buffer=1M<BR>
sort_buffer_size=2M<BR>
read_buffer_size=2M<BR>
max_connect_errors=10<BR>
thread_concurrency=2<BR>
myisam_sort_buffer_size=64M<BR>
log-bin<BR>
server-id=1<BR>
<BR>
[mysql.server]<BR>
user=mysql<BR>
basedir=/var/lib<BR>
<BR>
[safe_mysqld]<BR>
err-log=/var/log/mysqld.log<BR>
open_files_limit=8192<BR>
<BR>
[mysqldump]<BR>
quick<BR>
max_allowed_packet=16M<BR>
<BR>
[mysql]<BR>
no-auto-rehash<BR>
#safe-updates<BR>
<BR>
[isamchk]<BR>
key_buffer=64M<BR>
sort_buffer=64M<BR>
read_buffer=16M<BR>
write_buffer=16M<BR>
<BR>
[myisamchk]<BR>
key_buffer=64M<BR>
sort_buffer=64M<BR>
read_buffer=16M<BR>
write_buffer=16M<BR>
<BR>
[mysqlhotcopy]<BR>
interactive-timeout<BR>
<BR>
I also checked the mySQL database:<BR>
<BR>
mysql> use mysql;<BR>
Database changed<BR>
mysql> show variables like "max_allowed_packet";<BR>
+--------------------+----------+<BR>
| Variable_name | Value |<BR>
+--------------------+----------+<BR>
| max_allowed_packet | 16776192 |<BR>
+--------------------+----------+<BR>
1 row in set (0.00 sec)<BR>
<BR>
mysql> show global variables like "max_allowed_packet";<BR>
ERROR 2006: MySQL server has gone away<BR>
No connection. Trying to reconnect...<BR>
Connection id: 139<BR>
Current database: mysql<BR>
<BR>
+--------------------+----------+<BR>
| Variable_name | Value |<BR>
+--------------------+----------+<BR>
| max_allowed_packet | 16776192 |<BR>
+--------------------+----------+<BR>
1 row in set (0.00 sec)<BR>
<BR>
mysql> show session variables like "max_allowed_packet";<BR>
+--------------------+----------+<BR>
| Variable_name | Value |<BR>
+--------------------+----------+<BR>
| max_allowed_packet | 16776192 |<BR>
+--------------------+----------+<BR>
1 row in set (0.00 sec)<BR>
<BR>
mysql> show variables like "version";<BR>
+---------------+---------------------+<BR>
| Variable_name | Value |<BR>
+---------------+---------------------+<BR>
| version | 4.0.25-standard-log |<BR>
+---------------+---------------------+<BR>
1 row in set (0.00 sec)<BR>
<BR>
Any ideas?<BR>
<BR>
Sincerely,<BR>
<BR>
Chintan Zaveri.<BR>
<BR>
</BODY>
</HTML>