ColdFusion 10 Dev on Mac / MAMP / Trouble connecting MySQL 5 Datasource

3 replies
773 views
Translate

Hey,

I'm running ColdFusion Dev 2016.0.03.301771. When I try to add a MySQL 5 Datasource to connect a DB I am getting the following error:

Connection verification failed for data source: xxx1_dbname

java.sql.SQLException: Timed out trying to establish connection

The root cause was that: java.sql.SQLException: Timed out trying to establish connection

Anyone know how I could fix this? I've tried reconfiguring the webserver configuration but it doesn’t seem to help. Could really use some help getting this setup.

Thanks!

This topic is closed to new replies. Start a new post to keep the conversation going.

W

wyclefAuthor

Participating Frequently

Ok, this was a local database server. I had the port to MySQL incorrect and now am able to verify the MySQL datasource. Now the problem is, if I go to 127.0.0.1:8888/mysite the site is not displaying, I'm just seeing the raw content and the CF tags in the source. I have set the directory index to index.cfm in MAMPs http.conf file.

DirectoryIndex index.wsgi index.py index.cfm

</IfModule>

What else am I missing here?

Translate

H

haxtbh

Inspiring

This will normally be because a firewall is blocking the port required for it to connect. Is this DB located on the same server.

Translate

W

wonderful_Fountain157F

Inspiring

that error is telling you that coldfusion is timing out while trying to connect to the host. is it a local database server? can you connect to it with mysql client or command line from the same server that coldfusion is on? is there a firewall in between?

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.