summaryrefslogtreecommitdiffstats
path: root/satellit_installer/includes/50-add_mysql_dbs_users.inc
diff options
context:
space:
mode:
authorroot2016-06-09 16:06:21 +0200
committerroot2016-06-09 16:06:21 +0200
commit6b9c63030207fa5b71d0da7e0d772a47beaeea4a (patch)
treea096bbecdc4f038bda12aa0101a068fae4c85b04 /satellit_installer/includes/50-add_mysql_dbs_users.inc
parent[SSPS] ipxe git and reset to last patchable commit (diff)
downloadsetup-scripts-6b9c63030207fa5b71d0da7e0d772a47beaeea4a.tar.gz
setup-scripts-6b9c63030207fa5b71d0da7e0d772a47beaeea4a.tar.xz
setup-scripts-6b9c63030207fa5b71d0da7e0d772a47beaeea4a.zip
[SSPS] mysql db/table stuff now created before dump restore
(Added create privilege)
Diffstat (limited to 'satellit_installer/includes/50-add_mysql_dbs_users.inc')
-rw-r--r--satellit_installer/includes/50-add_mysql_dbs_users.inc10
1 files changed, 5 insertions, 5 deletions
diff --git a/satellit_installer/includes/50-add_mysql_dbs_users.inc b/satellit_installer/includes/50-add_mysql_dbs_users.inc
index 09eec24..aea2696 100644
--- a/satellit_installer/includes/50-add_mysql_dbs_users.inc
+++ b/satellit_installer/includes/50-add_mysql_dbs_users.inc
@@ -3,14 +3,14 @@ add_mysql_dbs_users() {
mysql_add_db openslx
mysql_add_db sat
- # $1=sql-dumpfile, $2=database
- mysql_import_dump "$BASEDIR/static_files/db_sat_dump.sql" sat
- mysql_import_dump "$BASEDIR/static_files/db_openslx_dump.sql" openslx
-
# $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"
+ mysql_add_privs "sat" "openslx.location" "SELECT, CREATE"
+
+ # $1=sql-dumpfile, $2=database
+ mysql_import_dump "$BASEDIR/static_files/db_sat_dump.sql" sat
+ mysql_import_dump "$BASEDIR/static_files/db_openslx_dump.sql" openslx
}