_ >   7 7 db_capb backup
  8 8
  9 9 STATE=1
< >   10   while [ "$STATE"  != 0 -a "$STATE" != 12 ]
    10 while [ "$STATE"  != 0 -a "$STATE" != 13 ]
11 11   do
  12 12   case "$STATE" in
  13 13       1)
 
17 17               if [ ! -z "$RET" ]; then
  18 18                   STATE=2
  19 19               fi
< >     20               pg_host="$RET"
20 21           else
  21 22               STATE=1
  22 23           fi
 
73 74               if [ ! -z "$RET" ]; then
  74 75                   STATE=7
  75 76               fi
< >     77               pg_user="$RET"
76 78           else
  77 79               STATE=2
  78 80           fi
 
97 99               if [ "$RET" != "$CONFIRM" ]; then
  98 100                   STATE=9
  99 101               else
< >   100                     STATE=10
    102                   # Check if host is localhost, user is not www-data and password is not null,
    103                   # to change the postgresql access permissions properly.
    104                   if { [ "$pg_host" = "localhost" ] && [ "$pg_user" != "www-data" ]; } then
    105                       STATE=10
    106                       if [ "A$RET" != "A" ]; then
    107                           pg_pass_blank="false"
    108                       else
    109                           pg_pass_blank="true"
    110                       fi
    111                   else
    112                       STATE=11
    113                   fi
101 114               fi
  102 115           else
  103 116               STATE=6
 
110 123           STATE=6
  111 124           ;;
  112 125
< >   113         10)
    126
    127       10) db_input critical openacs/pg_grant_access || true
    128           db_go
    129           db_get openacs/pg_grant_access || true
    130           if [ "$RET" = false ]; then
    131               if [ "$pg_pass_blank" = "true" ]; then
    132                   db_input critical openacs/pg_grant_access_manual_blank_pass || true
    133               else
    134                   db_input critical openacs/pg_grant_access_manual || true
    135               fi
    136           fi
    137           STATE=11
    138           ;;
    139         
    140       11)
114 141           # Check if tsearch tables exists
  115 142           dbname=template1
  116 143           db_get openacs/db_host
 
137 164                 err=1
  138 165                 echo $error
  139 166           fi
< >   140             STATE=11
    167           STATE=12
141 168           ;;
  142 169
< >   143         11)
    170       12)
144 171           db_input critical openacs/create_tables || true
  145 172           db_go
< >   146             STATE=12
    173           STATE=13
< _   147 174           ;;
  148 175   esac
  149 176 done