External access
Give a system outside the site, such as an order system or a reporting tool, its own login to an environment's database from addresses you choose.
On this page
Before you start
- The organisation that pays for the site turns external access on and off. A user of an agency that manages the site sees Ask your account owner instead.
- External access adds a monthly charge for a dedicated IP address. The dialog shows the price before you accept it.
- Allowed addresses are public IPv4 addresses or ranges from
/32to/28, up to 10. An environment can hold 5 external users.
Turn on external access
Open Database
Go to Managed Websites, choose the site, then Database under Site settings. On the External database access card, choose Turn on….
Enter the first allowed address
Enter the First allowed address and a Label saying whose it is. Tick the box that accepts the monthly charge, then choose the Turn on button.
The card reads Turning on, then On, usually within a few minutes. If it reads Tonight, it is ready in that night's maintenance window.
Add an external user and connect
Add the user
On Database users, choose Add user and the kind External: the rest is as for any database user. Under Limits and TLS (optional), cap its connections and query time, and tick Require TLS (encrypted, not CA-verified).
Connect the outside system
Give the system the Host, Port and Database from the External database access card, with the user's name and password. Use the host name, not the Fixed address: the host name stays the same if the address changes.
Change the allowed addresses
Under Allowed addresses, choose Add an IP address, or Rename or Remove on a row. A change applies in about a minute.
The last address cannot be removed while external access is on.
Turn off external access
Choose Turn off…
Choose Turn off…, type the environment's name, then confirm.
Outside systems lose access straight away and the external users are deleted. The fixed address cannot be got back: turning external access on again gives a new address under the same host name.
The charge stops from that moment.
Automate this
Gives the environment a fixed public address and a host name that only the addresses you list can reach, as a paid add-on charged monthly from when access is on.
curl -X POST https://manage.corefinity.com/api/corestack/sites/1042/external-db/enable \
-H "Authorization: Bearer $COREFINITY_TOKEN" \
-H "Accept: application/json" \
-H "Content-Type: application/json" \
-d '{
"confirm_cost": true,
"sources": [
{
"cidr": "198.51.100.64/29",
"label": "Order system"
}
]
}'Your assistant calls corestack_external_db_enable.
{
"name": "corestack_external_db_enable",
"arguments": {
"site_id": 4211,
"sources": [
{
"cidr": "203.0.113.10/32",
"label": "Order system"
}
],
"confirm_cost": true
}
}