Installation of the new provenance server

• [in progress] Provision the server in the inventory (rack position, idrac ips, ips, ...)
• [Done] notify the dsi of the delivery + give the information for the installation
• define the role in puppet
• Install the server

List of packages amended along the way:

• python3-virtualenvwrapper
• libpq-dev
• arcanist

Some more configuration:

• install scripts ./create-db.sh and ./drop-db.sh to ease db maintenance for @aeviso to drop/create dbs

ardumont@met:~% cat drop-db.sh
#!/usr/bin/env bash

DBNAME=$1

sudo -i -u postgres dropdb $DBNAME
ardumont@met:~% cat create-db.sh
#!/usr/bin/env bash

DBNAME=$1

sudo -i -u postgres createdb -p 5433 --lc-ctype=C.UTF-8 -T template0 -O swh-provenance $DBNAME

• Provision 10 dbs through puppet (so pgbouncer is configured as well) (infra/puppet/puppet-swh-site!420)
• at some point, dedicate some vms to andres so he can experiment from those, passing through the internal network (without the vpn)

---

Migrated from T3487 (view on Phabricator)