Solved

Unable to create mysql datasource from CFadmin

Posted on 2011-03-10
6
1,223 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 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
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.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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