[opencms-dev] installation issue
fhsubscriptions at componio.net
fhsubscriptions at componio.net
Sat Jan 11 21:18:22 CET 2014
Hi Alan,
C:\ProgramData\MySQL\MySQL Server 5.5\my.ini this is the proper place to
add the property to.
Please add max_allowed_packet to the section [mysqld].
E.g. for a 256 MB max. packet size:
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
...
max_allowed_packet = 256M
...
Finally restart the MySQL server and you should be all set.
Sincerely,
\Fabian
Am 11.01.14 19:02, schrieb alan shiers:
>
> 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
>
>
>
> In that file there was no max_allowed_packet parameter. So I added
> it. Now when I run MySQL and Tomcat I get:
>
>
>
>
>
> Now it thinks I have it set to zero! I'm still also getting the
> exception in the console that states:
>
>
>
> Exception: java.sql.SQLException: Access denied for user
> 'root'@'localhost' (using password: NO)
>
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
>
> at
> com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(My
>
> sqlIO.java:1709)
>
> ...
>
>
>
> I am using a password. Any more ideas as to how to fix this?
>
>
>
> Alan
>
>
>
> *From:*opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org] *On Behalf Of
> *fhsubscriptions at componio.net
> *Sent:* January-10-14 5:28 PM
> *To:* The OpenCms mailing list
> *Subject:* Re: [opencms-dev] installation issue
>
>
>
> Hi Alan,
>
> 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.
>
> Regards,
>
>
> \Fabian
>
> Am 10.01.14 22:20, schrieb alan shiers:
>
> Hi there,
>
>
>
> I'm checking out OpenCms for the first time and ran into a problem
> during setup. With MySQL running I provided the following parameters:
>
>
>
>
>
> When I click the Continue button I get:
>
>
>
>
>
> 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.
>
>
>
> In addition, the Tomcat console window is displaying the following
> exception:
>
>
>
> Exception: java.sql.SQLException: Access denied for user
> 'root'@'localhost' (using password: NO)
>
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
>
> at
> com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(My
>
> sqlIO.java:1709)
>
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)
>
> at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)
>
> at
> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
>
> 519)
>
> at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
>
> at
> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
>
> at
> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
>
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>
>
>
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
>
> orAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
>
> onstructorAccessorImpl.java:45)
>
> at
> java.lang.reflect.Constructor.newInstance(Constructor.java:525)
>
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>
> at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
>
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
>
> :346)
>
> at
> java.sql.DriverManager.getConnection(DriverManager.java:579)
>
> at
> java.sql.DriverManager.getConnection(DriverManager.java:221)
>
> at
> org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:489)
>
> at
> org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp._jsp
>
> Service(step_005f4a_005fdatabase_005fvalidation_jsp.java:88)
>
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
>
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
>
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>
> .java:432)
>
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>
> 90)
>
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
>
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>
> icationFilterChain.java:305)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>
> ilterChain.java:210)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
>
> alve.java:225)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
>
> alve.java:123)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
>
> torBase.java:472)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
>
> ava:168)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
>
> ava:98)
>
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
>
> 927)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
>
> ve.java:118)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
>
> a:407)
>
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
>
> 11Processor.java:1001)
>
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
>
> AbstractProtocol.java:585)
>
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
>
> t.java:310)
>
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
>
> java:1110)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
>
> .java:603)
>
> at java.lang.Thread.run(Thread.java:722)
>
>
>
> 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.
>
>
>
> Alan Shiers
>
>
>
>
> _______________________________________________
>
> 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
>
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> 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
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/fb9a25f8/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/fb9a25f8/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/fb9a25f8/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/fb9a25f8/attachment-0002.png>
More information about the opencms-dev
mailing list