[opencms-dev] new opencms user

Anand Agrawal ananda at halosys.com
Wed Aug 6 15:33:26 CEST 2008


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: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_jsp._jspService(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.java: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(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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
> 




More information about the opencms-dev mailing list