• Before you can configure the databases in Digital Access, you must create the databases manually in the desired database server. It is not required to create tables inside the databases. When Digital Access Admin service starts, it will do a lookup for all the tables and if not found it will create tables automatically.
  
  

Digital Access uses four databases:

The default database name and user for this database is “hag”. If you use another database name and user, make sure to modify it in the configuration accordingly.

1. Log in to Digital Access Admin with an administrator account.

2. Go to Manage System > User Database.

3. In the Database drop-down list, select database. The list contains the default configurations for the databases. If you use other databases which are not listed or need to change the default settings like port, or database drivers to use, then click on Advanced Fields. See also step 6.  Click “?” for more help.

4. Enter Host and Name. The system will convert this information to the form shown in the Advanced Fields.

5. Enter User, Password and Retry Attempts, click “? “For help.

6. If you do not want to configure a database in the Database drop-down list, but need to change the default settings like port, or database drivers to use, click Toggle Advanced Fields and enter Dialect, Url and Driver. Click “?” for help.

7. When done, click Save.

   1. Check Copy all users when you want to copy all users from the current configuration to the one about to be saved.

   2. When this page is saved it will save the information currently displayed. If the settings are saved while displaying the Standard Fields (Database, Host and Name) the information in the Standard Fields will be used, regardless of what manual changes has been made in the Advanced Fields. The same applies the other way around. If the page is saved while displaying the Advanced Fields the information in those fields will be used, regardless of what information might have been entered in the Standard Fields.

8. Publish the configuration.

The default database name and user for this database is “oath”.  If you use another database name and user, make sure to modify it in the configuration accordingly.

1. Log in to Digital Access Admin with an administrator account.

2. Go to Manage System and click OATH Configuration.

3. In the Database drop-down list, select database. The list contains the default configurations for the databases. If you use other databases which are not listed or need to change the default settings like port, or database driver, then click on Advanced Fields. 
   See also step 6. Click “?” for more help.

4. Enter Host and Name, for help click “?” When saving, the system will convert this information to the form shown in the Advanced Fields.

5. Enter User, Password and number of Retry Attempts. Click “?“For help.

6. If you do not want to configure a database in the Database drop-down list, but need to change the default settings like port, or database drivers, click Toggle Advanced Fields and enter Dialect, URL and Driver. For help and examples, click “?”.

7. When done, click Save.
   When this page is saved it will save the information currently displayed. If the settings are saved while displaying the Standard Fields (Database, Host and Name) the information in the Standard Fields will be used, regardless of what manual changes has been made in the Advanced Fields. The same applies the other way around. If the page is saved while displaying the Advanced Fields the information in those fields will be used, regardless of what information might have been entered in the Standard Fields.

8. Publish the configuration.

After the changes to the database connectivity settings have been published, you must restart the Authentication service. A restart is needed since the Authentication service only reads its database settings on startup.

The default database name and user for this Database is “oauth”. If you use another database name and user, make sure to modify it in the configuration accordingly.

1. Log in to Digital Access Admin with an administrator account.

2. Go to Manage System > OpenID Connect (OAuth2) Configuration > Configure Database Connection.

3. In the Database drop-down list, select database. The list contains the default configurations for the databases If you use other databases which is not listed or need to change the default settings like port, or database driver, then click on Advanced Fields. See also step 6. Click “?” for more help.

4. Enter Host and Name, for help click “?”. When saving, the system will convert this information to the form shown in the Advanced Fields.

5. Enter User, Password and number of Retry Attempts. Click “?“ for help.

6. If you want to configure a database not in the Database drop-down list, or need to change the default settings like port, or database drivers, click Toggle Advanced Fields and enter Dialect, URL and Driver. For help and examples, click  “?”.

7. When done, click Save.
   When this page is saved it will save the information currently displayed. If the settings are saved while displaying the Standard Fields (Database, Host and Name) the information in the Standard Fields will be used, regardless of what manual changes has been made in the Advanced Fields. The same applies the other way around. If the page is saved while displaying the Advanced Fields the information in those fields will be used, regardless of what information might have been entered in the Standard Fields.

8. Publish the configuration.