Hi I m trying to connect the Prefect Server Helm Chart to an

Question

Hi I m trying to connect the Prefect Server Helm Chart to an existing postgres database I ve configured the username and password fields inside the values file However my pods fail to start with this error `Error secret prefect server postgresql not found` I thought this secret would be created automatically Am I supposed to create it manually and if so how

Ryan Sattler · Answer

The comments in the yaml imply that this should be created automatically ``` This is the password for `postgresqlUsername` and will be set within the secret at the key `postgresql password````

Ryan Sattler · Answer

I did create something manually using `kubectl create secret generic prefect server postgresql from literal=postgresql password=mypassword` and that got a bit further though the auth is failing investigating why

Kevin Kho · Answer

I think <https prefect community slack com archives C014Z8DPDSR p1636472271337800 thread ts=1636470024 336600 amp cid=C014Z8DPDSR|this> thread may be relevant here Have you seen it

Ryan Sattler · Answer

I saw that which inspired the above fix but IMO this really ought to be created automatically or else what purpose does the password field in the yaml even serve

Ryan Sattler · Answer

or if not the comments could be improved to make it clear what needs to be done

Anna Geller · Answer

< Ryan Sattler> did you see this answer perhaps just the format of the secret is wrong

Ryan Sattler · Answer

Yes Anna that s what I did and it worked but if that s what s needed then the comments in the yaml file should make that clear instead of implying that this secret will be created automatically

Anna Geller · Answer

< Ryan Sattler> can you confirm that this is what would you expect to see in the docs ``` 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 explicitly set to the name of a Kubernetes secret This secret must be a key value pair containing the key `postgresql password` e g kubectl create secret generic prefect postgresql pwd from literal= postgresql password=YOUR POSTGRES PWD Helm chart value existingSecret prefect postgresql pwd existingSecret null```

Ryan Sattler · Answer

thanks Anna looks mostly correct except that the name of the secret must be ` lt helm release name gt postgresql`

Ryan Sattler · Answer

also I think the field `postgresqlPassword` should be removed as it is not used as far as I can tell

Anna Geller · Answer

correct postgresqlPassword is currently commented out Are you sure that the secret name must have the helm release name within it ` lt helm release name gt postgresql` I understood as long as you reference the name it should work ```existingSecret prefect postgresql pwd```

Anna Geller · Answer

but thanks anyway

Ryan Sattler · Answer

oh true that should work