QM Backend Deployment

Requirements

Kubernetes. Deployment Planning
Storage Solution Storage Solution - Getting Started
CX Deployement https://expertflow-docs.atlassian.net/wiki/x/r5Qm

Deployment

Add the Expertflow Helm charts repository.

CODE

helm repo add expertflow https://expertflow.github.io/charts

Update the charts repository

CODE

helm repo update expertflow

Clone QM Backend Repository

CODE

git clone -b CX-4.7-helm  https://efcx:RecRpsuH34yqp56YRFUb@gitlab.expertflow.com/cim/cim-solution.git CX-4.7-helm

CODE

cd CX-4.7-helm/kubernetes

Create a database with name qm_backend in Postgres.

export the admin username/password pair for postgresql-client pod

CODE

export POSTGRES_ADMIN_PASSWORD=$(kubectl get secret --namespace ef-external ef-postgresql -o jsonpath="{.data.postgres-password}" | base64 -d)

and for sa user ( default user for EF-CX component using PostgreSQL database )

CODE

export POSTGRES_PASSWORD=$(kubectl get secret --namespace ef-external ef-postgresql -o jsonpath="{.data.password}" | base64 -d)

launch the postgresql client

CODE

 kubectl run ef-postgresql-client --namespace ef-external --image docker.io/bitnami/postgresql:14.5.0-debian-11-r21 --env="PGPASSWORD=$POSTGRES_PASSWORD"  --command -- sleep infinity

once the pod is running, exec into the postgresql-client pod

CODE

kubectl -n ef-external exec -it ef-postgresql-client -- bash

execute the environment setup for postgresql-client ( Only needed when the postgresql is running in non-HA mode , like no pgpool and multiple replicas of postgresql are running )

CODE

/opt/bitnami/scripts/postgresql/entrypoint.sh /bin/bash

Log into Postgres using the following command:-

CODE

psql --host ef-postgresql -U sa postgres -p 5432

Create db and extensions using the following commands:-

CODE

CREATE DATABASE qm_db;
\c qm_db;
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
\c postgres;

Open the file qm-backend/values.yaml and edit it according to the below given information which is necessary for the qm-backend to work properly.

Value	Updated Value
ingressRouter	FQDN of the host

Finally, deploy the qm-backend using the following command:-

CODE

helm upgrade --install --namespace=expertflow --set global.efCxReleaseName="ef-cx" qm-backend  --debug --values=qm-backend/values.yaml qm-backend