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

Comments

Post a Comment

Popular posts from this blog

VIDIOC_S_FMT error 16, Device or resource busy - Raspberry Pi Forums

-
dear all, working on image processing using raspberry pi, have installed intex usb web camera on raspberry pi. have used basic python script of image processing https://www.cl.cam.ac.uk/projects/raspb ... first.html required libraries installed on raspberry pi. script code: import imgproc imgproc import * # open webcam take pictures camera = camera(160, 120) # open viewer window display images viewer = viewer(160, 120, "the first step") # take picture camera img = camera.grabimage() # display image in viewer viewer.displayimage(img) # iterate on each pixel in image x in range(0, img.width): for y in range(0, img.height): # value @ xth column , yth row, place intensities variables red, green, blue = img[x, y] # test find colour dominant if red > green , red > blue: # red dominant, set pixel red img[x, y] = 255, 0, 0 elif green > red , green > blue: img[x, y] = 0, 255, 0 else: # if red or gr...
Read more

using a laptop skeleton to build a pi laptop - Raspberry Pi Forums

-
Image
i have laptop dead motherboard . can remove components laptop , in anyway possible connect raspberry pi inbuilt display , keyboard on laptop ? (and touchpad if possible). (i figured remove components inside , fix pie inside , use extended usb cable , connect available usb ports respective holes in laptop skeleton, same headphone out ) . i'm noob when comes pi . on topic appreciated if screen lvds type may possible use screen installing converter board. this: http://www.ebay.com/itm/hdmi-dvi-vga-dr ... 3027&rt=nc need model number of screen , ask seller if work. or search ebay using brand , model number. assuming screen in working order..... back-light not burnt out etc.. other devices...... can used if have usb interface not part of motherboard. have make connector. raspberrypi
Read more

Smoothing Capacitor value?

-
Image
hi everyone! i have question "smoothing capacitors". have 5v arduino project have 6 individual 5v components attached it. since need these running @ different times, wanted take similar approach of nick gammon's in helpful example (http://www.gammon.com.au/forum/?id=12106) , use few mosfets switch these little guys on & off individually (instead of regular arduino pins), while minimizing potential power surges affect microcontroller and/or components themselves. these components 5v, , have maximum draw of ~170ma when powered on @ same time. so, if used 6 different mosfet switches turn switch +5v power line on each component directed via arduino uno, wondering: 1. still use 1 capacitor (like nick did in example)? 2. capacitor of 100uf work, or should use bigger? my plan first test circuit mosfets & capacitor(s) using usb, , later on, moving project battery power. thanks in advance ideas & suggestions! quote these little guys what ...
Read more