"The server requested SCRAM-based authentication" error

[juan]

Hi all

I'm not a DevOp but I want to get FusionAuth up & running as easy as possible, so I tried Digital Ocean one-click app. Also tried installing it in a stand alone server using the scripts.

In both cases when installation finishes and I go to the maintenance web site to finish config, it always replies with this error:

The user for the username you provided was either created or already existed but could not be granted access to the database. The error from the database was [The server requested SCRAM-based authentication, but no password was provided.].

Anyone had this problem before? I couldn't find anything related in this forum.

Thanks in advance.

[juan]

Hi everyone,

This issue has been resolved.

A DevOps engineer helped us identify and fix these small mistakes:

Single-node server:

The root user password for the PostgreSQL database was reset.
Both credentials (root and user) were provided in the maintenance configuration screen.
Additionally, the database user was incorrectly set to postgress instead of fusionauth—my mistake!

Digital Ocean one-click app instance (3 Kubernetes nodes):

The database host was populated incorrectly. In our case, changing it to db-postgresql solved the issue.
Similar to the single-node server, we also reset the root password and provided both credentials.

This could be helpful for future reference.

Thanks

[mark.robustelli]

@juan Thanks for sharing!