[opencms-dev] install opencms on two separate server

[lxbing113]

 Hello list:

       I need to install opencms 6.2.0 on two separate mechines ,one is mysql db server and the 

other is application server(installed tomcat java enveroment and so
on),I install opencms following the normal step ,and set the parameter
like this:




 
		User
		Password
		 
	
	
		Setup Connection
		
		
		

	
	
		OpenCms Connection
		
		
		

	
	
		Connection String
		
		

	
	
		Database
		
		

	
	
		 
		 Create database and tables 
		
		



because mysql has no password,so I leave the item blank, and Connecting String is :

jdbc:mysql://192.168.0.21:3306  

 192.168.0.21 is internal ip of the LAN(local area network),port is 3306.

when i go to next step, I got the 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, orYour 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-3.1.12-bin.jar]

									Check that the Jdbc drivers are included in your class path.


									Error connecting to database using: "jdbc:mysql://192.168.0.21:3306/"



com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
	at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
	at com.mysql.jdbc.Connection.(Connection.java:1485)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:267) at
org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp._jspService(step_005f4a_005fdatabase_005fvalidation_jsp.java:70)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at





I know a little about mysql, if mysql db server and application
server are on the same mechine, opencms installing  roll my hoop!
but why in two separate mechine,it shows the error? I need to config
mysql for TCP/IP connecting or I need another mysql-conner-driver for 

this installing? ( I use liux gentoo OS )

any advise appreciate! 




                                                                  
xiao bing

                                                              
    2006-05-22




  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060522/ffdeeff6/attachment.htm>