Also, make sure port 3306 (or whatever your MySQL is using) is open on your firewall, if there is one on the CF machine (or one between your CF and MySQL).
Cutter _________________ http://blog.cutterscrossing.com Steven Erat wrote: > In short, the problem is "Connection refused" when attempting to > establish a tcp connection from the driver to the database. > > Check the database ip and port number used in the datasource > configuration. > > Can you connect from another application on the same machine as > ColdFusion? Perhaps using the MySQL Administrator (available from > mysql.com). > > -Steven Erat > > > >>-----Original Message----- >>From: Jason T. Slack [mailto:[EMAIL PROTECTED] >>Sent: Tuesday, November 21, 2006 8:26 AM >>To: CF-Talk >>Subject: MySQL Datasource error >> >>I am trying to create a datasource in the CF administrator using the >>MySQL 5 Connector/J driver. >> >>I get the following exception that I dont see what is going wrong: >> >>Can anybody point this out? >> >>-Jason >> >> * Connection verification failed for data source: webPOS >> 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:276) at com.mysql.jdbc.Connection.createNewIO >>(Connection.java:2666) at com.mysql.jdbc.Connection.(Connection.java: >>1531) at com.mysql.jdbc.NonRegisteringDriver.connect >>(NonRegisteringDriver.java:266) at >>coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection >>(JDBCPool.java:562) at >>coldfusion.server.j2ee.sql.pool.ConnectionRunner >>$RunnableConnection.run(ConnectionRunner.java:67) at >>java.lang.Thread.run(Thread.java:552) ** END NESTED EXCEPTION >>** Last > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
