Skip to main content

Update Database Settings on Key Manager

On all the Key Manager back ends, update the database settings in /opt/sshmgr/app/localsettings.py:

  • Set the PORT and HOST parameters to empty strings.

  • Set the NAME parameter to the SSL SID value defined in tnsnames.ora.

As an example, if your localsettings.py file looked like this:

DATABASES = {
  'default': {
    'ENGINE': 'django.db.backends.oracle',
    'NAME': 'dbname',
    'USER': 'username',
    'PASSWORD': 'password',       
    'HOST': 'oracleserver.db.com',
    'PORT': '1540', 
  }
}

It should look something like this after the necessary changes:

DATABASES = {
  'default': {
    'ENGINE': 'django.db.backends.oracle',
    'NAME': 'SSHMGR_SSL_SID',
    'USER': 'username',
    'PASSWORD': 'password',       
    'HOST': '',
    'PORT': '', 
  }
}

After updating the localsettings.py file, make sure that the permissions (specifically group read permissions for the Nginx web-server user) are correct, and that they did not get modified.

note

You can use ssh-mgr-setup to change the database password in localsettings.py. There are two ways to change the password:

  • $ ssh-mgr-setup --db-user-password=<the new password>

    OR

  • $ ssh-mgr-setup --change-db-passwd

The latter will prompt you to enter the new password (twice), and update the password in localsettings.py. After changing the password you must restart the back end and/or front end running on the host for the change to take effect.