4 # Copyright Telefonica Investigacion y Desarrollo, S.A.U.
7 # Licensed under the Apache License, Version 2.0 (the "License"); you may
8 # not use this file except in compliance with the License. You may obtain
9 # a copy of the License at
11 # http://www.apache.org/licenses/LICENSE-2.0
13 # Unless required by applicable law or agreed to in writing, software
14 # distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
15 # WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
16 # License for the specific language governing permissions and limitations
36 echo -e "usage: sudo $0 [OPTIONS]"
37 echo -e "Install openmano database server and the needed packages"
39 echo -e " -U USER: database admin user. '$DB_ADMIN_USER' by default. Prompts if needed"
40 echo -e " -P PASS: database admin password to be used or installed. Prompts if needed"
41 echo -e " -d: database name, '$DB_NAME' by default"
42 echo -e " -u: database user, '$DB_USER' by default"
43 echo -e " -p: database pass, '$DB_PASS' by default"
44 echo -e " -H: HOST database host. 'localhost' by default"
45 echo -e " -T: PORT database port. '$DB_PORT' by default"
46 echo -e " -q --quiet: install in unattended mode"
47 echo -e " -h --help: show this help"
48 echo -e " --forcedb: if database exists, it is dropped and a new one is created"
49 echo -e " --updatedb: if database exists, it preserves the content and it is updated to the needed version"
50 echo -e " --no-install-packages: use this option to skip updating and installing the requires packages. This avoid wasting time if you are sure requires packages are present e.g. because of a previous installation"
51 echo -e " --unistall: delete database"
55 # ask to the user and parse a response among 'y', 'yes', 'n' or 'no'. Case insensitive
56 # Params: $1 text to ask; $2 Action by default, can be 'y' for yes, 'n' for no, other or empty for not allowed
57 # Return: true(0) if user type 'yes'; false (1) if user type 'no'
58 read -e -p "$1" USER_CONFIRMATION
60 [ -z "$USER_CONFIRMATION" ] && [ "$2" == 'y' ] && return 0
61 [ -z "$USER_CONFIRMATION" ] && [ "$2" == 'n' ] && return 1
62 [ "${USER_CONFIRMATION,,}" == "yes" ] ||
[ "${USER_CONFIRMATION,,}" == "y" ] && return 0
63 [ "${USER_CONFIRMATION,,}" == "no" ] ||
[ "${USER_CONFIRMATION,,}" == "n" ] && return 1
64 read -e -p "Please type 'yes' or 'no': " USER_CONFIRMATION
68 function install_packages
(){
69 [ -x /usr
/bin
/apt-get
] && apt-get
install -y $
*
70 [ -x /usr
/bin
/yum
] && yum
install -y $
*
72 #check properly installed
75 PACKAGE_INSTALLED
="no"
76 [ -x /usr
/bin
/apt-get
] && dpkg
-l $PACKAGE &>> /dev
/null
&& PACKAGE_INSTALLED
="yes"
77 [ -x /usr
/bin
/yum
] && yum list installed
$PACKAGE &>> /dev
/null
&& PACKAGE_INSTALLED
="yes"
78 if [ "$PACKAGE_INSTALLED" = "no" ]
80 echo "failed to install package '$PACKAGE'. Revise network connectivity and try again" >&2
86 function _install_mysql_package
(){
88 #################################################################
89 ##### INSTALL REQUIRED PACKAGES #####
90 #################################################################'
91 [ "$_DISTRO" == "Ubuntu" ] && ! install_packages
"mysql-server" && exit 1
92 [ "$_DISTRO" == "CentOS" -o "$_DISTRO" == "Red" ] && ! install_packages
"mariadb mariadb-server" && exit 1
94 if [[ "$_DISTRO" == "Ubuntu" ]]
96 #start services. By default CentOS does not start services
97 service mysql start
>> /dev
/null
98 # try to set admin password, ignore if fails
99 [[ -n $DBPASSWD ]] && mysqladmin
-u $DB_ADMIN_USER -s password
$DB_ADMIN_PASSWD
102 if [ "$_DISTRO" == "CentOS" -o "$_DISTRO" == "Red" ]
104 #start services. By default CentOS does not start services
105 service mariadb start
107 systemctl
enable mariadb
108 systemctl
enable httpd
109 ask_user
"Do you want to configure mariadb (recommended if not done before) (Y/n)? " y
&&
110 mysql_secure_installation
112 ask_user
"Do you want to set firewall to grant web access port 80,443 (Y/n)? " y
&&
113 firewall-cmd
--permanent --zone=public
--add-service=http
&&
114 firewall-cmd
--permanent --zone=public
--add-service=https
&&
115 firewall-cmd
--reload
119 function _create_db
(){
121 #################################################################
122 ##### CREATE AND INIT DATABASE #####
123 #################################################################'
124 echo "mysqladmin --defaults-extra-file="$TEMPFILE" -s create ${DB_NAME}"
125 mysqladmin
--defaults-extra-file="$TEMPFILE" -s create
${DB_NAME} \
126 ||
! echo "Error creating ${DB_NAME} database" >&2 \
128 echo "CREATE USER $DB_USER@'localhost' IDENTIFIED BY '$DB_PASS';" | mysql
--defaults-extra-file="$TEMPFILE" -s 2>/dev
/null \
129 ||
echo "Warning: User '$DB_USER' cannot be created at database. Probably exist" >&2
130 echo "GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '$DB_USER'@'localhost';" | mysql
--defaults-extra-file="$TEMPFILE" -s \
131 ||
! echo "Error: Granting privileges to user '$DB_USER' at database" >&2 \
133 echo " Database '${DB_NAME}' created, user '$DB_USER' password '$DB_PASS'"
134 DIRNAME
=$
(dirname $
(readlink
-f ${BASH_SOURCE[0]}))
135 ${DIRNAME}/init_mano_db.sh
-u"$DB_USER" -p"$DB_PASS" -d"$DB_NAME" -P"$DB_PORT" $DB_HOST_PARAM \
136 ||
! echo "Error initializing database '$DB_NAME'" >&2 \
140 function _delete_db
(){
141 mysqladmin
--defaults-extra-file="$TEMPFILE" -s drop
"${DB_NAME}" $DBDELETEPARAM \
142 ||
! echo "Error: Could not delete '${DB_NAME}' database" >&2 \
146 function _update_db
(){
148 #################################################################
149 ##### UPDATE DATABASE #####
150 #################################################################'
151 echo "CREATE USER $DB_USER@'localhost' IDENTIFIED BY '$DB_PASS';" | mysql
--defaults-extra-file="$TEMPFILE" -s 2>/dev
/null \
152 ||
echo "Warning: User '$DB_USER' cannot be created at database. Probably exist" >&2
153 echo "GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '$DB_USER'@'localhost';" | mysql
--defaults-extra-file="$TEMPFILE" -s \
154 ||
! echo "Error: Granting privileges to user '$DB_USER' at database" >&2 \
156 echo " Granted privileges to user '$DB_USER' password '$DB_PASS' to existing database '${DB_NAME}'"
157 DIRNAME
=$
(dirname $
(readlink
-f ${BASH_SOURCE[0]}))
158 ${DIRNAME}/migrate_mano_db.sh
-u"$DB_USER" -p"$DB_PASS" -d"$DB_NAME" -P"$DB_PORT" $DB_HOST_PARAM \
159 ||
! echo "Error updating database '$DB_NAME'" >&2 \
163 function _uninstall_db
(){
165 #################################################################
166 ##### DELETE DATABASE #####
167 #################################################################'
169 [[ -n $QUIET_MODE ]] && DBDELETEPARAM
="-f"
173 function db_exists
(){ # (db_name, credential_file)
175 mysqlshow
--defaults-extra-file="$2" >/dev
/null ||
exit 1
176 if mysqlshow
--defaults-extra-file="$2" |
grep -v Wildcard |
grep -w -q $1
178 # echo " DB $1 exists"
181 # echo " DB $1 does not exist"
185 while getopts ":U:P:d:u:p:H:T:hiq-:" o
; do
188 export DB_ADMIN_USER
="$OPTARG"
191 export DB_ADMIN_PASSWD
="$OPTARG"
194 export DB_NAME
="$OPTARG"
197 export DB_USER
="$OPTARG"
200 export DB_PASS
="$OPTARG"
203 export DB_HOST
="$OPTARG"
204 export DB_HOST_PARAM
="-h$DB_HOST"
207 export DB_PORT
="$OPTARG"
210 export QUIET_MODE
=yes
211 export DEBIAN_FRONTEND
=noninteractive
217 [ "${OPTARG}" == "help" ] && usage
&& exit 0
218 [ "${OPTARG}" == "forcedb" ] && FORCEDB
="y" && continue
219 [ "${OPTARG}" == "updatedb" ] && UPDATEDB
="y" && continue
220 [ "${OPTARG}" == "quiet" ] && export QUIET_MODE
=yes && export DEBIAN_FRONTEND
=noninteractive
&& continue
221 [ "${OPTARG}" == "no-install-packages" ] && export NO_PACKAGES
=yes && continue
222 [ "${OPTARG}" == "uninstall" ] && UNINSTALL
="y" && continue
223 echo -e "Invalid option: '--$OPTARG'\nTry $0 --help for more information" >&2
227 echo -e "Invalid option: '-$OPTARG'\nTry $0 --help for more information" >&2
231 echo -e "Option '-$OPTARG' requires an argument\nTry $0 --help for more information" >&2
240 if [ -n "$FORCEDB" ] && [ -n "$UPDATEDB" ] ; then
241 echo "Error: options --forcedb and --updatedb are mutually exclusive" >&2
245 # Discover Linux distribution
247 [ -f /etc
/redhat-release
] && _DISTRO
=$
(cat /etc
/redhat-release
2>/dev
/null | cut
-d" " -f1)
248 # if not assuming ubuntu type
249 [ -f /etc
/redhat-release
] || _DISTRO
=$
(lsb_release
-is 2>/dev
/null
)
251 if [[ -z "$NO_PACKAGES" ]]
253 [ "$USER" != "root" ] && echo "Needed root privileges" >&2 && exit 1
254 _install_mysql_package ||
exit 1
257 # Creating temporary file for MYSQL installation and initialization"
258 TEMPFILE
="$(mktemp -q --tmpdir "installdb.XXXXXX
")"
259 trap 'rm -f "$TEMPFILE"' EXIT
260 chmod 0600 "$TEMPFILE"
261 echo -e "[client]\n user='${DB_ADMIN_USER}'\n password='$DB_ADMIN_PASSWD'\n host='$DB_HOST'\n port='$DB_PORT'" > "$TEMPFILE"
263 #check and ask for database user password. Must be done after database installation
264 if [[ -z $QUIET_MODE ]]
266 echo -e "\nCheking database connection and ask for credentials"
267 # echo "mysqladmin --defaults-extra-file=$TEMPFILE -s status >/dev/null"
268 while ! mysqladmin
--defaults-extra-file="$TEMPFILE" -s status
>/dev
/null
270 [ -n "$logintry" ] && echo -e "\nInvalid database credentials!!!. Try again (Ctrl+c to abort)"
271 [ -z "$logintry" ] && echo -e "\nProvide database credentials"
272 read -e -p "database admin user? ($DB_ADMIN_USER) " DBUSER_
273 [ -n "$DBUSER_" ] && DB_ADMIN_USER
=$DBUSER_
274 read -e -s -p "database admin password? (Enter for not using password) " DBPASSWD_
275 [ -n "$DBPASSWD_" ] && DB_ADMIN_PASSWD
="$DBPASSWD_"
276 [ -z "$DBPASSWD_" ] && DB_ADMIN_PASSWD
=""
277 echo -e "[client]\n user='${DB_ADMIN_USER}'\n password='$DB_ADMIN_PASSWD'\n host='$DB_HOST'\n port='$DB_PORT'" > "$TEMPFILE"
282 if [[ ! -z "$UNINSTALL" ]]
288 # Create or update database
289 if db_exists
$DB_NAME $TEMPFILE ; then
290 if [[ -n $FORCEDB ]] ; then
292 # [[ -n $QUIET_MODE ]] && DBDELETEPARAM="-f"
296 elif [[ -n $UPDATEDB ]] ; then
298 elif [[ -z $QUIET_MODE ]] ; then
299 echo "database '$DB_NAME' exist. Reinstall it?"
300 if ask_user
"Type 'y' to drop and reinstall existing database (content will be lost), Type 'n' to update existing database (y/N)? " n
; then
307 echo "Database '$DB_NAME' exists. Use option '--forcedb' to force the deletion of the existing one, or '--updatedb' to use existing one and update it"