Create New Account¶
Firstly, if the client database isn’t going to sit within one of our existing database servers, please email positive to get a new database server setup. Please see example email below which was sent to Positive.
Positive Email
Hi, Good news, we have a new client to onboard! We’ll be supporting them in both Singapore and Australia https://www.nowcircular.com/.
Please could we setup a new independent DB server (this is the same request as setting up the new Three (10.3.61.155) and Westernunion (10.3.61.162) databases lately). Please assign the same user access as other our DBs, including all staff + attribroot. Please could you forward on the new DB host when done? 😊 Thankyou!
Once database has been setup and attribroot has access, we then need to SSH into the control server and navigate to /srv/attrib_backend/backend.
Command to run: sudo python3 manage.py control_create_account.
This command will create and confiture the clients database/tables. Follow on screen instructions and fill in requested fields. Check the end results before agreeing to start the command. Before starting you will need:
| Arg | Example | Notes |
|---|---|---|
| Name | My Company | Used as the friendly, command will try and auto generate token and db name based on this. |
| Token | mycompany-uk | The command will auto add c-a- to start of token. Note the location part |
| DB Name | mysql://username:password@connection-string:3306/c_a_mycompany_uk | This will be auto generated based on Name, and will presume Live DB connection. You can create your own connection string - if the DB is requested to be stored elsewhere. |
| Domain | mycompany.com | This is used to generate some patterns and hold for future use. |
Once entered, the command will print an example of what it will generate, please check this before continuing.
A CUBED account will be created and added to the usual attrib.attrib_account table. You should now go to the account configuration section in Cubed dashboard and setup timezone and currency for the account that was just created so the cron can run overnight.
Finally, we need to ask Positive to setup a new DPS Visscore instance for the new client so we can run our real-time propensity models. Please see email sent to Positive.
Positive Email
Hi, Could you please set up a new DPS Visscore instances for our new client Circular so we can run our propensity modelling via SQS. We’d like to setup are: circular-sg (account token: c-a-circular-sg, DB: 10.3.61.156) circular-au (account token: c-a-circular-au, DB: 10.3.61.156) Could we please also remove an old client: nuance-uk-a.
Once done, they would then display in grafana: https://grafana.cubed.engineering/d/iCwiI-g4z/dps-visscore-overview?orgId=1&refresh=30s&from=now-15m&to=now Thankyou!
Once this is setup, tags can be implemented and the client dashboard https://dash.withcubed.com/ will be ready.