Eli Mesika has uploaded a new change for review.
Change subject: core: Failed install DB during rhevm-setup...
......................................................................
core: Failed install DB during rhevm-setup...
Failed install DB during rhevm-setup not on clean server
This patch adds a utility encodingvalidator.sh that can be used to
validate that template1 database encoding is UTF8
If template1 database has any other encoding, giving this utility the -f
flag will fix the problem.
Since we were not able to reproduce the BZ, it was agreed that supplying
this utility and calling it from the installer in the
pre-install/upgrade step is sufficient to resolve this problem.
Change-Id: I74dd62ec2c0f96d719b15848da4e08d8f6cc5068
Signed-off-by: Eli Mesika <emes...@redhat.com>
---
A backend/manager/tools/dbutils/encodingvalidator.sh
1 file changed, 119 insertions(+), 0 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/66/12966/1
diff --git a/backend/manager/tools/dbutils/encodingvalidator.sh
b/backend/manager/tools/dbutils/encodingvalidator.sh
new file mode 100755
index 0000000..a0084cf
--- /dev/null
+++ b/backend/manager/tools/dbutils/encodingvalidator.sh
@@ -0,0 +1,119 @@
+###############################################################################################################
+# The purpose of this utility is to find not UTF8 template1 encoding , display
it and enable to fix it
+# Only support may access this utility with care
+# Use the -f flag to fix the problem by removing and recreating template1 with
UTF8 encoding.
+# Running this utility without the -f flag will only report the default
encoding for template1.
+# It is highly recomended to backup the database before using this utility.
+###############################################################################################################
+
+#!/bin/bash
+#include db general functions
+pushd $(dirname ${0})>/dev/null
+source ./common.sh
+
+#setting defaults
+set_defaults
+
+
+usage() {
+ printf "Usage: ${ME} [-h] [-s SERVERNAME [-p PORT]] [-u USERNAME] [-l
LOGFILE] [-f] [-v]\n"
+ printf "\n"
+ printf "\t-s SERVERNAME - The database servername for the database (def.
${SERVERNAME})\n"
+ printf "\t-p PORT - The database port for the database (def.
${PORT})\n"
+ printf "\t-u USERNAME - The admin username for the database.\n"
+ printf "\t-l LOGFILE - The logfile for capturing output (def.
${LOGFILE})\n"
+ printf "\t-f - Fix the templat1 database encoding to be UTF8.\n"
+ printf "\t-v - Turn on verbosity
(WARNING: lots of output)\n"
+ printf "\t-h - This help text.\n"
+ printf "\n"
+ popd>/dev/null
+ exit $ret
+}
+
+DEBUG () {
+ if $VERBOSE; then
+ printf "DEBUG: $*"
+ fi
+}
+
+FIXIT=false
+
+while getopts hs:u:p:l:fv option; do
+ case $option in
+ s) SERVERNAME=$OPTARG;;
+ p) PORT=$OPTARG;;
+ u) USERNAME=$OPTARG;;
+ l) LOGFILE=$OPTARG;;
+ f) FIXIT=true;;
+ v) VERBOSE=true;;
+ h) ret=0 && usage;;
+ \?) ret=1 && usage;;
+ esac
+done
+
+run() {
+ command="${1}"
+ db="${2}"
+ psql --pset=tuples_only=on -w -U ${USERNAME} -h ${SERVERNAME} -p ${PORT} -c
"${command}" ${db} > /dev/null
+}
+
+get() {
+ CMD="SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname =
'template1';"
+ encoding=$(psql --pset=tuples_only=on -w -U ${USERNAME} -h ${SERVERNAME}
-p ${PORT} -c "${CMD}" template1)
+ echo "${encoding}" | sed -e 's/^ *//g'
+}
+
+fix_template1_encoding() {
+ #Allow connecting to template 0
+ CMD="UPDATE pg_database SET datallowconn = TRUE WHERE datname =
'template0';"
+ run "${CMD}" template1
+ #Define template1 as a regular DB so we can drop it
+ CMD="UPDATE pg_database SET datistemplate = FALSE WHERE datname =
'template1';"
+ run "${CMD}" template0
+ #drop tempalte1
+ CMD="drop database template1;"
+ run "${CMD}" template0
+ #recreate template1 with same encoding as template0
+ CMD="create database template1 with template = template0;"
+ run "${CMD}" template0
+ #restore changed defaults for template1
+ CMD="UPDATE pg_database SET datistemplate = TRUE WHERE datname =
'template1';"
+ run "${CMD}" template0
+ #restore changed defaults for template0
+ CMD="UPDATE pg_database SET datallowconn = FALSE WHERE datname =
'template0';"
+ run "${CMD}" template1
+}
+
+if [ "${FIXIT}" = "true" ]; then
+ echo "Caution, this operation should be used with care. Please contact
support prior to running this command"
+ echo "Are you sure you want to proceed? [y/n]"
+ read answer
+
+ if [ "${answer}" = "n" ]; then
+ echo "Please contact support for further assistance."
+ popd>/dev/null
+ exit 1
+ fi
+else
+ encoding=$(get)
+ echo ${encoding}
+ exit 0
+fi
+
+encoding=$(get)
+
+if [[ "${encoding}" = "UTF8" || "${encoding}" = "utf8" ]]; then
+ echo "Database template1 has already UTF8 default encoding configured.
nothing to do, exiting..."
+ exit 0
+fi
+
+fix_template1_encoding
+
+if [ $? -eq 0 ]; then
+ echo "Operation completed successfully"
+else
+ echo "Operation failed"
+fi
+
+popd>/dev/null
+exit $?
--
To view, visit http://gerrit.ovirt.org/12966
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I74dd62ec2c0f96d719b15848da4e08d8f6cc5068
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <emes...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
