mirror of
https://github.com/YunoHost-Apps/phpmyadmin_ynh.git
synced 2024-09-03 19:56:46 +02:00
88 lines
3.1 KiB
Bash
88 lines
3.1 KiB
Bash
#!/bin/bash
|
|
|
|
#=================================================
|
|
# GENERIC START
|
|
#=================================================
|
|
# IMPORT GENERIC HELPERS
|
|
#=================================================
|
|
|
|
source _common.sh
|
|
source /usr/share/yunohost/helpers
|
|
|
|
#=================================================
|
|
# STANDARD MODIFICATIONS
|
|
#=================================================
|
|
# CREATE A MYSQL SUPERUSER
|
|
#=================================================
|
|
|
|
# Setup a privileged user for phpmyadmin (to prevent using MySQL root user)
|
|
db_admin_user="${app}_root"
|
|
ynh_app_setting_set --app=$app --key=db_admin_user --value=$db_admin_user
|
|
db_admin_pwd="$(ynh_string_random)"
|
|
ynh_app_setting_set --app=$app --key=db_admin_pwd --value=$db_admin_pwd
|
|
|
|
if ! ynh_mysql_user_exists --user=$db_admin_user
|
|
then
|
|
ynh_mysql_create_user $db_admin_user "$db_admin_pwd"
|
|
ynh_mysql_execute_as_root --sql="GRANT ALL PRIVILEGES ON *.* TO '$db_admin_user'@'localhost' IDENTIFIED BY '$db_admin_pwd' WITH GRANT OPTION; FLUSH PRIVILEGES;" --database=mysql
|
|
fi
|
|
|
|
#=================================================
|
|
# DOWNLOAD, CHECK AND UNPACK SOURCE
|
|
#=================================================
|
|
ynh_script_progression --message="Setting up source files..." --weight=6
|
|
|
|
# Download, check integrity, uncompress and patch the source from app.src
|
|
ynh_setup_source --dest_dir="$install_dir"
|
|
|
|
chmod 750 "$install_dir"
|
|
chmod -R o-rwx "$install_dir"
|
|
chown -R $app:www-data "$install_dir"
|
|
|
|
#=================================================
|
|
# SYSTEM CONFIGURATION
|
|
#=================================================
|
|
ynh_script_progression --message="Adding system configurations related to $app..." --weight=1
|
|
|
|
# Create a dedicated NGINX config
|
|
ynh_add_nginx_config
|
|
|
|
# Create a dedicated PHP-FPM config
|
|
ynh_add_fpm_config
|
|
|
|
#=================================================
|
|
# SPECIFIC SETUP
|
|
#=================================================
|
|
# POPULATE THE DATABASE
|
|
#=================================================
|
|
ynh_script_progression --message="Filling database..." --weight=3
|
|
|
|
ynh_replace_string --match_string="phpmyadmin" --replace_string="$db_name" --target_file=$install_dir/sql/create_tables.sql
|
|
ynh_mysql_connect_as --user="$db_name" --password="$db_pwd" --database="$db_name" \
|
|
< $install_dir/sql/create_tables.sql
|
|
|
|
#=================================================
|
|
# CONFIGURE PHPMYADMIN
|
|
#=================================================
|
|
ynh_script_progression --message="Configuring $app..."
|
|
|
|
ynh_add_config --template="../conf/config.inc.php" --destination="$install_dir/config.inc.php"
|
|
# config.inc.php contains sensitive data, restrict its access
|
|
chown $app: $install_dir/config.inc.php
|
|
chmod 640 $install_dir/config.inc.php
|
|
|
|
#=================================================
|
|
# GENERIC FINALIZATION
|
|
#=================================================
|
|
# SECURE FILES AND DIRECTORIES
|
|
#=================================================
|
|
|
|
# Setup phpMyAdmin temporary folder
|
|
mkdir -p $install_dir/tmp
|
|
chown $app: $install_dir/tmp
|
|
|
|
#=================================================
|
|
# END OF SCRIPT
|
|
#=================================================
|
|
|
|
ynh_script_progression --message="Installation of $app completed" --last
|