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

[Chintan Zaveri]

Hi Michael,

My problem seems to have been solved when I set it at 17MB.

Currently importing modules...

Thank-you very much,

Sincerely,

Chintan Zaveri.

On Tue, 2006-02-28 at 14:41 +0100, Michael Moossen wrote:

> 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.
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060228/7a5314e5/attachment.htm>