<div dir="ltr">Hi,<div><br></div><div>Add in my.ini node [mysqld] and [mysqldump]:</div><div>max_allowed_packet = 64M<br></div><div><br></div><div>Good Luck,</div><div><br></div><div>Deiverson</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2014/1/10 alan shiers <span dir="ltr"><<a href="mailto:alan.shiers@bellaliant.net" target="_blank">alan.shiers@bellaliant.net</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-CA" link="blue" vlink="purple"><div><p class="MsoNormal">Hi there,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span><img width="696" height="446" src="cid:image001.png@01CF0E26.DF76E190"></span><u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">
When I click the Continue button I get:<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span><img width="697" height="452" src="cid:image002.png@01CF0E26.DF76E190"></span><u></u><u></u></p><p class="MsoNormal">
<u></u> <u></u></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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">In addition, the Tomcat console window is displaying the following exception:<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span style="color:#1f497d">Exception: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(My<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d">sqlIO.java:1709)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d">519)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">orAccessorImpl.java:57)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">onstructorAccessorImpl.java:45)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at java.lang.reflect.Constructor.newInstance(Constructor.java:525)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d">:346)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at java.sql.DriverManager.getConnection(DriverManager.java:579)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at java.sql.DriverManager.getConnection(DriverManager.java:221)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:489)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp._jsp<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Service(step_005f4a_005fdatabase_005fvalidation_jsp.java:88)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">.java:432)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">90)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">icationFilterChain.java:305)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">ilterChain.java:210)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">alve.java:225)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">alve.java:123)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">torBase.java:472)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">ava:168)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">ava:98)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">927)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">ve.java:118)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">a:407)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">11Processor.java:1001)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">AbstractProtocol.java:585)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">t.java:310)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">java:1110)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">.java:603)<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"> at java.lang.Thread.run(Thread.java:722)<u></u><u></u></span></p><p class="MsoNormal">
<span style="color:#1f497d"><u></u> <u></u></span></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.<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></p>
<span class="HOEnZb"><font color="#888888"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Alan Shiers<u></u><u></u></p></font></span></div></div><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/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br>
<br>
<br>
<br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><i><div><span style="font-style:normal"><i><div><span style="font-style:normal"><i><div style="display:inline!important"><span style="font-style:normal"><i><a href="http://www.solutioncms.com" target="_blank">www.solutioncms.com</a></i></span></div>
</i></span></div><div><span style="font-style:normal"><i><span style="font-style:normal"><i><div><span style="font-style:normal"><i><div style="display:inline!important"><span style="font-style:normal"><i><span style="font-style:normal"><i><div style="display:inline!important">
<i>The Brazilian </i><span style="font-style:normal"><i><div style="display:inline!important"><span style="font-style:normal"><i><span style="font-style:normal"><i><div style="display:inline!important"><i>Official Provider OpenCms</i></div>
</i></span></i></span></div></i></span></div></i></span></i></span></div></i></span></div></i></span></i></span></div></i></span></div></i>
</div>