[opencms-dev] installation issue

alan shiers alan.shiers at bellaliant.net
Sat Jan 11 19:02:39 CET 2014 

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
 
 
 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/511c4144/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/511c4144/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/511c4144/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/511c4144/attachment-0002.png>

More information about the opencms-dev mailing list