satellit_installer/includes/50-add_mysql_dbs_users.inc


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

add_mysql_dbs_users() {
	# Now comes mysql stuff; adding databases:
	mysql_add_db openslx
	mysql_add_db sat

	# $1=user, $2=database, $3=privileges, $4=password
	mysql_add_user sat sat "DELETE, INSERT, SELECT, UPDATE, ALTER, CREATE, DROP" "$MYSQL_SAT_PASS"
	mysql_add_user openslx openslx ALL "$MYSQL_OPENSLX_PASS"
	# $1=user, $2=database, $3=privileges
	mysql_add_privs "openslx" "sat.*" "ALL"
	mysql_add_privs "sat" "openslx.location" "SELECT, CREATE"

	# $1=sql-dumpfile, $2=database
	mysql_import_dump "$BASEDIR/static_files/db_sat_dump.sql" sat
}