<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>