[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: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140110/ba2e834f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>

[Deiverson Silveira]

Hi,

Add in my.ini node [mysqld] and [mysqldump]:
max_allowed_packet = 64M

Good Luck,

Deiverson


2014/1/10 alan shiers <alan.shiers at bellaliant.net>

Post by alan shiers
Hi there,
I?m checking out OpenCms for the first time and ran into a problem during
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
(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
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

--
*www.solutioncms.com <http://www.solutioncms.com>The Brazilian Official
Provider OpenCms*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140110/80a73de8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>

[fhsubscriptions]

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

Post by alan shiers
Hi there,
I'm checking out OpenCms for the first time and ran into a problem
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: java.sql.SQLException: Access denied for user
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
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: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140110/d4c35236/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>

[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






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

[BigAdmin]

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

Post by 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
Now it thinks I have it set to zero! I'm still also getting the
Exception: java.sql.SQLException: Access denied for user
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
Hi there,
I'm checking out OpenCms for the first time and ran into a problem
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: java.sql.SQLException: Access denied for user
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
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: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140111/313839ff/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>

[fhsubscriptions]

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

Post by 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
Now it thinks I have it set to zero! I'm still also getting the
Exception: java.sql.SQLException: Access denied for user
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
Hi there,
I'm checking out OpenCms for the first time and ran into a problem
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: java.sql.SQLException: Access denied for user
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
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: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140111/fb9a25f8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>

[Arash Kaffamanesh]

Hi Alan,

it seems that your mysql installation has gone terribly wrong, you shall be
able to login through the DOS command prompt with:

mysql -u root -p <your mysql root password>

If you still get:
Exception: java.sql.SQLException: Access denied for user 'root'@'localhost'
(using password: NO) --> this means you're not using a root password

Then uninstall mysql, reboot your windows and install a clean one.
You've to grant all privileges to the root user on localhost to be able to
login to your mysql instance:

GRANT ALL ON *.* TO 'root'@'localhost';
(but this is done during the mysql installation for you)

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.

HTH,
Kind Regards,
Arash

Like <https://www.facebook.com/cloudssky> |
Follow<https://twitter.com/CLOUDSSKYONE>
| Build your CloudSite with OpenCms
OCCX<http://cloudssky.com/en/cloud_products/cloudsites.html>


On Sat, Jan 11, 2014 at 9:18 PM, fhsubscriptions at componio.net <

Post by fhsubscriptions
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].
# 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
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 it thinks I have it set to zero! I?m still also getting the exception
(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 <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
Hi there,
I?m checking out OpenCms for the first time and ran into a problem during
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
(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
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 visithttp://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: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140111/10024430/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <Loading Image...>

[alan shiers]

Hi Guys,



I did edit the my.ini file in C:\ProgramData\MySQL\MySQL Server 5.5\my.ini which included max_allowed_packet=32



I also opened a command prompt to MySQL using my password to ensure I have access as root. I had no problem getting in.



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.



Any more suggestions?



Alan



From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Arash Kaffamanesh
Sent: January-11-14 5:41 PM
To: The OpenCms mailing list
Subject: Re: [opencms-dev] installation issue



Hi Alan,

it seems that your mysql installation has gone terribly wrong, you shall be able to login through the DOS command prompt with:

mysql -u root -p <your mysql root password>

If you still get:
Exception: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO) --> this means you're not using a root password

Then uninstall mysql, reboot your windows and install a clean one.

You've to grant all privileges to the root user on localhost to be able to login to your mysql instance:

GRANT ALL ON *.* TO 'root'@'localhost';

(but this is done during the mysql installation for you)

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.



HTH,

Kind Regards,

Arash




<https://www.facebook.com/cloudssky> Like | <https://twitter.com/CLOUDSSKYONE> Follow | Build your CloudSite with OpenCms OCCX <http://cloudssky.com/en/cloud_products/cloudsites.html>



On Sat, Jan 11, 2014 at 9:18 PM, fhsubscriptions at componio.net <fhsubscriptions at componio.net> wrote:

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







_______________________________________________
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: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140111/4ed27005/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>

[fhsubscriptions]

You have to add an uppercase M behind the 32! Right now you have
configured 32 Bytes :-)
Further the password "ponyboy" has to be entered for the setup
connection as well as the OpenCms connection.

\Fabian

Post by alan shiers
Hi Guys,
I did edit the my.ini file in C:\ProgramData\MySQL\MySQL Server
5.5\my.ini which included max_allowed_packet=32
I also opened a command prompt to MySQL using my password to ensure I
have access as root. I had no problem getting in.
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.
Any more suggestions?
Alan
*From:*opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] *On Behalf Of *Arash Kaffamanesh
*Sent:* January-11-14 5:41 PM
*To:* The OpenCms mailing list
*Subject:* Re: [opencms-dev] installation issue
Hi Alan,
it seems that your mysql installation has gone terribly wrong, you
mysql -u root -p <your mysql root password>
Exception: java.sql.SQLException: Access denied for user
using a root password
Then uninstall mysql, reboot your windows and install a clean one.
You've to grant all privileges to the root user on localhost to be
(but this is done during the mysql installation for you)
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.
HTH,
Kind Regards,
Arash
Like <https://www.facebook.com/cloudssky> | Follow
<https://twitter.com/CLOUDSSKYONE> | Build your CloudSite with OpenCms
OCCX <http://cloudssky.com/en/cloud_products/cloudsites.html>
On Sat, Jan 11, 2014 at 9:18 PM, fhsubscriptions at componio.net
<mailto:fhsubscriptions at componio.net> <fhsubscriptions at componio.net
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].
# 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
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
Now it thinks I have it set to zero! I'm still also getting the
Exception: java.sql.SQLException: Access denied for user
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>
[mailto:opencms-dev-bounces at opencms.org] *On Behalf Of
*fhsubscriptions at componio.net <mailto: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
Hi there,
I'm checking out OpenCms for the first time and ran into a
problem during setup. With MySQL running I provided the
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
Exception: java.sql.SQLException: Access denied for user
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
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
_______________________________________________
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: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140112/fab492c0/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>

[alan shiers]

OK. My mistake. I included the M on the end and tried to install once
again. At least I am getting a little further this time. It didn't
complain about the max_allowed_packet parameter, but now it is still
complaining about the "No Password" thing. I did input the password in the
text field, see:







"ponyboy" is the password for the root account.



The console reads:



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)





Something is still amiss. Please advise.



Alan



From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of
fhsubscriptions at componio.net
Sent: January-11-14 8:38 PM
To: The OpenCms mailing list
Subject: Re: [opencms-dev] installation issue



You have to add an uppercase M behind the 32! Right now you have configured
32 Bytes :-)
Further the password "ponyboy" has to be entered for the setup connection as
well as the OpenCms connection.

\Fabian


Am 12.01.14 00:57, schrieb alan shiers:

Hi Guys,



I did edit the my.ini file in C:\ProgramData\MySQL\MySQL Server 5.5\my.ini
which included max_allowed_packet=32



I also opened a command prompt to MySQL using my password to ensure I have
access as root. I had no problem getting in.



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.



Any more suggestions?



Alan



From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Arash Kaffamanesh
Sent: January-11-14 5:41 PM
To: The OpenCms mailing list
Subject: Re: [opencms-dev] installation issue



Hi Alan,

it seems that your mysql installation has gone terribly wrong, you shall be
able to login through the DOS command prompt with:

mysql -u root -p <your mysql root password>

If you still get:
Exception: java.sql.SQLException: Access denied for user 'root'@'localhost'
(using password: NO) --> this means you're not using a root password

Then uninstall mysql, reboot your windows and install a clean one.

You've to grant all privileges to the root user on localhost to be able to
login to your mysql instance:

GRANT ALL ON *.* TO 'root'@'localhost';

(but this is done during the mysql installation for you)

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.



HTH,

Kind Regards,

Arash



Like <https://www.facebook.com/cloudssky> | Follow
<https://twitter.com/CLOUDSSKYONE> | Build your CloudSite with OpenCms OCCX
<http://cloudssky.com/en/cloud_products/cloudsites.html>



On Sat, Jan 11, 2014 at 9:18 PM, fhsubscriptions at componio.net
<fhsubscriptions at componio.net> wrote:

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







_______________________________________________
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: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20140112/60f1dbf3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 45352 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <Loading Image...>