OpenPKG Specs: davical/davical-setup.sh@f71e028eb3e2

Correct and improve several packaging aspects including...
Correct datadir path for python modules, correct jar(1) path for
building libgcj classes, strip libexecdir path of version numbers,
improve name of oblbld build path, clean whitespace from as(1) and
ld(1) GNU detection, remove seemingly discarded '--with-local-prefix'
configure argument, and correct hardcoded lto plugin libtool archive
dependency information.

Most importantly, correct IA32 architecture detection logic in
config.gcc to correctly emit SSE2 instructions conditionally, leading
to the removal of all '-march' bootstrap options and replacement with
unconditional (for IA32/AMD64) '-mtune=native' options. Comments and
buildtime warnings are corrected appropriately. In theory these changes
cause a more portable, orthoganal, and optimal bootstrap to be built.

     1 #!/bin/sh

     2 ##

     3 ##  davical-setup

     4 ##

     6 #   command line argument sanity check

     7 prg="$0"

     8 if [ $# -eq 0 ]; then

     9     echo "$prg:ERROR: invalid command line" 1>&2

    10     echo "$prg:USAGE: $prg install [<admin-password>]" 1>&2

    11     echo "$prg:USAGE: $prg uninstall" 1>&2

    12     echo "$prg:USAGE: $prg edit" 1>&2

    13     exit 1

    14 fi

    16 #   database configuration

    17 db_dir="@l_prefix@/var/davical/db"

    18 db_name="davical"

    19 db_user="davical"

    20 db_pass="davical"

    21 db_sname=`grep "^superuser_database" @l_prefix@/var/postgresql/db/pg_superuser.conf |\

    22           sed -e 's;^ *superuser_database="\(.*\)".*;\1;'`

    23 db_suser=`grep "^superuser_username" @l_prefix@/var/postgresql/db/pg_superuser.conf |\

    24           sed -e 's;^ *superuser_username="\(.*\)".*;\1;'`

    25 db_spass=`grep "^superuser_password" @l_prefix@/var/postgresql/db/pg_superuser.conf |\

    26           sed -e 's;^ *superuser_password="\(.*\)".*;\1;'`

    28 #   dispatch operation

    29 cmd="${1:-"install"}"

    30 shift

    31 case "$cmd" in

    32     install )

    33         #   determine admin password

    34         admin_password="$1"

    35         if [ ".$admin_password" = . ]; then

    36             admin_password="`@l_prefix@/bin/apg -Mncl -a1 -m12 -n1`"

    37             echo "ATTENTION: using generated \"admin\" password: \"$admin_password\"" 1>&2

    38         fi

    40         #   create database

    41         ( echo "CREATE ROLE $db_user LOGIN ENCRYPTED PASSWORD '$db_pass' NOCREATEDB NOCREATEUSER;"

    42           echo "CREATE TABLESPACE $db_name OWNER $db_user LOCATION '$db_dir';"

    43           echo "CREATE DATABASE $db_name OWNER $db_user TABLESPACE $db_name ENCODING 'SQL_ASCII';"

    44         ) | PGPASSWORD="$db_spass" @l_prefix@/bin/psql -q -U "$db_suser" -d "$db_sname" -f-

    45         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" \

    46             -c "CREATE LANGUAGE plpgsql;"

    48         #   create schema 1/2 (from original "create_database" script)

    49         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" -A -t \

    50             -f "@l_prefix@/lib/davical/awl/dba/awl-tables.sql" 2>&1 | grep -v NOTICE

    51         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" -A -t \

    52             -f "@l_prefix@/lib/davical/awl/dba/schema-management.sql" 2>&1 | grep -v NOTICE

    53         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" -A -t \

    54             -f "@l_prefix@/lib/davical/davical/dba/davical.sql" 2>&1 | grep -v NOTICE

    55         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" -A -t \

    56             -f "@l_prefix@/lib/davical/davical/dba/base-data.sql" 2>&1 | grep -v NOTICE

    58         #   create schema 2/2 (from original "update-davical-database" script)

    59         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" -A -t \

    60             -f "@l_prefix@/lib/davical/davical/dba/supported_locales.sql" 2>&1 | grep -v NOTICE

    61         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" -A -t \

    62             -f "@l_prefix@/lib/davical/davical/dba/caldav_functions.sql" 2>&1 | egrep -v '(NOTICE|ERROR)'

    63         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" -A -t \

    64             -f "@l_prefix@/lib/davical/davical/dba/rrule_functions.sql" 2>&1 | egrep -v '(NOTICE|ERROR)'

    65         PGPASSWORD="$db_spass" @l_prefix@/bin/psql -q -U "$db_suser" -d "$db_name" -A -t \

    66             -f "/opmi/lib/davical/davical/dba/views/dav_principal.sql"

    67         PGPASSWORD="$db_spass" @l_prefix@/bin/psql -q -U "$db_suser" -d "$db_name" -A -t \

    68             -f "@l_prefix@/lib/davical/davical/dba/appuser_permissions.txt" 2>&1 | grep -v NOTICE

    70         #   set admin password

    71         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" \

    72             -c "UPDATE usr SET password = '**$admin_password' WHERE user_no = 1;"

    73         ;;

    75     uninstall )

    76         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" \

    77             -c "DROP LANGUAGE plpgsql CASCADE;" 2>&1 | grep -v NOTICE

    78         ( echo "DROP DATABASE $db_name;"

    79           echo "DROP TABLESPACE $db_name;"

    80           echo "DROP ROLE $db_user;"

    81         ) | PGPASSWORD="$db_spass" @l_prefix@/bin/psql -q -U "$db_suser" -d "$db_sname" -f-

    82         ;;

    84     edit )

    85         PGPASSWORD="$db_spass" @l_prefix@/bin/psql -U "$db_suser" -d "$db_name"

    86         ;;

    87 esac

OpenPKG Specs / file revision

davical/davical-setup.sh@f71e028eb3e2

davical/davical-setup.sh