diff options
| -rw-r--r-- | README.md | 52 | ||||
| -rw-r--r-- | sql/0001_migration.sql | 11 |
2 files changed, 52 insertions, 11 deletions
@@ -2,11 +2,59 @@ # Ceres - Recipe server for your favorite dishes -With Ceres you can run a little recipe server in your home network. Have a look -at the [project page][1] for more details. +With Ceres you can run a recipe server in your home network. Have a look at the +[project page][1] for more details. All notable changes are documented in the [changelog][2]. +## Setup Ceres database + +Ceres supports only the [MariaDB][3] SQL implementation which is available on a +lot of Linux distributions. + +Database creation should be easy so please install MariaDB on your system and +then just run the first migration script with root user rights like this: + +``` + mariadb -u root < sql/0001_migration.sql +``` + +After database creation you have to also grant access to the database for a +Linux user. See the next section for details. + + +## Grant access to Ceres database for a Linux user + +If you want to use Ceres for production it is recommended to add a Linux user +for this purpose like this: + +``` + useradd ceres +``` + +For development you can just go on with your default Linux username. First +start an interactive MariaDB shell like this: + +``` + mariadb -u root +``` + +And then add a corresponding MariaDB user for the selected Linux user and set +corresponding access rights (substitute <user> with the selected username): + +``` + CREATE USER IF NOT EXISTS '<user>'@'localhost' IDENTIFIED VIA unix_socket; + GRANT ALL PRIVILEGES on ceres.* to '<user>'@'localhost'; + FLUSH PRIVILEGES; +``` + +The `unix_socket` authentication method ensures that the corresponding user +does not need to provide a password. + +Finally you can quit the MariaDB shell with CTRL + d. + + [1]: https://xengineering.eu/git/ceres [2]: ./CHANGELOG.md +[3]: https://mariadb.com/ diff --git a/sql/0001_migration.sql b/sql/0001_migration.sql index b04a754..9502e6c 100644 --- a/sql/0001_migration.sql +++ b/sql/0001_migration.sql @@ -1,18 +1,11 @@ -------------------------------------------------------------------------------- --- This migration script adds the ceres database and user and sets --- permissions. - --- Run this migration via `sudo mariadb -u root < 0001_migration.sql`. Mind --- that you also have to create the ceres Linux user. This is possibly done --- by the systemd *.sysusers file. +-- This migration script adds the initial version of the Ceres database. +-- Run this migration via `sudo mariadb -u root < 0001_migration.sql`. -- create database for ceres, add ceres user and set privileges CREATE DATABASE IF NOT EXISTS ceres; -CREATE USER IF NOT EXISTS 'ceres'@'localhost' IDENTIFIED VIA unix_socket; -GRANT ALL PRIVILEGES on ceres.* to 'ceres'@'localhost'; -FLUSH PRIVILEGES; -- select correct database for the rest of this script USE ceres; |