source: lliurex-analytics-server/trunk/fuentes/debian/postinst @ 3376

#!/bin/bash
# postinst script
#
# see: dh_installdeb(1)

#set -e

. /usr/share/debconf/confmodule 

# summary of how this script can be called:
#        * <postinst> `configure' <most-recently-configured-version>
#        * <old-postinst> `abort-upgrade' <new version>
#        * <conflictor's-postinst> `abort-remove' `in-favour' <package>
#          <new-version>
#        * <postinst> `abort-remove'
#        * <deconfigured's-postinst> `abort-deconfigure' `in-favour'
#          <failed-install-package> <version> `removing'
#          <conflicting-package> <version>
# for details, see http://www.debian.org/doc/debian-policy/ or
# the debian-policy package

do_dialog(){
    input=$(dialog      \
        --title "$1"    \
        --inputbox "$2" 0 0     \
        3>&1 1>&2 2>&3 3>&-)
        clear
}
ask_question(){
    dialog --yesno "$1" 0 0
    if [ $? -eq 0 ]; then
        input=yes
    else
        input=no
    fi
    clear
}

case "$1" in
    configure)

    ASK="no"
    
#CHECK OLD CONFIG
    if [ ! -d "/etc/lliurex-analytics-server" ]; then
        ASK="yes"
        echo "creating config directory"
        mkdir /etc/lliurex-analytics-server
    else
        if [ -f "/etc/lliurex-analytics-server/config_db" ]; then
            USER=$(cat /etc/lliurex-analytics-server/config_db|perl -ne '/user=(.*)/i && print $1')
            PASS=$(cat /etc/lliurex-analytics-server/config_db|perl -ne '/pass=(.*)/i && print $1')
            if [ -n "${USER}" -a -n "${PASS}" ]; then
                RES=$(echo 'show tables;'|mysql -u${USER} -p${PASS} -s analytics 2>/dev/null)
                if [ -n "${RES}" ]; then
                    user="${USER}"
                    pass="${PASS}"
                    ASK="no"
                    echo "using user & pass from config_db file"
                else
                    echo "wrong user & pass into config_db file"
                    ASK="yes"
                fi
            else
                echo "user & pass not detected in config_db file"
                ASK="yes"
            fi
        else
            echo "config_db file not found"
            ASK="yes"
        fi
    fi

# ASK QUESTIONS
    print_info="no"
    if [ "${ASK}" = "yes" ]; then
        ask_question 'Desea configurar la base de datos analytics?'
        if [ "x$input" == "xyes" ]; then
            create_db=$input
            ask_question 'Desea crear usuario para la tabla de la base de datos?'
            create_user=$input
            if [ "x$input" == "xyes" ]; then
                do_dialog 'Database configuration' 'Nombre del usuario para crear:'
                user=$input
                do_dialog 'Database configuration' 'Password del usuario para crear:'
                pass=$input
            else
                do_dialog 'Database configuration' 'Usuario con permiso en bd analytics?'
                user=$input
                do_dialog 'Database configuration' 'Password del usuario con permiso en bd analytics?'
                pass=$input
            fi
            do_dialog 'Database configuration' 'Password root de mysql?'
            rootpass=$input
        else
            print_info="yes"
        fi
    else
    #ASK=no
        create_db="no"
        create_user="no"
        ask_user="no"
    fi

#INITIALIZE DB

    if [ "x$create_db" == "xyes" ]; then
        if [ "x$rootpass" == "x" ]; then
            mysqlroot="mysql -uroot"
            mysqluser="mysql -u$user -p$pass"
        else
            mysqlroot="mysql -uroot -p$rootpass"
            mysqluser="mysql -u$user -p$pass"
        fi
        if [ "x$create_user" == "xyes" ]; then
            echo "create user '$user'@'%' identified by '$pass';" | $mysqlroot
            echo "grant all privileges on analytics.* to '$user'@'%';" | $mysqlroot
            echo "flush privileges;" | $mysqlroot
            echo "user=$user" > /etc/lliurex-analytics-server/config_db
            echo "pass=$pass" >> /etc/lliurex-analytics-server/config_db
            chmod 750 /etc/lliurex-analytics-server/config_db
        fi
        $mysqluser < /usr/lib/analytics-server/analytics.sql
    else
        if [ "x$create_user" != "xyes" -o "${ask_user}" != "no" ]; then
            do_dialog 'Analytics configuration' 'Usuario con permiso en bd analytics?'
            user=$input
            do_dialog 'Analytics configuration' 'Password del usuario con permiso en bd analytics?'
            pass=$input
            echo "user=$user" > /etc/lliurex-analytics-server/config_db
            echo "pass=$pass" >> /etc/lliurex-analytics-server/config_db
            chmod 640 /etc/lliurex-analytics-server/config_db
        fi
    fi

    RES1=$(grep -o '@phpuser@' /usr/lib/analytics-server/analytics/config.php)
    RES2=$(grep -o '@phppass@' /usr/lib/analytics-server/analytics/config.php)

    if [ -f "/usr/lib/analytics-server/analytics/config.php" -a -n "${RES1}" -a -n "${RES2}" ]; then
        sed -i.old -e "s/@phpuser@/$user/g" -e  "s/@phppass@/$pass/g" /usr/lib/analytics-server/analytics/config.php
        rm /usr/lib/analytics-server/analytics/config.php.old
        chmod 640 /usr/lib/analytics-server/analytics/config.php
        apachectl_cmd=$(which apachectl)
        apache_group=$(${apachectl_cmd} -t -D DUMP_RUN_CFG 2>/dev/null|perl -ne '/group:[ ]+name=\"(.*)\"/i && print $1')
        if [ -z "${apache_group}" ]; then
            echo "Warning: apache group not detected, falling back to www-data"
            apache_group="www-data"
        fi
        chgrp ${apache_group} /usr/lib/analytics-server/analytics/config.php
    else
        echo "BUG !! WARNING: replace tags @phpuser@ & @phppass@ not found in /usr/lib/analytics-server/analytics/config.php"
        echo "Installation may not work succesfully, report bug to developers"
    fi


# CONFIG APACHE

    a2enmod rewrite
    a2ensite analytics
    service apache2 restart

    if [ "${print_info}" = "yes" ]; then
            echo
            echo "To import database schema use:"
            echo ""
            echo "echo \"create user '<user>'@'%' identified by '<password>';\" | mysql -u root -p<root_password>"
            echo "echo \"grant all privileges on analytics.* to '<user>'@'%';\" | mysql -u root -p<root_password>"
            echo "echo \"flush privileges; \" | mysql -u root -p<root_password>"
            echo "mysql -u <user> -p<root_password> < /usr/lib/analytics-server/analytics.sql"
            echo "After that, edit /usr/lib/analytics-server/analytics/config.php"
            echo 
            echo
    fi
    ;;

    abort-upgrade|abort-remove|abort-deconfigure)
    ;;

    *)
        echo "postinst called with unknown argument \`$1'" >&2
        exit 1
    ;;
esac

# dh_installdeb will replace this with shell code automatically
# generated by other debhelper scripts.

#DEBHELPER#

exit 0