[opencms-dev] about how to resolve the rejecting connec tion

[RuiXian BAO]

Hello Xiao Bing,

On 5/22/06, lxbing113 <lxbing113 at 163.com> wrote:
>
>
>  Hi joe:
>     frist,thank you for your advise; i type the commond and get a error :
>
> dev10 ~ # mysql -user=root -host=192.168.0.21
>

Joe let you write as

 mysql --user=root --host=192.158.0.21

ERROR 2005 (HY000): Unknown MySQL server host 'ost=192.168.0.21' (3)
>

Or from the above error message, you get a hint to write as

mysql -u=root -h=192.158.0.21

See the difference?

Good luck.

- RuiXian


whiche config file of mysql  should i modify ? I see the my.conf, it has no
> information about
> the problem ! Look forward to your feedback ,appreciate!
>                                                          xiao bing
>                                                          2006-05-22
>
>
>
> ------------------------------
>
> -----原始邮件-----
> 发件人:"Joe Desbonnet"
> 发送时间:2006-05-22 18:09:18
> 收件人:"The OpenCms mailing list"
> 抄送:(无)
> 主题:Re: [opencms-dev] install opencms on two separate server
>
>
> From: "Joe Desbonnet"
> To: "The OpenCms mailing list"
> Date: Mon, 22 May 2006 18:09:18 +0800 (CST)
> Subject: Re: [opencms-dev] install opencms on two separate server
>
> 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060523/9db6cd25/attachment.htm>