<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><span>Hi Alan,<br>
<br>
</span><span><span>C:\ProgramData\MySQL\MySQL Server 5.5\my.ini </span>this
is the proper place to add the property to</span>.<br>
Please add max_allowed_packet to the section [mysqld]. <br>
<br>
E.g. for a 256 MB max. packet size:<br>
<br>
# The MySQL server<br>
[mysqld]<br>
port = 3306<br>
socket = /var/lib/mysql/mysql.sock<br>
...<br>
max_allowed_packet = 256M<br>
...<br>
<br>
Finally restart the MySQL server and you should be all set.<br>
<br>
<br>
Sincerely,<br>
<br>
<br>
\Fabian<br>
<br>
<br>
<br>
Am 11.01.14 19:02, schrieb alan shiers:<br>
</div>
<blockquote
cite="mid:000001cf0ef7$5103fac0$f30bf040$@bellaliant.net"
type="cite">
<meta http-equiv="Context-Type" content="text/html;
charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<div class="WordSection1">
<p class="MsoNormal"><span>I’m running Windows 7. I did a
complete hard drive search for file my.ini. It showed up in
C:\ProgramData\MySQL\MySQL Server 5.5\my.ini</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>In that file there was no
max_allowed_packet parameter. So I added it. Now when I
run MySQL and Tomcat I get:</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><img id="_x0000_i1027"
src="cid:part1.07020508.08000809@componio.net" height="449"
width="695"><span></span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>Now it thinks I have it set to zero!
I’m still also getting the exception in the console that
states:</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>Exception: java.sql.SQLException:
Access denied for user 'root'@'localhost' (using password:
NO)</span></p>
<p class="MsoNormal"><span> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)</span></p>
<p class="MsoNormal"><span> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)</span></p>
<p class="MsoNormal"><span> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)</span></p>
<p class="MsoNormal"><span> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)</span></p>
<p class="MsoNormal"><span> at
com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(My</span></p>
<p class="MsoNormal"><span>sqlIO.java:1709)</span></p>
<p class="MsoNormal"><span>…</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>I am using a password. Any more
ideas as to how to fix this?</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>Alan</span></p>
<p class="MsoNormal"><span> </span></p>
<div>
<div>
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span
lang="EN-US"> <a class="moz-txt-link-abbreviated" href="mailto:opencms-dev-bounces@opencms.org">opencms-dev-bounces@opencms.org</a>
[<a class="moz-txt-link-freetext" href="mailto:opencms-dev-bounces@opencms.org">mailto:opencms-dev-bounces@opencms.org</a>] <b>On Behalf
Of </b><a class="moz-txt-link-abbreviated" href="mailto:fhsubscriptions@componio.net">fhsubscriptions@componio.net</a><br>
<b>Sent:</b> January-10-14 5:28 PM<br>
<b>To:</b> The OpenCms mailing list<br>
<b>Subject:</b> Re: [opencms-dev] installation issue</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Hi Alan,<br>
<br>
your max_allowed_packet size is definitely set to 1MB. Are
you on a windows system? If so, please see the folder
"Application Data" for the current my.ini and change the
parameter accordingly.<br>
<br>
Regards,<br>
<br>
<br>
\Fabian<br>
<br>
Am 10.01.14 22:20, schrieb alan shiers:</p>
</div>
<blockquote>
<div>
<p class="MsoNormal">Hi there,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I’m checking out OpenCms for the first
time and ran into a problem during setup. With MySQL
running I provided the following parameters:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><img id="Picture_x0020_1"
src="cid:part2.06090701.06000505@componio.net"
height="446" width="696"></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">When I click the Continue button I get:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><img id="Picture_x0020_2"
src="cid:part3.01070301.05020203@componio.net"
height="452" width="697"></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I read the instructions on your website
that states edit the max_allowed_packet to equal 32M in
the file my.ini. Well, there are several versions of the
ini file: my-small.ini, my-medium.ini, my-large.ini,
my-huge.ini. They all have this parameter. I edited all
of them prior to starting MySQL. Still, for whatever
reason, your wizard seems to think that it is set to only
1M.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">In addition, the Tomcat console window
is displaying the following exception:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Exception: java.sql.SQLException:
Access denied for user 'root'@'localhost' (using password:
NO)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(My</p>
<p class="MsoNormal">sqlIO.java:1709)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2</p>
<p class="MsoNormal">519)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)</p>
<p class="MsoNormal"> at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct</p>
<p class="MsoNormal">orAccessorImpl.java:57)</p>
<p class="MsoNormal"> at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC</p>
<p class="MsoNormal">onstructorAccessorImpl.java:45)</p>
<p class="MsoNormal"> at
java.lang.reflect.Constructor.newInstance(Constructor.java:525)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)</p>
<p class="MsoNormal"> at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java</p>
<p class="MsoNormal">:346)</p>
<p class="MsoNormal"> at
java.sql.DriverManager.getConnection(DriverManager.java:579)</p>
<p class="MsoNormal"> at
java.sql.DriverManager.getConnection(DriverManager.java:221)</p>
<p class="MsoNormal"> at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:489)</p>
<p class="MsoNormal"> at
org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp._jsp</p>
<p class="MsoNormal">Service(step_005f4a_005fdatabase_005fvalidation_jsp.java:88)</p>
<p class="MsoNormal"> at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)</p>
<p class="MsoNormal"> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)</p>
<p class="MsoNormal"> at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper</p>
<p class="MsoNormal">.java:432)</p>
<p class="MsoNormal"> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3</p>
<p class="MsoNormal">90)</p>
<p class="MsoNormal"> at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)</p>
<p class="MsoNormal"> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)</p>
<p class="MsoNormal"> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl</p>
<p class="MsoNormal">icationFilterChain.java:305)</p>
<p class="MsoNormal"> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF</p>
<p class="MsoNormal">ilterChain.java:210)</p>
<p class="MsoNormal"> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV</p>
<p class="MsoNormal">alve.java:225)</p>
<p class="MsoNormal"> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV</p>
<p class="MsoNormal">alve.java:123)</p>
<p class="MsoNormal"> at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica</p>
<p class="MsoNormal">torBase.java:472)</p>
<p class="MsoNormal"> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j</p>
<p class="MsoNormal">ava:168)</p>
<p class="MsoNormal"> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j</p>
<p class="MsoNormal">ava:98)</p>
<p class="MsoNormal"> at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:</p>
<p class="MsoNormal">927)</p>
<p class="MsoNormal"> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal</p>
<p class="MsoNormal">ve.java:118)</p>
<p class="MsoNormal"> at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav</p>
<p class="MsoNormal">a:407)</p>
<p class="MsoNormal"> at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp</p>
<p class="MsoNormal">11Processor.java:1001)</p>
<p class="MsoNormal"> at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(</p>
<p class="MsoNormal">AbstractProtocol.java:585)</p>
<p class="MsoNormal"> at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin</p>
<p class="MsoNormal">t.java:310)</p>
<p class="MsoNormal"> at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.</p>
<p class="MsoNormal">java:1110)</p>
<p class="MsoNormal"> at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor</p>
<p class="MsoNormal">.java:603)</p>
<p class="MsoNormal"> at
java.lang.Thread.run(Thread.java:722)</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">It is interesting that it states that a
password wasn’t provided. As you can see from the
screenshot, I did provide a password. Please advise.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Alan Shiers</p>
</div>
<p class="MsoNormal"><br>
<br>
<br>
</p>
<pre>_______________________________________________</pre>
<pre>This mail is sent to you from the opencms-dev mailing list</pre>
<pre>To change your list options, or to unsubscribe from the list, please visit</pre>
<pre><a moz-do-not-send="true" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a></pre>
<pre> </pre>
<pre> </pre>
<pre> </pre>
</blockquote>
<p class="MsoNormal"> </p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
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
<a class="moz-txt-link-freetext" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>