path: root/satellit_installer/includes/10-handle_mysql.inc

preset_mysql_root() {
	# Presetting a root password for mysql so installer keeps quiet:
	echo "Presetting root password for mysql: $MYSQL_ROOT_PASS"
	debconf-set-selections <<< "mysql-server mysql-server/root_password password $MYSQL_ROOT_PASS"
	debconf-set-selections <<< "mysql-server mysql-server/root_password_again password $MYSQL_ROOT_PASS"
}

mysql_add_db() {
	echo "# Creating mysql database $1..."
	echo "create database $1;" | mysql -u root -p"$MYSQL_ROOT_PASS"
	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not create mysql database $1!"
	fi
}

mysql_delete_db() {
	# $1 database; $2 password
	echo "# Deleting mysql database $1..."
	echo "drop database if exists $1;"	| mysql -u root -p"${2}"
	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not delete mysql user $1!"
	fi

}

mysql_add_user() {
	# $1=user, $2=database, $3=privileges, $4=password
	echo "# Adding user $1 for database $2, privileges $3..."
	mysql -u root -p"$MYSQL_ROOT_PASS" <<-CMDS
		CREATE USER '$1'@'localhost' IDENTIFIED BY '$4';
		GRANT $3 ON $2.* TO '$1'@'localhost';
	CMDS

	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not add mysql user!"
	fi
}

mysql_add_privs() {
	# $1=user, $2=database, $3=privileges
	echo "# Adding privileges $3 for user $1 on database $2..."
	mysql -u root -p"$MYSQL_ROOT_PASS" <<-CMDS
		GRANT $3 ON $2 TO '$1'@'localhost';
	CMDS

	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not add privileges!"
	fi
}

mysql_delete_user() {
	# $1: mysql user, $2 password
	echo "# Deleting mysql user $1..."
	echo "drop user $1@localhost;"	| mysql -u root -p${2}
	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not delete mysql user $1!"
	fi
}

mysql_import_dump() {
	# $1: dump file, $2: database
	echo "# Importing sql dump file $1..."
	mysql -u root -p"$MYSQL_ROOT_PASS" -h localhost "$2" < "$1"
	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not import sql dump file $1!"
	fi
}