[opencms-dev] installation issue
fhsubscriptions at componio.net
fhsubscriptions at componio.net
Sun Jan 12 01:37:31 CET 2014
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
> <mailto:fhsubscriptions at componio.net> <fhsubscriptions at componio.net
> <mailto: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>
> [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
>
> 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: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20140112/fab492c0/attachment.htm>
-------------- 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/20140112/fab492c0/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/20140112/fab492c0/attachment-0001.png>
-------------- 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/20140112/fab492c0/attachment-0002.png>
More information about the opencms-dev
mailing list