Request help on Keycloak operator : External Database configuration

[Sankha Sil]

Hallo Team, 

I request for help regarding keycloak operator configuration. I am trying to make a deployment of keycloak , with HA mode enabled. I want to use external data storage. 
I am sharing my yamls used.

Keycloak-idm

apiVersion: keycloak.org/v1alpha1

kind: Keycloak

metadata:

name: kiwigrid-keycloak-idm

spec:

instances: 3

externalAccess:

enabled: false

externalDatabase:

enabled: true

external storage secret

apiVersion: v1

kind: Secret

metadata:

name: keycloak-db-secret

namespace: kiwios-application

type: Opaque

stringData:

POSTGRES_DATABASE: keycloak-storage

POSTGRES_EXTERNAL_ADDRESS: plsqlproxy

POSTGRES_EXTERNAL_PORT: "5432"

POSTGRES_HOST: keycloak-postgresql

POSTGRES_USERNAME: keycloak-user

POSTGRES_PASSWORD: S1ly3AValJYBNR-fsptLYdT74

POSTGRES_SUPERUSER: "true"

Storage-database

apiVersion: sql.cnrm.cloud.google.com/v1beta1

kind: SQLDatabase

metadata:

name: keycloak-storage

namespace: kiwios-application

annotations:

cnrm.cloud.google.com/deletion-policy: "abandon"

spec:

charset: UTF8

collation: en_US.UTF8

instanceRef:

name: keycloak-storage-instance-pg

namespace: infra

storage users

apiVersion: sql.cnrm.cloud.google.com/v1beta1

kind: SQLUser

metadata:

name: keycloak-user

namespace: kiwios-application

annotations:

cnrm.cloud.google.com/deletion-policy: "abandon"

spec:

instanceRef:

name: keycloak-storage-instance-pg

namespace: infra

password:

valueFrom:

secretKeyRef:

name: keycloak-db-secret

key: POSTGRES_PASSWORD

Since I am using google cloudsql, the instance is already available. 

In Kubernetes cluster it is failing to start keycloak since it fails to connect to the database. 

The error below:

would you please help me. Also let me know if you need any further information.

Regards

Sankha

Kiwigrid Gmbh