blob: 9d3812edb097ce8c6fa71cc996e55f72e38ae505 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
# Ceres - Recipe server for your favorite dishes
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/
|
