<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">You have to add an uppercase M behind
the 32! Right now you have configured 32 Bytes :-)<br>
Further the password "ponyboy" has to be entered for the setup
connection as well as the OpenCms connection.<br>
<br>
\Fabian<br>
<br>
<br>
Am 12.01.14 00:57, schrieb alan shiers:<br>
</div>
<blockquote
cite="mid:000001cf0f28$e2a4bfb0$a7ee3f10$@bellaliant.net"
type="cite">
<meta http-equiv="Context-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<div class="WordSection1">
<p class="MsoNormal"><span>Hi Guys,</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>I did edit the my.ini file in </span>C:\ProgramData\MySQL\MySQL
Server 5.5\my.ini which included max_allowed_packet=32</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I also opened a command prompt to MySQL
using my password to ensure I have access as root. I had no
problem getting in.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">So, since the my.ini file is correctly
edited and I have access to MySQL via root with password, then
everything should work. The OpenCms wizard should not have an
issue, but it still does. It still says that
max_allowed_packet=0 and I’m still getting the exception
showing in the console.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Any more suggestions?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Alan<span></span></p>
<p class="MsoNormal"><span> </span></p>
<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>Arash
Kaffamanesh<br>
<b>Sent:</b> January-11-14 5:41 PM<br>
<b>To:</b> The OpenCms mailing list<br>
<b>Subject:</b> Re: [opencms-dev] installation issue</span></p>
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal">Hi Alan,</p>
</div>
<div>
<p class="MsoNormal">it seems that your mysql installation
has gone terribly wrong, you shall be able to login
through the DOS command prompt with:</p>
</div>
<div>
<p class="MsoNormal">mysql -u root -p <your mysql root
password></p>
</div>
<div>
<p class="MsoNormal">If you still get:<br>
<span>Exception: java.sql.SQLException: Access denied for
user 'root'@'localhost' (using password: NO) --> this
means you're not using a root password</span></p>
</div>
<div>
<p class="MsoNormal"><span>Then uninstall mysql, reboot your
windows and install a clean one.</span></p>
</div>
<div>
<p class="MsoNormal"><span>You've to grant all privileges to
the root user on localhost to be able to login to your
mysql instance:<br>
<br>
</span><code><span>GRANT ALL ON *.* TO 'root'@'localhost';</span></code></p>
</div>
<div>
<p class="MsoNormal"><span>(but this is done during the
mysql installation for you)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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.</span></p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal"><span>HTH,</span></p>
</div>
<div>
<p class="MsoNormal"><span>Kind Regards,</span></p>
</div>
<div>
<p class="MsoNormal"><span>Arash</span></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><br>
</p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span><a
moz-do-not-send="true"
href="https://www.facebook.com/cloudssky"
target="_blank"><span>Like</span></a> | <a
moz-do-not-send="true"
href="https://twitter.com/CLOUDSSKYONE"
target="_blank"><span>Follow</span></a> | <span><a
moz-do-not-send="true"
href="http://cloudssky.com/en/cloud_products/cloudsites.html"
target="_blank">Build your CloudSite
with OpenCms OCCX</a></span></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">On Sat, Jan 11, 2014 at 9:18 PM,
<a moz-do-not-send="true"
href="mailto:fhsubscriptions@componio.net">fhsubscriptions@componio.net</a>
<<a moz-do-not-send="true"
href="mailto:fhsubscriptions@componio.net"
target="_blank">fhsubscriptions@componio.net</a>>
wrote:</p>
<div>
<div>
<p class="MsoNormal">Hi Alan,<br>
<br>
C:\ProgramData\MySQL\MySQL Server 5.5\my.ini
this is the proper place to add the property to.<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:</p>
</div>
<div>
<div>
<blockquote>
<div>
<p class="MsoNormal">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</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">In that file there was
no max_allowed_packet parameter. So I
added it. Now when I run MySQL and Tomcat
I get:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><img id="_x0000_i1025"
src="cid:part6.09030801.03070007@componio.net" height="449" width="695"></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Now it thinks I have it
set to zero! I’m still also getting the
exception in the console that states:</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">…</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I am using a password.
Any more ideas as to how to fix this?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Alan</p>
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal"><b><span
lang="EN-US">From:</span></b><span
lang="EN-US"> <a
moz-do-not-send="true"
href="mailto:opencms-dev-bounces@opencms.org"
target="_blank">opencms-dev-bounces@opencms.org</a>
[<a moz-do-not-send="true"
href="mailto:opencms-dev-bounces@opencms.org"
target="_blank">mailto:opencms-dev-bounces@opencms.org</a>]
<b>On Behalf Of </b><a
moz-do-not-send="true"
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
id="_x0000_i1026"
src="cid:part10.09070308.07030406@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="_x0000_i1027"
src="cid:part11.05070704.02040907@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>
</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" 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>
<p class="MsoNormal"> </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" 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>
</div>
</div>
<p class="MsoNormal"><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 moz-do-not-send="true"
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>
</p>
</div>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
</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>