| Subject: | MySQL Connection Problem |
|---|---|
| From: | "JuniperDan" <webforumsuser@xxxxxxxxxxxxxx> |
| Date: | Mon, 28 Apr 2008 16:59:27 +0000 (UTC) |
| Newsgroups: | macromedia.coldfusion.database_access |
Operating System: Linux Red Hat v5 (kernal.os release 2.6.18-8.e15) Cold Fusion: Trial Developer Version 8 MySQL version: 5.0.51a MySQL connector (installed in /opt/jrun4/lib): mysql-connector-java-5.1.6-bin.jar Hostname (verified by sysctl and phpMyAdmin): //juniperweb/jsihome.com MySQL Listening port (verified by phpMyAdmin): 3306 Apache web server: works php: works MySQL: works with php Cold Fusion: works (CFIDE/administrator/index.cfm works) Data Source settings tried: Type: MySQL (4/5) CF Data Source Name: junipersys Database: junipersys Server: //juniperweb/jsihome.com Port: 3306 Username: website Password: ******* and: Type: Other CF Data Source Name: junipersys-other JDBC URL: jdbc:mysql://juniperweb/jsihome.com:3306/junipersys Driver Class: com.mysql.jdbc.Driver Username: website Password: ******* Both settings throw the following error: Connection verification failed for data source: junipersys-other com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection refused STACKTRACE: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.(Socket.java:366) at java.net.Socket.(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:173) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:267) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739) at com.mysql.jdbc.Connection.(Connection.java:1553) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java: 589) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(Connecti onRunner.java:67) at java.lang.Thread.run(Thread.java:619) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. The root cause was that: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection refused STACKTRACE: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.(Socket.java:366) at java.net.Socket.(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:173) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:267) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739) at com.mysql.jdbc.Connection.(Connection.java:1553) at com.mysql.jdbc.NonReg... Any help greatly appreciated. Dan Parchman IT Technician Email: dan@xxxxxxxxxxxxxx Phone: 435.774.8992 Web: www.junipersys.com Juniper Systems, Inc. 1132 West 1700 North Logan, UT 84321 Telephone: 435-753-1881 FAX: 435-774-8990 or 435-753-1896 |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | Re: Oracle Thin Client Error when Inserting, ksmith |
|---|---|
| Next by Date: | Cheap Bulova Watches Women's Gold Tone Watches - Bulova Watches Women's Gold Tone Watch Cheapest, blog294 |
| Previous by Thread: | Cheap Tissot Watches PRS200 Watches - Tissot Watches PRS200 Watch Cheapest, taoxiaojie1002 |
| Next by Thread: | Re: MySQL Connection Problem, Jochem van Dieten **AdobeCommunityExpert** |
| Indexes: | [Date] [Thread] [Top] [All Lists] |