#! /bin/sh -e
# postinst script for dotlrn 
#
# see: dh_installdeb(1)
#
# 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>
#        * <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
#
# quoting from the policy:
#     Any necessary prompting should almost always be confined to the
#     post-installation script, and should be protected with a conditional
#     so that unnecessary prompting doesn't happen if a package's
#     installation fails and the `postinst' is called with `abort-upgrade',
#     `abort-remove' or `abort-deconfigure'.

get_config() {
    db_get dotlrn/db_host
    db_host="$RET"

    db_type="postgres7"
    db_port=5432 

    db_get dotlrn/dba_name
    dba_name="$RET"

    db_get dotlrn/dba_password
    dba_password="$RET"

    db_get dotlrn/dbu_name
    dbu_name="$RET"

    db_get dotlrn/dbu_password
    dbu_password="$RET"
    
    db_get dotlrn/pg_grant_access
    if [ ! -z "$RET" ]; then
        grant_access="$RET"
    else
        grant_access="false"
    fi
}

db_not_installed() {
    echo "Please install the chosen dotLRN SGBD: postgresql, then try"
    echo "dpkg-reconfigure dotlrn"
}

case "$1" in
    configure)
	. /usr/share/debconf/confmodule
	db_version 2.0

	# Read debconf and edit the config file accordingly
	get_config
	db_stop
	exec 0<&1
	
	 # Care about the repository
        repository=/var/lib/dotlrn
        if [ -d $repository ]; then
            # set the owner and change rights accordingly
            chown -R www-data:www-data $repository
            chmod 0755 $repository
        fi

	# Care about the log directory
	logdir=/var/log/aolserver4/dotlrn
        if [ -d $logdir ]; then
            # set the owner and change rights accordingly
            chown -R www-data:www-data $logdir
            chmod 0755 $logdir
        fi
	
	# Care about the app dir
        appdir=/usr/share/dotlrn
        if [ -d $appdir ]; then
            # set the owner and change rights accordingly
            chown -R www-data:www-data $appdir
        fi

	# care about the database creation
	dbname=dotlrn
	dbserver=$db_host
	dbadmin=$dba_name
	dbadmpass=$dba_password
	dbuser=$dbu_name
        dbpass=$dbu_password

	. /usr/share/wwwconfig-common/pgsql-createuser.sh
	if [ "$status" = "error" ]
	then
		err=1
		echo $error
	fi
	. /usr/share/wwwconfig-common/pgsql-createdb.sh
	if [ "$status" = "error" ]
	then
		err=1
		echo $error
	fi
	
	# Modify the pg_hba.conf to grant dotlrn user access to postgresql
	# 1- Do we want to do that?
	if [ "$grant_access" = true ]; then

		# 2- Where is the pg_hba.conf from this database instance?
		dbuser=$dba_name
                dbpass=$dba_password
		. /usr/share/wwwconfig-common/pgsql.get
		pg_hba_file=$($pgsqlcmd -c "SELECT * from pg_settings where name='hba_file';" 2>/dev/null | grep hba | cut -d\| -f2)
		pg_version=$(echo "$pg_hba_file" | cut -d\/ -f4)
		if [ "$status" = "error" ]
          		then
                	err=1
                	echo $error
          	else
			# 3- Modify the file
			# Select connection method
			if [ "A$dbu_password" != "A" ]; then 	
				# No Blank Password
				pg_conn_method="md5"
			else
				# Blank Password
				pg_conn_method="trust"
			fi
			# Delete all lines between ## dotLRN ... ## and ########### from previous configurations.
			# Insert connection line after the first local connection line (the postgres user connection line).
			sed -i "/^## dotLRN package debconf changes (DO NOT EDIT BYHAND) ##/,/^#########################################################/d;1,/^local/{
        /^local/a ## dotLRN package debconf changes (DO NOT EDIT BYHAND) ##\nlocal   dotlrn     $dbu_name                              $pg_conn_method\n#########################################################
} " $pg_hba_file
			
			# 4-Reload postgresql conf
			/etc/init.d/postgresql-"$pg_version" reload
		fi
	fi

	# Modify config.tcl with debconf values
	dbuser=$dbu_name
        dbpass=$dbu_password	
	sed -i "/^    set db_host/,/^    set db_user/d;s/## Debconf changes (DO NOT EDIT BYHAND) ##/&\n    set db_host               $dbserver\n    set db_password           \"$dbpass\"\n    set db_port               \"5432\"\n    set db_user               $dbuser/" /etc/dotlrn/config.tcl

	# Install plpgsql on database and enable compatibility options
	dbuser=$dba_name
	dbpass=$dba_password
	sqlfile=/tmp/dotlrn-create-plpgsql.sql
	echo "CREATE LANGUAGE plpgsql;
		ALTER DATABASE dotlrn SET add_missing_from = on;
		ALTER DATABASE dotlrn SET default_with_oids = on;
		ALTER DATABASE dotlrn SET regex_flavor = extended;
		" > $sqlfile
        . /usr/share/wwwconfig-common/pgsql-exec.sh
	rm -f $sqlfile
        if [ "$status" = "error" ]
        then
                err=1
                echo $error
        fi

	
	if [ "$err" = "1" ]
	then
		echo "-------------------------------------------------------------"
		echo "I've tried my best to create the dotLRN user and database"
		echo "but an error has occurred"
		echo "-------------------------------------------------------------"
		echo "You will have to set up the dotLRN user and database yourself"
		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