Install MariaDB

This page serves as an example only, and describes a typical setup of MariaDB on Linux like Ubuntu.

To work with sapio365, the version of MariaDB must be at least version 10.11.

1 - Install MariaDB

The MariaDB server is usually directly available as a package that can be installed using the following:

CODE

sudo apt install mariadb-server

2 - Secure instance

Once installed, we suggest to secure the MariaDB instance right away.

Run the following script as an admin.

CODE

sudo mysql_secure_installation

This script lets you set a root password, remove anonymous users, disallow root remote login, remove the test database, and reload privileges.

By default, the installation only allows connections to the server from the machine where MariaDB has been installed (basic security).

3 - Enable outside access

To use sapio365 with MariaDB, you must enable access to it from the outside.

After the installation is complete, open configuration file /etc/mysql/mariadb.conf.d/50-server.cnf.

In the section [mysqld], change the bind-address = 127.0.0.1 to bind-address = 0.0.0.0 to open all access to MariaDB.

4 - Initialize the database

Security: Keep shared cache and collaboration SQL databases separate

We strongly suggest to create one database for your shared cache, and another for your collaboration data.

Suggested names	Database	User
Shared cache (used in the example script below)	sapio365-cache	sapio365-cache-sql
Collaboration	sapio365-collab	sapio365-collab-sql

First, open a session in MariaDB by running:

CODE

mariadb -u root -p

This will prompt you for the password to open the SQL console.

Second, run the following SQL commands to:
- Create a new database
- Create a user who can connect from the outside, and give this user the proper privileges to this new database.

CODE

CREATE DATABASE sapio365-cache;
CREATE USER 'sapio365-cache-sql'@'%' IDENTIFIED BY '-Your Password Here-';
GRANT ALL PRIVILEGES ON sapio365-cache.* TO 'sapio365-cache-sql'@'%';
FLUSH PRIVILEGES;

You are now ready to connect sapio365 to your MariaDB.