<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=683364408-22052006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683364408-22052006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683364408-22052006><FONT face=Arial
color=#0000ff size=2>Jon</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683364408-22052006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr align=left><FONT face=Tahoma size=2><B>From:</B>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org] <B>On
Behalf Of </B>lxbing113<BR><B>Sent:</B> 22 May 2006 07:39<BR><B>To:</B>
opencms-dev@opencms.org<BR><B>Subject:</B> [opencms-dev] install opencms on two
separate server<BR><B>Importance:</B> High<BR></FONT><BR></DIV>
<DIV></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 cellSpacing=0 cellPadding=2 border=0>
<TBODY>
<TR>
<TD> </TD>
<TD>User</TD>
<TD>Password</TD>
<TD> </TD></TR>
<TR>
<TD>Setup Connection</TD>
<TD><INPUT style="WIDTH: 150px" size=8 value=root name=dbCreateUser></TD>
<TD style="TEXT-ALIGN: right"><INPUT style="WIDTH: 150px" size=8
name=dbCreatePwd></TD>
<TD><IMG id=img1 onmouseover=showHelp(1); onmouseout=hideHelp(1);
src="http://localhost:8080/opencms/setup/resources/help.png" border=0
name=img1 NOSEND="1"> </TD></TR>
<TR>
<TD>OpenCms Connection</TD>
<TD><INPUT style="WIDTH: 150px" size=8 value=root name=dbWorkUser></TD>
<TD style="TEXT-ALIGN: right"><INPUT style="WIDTH: 150px" size=8
name=dbWorkPwd></TD>
<TD><IMG id=img2 onmouseover=showHelp(2); onmouseout=hideHelp(2);
src="http://localhost:8080/opencms/setup/resources/help.png" border=0
name=img2 NOSEND="1"> </TD></TR>
<TR>
<TD>Connection String</TD>
<TD colSpan=2><INPUT style="WIDTH: 315px" size=22
value=jdbc:mysql://192.168.0.21:3306/ name=dbCreateConStr></TD>
<TD><IMG id=img3 onmouseover=showHelp(3); onmouseout=hideHelp(3);
src="http://localhost:8080/opencms/setup/resources/help.png" border=0
name=img3 NOSEND="1"> </TD></TR>
<TR>
<TD>Database</TD>
<TD colSpan=2><INPUT style="WIDTH: 315px" size=22 value=opencms
name=db></TD>
<TD><IMG id=img4 onmouseover=showHelp(4); onmouseout=hideHelp(4);
src="http://localhost:8080/opencms/setup/resources/help.png" border=0
name=img4 NOSEND="1"> </TD></TR>
<TR>
<TD> </TD>
<TD colSpan=2><INPUT type=checkbox CHECKED value=true name=createDb>
Create database and tables </TD>
<TD><IMG id=img5 onmouseover=showHelp(5); onmouseout=hideHelp(5);
src="http://localhost:8080/opencms/setup/resources/help.png" border=0
name=img5 NOSEND="1"></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><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: #999 1px solid"></DIV><BR><FONT
style="FONT-SIZE: 14px" color=black>你 不 想 试 试 今 夏 最 “酷” 的 邮 箱 吗 ？</FONT> <BR><A
style="FONT-SIZE: 13px; COLOR: blue; LINE-HEIGHT: 160%"
href="http://www.126.com/" target=_blank>蕴 涵 中 华 传 统 文 化 于 世 界 一 流 科 技 之 中，创 新
Ajax 技 术，126 “D 计 划”火 热 体 验 中 ！ </A></BODY></HTML>