@jeffreystables thanks for the reply!
I’m not sure where to get the DSP’s logs from, other than the DreamFactory Live API Documentation testing section. I’m not seeing DSP’s info in my standard system log.
Here’s what I’m getting out of the API test when I hit “Try it out!” under the “getTables() - List all table names”, or any of the other test, when running from the DreamFactory Service Platform test I setup. But I’m seeing the same thing out of my own system as well.
"message": "Failed to launch service "dh_mysql": CDbConnection failed to open the DB connection.",
"Date": "Tue, 07 Apr 2015 11:45:03 GMT",
"P3p": "CP=\"IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT\"",
"Cache-Control": "no-store, no-cache, must-revalidate, post-check=0, pre-check=0",
"Content-Type": "application/json; charset=utf-8",
"Expires": "Thu, 19 Nov 1981 08:52:00 GMT"
I can access the remote MySQL DB from the command line on the same system I have DreamFactory installed on. Given that the MySQL version with DreamFactory downloaded seemed to be 5.5 I wondered if it was a version incompatibility.
But I’m just shooting in the dark here. Given the other things I’ve found around the forums now I’m not sure it’s the version, and more likely just a formatting of the access string, or access issue.
I have verified that the end server, where MySQL is, has an exception for my local system (which I’ve tested with command line access to MySQL successfully), and I have added one in for what I found in an obscure post seems to be the DreamFactory Hosted DSPs IP (220.127.116.11). The port is the standard 3306 that the MySQL is accessed over.
I’ve even tested this with other MySQL DBs I have access to, from service providers like DreamHost, and I get the same results.
I will say that all the servers I run, or use from other providers, are running nginx as the front end service and load balancer, and in some cases is the only front end server running (no apache server).
So any info or what to check next would be welcomed!