Using An External Database Server - alastairtech/rivendell GitHub Wiki

Depending on your set up you may want to store your Rivendell database on a more robust server/host. Rivendell uses MariaDB, which is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. The first half of this guide will help you set up an empty Rivendell database that workstations can connect to. The second half will guide you through moving an existing database to a new host.

Installing MariaDB

Depending on your Linux distribution you'll need to use the appropriate package manager to install MariaDB. For ARM devices you should normally use Debian's apt package manager. This part is the only Linux distribution unique step. Everything afterwards should work on all systems.

Debian

sudo apt install mariadb-server

Red Hat/CentOS/Fedora

sudo dnf install mariadb-server

Arch/Manjaro

sudo pacman -S mariadb-server

To be 100% certain MariaDB is running and enabled run the following commands.

Start MariaDB Service

sudo systemctl start mariadb

Enable MariaDB Service

sudo systemctl enable mariadb

Creating the Blank Rivendell Database

The following command will create a blank Rivendell database with the default username 'rduser' and the default password 'letmein'. You can adjust user and password credentials in the command to suit your needs. You will need these credentials to be able to connect to the database over the network from a Rivendell workstation.

sudo mysql -e "create database Rivendell;" ; sudo mysql -e "grant Select, Insert, Update, Delete, Create, Drop, References, Index, Alter, Create Temporary Tables, Lock Tables on Rivendell.* to rduser@'%' identified by 'letmein'"