myvesta/bin/v-list-sys-db-status
2016-06-09 16:26:54 +03:00

84 lines
2.6 KiB
Bash
Executable File

#!/bin/bash
# info: list db status
# options: [FORMAT]
#
# The function lists db server status
#----------------------------------------------------------#
# Variable&Function #
#----------------------------------------------------------#
# Argument definition
#format=${1-shell}
# Includes
#source $VESTA/func/main.sh
source $VESTA/conf/vesta.conf
#----------------------------------------------------------#
# Action #
#----------------------------------------------------------#
# Checking db system
if [ -z "$DB_SYSTEM" ]; then
exit
fi
# Checking supported database systems
for db in $(echo $DB_SYSTEM| tr ',' '\n'); do
OLD_IFS="$IFS"
IFS=$'\n'
# Checking database config
if [ -e "$VESTA/conf/$db.conf" ]; then
# Checking server status
for host_str in $(cat $VESTA/conf/$db.conf); do
eval $host_str
# Checking MySQL
if [ "$db" = 'mysql' ]; then
mycnf="$VESTA/conf/.mysql.$HOST"
if [ ! -e "$mycnf" ]; then
echo "[client]">$mycnf
echo "host='$HOST'" >> $mycnf
echo "user='$USER'" >> $mycnf
echo "password='$PASSWORD'" >> $mycnf
chmod 600 $mycnf
else
mypw=$(grep password $mycnf|cut -f 2 -d \')
if [ "$mypw" != "$PASSWORD" ]; then
echo "[client]">$mycnf
echo "host='$HOST'" >> $mycnf
echo "user='$USER'" >> $mycnf
echo "password='$PASSWORD'" >> $mycnf
chmod 660 $mycnf
fi
fi
echo "MySQL $HOST status"
mysqladmin --defaults-file=$mycnf status |sed -e "s/ /\n/g"
echo
mysqladmin --defaults-file=$mycnf processlist
echo -en "\n-------------------------------------"
echo -en "-------------------------------------\n\n"
fi
# Checking PostgreSQL
if [ "$db" = 'pgsql' ] && [ ! -z "$(which psql)" ]; then
echo "PostgreSQL $HOST status"
export PGPASSWORD="$PASSWORD"
psql -h $HOST -U $USER -c "SELECT * FROM pg_stat_activity"
fi
done
fi
IFS="$OLD_IFS"
done
#----------------------------------------------------------#
# Vesta #
#----------------------------------------------------------#
exit