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
: Timed out trying to establish connection
The root cause was that:: 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.
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?
This will normally be because a firewall is blocking the port required for it to connect. Is this DB located on the same server.
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
What else am I missing here?