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

[lxbing113]

     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

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



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, orYour 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 计 划"火 热 体 验 中 ！





_______________________________________________
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/18ea6e1f/attachment.htm>