Try accessing MySQL from the command line on the OpenCms machine, eg<br><br>mysql --user=root --host=<a href="http://192.158.0.21">192.158.0.21</a><br><br>If you get an error at this point it's either because MySQL is configured to reject the connection or a firewall is blocking the port.
<br><br>Joe.<br><br><br><div><span class="gmail_quote">On 5/22/06, <b class="gmail_sendername">lxbing113</b> <<a href="mailto:lxbing113@163.com">lxbing113@163.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><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 name="img1" 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 name="img2" 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 name="img3" 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 name="img4" 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 name="img5" 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> <a href="http://192.168.0.21" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.0.21</a> 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></span><br><br><br><br><br><br><div style="border-bottom: 1px solid rgb(153, 153, 153);"></div><br>
<font style="font-size: 14.8px;" color="black">你 不 想 试 试 今 夏 最 "酷" 的 邮 箱 吗 ？</font>
<br>
<a href="http://www.126.com/" style="font-size: 13px; line-height: 160%; color: blue;" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">蕴 涵 中 华 传 统 文 化 于 世 界 一 流 科 技 之 中，创 新 Ajax 技 术，126 "D 计 划"火 热 体 验 中 ！
</a>
</div><br><br>_______________________________________________<br>This mail is sent to you from the opencms-dev mailing list<br>To change your list options, or to unsubscribe from the list, please visit<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">
http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br><br></blockquote></div><br>