<div dir="ltr"><div>Hi Alan,<br><br></div><div>it seems that your mysql installation has gone terribly wrong, you shall be able to login through the DOS command prompt with:<br><br></div><div>mysql -u root -p <your mysql root password><br>
<br></div><div>If you still get:<br><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Exception: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO) --> this means you're not using a root password<br>
<br></span></div><div><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Then uninstall mysql, reboot your windows and install a clean one.<br></span></div><div><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">You've to grant all privileges to the root user on localhost to be able to login to your mysql instance:<br>
<br></span><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><code>GRANT ALL ON *.* TO 'root'@'localhost';</code><br></span></div><div><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">(but this is done during the mysql installation for you)<br>
<br></span></div><div><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">It would be a good idea to install the MySQL Administration Tools and make sure that the root user has full access to the mysql DB.<br>
</span></div><div><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><br></span></div><div><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">HTH,<br>
</span></div><div><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Kind Regards,<br></span></div><div><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Arash</span></div>
<div><div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div></div><div><div style="font-family:arial;font-size:small"><div><div><a href="https://www.facebook.com/cloudssky" style="color:rgb(17,85,204)" target="_blank">Like</a> | <a href="https://twitter.com/CLOUDSSKYONE" style="color:rgb(17,85,204)" target="_blank">Follow</a> | <font color="#0000ff"><font color="#0000ff"><a href="http://cloudssky.com/en/cloud_products/cloudsites.html" target="_blank">Build your CloudSite with OpenCms OCCX</a></font></font><br>
</div></div></div></div></div></div>
<br><br><div class="gmail_quote">On Sat, Jan 11, 2014 at 9:18 PM, <a href="mailto:fhsubscriptions@componio.net">fhsubscriptions@componio.net</a> <span dir="ltr"><<a href="mailto:fhsubscriptions@componio.net" target="_blank">fhsubscriptions@componio.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div><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><div><div class="h5">
<blockquote type="cite">
<div>
<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 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 href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>
[<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">mailto:opencms-dev-bounces@opencms.org</a>] <b>On Behalf
Of </b><a href="mailto:fhsubscriptions@componio.net" target="_blank">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 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 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 href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">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></fieldset>
<br>
<pre>_______________________________________________
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 href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>
</pre>
</blockquote>
<br>
</div></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></div></div></div></div>