Solved

Unable to create mysql datasource from CFadmin

Posted on 2011-03-10
6
1,210 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
  • 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 15

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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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 15

Expert Comment

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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now