[opencms-dev] max_packet_size to small

[simone.bortolaso at libero.it]

Hi, what follows is my my.ini into windows xp......
The correct position of "set-variable=max_allowed_packet=16M"  is under [mysqld] and not [WinMySQLadmin]. 
In linux change only the my.cnf position into file sistem.

The connector mysql-connector-java-3.0.15-ga-bin.jar for mysql 4.xx is good.


Usually, my site work with 30M of upload file (pdf,jpg....)  
Eventually, you could resolve the sucessive problem "OutOfMemory" updating catalina.bat or catalina.sh with:

set CATALINA_OPTS=%CATALINA_OPTS% -Dsun.io.useCanonCaches=false -Dfile.encoding=ISO-8859-1 -Xmx512M -Xms128M
 
------------------------------------------------------
#This File was made using the WinMySQLAdmin 1.4 Tool
#16/10/2004 23.43.46

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=127.0.0.1
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
set-variable=max_allowed_packet=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=admin
password=admin


Simone Bortolaso

---------- Initial Header -----------

>From      : opencms-dev-bounces at opencms.org
To          : opencms-dev at opencms.org
Cc          : 
Date      : Fri, 21 Apr 2006 10:44:56 -0700 (PDT)
Subject : [opencms-dev] max_packet_size to small







> Hi,
> 
> I'm using version 5 and can't upload an image that is
> 1.5M in size. the error mentions something about
> maxpacketsize too big exception error. I have tried to
> look for a solution in various forums and was told to
> set a variable for this in my my.ini file. that didnt
> work. After further reading it said that the
> limitation is in the connection driver. I am using
> J2SDK1.4.2_08 on a windows OS machine. If there is a
> limit in the config file for the connector, then where
> do I find this??
> 
> Basic Problem = can't upload over 1MB image in opencms
> galleries.
> 
> 
> thanks in advance...
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>