search

FusionAuth / fusionauth-issues

FusionAuth issue submission project
https://fusionauth.io
90 stars 12 forks source link

FusionAuth Kubernetes - Postgres, Pass the database connection string #2306

Open khandg opened 1 year ago

khandg commented 1 year ago

I have installed the fusionauth on DigitalOcean kubernetes via helm charts. Also wanted to connect via DigitalOcean managed Postgresql however, it keeps giving maintenance page. I have already verified that database is accessible from within the kube cluster, so connectivity issue is not there. Also verified that username & password i had input in values.xml are working fine. My only doubt is somehow the connecting string which is being formed by FusionAuth is not correct because DigitalOcean postgres requires sslmode=require as a parmeter to pass in the connection string. I have already bootstraped the database but still the maintenance page is there.

On the maintenance page iam getting this error:

The error from the database was [The server requested password-based authentication, but no password was provided by plugin null].

I am not supplying the super username and password and just supplying the fusionauth credentials.

image

I am thinking if i can somehow pass the connection string that could solve the problem

khandg commented 1 year ago

same issue with DigitalOcean mysql as well

johnmccalla commented 2 months ago

Same issues here. Did you ever figure it out @khandg?

khandg commented 2 months ago

Yes, its kind of hack as i ssh into the pod and then updated the fusion auth config with the DB string directly. Then i refreshed the installation page and it worked.

@johnmccalla

jobannon commented 2 months ago

Just a thought here - -could you set the DATABASE_URL or database.host in the helm chart to avoid the above scenario?