hestiacp/install/upgrade/manual/migrate_phpmyadmin.sh

#!/bin/bash
# info: Disconnect phpMyadmin from APT and solving issues with PHPMyadmin accidental updates from ATP

#----------------------------------------------------------#
#                    Variable&Function                     #
#----------------------------------------------------------#

# Includes
source $HESTIA/func/main.sh
# get current phpmyadmin version
source $HESTIA/install/upgrade/upgrade.conf
source $HESTIA/conf/hestia.conf

#----------------------------------------------------------#
#                    Verifications                         #
#----------------------------------------------------------#

echo "To remove phpMyAdmin you will need use the root password. Password can be found in /usr/local/hestia/conf/mysql.conf"
read -p 'Would you like to continue? [y/n]'

#----------------------------------------------------------#
#                       Action                             #
#----------------------------------------------------------#

echo # (optional) move to a new line
if [[ $REPLY =~ ^[Yy]$ ]]; then
	# Remove PMA SSO first
	sso="no"
	if [ "$PHPMYADMIN_KEY" != "" ]; then
		sso="yes"
		$BIN/v-delete-sys-pma-sso
	fi

	# Create an backup of current config
	echo "[ * ] Backing up old configuration files..."
	mkdir -p /root/hst_backup_man/phmyadmin
	cp -r /etc/phpmyadmin/* /root/hst_backup_man/phmyadmin

	mkdir -p /root/hst_backup_man/var_phmyadmin
	cp -r /var/lib/phpmyadmin/* /root/hst_backup_man/var_phmyadmin

	echo '[ * ] Marking phpmyadmin as held in apt...'
	apt-mark hold phpmyadmin

	echo '[ * ] Removing old folders...'
	# make sure everything is deleted
	rm -f -r /usr/share/phpmyadmin
	rm -f -r /etc/phpmyadmin
	rm -f -r /var/lib/phpmyadmin/

	echo '[ * ] Creating new folders...'
	# Create folders
	mkdir -p /usr/share/phpmyadmin
	mkdir -p /etc/phpmyadmin
	mkdir -p /etc/phpmyadmin/conf.d/
	mkdir /usr/share/phpmyadmin/tmp
	chmod 770 /usr/share/phpmyadmin/tmp/
	chown root:www-data /usr/share/phpmyadmin/tmp/
	mkdir -p /etc/phpmyadmin/conf.d/

	# Configuring Apache2 for PHPMYADMIN
	if [ "$WEB_SYSTEM" == "apache2" ]; then
		cp -f $HESTIA_INSTALL_DIR/pma/apache.conf /etc/phpmyadmin/
		rm /etc/apache2/conf.d/phpmyadmin.conf
		ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
	fi

	PASS=$(generate_password)

	echo "[ * ] Installing phpMyAdmin version v$pma_v..."
	# Download latest phpmyadmin release
	wget --quiet https://files.phpmyadmin.net/phpMyAdmin/$pma_v/phpMyAdmin-$pma_v-all-languages.tar.gz
	# Unpack files
	tar xzf phpMyAdmin-$pma_v-all-languages.tar.gz

	# Overwrite old files
	cp -rf phpMyAdmin-$pma_v-all-languages/* /usr/share/phpmyadmin

	# Create copy of config file
	cp -f $HESTIA_INSTALL_DIR/phpmyadmin/config.inc.php /etc/phpmyadmin/
	mkdir -p /var/lib/phpmyadmin/tmp
	chmod 770 -R /var/lib/phpmyadmin/tmp

	# Set config and log directory
	sed -i "s|'configFile' => ROOT_PATH . 'config.inc.php',|'configFile' => '/etc/phpmyadmin/config.inc.php',|g" /usr/share/phpmyadmin/libraries/vendor_config.php

	# Generate blowfish
	blowfish=$(head /dev/urandom | tr -dc A-Za-z0-9 | head -c 32)
	sed -i "s|%blowfish_secret%|$blowfish|" /etc/phpmyadmin/config.inc.php

	# Clear Up
	rm -fr phpMyAdmin-$pma_v-all-languages
	rm -f phpMyAdmin-$pma_v-all-languages.tar.gz

	if [ -z "$DB_PMA_ALIAS" ]; then
		echo "DB_PMA_ALIAS='phpmyadmin'" >> $HESTIA/conf/hestia.conf
	fi
	$BIN/v-change-sys-db-alias 'pma' "phpmyadmin"

	# Special thanks to Pavel Galkin (https://skurudo.ru)
	# https://github.com/skurudo/phpmyadmin-fixer

	echo "[ * ] Creating localhost configuration..."
	#ubuntu phpmyadmin path
	pmapath="/etc/phpmyadmin/conf.d/01-localhost.php"
	echo "<?php " >> $pmapath
	echo "\$cfg['Servers'][\$i]['host'] = 'localhost';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['port'] = '3306';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['favorite'] = 'pma__favorite';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['usergroups'] = 'pma__usergroups';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['central_columns'] = 'pma__central_columns';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['designer_settings'] = 'pma__designer_settings';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['export_templates'] = 'pma__export_templates';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['savedsearches'] = 'pma__savedsearches';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['navigationhiding'] = 'pma__navigationhiding';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['users'] = 'pma__users';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['usergroups'] = 'pma__usergroups';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['pmadb'] = 'phpmyadmin';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['controluser'] = 'pma';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['controlpass'] = '$PASS';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['bookmarktable'] = 'pma__bookmark';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['relation'] = 'pma__relation';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['userconfig'] = 'pma__userconfig';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['table_info'] = 'pma__table_info';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['column_info'] = 'pma__column_info';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['history'] = 'pma__history';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['recent'] = 'pma__recent';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['table_uiprefs'] = 'pma__table_uiprefs';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['tracking'] = 'pma__tracking';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['table_coords'] = 'pma__table_coords';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['pdf_pages'] = 'pma__pdf_pages';" >> $pmapath
	echo "\$cfg['Servers'][\$i]['designer_coords'] = 'pma__designer_coords';" >> $pmapath

	#SOME WORK with DATABASE (table / user)
	PMADB=phpmyadmin
	PMAUSER=pma

	echo '[ * ] Dropping database (could throw an error if successful)...'
	# removed tabs due to here doc errors
	#DROP USER and TABLE
	mysql -uroot << MYSQL_PMA1
DROP USER '$PMAUSER'@'localhost';
DROP DATABASE $PMADB;
FLUSH PRIVILEGES;
MYSQL_PMA1

	#CREATE PMA USER
	if [ -f '/usr/bin/mariadb' ]; then
		mysql="mariadb"
	else
		mysql="mysql"
	fi
	mysql_out=$(mktemp)
	$mysql -e 'SELECT VERSION()' > $mysql_out
	mysql_ver=$(cat $mysql_out | tail -n1 | cut -f 1 -d -)
	mysql_ver_sub=$(echo $mysql_ver | cut -d '.' -f1)
	mysql_ver_sub_sub=$(echo $mysql_ver | cut -d '.' -f2)

	if [ "$mysql" = "mysql" ] && [ "$mysql_ver_sub" -ge 8 ]; then
		query="CREATE USER '$PMAUSER'@'localhost' IDENTIFIED BY '$PASS';"
		$mysql -uroot -e "$query" > /dev/null

		query="CREATE DATABASE $PMADB;"
		$mysql -uroot -e "$query" > /dev/null

		query="GRANT USAGE ON $PMADB.* TO '$PMAUSER'@'localhost';"
		$mysql -uroot -e "$query" > /dev/null

		query="GRANT ALL PRIVILEGES ON $PMADB.* TO '$PMAUSER'@'localhost';"
		$mysql -uroot -e "$query" > /dev/null

		query="FLUSH PRIVILEGES;"
		$mysql -uroot -e "$query" > /dev/null

	else
		query="CREATE USER '$PMAUSER'@'localhost' IDENTIFIED BY '$PASS';"
		$mysql -uroot -e "$query" > /dev/null

		query="CREATE DATABASE $PMADB;"
		$mysql -uroot -e "$query" > /dev/null

		query="GRANT USAGE ON $PMADB.* TO '$PMAUSER'@'localhost' IDENTIFIED BY '$PASS';"
		$mysql -uroot -e "$query" > /dev/null

		query="GRANT ALL PRIVILEGES ON $PMADB.* TO '$PMAUSER'@'localhost';"
		$mysql -uroot -e "$query" > /dev/null

		query="FLUSH PRIVILEGES;"
		$mysql -uroot -e "$query" > /dev/null
	fi

	#MYSQL DB and TABLES ADDITION
	mysql -uroot < $HESTIA_INSTALL_DIR/phpmyadmin/create_tables.sql

	if [ "$sso" == "yes" ]; then
		$BIN/v-add-sys-pma-sso
	fi
fi