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