[opencms-dev] install opencms on two separate server

[Joe Desbonnet]

Try accessing MySQL from the command line on the OpenCms machine, eg

mysql --user=root --host=192.158.0.21

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.

Joe.


On 5/22/06, lxbing113 <lxbing113 at 163.com> wrote:
>
>  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    OpenCms Connection    Connection
> String   Database     Create database and tables
> 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
>
>
>
>
>
>
>
>
>
>
> 你 不 想 试 试 今 夏 最 "酷" 的 邮 箱 吗 ？
> 蕴 涵 中 华 传 统 文 化 于 世 界 一 流 科 技 之 中，创 新 Ajax 技 术，126 "D 计 划"火 热 体 验 中 ！
> <http://www.126.com/>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060522/71795741/attachment.htm>