MySQL Connection Problem

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 sysctl , phpmyadmin): //juniperweb/jsihome.com
mysql listening port (verified phpmyadmin): 3306

apache web server: works
php: works
mysql: works 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 following error:

connection verification failed data source: junipersys-other
com.mysql.jdbc.communicationsexception: communications link failure due 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(connectionrunner. java:67)
at java.lang.thread.run(thread.java:619)
** end nested exception **
last packet sent server 0 ms ago.
the root cause that: com.mysql.jdbc.communicationsexception: communications link failure due 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 appreciated.

dan parchman
it technician
email: dan@junipersys.com
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

juniperdan wrote:
> 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 sysctl , phpmyadmin): //juniperweb/jsihome.com

that not valid hostname. "juniperwb" hostname or
"jsihome.com", not that. make sure have valid hostname
according rules of dns or use ip address.

jochem


--
jochem van dieten
adobe community expert coldfusion

More discussions in Database Access

adobe