blob: c80328ac6aed586df19c355c51088cb89d28d88d (
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
|
#!/bin/sh -e
# HOMER database setup script
# Copyright (c) 2017 Kaarle Ritvanen
exec_sql() {
mysql $2 < /usr/share/homer-db/$1.sql
}
exec_sql homer_databases
exec_sql homer_user
for db in configuration data statistic; do
exec_sql schema_$db homer_$db
done
homer_rotate
[ "$1" = -r ] || exit 0
mysql <<EOF
CREATE USER 'homer_user' IDENTIFIED BY 'homer_password';
GRANT SELECT ON homer_data.* TO 'homer_user';
EOF
|
