Local Installations may opt to sync peering data via the PeeringDB API (recommended), or by self-managing a local database utilizing a cron task to sync data - this option is only recommended for advanced users experiencing heavy loads.
To set a PeeringDB Account, go to Admin Settings → Peering, and enter the Read Only PeeringDB API key. Click "Test" to verify the connection.
When done, click "Save Changes". If successful, the phrase "Account is set" will display above the API key form.
Self-Manage a Local DB (Not Recommended):
Instead of making API requests to PeeringDB, you can now make them to a local PeeringDB copy and sync through either a separate cron job or by using the associated Scheduler Task.
This option is only recommended for advanced users experiencing heavy loads. Most users should utilize the API Key option, above.
Define Constants
To link a provision instance to PeeringDB, define these constants in globals.php, where the values match the actual database that is hosting PeeringDB. :
The database can also be synced using the scheduler. The task needs to know the location of the python virtual environment where peeringdb-py is installed and the directory that hosts the peeringdb-py config file. For information on how to add a scheduler task, see Scheduler Tab.
Customers who are not using a python virtual environment, or who are not running their local peeringdb database on the same server, should be able to set up their own cron task as outlined in the documentation below: https://peeringdb.github.io/peeringdb-py/cli/#sync
View the Status:
Once set up, If the local database is reachable a green success message will display in Admin Settings → Peering Settings.
If the database fails to connect, a warning and error message will display instead:
ProVision versions 7.x and newer
For ProVision versions 7.x and later, ProVision directly interfaces with PeeringDB's API to update exchange and peering data, caching the data for a default time of 12 hours.
This requires a PeeringDB account, and for the account credentials to be set in ProVision. The credentials may either be hard coded into globals.php, or set into the database via the Admin/Peering GUI. See Admin Settings and Peering for detailed information.
Additional Peering constants may be added into globals.php to change the PeeringDB URL between the main and beta site (some users may find the beta site to have faster response times), and to adjust the PeeringDB cache TTL.
For real-time updates, TTL may be set to 0. However, some users may experience severe lag with a TTL = 0; we recommend using a 10 to 15 minute or greater TTL if this occurs.
ProVision versions 5.3.0 to 6.1.2 (Legacy)
For legacy set up (not recommended):
ProVision uses a locally-hosted mirror of the PeeringDB database in order to perform non-edit Peering functions. There are a few steps to take in order to set up your locally hosted instance to coordinate with PeeringDB information.
As of PeeringDB 2.0, SQL dump files are no longer provided. If you are using ProVision 5.3.0 or higher, you must follow this new install process. If you are using a lower version of ProVision, then please follow the instructions in the previous version of this page.
1) Create a new database to store the PeeringDB data. This must be on the same server as the database which is used by ProVision.
2) Download, install, and use the PeeringDB Python Client to populate the database.
3) Once this has been done, edit the ProVision global configuration file located here:
[ProVision Root]/data/globals.php
It must be updated with the following variables to inform ProVision of the location of this new install. The username and password fields correspond to the username and password of the MySQL account which has access to the database (Not the username and password to your PeeringDB account).
This can, but does not have to be, the same MySQL user which is used for the ProVision database. However, the ProVision MySQL user must have at least READ access to the PeeringDB database.
$peeringdb_host = 'localhost'; // Database host must be the same for provision and peering
$peeringdb_username = 'username'; // username for the MySQL user
$peeringdb_password = 'password'; // password for the MySQL user
$peeringdb_db_name = 'peeringdb'; // name of the database in MySQL
4) Periodically sync with the PeeringDB server to get the latest updates. This can be done manually, or there are instructions in the PeeringDB documentation on how to automatically schedule syncs using cron (http://peeringdb.github.io/peeringdb-py/cli/#sync).
Peering Constants
In globals.php, the following constants can be defined to tweak the Peering internals:
PEERINGDB_USERNAME
define('PEERINGDB_USERNAME', 'username');
Default value: none
The username for the account used to connect to the PeeringDB API
Instead of saving the username and password in the database, the values can be hard coded into globals.php
PEERINGDB_PASSWORD
define('PEERINGDB_PASSWORD', 'mypass');
Default value: none
The password for the account used to connect to the PeeringDB API
Customers updated to v8.0.2 and later do not need to take any action and are not affected.
Local customers using versions 8.0.1 or earlier, and who are using Peering (or wish to start using Peering), should perform the following update(s) as applicable to their situation:
A) Existing local customers who already have their peeringdb account details saved in Provision should update PEERINGDB_URL in globals.php to:
B) Customers who wish to begin using Peering (thus, do not already have saved peeringdb account details) will not be able to add their account via the GUI prior to v8.0.2. An attempt to do so will fail the "valid account test", which uses a hardcoded string value.
Instead, affected users must do both of the following: