Dreamfactory returning 500 on an active local MySQL DB

REST API
1

My server (a LAMP stack) is running, and I can see that MySQL is listening on port 3306 on localhost (127.0.0.1). So I created a service in the Dreamfactory admin as Remote SQL DB, and the connection as mysql:host=localhost;dbname=testdb I also tried replacing localhost with the ip, and adding the port. But I keep getting "Failed to launch service "maindb": CDbConnection failed to open the DB connection" Any help is very appreciated.

2

Can you telnet localhost 3306?

Beyond that, we will need to see what’s logged in your DSP’s logs when it fails to connect before we know much more.

3

Thanks for responding. I did a local Dreamfactory installation, and it is working now.

1 Like