mirror of
https://github.com/serghey-rodin/vesta.git
synced 2025-01-08 20:13:01 -08:00
75 lines
1.7 KiB
Bash
Executable File
75 lines
1.7 KiB
Bash
Executable File
#!/bin/bash
|
|
# info: Suspending databses
|
|
|
|
#----------------------------------------------------------#
|
|
# Variable&Function #
|
|
#----------------------------------------------------------#
|
|
|
|
# Argument defenition
|
|
user="$1"
|
|
|
|
# Importing variables
|
|
source $VESTA/conf/vars.conf
|
|
source $V_FUNC/shared_func.sh
|
|
source $V_FUNC/db_func.sh
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Verifications #
|
|
#----------------------------------------------------------#
|
|
|
|
# Checking arg number
|
|
check_args '1' "$#" 'user'
|
|
|
|
# Checking argument format
|
|
format_validation 'user'
|
|
|
|
# Checking db system is enabled
|
|
is_system_enabled 'db'
|
|
|
|
# Checking user
|
|
is_user_valid
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Action #
|
|
#----------------------------------------------------------#
|
|
|
|
# Defining config
|
|
conf="$V_USERS/$user/db.conf"
|
|
|
|
# Defining fileds to select
|
|
field='$DB'
|
|
|
|
# Defining search string
|
|
search_string="SUSPEND='no'"
|
|
|
|
# Parsing unsuspeneded domains
|
|
databases=$(db_clear_search)
|
|
|
|
for database in $databases; do
|
|
# Define database variables
|
|
db_user=$(get_db_value '$USER')
|
|
host=$(get_db_value '$HOST')
|
|
type=$(get_db_value '$TYPE')
|
|
|
|
# Switching on db type
|
|
case $type in
|
|
mysql) suspend_db_mysql ;;
|
|
pgsql) suspend_db_pgsql ;;
|
|
esac
|
|
|
|
# Updating db value
|
|
update_db_base_value '$SUSPEND' 'yes'
|
|
done
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Vesta #
|
|
#----------------------------------------------------------#
|
|
|
|
# Logging
|
|
log_event 'system' "$V_EVENT"
|
|
|
|
exit $OK
|