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

[Michael Moossen]

Hi, Chintan!

I think this is a detail problem related to the definition of 16Mb, try to set
your db param to something bigger, ie. 17Mb...

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




Quoting Chintan Zaveri <smile at sis.net.in>:

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


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