Solved

Unable to create mysql datasource from CFadmin

Posted on 2011-03-10
6
1,285 Views
Last Modified: 2012-08-13
Hi,
I keep getting the following error when creating a new datasource for mysql 5 in cfadmin.
I have about 15 already working, my database is running fine and what even more confusion is that if I edit an existing datasource to point at my new database it works first time.

Has anyone come across this as I am running out of old datasources to rename and edit.

Connection verification failed for data source: myDataSource
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.
0
Comment
Question by:Lmillard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 1

Accepted Solution

by:
witsCOMPUTING earned 500 total points
ID: 35096029
I think you have limit of connection on your MySQL.

Try executing following query:

set global max_connections = 2000;

0
 
LVL 16

Expert Comment

by:Gurpreet Singh Randhawa
ID: 35096436
Just Start your mysql server that is why it is showing an Error

Could not create connection to database server. Attempted reconnect 3 times. Giving up.

the above line states that it is looking if the mysql server is started or not, it tries for three times and then it gives up!

Just make sure your mysql server is started and working

have to installed wamp or xamp server, if any one, just click on wamp and start its services, it will work then

Cheers
0
 

Author Comment

by:Lmillard
ID: 35098165
This is a development server running on my windows laptop, there were only about 5 connections runing at the time and the server was up and running for everything else other than the CF admin datasource connection.
0
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

 
LVL 1

Expert Comment

by:witsCOMPUTING
ID: 35098182
@Lmillard: Did you tried increasing connection limit?
0
 

Author Closing Comment

by:Lmillard
ID: 35098232
Just tried and worked perfectly thanks,
0
 
LVL 16

Expert Comment

by:Gurpreet Singh Randhawa
ID: 35098268
Great catch Thanks for the Info @wits
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question