backup-gitops/oracle-cloud/k8s-zammad/namespaces/zammad/README.md

Integracion Keycloak

1. Avoid Autowizard
2. Ensure HTTPS and Host
3. follow https://admin-docs.zammad.org/en/latest/settings/security/third-party/saml.html
4. follow https://community.zammad.org/t/saml-keycloak-invalid-request/3773

Create 2 mappers

1. For name as javascript mapper (delete mapper for name and recrete)

var firstname = user.getFirstName();
var lastname = user.getLastName();
var fullname = firstname+' '+lastname;

exports = fullname;

ADD HELM REPO

helm repo add zammad https://zammad.github.io/zammad-helm

INSTALL HELM

helm install zammad zammad/zammad --namespace zammad --version 6.7.1 --values values.yaml

UPGRADE HELM

helm upgrade zammad zammad/zammad --namespace zammad --version 6.7.1 --values values.yaml

CONNECT PG DATABASE FOR CONSOLE

PG_CLUSTER_PRIMARY_POD=$(kubectl get pod --context context-cohijevimoq -n dbs -o name -l postgres-operator.crunchydata.com/cluster=pg,postgres-operator.crunchydata.com/role=master)

kubectl --context context-cohijevimoq -n dbs port-forward "${PG_CLUSTER_PRIMARY_POD}" --address 127.0.108.1 5432:5432

kubectl get secrets -n dbs pg-pguser-sapian -o go-template='{{.data.uri | base64decode}}'

psql postgresql://sapian:CHANGME@127.0.108.1:5432

DROP DATABASE zammad;

CREATE DATABASE zammad ENCODING 'UTF8' owner='zammad';