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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
#!/bin/sh
# Cyphesis Online RPG Server and AI Engine
# Copyright (C) 2002-2007 Alistair Riddoch
# 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 2 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, write to the Free Software Foundation,
# Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
# $Id: cyphesis-setup.sh,v 1.5 2008-06-08 22:59:06 alriddoch Exp $
# The main purpose of this script is to get round the issue of access to
# to the database required by cyphesis.
cat << EOWELCOME
Welcome to cyphesis.
This script will go through the steps required to configure
your system so that you can run cyphesis. An important part of this
process is setting up access to the PostgreSQL RDBMS, so this script
must be run as root or with sudo access. It is strongly recommended that
you run cyphesis using a normal user account, and this script will help to
set up access for this account to the database.
This script will remove any existing server rules and maps, but will
preserve any user accounts in the server.
EOWELCOME
# Check who is running this script. This should either be the user who is
# going to run cyphesis, or root if extra privs are required to set up
# database access
RUNNINGAS=`whoami`
if test ${RUNNINGAS} != "root"; then
echo Not running as root, so will try and use sudo.
echo
if ! sudo -p "Please enter your password for sudo access or hit ctrl-c to abort:" /bin/true; then
echo ERROR: $0:
echo You must run $0 as root in order to create the database accounts.
echo The best way to run it is using sudo or su.
exit 1
fi
fi
while test x${USERNAME} == "x" || test ${USERNAME} == "root"; do
echo
echo Unable to determine your real username.
echo Cyphesis cannot be run as root for security reasons.
echo Please give the username of the account that will be running cyphesis,
echo or hit ctrl-c to abort.
read -e -p "Your username:" REALUSERNAME
if sudo su ${REALUSERNAME} -c /bin/true; then
USERNAME=${REALUSERNAME}
else
echo
echo Unable to become account ${USERNAME}.
echo It looks as though you did not enter the username of a valid account.
fi
done
# exit 0
# We now have root privs using sudo, and know the users real username in
# ${USERNAME}. We can proceed to set up their account.
CREATE_USER_CMD=`which createuser 2>/dev/null`
CREATE_DATABASE_CMD=`which createdb 2>/dev/null`
POSTGRESQL_SUSER=postgres
POSTGRESQL_QUERY_CMD=`which psql 2>/dev/null`
POSTGRESQL_TEMPLATE=template1
# Check whether the user already has an account. There is more than one
# reason why this might fail, but we assume if it does that it
# means the user does not have access. The database account we create
# has the right to create databases.
if sudo -u ${USERNAME} ${POSTGRESQL_QUERY_CMD} -c "" ${POSTGRESQL_TEMPLATE} 2> /dev/null ; then
echo PostgreSQL user ${USERNAME} already exists. Good.
else
echo Creating PostgreSQL account for user ${USERNAME}...
sudo -u ${POSTGRESQL_SUSER} ${CREATE_USER_CMD} -A -d -q -R ${USERNAME} || \
(echo ERROR: $0: Unable to create database account ${USERNAME}. ; \
exit 1)
echo Created PostgreSQL user ${USERNAME}.
fi
echo
# Check whether a database called cyphesis exists, and the user we are
# setting up can connect to it. If the database exists, but we cannot
# connect to it, this will fail. If the user already had a PostgeSQL
# account, but did not have the right to create databases, this will fail.
if sudo -u ${USERNAME} $POSTGRESQL_QUERY_CMD -c "" cyphesis 2> /dev/null ; then
echo PostgreSQL database cyphesis already exists.
else
echo Creating PostgreSQL database cyphesis as user ${USERNAME}...
sudo -u ${USERNAME} ${CREATE_DATABASE_CMD} -q cyphesis
echo Created PostgreSQL database cyphesis as ${USERNAME}.
fi
echo
# Currently dropping the rules and world should not have any
# negative consequences, as there is no instance specific data
# in these tables, and no tools currently exist for the user to
# modify them.
echo Clearing rules data...
sudo -u ${USERNAME} $POSTGRESQL_QUERY_CMD -c "DROP TABLE rules;" cyphesis > /dev/null 2>&1
echo Cleared.
echo
SCRIPTDIR=`dirname $0`
# cyloadrules automatically picks up the right files for the ruleset
# set in the main config.
echo Loading game rules into database...
if sudo -u ${USERNAME} ${SCRIPTDIR}/../tools/cyloadrules 2> /dev/null; then
echo Loaded.
else
echo ERROR: $0: Unable to load rules into database.
exit 1
fi
echo
echo This system is now ready to run cyphesis.
|
