Page History

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. :

define('PEERINGDB_HOST', 'localhost');

define('PEERINGDB_USERNAME', 'root');

define('PEERINGDB_PASSWORD', 'mypass');

define('PEERINGDB_NAME', ‘peeringdb');

This will change Settings section in the Peering area so it will now show the database status, instead of asking you for an account API KEY.

Installation:

For local customers, they can find install instructions for the PeeringDB Python Client here:

https://peeringdb.github.io/peeringdb-py/

You may create a config file as follows:

$ cat .peeringdb/config.yaml 
orm:
  backend: django_peeringdb
  database:
    engine: mysql
    host: localhost
    name: peeringdb
    password: supers3cr3t
    port: 0
    user: peeringdb
  migrate: true
  secret_key: ''
sync:
  api_key: YOUR_API_KEY
  only: []
  password: ''
  strip_tz: 1
  timeout: 0
  url: https://www.peeringdb.com/api
  user: ''

Sync set up:

To run a sync of PeeringDB:

. pdbvenv/bin/activate
peeringdb sync

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. 


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. 

Image Added

If the database fails to connect, a warning and error message will display instead:

Image Added