New in version 1.3.0.
Several Bcfg2 plugins, including Metadata, Probes, and Reporting, can connect use a relational database to store data. They use the global database settings in bcfg2.conf, described in this document, to connect.
Note
Although SQLite is supported as a database, it may cause significant thread contention (and a performance penalty) if you use SQLite with Metadata or Probes. If you are using the database-backed features of either of those plugins, it’s recommended that you use a higher performance database backend.
New in version 1.4.0.
Bcfg2 supports storing the data generated by the Reporting in a separate database from the data generated by the other plugins (e.g. Metadata and Probes). To activate this support, set the reporting_engine, reporting_name, reporting_user, etc. options in the [database] section of the config file. The valid values for the reporting_* options are the same as for the standard database options. See Configuration Options for a full listing.
All of the following options should go in the [database] section of /etc/bcfg2.conf.
| Option name | Description | Default |
|---|---|---|
| engine | The name of the Django database backend to use. See https://docs.djangoproject.com/en/dev/ref/settings/#engine for available options (note that django.db.backends is not included in the engine name) | “sqlite3” |
| name | The name of the database | “/var/lib/bcfg2/etc/bcfg2.sqlite” |
| user | The user to connect to the database as | None |
| password | The password to connect to the database with | None |
| host | The host to connect to | “localhost” |
| port | The port to connect to | None |
| options | Extra parameters to use when connecting to the database. Available parameters vary depending on your database backend. The parameters are supplied as the value of the django OPTIONS setting. | None |
| reporting_engine | The name of the Django database backend to use for the reporting database. Takes the same values as engine. | None |
| reporting_name | The name of the reporting database | “/var/lib/bcfg2/etc/reporting.sqlite” |
| reporting_user | The user to connect to the reporting database as | None |
| reporting_password | The password to connect to the reporting database with | None |
| reporting_host | The host to connect to for the reporting database | “localhost” |
| reporting_port | The port to connect to for the reporting database | None |
| reporting_options | Extra parameters to use when connecting to the reporting database. Available parameters vary depending on your database backend. The parameters are supplied as the value of the django OPTIONS setting. | None |
After making changes to the configuration options or adding a plugin that uses the global database, you should run bcfg2-admin syncdb to resync the database schema.