[opencms-dev] OpenCms Setup Wizard - Validate database connection

[Chintan Zaveri]

Hello All,

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.

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.

Validating Database Server Configuration

MySQL system variable 'max_allowed_packet' is set to 16776192 Bytes.

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).

To resolve this issue, I checked the /etc/my.cnf file which looks as
below:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=2
myisam_sort_buffer_size=64M
log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

I also checked the mySQL database:

mysql> use mysql;
Database changed
mysql> show variables like "max_allowed_packet";
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16776192 |
+--------------------+----------+
1 row in set (0.00 sec)

mysql> show global variables like "max_allowed_packet";
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    139
Current database: mysql

+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16776192 |
+--------------------+----------+
1 row in set (0.00 sec)

mysql> show session variables like "max_allowed_packet";
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16776192 |
+--------------------+----------+
1 row in set (0.00 sec)

mysql> show variables like "version";
+---------------+---------------------+
| Variable_name | Value               |
+---------------+---------------------+
| version       | 4.0.25-standard-log |
+---------------+---------------------+
1 row in set (0.00 sec)

Any ideas?

Sincerely,

Chintan Zaveri.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060228/0e36b0cc/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: opencms_setup_error_16M.png
Type: image/png
Size: 43820 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060228/0e36b0cc/attachment.png>