mirror of
https://github.com/serghey-rodin/vesta.git
synced 2025-02-13 13:33:04 -08:00
66 lines
1.8 KiB
Bash
Executable File
66 lines
1.8 KiB
Bash
Executable File
#!/bin/bash
|
|
# info: change database password
|
|
# options: USER DATABASE DBPASS
|
|
#
|
|
# The function for changing database user password to a database. It uses the
|
|
# full name of database as argument.
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Variable&Function #
|
|
#----------------------------------------------------------#
|
|
|
|
# Argument defenition
|
|
user=$1
|
|
database=$2
|
|
dbpass=$3
|
|
|
|
# Includes
|
|
source $VESTA/func/main.sh
|
|
source $VESTA/func/db.sh
|
|
source $VESTA/conf/vesta.conf
|
|
|
|
# Hiding password
|
|
A3='******'
|
|
EVENT="DATE='$DATE' TIME='$TIME' CMD='$SCRIPT' A1='$A1' A2='$A2' A3='$A3'"
|
|
EVENT="$EVENT A4='$A4' A5='$A5' A6='$A6' A7='$A7' A8='$A8' A9='$A9'"
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Verifications #
|
|
#----------------------------------------------------------#
|
|
|
|
check_args '3' "$#" 'USER DATABASE DBPASS'
|
|
validate_format 'user' 'database' 'dbpass'
|
|
is_system_enabled "$DB_SYSTEM" 'DB_SYSTEM'
|
|
is_object_valid 'user' 'USER' "$user"
|
|
is_object_unsuspended 'user' 'USER' "$user"
|
|
is_object_valid 'db' 'DB' "$database"
|
|
is_object_unsuspended 'db' 'DB' "$database"
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Action #
|
|
#----------------------------------------------------------#
|
|
# Get database values
|
|
get_database_values
|
|
|
|
case $TYPE in
|
|
mysql) change_mysql_password ;;
|
|
pgsql) change_pgsql_password ;;
|
|
esac
|
|
|
|
|
|
#----------------------------------------------------------#
|
|
# Vesta #
|
|
#----------------------------------------------------------#
|
|
|
|
# Update config value
|
|
update_object_value 'db' 'DB' "$database" '$MD5' "$md5"
|
|
|
|
# Logging
|
|
log_history "changed $database database password"
|
|
log_event "$OK" "$EVENT"
|
|
|
|
exit
|