Question

App platform deployment with Dockerfile not able to access database

Posted on October 9, 2024
MySQL DigitalOcean Managed MySQL Database DigitalOcean App Platform Managed Databases App Platform
Asked by Quenoz Alvareoe

I have this App platform deployment via Dockerfile, it succeeded the deployment but when I try to do some console sql commands it refuses the connection. The App has been added to trusted source unto database and the credentials it uses were correct. I tested it by removing the trusted source and the database connection succeeded. Any idea whats going on and how I’m going to connect my App to database with trusted source enabled?

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby Iliev

Site Moderator

• October 15, 2024

Hey!

As this only fails when you have trusted sources enabled, I would guess that it could be caused by one of those few things:

Double-check that the correct App is added as a trusted source in your Managed Database settings.
Ensure the database credentials (username, password, host, etc.) are set correctly as environment variables in the App Platform. You can do this through the App Platform settings.
Make sure that you only connect to the database during the deploy stage and not during the build stage. During the build stage, your app platform will not have access to the database cluster even if it is added to the trusted sources.

Let me know how it goes!

- Bobby