<div> Hello list:<br>
I need to install opencms 6.2.0 on two separate mechines ,one is mysql db server and the <br>
other is application server(installed tomcat java enveroment and so
on),I install opencms following the normal step ,and set the parameter
like this:<br>
<br>
<table border="0" cellpadding="2" cellspacing="0">
<tbody><tr><td> </td>
<td>User</td>
<td>Password</td>
<td> </td>
</tr>
<tr>
<td>Setup Connection</td>
<td><input name="dbCreateUser" size="8" style="width: 150px;" value="root" type="text"></td>
<td style="text-align: right;"><input name="dbCreatePwd" size="8" style="width: 150px;" value="" type="text"></td>
<td><img id="img1" name="img1" src="http://localhost:8080/opencms/setup/resources/help.png" onmouseout="hideHelp(1);" onmouseover="showHelp(1);" border="0">
</td>
</tr>
<tr>
<td>OpenCms Connection</td>
<td><input name="dbWorkUser" size="8" style="width: 150px;" value="root" type="text"></td>
<td style="text-align: right;"><input name="dbWorkPwd" size="8" style="width: 150px;" value="" type="text"></td>
<td><img id="img2" name="img2" src="http://localhost:8080/opencms/setup/resources/help.png" onmouseout="hideHelp(2);" onmouseover="showHelp(2);" border="0">
</td>
</tr>
<tr>
<td>Connection String</td>
<td colspan="2"><input name="dbCreateConStr" size="22" style="width: 315px;" value="jdbc:mysql://192.168.0.21:3306/" type="text"></td>
<td><img id="img3" name="img3" src="http://localhost:8080/opencms/setup/resources/help.png" onmouseout="hideHelp(3);" onmouseover="showHelp(3);" border="0">
</td>
</tr>
<tr>
<td>Database</td>
<td colspan="2"><input name="db" size="22" style="width: 315px;" value="opencms" type="text"></td>
<td><img id="img4" name="img4" src="http://localhost:8080/opencms/setup/resources/help.png" onmouseout="hideHelp(4);" onmouseover="showHelp(4);" border="0">
</td>
</tr>
<tr>
<td> </td>
<td colspan="2"><input name="createDb" value="true" checked="checked" type="checkbox"> Create database and tables
</td>
<td><img id="img5" name="img5" src="http://localhost:8080/opencms/setup/resources/help.png" onmouseout="hideHelp(5);" onmouseover="showHelp(5);" border="0"></td></tr></tbody>
</table>
<br>
because mysql has no password,so I leave the item blank, and Connecting String is :<br>
jdbc:mysql://192.168.0.21:3306 <br>
</div><div> 192.168.0.21 is internal ip of the LAN(local area network),port is 3306.<br>
when i go to next step, I got the error:<br>
<br>
<br>
It was not possible to create a database connection with the given parameters.<br>
Please check the Exception below. There can be two reasons for this error:<br>
<br>
<ul>
<li><b>Your database is down</b>, or</li><li><b>Your database is not accessible with the given connection parameters.</b></li>
</ul>
<br>
Be also aware that Alkacon recommends to use the
following JDBC drivers for MySQL 4.1.x & 5.0.x:<br>
<code>[mysql-connector-java-3.1.12-bin.jar]</code>
<p>
Check that the Jdbc drivers are included in your class path.<br>
Error connecting to database using: "jdbc:mysql://192.168.0.21:3306/"<br>
</p>
<p>
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<br>
</p>
<p><br>
</p>
<p>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 <br>
this installing? ( I use liux gentoo OS )<br>
any advise appreciate! <br>
</p>
<p><br>
xiao bing<br>
2006-05-22<br>
</p>
<br>
</div><div> </div><div> </div><span id="spnSign"></span><br><!-- footer --><br><br><br><br><br><div style="border-bottom:1px solid #999"></div><br>
<font color="black" style="font-size:14.8px">你 不 想 试 试 今 夏 最 “酷” 的 邮 箱 吗 ？</font>
<br>
<a href="http://www.126.com/" target="_blank" style="font-size:13px;line-height:160%;color:blue">蕴 涵 中 华 传 统 文 化 于 世 界 一 流 科 技 之 中，创 新 Ajax 技 术，126 “D 计 划”火 热 体 验 中 ！
</a>