Report this

What is the reason for this report?

App platform deployment with Dockerfile not able to access database

Posted on October 9, 2024
Quenoz Alvareoe

By Quenoz Alvareoe

Software Engineer

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?



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.

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

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.