[opencms-dev] install opencms on two separate server

[Jonathan Woods]

I reckon there's a packet filter/firewall running on 192.168.0.21, which is what you would normally want - in this case, it may be that it is closing off access to port 3306 from all except the localhost.  If this is the case, you'll have to open up port 3306 to (say) hosts on the same LAN.
 
Jon
 
  _____  

From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of lxbing113
Sent: 22 May 2006 07:39
To: opencms-dev at opencms.org
Subject: [opencms-dev] install opencms on two separate server
Importance: High


 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	 	 	   <http://localhost:8080/opencms/setup/resources/help.png> 	
OpenCms Connection	 	 	   <http://localhost:8080/opencms/setup/resources/help.png> 	
Connection String	 	   <http://localhost:8080/opencms/setup/resources/help.png> 	
Database	 	   <http://localhost:8080/opencms/setup/resources/help.png> 	
 	  Create database and tables 	  <http://localhost:8080/opencms/setup/resources/help.png> 	

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, 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-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



 
 








你 不 想 试 试 今 夏 最 “酷” 的 邮 箱 吗 ？ 
蕴 涵 中 华 传 统 文 化 于 世 界 一 流 科 技 之 中，创 新  <http://www.126.com/> Ajax 技 术，126 “D 计 划”火 热 体 验 中 ！ 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060522/ac744e24/attachment.htm>