I have a bash script that utilizes dialog to show the progress bar during non-interactive Mysql database creation.
System OS: Ubuntu 20.04 server
Mariadb: 10.5
The issue:
Only the first Mysql command gets executed (i.e. create database) and in case of others there is Error 1064.
#!/usr/bin/env bash
export NCURSES_NO_UTF8_ACS=1
var_db() {
pfx=$(shuf -zer -n2 {a..z} | tr -d '\0')
vnum=$(shuf -i 8-11 -n 1)
sfx=$(openssl rand -base64 32 | tr -d /=+ | cut -c -"$vnum")
varnam="${pfx}_${sfx}"
echo "$varnam"
}
site_db() {
dbname=$(var_db)
userdb=$(var_db)
vnum=$(shuf -i 12-15 -n 1)
passdb=$(openssl rand -base64 32 | tr -d /=+ | cut -c -"$vnum")
msgs=('Database created'
'Database user created'
'All privileges granted on database to user'
'Reload privilege tables'
'Restart Mariadb'
'Reload Mariadb'
)
commands=('sudo mysql -e "CREATE DATABASE ${dbname};"'
'sudo mysql -e "CREATE USER ${userdb}@localhost IDENTIFIED BY '${passdb}';"'
'sudo mysql -e "GRANT ALL PRIVILEGES ON ${dbname}.* TO '${userdb}'@'localhost';"'
'sudo mysql -e "FLUSH PRIVILEGES;"'
'sudo systemctl restart mariadb'
'sudo systemctl reload mariadb'
)
n=${#commands[@]}
i=0
while [ "$i" -le "$n" ]; do
pct=$(( i * 100 / n )) # calculating progress percentage
if [ $pct -eq 100 ]; then
echo -e "XXX\n100\nMariadb secure installation completed!\nXXX"
else
echo -e "XXX\n$i\n${msgs[i]}\nXXX"
fi
echo "$pct"
eval "${commands[i]}" > /dev/null 2>&1 #eval the output of the commands,
i=$((i + 1))
sleep 2
done | dialog --keep-tite --title "Site database configuration" --gauge "Site database created" 20 100 0
}
site_db
However, if I don't use the commands inside an array, then all the mysql commands get executed in the script below. So, why is there an Error 1064 in the above script?
#!/usr/bin/env bash
var_db() {
pfx=$(shuf -zer -n2 {a..z} | tr -d '\0')
vnum=$(shuf -i 8-11 -n 1)
sfx=$(openssl rand -base64 32 | tr -d /=+ | cut -c -"$vnum")
varnam="${pfx}_${sfx}"
echo "$varnam"
}
site_db() {
dbname=$(var_db)
userdb=$(var_db)
vnum=$(shuf -i 12-15 -n 1)
passdb=$(openssl rand -base64 32 | tr -d /=+ | cut -c -"$vnum")
sudo mysql -e "CREATE DATABASE ${dbname};"
sudo mysql -e "CREATE USER ${userdb}@localhost IDENTIFIED BY '${passdb}';"
sudo mysql -e "GRANT ALL PRIVILEGES ON ${dbname}.* TO '${userdb}'@'localhost';"
sudo mysql -e "FLUSH PRIVILEGES;"
sudo systemctl restart mariadb
)
}
site_db