Making API and INIT listen to external DB

luke · September 28, 2023, 7:12am

Hello!

I’m trying to deploy the API and DB seperatly since i’m getting issues with connecting to the DB.

How can i customize my application so that it no longer tries to connect to localhost:5432 but rather a URL.

Thanks

amandus · October 5, 2023, 2:32pm

you would probably need to switch the host and port parameters in the ops_settings_docker.yml
to your url and port (80 if default port). But i’m not sure if the connection will work with URLs.

That’s the place it will use the config values:

github.com

GIScience/openpoiservice/blob/bb0c89ce797e7c3830a48c676d69a6fbadf3786c/openpoiservice/server/config.py#L21


      
          
              WTF_CSRF_ENABLED = True
              DEBUG_TB_ENABLED = False
              DEBUG_TB_INTERCEPT_REDIRECTS = False
          
          
          class ProductionConfig(BaseConfig):
              """Production configuration."""
          
              SQLALCHEMY_DATABASE_URI = 'postgresql://{}:{}@{}:{}/{}'.format(pg_settings['user_name'], pg_settings['password'],
                                                                             pg_settings['host'], pg_settings['port'],
                                                                             pg_settings['db_name'])
              DEBUG_TB_ENABLED = False
              SQLALCHEMY_TRACK_MODIFICATIONS = False
          
          
          class DevelopmentConfig(BaseConfig):
              """Production configuration."""
          
              SQLALCHEMY_DATABASE_URI = 'postgresql://gis_admin:admin@localhost:5433/gis'
              DEBUG_TB_ENABLED = True

if you want to edit stuff.

Best regards