creating a connection pool

[hyesol]

Hi,

I recently created a new environment and am attempting to connect with DigitalOcean6. We followed the instructions from this guide under section (b) "Building a Database." However, when I try to create a connection pool, it seems there is no connection between the database and Warwulf.

I modified the hyesol_newdb-database.yaml file:

default:
  ENGINE: django.db.backends.postgresql
  HOST: ****
  NAME: simmate01
  USER: ****
  PASSWORD: ****
  PORT: ****
  OPTIONS:
    sslmode: require

But when I run:

from simmate.configuration import settings
print(settings.database)  # this should display your connection info!

it returns:
{'engine': 'django.db.backends.sqlite3', 'name': PosixPath('/home/WarrenLab/simmate/hyesol_newdb-database.sqlite3')}.
Am I missing something here? Could you provide some guidance on how to resolve this?

Thank you!

[jacksund]

The settings module was refactored in the last year, so the yaml will look slightly different. The docs have the updated versions, so you might want to go back through them! And as always, let me know where docs could be cleaned up and improved

Here is your setup (the old way to configure a database):

# Inside the file `hyesol_newdb-database.yaml`
default:
  ENGINE: django.db.backends.postgresql
  HOST: ****
  NAME: simmate01
  USER: ****
  PASSWORD: ****
  PORT: ****
  OPTIONS:
    sslmode: require

And the new way to configure the database:

# Inside the file `hyesol_newdb-settings.yaml`
database:
  engine: django.db.backends.postgresql
  host: ****
  name: simmate01
  user: ****
  password: ****
  port: ****
  options:
    sslmode: require

The differences are:

• file name switched from *database.yaml to *settings.yaml (because the settings file can now handle other configs like apps and website settings)
• main keyword changed from default to database (to help clarify what these settings are for now that there are other config options in the file)
• database args are now lowercase

Try playing around with the command simmate config show --help (I believe this is in 0.17.0... if not, let me know and I'll issue a new release). That command will show you a full settings.yaml file with all the default settings + your user-specified settings