davical/davical-setup.sh@4a34d7a82eab
davical/davical-setup.sh
Tue, 29 Mar 2011 20:04:34 +0200
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Tue, 29 Mar 2011 20:04:34 +0200
- changeset 334
- 4a34d7a82eab
- parent 295
- adc4bc1f8985
- child 396
- 610cba0674b9
- permissions
- -rw-r--r--
Rework package yet again, correcting and introducing new buildconf logic:
Conditionally disable bootstrap stage comparison correctly, correct
english grammar, better find system as(1) and ld(1), indotruce detailed
optimization option messages, more completely guess cpu types, allow
profiled bootstrapping without a preinstalled GCC because many other
compilers have long since implemented 64-bit arithmetic, instruct make
to build sequentially (not in sparallel) when building a profiled
bootstrap as GCC online documents recommend, and generally improve
comment blocks.
The single most important correction in this changeset relates to the
GCC changed optimization policy since at least GCC 4.5, in which -march
is always passed and not always correctly guessed. In the case of this
package, allowing GCC to guess the architecture leads to wild build
errors at various subcomponents (zlib, libgcc, libiberty...) and
bootstrap stages. It seems quite platform specific, and the safest
approach to correcting this seems to be explicitly always specifying the
-march argument when bootstrapping GCC. Because the best choice 'native'
is not available when bootstrapping using a foreign (non GCC) compiler,
a guess is made according to rpmmacros l_platform in that case.
It is questionable as to whether these recent optimization changes
on the part of GCC or this package are compatible with each other,
or if either are complete or correct at all. At least applying these
corrections allows this package to build again in most cases test.
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
