Repository Setup
The repository
is a PostgreSQL (>=9.5) database. It let temboard store its data, including users, agent registration and metrics data.
Usage of plugin supervision
requires tablefunc
extension. This extension is available as part of the extensions shipped with the source code of PostgreSQL, in the contrib/
directory. Usually, the "contrib" package of PostgreSQL from your Linux distribution has it.
Configuration
To ensure the browsing of the web interface is fast enough, please note the work_mem
parameter PostgreSQL cluster hosting the repository should be set to at least 16MB
.
Setup
To acces the repository
, temboard
needs to have its own user and database. To create them on a typical PostgreSQL setup, run the following commands:
sudo -u postgres createuser temboard -l -P
sudo -u postgres createdb -O temboard temboard
Authentication with password
The PostgreSQL user temboard
must be allowed to connect to the repository database using password authentication (md5
), please ensure the pg_hba.conf
is configured accordingly. The password of temboard
user should be set in the temboard
configuration file, under section [repository]
, parameter password
.
For example, if the PostgreSQL cluster is on the same host as temboard, the following lines can be added to the pg_hba.conf
file.
Insert the following lines before the first line that is not a comment:
local temboard temboard md5
host temboard temboard 127.0.0.1/32 md5
host temboard temboard ::1/128 md5
If the PostgreSQL cluster is on th different host, replace 127.0.0.1/32
by the IPv4 address (keeping /32
) of the host of temboard and ::1
by its IPv6 address (keeping /128
). Reload the configuration of the PostgreSQL cluster to activate the changes.
Installation
temboard
SQL schema must be loaded. The schema is stored in the SQL files located in /usr/share/temboard
after the installation:
psql -U temboard -1 -v'ON_ERROR_STOP=on' -f /usr/share/temboard/sql/application.sql temboard
If you plan to use the plugin supervision
:
sudo -u postgres psql -U postgres -c "CREATE EXTENSION tablefunc" temboard
psql -U temboard -1 -v'ON_ERROR_STOP=on' -f /usr/share/temboard/supervision.sql temboard
Configuration of temBoard
The last step is to configure temBoard to access the database. Edit /etc/temboard/temboard.conf
and configure the parameters under the [repository]
.
Then start the temboard
service and check the log file (/var/log/temboard/temboard.log
by default).