Riley Hun
11/25/2020, 6:10 PMpostgresql:
postgresqlDatabase: prefect
postgresqlUsername: postgres
postgresqlPassword: <PASSWORD>
servicePort: 5432
externalHostname: <IP_ADDRESS>
useSubChart: false
The error I'm getting:
secret "prefect-gke-3-postgresql" not found: CreateContainerConfigError
Zanie
existingSecret
anyway, could you give that a try?Riley Hun
11/25/2020, 6:53 PMZanie
existingSecret: null
only generates a secret for you if useSubChart: true
# existingSecret configures which secret should be referenced
# for access to the database. If null and `useSubChart` is
# enabled, the secret will be generated. If using an external
# postgres service, this value should be set to a secret
# containing the key `postgresql-password`
Riley Hun
11/25/2020, 8:20 PMkubectl create secret generic prefect-db-secrets --from-literal=postgresql-password=${DB_PASSWORD}
Config
postgresqlDatabase: prefect
postgresqlUsername: postgres
existingSecret: prefect-db-secrets
servicePort: 5432
externalHostname: 34.74.17.161
useSubChart: false
Note: I am using a private cloudsql instance, but my cluster is in the same VPC network.Zanie
kubectl describe pod <pod>
or kubectl logs <pod>
what are the errors?Riley Hun
11/25/2020, 8:41 PM{"type":"startup","timestamp":"2020-11-25T20:39:10.209+0000","level":"info","detail":{"kind":"server_configuration","info":{"live_query_options":{"batch_size":100,"refetch_delay":1},"transaction_isolation":"ISOLATION LEVEL READ COMMITTED","plan_cache_options":{"plan_cache_size":100},"enabled_log_types":["http-log","websocket-log","startup","webhook-log"],"server_host":"HostAny","enable_allowlist":false,"log_level":"info","auth_hook_mode":null,"use_prepared_statements":true,"unauth_role":null,"stringify_numeric_types":false,"enabled_apis":["metadata","graphql","config","pgdump"],"enable_telemetry":true,"enable_console":true,"auth_hook":null,"jwt_secret":null,"cors_config":{"allowed_origins":"*","disabled":false,"ws_read_cookie":null},"console_assets_dir":null,"admin_secret_set":false,"port":3000}}}
{"type":"startup","timestamp":"2020-11-25T20:39:10.209+0000","level":"info","detail":{"kind":"postgres_connection","info":{"retries":1,"database_url":"<postgresql://postgres@34.74.17.161:5432/prefect>"}}}
{"type":"pg-client","timestamp":"2020-11-25T20:39:42.035+0000","level":"warn","detail":{"message":"postgres connection failed, retrying(0)."}}
Zanie
Riley Hun
11/25/2020, 8:55 PMZanie
Riley Hun
11/25/2020, 9:33 PMZanie
externalHostname
Riley Hun
11/25/2020, 10:27 PMZanie
Riley Hun
11/25/2020, 10:38 PMexternal hostname
in the helm chart config.Zanie
Riley Hun
11/25/2020, 11:14 PMZanie
Riley Hun
11/25/2020, 11:19 PMZanie
# apolloApiUrl defines the default gateway to the Apollo
# GraphQL server. This location must be accessible by the
# user of the API because the browser is making requests
# (not the ui server)
apolloApiUrl: <http://localhost:4200/graphql>
Riley Hun
11/25/2020, 11:21 PMZanie
kubectl port-forward
to make the apollo api available at localhost:4200
Riley Hun
11/25/2020, 11:27 PMZanie
kubectl port-forward
or if the user can see the external ip of the service changing the graphql target url in the UI home screenRiley Hun
11/25/2020, 11:38 PMui:
image:
name: prefecthq/ui
tag: null
pullPolicy: IfNotPresent
pullSecrets: []
apolloApiUrl: http://<Internal_Load_Balancer_IP>:4200/graphql
Zanie
apolloApiUrl
is setting the default for each user of the UI but they can override it from the UI home screenRiley Hun
11/25/2020, 11:45 PMZanie
apolloApiUrl
default and the user wouldn’t have to do anything.Riley Hun
11/25/2020, 11:49 PMZanie
Riley Hun
11/25/2020, 11:51 PM