cloudstack/setup/db/deploy-db-dev.sh at main · apache/cloudstack · GitHub

History

executable file

144 lines (115 loc) · 3.51 KB

Raw

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

136

137

138

139

140

141

142

143

144

#!/usr/bin/env bash

# Licensed to the Apache Software Foundation (ASF) under one

# or more contributor license agreements. See the NOTICE file

# distributed with this work for additional information

# regarding copyright ownership. The ASF licenses this file

# to you under the Apache License, Version 2.0 (the

# "License"); you may not use this file except in compliance

# with the License. You may obtain a copy of the License at

# http://www.apache.org/licenses/LICENSE-2.0

# Unless required by applicable law or agreed to in writing,

# software distributed under the License is distributed on an

# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

# KIND, either express or implied. See the License for the

# specific language governing permissions and limitations

# under the License.

# deploy-db.sh -- deploys the database configuration.

# set -x

if [ "$1" == "" ]; then

printf "Usage: %s [path to server-setup.xml] [path to additional sql] [root password]\n" $(basename $0) >&2

exit 1;

if [ ! -f $1 ]; then

echo "Error: Unable to find $1"

exit 2

if [ "$2" != "" ]; then

if [ ! -f $2 ]; then

echo "Error: Unable to find $2"

exit 3

if [ ! -f create-database.sql ]; then

printf "Error: Unable to find create-database.sql\n"

exit 4

if [ ! -f create-schema.sql ]; then

printf "Error: Unable to find create-schema.sql\n"

exit 5

if [ ! -f create-index-fk.sql ]; then

printf "Error: Unable to find create-index-fk.sql\n"

exit 6;

PATHSEP=':'

if [[ $OSTYPE == "cygwin" ]] ; then

export CATALINA_HOME=`cygpath -m $CATALINA_HOME`

PATHSEP=';'

handle_error() {

mysqlout=$?

if [ $mysqlout -eq 1 ]; then

printf "Please enter root password for MySQL.\n"

mysql --user=root --password < $1

if [ $? -ne 0 ]; then

printf "Error: Cannot execute $1\n"

exit 10

elif [ $mysqlout -eq 127 ]; then

printf "Error: Cannot execute $1 - mysql command not found.\n"

exit 11

elif [ $mysqlout -ne 0 ]; then

printf "Error: Cannot execute $1\n"

exit 11

}

echo "Recreating Database cloud."

mysql --user=root --password=$3 < create-database.sql > /dev/null 2>/dev/null

handle_error create-database.sql

echo "Recreating Database cloud_usage"

mysql --user=root --password=$3 < create-database-premium.sql > /dev/null 2>/dev/null

handle_error create-database-premium.sql

mysql --user=cloud --password=cloud cloud < create-schema.sql

if [ $? -ne 0 ]; then

printf "Error: Cannot execute create-schema.sql\n"

exit 11

mysql --user=cloud --password=cloud < create-schema-premium.sql

if [ $? -ne 0 ]; then

printf "Error: Cannot execute create-schema-premium.sql\n"

exit 11

CP=./

CP=${CP}$PATHSEP$CATALINA_HOME/conf

# Add mysql jar from mysql-connector-j package to CP

# for Jenkins

MYSQL_CONNECTOR_VERSION = '8.4.0'

CP=${CP}${PATHSEP}/usr/share/java/mysql-connector-j-${MYSQL_CONNECTOR_VERSION}.jar

for file in $CATALINA_HOME/webapps/client/WEB-INF/lib/*.jar

CP=${CP}$PATHSEP$file

done

for file in $CATALINA_HOME/lib/*.jar; do

CP=${CP}$PATHSEP$file

done

echo CP is $CP

java -cp $CP com.cloud.test.DatabaseConfig $*

if [ $? -ne 0 ]

then

exit 1

if [ "$2" != "" ]; then

mysql --user=cloud --password=cloud cloud < $2

if [ $? -ne 0 ]; then

printf "Error: Cannot execute $2\n"

exit 12

echo "Creating Indice and Foreign Keys"

mysql --user=cloud --password=cloud cloud < create-index-fk.sql

if [ $? -ne 0 ]; then

printf "Error: Cannot execute create-index-fk.sql\n"

exit 13

cloudstack/setup/db/deploy-db-dev.sh at main · apache/cloudstack · GitHub

Uh oh!

Expand file tree

Breadcrumbs

deploy-db-dev.sh

Latest commit

History

Breadcrumbs

deploy-db-dev.sh

File metadata and controls