aboutsummaryrefslogblamecommitdiffstats
path: root/community/homer-api/homer_db_init
blob: c80328ac6aed586df19c355c51088cb89d28d88d (plain) (tree)
1
2
3
4
5

            


                                    

















                                                        
   
#!/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