Maria DB

MariaDB is supported since version 10.3.

The following example covers the database installation using the DB Tool provided by USU GmbH.

To install the MariaDB:

1. Create new database with the following settings:

   server default charset set to "utf_8", default collation="utf8_general_ci"

   For example, you can do so by using the following command:

   CREATE DATABASE <database name>

   CHARACTER SET = 'utf8'

   COLLATE = 'utf8_general_ci';

2. Create new database credentials for the Valuemation connection <database name>/<password> used in the AuthenticationManager_jaas.config Valuemation configuration file.

   GRANT ALL PRIVILEGES ON <database name>.* TO '<database name>'@'%' IDENTIFIED BY '<password>' WITH GRANT OPTION;

3. Install the Valuemation DB.
   1. Start the DBTool.
   2. Connect to the database with System > Open Database.
   3. Fill in the following parameters:

      DBMS = MariaDB

      ConnectName = <database name>

      User = <database name>

      Password = <password>

      Net-Access = HOST IP of the database server

      Port = Port of the database server

   4. Run the scripts:

      For Unicode databases with fulltext search indexes:

      VM_Create_Base_Complete.sql (USU Valuemation 5.2 with base data)

      VM_Create_Demo_Complete.sql (USU Valuemation 5.2 with demo data)

      For Unicode databases without fulltext search indexes:

      VM_Create_Base_Complete_NoFulltextSearchIndexes.sql (USU Valuemation 5.2 with base data)

      VM_Create_Demo_Complete_NoFulltextSearchIndexes.sql (USU Valuemation 5.2 with demo data)

Notes:

See also the readme_MARIADB_eng.txt file included in the database installation package for further details.

For complex information, see the MariaDB official knowledgebase and documentation.