Home

Welcome to the DBS wiki!

How to connect a DBS server to a database

1. Create a set of db accounts, please see instructions https://cern.service-now.com/service-portal/article.do?n=KB0000829

• cms_x_y_owner
• cms_x_y_admin
• cms_x_y_writer
• cms_x_y_reader You may define x or y to whatever is meaningful to you. The important here is that you have four accounts: owner, admin, writer and reader.

2. edit https://github.com/dmwm/DBS/blob/master/Schema/DDL/create-oracle-schema.sql You need to edit this file to create new roles and assign them the accounts you ask the DBA created for you. Note you have to modify the create-oracle-schema.sql to get unique roles for your database. Fail to do so, the script will not run.
3. Logging to the cms_x_y_owner account and run create-oracle-schema.sql.
4. Prepare the db secrets file DBSSecrets.py

dbs3_xy_db = {'connectUrl' : { 'reader' : 'oracle://cms_x_y_reader:pd1@db_server_name', 'writer' : 'oracle://cms_x_y_writer:pd2@db_server_name' }, 'databaseOwner' : 'cms_x_y_owner' }

5. save DBSSecrets.py in auth/dbs

6. in /config/dbs, modify DBS.py to use the proper accounts defined DBSSecrets.py