[opencms-dev] Packet for query is too large - my.cnf doesn't fix

[Brad Clemmons Jr]

Actually, I checked the my.cnf manually and it shows the change (64M instead
of 16M) for that variable.  I also tried to change via MySQL-Administrator,
but the option to change that value in the gui is grayed out and it appears
to be defaulted to 1M which is frustrating since a cat or vi on the my.cnf
shows 16M.

-brad


On Thu, Jul 24, 2008 at 2:59 AM, Schliemann, Kai <K.Schliemann at comundus.com>
wrote:

>  Hi Brad,
> i assume, you already checked that. But to be sure.
> Did you check the values of the server variables (especially the
> max_allowed_packet) during runtime with a tool like MySQLFront or
> MySQL-Administrator? Maybe your changes are somehow not taken over by
> your DB server.
>
> Regards
> Kai
>  ------------------------------
> *Von:* opencms-dev-bounces at opencms.org [mailto:
> opencms-dev-bounces at opencms.org] *Im Auftrag von *Brad Clemmons Jr
> *Gesendet:* Donnerstag, 24. Juli 2008 01:17
> *An:* The OpenCms mailing list
> *Betreff:* Re: [opencms-dev] Packet for query is too large - my.cnf
> doesn't fix
>
>  I wondered about that but I didn't find any.  I did a find / -name my.cnf
> as root.  All it found was the one in /etc.
>
>
> On Wed, Jul 23, 2008 at 6:53 PM, Kim, Allan <jak009 at ucsd.edu> wrote:
>
>>  Could there be multiple instances of my.cnf?
>>
>>
>>
>>
>>
>> *From:* opencms-dev-bounces at opencms.org [mailto:
>> opencms-dev-bounces at opencms.org] *On Behalf Of *Brad Clemmons Jr
>> *Sent:* Wednesday, July 23, 2008 2:53 PM
>> *To:* opencms-dev at opencms.org
>> *Subject:* [opencms-dev] Packet for query is too large - my.cnf doesn't
>> fix
>>
>>
>>
>> Hi all.
>>
>> I'm running OpenCMS 7.0.4 with mysql 5 on Cent0S5 and I'm running into
>> this error:
>>
>> "com.mysql.jdbc.PacketTooBigException: Packet for query is too large"
>>
>> Before everyone jumps on me to check the archives...I've already changed
>> the my.cnf to 16, 32, and 64M respectively.  Neither worked.  I changed the
>> sizes, restarted the mysqld and same error occurs when trying to upload
>> anything over 1mb via the upload applet in the opencms management console.
>>
>> Any ideas?  Am I missing something obvious right under my nose?
>>
>> Thanks,
>>
>> Brad
>>
>>
>> _______________________________________________
>> 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
>>
>
>
>
> --
> I am the guardian standing at the gates and evil shall not pass, it will
> not cast it shadow on me and mine, and I will not fear it. -bclemmons
> "Maj.Haywood:There is a war on. How is it you are heading west?
> Hawkeye: Well, we face to the north and, real sudden like, turn left." -
> Last of the Mohicans
>
>
> _______________________________________________
> 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
>



-- 
I am the guardian standing at the gates and evil shall not pass, it will not
cast it shadow on me and mine, and I will not fear it. -bclemmons
"Maj.Haywood:There is a war on. How is it you are heading west?
Hawkeye: Well, we face to the north and, real sudden like, turn left." -
Last of the Mohicans
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20080724/eb4c7889/attachment.htm>