Setup of the CaosDB SQL back end¶
MariaDB Client 10.1,
MySQL Client 5.5, or later versions. In the case of MySQL, version 5.6 is recommended.
Create the configuration¶
Create an empty
.configfile. For the default values and the meaning of these default values see config.defaults. For each parameter that you want to change, add a corresponding line in your
.configfile. You probably want to change the passwords. As the passwords are stored unencrypted in the
.configfile, make sure nobody else can read it.
If there is no
MySQL 5.5. and
MariaDB) then the
MYSQL_USER_PASSWORDmust be provided, that is the password of the
If you are using MariaDB and the
rootdatabase user uses pam authentication, no pasword string is required. You can set the
MYSQL_USER_PASSWORDto an empty string. But you need to be logged in as root for the installation and upgrade process.
Setup the SQL database for CaosDB¶
make install. If a there is a database with the name you have choosen during the configuration, you need to reconfigure or delete the database first.
Upgrade the SQL database¶
make upgrade. This upgrades the database to the latest version.
If you want to delete your database, run
make drop-$DATABASE_NAME. Use this with caution!!! If you did not backup your database, everything will be lost afterwards. And no, there is no additional prompt to ask if you are sure. If you
make drop-..., you actually delete the database.
The versioning feature is still experimental. Therefore it is possible to turn if on and off with a patch file and a special property.
Procedures and Functions¶
The procedures which need to behave differently if the versioning is on or off
check the return value of
is_feature_config function checks the
feature_config table, which is
a key-value store.
Turn off versioning: Run
UPDATE feature_config SET _value = "DISABLED" WHERE _key = "ENTITY_VERSIONING"; on your database.
Turn on versioning again: Run
UPDATE feature_config SET _value = "ENABLED" WHERE _key = "ENTITY_VERSIONING"; on your database.
When the versioning patch is installed, the versioning is turned on by default
and all old entities become versioned entities with their current version as
the oldest known version. That is, they all need an entry in the
entity_version table. These entries are generated by the
If you want to turn off the versioning for the time being you can just turn it
off for the procedures as described above. You should also empty the
entity_version table because the
_fix_unversioned procedure is only
designed to cope with entities which do not have any versioning information at
all. The already recorded versioning information is of course lost then! If you
switch on the versioning at some point in the future, the history begins anew
with the then current version of the stored entities.
We use MyTAP-1.0 for unit tests.
mysql client program
Tests are in
Alternatively, to run the tests in a containerized MariaDB instance, run
make test-docker, followed by
Build documentation in
breathe (Doxygen extension for Sphinx)