
wordpress_install()
{
    ip=$(ifconfig  | grep 'inet addr:'| grep -v '127.0.0.1' | cut -d: -f2 | awk '{ print $1}')

    info "Getting data from API service"
    wp_admin_user=$paneluser
    wp_admin_pass=$panelpassword
    wp_admin_email='wordpress@vscale.io'
    wp_db_user=$wp_admin_user
    wp_db_user_pass=$panelpassword
    wp_site_title='Wordpress'
    wp_site_url=$ip
    # Check data
    for i in wp_admin_user wp_admin_pass wp_admin_email wp_db_user wp_db_user_pass wp_site_title wp_site_url; do
        if [[ -z "$i" ]]; then
            error "$i is empty. Exiting..." && broadcast "Wordpress configuration failed"
            exit 5
        fi
    done

    info "Configuring MySQL"
    for i in $(seq 1 10); do
            mysql -u root -e "exit"
            if [[ $? != 0 ]]; then
                    sleep 5
            else
                    break
            fi
    done

    mysql -e "GRANT ALL ON wordpress.* TO '$wp_db_user'@'localhost' IDENTIFIED BY '$wp_db_user_pass';"
    mysql -e "USE mysql;UPDATE user SET password=PASSWORD('$wp_db_user_pass') WHERE user = 'root';FLUSH PRIVILEGES;"

    #mysqladmin -u root password $wp_db_user_pass
    echo -e "[client]\npassword='$wp_db_user_pass'\n" > /root/.my.cnf
    chmod 600 /root/.my.cnf

    info "Configuring Wordpress"
    cd /var/www/html/
    wp core config --dbname='wordpress' --dbuser=$wp_db_user --dbpass=$wp_db_user_pass --allow-root
    wp core install --url=$wp_site_url --title=$wp_site_title --admin_user=$wp_admin_user --admin_password=$wp_admin_pass --admin_email=$wp_admin_email --allow-root
    wp plugin delete hello --allow-root
    wp plugin delete akismet --allow-root
    wp core is-installed --allow-root
    chown -R www-data:www-data /var/www
    systemctl restart apache2.service

}

# Change password for debian-sys-maint
change_dsm_pwd() {
    dsm_usr="$(awk '/user/{print $NF; exit;}' /etc/mysql/debian.cnf)"
    old_dsm_usr_pwd="$(awk '/password/{print $NF; exit;}' /etc/mysql/debian.cnf)"
    rnd_dsm_pwd="$(< /dev/urandom tr -dc A-Za-z0-9 | head -c 32;echo)"
    mysql --user=${dsm_usr} --password=${old_dsm_usr_pwd} --execute="GRANT ALL PRIVILEGES ON *.* TO '${dsm_usr}'@'localhost' IDENTIFIED BY '${rnd_dsm_pwd}';"

    cat > /etc/mysql/debian.cnf <<EOF
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = ${dsm_usr}
password = ${rnd_dsm_pwd}
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = ${dsm_usr}
password = ${rnd_dsm_pwd}
socket   = /var/run/mysqld/mysqld.sock
EOF

    systemctl restart mysql.service
}

app_setup()
{
    wordpress_install
    if [ $? != 0 ]; then
        error "ERROR: Failed to install wordpress"
        exit 3
    fi
    change_dsm_pwd
    if [ $? != 0 ]; then
        error "ERROR: Failed to change debian-sys-maint"
        exit 3
    fi
}
