[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