Skip to main content
W
wyclef
Participating Frequently
August 24, 2017
Question

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

  • August 24, 2017
  • 3 replies
  • 765 views

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 has been closed for replies.

    3 replies

    W
    wyclefAuthor
    Participating Frequently
    August 25, 2017

    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.

    <IfModule wsgi_module>

            DirectoryIndex index.wsgi index.py index.cfm

    </IfModule>

    What else am I missing here?

    H
    haxtbh
    Inspiring
    August 25, 2017

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

    W
    wonderful_Fountain157F
    Inspiring
    August 24, 2017

    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?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices