Index: installers/debian/dotlrn/TODO =================================================================== RCS file: /usr/local/cvsroot/installers/debian/dotlrn/Attic/TODO,v diff -u -r1.7 -r1.8 --- installers/debian/dotlrn/TODO 27 Mar 2008 12:47:02 -0000 1.7 +++ installers/debian/dotlrn/TODO 28 Mar 2008 10:33:16 -0000 1.8 @@ -2,7 +2,7 @@ [X] Modification of the config.tcl using the FHS routes. [X] Set permissions for user www-data. [ ] Load tsearch sql. -[\] Enable compatibility postgresql options. (Added a warning on debconf). +[X] Enable compatibility postgresql options. [X] Remove and purge logic (postrm). [ ] Lintian errors and warnings. [ ] Fix control file adding tdom (when there is a tdom debian package) Index: installers/debian/dotlrn/postinst =================================================================== RCS file: /usr/local/cvsroot/installers/debian/dotlrn/postinst,v diff -u -r1.4 -r1.5 --- installers/debian/dotlrn/postinst 26 Mar 2008 13:42:16 -0000 1.4 +++ installers/debian/dotlrn/postinst 28 Mar 2008 10:33:16 -0000 1.5 @@ -115,11 +115,15 @@ # echo $error #fi - # Install plpgsql on database + # Install plpgsql on database and enable compatibility options dbuser=$dba_name dbpass=$dba_password sqlfile=/tmp/dotlrn-create-plpgsql.sql - echo "CREATE LANGUAGE plpgsql;" > $sqlfile + 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" ] Index: installers/debian/dotlrn/templates =================================================================== RCS file: /usr/local/cvsroot/installers/debian/dotlrn/templates,v diff -u -r1.2 -r1.3 --- installers/debian/dotlrn/templates 26 Mar 2008 11:40:13 -0000 1.2 +++ installers/debian/dotlrn/templates 28 Mar 2008 10:33:16 -0000 1.3 @@ -44,17 +44,6 @@ Description: Database user password confirmation: Please confirm the password of the dotLRN database owner. -Template: dotlrn/pg_warning -Type: note -Description: Warning - Enable postgresql compatibility options - To allow dotLRN to install properly (on postgresql 8.x), please enable - the following compatibility options on postgresql.conf file before creating - the database: - . - add_missing_from = on - default_with_oids = on - regex_flavor = extended - Template: dotlrn/notconfigured Type: note Description: Warning - dotLRN is not configured