05. Database Setup and Configuration

Maria DB (local)

To install and configure a MariaDB database instance locally on the appliance, perform the following steps in the bash terminal as root user on the appliance:

$ systemctl enable mariadb
$ systemctl start mariadb

Define the local MariaDB administrator and the corresponding password:

$ mariadb-secure-installation

After finishing configuration, access is allowed to the database instance. The database for EBF Files server and the corresponding database admin user now need to be defined:

$ mysql -u root -p

Enter the MariaDB Admin password, and enter the MariaDB shell. Follow the example to create a user „files“ with the password „files_pwd“. Then create the configuration database shell „files_db“ for the EBF Files server and assign this shell to the user „files“:

CREATE USER 'files'@'localhost' IDENTIFIED BY 'files_pwd';

GRANT ALL PRIVILEGES ON * . * TO 'files'@'localhost';

FLUSH PRIVILEGES;

CREATE DATABASE files_db;

USE files_db;

EXIT;

EBF Files server is now ready to be configured.

MS-SQL Database Connection

EBF Files server can create a dedicated database or use an existing database connection. When using a dedicated database, a database shell must be created with an authorized database user with the following rights:

• Database Schema creation
• Database read/write

The description of the database (database server version, database instance/database name, database user and user password) is required within the EBF Files server configuration. It is recommended to use an internal database user instead of a user using Windows authentication. The database will be initialized the first time EBF Files server starts.

If a single server installation of EBF Files server is desired, a local MariaDB instance can also be stored on the appliance itself.