Hello Xiao Bing,<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> </div><span></span><div> Hi joe:<br>
frist,thank you for your advise; i type the commond and get a error :<br>
<br>
dev10 ~ # mysql -user=root -host=<a href="http://192.168.0.21" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.0.21</a></div></div></blockquote><div><br>
Joe let you write as <br>
<br>
mysql --user=root --host=<a href="http://192.158.0.21/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.158.0.21</a><br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div>
ERROR 2005 (HY000): Unknown MySQL server host 'ost=<a href="http://192.168.0.21" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.0.21</a>' (3)</div></div></blockquote><div><br>
Or from the above error message, you get a hint to write as<br>
<br>
mysql -u=root -h=<a href="http://192.158.0.21/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.158.0.21</a><br>
<br>
See the difference?<br>
<br>
Good luck.<br>
<br>
- RuiXian<br>
<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div>
whiche config file of mysql should i modify ? I see the my.conf, it has no information about <br>
the problem ! Look forward to your feedback ,appreciate!<br>
xiao bing<br>
2006-05-22<br>
</div><div> </div><div> </div><blockquote style="border-left: 2px solid rgb(160, 198, 229); padding-left: 5px; margin-left: 5px; margin-right: 0px;"><hr color="#a0c6e5" size="1"><br>-----原始邮件-----<br>发件人:"Joe Desbonnet"
<br>发送时间:2006-05-22 18:09:18<br>收件人:"The OpenCms mailing list" <br>抄送:(无)<br>主题:Re: [opencms-dev] install opencms on two separate server<br><br><br>From: "Joe Desbonnet" <br>To: "The OpenCms mailing list"
<br>Date: Mon, 22 May 2006 18:09:18 +0800 (CST)<br>Subject: Re: [opencms-dev] install opencms on two separate server<br><br>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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
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>
</div></blockquote></div></blockquote><br><br><br>
</div></blockquote></div><br>