blob: 0c36a3fce73675d64d68504382bd6d8e4dd10b8a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
#!/bin/bash
# /////////////////////////////////////////////////////////////////////////////
# //BOCA Online Contest Administrator
# // Copyright (C) 2016- by BOCA Development Team (bocasystem@gmail.com)
# //
# // This program is free software: you can redistribute it and/or modify
# // it under the terms of the GNU General Public License as published by
# // the Free Software Foundation, either version 3 of the License, or
# // (at your option) any later version.
# //
# // This program is distributed in the hope that it will be useful,
# // but WITHOUT ANY WARRANTY; without even the implied warranty of
# // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# // GNU General Public License for more details.
# // You should have received a copy of the GNU General Public License
# // along with this program. If not, see <http://www.gnu.org/licenses/>.
# /////////////////////////////////////////////////////////////////////////////
# // Last modified 15/Sep/2016 by brunoribas@utfpr.edu.br
if ! whoami | grep -q '^root$' ; then
echo "$0 must be run as root"
exit 1
fi
if [[ "$1" == "-h" ]]; then
echo "Usage:"
echo " $0 [-f]"
echo " -f : Optional Parameter that enforces the (re)creation of the postgres holes"
echo " this also regenerate passwords"
echo " first time execution everything is created."
exit 0
fi
. /etc/boca.conf
privatedir=$bocadir/src/private
postgresuser=postgres
if [[ "x$bdserver" == "x" ]]; then
echo "Please run boca-config-dbhost first"
exit 2
fi
if [[ "x$bdcreated" == "x" || "$1" == "-f" ]] ; then
OK=n
if [[ "$bdserver" == "localhost" ]]; then
echo "You need to define a password to be used in the database."
echo "IF THIS IS A BKP SERVER, PLEASE USE THE SAME AS IN THE MAIN SERVER."
echo -n "It is possible generate a random one. Want a random password "
read -p "[Y/n]? " OK
fi
if [ "$OK" = "n" ]; then
read -p "Enter DB password: " -s PASS
else
PASS=`makepasswd --char 10`
echo "The DB password is: $PASS"
fi
echo "Keep the DB password safe!"
if [[ "$bdserver" == "localhost" ]]; then
su - $postgresuser -c "echo drop user bocauser | psql -d template1 >/dev/null 2>/dev/null"
su - $postgresuser -c "echo create user bocauser createdb password \'$PASS\'| psql -d template1"
su - $postgresuser -c "echo alter user bocauser createdb password \'$PASS\'| psql -d template1"
fi
if [[ "x$bdcreated" == "x" ]]; then
echo 'bdcreated=y' >> /etc/boca.conf
fi
fi
if ! echo "$*" | grep -q 'nocreate'; then
php ${bocadir}/src/private/createdb.php
chown www-data.www-data ${bocadir}/src/private/conf.php
chmod 600 ${bocadir}/src/private/conf.php
fi
exit 0
|
