You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
71 lines
1.7 KiB
71 lines
1.7 KiB
#!/bin/bash
|
|
|
|
### DO NOT EDIT THIS FILE
|
|
|
|
function usage {
|
|
echo
|
|
echoMainTitle "Creates a database on plesk server"
|
|
echo
|
|
echoSubTitle "Usage:"
|
|
echo
|
|
echo "project-manager plesk:create-database [project-shortname] [env]"
|
|
echo
|
|
echo " [env] could be live or stage"
|
|
echo
|
|
echo "--help Prints this message"
|
|
echo
|
|
}
|
|
|
|
source "$project_manager_dir/bin/includes/project_header"
|
|
env="$(getArgument "$2" "$(usage)" "live stage")"
|
|
pleskValidate "$env"
|
|
|
|
db_user="$(dbGetConfig "$env" "user")"
|
|
db_password="$(dbGetConfig "$env" "password")"
|
|
db_database="$(dbGetConfig "$env" "database")"
|
|
domain="$(getConfig "$env" "domain")"
|
|
|
|
split=($(echo $domain | tr "." "\n"))
|
|
count="${#split[@]}"
|
|
((length=$count-2))
|
|
sub=''
|
|
for i in "${!split[@]}"
|
|
do
|
|
((j=$i+1))
|
|
if [ "$j" -lt "$length" ]
|
|
then
|
|
sub+="${split[$i]}."
|
|
fi
|
|
if [ "$j" -eq "$length" ]
|
|
then
|
|
sub+="${split[$i]}"
|
|
fi
|
|
done
|
|
domain="$(echo "$domain" | sed "s/$(sedEscape "$sub")\.//")"
|
|
|
|
echo
|
|
echoMainTitle "Adding database on plesk server"
|
|
echo
|
|
echoSubTitle "Please verify data"
|
|
echo
|
|
echo "-- $env"
|
|
echo "Domain: $domain"
|
|
echo
|
|
echo "Database name: $db_database"
|
|
echo "Database user: $db_user"
|
|
echo
|
|
echo "Plesk host: $plesk_host"
|
|
echo "Plesk user: $plesk_user"
|
|
echo "Plesk private key: $plesk_private_key"
|
|
echo "Plesk public key: $plesk_public_key"
|
|
echo
|
|
confirm
|
|
|
|
pleskAddSSHKey
|
|
|
|
ssh "$plesk_user@$plesk_host" "plesk bin database --create '$db_database' -domain '$domain' -type '$plesk_db_type' -server 'localhost'"
|
|
ssh "$plesk_user@$plesk_host" "plesk bin database --create-dbuser '$db_user' -passwd '$db_password' -domain '$domain' -database '$db_database' -server 'localhost'"
|
|
|
|
echo
|
|
echoSuccess "Database has been created on plesk"
|
|
echo
|