<div dir="ltr">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.<br>
<br>-brad<br><br><br><div class="gmail_quote">On Thu, Jul 24, 2008 at 2:59 AM, Schliemann, Kai <<a href="mailto:K.Schliemann@comundus.com">K.Schliemann@comundus.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font size="2" color="#0000ff" face="Arial">Hi Brad,</font></span></div>
<div dir="ltr" align="left"><span><font size="2" color="#0000ff" face="Arial">i assume, you already checked that. But to be
sure.</font></span></div>
<div dir="ltr" align="left"><span><font size="2" color="#0000ff" face="Arial">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.</font></span></div>
<div dir="ltr" align="left"><span><font size="2" color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font size="2" color="#0000ff" face="Arial">Regards</font></span></div>
<div dir="ltr" align="left"><span><font size="2" color="#0000ff" face="Arial">Kai</font></span><br></div>
<div dir="ltr" align="left" lang="de">
<hr>
<font size="2" face="Tahoma"><b>Von:</b> <a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>
[mailto:<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>] <b>Im Auftrag von </b>Brad Clemmons
Jr<br><b>Gesendet:</b> Donnerstag, 24. Juli 2008 01:17<br><b>An:</b> The OpenCms
mailing list<br><b>Betreff:</b> Re: [opencms-dev] Packet for query is too large
- my.cnf doesn't fix<br></font><br></div><div><div></div><div class="Wj3C7c">
<div></div>
<div dir="ltr">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.<br><br><br>
<div class="gmail_quote">On Wed, Jul 23, 2008 at 6:53 PM, Kim, Allan <<a href="mailto:jak009@ucsd.edu" target="_blank">jak009@ucsd.edu</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div vlink="purple" link="blue" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Could there be
multiple instances of my.cnf?</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"></span> </p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"></span> </p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a> [mailto:<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>] <b>On Behalf Of </b>Brad
Clemmons Jr<br><b>Sent:</b> Wednesday, July 23, 2008 2:53 PM<br><b>To:</b> <a href="mailto:opencms-dev@opencms.org" target="_blank">opencms-dev@opencms.org</a><br><b>Subject:</b> [opencms-dev]
Packet for query is too large - my.cnf doesn't fix</span></p></div>
<div>
<div></div>
<div>
<p> </p>
<div>
<p>Hi all.<br><br>I'm running OpenCMS 7.0.4 with mysql 5 on Cent0S5 and I'm
running into this error:<br><br>"com.mysql.jdbc.PacketTooBigException: Packet
for query is too large"<br><br>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.<br><br>Any ideas? Am I
missing something obvious right under my
nose?<br><br>Thanks,<br><br>Brad</p></div></div></div></div></div><br><br>_______________________________________________<br>This
mail is sent to you from the opencms-dev mailing list<br>To change your list
options, or to unsubscribe from the list, please visit<br><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br></blockquote></div>
<br><br clear="all"><br>-- <br>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<br>"Maj.Haywood:There is a war on. How is it you are heading
west?<br>Hawkeye: Well, we face to the north and, real sudden like, turn left."
- Last of the Mohicans </div></div></div></div>
<br><br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br></blockquote></div><br><br clear="all"><br>-- <br>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<br>
"Maj.Haywood:There is a war on. How is it you are heading west?<br>Hawkeye: Well, we face to the north and, real sudden like, turn left." - Last of the Mohicans
</div>