Getting this error: CDbConnection failed to open the DB connection."

Connecting to SQL
1

Ok, so I resolved an earlier isssue, and gained access into my api doc, but when I want to get the list of tables on my remote mysql database, I get this error Failed to launch service “sql”: CDbConnection failed to open the DB connection." I’m connecting to a remote mysql database on a shared web host. What do I do.

2

You should check your DreamFactory logs to see the full error message. This will give you the first troubleshooting step.

3

@jeffreystables Where to check DF logs? Sry I don’t see any options in admin console.

4

Information on finding your logs: https://github.com/dreamfactorysoftware/dsp-core/wiki/Installation-Troubleshooting#logs

5

@formerstaff is correct, there is no UI component to view the logs as they’re stored in your filesystem. You will need to follow the documentation and read the text files yourself.