[opencms-dev] installation issue

BigAdmin bigadmin at wjug.ca
Sat Jan 11 20:14:53 CET 2014


if you can't find one, create one and test

http://dev.mysql.com/doc/refman/4.1/en/mysql-config-wizard-file-location.html
http://stackoverflow.com/questions/14597884/mysql-my-ini-location





On 01/11/14 12:02, alan shiers wrote:
>
> 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/313839ff/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/313839ff/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/313839ff/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/313839ff/attachment-0002.png>


More information about the opencms-dev mailing list