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
|
#!/bin/sh
#
# Pantera first time installation script.
#
# License (For this script only, not for Pantera): BSD.
#
# Bug reports & feature requests > onatan@gmail.com
#
# This script assumes the following:
# MySQL client and server are installed and useable.
# There is no Database named "pantera" (default name).
# User will take care of hardening database permissions after the installation
# is finished.
#
# Feel free to change these, if you know what you're doing
DBNAME="pantera"
DBHOST="localhost"
DBUSER="root"
DBPASS=""
echo "==> Checking that MySQL server is available:"
if [ -n "${DBPASS}" ]; then
PING=`mysqladmin -h ${DBHOST} -u ${DBUSER} -p=${DBPASS} ping`
else
PING=`mysqladmin -h ${DBHOST} -u ${DBUSER} ping`
fi
if [ "mysqld is alive" != "${PING}" ]; then
echo "Cannot connect to MySQL with user 'root' and no password."
echo "Edit ${0} for different user and password."
exit 1
fi
echo "==> Creating database schema named ${DBNAME}:"
if [ -n "${DBPASS}" ]; then
mysqladmin -h ${DBHOST} -u ${DBUSER} -p=${DBPASS} create ${DBNAME}
CRTDB=$?
else
mysqladmin -h ${DBHOST} -u ${DBUSER} create ${DBNAME}
CRTDB=$?
fi
if [ "0" -ne "${CRTDB}" ]; then
echo "Cannot create schema. Maybe it is already there."
echo "If you want to drop it, use:"
echo "mysqladmin drop ${DBNAME}"
echo "with the proper user-name and password."
exit 1
fi
echo "==> Identifying Schema file:"
# Hack to get DATADIR:
TMP1=`which pantera.sh`
TMP2=`grep "^cd /" ${TMP1}`
TMP3=`echo "${TMP2}" | sed "s/^cd //" `
DATADIR=$TMP3
SCHEMA_FILE=${DATADIR}/doc/pantera_sql_create_script.txt
if [ ! -r ${SCHEMA_FILE} ]; then
echo "Cannot identify schema file."
echo "I guessed it would be at:"
echo "${SCHEMA_FILE}"
echo "but it was not there, or not readable."
echo "If you know where it is, set SCHEMA_FILE variable manually."
exit 1
fi
echo "==> Installing schema:"
if [ -n "${DBPASS}" ]; then
mysql -h ${DBHOST} -u ${DBUSER} -p=${DBPASS} ${DBNAME} < ${SCHEMA_FILE}
INSTSCHM=$?
else
mysql -h ${DBHOST} -u ${DBUSER} ${DBNAME} < ${SCHEMA_FILE}
INSTSCHM=$?
fi
if [ "0" -ne "${INSTSCHM}" ]; then
echo "Cannot install schema."
echo "Very weird - we should have failed earlier."
exit 1
fi
echo "==> All Done!"
echo "If you made any changes to the user-name and password,"
echo "or plan to make these changes, update the panteracfg.xml file,"
echo "in ${DATADIR} ."
echo "It would also be a good idea to create a database-user for pantera,"
echo "GRANT this users rights on the \"${DBNAME}\" database schema,"
echo "and set a password for this user. See MySQL Documentation at"
echo "http://www.mysql.org/doc/ for more details."
echo "To use Pantera, run \"pantera.sh\", and set the IP address of"
echo "this machine, and port 8080, to your browsers proxy."
|
