From bae6e34c9119750b2cba2a2ce6d88e9f8c895900 Mon Sep 17 00:00:00 2001 From: xengineering Date: Sat, 1 Apr 2023 21:18:29 +0200 Subject: Switch from MariaDB to files Using a database is way more complex (see the commit statistics of this commit) than using files to store recipe data. Also administration and usage is simpler. --- README.md | 54 ++---------------------------------------------------- 1 file changed, 2 insertions(+), 52 deletions(-) (limited to 'README.md') diff --git a/README.md b/README.md index b2b3584..5fd507d 100644 --- a/README.md +++ b/README.md @@ -19,54 +19,6 @@ Please install the following dependencies to build and run Ceres: - [Git][5] - [Make][6] - [Go][7] -- [MariaDB][3] - - -## 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 with the selected username): - -``` - CREATE USER IF NOT EXISTS ''@'localhost' IDENTIFIED VIA unix_socket; - GRANT ALL PRIVILEGES on ceres.* to ''@'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. ## Build and run Ceres @@ -74,9 +26,8 @@ Finally you can quit the MariaDB shell with CTRL + d. If you just cloned the repository it is important to initialize Git submodules to add dependencies via `git submodule update --init`. -Then it is time to build and run Ceres for the first time! If your database is -correctly configured and your current user has access rights, it is very simple -to run the server in debug mode: +Then it is time to build and run Ceres for the first time in debug mode like +this: ``` make debug @@ -118,7 +69,6 @@ executable at boot. [1]: https://xengineering.eu/git/ceres [2]: ./CHANGELOG.md -[3]: https://mariadb.com/ [4]: https://www.gnu.org/software/coreutils/ [5]: https://git-scm.com/ [6]: https://www.gnu.org/software/make/ -- cgit v1.2.3-70-g09d2