Upgrading ZPanel 10.1.* to Sentora - Alpha/Beta

Code:

#--- Resolv.conf protect
chattr +i /etc/resolv.conf

#--- Prepare hostname
old_hostname=$(cat /etc/hostname)
# In file hostname
echo "$PANEL_FQDN" > /etc/hostname

# In file hosts
sed -i "/127.0.1.1[\t ]*$old_hostname/d" /etc/hosts
sed -i "s|$old_hostname|$PANEL_FQDN|" /etc/hosts

# For current session
hostname "$PANEL_FQDN"

# In network file
if [[ "$OS" = "CentOs" && "$VER" = "6" ]]; then
    sed -i "s|^\(HOSTNAME=\).*\$|HOSTNAME=$PANEL_FQDN|" /etc/sysconfig/network
    /etc/init.d/network restart
fi

Code:

mysqlpassword=$(cat /etc/sentora/panel/cnf/db.php | grep "pass" | cut -d \' -f 2);

Code:

if [ -z "$mysqlpassword" ]; then
    mysqlpassword=$(passwordgen);
    mysqladmin -u root password "$mysqlpassword"
fi

Code:

cat /etc/sentora/panel/cnf/db.php | grep "pass" | cut -d \' -f 2

Code:

[root@192 ~]# ps -p $$ | tail -1 | awk '{print $NF}'
bash
[root@192 ~]#

Code:

[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DELETE FROM mysql.user WHERE User='root' AND Host != 'localhost'"
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA-e "DELETE FROM mysql.user WHERE User=''";
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DELETE FROM mysql.user WHERE User=''";
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DELETE FROM mysql.user WHERE User='root' AND Host != 'localhost'"
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DELETE FROM mysql.user WHERE User=''";
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "FLUSH PRIVILEGES";
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DROP DATABASE IF EXISTS test";
[root@192 /]#  mysql -u root -pLmmFO7D6gR9PJmtA < /etc/sentora/configs/sentora-update/zpanel/sql/update-structure.sql
ERROR 1091 (42000) at line 50: Can't DROP 'pk_enablecgi_in'; check that column/key exists
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA < /etc/sentora/configs/sentora-update/zpanel/sql/update-data.sql
ERROR 1062 (23000) at line 17: Duplicate entry '48' for key 'PRIMARY'
[root@192 /]#

Code:

[root@192 /]#  mysql -f -u root -pLmmFO7D6gR9PJmtA < /etc/sentora/configs/sentora-update/zpanel/sql/update-structure.sql
ERROR 1091 (42000) at line 50: Can't DROP 'pk_enablecgi_in'; check that column/key exists
ERROR 1060 (42S21) at line 68: Duplicate column name 'vh_soaserial_vc'
[root@192 /]# mysql -f -u root -pLmmFO7D6gR9PJmtA < /etc/sentora/configs/sentora-update/zpanel/sql/update-data.sql
ERROR 1062 (23000) at line 17: Duplicate entry '48' for key 'PRIMARY'
ERROR 1062 (23000) at line 19: Duplicate entry '94' for key 'PRIMARY'
ERROR 1062 (23000) at line 20: Duplicate entry '93' for key 'PRIMARY'
ERROR 1062 (23000) at line 21: Duplicate entry '92' for key 'PRIMARY'
ERROR 1091 (42000) at line 166: Can't DROP 'pk_enablecgi_in'; check that column/key exists
[root@192 /]# mysqldump -u root -pLmmFO7D6gR9PJmtA zpanel_core | mysql -u root -pLmmFO7D6gR9PJmtA  -D sentora_core

Code:

INSERT INTO `zpanel_core`.`x_modules` (`mo_id_pk`, `mo_category_fk`, `mo_name_vc`, `mo_version_in`, `mo_folder_vc`, `mo_type_en`, `mo_desc_tx`, `mo_installed_ts`, `mo_enabled_en`, `mo_updatever_vc`, `mo_updateurl_tx`) VALUES('48', '3', 'Protected Directories', '200', 'protected_directories', 'user', 'Password protect your web applications and directories.', NULL, 'true', '', '');

INSERT INTO `zpanel_core`.`x_permissions` (`pe_id_pk`, `pe_group_fk`, `pe_module_fk`) VALUES('94', '3', '48');
INSERT INTO `zpanel_core`.`x_permissions` (`pe_id_pk`, `pe_group_fk`, `pe_module_fk`) VALUES('93', '2', '48');
INSERT INTO `zpanel_core`.`x_permissions` (`pe_id_pk`, `pe_group_fk`, `pe_module_fk`) VALUES('92', '1', '48');