[opencms-dev] new opencms user

Wagner,Aaron anwagner at deq.virginia.gov
Wed Aug 6 15:49:12 CEST 2008 

It looks like MySQL is not allowing access from the openCMS ip address.

java.sql.SQLException: Access denied for user
'java_opencms'@'192.168.0.24'

Check MySql to see if it allows db connection from
java_opencms at 192.168.0.24


Aaron N Wagner
Web Developer, Office of Public Affairs
http://www.deq.virginia.gov
DEQ - Virginia Department of Environmental Quality
[W] 804.698.4265
 
There are 10 types of people in the world: those who understand binary,
and those who don't. 
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-
> bounces at opencms.org] On Behalf Of Anand Agrawal
> Sent: August 06, 2008 09:33
> To: The OpenCms mailing list
> Subject: Re: [opencms-dev] new opencms user
> 
> Hi Olivier,
> Ya the stack trace of error send by me shown 1912 but after that i
typed
> correctly for 192.168.0.7.Then again same error is displayed. I am
again
> sending the stack trace of error.
> 
> 
>    It was not possible to create a database connection with the given
> parameters.
> Please check the Exception below. There can be two reasons for this
> error:
>       * Your database is down, or
>       * Your database is not accessible with the given connection
>         parameters.
> Be also aware that Alkacon recommends to use the following JDBC
drivers
> for MySQL 4.1.x & 5.0.x:
> [mysql-connector-java-5.0.7-bin.jar]
> 
> Check that the Jdbc drivers are included in your class path.
> 
> 
> Error connecting to database using: "jdbc:mysql://192.168.0.7:3306/".
> -------------------------------------------
> java.sql.SQLException: Access denied for user
> 'java_opencms'@'192.168.0.24' (using password: YES) at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) at
> com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421) at
> com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) at
> com.mysql.jdbc.Connection.createNewIO(Connection.java:2748) at
> com.mysql.jdbc.Connection.(Connection.java:1553) at
>
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:28
5)
> at java.sql.DriverManager.getConnection(DriverManager.java:582) at
> java.sql.DriverManager.getConnection(DriverManager.java:185) at
> org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:480) at
>
org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp._jspSer
vi
> ce(step_005f4a_005fdatabase_005fvalidation_jsp.java:73) at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
>
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va
> :332) at
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
ti
> onFilterChain.java:252) at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
er
> Chain.java:173) at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.
> java:213) at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.
> java:178) at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:1
> 26) at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:1
> 05) at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
ja
> va:107) at
>
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48
> ) at
>
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
> at
>
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
es
> sConnection(Http11BaseProtocol.java:664) at
>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.j
> ava:527) at
>
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
er
> WorkerThread.java:80) at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.j
> ava:684) at java.lang.Thread.run(Thread.java:619)
> 
> 
> There is no meaning for this button.
> 
> 
> 
> 
> On Wed, 2008-08-06 at 15:16 +0200, Chirouze Olivier wrote:
> > I missed something: the error says: UnknownHostException:
1912.168.0.7.
> > Notice the first part? 1912! Not 192...
> >
> > So you must have mistipped it somewhere. Check that you entered 192
and
> > not 1912.
> >
> > Olivier
> >
> >
> > > -----Original Message-----
> > > From: Anand Agrawal [mailto:ananda at halosys.com]
> > > Sent: 06 August 2008 15:04
> > > To: Chirouze Olivier
> > > Subject: RE: [opencms-dev] new opencms user
> > >
> > > Hi Olivier,
> > >
> > > According to your advice i check whether database is running
> > > 192.168.0.7
> > > on port 3306 or not. Database is properly running on the given ip
and
> > > port.But for this database i haven't administrative power .Also i
am
> > > going to install this cms on the tomcat server version 5.5.16
which
> > > resides on my local system .And database is running on the
> > > other server.
> > > Please give me any other solution so that i could solve my
problem.
> > >
> > > Thanks
> > >
> > > Anand Agarwal
> > >
> > >
> > >
> > > On Wed, 2008-08-06 at 14:37 +0200, Chirouze Olivier wrote:
> > > > Hi,
> > > >
> > > > Your database is not running 192.168.0.7 on port 3306: you
> > > must either
> > > > find the proper IP/port or check that the DB is properly
running.
> > > >
> > > > Olivier
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: opencms-dev-bounces at opencms.org
> > > > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of
> > > Anand Agrawal
> > > > > Sent: 06 August 2008 14:28
> > > > > To: opencms-dev at opencms.org
> > > > > Subject: [opencms-dev] new opencms user
> > > > >
> > > > > Hi,
> > > > > I am new developer using OpenCms. While I am doing
installation of
> > > > > opencms then in the setup wizard for database I got the
> > > > > following error.
> > > > > ie I am not able to setup the opencms for this database
connection
> > > > > problem.
> > > > >
> > > > >
> > > > >
> > > > >    It was not possible to create a database connection
> > > with the given
> > > > > parameters.
> > > > > Please check the Exception below. There can be two
> > > reasons for this
> > > > > error:
> > > > >       * Your database is down, or
> > > > >       * Your database is not accessible with the given
connection
> > > > >         parameters.
> > > > > Be also aware that Alkacon recommends to use the following
> > > > > JDBC drivers
> > > > > for MySQL 4.1.x & 5.0.x:
> > > > > [mysql-connector-java-5.0.7-bin.jar]
> > > > >
> > > > > Check that the Jdbc drivers are included in your class path.
> > > > >
> > > > >
> > > > > Error connecting to database using:
> > > "jdbc:mysql://192.168.0.7:3306/".
> > > > > -------------------------------------------
> > > > > com.mysql.jdbc.CommunicationsException: Communications link
> > > > > failure due
> > > > > to underlying exception: ** BEGIN NESTED EXCEPTION **
> > > > > java.net.UnknownHostException MESSAGE: 1912.168.0.7
STACKTRACE:
> > > > > java.net.UnknownHostException: 1912.168.0.7 at
> > > > > java.net.InetAddress.getAllByName0(InetAddress.java:1157) at
> > > > > java.net.InetAddress.getAllByName(InetAddress.java:1083) at
> > > > > java.net.InetAddress.getAllByName(InetAddress.java:1019) at
> > > > > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFac
> > > > > tory.java:246) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
> > > > > at
> > > > > com.mysql.jdbc.Connection.createNewIO(Connection.java:2744)
> > > > > at com.mysql.jdbc.Connection.(Connection.java:1553) at
> > > > > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv
> > > > > er.java:285) at
> > > > > java.sql.DriverManager.getConnection(DriverManager.java:582)
> > > > > at
> > > > > java.sql.DriverManager.getConnection(DriverManager.java:185)
> > > > > at
> > > > > org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:480
> > > > > ) at
> > > > > org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_j
> > > > > sp._jspService(step_005f4a_005fdatabase_005fvalidation_jsp.jav
> > > > > a:73) at
> > > > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java
> > > > > :97) at
> > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > > > at
> > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServlet
> > > > > Wrapper.java:332) at
> > > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> > > > > .java:314) at
> > > > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:2
> > > > > 64) at
> > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > > > at
> > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
> > > > > er(ApplicationFilterChain.java:252) at
> > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> > > > > cationFilterChain.java:173) at
> > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> > > > > rapperValve.java:213) at
> > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC
> > > > > ontextValve.java:178) at
> > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> > > > > Valve.java:126) at
> > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> > > > > Valve.java:105) at
> > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> > > > > gineValve.java:107) at
> > > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap
> > > > > ter.java:148) at
> > > > > org.apache.coyote.http11.Http11Processor.process(Http11Process
> > > > > or.java:869) at
> > > > > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHa
> > > > > ndler.processConnection(Http11BaseProtocol.java:664) at
> > > > > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolT
> > > > > cpEndpoint.java:527) at
> > > > > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(Le
> > > > > aderFollowerWorkerThread.java:80) at
> > > > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > > > > ThreadPool.java:684) at java.lang.Thread.run(Thread.java:619)
> > > > > ** END NESTED EXCEPTION ** Last packet sent to the server was
> > > > > 1 ms ago. at
> > > > > com.mysql.jdbc.Connection.createNewIO(Connection.java:2820)
> > > > > at com.mysql.jdbc.Connection.(Connection.java:1553) at
> > > > > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv
> > > > > er.java:285) at
> > > > > java.sql.DriverManager.getConnection(DriverManager.java:582)
> > > > > at
> > > > > java.sql.DriverManager.getConnection(DriverManager.java:185)
> > > > > at
> > > > > org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:480
> > > > > ) at
> > > > > org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_j
> > > > > sp._jspService(step_005f4a_005fdatabase_005fvalidation_jsp.jav
> > > > > a:73) at
> > > > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java
> > > > > :97) at
> > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > > > at
> > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServlet
> > > > > Wrapper.java:332) at
> > > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> > > > > .java:314) at
> > > > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:2
> > > > > 64) at
> > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > > > at
> > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
> > > > > er(ApplicationFilterChain.java:252) at
> > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> > > > > cationFilterChain.java:173) at
> > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> > > > > rapperValve.java:213) at
> > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC
> > > > > ontextValve.java:178) at
> > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> > > > > Valve.java:126) at
> > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> > > > > Valve.java:105) at
> > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> > > > > gineValve.java:107) at
> > > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap
> > > > > ter.java:148) at
> > > > > org.apache.coyote.http11.Http11Processor.process(Http11Process
> > > > > or.java:869) at
> > > > > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHa
> > > > > ndler.processConnection(Http11BaseProtocol.java:664) at
> > > > > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolT
> > > > > cpEndpoint.java:527) at
> > > > > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(Le
> > > > > aderFollowerWorkerThread.java:80) at
> > > > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > > > > ThreadPool.java:684) at java.lang.Thread.run(Thread.java:619)
> > > > >
> > > > > My database name is :-java_opencms
> > > > > username is         :java_opencms
> > > > > password is         : halo123DB
> > > > >
> > > > > So please help me as soon as possible so that i could
> > > continue my work
> > > > > without any interruption.
> > > > >
> > > > >
> > > > > Thanks
> > > > >
> > > > > Anand Agarwal
> > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > 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/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/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/mailman/listinfo/opencms-dev

More information about the opencms-dev mailing list