[opencms-dev] installation issue

[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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140110/ba2e834f/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/20140110/ba2e834f/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/20140110/ba2e834f/attachment-0001.png>