[opencms-dev] installation issue
Arash Kaffamanesh
ak at cloudssky.com
Sat Jan 11 22:41:27 CET 2014
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 <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 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: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/10024430/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 31256 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/10024430/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 45305 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/10024430/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 30942 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140111/10024430/attachment-0002.png>
More information about the opencms-dev
mailing list