|
| |
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 |