Error Deploying Temporal Pod with abctl

Slack Knowledge Base Q&A API, Terraform and Other Topics
, , , ,
1

Summary

User encounters an error while deploying the temporal pod using abctl, indicating SSL is not enabled on the PostgreSQL server. The issue arises during the connection to the external Cloud SQL PostgreSQL database.


Question

Hello :wave:
I am currently using Airbyte with docker-compose on GCP Compute Engine VM, with Airbyte version 0.63.20 (displayed as 0.63.13 in Airbyte UI), using an external database on GCP Cloud SQL PostgreSQL in PG version 13, reached via the Cloud SQL Proxy.

I would like to migrate to abctl and run below commands:

abctl local install --values=values.yaml --secret=secrets.yaml --chart-version=1.0.0 ```
but it fails on deploying `temporal` pod with below extract warning message:
```2024-10-02T10:40:41.358Z      ERROR   Unable to create SQL database.  {"error": "unable to connect to DB, tried default DB names: postgres,defaultdb, errors: [pq: SSL is not enabled on the server pq: SSL is not enabled on the server]", "logging-call-at": "handler.go:94"}
2024/10/02 10:40:41 Loading config; env=docker,zone=,configDir=config
2024/10/02 10:40:41 Loading config files=[config/docker.yaml]
...
{"level":"warn","ts":"2024-10-02T10:40:41.388Z","msg":"Not using any authorizer and flag `--allow-no-auth` not detected. Future versions will require using the flag `--allow-no-auth` if you do not want to set an authorizer.","logging-call-at":"main.go:178"}
...
[Fx] RUN      provide: go.temporal.io/server/temporal.ServerOptionsProvider()
          [Fx] Error returned: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider
                /home/builder/temporal/temporal/fx.go:180:
          sql schema version compatibility check failed: pq: SSL is not enabled on the server
          [Fx] ERROR            Failed to initialize custom logger: could not build arguments for function "go.uber.org/fx".(*module).constructCustomLogger.func2
                /go/pkg/mod/go.uber.org/fx@v1.20.0/module.go:251:
          failed to build fxevent.Logger:
          could not build arguments for function "go.temporal.io/server/temporal".init.func8
                /home/builder/temporal/temporal/fx.go:1029:
          failed to build log.Logger:
          received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider
                /home/builder/temporal/temporal/fx.go:180:
          sql schema version compatibility check failed: pq: SSL is not enabled on the server
          Unable to create server. Error: could not build arguments for function "go.uber.org/fx".(*module).constructCustomLogger.func2 (/go/pkg/mod/go.uber.org/fx@v1.20.0/module.go:251): failed to build fxevent.Logger: could not build arguments for function "go.temporal.io/server/temporal".init.func8 (/home/builder/temporal/temporal/fx.go:1029): failed to build log.Logger: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider (/home/builder/temporal/temporal/fx.go:180): sql schema version compatibility check failed: pq: SSL is not enabled on the server.```
Do you have any idea how to solve it ? :pray:
Thanks a lot :slightly_smiling_face:

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1727866852503529) if you want
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
['docker-compose', 'gcp', 'cloud-sql', 'postgresql', 'abctl', 'temporal', 'ssl-error']
</sub>