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.