[opencms-dev] installation issue
alan shiers
alan.shiers at bellaliant.net
Sun Jan 12 00:57:29 CET 2014
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: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/4ed27005/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/4ed27005/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/4ed27005/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/4ed27005/attachment-0002.png>
More information about the opencms-dev
mailing list