Skip navigation
myjeep
myjeep Calculating status...
Currently Being Moderated

Having trouble connecting to mysql 5 ..... Please help...

Aug 24, 2012 1:59 PM

Tags: #mysql

I am not sure what is wrong but I am stuck and some help would be appreciated. I am running ColdFusion Version 9,0,1,274733  Enterprise Edition on Linix 6x with apache connector. I am running 3 instances of ColdFusion. I fire off cfusion like this ./jrun start cfusion . I am using Mysql is mysql 5.1.31sp1- enterprise. Then I use the web browser to connect to the admin portal. Everything works but I cant connect the mysql datasource. I get the follwoing screen.

 

 

 

 

Connection verification failed for data source: weblive

  com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

 

 

 

I can connect to mysql using the GUI admin or command line No problem......It is running on port 3306.

 

 

Please help....................

286 Views   1 Reply   Latest reply: Charlie Arehart, Aug 26, 2012 1:24 PM
 
Replies
  • Charlie Arehart
    Currently Being Moderated
    1. Charlie Arehart,
    Aug 26, 2012 1:24 PM   in reply to myjeep
    Report

    Just as one possible issue, when you say you “can connect to mysql using the GUI admin or command line No problem”, are you doing that from the machine on which you are running CF? Because if you’re doing it from, say a laptop, and CF is on another box, it could be that you have a firewall on the machine running MySQL, and it’s been opened to your laptop but not your server.

     

    I realize this may be “all on one box”. Just had to ask. If that’s the issue, maybe someone else will recognize another problem/solution.

     

     

     

    /charlie

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points