Databases¶
Pending on your level of access, you might be able to access the databases listed below.
If you're getting errors, or feel you should have permissions please contact your manager with the relevant information.
You should connect to the VPN, then only use the host name you require plus the usual mysql port 3306 and then your relative username and password.
The external port is for when the VPN is down and youre connecting from outside the Positive Internet network.
External Connection¶
If you are not on the VPN, you can access the DBs via the external host:port. You can do this while working from the Cardiff office, as the office IP has already been white listed in Positive Internet. You can connect from home, for example if the VPN is down for some reason, but you will need to request your IP be white listed by Positive Internet.
Here is the external host IP:
80.87.128.37
Please see the tables below for the relevant external addresses/ports needed to access the DB you want.
Development Database¶
This is the database that holds all Cubed developers' DBs. Please log in with the credentials you were given via email.
| account | internal connection | external connection | database |
|---|---|---|---|
| {dev user} | 10.3.63.32:3306 | 80.87.128.37:9921 | {dev user}_attrib |
Staging Database¶
The staging database is where we test before deploying to live. Currently (2022 Q3) we have this still in our Amazon account. Please log in with your relevant credentials.
Here you will find attrib (which holds cubed account(s) and cubed user(s), seopt (which holds all seopt config and centralised data pulls), and finally command (which holds all configuration needed to run and manage command(s) across all cubed account(s))
| account | internal connection | external connection | database |
|---|---|---|---|
| config | 10.3.63.31:3306 | 80.87.128.37:9922 | attrib |
| command | 10.3.63.31:3306 | 80.87.128.37:9922 | command |
| seopt | 10.3.63.31:3306 | 80.87.128.37:9922 | seopt |
Live Test Accounts¶
These accounts exist within our production servers, but server as a "live environment" test bed for different purposes.
| account | internal connection | external connection | database | info |
|---|---|---|---|---|
| sandbox | 10.3.61.83:3306 | 80.87.128.37:9920 | cubed_a_sandbox_uk | Sandbox account to use as demo |
| pydcs t | 10.3.61.83:3306 | 80.87.128.37:9920 | cubed_a_pydcs_t | Test account for our DCS |
| facebook dev | 10.3.61.83:3306 | 80.87.128.37:9920 | cubed_a_facebook_dev | Account for Facebook admins to check our API process |
Production Databases¶
| account | internal connection | external connection | database | info |
|---|---|---|---|---|
| config | 10.3.61.151:3306 | 80.87.128.37:9906 | attrib | Data for legacy commands, logs, account and user data |
| command | 10.3.61.153:3306 | 80.87.128.37:9907 | command | Information for commands setup and state |
| seopt | 10.3.61.152:3306 | 80.87.128.37:9908 | seopt | Holds all data and configuration |
Client Accounts¶
Clients can hold their DBs internally or allow us to host them.
Hosted by Positive¶
| account | internal connection | external connection | database |
|---|---|---|---|
| visitscot uk | 10.3.61.160:3306 | 80.87.128.37:9905 | cubed_a_visitscot_uk |
| visitscot org | 10.3.61.160:3306 | 80.87.128.37:9905 | cubed_a_visitscotorg_uk |
| heritage uk | 10.3.61.156:3306 | 80.87.128.37:9902 | cubed_a_heritage_uk |
| norton uk | 10.3.61.156:3306 | 80.87.128.37:9902 | cubed_a_norton_uk |
| landg uk | 10.3.61.157:3306 | 80.87.128.37:9903 | cubed_a_landg_uk |
| moneysmart hk | 10.3.61.159:3306 | 80.87.128.37:9911 | cubed_a_moneysmart_hk |
| moneysmart sg | 10.3.61.159:3306 | 80.87.128.37:9911 | cubed_a_moneysmart_sg |
| bestinvest uk | 10.3.61.159:3306 | 80.87.128.37:9911 | cubed_a_bestinvest_uk |
| yard uk | 10.3.61.159:3306 | 80.87.128.37:9911 | cubed_a_yard_uk |
| cubed website | 10.3.61.159:3306 | 80.87.128.37:9911 | cubed_a_withcubed_uk |
| cubed dash | 10.3.61.159:3306 | 80.87.128.37:9911 | cubed_a_cubedai_uk |
| westernunion | 10.3.61.162:3306 | 80.87.128.37:9911 | cubed_a_westernunion |
| westernunion gb | 10.3.61.162:3306 | 80.87.128.37:9911 | cubed_a_westernunion_gb |
| westernunion de | 10.3.61.162:3306 | 80.87.128.37:9911 | cubed_a_westernunion_de |
| westernunion br | 10.3.61.162:3306 | 80.87.128.37:9911 | cubed_a_westernunion_br |
| nowcircular au | 10.3.61.156:3306 | 80.87.128.37:9911 | cubed_a_circular_au |
| nowcircular sg | 10.3.61.156:3306 | 80.87.128.37:9911 | cubed_a_circular_sg |